Setting up an import process

To import data, you start by setting up an exchange scheme, as described in Master data. Next, you go on by defining the details of the tables to be imported.

To begin, you must use the Table Relations (Import) (daxch0521m000) session to create the relationship at the table level between the LN tables and the ASCII files. You then create the relationship at the field level, by setting up the relations between logical ASCII file fields and LN table fields. To set up the relations, you can use the Field Relations (Import) (daxch0522m000) session.

Often, you must convert data from one system for use by another. In this case, you can use the Conversion Tables (daxch0105m000) and Conversions per Field (daxch0106m000) sessions to set up the conversions.

After you define the table relations, field relations, and conversions, you must run the Create Import Programs (daxch0227m000) session to compile an object that Exchange can use to run the import.

You then run the Import Data (Non-Regular) (daxch0223m000) session to test your import. When you are satisfied that everything is working, in the Import Data (on a Regular Basis) (daxch0224m000) session, you can set up imports to run as often as your business requires.

The Import module contains the following sessions:

  • Table Relations (Import) (daxch0521m000)
  • Field relations (import) (daxch0522m000)
  • Conversion Tables (daxch0105m000)
  • Conversions per Field (daxch0106m000)
  • Create Import Program (daxch0227m000)
  • Import Data (on a Regular Basis) (daxch0224m000)
  • Import Data (Non-Regular) (daxch0223m000)