Adding Import Formats

You work with import formats on the Import Format screen, which consists of three sections:

• Import Format Summary—Displays common information relevant to the source and target applications.

• Import Format Detail—Enables you to add and maintain import format information.

• Import Format Mappings—Enables you to add and maintain import format mapping information.

To add an import format for a file-based data load system:

1. On the Setup tab, under Integration Setup, select Import Format.

2. In the Import Format summary task bar, select Add.

   In the upper grid of the Import Formats screen, a row is added.

3. In Name, enter a user-defined identifier for the import format.

   You cannot modify the value in this field after a mapping has been created for this import format.

4. In Description, enter a description of the import format.

5. In Source, select File for the source system.

6. From File Type, select the format of the file.

   • Fixed - Numeric Data

     See Defining Import Formats for File-Based Mappings.

   • Delimited - Numeric Data

     See Defining Import Formats for File-Based Mappings.

   • Multi Column - Numeric Data

     See Loading Multi-Column Numeric Data.

   • Delimited Data - All Data Type

     See Setting the Import Format Data Types.

   • Fixed Data - All Data Type

     See Setting the Import Format Data Types.

   • Multi Column - All Data Type

7. If the file type is "delimited," in the File Delimiter field, select a type of delimiter.

   Available delimiter symbols:

   • comma (,)

   • exclamation (!)

   • semicolon (;)

   • colon (:)

   • pipe (|)

   • tab

   • tilde (~)

8. In Target, select the target system.

9. In Drill URL, enter the URL used for the drill-through.

   To display the Drill URL editor, click .

10. In the Mapping section, map any dimensions.

11. Click Save.

    To define import formats for file-based mappings, see Defining Import Formats for File-Based Mappings.