You import data from comma-separated values (CSV) files
into a mapping to relate associated data in two reference data sets.
Procedure
- Click the Mappings tab and select
the mapping you want to work with.
- Right-click the mapping and select Import....
The Import Mappings wizard opens. Alternatively,
you can double-click the mapping to open the mapping detail tab and
click Import.
- On the Choose Import File tab, browse
for a CSV file to import.
- Choose the separator used in the file. In most cases, CSV
files use commas to separate fields, but your file might use a different
character.
- Indicate the wanted date and date/time format.
- Click Next.
- On the Map File Columns tab, choose
the CSV column for each property in the set. The Code property must
be mapped.
- Click Next.
- On the Preview File tab, review the
mappings selected. Click the Errors Found tab,
if present, to review any errors found. Make any needed corrections
to the mapping at this time.
- Click Finish to begin importing
the data.
Note: Any values that were previously mapped
in the current mapping are not imported.