How to prepare for CSV import

In this chapter, you can find guidelines for your users to prepare the users.csv and groups.csv files. These files are sent to AMS for bulk import.

The user is advised to follow the below guidelines while preparing the CSV files to avoid error messages during the import process.

Users, CSV and CSV groups are provided to AMS for bulk import.

General Guidelines

  • The users need to prepare two CSV files:
    • Users.csv: This file contains user information, formatted in the standard of IDC sample user CSV file.
    • Groups.csv: This file contains groups and user-group associations, formatted in the standard of IDCS sample group CSV file.
  • CSV files need to be in the UTF-8 format.
  • the CSV file name should not include special characters such as commas or spaces.
  • To create a CSV file, you can use a standard spreadsheet application such as Microsoft Excel or Google Sheets, or you can use a text editor, such as Notepad or TextPad.

For more information, see: