Create multiple users from spreadsheet with same credentials

Help Studio
, ,
1

I created a similar post that may use the same logic as this question but still awaiting response… I have a list of new users that I need to set up in our web based system. Each user will have a different First Name, Last Name and User Name. The rest of the information for the users will be exactly the same. The process of adding a new user involves both Type Into and Click activities. What is the best way to Repeat this process while incorporating the excel list of all user fields?

2

Option1:
Excel = FirstName | LastName | UserName => use these to create the users
Use variables to save “rest of the information” and use these to enter the same information

Option2:
Depending on how many users, mandatory fields, your access to the database and system rules, you could:
Excel = FirstName | LastName | UserName => use these to create the users
Leave rest of the information empty on the UI
Create and run a database script to populate the database directly with “rest of the information” - this will be much much faster