A CSV (comma-separated values) file is a text file format that stores identity information in a tabular format. The first line in the CSV file is the header line, which contains the column names. Each identity record is represented by a new line, and each value in the record is separated by a semicolon. Automatic File Importer can easily fetch data from the CSV file and synchronize the data to Security Manager.

All data in the CSV file can be synchronized to Security Manager. The description field is not supported in the CSV file. The data displays based on the identity template set in Security Manager. For example, if the standard identity template UIM is used, the data is displayed in Security Manager accordingly. Following are the details of the standard columns:

  • statusFlag: Current status of an identity record.
    • NEW: Newly added identity.
    • UPDATED: Modified details of an existing identity.
    • DELETED: Deleted an identity.

  • If the statusFlag column is not available in the CSV file, all identities are considered as newly added.

  • country: Country where a person or identity is located.
  • firstName: First name of the identity.
  • lastName: Last name of the identity.
  • email: Email address of the identity.
  • TCGID: A unique identifier that identifies each identity in an access control system. This helps to differentiate each identity and maintain records related to the identity.

  • If the TCGID is not available, the email acts as the identifier. When both the TCGID and email are missing, Automatic File Importer excludes the record from data synchronization.

  • validUntil: Validity end date of the identity credentials.
  • department: This column in the CSV file is mapped to the Department in Security Manager.
  • location: This column in the CSV file is mapped to the Site in Security Manager.