- Release notes Public Sector
- Getting Started
- Permissions
- Starting as
- Admin Console
- Workspace
- Explore
- Share Idea or Automation
- Dashboards
- My Tasks
- Notifications
- Email Notifications
- Resources
- Studio Integration
- Task Capture Integration
- Automation Store
- Additional Resources
Working with a CSV file
By accessing the Manage Access > Assign Roles page you have the Download CSV option that allows you to download two different CSV types:
Download a CSV file containing the data from the People page by clicking Download Users. The exported CSV file contains the data listed on the Assign Role page, except for the information from the Status column. You can use the CSV file to bulk add new user accounts or update existing ones.
Download a CSV file containing a template to be used when you want to bulk add new user accounts.
Regardless of the CSV type you choose to download, its header contains the following information:
- First Name,
- Last Name,
- E-mail,
- Job title,
- Business Unit,
- City,
- Department,
- Roles column which includes both the assigned Role(s) and the Collaborator Roles.
To add or update information in the CSV follow the below steps:
- Open the CSV file downloaded using the Download CSV.
-
Enter all the details for a new account or apply updates on the existing account information.
- The only accepted separator for the CSV format is the comma.
- Keep the header as downloaded.
- In the Roles columns, you can assign both Roles and Collaborator Roles (default or custom ones), along with the categories they apply to.
- Save the CSV file locally.
The Roles, as well as Collaborator Roles, are assigned by using a slug that has the following format: "ah-role", respectively "ah-collaborator-role". Check the below tables for the default Roles and Collaborator roles slug format.
Besides the Slug, you need to add the Category ID. The final format should look like [["ah-role",categoryID]], respectively [["ah-collaborator-role",categoryID]].
The category ID "0" gives access to the user to exercise the role's / collaborator's roles permissions in all categories.
|
User Role |
Slug Format |
|---|---|
|
System Admin |
"ah-system-admin" |
|
RPA Sponsor |
"ah-rpa-sponsor" |
|
Component Curator |
"ah-curator" |
|
Program Manager |
"ah-program-manager" |
|
Idea Approver |
"ah-idea-approver" |
|
Authorized User |
"ah-authorized-user" |
|
Standard User |
"ah-standard-user" |
|
Collaborator Role |
Slug Format |
|---|---|
|
Project Manager |
"ah-project-manager" |
|
Business Analyst |
"ah-business-analyst" |
|
Solution Architect |
"ah-solution-architect" |
|
RPA Developer |
"ah-rpa-developer" |
To find out the slugs for the custom roles and collaborator roles, as well as specific Category IDs please create a dummy user or use the one we predefined as an example, access their user details in the Admin Console > Manage Access > Assign Roles page and assign it all the available Roles and Collaborator Roles, along with the various categories that interest you. Download the CSV using the Download Users option. Apply to the new users the slugs for the Roles and Collaborator Roles, as well as the Category IDs that interest you. Alternatively, you can leave the Roles column empty in the CSV, and apply the user roles and their categories directly in the Upload CSV preview screen.
Please find below several examples on completing the Roles column:
-
To define a user to whom we want to assign the Standard User role for all the Categories and the Idea Approver role only for the Human Resources category, the Roles cell in the CSV would look like this, if 1 is the ID of the "Human Resources" category:
[["ah-standard-user",0],["ah-idea-approver",1]]
-
To define a user to whom we want to assign the Standard User role for all the Categories and the Solution Architect Collaborator Role for the Finance&Accounting category, the Roles cell in the CSV would look like this, if 7 is the ID of the "Finance&Accounting" category:
[["ah-standard-user",0],["ah-solution-architect",7]]
