|
xTuple ERP Reference Guide |
|
|
xTuple ERP Reference Guide |
| 12.5. Export Data | ||
|---|---|---|
 | 12. Utilities |  |
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:
You can choose to export the data either in the default xTuple format or transform that xTuple format using XSLT.
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.
This option lets you choose an XSLT transformation from the list of XSLT export filters defined on the Section 13.1.4, “Import/Export” screen.
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.
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:
Run the database queries in the Query Set to create the XML file.
Edit the value of MetaSQL parameters which have the Type QVariantList.
| |  | |
| 12.4. Import Data |  | 12.5.1. Query Sets and the QuerySet widget |