TeamCal Neo
  • TeamCal Neo
    • Feature Comparison
    • TeamCal Neo License
    • Support
  • Installation
  • Quick Start Guide
  • Administration
    • Absence Types
      • Absence Allowance
      • Absence Type Edit
      • Absence Type Icon
    • Absence Patterns
    • Allowance Bulk Edit
    • Calendar Options
    • Database Management
      • TeamCal Pro Import
    • Declination Management
      • Absence Threshold
      • Before Date
      • Period 1-3
      • Scope
    • Framework Configuration
      • License
    • GDPR
    • Groups
      • Group Edit
    • Holidays
      • Holiday Edit
    • Permissions
      • Group Manager Permission
    • PHP Info
    • Regions
      • Region Calendar
    • Responsive Display
    • Roles
    • System Log
    • Users
      • User Edit
      • User Import
    • LDAP Authentication
    • Two Factor Authentication
  • User Guide
    • Attachments
    • Calendar (Month)
      • View Calendar (Month)
      • Edit Calendar (Month)
      • Edit Group Calendar (Month)
      • Edit Daynotes
    • Calendar (Region)
    • Calendar (Year)
    • Dark Mode
    • Language
    • Messages
    • Remainder Page
    • Statistics
      • Absence Type Statistics
      • Absence Statistics
      • Presence Statistics
      • Remainder Statistics
      • User Absence Summary
    • View Profile
    • Two Factor Authentication
Powered by GitBook
On this page
  • CSV File
  • Import Process
  • Options
  • Buttons
  1. Administration
  2. Users

User Import

PreviousUser EditNextLDAP Authentication

Last updated 5 months ago

Via the button “Import” on the User List page you can get to this User Import page.

CSV File

TeamCal Neo allows a bulk user import via a CSV file (CSV = comma separated values). A CSV file is a plain text file, containing one line of text for each user to import. The file extension must be “.csv”.

Each line must contain five values in the following sequence:

  1. Username

  2. Firstname

  3. Lastname

  4. E-mail address

  5. Gender (male or female)

Each value must be separated by a semicolon “;”.

Each value must be in quotes.

"butch";"Butch";"Cassidy";"butch@holeinthewall.com";"male"
"sundance";"Sundance";"Kid";"sundance@holeinthewall.com";"male"
"jdunbar";"John";"Dunbar";"john.dunbar@wolves.com";"male"
"sconnor";"Sarah";"Connor";"sconnor@resistance.com";"female"
"jtkirk";"James T.";"Kirk";"jtkirk@enterprise.com";"male"
"dtargaryen";"Daenerys";"Targaryen";"dtargaryen@got.com";"female"

You can find a sample CSV file in the sql folder of the installation directory.

Import Process

TeamCal Neo will go through each line and check each value. The following errors will be caught:

  • Less or more than 5 columns

  • Incorrect formats of username, lastname, firstname or E-Mail address

  • Incorrect gender

  • Username already exists

  • Username = “admin” (not allowed for import)

Each line where one of these errors exist will be skipped.

Each line that is OK will be imported.

A detailed message at the end of the import will show the result. Here are two examples:

Options

Filter
Function

Group

Select the group that all imported users will be assigned to.

Role

Select the role that all imported users will be assigned to. Default is “User”.

Hidden

With this option selected, all imported users will be set to “hidden”.

Locked

With this option selected, all imported users will be set to “locked”.

Buttons

Button
Function

Import

Will start the import

Show User List

Will go back to the User List page