Collapse AllExpand All

12.5. Export Data

Use the Export Data window to export data from the xTuple ERP database into XML files.

Export Data screen

When you open the Export Data window, you are presented with the following options:

Destination Format

You can choose to export the data either in the default xTuple format or transform that xTuple format using XSLT.

xTuple XML

Choosing this option will export the data in the default xTuple format. The XML element names in the output file follow the query names and columns in the query set selected.

Alternate XML

This option lets you choose an XSLT transformation from the list of XSLT export filters defined on the Section 13.1.4, “Configure Import and Export” screen.

Query Set

A Query Set is a collection of database queries that are run in sequence. The Query Set you choose defines the data that will be exported. See Section 12.5.1, “Query Sets and the QuerySet widget” for details.

[ MetaSQL parameter list ]

Once you select a Query Set from the list, the third table on the screen shows the list of MetaSQL parameters used by that Query Set. You can edit individual parameters to make them active and give them particular values that will be used to control the execution of the individual queries in the Query Set. See Section 12.5.2, “MetaSQL Parameter Editor” for details.

The following buttons are unique to this screen:

Export

Run the database queries in the Query Set to create the XML file.

List

Edit the value of MetaSQL parameters which have the Type QVariantList.