How to export sample data
Objective
The objective of this document is to explain how the Openbravo sample data is exported using the export.sample.data task.
Sample Data Dataset
The tables that will be exported when the export.sample.data task is run are included in the Client Definition dataset. You can read more about datasets in this link.
Note that the way the export.sample.data task currently works, the SQL Where Clause defined in the dataset tables of the Client Definition dataset will be ignored and replaced by a client filter.
Exporting the Sample Data
To export the sample data of a given client, this export.sample.data ant task, available from the Openbravo root folder must be run. It has the following parameters:
- client: The name of the client whose sample data will be exported
- module: The module where the sample.data will be exported. The exported sample data will be stored in the referencedata/sampledata/<clientName> folder relative to the module path. To export to the core sample data folder, 'org.openbravo' must be specified in the client parameter
- exportFormat (optional): Available starting from 3.0PR17Q1.. It is used to specify the export format of the sample data. Currently there are two available export formats: xml (the default one) and copy. The copy export format will be only available when exporting the sample data from a PostgreSQL database. Sample data exported with the copy format can only be imported in PostgreSQL databases. If the copy parameter is used in an Oracle environment, a warning message will be shown and the xml format will be used instead.
For instance, to export the sample data of the 'F&B International Group' client to core using the COPY format, the following command must be used:
ant export.sample.data -Dclient="F&B International Group" -Dmodule=org.openbravo -DexportFormat=copy
For a more detailed info: QA_How_To_Export_Sampledata_POS2