File-based importing and exporting is a proven method for transferring data between X3 and other applications or data sources. It is well suited to processing large amounts of data, and the process can be automated through user-defined time scheduling of batch jobs.
Should you need to integrate on a real-time basis, take a look at the web service example of exporting.
Data is exported via templates which specify the fields exposed for exporting, as well as the data file type, the field and record separators, and the record types used in the destination file. Templates are also used to define fields that can be used as criteria to filter exported data.
File Export Example
The product template used to manage the export of basic product data is “ITM” (Item).
You’ll find the template and demonstration data in X3’s “SEED” folder.
To export the data in X3:
- Go to Usage > Imports / Exports > Exports.
- In the dialog box, enter
ITMas the name of the template.
- Under Location, select the Client radio button then click OK.
- The Range grid can be used to select records based on the product field.
- Click OK.
- In the dialog box, select the Save File radio button and click OK.
- In the file dialog box, navigate to a location where you want to save the data, and name the file.
A log displays the results of the export. Make note of the log number to access it later at Reports > Reports > Log reading.
Note: If you wish to export the same records more than once, you will need to uncheck the Chromo management option. For many tables, X3 tracks which records have been exported, and this option can prevent re-exporting records that have not changed.
To find out how you can build your own export templates, and take advantage of more functionality, see the Import/Export Guide.