You can delete data using a source data file (delimited text file) that contains the data that you want to delete. You select the file, configure the import parameters, and specify the delimiter (for example, a comma) that separates the data in the file.
You can also create a deletion import using a legacy map file from a previous product release. For more information, see creating a deletion import from a legacy map file.
Follow these steps:
Important! In this scenario, the system administrator performs the deletion import. However, the administrator can grant Data Importer User Access or Data Importer Admin Access to any CA APM user role. User access allows users to create imports, modify or delete their own imports, and view any import that was created by another user. Admin access allows users to create imports and modify or delete any import that was created by any user.
Specifies the source data file.
If this file is available on the CA APM application server, search for the data file and select the file. If this file is not available on the application server, upload the data file.
Allows you to browse on your local server for the source data file. This file is uploaded to the CA APM application server.
Important! The file size is limited by the product environmental settings. For more information, contact your administrator or CA Support.
Specifies the main object for the deletion import.
Asset and Model objects are listed with their corresponding families. You can also specify All Families. Legal Document objects are listed according to legal template. You can also specify All Templates. The objects include all objects that can be imported or deleted.
Note: For assets or models that include multiple asset family types or legal documents that include multiple legal templates, use the following selections for this field. Specify the particular family or template for each record in your source data file.
Important! Ensure that you select the correct main destination object. You cannot change the main destination object after you save or copy an import.
Specifies whether the first row in the source data file contains the column names. If the first row does not contain the column names, the names display as generic names, such as Field 1 and Field 2.
Specifies the tenant that applies to the import (if you are using multi-tenancy).
You can select a tenant only when multi-tenancy is enabled in CA APM and you are authorized to access different tenants. If you have access to public data and you have multiple tenants, you can select all tenants.
If you specify all tenants, your source data file must have a tenant name column that you map to the Tenant Name field.
Note: If you specify one tenant, verify that all data in your source data file belongs to your selected tenant. If you have data for more than one tenant, data for all tenants is applied to the selected tenant.
Specifies the delimiter (for example, comma or tab) that you used in the source data file.
Important! If a data value in your source data file contains the selected delimiter, you must use double quotation marks around the data value. For example, you select a comma as the delimiter to import companies. You want to include the data value Document Management Company, Inc. in your source data file. Specify this data value with double quotation marks:
"Document Management Company, Inc"
Specifies the locale for the source data file. This setting determines the date and time format.
The following fields require explanation:
Defines the number of errors after which the import stops. The threshold is based on the percentage of records processed. We recommend a minimum threshold of 15 percent.
Note: The Data Importer processes the number of records that are specified on Administration, System Configuration, Data Importer (Maximum Batch Record Size field) before calculating if the error threshold has been reached.
Specifies the type of import activity. Select one of the following options:
Select this option to delete primary objects and the relationships to their associated secondary objects. For example, you delete a company (primary object) and you remove the relationship to an associated asset allocation (secondary object).
When you select this option, verify that your mapping rules specify the primary objects only. Do not include any mapping rules for secondary objects.
Note: The secondary object that is associated with a primary object is not deleted. The relationship between the primary object and the secondary object is removed. For example, you have a primary object Company1 with an associated acquired company Company2 (secondary object). When you delete Company1, the relationship to Company2 is removed. The secondary object Company2 is not deleted.
Select this option to remove the relationships between secondary objects and their primary objects. When you select this option, verify that your mapping rules specify the primary and secondary objects only. You include a mapping rule for a secondary object; however, do not select the Primary Lookup check box for this rule.
Note: A secondary object that is associated with a primary object is not deleted. The relationship between the primary and secondary object is removed.
Specifies whether to normalize the data or write an error message in the log file without normalizing the data.
Note: This field appears only if you have defined normalization rules.
Writes an error message to the Data Importer log file when data that can be normalized is found in the data that you are deleting. The data involved is not deleted. The log file error message includes the details about the data.
For example, your data includes the company name Microsoft. The company normalization rules that you created identify Microsoft as a collected (nonauthoritative) value and specify Microsoft Corporation as the normalized (authoritative) value. If you select this option when deleting your data, the object with the company name Microsoft is not deleted and an error message is written to the log file.
Uses the normalization rules to normalize the data that you are deleting. If data that can be normalized is found, the data is normalized and deleted. No error message about the data is written to the log file.
For example, your data includes the company name Microsoft. The company normalization rules you created identify Microsoft as a collected (nonauthoritative) value and specify Microsoft Corporation as the normalized (authoritative) value. If you select this option when deleting your data, the object with company name Microsoft is normalized. In this example, the company name is changed to Microsoft Corporation and the associated object is deleted.
The deletion import is saved. The Mapping, Exclusion Filter, and Schedule areas of the page are now available for your input.
Example: Create a Deletion Import from a Data File
Miriam, the CA APM system administrator, performs the following actions to create the deletion import:
This CSV file is the source data file that contains the laptop deletions.
|
Copyright © 2013 CA.
All rights reserved.
|
|