User Import

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

•	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.

Navigation: Administration
User Import