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:
-
On the Setup tab, under Integration Setup, select Import Format.
-
In the Import Format summary task bar, select Add.
In the upper grid of the Import Formats screen, a row is added.
-
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.
-
In Description, enter a description of the import format.
-
In Source, select File for the source system.
-
From File Type, select the format of the file.
-
Fixed - Numeric Data
-
Delimited - Numeric Data
- Multi Column - Numeric Data
-
Delimited Data - All Data Type
-
Fixed Data - All Data Type
-
Multi Column - All Data Type
-
-
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 (~)
-
-
In Target, select the target system.
-
In Drill URL, enter the URL used for the drill-through.
To display the Drill URL editor, click .
-
In the Mapping section, map any dimensions.
-
Click Save.
To define import formats for file-based mappings, see Defining Import Formats for File-Based Mappings.