You have to login in order to post a reply to this topic.

4 replies [Last post]
Thu, 02/04/2010 - 18:39
Use Excel Data To Populate Web Forms
Jeremy
User offline. Last seen 1 year 51 weeks ago. Offline
Joined: 02/04/2010
Posts: 4

Hello,

I need to take data stored in Excel files and populate (copy and paste ) the data into web forms, submit the form then loop through the enitre process until I have gone through the entire Excel file.

 

So the Excel file will have a variable number of rows but always 3 colums of data per row.

I then need to:

1) login to the site (TextBroker.com),

2) Navigate the site to get to the correct forms

3) Insert the data from Excel into the correct form field (there are two form fields, column 1 data goes into form1 and column 2&3 data goes into form 2)

4) submit the form

5) do the entire process over again

 

It seems it would be easy to create a job that would navigate through the Textbroker.com site and that I would just need to add some kind of code/variable that would read from the Excel file and loop through the data correctly inserting the data into the correct form fields.

Then I would need to somehow loop the part of the job that navigates to the forms so I can populate the next set of date from Excel

I just have no clue how to handle the Excel part, where/how to insert that functionality into the job and how to loo p the required steps.

Hopefully this makes sense.

 

Thanks for the help!

 

 

Top
  • Quote
Thu, 02/04/2010 - 19:09
#1
Thomas Minitsios
User offline. Last seen 1 year 4 weeks ago. Offline
Joined: 07/16/2009
Posts: 34
Re: Use Excel Data To Populate Web Forms

Hello Jeremy,

Please check the 2 blog posts about how to use data from Excel in WinAutomation:

http://winautomation.com/blog/using-data-excel-part-i
http://winautomation.com/blog/using-data-excel-par...

I hope that this will give you an idea about how to automate the task that you described. 

Top
  • reply
  • quote
Mon, 02/08/2010 - 23:59
#2
Jeremy
User offline. Last seen 1 year 51 weeks ago. Offline
Joined: 02/04/2010
Posts: 4
Re: Use Excel Data To Populate Web Forms

Thanks Thomas!  This did the trick!

Top
  • reply
  • quote
Fri, 11/19/2010 - 00:31
#3
julienraby
User offline. Last seen 11 weeks 28 min ago. Offline
Joined: 11/19/2010
Posts: 4
Re: Use Excel Data To Populate Web Forms

 Hi, I've been trying all afternoon to find a solution for what I'm looking for but I gave up. 

 

Here's what I really need:

 

I have a list of about 300 name that I have to manually insert in an email marketing. For some reason I need to submit them individually. So for every email, I need to:

 

- put the email in the email field;

- put "yes" in another filed;

- check a checkbox;

- Hit submit;

 

And then repeat for every emails.

 

Is that possible, and if so, can you enlight me on how?

 

Thanks!

 

Top
  • reply
  • quote
Fri, 11/19/2010 - 14:08
#4
codex
codex's picture
User offline. Last seen 18 weeks 4 days ago. Offline
Joined: 11/12/2009
Posts: 161
Re: Use Excel Data To Populate Web Forms

The only difference between the task that you need to automate, and the task that is described in the blog posts that are posted above, is that instead of using the various variables in a single action (i.e. the "Send Email" action) you need to send them with keystrokes to specific inputs.

 

First of all, I am assuming that you have version 3.1 (it has a feature that comes in very handy, you'll see below):

 

- Follow the instructions of the blog post till you reach the "For Each" part.

- Instead of placing a "Send Email" action in the "For Each" loop, you will have to place the following actions in the "For Each" loop:

 

1) "Move Mouse to Image": Capture the email field of the form as an image. Check the two advanced options, "Wait for Image to appear", "Send Left Mouse Click" (these options have been added in 3.1)
2) "Send Keys": Send the email address as keystrokes (if for example you are using the exact same structure with the blog post in your Excel file, you will have to enter something like this: %CurrentDataRow["Email Address"]%)

... do the same for the "YES" field, checkbox and submit button ...

 

x) "Wait for Image": Wait for an image that is in the empty form. This way the job will wait for the page to become available before going at the start of the loop again, and continue with the next email entry.

__________________

Error is not blindness, error is cowardice

__________________

Error is not blindness, error is cowardice

Top
  • reply
  • quote