Skip to content
Developerhome
Product homepage
X3

Importing Sales Orders Using Files

  Less than to read

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 importing.

Importing data leverages the very same business logic as the X3 UI (User Interface) to provide consistent validation and referential integrity across input methods. This common logic also provides default data. For example, when populating the order date, the delivery date is calculated for you.

Data is imported via templates which specify the fields exposed for importing, as well as the data file type, the field and record separators, and the record types used for the source data.

File Import Example

The sales order template used to manage the import of sales order data is “SOH” (Sales Order - Header).

You’ll find the template and demonstration data in X3’s “SEED” folder.

Download the sample sales order data file

The sample sales order data file contains records for several orders.

To import the data in X3:

  1. Go to Usage > Imports/Exports > Imports.
  2. In the dialog box, enter SOH as the name of the template.
  3. Under Location, select the Client radio button, then click OK.
  4. In the file dialog box, navigate to the location of the downloaded data file and select it.
  5. Once the file is uploaded, click OK to begin the import.

A log displays the results of the export. Make note of the log number to access it later at Reports > Reports > Log reading.

To find out more, and take control of more functionality, see the Import/Export Guide.