Data Management User Guide › Import and Export Menus › CSV Files Converter › CSV Mapper Utility

Previous Topic: Export to CSV Files

Next Topic: Active Directory Converter

CSV Mapper Utility

The CSV Mapper Utility allows you to extract user and resource data from any CSV file and map that data to create CA RCM Configuration files, and User and Resource databases. The utility does not identify any role relationship that may exist between the Users and Resources in CSV file.

To map a CSV file to CA RCM entities

  1. Click Import, CSV Mapper Utility.

    The CSV Mapper window opens.

  2. In the Files section, specify the pathnames of source and target data files, and specify the character used to separate data values in the source CSV file.
  3. In the Source CSV to SageDNA Mapping section, specify the columns in the source CSV file that correspond to mandatory user and resource fields.
  4. Click Convert.

    The CSV Mapper Utility creates each of the CFG, UDB, RDB files and locates them as indicated in the CSV Mapper Utility.