How to Delete Data with the Data Importer › How to Delete Data with the Data Importer › Map Data File Columns to Data Fields

Map Data File Columns to Data Fields

You can map the columns in your source data file to product fields. You perform column mapping to specify which data is deleted. You can select most objects and associated fields as destination fields during column mapping.

Note: If you created your deletion import from a legacy map file, the column mapping exists. You can edit the existing mapping rules if you want to change the values. You can also add new mapping rules.

When you log in, the user role that your administrator assigned to you determines the objects and fields that you can see and use. If your role specifies that you do not have permissions for an object field, the field is not available for a mapping. You can only create a mapping and import or delete data for the objects and fields for which you have permissions.

Follow these steps:

1. Navigate to Administration, Data Importer.
2. Click New in the Mapping area for a selected deletion import.
3. Click the Select icon next to Source Field, select a column from your data source, and click OK.
4. Click the Select icon next to Destination Field, select a Destination Field for the selected Source Field, and click OK.

   The destination fields that appear are based on your selected main destination object.

   Note: The destination fields display in hierarchical order. For example, the fields that are listed under Asset Type Hierarchy are Asset Family, Class, and Subclass. The order of the fields represents the field hierarchy. Follow the field hierarchy when you specify mapping rules. For example, for Asset Type Hierarchy, specify a rule for Class before you specify Subclass.

5. Select the Primary Lookup and Secondary Lookup check boxes as required.
   1. Select a Primary Lookup check box for each destination field that you want to use to find the primary object. Use the following guidelines when selecting this check box:
      • Select at least one Primary Lookup check box in the column mapping for an import.
      • Do not select this check box if the Destination Field is Note Text (under the Note object). The database data type for the Note Text field does not allow it to function as a lookup field.
   2. Select a Secondary Lookup check box for each destination field that you want to use to find the secondary object. Use the following guidelines when selecting this check box:
      • Do not select this check box if the destination field is not one of your lookup fields for the secondary object.
      • Do not select this check box if the Destination Field is Note Text (under the Note object). The database data type for the Note Text field does not allow it to function as a lookup field.
6. Click the Complete Record Edit icon.
7. (Optional) Click New to specify more mapping rules.

   You can select more Source and Destination fields to add to the column mapping.

   Note: To delete a specific mapping rule from the list of mapped columns, click the Delete icon next to the mapping rule. The column mapping rule is removed from the list.

8. Click Save.

   Your column mapping is saved.

Example: Map Data File Columns to Data Fields

Miriam performs the following steps to map the columns in the source data file to the CA APM data fields:

1. Clicks New in the Mapping area of the Import Details page.
2. Selects %Hardware Name% in the Source Field by clicking the Select icon next to Source Field and selecting this item from the dialog.

   The items that are listed in the dialog are the columns from the source data file.

3. Selects Asset Name in the Destination Field by clicking the Select icon next to Destination Field and selecting this object from the dialog.
4. Selects the Primary Lookup check box.
5. Clicks the Complete Record Edit icon and clicks Save.