How to Import Data › How to Import Data › Review the Prerequisites

Review the Prerequisites

To ensure that you can successfully import the data, verify that you have completed the following tasks:

• Prepare a source data file in delimited text format (for example, tab or comma). This file contains the data that you want to import.

  Note: We recommend that you include the main destination object in the name of the source data file. This file naming convention helps you locate your data files when you create your import.

  Note: A value of NULL in your source data file clears the corresponding destination field value. An empty field in your source data file leaves the corresponding destination field value unchanged.

  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"

• (Optional) Copy your source data files from your local server to one of the following locations. You can access these locations on the CA APM application server where the Storage Manager Service is installed. The location depends on whether you are using multi-tenancy.

  [ITAM Root Path]\Storage\Common Store\Import
  

  [ITAM Root Path]\Storage\Tenant_Name\Import
  

  Note: If you copy the data file before you create an import, you can then specify the file name when you create the import. If you do not copy the data file first, you can upload the file from your local server when you create the import.

• (Optional) Copy your legacy map files from a previous product release (if you have these files) from your local server to one of the following locations. You can access these locations on the CA APM application server where the Storage Manager Service is installed. The location depends on whether you are using multi-tenancy.

  [ITAM Root Path]\Storage\Common Store\Import 
  

  [ITAM Root Path]\Storage\Tenant_Name\Import