Schema  > Products  > SRTransport  > Documentation  > Modules  > XML
 

The XML Module

The XML module can read structured data from an XML file and present it as rows that can be inserted into a database. The module can only be used as a source. It is BETA and has some limitations in its functionality.

 

At the top of the module window are an icon indicating that this is the XML module, the name of the XML document and it's location, the 'Options' pop-up menu and an icon well.

You can drag an XML document from a browser window into the well. If you double click in an icon in the well, SRTrasport will ask the default browser to open the document.

Options menu

Data Paths

The 'Parse Data Paths' button will parse a document for its structure. Once you click on this button the data elements of the document will appear in the "Data Path" pop-up menu. When you select an item from the menu the fields and their data types will appear in the table to the right. This is how the data will be made available in SRTransport expressions. You may need to convert the data type using the 4gl convert() function.

Generating XML

When the XML document is a destination this allows you to specify the format of the output file. You can specify how the tags will be written. You can supply a header. You can indent the output to make it more readable.