Importing Users
Import users using a comma-separated values (CSV) file.
-
Download these sample files as a starting point.
-
Extract the compressed file and then open the
Users.csv
file. - Optional. To familiarize yourself with the import process, consider importing just the demo data. You can then delete the unwanted demo data before you begin importing live data.
-
Review and then delete any demo data in the
Users.csv
file. -
Create an import file using the
Users.csv
file. TheUsers.csv
file is a simple text file in a tabular format (rows and columns). The first row in the file defines the columns (fields) in your table.Note
-
The maximum number of rows in the user import file must not exceed 100,000 and the import file size must not exceed 52 MB.
-
At a minimum, the file must have these exact column headings and the fields in these columns must be unique.
-
User ID
-
Last Name
-
First Name
-
Work Email
-
Primary Email
-
Primary Email Type
-
-
For each account, you create a new row (line) and enter data into each column (field). Each row equals one record.
-
The telephone numbers of the users that you want to import must meet the requirements of the RFC 3966 specification.
-
When importing users, the attribute
Recovery
cannot be specified as one of valid values for Primary Email Type. The valid values for Primary Email Type arehome
,work
, orother
. -
If you want users to use their federated accounts to sign in, then you must set the Federated column to TRUE for those users. When the federated flag is set to TRUE, IAM no longer manages the federated user's password. This prevents IAM from forcing a password change for these imported user accounts.
-
If you don't want users to be notified that accounts were created for them, then you must set the ByPass Notification column to TRUE for those users. The ByPass Notification option determines whether an email notification is sent after creating or updating a user.
-
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.
-
-
Save your file in UTF-8 format. Saving the file in UTF-8 format ensures that non-English characters display properly.
- Open the CSV file with a text editor, such as Notepad.
- Save the file with UTF-8 for encoding.
Note
If you don't save the file in a CSV format with UTF-8 encoding, the import fails.