Adding code values and crosswalks to the reference data assets
You can import the code values and crosswalks in to the reference data assets using Reference 360. Add the reference data values to the reference data assets.
1To access the Administrator service, assign the Reference 360 Business Steward role to the user.
aIn Administrator, click Users.
bSelect the user name to assign the role.
cIn the Assigned User Groups and Roles section, enable the Reference 360 Business Steward role.
dClick Save.
2To import data into Reference 360, upload the CSV file with code values.
aIn Reference 360, from the Explore page, select the reference data to which you want to add the code values.
bClick the Import Values icon.
The Upload File page of the Import Values wizard appears.
cTo select a file to upload, drag a CSV source file, or click Browse and select the source file.
The first 10 rows of records appear in the preview section.
The following table lists the code values and the location:
3 After you select the file to import, the import process automatically maps the possible columns to the suitable target fields. You can either use the system suggested mapping or modify the mapping as required.
aOn the Map Fields page of the Import Values wizard, verify the system suggested mapping of fields.
bTo manually map any field, perform one of the following tasks:
▪ Drag a source column to a target field.
▪ Select a source column and a corresponding target field, and click Map Selected.
The import process maps the field accordingly.
cVerify the mapping of all fields and ensure that all the required fields are mapped.
dClick Next.
The Preview and Import File page appears.
4 After you map the fields, use the preview section to review and verify the mapping, and then import the data.
aOn the Preview and Import File page of the Import Values wizard, verify the mapping.
If the preview does not return desired results, you can go back to the Map Fields page to map the fields again.
bTo import the file, click Import.
The import process starts. You get a notification after the import process is complete.
Note: For more information about importing code values, see Import data.
5Import the value mappings of a crosswalk.
aIn Reference 360, click Explore, search and open the crosswalk.
The following table lists crosswalks and their location:
Crosswalk
Location
Salesforce Country
Country > Salesforce Country
Country_ISO_Conversion
Country > Enterprise Country > Salesforce Country to Enterprise Country
Salesforce State
State > Salesforce State
State_ISO_Conversion
State > Enterprise State > Salesforce State to Enterprise State
bClick Open.
cClick the Import Values icon.
The Upload File page of the Import Values wizard appears.
dTo select a file to upload, drag a CSV source file, or click Browse and select the source file.
The following table lists the crosswalks of the reference data set and the location: