Working with a CSV file

Download CSV

By accessing the Manage Access > Assign Roles page you have the Download CSV option that allows you to download two different CSV types:

1. Download Users;

2. Download Template.

   
   

   

   
   

Download Users

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 Template

Download a CSV file containing a template to be used when you want to bulk add new user accounts.

Note: To be able to upload the CSV back to Automation Hub please do not modify the header information and follow the instructions from the Filling in the CSV section available below.

Filling in the CSV

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:

1. Open the CSV file downloaded using the Download CSV.

2. 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.
3. Save the CSV file locally.

Setting up the Roles, Collaborator Roles, and Defining the Categories

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"

Note: The Account Owner role is not available to be assigned to users, as it is automatically assigned only to the tenant's first 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"

Note: The Employee Idea Submitter, CoE Idea Submitter, and Process Owner collaborator roles are not available to be assigned to users when adding/editing users, as these collaborator roles are automatically obtained following the submission of an idea, respectively assigning a Process Owner to help with the detailed assessment.

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]]