CA Identity Governance Client Tools Guide › Import and Export › CSV Files Converter › Import from CSV Files › CSV File Import Generation

CSV File Import Generation

Symptom:

When I import data in a CSV file from Microsoft Excel, the file is corrupted after porting to CA Identity Governance. Upon looking at the resultant CSV file, it is seen that the backslash ("\") character is removed under certain circumstances.

Solution:

When importing CSV files into CA Identity Governance, use the following property setting:

import.csv.reader.escape

Description: Changes the escape character to a specific character not included in the CSV font set when the backslash character ("\") is included.