Identify interface files and CSV files

Identify the Infor interface database files and comma separated value (CSV) files that are used to transfer your data. A CSV file is used to save data in a table structured format using commas or other delimiter characters. When you load a source file to an interface database file, its format is defined by the Infor database. When you load a source file to a CSV file, the format is different than data in the Infor databases until the interface program is run.

Use these resources to determine how to identify and map your data:

Resource Description
Identify the database files and CSV files See each solution chapter in this guide for a list of interface database files and CSV files.
Table Definitions Each interface file has a related table in Table Definitions. The Table Definitions documents contain the fields in the Infor solution. They provide information about each field, such as its length and format and whether the field is required for the interface. This is your primary source of data mapping information. Use the table definitions to create a CSV file.

Table Definitions are located on the Product Download page on https://customerportal.infor.com.

Note: Required fields are identified in the user interface by an asterisk.
File descriptions
  • Export database file descriptions using the viewdict utility.
  • Export a CSV file definition using the dbexport utility.
Import CSV file data Use the dbimport utility to import a CSV file into an Infor database table.

You can also import CSV file data using the Import to Database option in Administration Console.
Interface programs that read a CSV file For interface programs that read a CSV file directly, see each solution chapter in this guide. Information in each chapter helps you determine the correct location for the interface CSV file.

For information about utilities, see the Landmark Technology documentation.