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

Buttons

Will start the import

Will show this help

Will close the dialog

Will close the dialog and refresh the user list.