You can import member mappings from a selected .CSV and .TXT. This feature enables you to create new mappings in a text file and import them. Import Member Mappings supports merge or replace modes, along with validate or no validate options for target members.
To import member mappings:
From the Data Load Mapping task bar, select Import.
The Import drop-down is displayed.
From the Import drop-down, select either Current Dimension or All Dimensions.
The Select file to import screen is displayed.
Optional: If necessary, click Upload to navigate to the file to import and then click OK.
You are prompted to open or save the file.
In the member mapping import files ERP Integrator supports one of the following characters as column separator:
,
|
;
The order of the columns are as follows: Source Value, Target Value, Rule Name, Rule Description
The mapping details are as follows:
Table 14. Supported Column Separators
| Column | Mapping |
|---|---|
| 100, Cash, R1, Explicit Map | Explicit Mapping |
| 100>199, Cash, R2, Between Mapping ' | “>” indicates its BETWEEN mapping. |
| 1*, Cash, R3, Like Mapping | “*” indicates its LIKE mapping. |
| #MULTIDIM ACCOUNT=[4*] AND UD3=[000],Cash,R4,Multi Dimension Mapping | “#MULTIDIM” indicates its Multi Dimension Mapping. The actual column name used for the mapping is the Data Table Column Name. The easiest way to create a Multi dimension mapping would be to create a mapping through the UI and export it to the file. You can then modify the file by additional mappings |