Column Name

Required?

Maximum
Text Size

Description

User Name

Yes

255

The login name (user ID).

Note: The user name cannot be changed when doing updates by upload.

Acceptable characters are as follows:

abcdefghijklmnopqrstuvwxyz0123456789@$_.~'-

A user ID (user name) cannot start with an apostrophe (') or a dash (-).

Non-breaking white spaces (space, tab, and newline) and double-byte characters (for example, Japanese or Chinese characters) are not allowed.

All user IDs are converted to lower case, then validated, and finally saved in lower case if valid.

Also note that there exists a list of reserved words that you cannot use (doing so produces an error). The following are the most common: add, all, block, count, down, force, link, mount, off, simple, tag, up.

Password

No

255

The password for the user. Passwords are case-sensitive. Acceptable characters are as follows:

All single-byte characters are accepted except the following: plus (+), double quote ("), and back slash (\).

Non-breaking whitespaces (space, tab, newline), double byte characters (for example, Japanese or Chinese characters), and blank passwords are not allowed.

If omitted, the value for User Name is used.

Force Password Change

No

Not applicable; see Description column for acceptable values.

Determines whether the user will be forced to change his or her password immediately after the next (or first) login. Acceptable values are 1 (to force a password change) or 0 (to not force a password change).

If omitted during an add operation, a default value of 0 is used.

Status

No

Not applicable; see Description column for acceptable values.

The status of the user. Acceptable values are 1 (for Activated) and 0 (for Deactivated).

If omitted during an add operation, a default value of 1 is used. If omitted during an update operation, the user's status is unchanged.

First Name

No

255

The first name of the user. If omitted, the value for User Name is used. All Latin-1 and double-byte characters are accepted.

Last Name

No

255

The last name of the user. If omitted, the value for User Name is used. All Latin-1 and double-byte characters are accepted.

Email Address

No

255

The email address of the user. If omitted, this field is left blank. Non-breaking whitespaces (space, tab, newline) are not allowed.

Role

No

Not applicable; see Description column for acceptable values.

The role (profile) to assign to the user.

Note: The value for Role determines the user's access privileges in the system. It is not meant to identify his or her position within his or her organization.

Possible values are END_USER (default), MANAGER, or ADMIN.

Company administrators (and super administrators) cannot be created using the Upload feature.

Birthdate

No

10

This is a date field; use the format mm/dd/yyyy.

Sex

No

255

The gender of the user.

Address1

No

255

The primary address for the user.

Address2

No

255

The secondary address for the user.

City

No

255

The city in which the user is located.

State

No

255

The state in which the user is located.

Zip

No

255

The zip code for the city in which the user is located.

Country

No

255

The country in which the user is located.

Phone

No

255

The phone number for the user.

CC Number

No

255

The number of the credit card associated with the user.

CC Type

No

255

The type of credit card associated with the user.

CC Expr

No

255

The expiration date of the credit card associated with the user.

free1

No

255

An optional field used to specify additional user information.

Group Membership

No

Note: Because a user must belong to at least one group, this field is required if you are uploading new users.

240

One or more org codes (unique, alphanumeric identifiers) associated with the groups to which the given user should be added.

A user can belong to any number of normal (organizational) groups, but he or she can only belong to 1 advanced group.

Each org code must be separated by a semi-colon. Capital letters are accepted. Non-breaking whitespaces (space, tab, newline) are not allowed.

The groups associated with the specified org codes must exist prior to the upload of the user.

To determine a group's org code, click Management | Users and Groups, and navigate to the group in the hierarchy in the left pane. The org code for a group is displayed in parentheses beside the group name.

Group Operation

No

Not applicable; see Description column for acceptable values.

Indicates how the groups specified in the Group Membership field are to be applied to the user. Acceptable values are 0, 1, and 2:

• 0: (Default) Replaces the user's current list of groups with the list specified in the Group Membership field. If you use this value, include in the Group Membership field the complete list of new groups that will replace the user's current groups. If you are uploading new users, this option simply adds the new users to the specified groups.
• 1: Adds the user to the groups specified in the Group Membership field. If you use this value, include in the Group Membership field only the groups that you are adding. If you are uploading updates to existing users, this option retains the users’ existing groups and adds the users to the specified groups.
• 2: Removes the user from the groups specified in the Group Membership field. This value is only valid if you are uploading updates to existing users. If you use this value, include in the Group Membership field only the groups that you are removing.

Note: If omitted, a default value of 0 is used. If a value for Group Membership is omitted, this field is ignored.

Approval Manager

No

255

The user name (login name) of an existing user who is the approval manager for this user.

The approval manager is responsible for approving and denying this user's requests for enrollment in learning programs and Live Learning courses.

Note: This column is not shown unless the Enable Manager Approval web site switch is enabled by a super administrator.