/
User Import
The following macros are not currently supported in the header:
  • style

User Import

Apr 09, 2013

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.