You can import member mappings from a text file. Mapping files must have the .txt extension. A sample member file must contain all of the following (except extra columns):
Data source members column (left)—lists the member names in the data source. Member names containing spaces must be in quotation marks.
Data target members column (center)—lists the member names in the data target. Member names containing spaces must be in quotes.
Non-member column (left)—missing members. Use it to map an extra member in the data source to Void in the data target or to map an extra member in the data target to Void in the data source.
Separators (between the columns)—tabs or spaces to separate columns.
Extra column (right)—the file can contain extra columns that do not contain member names.