Oracle Data Loader On Demand Guide > Files, Record Types, and Parameters for Oracle Data Loader On Demand >

Map File for Oracle Data Loader On Demand

A map file contains the field mappings between Oracle CRM On Demand and the fields from an external data source. You specify the path and the name of the map file in the properties file or in the command-line. The map file must be in CSV format. It must have the same character set encoding as the data file. The first line of the map file must contain the following header:

"Oracle CRM On Demand Field","Import File Field"

All remaining lines in the map file must contain a pair of mappings where the first item is a field in Oracle CRM On Demand and the second item is a field in your data file. Only mapped fields are processed. If the map file is not a valid CSV format, a mapping validation error occurs. For example, if you have a data file that contains two columns, and the names of those two columns are My Acct Name and My Acct Loc, then the map file contains the following:

"Oracle CRM On Demand Field","Import File Field"
"Name","My Acct Name"
"Location","My Acct Loc"

Map files are interchangeable between the Import operation in Oracle CRM On Demand and Oracle Data Loader On Demand. To save time, you can perform a small import (with at least one record), which generates a map file. The Import Assistant allows easy mapping of your data files with Oracle CRM On Demand fields. When the import finishes, the map file for the import becomes available in Oracle CRM On Demand. You can download the map file and use it with Oracle Data Loader On Demand. Note that the mapping file has the extension MAP. You must keep that extension for the mapping file to be recognized by Oracle Data Loader On Demand.

The double quotation marks are optional when you create a map file manually. If you create the map file using the Import Assistant, it surrounds all values with double quotation marks. For an example of a map file, see Sample Map File.