Export XML Data

The XML data from a selected XML field of a record can be exported to a new transformed XML file. The transformation is done based on the Style-Sheet XML which is supplied through the table tbs_info in AdapLink configuration. A user can click on the Export XML button after selecting a XML field for a record in Table Browser.

See also

Configuring Stylesheet for more details about configuring stylesheets for a XML field in Table Editor.

Exporting Single Field

An export wizard will appear as shown below. Select the source XML from the two options, Single XML field or Current Batch. Select the type of export and then click Next to select the style of export for the selected export type.

Select the export style and set the output file location by clicking on Browse.

The export file can be set from the following browser window:

Click on the Finish to export the file at desired location.

Look at the success message if the file exported without any issues in the console.

Following is a part of transformed and exported file:

Exporting Current Batch

Select the source XML as Current Batch, find a suitable export type and click on Next to get a list of export styles associated with this export type.

Select the export style from the list of associated styles, set the export file name and click on the Finish to export the file.

Example 1. Transform and Export batch data into one excel sheet

Select the style-sheet which transforms and exports the batch data to single excel sheet.

Following is a part of exported excel sheet after the transformation:

Example 2. Transform and Export batch data into multiple sheets in excel

Select the style-sheet which transforms and exports the batch data to multiple excel sheets.

Following is a part of exported excel sheet after the transformation: