Import users from a CSV file using TinyMDM
How to import users from a CSV file?
TO IMPORT USERS FROM A CSV FILE:
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
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 Add “Anonymous” users help page. In this example, we’re putting “0” for “is_anonymous:0 or 1”.
send_email: if you want end-users to receive their IDs and QR code to enroll their device, put “1”. If you don’t want them to receive anything from TinyMDM because the enrollment will be done by the admin, put “0”.
custom_field: you can add up to 3 personalized fields. If you want to let them empty, put <;;>.
Example:
John Doe;john.doe@demo.com;Sales;john.doe;0;1;;;
Jane Doe;jane.doe@demo.com;Marketing;jane.doe;0;0;;;
You can create a CSV file from an Excel one. On Excel, select a New tab, then click on File -> Export -> Change file type and select CSV (Comma delimited) (*csv) and then fill in one column per field.

Note: If you create your CSV file from an Excel one 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: =””
(equal quote quote)
2. Then from the Users tab click on the orange button Import your 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

Number of fields:
In the CSV upload results, if you see the error “Row N°X The number of fields should be: 9”, it’s because there is an incorrect number of fields in your file. Please check it out (open your file with Notepad for example): there should be exactly nine fields >> Jane Doe;jane.doe@demo.com;Sales;jane.doe;0;0;;;

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.