Importing Customers Using Files

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 “Customer Category” in a customer record, the customer’s language, currency, and country are automatically assigned, if not provided.

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 customer template used to manage the import of basic customer data, addresses, contacts, and bank information is “BPC” (Business Partner - Customer). You’ll find the template and demonstration data in X3’s “SEED” folder.

Download the sample customer data file

The sample customer data file contains records for several customers. You can open the file with a text editor and compare the data across customers.

To import the data in X3:

1. Go to Usage > Imports/Exports > Imports.
2. In the dialog box, enter BPC 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.