User importer file structure

Each line, which represents a user entry, contains the following data.

Note: The Login ID field is mandatory; all other fields are optional.

Tip: If you wish to specify Field 3 and Field 5, but not Field 4, then separate Field 3 and Field 5 with two commas to represent the empty entry. For example, "Field 3,,Field 5"

1. Field 1: Indicates whether the user datum is marked as deleted in the database or not.

2. Field 2: Specifies the first name of the user.

3. Field 3: Specifies the last name of the user.

4. Field 4: Corresponds to the unique Login ID of the user datum.

5. Field 5: Indicates the password of the user.

6. Field 6: Indicates whether the user is allowed to change password on next login or not.

7. Field 7: Indicates whether the user datum is an Active Directory user or not.

A section of a formatted .csv file opened in Notepad is displayed below.

The same section of the formatted .csv file opened in Microsoft Excel is displayed below.

Note: The CSV file opened in Microsoft Excel must not contain a header row specifying the field names.