Upload Groups and Assignments in Bulk

If you've ever needed to create many Groups in ActivTrak and assign users to them, you know this can be a tedious process. For many, lists of users and the groups or teams they belong to are easier managed in a spreadsheet. In fact, we often get these as a CSV export from another system.

That's why we have enabled Groups Upload via CSV

Instructions:

1. Navigate to Groups settings by selecting Settings > Users & Groups > Groups.

mceclip0.png

2. Click Create Group followed by Upload Group.

Groups___ActivTrak_2021-07-06_14-07-29.png Groups___ActivTrak_2021-07-06_14-09-03.png

3. Download existing Groups from this window:

Groups___ActivTrak_2021-07-06_14-11-05.png

...or from the Download button on the Groups home screen.

Groups___ActivTrak_2021-07-06_14-20-02.png

Tips 💡

  • These downloads are identical and will export in CSV format.
  • Users may appear multiple times if they are assigned to multiple groups.
  • Groups without users and users that are not in any groups are listed at the bottom.

4. Add new Groups and assignments.

In the example below, 4 users are in the 'Sales' Group. In rows 6-9, sub-groups are added and users are assigned to the appropriate ones.ActivTrak_Group_Upload_-_Google_Sheets_2021-07-06_13-48-28.png

Tips 💡

  • Group names have a 65-character limit.
  • The only columns required for upload are group_name and user_id, and user_id can be blank if creating empty groups for users to be added to later. Below is an example:

image__1_.png

5. Export back to CSV and upload. Export your spreadsheet as a CSV. Then drag and drop or select the CSV from your file explorer:

Groups___ActivTrak_2021-07-06_14-34-17.png

Your results will appear after the upload:

mceclip2.png

Tips 💡

  • With this version, you cannot modify or delete groups or assignments.

For more assistance, please reach out to Support.

Was this article helpful?

3 out of 4 found this helpful

Comments

No comments