Data Validator uses import definitions to map imported CSV file data from existing column headers to the correct column headers for objects, properties, relationships, and relationship properties in the staging area. The import definition helps you specify that the template file is in CSV format and the mapping is of basic format. You can use the sample input file in CSV format to generate column headers.
-
Click Data Validator Administration > Import Mapping.
-
Click Create Import Definition
.
-
In the Create New Import Definition dialog box, type a name and description for the import definition. You can name it ImportDef-Tag with a description of Import Definition to load custom tags.
-
Select CSV as the Template File.
-
Click Browse to navigate to the PUMP_LIST.csv.
You can find the sample file on Smart Community. For more information, see Find sample data on Smart Community.
-
Select the character encoding to be used from the Character Encoding box. For example, ISO-8859-15.
-
Select the Enforce Column Order option to use the exact column order as the CSV file that is used for creating the import definition.
-
Select SPFTGT option from the Target System list.
-
Select the Auto Generate Export Mapping option to automatically generate the export mappings. This ensures that the column headers match the objects and properties found in the target system.
When the Auto Generate Export Mapping option is selected, the import definition maps the imported objects, classes, and
properties to the existing objects, classes, and properties in the target system.
For more information, see Create export mapping.
-
Select the Auto Generate Validation Rules option if you want to automatically generate the validation rules from the mapping set up in the target system.
-
Select Basic Format from the Mapping Format list.
-
Click Save. This creates ten column headers for each column heading available in the PUMP_LIST.csv file.
You must map the column headers available in the Column Headers pane to an object, property, or relationship in the target system.