Employee Import
The employee account import feature in LiteLog allows you to efficiently add multiple employees via a CSV or XLSX file. You can upload a table containing essential employee information. Additionally, you can pass and store extra details using optional columns.
Note: Make sure the file is correctly formatted and all required fields are filled in. Any additional columns not listed will automatically be saved as extra data.
Download the provided Excel template. This file contains an example of the “Employee Import” table, which you can edit with your own data.
Table Requirements
| Column Name | Description | Required |
|---|---|---|
| Name | Employee’s first and last name | ✅ |
| Benutzername | Login username | |
| Passwort | Password for the user | |
| Rolle | User role (e.g., propertymanager, securityemployee) | |
| Personennummer | Internal employee number | |
| Status | Account status: Active or Locked. Default is Active. | |
| Geburtsdatum | Date in the format DD.MM.YYYY | |
| Adresse | Address in the format: Street, House Number, ZIP Code, City, Country Code | |
| Telefon | Phone number | |
| Email address | ||
| Website | Company website or profile | |
| Notizen | Free text / remarks |
Note: Additional, non-listed columns are also allowed — they will automatically be stored as extra data. Fields not marked as required will automatically be filled with default values if left empty.
Format & Example
| Name | Username | Password | Role | Employee ID | Status | Date of Birth | Location | Phone | Website | Notes | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Max Mustermann | mmuster | 123456 | Admin | K12345 | Active | 01.01.1999 | Musterstraße 12, 10115 Berlin, DE | +49 123 456789 | max@example.com | www.example.com | Test user |
| Anna Schmidt | aschmidt | qwerty | Employee | K67890 | Locked | 10.05.1988 | Hauptstraße 45, 80331 Munich, DE | +49 876 543210 | anna@site.de | www.schmidt.de | Admin account |
Field Descriptions
- Name: Mandatory. Must contain the full employee name. Missing names will prevent import.
- Role: Enter the exact role name as defined in your system (e.g., “Admin”, “Employee”).
- Status: Mark an account as Locked. Invalid or empty values default to Active.
- Date of Birth: Format must be DD.MM.YYYY (e.g., 01.01.1990).
- Location: Must follow one of these formats:
- Street, House Number, ZIP Code, City, Country Code (e.g., Musterstraße 12, 10115 Berlin, DE)
- Street, ZIP Code, City, Country Code
- Street, City, Country Code
Explanation of Address Fields
- Street: Street name (e.g., Musterstraße)
- House Number: House number (e.g., 12)
- ZIP Code: Postal code (e.g., 10115)
- City: City name (e.g., Berlin)
- Country Code: Two-letter country code (e.g., DE). Complete list: Wikipedia ISO 3166-1 page.
Important Notes
- All address data must be accurate and complete.
- The country code must always be provided for correct geographic assignment.
- The format may omit house number or ZIP code for general location references.
Additional Columns
You can add as many custom columns as needed that are not listed in the Table Requirements. The values of these columns will be stored as additional data for the account.