Data Uploader

The Data Uploader application is developed as a KNIME Analytics Platform plug-in comprising of several workflow nodes. Its aim is to allow easy data mapping and import of non-IUCLID data into IUCLID in a controlled way, supporting all IUCLID data sections.

The Data Uploader supports the transformation of data on chemicals to the IUCLID format. It is especially useful for conversion of legacy toxicity data into harmonised templates which can be stored in a IUCLID database. This tool can be used by owners of chemical databases who would like to share their information in an internationally recognised format. The application is developed as a KNIME Analytics Platform plug-in, comprising of several workflow nodes.

The main Data Uploader workflow consists of 6 tailor-made KNIME nodes:

Data Uploader Workflow

 

  • Connection to a IUCLID database
  • Selection of relevant IUCLID documents and fields
  • Mapping with an external data source
  • Validation of the data against the IUCLID format
  • Generation of IUCLID files (.i6z)
  • Upload to IUCLID

 

 

 

The Data Uploader workflow with the Incremental update node supports a stepwise approach. With the stepwise approach the user is able to upload a set of simple entities, e.g. Reference Substance, Legal entity, Literature, that can be used later as references in SUBSTANCE or TEMPLATE documents. This reduces the complexity of the KNIME workflows to transform the data and improves the overall user experience.

Data Uploader Knime plug-in (28th November 2022 - v1.1 - compatible with IUCLID 6.6)

You can now download v.1.1 of the Data Uploader. The installation package contains the following:

  • The installation instructions
  • The Data Uploader KNIME plug-in
  • An introductory use case for creating reference substance documents in IUCLID, guiding the user through the Data Uploader workflow and data preparation process, and explaining the configuration of the Data Uploader nodes. The provided material includes the starting data set and two KNIME workflows, one for the data preparation and one for the data upload into IUCLID.
  • A more advanced use case for creating substance datasets that contain endpoint study records. This use case also explains the stepwise approach to upload data. The provided material includes the starting data set and six KNIME workflows that are described in the accompanying documentation.

If you have questions about the Data Uploader, or suggestions on how to improve it, please fill in the contact form on the ECHA Website here. Under Request type, select Data Uploader.

Version Compatibility Improvements
1.1

KNIME 4.6
IUCLID 6.6

 - Upgrade to KNIME 4.6
- Alignment with trusted community nodes
- Simplified installation
- Automatic selection of required fields (DocumentSelection node)
1.0

KNIME 4.2.2
IUCLID 6.6

 - First released version

 

 

 

 

 

 

Please sign in to download files