---
title: "CSV File User Directories"
slug: "csv-file-user-directories"
updated: 2024-01-17T12:56:31Z
published: 2024-01-17T12:56:31Z
canonical: "help.mail-and-deploy.com/csv-file-user-directories"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.mail-and-deploy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# CSV File User Directories

### General

This type of user directory synchronizes [Users](/version340/docs/users) and [User Groups](/version340/docs/user-groups) with a CSV file.

          NOTE

          

This type of user directory is not available in the SaaS version of Mail & Deploy.

### File Structure

The CSV file contains two types of entries; each entry needs to be in a line of its own.

#### User Group Entry

This type of entry describes a user group and has the following syntax:

          CSV File User Group Entry

          

usergroup;<id>;<name>

The entry has the following values:

| Name | Description |
| --- | --- |
| id | The ID of the user group which is used by to identify a user group throughout multiple synchronizations with the CSV file. This is an alphanumeric string that needs to be unique. |
| he ID of the user group which is used by to identify a user group throughout multiple synchronizations with the CSV file. This is an alphanumeric string that needs to be unique. | The name of the user group. |
| #### User Entry |  |
| This type of entry describes a user and has the following syntax: |  |

          CSV File User Entry

          

user;<id>;<name>;<match_code>;<type>;<language>;<email>;<time_zone>;<culture>;<has_windows_account>;<windows_account_name>;<has_custom_credentials>;<custom_username>;<custom_password>[;<usergroup_id_1>;...<usergroup_id_n>]

The entry has the following values:

| Name | Description |
| --- | --- |
| id | The ID of the user which is used by to identify a user throughout multiple synchronizations with the CSV file. This is an alphanumeric string that needs to be unique. |
| name | The name of the user. |
| match_code | The match-code of the user. This property is optional and can be an empty string. |
| type | *0.* Standard User *1.* API User *2.* Administrator |
| language | *en.* English *de.* German |
| email | The e-mail address of the user. This property is optional and can be an empty string. |
| time_zone | The timezone of the user; this needs to be one of the values of the *Timezone* column of the  [Windows Default Time Zones](https://learn.microsoft.com/en-us/windows-hardware/manufacture/desktop/default-time-zones?view=windows-11). |
| culture | The culture of the user; this needs to be one of the values of the *CultureInfo Code* column of the  [Culture Code List](https://azuliadesigns.com/c-sharp-tutorials/list-net-culture-country-codes/). |
| has_windows_account | *False*. The user does not have a windows account. *True*. The user does have a windows account. |
| windows_account_name | The name of the windows account of the user in *DOMAIN\accountname* format. This property can be an empty string if *haswindowsaccount* is set to False. |
| has_custom_credentials | *False*. The user does not have custom credentials. *True*. The user does have custom credentials. |
| custom_username | The custom username of the user. This property can be an empty string if *hascustomcredentials* is set to *False*. |
| custom_password | The custom password of the user. This property can be an empty string if *hascustomcredentials* is set to *False*. The custom password of a user will only be set if the user is first added during a synchronization; when an existing user is updated, the password will not be overwritten. |
| usergroup_id_1 ... usergroup_id_n | One or more IDs of user group entries within the same CSV file (see User Group Entry above). |

          NOTE

          

For a full description of the individual properties see the [Users](/version340/docs/users) article.