File-based importing and exporting is a proven method for transferring data between Enterprise Management 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.

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 Enterprise Management 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 template used to manage the import of sales order data is “SOH” (Sales Order - Header).

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

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

To import the data in Enterprise Management:

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.

---

Provide feedback