Import Users & Groups
Supported Functions for Import from Excel
The following operations are supported from the import function:
- Inviting users to a project
- Updating user roles
- Adding users to Groups
- Creating new Groups
Setting up the spreadsheet
To use the import function, your spreadsheet must contain the following columns with the exact spelling listed:
- User email
- User group(s)
- Role
- Supported variables are User or Admin
Inviting Users to a Project
- Set up the spreadsheet
- Only the User email column is mandatory for successful import.
- If the Role column is left blank, the user will be invited with the role of User
- If the user email does not match an existing project member, they will be invited/added to the project during the import process
- To import a single user to multiple groups, separate the group names by using a semicolon ";".
- If the group does not exist in the project, it will be created during import
- Open a project in Trimble Connect for Browser.
- Go to the Team page.
- Click the Overflow Menu at the top of the right side of the page.
- Select Import from Excel.
- The Import Excel as Team dialog box opens.
Click Browse to select the Excel file.
- Click Open.
After the import has been processed, you receive an email with a link to download the import log file. You must be signed into Trimble Connect to download the log file. The log file will contain information in the event that an import failed.
Updating Team Members Information
You can change the user’s role or add them to groups using the Import function. Note: It is not possible to remove users from the project or remove them from a group using this process.
- Set up the spreadsheet
- Only the User email column is mandatory for successful import.
- Change the user role by adding User or Admin under the Role column.
If the role does not match their existing role in the project, it will get updated accordingly
- To import a single user to multiple groups, separate the group names by using a semicolon ";".
- If the group does not exist in the project, it will be created during import
- Next → Open a project in Trimble Connect for Browser.
- Go to the Team page.
- Click the Overflow Menu at the top of the right side of the page.
- Select Import from Excel.
- The Import Excel as Team dialog box opens.
- Click Browse to select the Excel file.
- Click Open.
After the import has been processed, you receive an email with a link to download the import log file. You must be signed into Trimble Connect to download the log file. The log file will contain information in the event that an import failed.
Create Groups by Importing an Excel Spreadsheet
- Set up the spreadsheet
- Only the User group(s) column is mandatory for successful import.
- If you are only creating new groups, leave the User email and Role columns blank
- If a group with the same name already exists in the project, it will be skipped during import
- Next → Open a project in Trimble Connect for Browser.
- Go to the Team page.
- Click the Overflow Menu at the top of the right side of the page.
- Select Import from Excel.
- The Import Excel as Team dialog box opens.
- Click Browse to select the Excel file.
- Click Open.
After the import has been processed, you receive an email with a link to download the import log file. You must be signed into Trimble Connect to download the log file. The log file will contain information in the event that an import failed.