CSV file values and definitions for importing users

When you create a CSV (comma-separated value) file for importing users, place the values for each user on a single line in the following format. Values are defined below.

<Username>,[[<password>],[<plan>],[<firstname>],[<middlename>],[<lastname>],[<true/false/1/0/yes/no>],[<email>],[<phone>],[<description>],[<true/false/1/0/yes/no>],[<sam_account_name>]]

CSV file example

The following is the text of a CSV (comma-separated value) file used to import users:

User1,pwd

User2,pwd,plan1

User3,pwd,,firstname,,lastname,true,,,user 3 description,true,user1#domainname

User4,pwd,plan2,,,,,,,,false

If the CSV file above is imported, the following four user accounts are created:

Values

There are 12 possible values, each of which is described below.

Explanation of Values

Value Name

Required/ Optional

Description

Valid Input

1. Username

Required

A name that identifies the user. The user types this name, followed by your domain name when logging in to the control panel. The username and your domain name are also the user's email address at your organization. site.

Username requirements

2. Password

Depends upon the password policy set on the Active Directory server.

A password the user types to access the control panel.

Password requirements

3. Plan name

Optional

The user template you want to use to enable services for the user. If you do not specify a template, the user account is created without access to services.

The name of a valid enabled user template

4. Firstname

Optional

The user's first name.

Any input is valid

5. Middlename

Optional

The user's middle name.

Any input is valid

6. Lastname

Optional

The user's last name.

Any input is valid

7. Admin

Optional

Whether the user is allowed to log in to the organization site control panel.

TRUE, 1, FALSE, 0, empty

 

TRUE: the user can log in to the organization site control panel in addition to the User Administrator control panel.

 

1: Same as True

 

FALSE: the user can log in only to the User Administrator control panel.

 

0: Same as False.

 

Empty (no input): Same as False. The user can log in only to the User Administrator control panel.

8. Email

Optional

An email address at which the user can be contacted. This address is external to the user account you are adding.

A valid email address

9. Phone

Optional

A telephone number at which the user can be contacted.

Any phone number format is valid

10. Description

Optional

Any additional information you want to provide about the user.

Any input is valid

11. Enabled?

Optional

Whether control panel access is enabled or disabled.

TRUE, 1, FALSE, 0 empty

 

TRUE: the user can log in to the control panel and use any services enabled through the template.

 

1: Same as True

 

FALSE: the user cannot log in to the control panel or use services.

 

0: Same as False.

 

Empty (no input): Same as True. The account is enabled by default.

12. Sam_account_name

Optional. However, the system automatically generates a Sam_account_name if you do not provide one.

The login name used to support clients and servers running older versions of the operating system, such as Windows NT 4.0, Windows 95, Windows 98, and LAN Manager.

Sam account names can be up to 20 alphanumeric characters in length, and they cannot contain spaces. They can contain special characters, such as #.

Example:

user1#domainname

Instructions for importing users