Jump to content
Sign in to follow this  
gsc

Auto Fill of Forms

Recommended Posts

gsc

Hi All,

I am fairly new to this, I have got a job of filling forms with information from a Spreadsheet. Some of it is a simple case of copying and pasting, the rest has to be done by researching the info.

What I would like is something that pulls the info from the spreadsheet and then allows me to continue to do the researching part.

Do you have anything like this that can help me?

So imagine you have the below on a spreadsheet.....

Name: GSC

ID: 1234

Agreement: Corperate

Contract Version: 2011

Account Manager: GS

Code: SLIC/SLIC

Then on the website these feilds are all over the place and some of them are a look up that then loads another page where you have to type the Account Managers name to get their email address.... you click it and it goes back to the original page...

Once it has done the copying and pasting of all that I would then research other info such as what Level they are of a customer and when their agreement ends......

I get so many of these and are on such a low budget pay... just need something to make it easier..

Any help would be most grateful..

GSC

Share this post


Link to post
Share on other sites
Skitty

Looks like you posted in the wrong forum.

Also, you're going to need to be a little familiar with autoit to really do that, there's a UDF library called winhttp.au3 which is suited for these types of things.


Things that I've done..

Icon Resource Editor: icon resource editor 

AutoIt Piano: a piano

AutoIt Unlocker: unlocks files when you want to delete them

Colorful tooltips: a wrapper for the tool tips UDF

Rouge GoogleBot: a full screen animation

ASciTE text editor: a text editor written in autoit

Warning: Posts by this user are subject to change or may disappear without notice.

Share this post


Link to post
Share on other sites
gsc

Oh? How have I posted in the wrong Forum? Where do I need to post this? I understand a little bit about it but not a great deal, once I have the base of it I am a quick learner and can develop it. I just need a push in the right direction ;)

GSC

Share this post


Link to post
Share on other sites
gsc
I see what you mean, I have moved it to the correct page! thanks for your pointer...

Share this post


Link to post
Share on other sites
shmuelw1

Name: GSC

ID: 1234

Agreement: Corperate

Contract Version: 2011

Account Manager: GS

Code: SLIC/SLIC

You definitely could use AutoIt for copy/pasting from one program to another.

Below is a sample script that copies the title of a field, for example "Name," finds it in Internet Explorer, copies the name data in Excel, then waits for you to click in the Name field in Internet Explorer. When you click OK it pastes the name and goes to the next Excel field.

; Click on the top-left cell in Excel before running
Opt("WinTitleMatchMode", 2) ; match any part of title
Dim $answer

While 1 ; continue loop forever
    WinActivate("Microsoft Excel") ; go to Excel
    WinWaitActive("Microsoft Excel")
    Send("^c") ; presses CTRL+c to copy cell
    WinActivate("Internet Explorer") ; go to IE
    WinWaitActive("Internet Explorer")
    Send("^f") ; presses CTRL+f
    Sleep(500)
    Send("^v") ; presses CTRL+v
    Send("{ENTER}") ; presses Enter to find the search item
    WinActivate("Microsoft Excel")
    WinWaitActive("Microsoft Excel")
    Send("{RIGHT}") ; presses Right Arrow to go to cell to the right  
    Send("^c") ; presses CTRL+c to copy cell
    Send("{DOWN}") ; go down one row
    Send("{LEFT}") ; go one cell to the left
    WinActivate("Internet Explorer") ; go to Excel
    WinWaitActive("Internet Explorer")
    $answer = MsgBox(262145, " ", "Click in the field where you want to copy the text, then click OK.") ; 262145 makes the dialog box have OK and Cancel buttons and always stay on top
    If $answer = 2 Then Exit ; exit if Cancel is clicked
    Send("^v") ; presses CTRL+v
    WinActivate("Internet Explorer") ; go to IE
    WinWaitActive("Internet Explorer")
WEnd

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×