Creating the CSV File

The CSV file used to import user accounts into the appliance must be generated with the guidelines shown in the below table, and fields must be in the order shown.

CSV file field order

Field	Required or Optional	Guidelines	Description
Username	Required	1-255 characters (case-sensitive)	Name the user enters to login
Description	Optional	Any number and type of characters allowed	Additional information about the user
Password	Optional	Must conform to the password policy configured for the local authentication server (used only when importing new users)	Password the user enters to login
Enabled	Required	Must contain either Trueor False Case-sensitive	Whether the user is allowed to login
E-mail	Optional	Local user name and domain name separated by an @ (up to 254 characters)	Valid e-mail address used to send one-time passwords to the user
Devices	Optional	Comma-separated list	Device IDs associated with the user
Groups	Optional	Comma-separated list (up to 255 characters) A group is created if AMC tries to import an undefined group.	Comma-separated list of groups to which the user belongs
IPAddress	Optional	Single IPv4 address, each IPv4 address should match the network address of the resource interface. List of IPv4 addresses, these addresses are presented to the User-Mapped Tunnel Address Pool, in the order they appear in the list.	If you are using a user-mapped address pool, you can specify one or more comma-delimited IPv4 addresses for this user.
Phone number	Optional	mobile number	Phone number associated with the user that receives one-time password SMS

This example shows the file format required to import users into AMC:

The following guidelines are also required, as shown in the above example:

• The first row of the file is ignored, because the CSV format uses the first row as column headers.

• String values are typically quoted using double quotes (“).

• String values containing commas must be quoted.

• String values containing quotes must escape the quote by using another double quote character, for example, “The group name is “”Team1””.”

If AMC encounters any errors in the CSV file, no data is imported and an error message is displayed. Error messages are shown in Import and Export Error Messages.