Using XSLT for alternative XML formatting

[Q&A] Developer Tools
2

Hi Mila,

In short the steps to add an XSLT to change the formatting of your export are as follows:

  1. Open the export definition
  2. In the settings of the export definition set the option XSLT-transformation to ‘Yes’, a field will be shown where you can upload the XSLT file you want to use to change the export output.
    image

To create the XSLT you can do the following:

  1. Open your preferred application to create XSLTs. For the creation of XSLT I normally use Notepad++ including the XML tools plugin because it gives you the possibility to test with the XSLT you create.
  2. Export the exportdefinition without the ‘XSLT-transformation’ option set to ‘Yes’ and save this file, you will use this for testing. The output will be the standard Novulo Export and look similar to this.
    image
    image936×351 65.1 KB
  3. Collect the target XML you want to create
  4. Create the .XSLT to change the Novulo Export into the desired target XML.
  5. In Notepad++ you can test your XSLT by (1) opening the Novulo Export you saved, (2) clicking on XSL transformation in the plugins>XML tools menu (3) selecting the XSLT you created and (4) clicking on Transform:
    image
    image822×434 44.2 KB
  6. One good source for information about the creation/usage of XSLTs is ( XSLT Reference (w3schools.com).

To automate this integration you can use a scheduled task.

3 Likes