Import users from a CSV file using TinyMDM

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.