Creating a mapping file

 To create a mapping file

1. Log in to Data Import.
2. Choose File > New Mapping.

3. In the Mapping File Editor, complete the following fields in the Data File and Server section:

   New Mapping dialog box fields
4. Map the fields in the Field Value Mappings section using either of the following methods.
   1. Click Auto Map to add all fields and map fields to fields of the same name. For more information, see Tips for mapping all data file fields.
       Or
   2. Click Add.
   3. In the Add Mapping dialog box, select a Field Name.
   4. Use the Keyword or Field buttons to add a value to the Value field.
       You can also type field names, keywords, or any constant string into the Mapping Value field.
       For example, suppose you select the Create Date field, and you want each record in the destination form to have today's date as the value in the Create Date field. Choose $DATE$ in the Keyword list. The resulting value in the destination form is the date of the import. See Keywords.

   5. Repeat this step for all the fields that you want to map.

      Warning

      Note

      If the data file contains duplicate field titles, an error is generated. If the data is*.arx* or .xml format, the field titles appears as their field IDs. If the data file is .csv or .asc format, the fields appear with an appended number (for example, fieldTitle1, fieldTitle2, and so on).

5. (Optional) Define fallback mappings for fields.
    For more information, see Defining default mappings.
6. To edit a field value mapping or fallback mapping, select the field, and click Edit.
7. (Optional) Click the Options tab, and change the preferences as needed.
    See Defining Data Import preferencesfor a description of most of the options. The differences are
   • The Options tab does not include a Log File field, but it is included in the Preferences window.

   • The Options tab includes the following fields, which are not included in the Preferences window.

     

     Additional Data Handling field on the Options tab
8. (Optional) Save the mapping.
9. Import the data as described in Importing data.