0 Replies Latest reply on Jul 1, 2021 6:50 PM by 1327392

    A new approach to tabular reports (with example annotations report)

    1327392 New User
      Hello Everyone  
      In this post I'd like to announce the publication of a brand new type of report template for the IUCLID report generator. In addition to
      being a standalone annotations report (tabulates annotations found in a dataset or dossier) this report outlines a reusable approach to
      generating regular / tabular report types (list reports). The report was developed as an in-house collaboration at ECHA and is currently at a prototype stage.

      The report includes innovations which allow tackling entirely new use cases and a higher level of customisability while remaining general and reusable. In
      practice the new report type ensures information about substances and mixtures is easier to access and more of it is available. The finer grained access to the
      IUCLID navigation tree and regulatory working context found within is made possible by updates to the IUCLID reporting engine. For example the generation
      of reports whose output reflects the per substance regulatory working context is now possible.


      The report borrows from the annotations report distributed with the current version of IUCLID (5.15) and builds on it. It outputs word processor compatible
      `rtf` files and machine readable `csv` files.


      The new approach is modular (see the table below) and extensible, meaning that it can easily be adapted to new reports which target tabular outputs. More similar list reports for

      common use cases are in development and will be made available soon.


      PurposeDescriptionSource `ftl`
      traversal of navigation treeextracts annotation documents`30_traversal.ftl`
      transformationwrangles and maps data into a tabular format`00_main_annotations.ftl`
      representationformats data into a human/machine readable format`40_layout_{rtf,csv}.ftl`


      The complete report source code (`ftl` files) can be found in a git repository on GitHub.
      The files can be fetched by cloning/downloading the repository to a local folder (see here for instructions). The report templates can be enabled for use
      by uploading them in IUCLID from the Report Manager view (see section 21.1 of the IUCLID functionalities manual).

      For questions or comments we'd be happy to reply in this thread.




      Message was edited by: Oscar Silva