IUCLID

The Report Generator allows you to customise and manage your own report templates and to use these with the Report Generator to extract data from IUCLID’s datasets and dossiers. The IUCLID team can help you to create your own report templates, and provide the necessary technical and business support. Use the IUCLID functional mailbox to contact us with any such request.

Typically, we recommend the creation of customised report templates when:

• There is a set of structured IUCLID data which you repeatedly have to use in your business processes, such as study summary data, use information, or composition data.
• You want to regularly send IUCLID data in a readable format to other organisations.
• There is another IT system which you feed IUCLID data in to and which you wish to have ready in machine-readable format, such as XML or CSV.

There are basic instructions available to create customised reports together with a few examples:

• DocBook report template example (.ftl) including a test .i6z
  • This is applicable for any Substance, Mixture, Category or Article entity and any related Working Context, although the example is more relevant for users generating from Substances or Mixtures;
  • You can upload the supplied .ftls into the IUCLID Report Manager, see the screenshot here.
• XML report template example (.ftl), to be used with this IUCLID 6 dataset (.i6z)

When creating your own report templates, you can also upload your own stylesheet (.xsl) file into the Report Generator which adds extra formatting conditions to the .rtf output. Here are two stylesheets which you can use as a basis for creating your own stylesheets:

• Default IUCLID stylesheet (.xsl) used with the CSR report
• Two modified stylesheets (landscape and portrait in .xsl) which converts an RTF or PDF document into a landscape or portrait format accordingly, as well as permitting different text colours and table cell colours.

Sharing your report templates

If you wish to share the templates you have customised and potentially have these published on the IUCLID 6 website, please contact ECHA through the IUCLID functional mailbox.

From IUCLID 6.5 onwards, a set of common modules can be easily re-used to create an assessment report. The modules are kept up-to-date with the latest IUCLID format. The modules encompass the major robust summary studies and endpoint summaries from IUCLID, as well as classification and labelling information, physical-chemical summaries, and chemical structure identity and composition.

Here is a short video on how the modular approach works. The video gives an overview of the steps to include, as an example, the module for environmental hazard assessment and the study information on aquatic algae in a main report template.

The modules are currently available in GitHub (go to the OECD Customisation forum for information on the governance of the modules and where to access them)

The available modules have been mapped to the current Chemical Safety Report (REACH) to help you understand the layout and presentation of the different studies and summaries. The mapping is ordered by CSR chapter, and each one can be expanded and collapsed. You can find the mapping here.

An example report template of how to use the common modules can be found here. The example can be generated from a Substance or Mixture entity, and has a different output depending on which entity you generate from and what data you have available in the IUCLID you use to generate the report, see the table of contents below. To upload the reports, see the above section on 'Uploading your own reports'. The main report template is named 'main_report_template_modular.ftl'