|
Oracle Customer Hub (UCM) Master Data Management Reference > Configuring the List Import Function > Administering the List Import Function >
Working with Import Job Data Mapping
Before you import a new file, you must map the fields in the imported list to the fields in either the Contact or the Account business component. When you do this mapping, the values in the list fields are transferred into the correct fields in the record. There are two ways to create a new import mapping template:
Use the following task to create a new import mapping template. To create a new import mapping template
- Navigate to the Administration - Universal Customer Master screen, then the Import Mappings view.
- In the Import Mappings screen, query for an existing Import Mappings template, or click New to create a new one.
- Enter the Reference Name and Main Object (either the Account or Contact object) for this Import Mapping template.
- In the bottom view, click on the New button to create new Field Mapping.
- For each entry, click the Select button in the Field Name field.
The Import Mappings picklist appears listing the import object and the field in that object to which the data is mapped.
- Choose an entry, then click OK.
- Repeat steps Step 4 through Step 6 for each field you want to map to.
Use the following task to map the fields of an import job. To map fields for an import job
- After successfully creating an Import Job as outlined in Creating and Scheduling Import Jobs, click the Data Mapping tab.
- In the Data Mapping view, click Refresh Mapping.
The provided input file is read and the sample input data is displayed.
- For each entry, click in Input Field, then click the Select button.
The Import Mappings picklist appears listing the import object and the field in that object to which the data is mapped.
- Choose an entry and click OK.
- Repeat for each field that you want to map to.
|
