Mapping Sample Data with the Data Importer › How to Work with the Sample Map Files › Define a Data Mapping from a Sample Map File

Define a Data Mapping from a Sample Map File

You can define a data mapping using a sample map file as a template for your own data mapping.

Follow these steps:

1. Click Administration, Data Importer, New Import.
2. Enter a name for the import.
3. Click Search and Load Map and select a sample map file name in the Legacy Map File field.

   Important! Your map file and corresponding data file must be available on the CA APM application server. For more information, see How to Import Data.

4. Specify the Advanced Settings and click Save.

   The Basic Information, Exclusion Filter, and Mapping data mapping are loaded. The Mapping, Exclusion Filter, and Schedule areas of the page are now available for you to edit. The Mapping and Exclusion Filter areas display the data from the legacy map file.

5. Select a source data file in the Data File field.

   Your selected file replaces the data file that was originally associated with the sample map file that you opened.

6. Verify that the correct source data file delimiter is specified for the Delimiter.
7. Verify that the correct object is specified for Main Destination Object.
8. Click Save.
9. In the Mapping area, modify the contents of the mapping based on your requirements to map your new data field columns to CA APM destination fields.
10. In the Exclusion Filter area, specify filter rules, if needed.
11. In the Schedule area, complete one of the following steps:
    • Click Submit to start the import now.
    • Select the Is Scheduled check box, specify the schedule information, and click Submit.

    To view the import job for your current selected import, click Associated Jobs on the left side of the page. In the list of import jobs that appears, click Status Message to view the status of your import. The status includes the number of records that were processed, how many records were successful, and the number of errors or warnings.

    You can also view the log file for more information about the import activity. In the list of import jobs, click View Log for your import.

12. Examine the results of the import in the CA APM user interface when the import job is complete.