Importing people from CSV

Under Admin → Users → CSV import admins create many people at once — in their company; super admins choose the company. The file has a header row and one person per row (UTF-8, semicolon or comma, at most 1,000 rows); the page offers a template to download.

• Columns (German or English, any order): first name, last name and e-mail are required; optional are username (otherwise the part of the e-mail address before the @), personnel number, department (the name of an existing department), role (User, Manager, Admin or Auditor), weekly hours (default 40, spread over Monday to Friday), vacation days (default 30), start date (DD.MM.YYYY or YYYY-MM-DD) and language (de or en).
• Check: Klokk first shows a preview with every row and its problems — missing required fields, e-mail addresses, usernames and personnel numbers twice in the file or already taken, unknown departments, roles you may not give, invalid values and an exceeded licence limit.
• Create: only after you confirm and only when no row has a problem — never half an import. Like a user created in the form, each person gets a one-time password by e-mail and changes it at the first sign-in. Super admins cannot be imported.

The audit log records every person created and the import with its count.