Data editor tools

  • Posted:
  • / By: cremeadm
  • / In: Data Editor

The Data editor tools become available when you open a table. To open a table, move with the mouse on its name and left-click on it.

The tools are grouped in the following way:

  • Icon toolbar on the top left corner just below the table name, with the following functionalities:
    • Undo icons
    • Redo
    • Filter
    • Select all / Deselect all; these two options are available only for the Food table
  • Validate Data button on the top right corner, right below the main menu
  • Main menu on the very top right corner which contains:
    • File
    • Edit
    • View
    • Insert

All these tools are described here under.

Icon toolbar

The icon toolbar gives you the ability to

  • Undo & Redo a modification in the table
  • Apply filters to the table columns
  • Sort the data stored in the table
Undo & Redo

The undo and redo icons are active only if any changes have been applied to the table since the moment the table was opened. They allow you to easily amend mistakes or unwanted changes by reverting back or moving forward among the sequential versions of the table.

Filter

The Filter icon gives you the ability to apply filters to all the columns of the table and select the subset of data you are interested in.

Click on filter; a grey bar opens above the table with a drop-down input field.new filter 1

Click on the input field; a dropdown list shows the columns included in the table. new filter 2

Select the column to be filtered. Other two input fields appear on the right side of the first input field. The first input field contains a drop-down list with the filtering operators that can be applied. The list of operators depends on the type of data recorded in the column to be filtered; they are:

  • The operators on texts are ‘Contains’, ‘Does Not Contain’, ‘Equals’, ‘Does not Equal’; the input field on right hand accepts any alphanumeric combination
  • The operators on numbers are >, >=, <,<=, =, !=; the input field on right hand will only accept a number
  • The operators for bool only contain ‘is’ (equals) and input field on right hand is a select of ‘True’ or ‘False’

new filter 3

Type in the input field on the right side the value in the column you are looking for; then click on filter button.
The input filter bar shrinks into a thinner blue bar, as shown in the image below, and the filtering input fields are concealed.
new filter 4
To reopen the filters and change them, click on filters applied
It is possible to apply the filters on more than one column. Click on add filter; a new input field, with the drop-down list of the table columns, appears underneath.
new filter 5
Repeat the above steps on all the columns you wish to filter.
Click on clear filter button to remove the filters. Click on filter to close the filter system.

Select all / Deselect all

These two icons are available only for the Food table and they allow to select/deselect all the rows that are filtered. Open a Food table and filter the foods you want to analyse by following the process described in the previous section. Click on select all to select all the foods you have previously filtered; all the check-boxes beside the food codes are checked. Click on deselect all to deselect all the foods that are filtered.

Validate Data

The validate data button button appears only in two cases:

  • The table is empty
  • The table contains wrong data that will cause the failure of the exposure assessment provided no amendments are carried out. Wrong data mean blank cells that are indispensable to complete the exposure assessment, alphabetic values in cells where numeric values are expected, etc.

When the validate data button button is displayed in the Data Editor, the table is not validated and it cannot be used in an exposure assessment. This is also stated in a tag that appears beside the table name, on the top left corner of the screen, as shown in the image below. The cells that contains wrong data are highlighted in

  • Yellow if they are blank
  • Red in case they contain not suitable data types

table to be validated 1

If you wish to have more information on the errors that prevent you from validating the table, click on validate data button. A red bar will appear just above the table with the number of errors detected by the validation process implemented in CARES NG®.
table to be validated 2

Click on show error to see the detailed list of the errors together with a brief description of the reason why the validation process considers them as such.
Click on table to be validated 3

If you click on the error you want to check, the Data Editor will automatically highlight the cell in the table where the error occurs. Otherwise, click on show error

Click take me to first to highlight the cell of the first error in the list.
table to be validated 4

Click on the tab claer tab which has appeared beside validate data button to remove the filters on the errors and revert back to the full-table visualization.

view in window opens a new tab with the same list of errors displayed at the top of the table to be validated.
table to be validated 5

The validation process continuously checks tables while modifications are being made; once all the errors are fixed, the table is automatically tagged as validated and the following things happen:

  • the tag validate tag disappears
  • validate data button disappears too
  • No more errors are displayed above the table

Main bar

The main bar consists of the light blue area positioned at the top of the Data Editor and contains

  • The name of the table on the left side
  • The number of rows, displayed on the right side of the table name
  • A list of dropdown menus:
    • File
    • Edit
    • View
    • Insert (except in the Food tables only)

The dropdown menus are described hereunder.

File

The File menu gives you the ability to perform the following actions on the table.

Copy

Enables to copy the table without closing it. The table copy is automatically stored in the same folder of the original table.
Click on Copy; you are presented with a popup window with an input text field, as shown in the image below.

copy table window

Type the name of the new table and press Confirm.

Copy Filtered

It works as Copy but the new table contains only the values selected with the filtering system. All the values that have been filtered out are discarded and not copied into the new table.

Move to Folder

It allows you to move the table into another folder without closing it.
Click on Move to Folder; you are presented with a popup window that allows you to browse through the File Manager System.

move table

Select the folder you want to move the table into by clicking on the folder name, then press Move.
You can also create a new folder where to move the table.

create new folder

Click on New Folder, right above the Move button. A new folder appears in the folder tree of the popup window. Type the name of the new folder in the text field then click on thick

Move to Trash

Select this option if you wish to delete the table.

Download

The table can be downloaded as a zipped csv file. Please refer to the section Download a file of the File actions page for more information.

Edit

The Edit menu gives you the ability to perform the following actions on the table.

Undo & Redo

Please refer to the Undo & Redo section of the Icon Toolbar section above

Cut, Copy, Paste and Clear

These options give the ability to cut, copy, paste and clear the value in the active cells of the table. It is possible to perform the same actions in two other ways:

  • By right-clicking on the active cell; a dropdown menu will be presented to you with all edit actions
  • By the following keyboard shortcuts:
    Cut: CTRL + X
    Copy: CTRL + C
    Paste: CTRL + V
    Clear: Delete

View

The View menu gives you the ability to perform the following actions on the table:

  • Select all and Deselect all; available only in the Food table
  • Filter
  • Sort Ascending
  • Sort Descending
  • Remove Sorting

Select the action you wish to perform on the table; then follow the same process described in the Icon Toolbar section. The two sorting options are not available in the Icon Toolbar; their functionality is described below.

Sort Ascending and Sort Descending

These options gives you the ability to sort the data stored in the table according to the values of a column.

  • Click on a cell of the column to be sorted
  • Click on sort ascending or sort descending
  • The data of the selected column are sorted in ascending/descending order

It is possible to sort the data also by right-clicking on a cell of the column itself and click on Sort Ascending or Sort Descending, as shown in the image below.
sort option

Insert

The Insert menu is not available for the Foods table because it is not possible to add new food codes into this table; the exposure assessment is not able to handle new food codes. However, it is possible to remove foods from the table without causing the failure of the exposure assessment.

The Insert menu gives you the ability to perform the following actions on the table:

  • Row Above: it inserts a row above the row of the active cell
  • Row Below: it inserts a row below the row of the active cell
  • Delete Row: it deletes the row of the active cell