IUCLID Integration Platform

The IUCLID Integration Platform (IIP) from CropLife Europe is a platform to supply additional data import services for a connected and running IUCLID instance, that the IUCLID web interface does not supply.

The core of the IIP is the display of arbitrary documents in its own interface, based on the document definition and document data retrieved from the connected IUCLID instance. The IIP is therefore not restricted to specific document types or fields, but will dynamically adapt to new document types as long as the supported syntax for data and definition stays the same.

Based on this core of dynamic document display, the IIP supports currently two main use cases:

CSV-import

Efficient upload of metadata and attachments for the following IUCLID entities:

  • Literature references (for GLP study reports and publications plus associated metadata)
  • Reference substance

As input, the IIP processes a CSV (Comma separated value) file of a predefined structure – that can for example be generated from Excel or an inhouse reporting tool – plus referenced attachments (like the PDF for study reports). This allows companies to prepare this CSV data from existing inhouse data / systems and then create or update a running IUCLID instance with this information in one batch, without having to manually enter the values in the IUCLID web interface field by field. This ensures better data quality and increases the efficiency of filling IUCLID.

The IIP version 1.0.0 was developed with IUCLID6 version 5.15 with the format published in 10/2020, and the resources bundled with this version support the format as published in October 2020.

Note: For the October 2021 release of IUCLID6 v6 there are changes in the definition of the literature references. Please download the latest resources from the download page to get a CSV template this IUCLID6 v6. Due to the format changes, you need to choose the correct template, dependent on what IUCLID version you connect to.

Please check the download page or contact us.

For more details, see the respective subpage about CSV-import.

Tabular data entry

The entry of tabular data in IUCLID is very time-consuming, as each cell has to be filled individually. With the IIP, the user can copy a table from a worksheet (e.g. Excel) into a real tabular display in one go via the Windows clipboard. Also ranges, individual lines and columns are possible.

For more details, see the respective subpage about tabular data entry

Getting started

IUCLID support

The version 1.0.0 of the IIP has been developed with IUCLID6 version 5.15.0 from spring 2021. As long as ECHA does not change the syntax on how document types are defined, the IIP will be able to cope with format changes in future versions. Please make sure to regularly check this site and the download page in this menu section for the latest release.

The IIP requires a live connection to a running IUCLID instance and communicates via the REST API (Application Programming Interface) provided by ECHA. Unfortunately, this API is not supported by ECHA for IUCLID instances in the ECHA cloud. Therefore, the IIS has to be used in conjunction with an on-premises installation of IUCLID.

Disclaimer

As with all software supplied by CropLife Europe, please note the License Agreement. Use at own risk!

Outlook

The IIP will serve as platform to support additional types of efficient import and data entry into IUCLID, further use cases have been collected. In addition, the IIP is also extensible to become a management console to show aggregated information about datasets. If you have a specific use case in mind, please let us know. Dependent on acceptance and feedback the eSEG group will decide upon future extensions.

As with other CropLife Europe tools, the source code can be requested on demand to collaborate to the development, provided that extensions are made available for the general public again. The CropLife Europe eSEG invites all parties to contribute to and maintain the IIP.