Tabular data editing

IUCLID entity management

The perspective “IUCLID entity management” allows to browse the connected IUCLID instance and to display its main entity types in the IIP interface, optimized for data input.

The current version of the IIP supports the entry of data into IUCLID tables. The user can select and copy a range in a worksheet (e.g. in Excel) into the clipboard and then paste the data into a table in the IIP.. The table display in the IIP supports cell selection, copy and pasting and navigation with the keyboard, similar as in Excel. This allows the user to quickly and efficiently fill tabular data, without the need of filling each cell individually as in the IUCLID interface.

Below, you find a screenshot of the IIP, with a document display on the right side with one table with 4 lines. The table is editable, meaning that each cell can be the target of a paste operation. The other information in fields outside of tables is displayed read-only in the current IIP version. Future versions may introduce data entry capabilities also for those fields.

The table used to produce the above entries is listed below:

GAP Use 1parent Tier 1MACROChateaudunca. 12 μg/L
GAP Use 2metabolite Tier 2pearlHamburg< 14 μg/L
GAP Use 3parent Tier 3PelmoPorto<=20 μg/L
GAP Use 4metabolite Tier 4other: TormoSevilla>= 8 μg/L

Upon pasting into a table cell, the IIP will automatically add new lines if needed and verify, that the pasted data can be correctly matched to the document definition as retrieved from IUCLID, for example:

  • For Picklists, the value must match one decode value of the respective IUCLID picklist. Upper and lowercase are ignored.
  • Ranges can be supplied in one cell, meaning that upper and lower qualifier, number and unit can be supplied in one cell string. The IIP will parse the string and assign it correctly to the respective structure in IUCLID.
  • Reference fields are resolved by searching the target entity in IUCLID with the given search string and replacing it with a true reference, consisting of the UUID of the target entity

Below you seen an example of the same table as in the user interface above, but with a couple of pasted values tha could not be validated and hence the data cannot be saved.

All data types are validated prior to saving the values to IUCLID itself and errors are indicated as above. This allows the user to quickly correct the data, e.g. by repasting corrected values.

A couple of things for clarification of the current functionality and its limits:

  • Of course it is not possible to paste into cells designated for the upload of attachments. The current version does not support attachment upload in tabular data.
  • Cells of type data protection are disabled in this version and have to be edited in IUCLID.
  • Nested tables (tables in tables) are currently not supported (e.g. as in OHT 85-5 ENDPOINT_STUDY_RECORD.ResiduesInRotationalCrops)
  • The display of text fields is abbreviated and the display of Richtext fields (with HTML formatting) is not correctly displayed. This is not critical, as the fields are read-only in the current version.
  • As we trim all our paste values, please make sure, that the names in IUCLID do not have a trailing space, otherwise we will not find a match.
  • Take care with strings with special characters like “μg/L” or “mg/m²” – your CSV cell must exactly match those. Surprisingly, there are (at least) two different character codes for the “μ” sign, the correct one to use is U+03BC. You are on the safe side if you simply copy the respective character from the IUCLID interface for those few characters.
  • Please note that the cells in the tables in the IIP interface support pasting, but not direct editing and cell-wise deletion. To change or delete a cell also use a paste operation, e.g. pasting an empty cell. Complete lines can be deleted and added as in IUCLID with the button at the end of the line.

As long as the pasted information cannot be correctly validated, the save button (upper right corner) remains inactive. This prevents to provoke errors in IUCLID.

After saving the document (upper right corner) the user can click on the UUID in the top bar to open the document in a separate browser tab in the native IUCLID interface, in order to verify the entry and to complete the remaining information.