Importing Member Mappings

You can import member mappings from a selected .CSV and .TXT. You can create new mappings in a text file and import them. Import member mappings support 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.
Navigate to the file to import and click OK.
Optional: If necessary, click Upload to navigate to the file to import and then, click OK.

In the member mapping import files FDMEE 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

Note:

If you add a minus sign in front of a target account value, then it is imported with the “Change Sign” selected.

The mapping details are as follows:

Table 26. Supported Column Separators

Column	Mapping
100, Cash, R1, Explicit Mapping	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 it is a multiple dimension mapping. The actual column name used for the mapping is the Data Table Column Name. The easiest way to create a multiple dimension mapping is to create a mapping through the user interface and export it to the file. You can then modify the file by additional mapping.
10, 20, In Mapping	Source values are enclosed with “ ” and separated by a comma (,) for the In mapping. For example IN 10, 20 is defined as “10,20” in the source column of the import file.