Filling online forms using MS Excel / .csv data

excel
uiautomation
orchestrator
activities
studio

#1

Hey everyone,

I would appreciate some assistance with data entry automation… I have an excel document (which is available in .csv also) which has 2 columns filled with data… I would like to use this data to enter into an online form (web based)… could someone please give me a step by step walk thru as to how I could read my data and parse into the web browser field?

Thanks
Avi


#2

Hi @Avinash_Narayanan,

  1. use read CSV activity to read the data from the excel to datatable
  2. using for each row activity loop through the data.
  3. inside the loop you can mention where to type the data in online.

Regards,
Arivu


#3

Hey @arivu96,

Thank you for the assistance…

For step 3… could you explain a little further? which command do i use?

-Avi


#4

Hi @Avinash_Narayanan,

Can you tell me what you are entering into online can you tell me the sample input.

Regards,
Arivu


#5

Hey Arivu,

Yes sure… the sample looks like this:

username Code
xyz@gmail.com 100
abc@gmail.com 200
san@hotmail.com 300

Hope this helps

-Avi


#6

ok if you are entering username and code after that what you will do??

Regards,
Arivu


#7

Hey there,
Take a look here. :slight_smile:


#8

Hi in looping I am getting the problem please attach your camel code thank you