Screenshot:Import Loader Format

Back to Screens_Reference

Import Loader Format

Define the file layout for product information which will be imported.

Import Format

Create and edit import formats for specific database tables.

• Client : Client for this installation.
• Organization : Organizational entity within client
• Name : A non-unique identifier for a record/document often used as a search tool.
• Description : A space to write additional related information.
• Active : A flag indicating whether this record is available for use or de-activated.
• Table : A dictionary table used for this tab that points to the database table.
• Format : Format of the data
• Copy Lines : Copy Lines from other Import Format
• Import Format

Field Format

Define individual fields and the required format of the import file.

• Format Field
• Client : Client for this installation.
• Organization : Organizational entity within client
• Import Format
• Sequence Number : The order of records in a specified document.
• Name : A non-unique identifier for a record/document often used as a search tool.
• Active : A flag indicating whether this record is available for use or de-activated.
• Column : A link to the database column of the table.
• Data Type : Type of data
• Data Format : Format String in Java Notation, e.g. ddMMyy
• Starting No. : The first number that will be used in a standard or control sequence.
• End No
• Decimal Point : Decimal Point in the data file
• Divide by 100 : Divide number by 100 to get correct amount
• Constant Value : Constant value
• Callout Function : A series of actions that occur when data is modified.
• Script : A code used to create or modify the database or the database data.

Back to Screens_Reference