Account Map and Group Map CSV File Guidelines
On This Page
Overview
Mapping and exclusion imports must be a comma-separated values (CSV) file and follow a specific format. Data fields are wrapped in double quotation marks ("Value 1", "Value 2", "Value 3") and separated with commas. Empty fields must be qualified with two double quotation marks ("") in order to be accepted ("Field 1 Value","", "Field 3 Value"). This page provides information to help you understand the file structure and sample files you can use to help you build your own import files.
If you receive an error when importing a CSV file, the file does not meet the expected format. Compare your file to the sample files provided, and edit the file before attempting to import it again.
Understanding the File Elements
Both mapping files and exclusion files utilize the same four fields: ID, username, name, and caption. The table below lists each field and identifies the information that can be used in each field.
Field | Description | Example Values |
---|---|---|
id | The ID is the unique identification number assigned to the account. Not all platforms have IDs. Some platforms, such as Box, display the ID as part of the account details. Other platforms, such as G Suite, provide the ID as part of the security settings. Refer to documentation for your specific platforms to identify if the platform uses an ID and how to find it. For NFS, the ID will be the user directory. |
|