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
- 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:
All these tools are described here under.
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 and 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.
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 ; a grey bar opens above the table with a drop-down input field.
Click on the input field; a dropdown list shows the columns included in the table.
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’
Type in the input field on the right side the value in the column you are looking for; then click on .
The input filter bar shrinks into a thinner blue bar, as shown in the image below, and the filtering input fields are concealed.
To reopen the filters and change them, click on
It is possible to apply the filters on more than one column. Click on ; a new input field, with the drop-down list of the table columns, appears underneath.
Repeat the above steps on all the columns you wish to filter.
Click on to remove the filters. Click on 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 to select all the foods you have previously filtered; all the check-boxes beside the food codes are checked. Click on to deselect all the foods that are filtered.
The 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 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
If you wish to have more information on the errors that prevent you from validating the table, click on . A red bar will appear just above the table with the number of errors detected by the validation process implemented in CARES NG®.
Click on to see the detailed list of the errors together with a brief description of the reason why the validation process considers them as such.
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
Click to highlight the cell of the first error in the list.
Click on the tab which has appeared beside to remove the filters on the errors and revert back to the full-table visualization.
opens a new tab with the same list of errors displayed at the top of the table to be validated.
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 disappears
- disappears too
- No more errors are displayed above the table
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:
- Insert (except in the Food tables only)
The dropdown menus are described hereunder.
The File menu gives you the ability to perform the following actions on the table.
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.
Type the name of the new table and press Confirm.
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.
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.
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
Move to Trash
Select this option if you wish to delete the table.
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.
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
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
- 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 or
- 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.
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