Unit 4: Testing and Automation

FMR provides a comprehensive user interface for creating, maintaining, testing, and executing data recoding tasks. In a production environment it is preferable to automate these tasks to the extent possible and embed them in production workflows.

Why testing matters

Regardless of the technology and approach used, recoding of data can be very powerful. In parallel, recoding of data using complex methods and regular expressions can also be complicated, requiring thorough testing to ensure that all the possible scenarios have been accounted for and the results are as expected.

Testing and automation with FMR

The FMR user interface has a feature to support the testing of mappings whereby the user selects the structure map to be tested and an input dataset to use for the test and then FMR produces a detailed report on the results of the transformation.

Select the FMR user interface to enlarge.

Select the FMR mapping output to enlarge.

Testing and automation with web services: Example use cases

Web services may also be used to automate recoding (transformation) and can be directed to provide details on the results of the transformation request to assist with validation and testing.

Select each example use case for the details.

Example 1: POSTMAN & XML
The same validation test previously shown using the FMR user interface can also be undertaken using the FMR data transformation web service and the POSTMAN application, in this case using an XML data format.

Select the example to enlarge.

Select the RESULTS from POSTMAN POST request to the transformation web service to enlarge.

Example 2: CURL & XML
The same POSTMAN FMR transformation web service call in Example 1 can also be executed using CURL (or another similar tool).

Select the example to enlarge.

Example 3: POSTMAN & CSV
Note that the DATA for the previous request in Example 2 was in SDMX-ML format although this could just as easily have been demonstrated using any other SDMX format, such as CSV.

Select the example to enlarge.

Example 4: CURL & CSV
The same POSTMAN FMR transformation web service call in Example 3 with data in CSV format using CURL (or another similar tool).

Select the example to enlarge.

What do you know?

You have now completed Recoding: Transforming Data into Different Structures, but before moving on to the module summary, try this final question.

Which of the following statements are TRUE?

Select all that apply and then select Submit.

AI assistant

Need help finding something? I am an AI Assistant that’s here to help!

Welcome to SDMX AI assistant

What are you looking for?

SDMX AI assistant

By using this AI-powered service (“Service”), you acknowledge and agree to the following:

This Service uses generative AI to assist with statistical analysis and research . While the Service strives to deliver useful information, the output (“Output”) may contain inaccuracies, omissions, or biases. The Output is provided for informational purposes only and should not be considered professional advice. You remain responsible for how you interpret and use the Output.

The BIS makes no warranties regarding the accuracy or completeness of the Output and accepts no liability for any loss or damage resulting from its use.

Do not include or share personal, private, confidential or proprietary information when using the Service.

By using this technology, you agree to the Terms and Conditions.

How the assistant can help you

Understand SDMX standards

Ask and get clear explanations about SDMX standards.

Navigate the website

Find tools and documentation on website quickly.

Explore SDMX tools

Ask about API, software and libraries supporting SDMX.

Access documentation

Locate technical guides, specifications, and FAQs.

LLMs can make mistakes, please verify important information.

Why was the answer unhelpful?