# User Import

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

<figure><img src="/files/l4dX5OsDctMk4BVr03a4" alt=""><figcaption></figcaption></figure>

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

```csv
"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:

<figure><img src="/files/1LMMEXcu83rSkQfF9cEX" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/51h0Gp6lxPE3vF9SYLgA" alt=""><figcaption></figcaption></figure>

## 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 |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://lewe.gitbook.io/teamcal-neo/administration/users/user-import.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.