Excel read and Write

[Alagupandi]

Scenario:

Want to Sign up for 100 new user's in a sample application.
I am passing the inputs from excel sheet such as Name, Email, Contact Number.

My Design:

Start --> Get input from sheet and save it in collection --> Loop Start --> Name, Email,Contact Number--Loop End--End.

Queries:

1. How to pass the inputs from collection to application for 100 users and also Please let me know how it can be resolved using code stage.

2. Is there any possiblity to achive parallel excution for the above scenario using multiple BOT ot multiple process?


Please provide your valuable comments.

 

[VJR]

Hi Alagupandi,

At first you need to spy the elements of the your sample application whatever that may be a web or a desktop application or even a mainframe. You need to spy all those elements which you are going to access through Blue Prism. For eg; All those textboxes where you will be writing your data (Name, Email, Contact Number) in order to do the signing up and also the final Submit button after entering all the data.

Assuming you have already launched your application prior to the loop, answers to your queries would be as below..
1. Inside the loop use a Writer stage to write value from the collection into its corresponding textbox.
[CollectionName.Name] will go into the element spied for the 'Name' textbox.

Similarly for the rest of the columns.
You can use a single Writer stage to write each of these these three collection values to their own textboxes. Use the Add button in the Writer stage
Spying an element is a common and widely used feature in Blue Prism and so does not have to involve the Code stage that you enquired about.

2. A multi bot architecture is typically used for tasks that are repetitive within the process and when there are a large number of records to be processed simultaneously to save time. So you need to identify the tasks that are repetitive in your process.
Videos from 32 to 35 in this tutorial explains everything from configuration of multiple bots to how to use them in your process.

 

[Alagupandi]

Hi Alagupandi,

At first you need to spy the elements of the your sample application whatever that may be a web or a desktop application or even a mainframe. You need to spy all those elements which you are going to access through Blue Prism. For eg; All those textboxes where you will be writing your data (Name, Email, Contact Number) in order to do the signing up and also the final Submit button after entering all the data.

Assuming you have already launched your application prior to the loop, answers to your queries would be as below..
1. Inside the loop use a Writer stage to write value from the collection into its corresponding textbox.
[CollectionName.Name] will go into the element spied for the 'Name' textbox.

Similarly for the rest of the columns
You can use a single Writer stage to write each of these these three collection values to their own textboxes. Use the Add button in the Writer stage
Spying an element is a common and widely used feature in Blue Prism and so does not have to involve the Code stage that you enquired about.

2. A multi bot architecture is typically used for tasks that are repetitive within the process and when there are a large number of records to be processed simultaneously to save time. So you need to identify the tasks that are repetitive in your process.
Videos from 32 to 35 in this tutorial explains everything from configuration of multiple bots to how to use them in your process.

Hi VJR,

Thanks for your detailed explanation and i will try and let you know if any issues.