Summary

In this module, we explored the end-to-end process of automating reporting templates using FMR REST API. In conclusion:

By following the steps outlined in this course, you can create detailed reporting templates using FMR's web services, facilitating efficient and accurate data collection from Data Providers.
Once created, the templates can be massaged using web services at various stages of the data collection/reporting process by both the data requesting agency as well as the data reporting agency.
These metadata driven Excel Forms enable Data Providers to easily report data and make a positive contribution to improving data quality.
For further assistance and advanced configurations, consult sdmx.io, the FMR Knowledge Base, or reach out to the community using the SDMX User Forum.

Code Examples

The following references provide examples of code snippets we have covered in this module:

Video 1: FMR reporting template security: Directory services and role assignment
To access the code presented in this video, click here
Video 2: FMR reporting template security: worksheet passwords
To access the code presented in this video, click here
Video 3: List reporting templates
To access the code presented in this video, click here
Video 4: How to generate an XLSX workbook
To access the code presented in this video, click here

The following references provide more details on some of the topics covered in this module:

For details on the necessary SDMX structures and on generating the template, refer to the FMR Knowledge Base: https://fmrwiki.sdmxcloud.org/Create_an_Excel_Reporting_Template
For detailed information on security configurations, see: https://fmrwiki.sdmxcloud.org/Security_Configuration
For more information on these web services, refer to the FMR Knowledge Base: https://fmrwiki.sdmxcloud.org/Data_Reporting_Template_Web_Services
Sdmx.io course Validating and Transforming Data
Sdmx.io course Data Collection with XLSX Templates
Sdmx.io course Automating Structural Validation Using the FMR REST API