Image: User import dialog

Administrators may import user accounts via a CSV file. This shall speed up the process of user creation if you want to migrate or copy user from another database.

CSV Requirements

The import feature expects a CSV file that follows these rules:

field delimiter is a semicolon: ;
text enclose character is a double quote: "
each record is ended by a carriage return/line feed (new line)
no empty line at the end
each record contains 11 fields:
"username";"firstname";"lastname";"title";"position";"phone";"mobile";"email";"idnumber";"birthday";"showbirthday"
(Note: An error message will point you to the faulty record.)

Example:

"rambo";"John";"Rambo";Mr.;"Soldier";"+01/555 111 1115";"555 1000 111";"rambo@army.com";"M345T";"1960-02-01";"yes"
"rocky";;"Rocky";"Balboa";"Boxer";;;"rocky@gym.com";;"1970-02-01";"no"
"butch";"Butch";"Cassidy";;"Bandit";"+01/555 111 1112";;"butch@holeinthewall.com";;"1980-02-01";"no"
"sundance";"Sundance";"Kid";;"Bandit";"+01/555 111 1111";;"sundance@holeinthewall.com";;;
"dances";"John";"Dunbar";;;;;;;;
"kyle";"Kyle";"Reese";;;;;;;;
"wallace";"William";"Wallace";"Mr.";"Hero";;;;;"1976-02-01";"yes"

Import Rules

If a line contains more than 9 fields the import is stopped. All records after the false one will not be imported. An error message is produced.
If the username is "admin" the record will be skipped. For security and integrity reasons this username cannot be imported via CSV.
If a user with the imported username already exists the record will be skipped. CSV import will not overwrite existing user records of the same username.
The default password for all imported users will be: password
The default user type for all imported users will be: regular user
The default gender for all imported users will be male.
The default notification settings will be none.
Show own groups only will bet set to No.
Show birthday will be set to No.
Ignore age will be set to No.
Notify Birthday will be set to No.
Default view of groups will be All.
For each imported user there will be an entry in the system log.

Options

Field	Description
Source CSV file to import	Select a file from your local drive to import
Default Group	All imported users will be assigned to this group
Default Language	All imported users will be assigned this default language
Lock user	All imported users will be locked. They can't login until the administrator unlocks them in their profile.
Hide user	All imported users will be hidden from the calendar. They will not be listed in the calendar until the administrator unhides them in their profile.

Buttons

Import

Will start the import

Help

Will show this help

Close

Will close the dialog

Done

Will close the dialog and refresh the user list.

Browser not supported