Import users from a CSV file

How to import users from a CSV file?

Create and import users:

1. First of all, you’ll need to prepare a CSV file with the following structure:

user_name;user_email;group_name;directory_name;is_anonymous : 0 or 1;send_email : 0 or 1;custom_field_1;custom_field_2;custom_field_3

From TinyMDM version 7.3 (september 2024), please use this structure:
user_name;user_email;group_name;directory_name;is_anonymous : 0 or 1;send_email : 0 or 1;send_special_WPCO_email: 0 or 1;custom_field_1;custom_field_2;custom_field_3

  • user_name: user’s full name
  • user_email: user’s email address
  • group_name: user’s group (ex: sales, marketing, team B, etc). Later on, if you create a policy “Sales” for example, you’ll be able to apply it to the group_name Sales and all users in this group will be impacted.
  • directory_name: user name in company directory, could be helpful to automatically configure email parameters for example.
  • is_anonymous: to know what is an Anonymous user and how to use it, please read our tutorial Add “Anonymous” users.
    • If this is a normal user, enter “0” in this field (example: John Doe;john.doe@demo.com;Sales;john.doe;0;0;0;custom field 1;custom field 2;custom field 3).
    • To create an anonymous user, put “1” in the field. You can leave <user_email> empty (<;;>), but be sure to specify the <directory_name>. (example: John Doe;;Sales;john.doe;1;0;0;custom field 1;custom field 2;custom field 3).
  • send_email:
    • If you want the user to receive an e-mail containing his login and QR code so that they can enroll their device, enter 1 (example: John Doe;john.doe@demo.com;Sales;john.doe;0;1;0;customfield 1;customfield 2;customfield 3).
    • If you don’t want the user to receive an e-mail, since enrolment will be carried out by you or another MDM manager via the console, enter 0 (example: John Doe;john.doe@demo.com;Sales;john.doe;0;0;0;customfield 1;customfield 2;customfield 3). If the user is anonymous, you can leave this field empty or enter 0, since they won’t receive any e-mail anyway.
  • custom_fields: you can add up to 3 personalized fields. If you want to let them empty, put <;;>.

You can create a CSV file via an Excel file. In Excel, click on File -> Export -> Change file type, then select CSV (separator: semicolon) (*.csv) and fill in one column per field.

Note: if you create a CSV file from an Excel document and you don’t want to fill all the cells of custom_field, it is important to insert the following formula in the empty cells so that they can be taken into account: =”” (insert equal quote quote)

2. From the Users tab, click on the button Import users, select your CSV file and click on OK.

3. If the upload is successful, users will be created and appear in the Users tab. Except if users are anonymous or if you chose not to send them an email, they will receive a QR code and a password via email that they will need to enroll their device later on (using either one).

Main errors when importing the CSV file:

Duplicate users:

In the CSV upload results, if you see the error “Row N°X duplicate user: XXXX”, it’s because the user already exists in your console. Please delete this user from the file or from the console and try again.

Name required:

In the CSV upload results, if you see the error “Row N°X name required for anonymous users”, please make sure the field “user_name” is not empty.

Number of fields:

In the results window, if you see the error “Line N°X: number of fields must be: 10”, this means that the number of fields in your file is incorrect.