Filling online forms using MS Excel / .csv data

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

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

Hey @arivu96,

Thank you for the assistance…

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

-Avi

Hi @Avinash_Narayanan,

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

Regards,
Arivu

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

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

Regards,
Arivu

Hey there,
Take a look here. :slight_smile:

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