views:

296

answers:

8

Can anyone offer any suggestions for "something" that an end-user could use to put together macros that automate some CRM forms in Internet Explorer?

  • I was originally going to suggest iMacro, but then found out
    (i) they only have Internet Explorer and
    (ii) to make things even worse, it's version 6 :-(
  • it has to be fairly simple, so I can't suggest something like WATIN
  • but the forms on the page are not very complicated: type some text in, select from a list, click the submit button

Cheers, SteveC.

+1  A: 

Just write some javascript bookmarklets. Anything you can do to the page you should be able to do in JScript.

If you want to automate outside the HTML area, you'll have to use COM Automation.

jeffamaphone
you can use a bookmarklet to inject a whole script into the DOM, which would enable you to get around extremely long urls. http://tools.yaauie.com/pageSafe/ might give you a good starting point.
yaauie
Nah, this is for "end users", so javascript is going to have them running for the hills ... needs to be a (simple) UI / IDE or a "macro recorder", as they're used to Excel
SteveC
Okay. I assumed you (or someone) would be writing it for them.
jeffamaphone
I was trying to avoid it :-)
SteveC
+1  A: 

What about RoboForm?

Shoban
Can't see any mechanism for multiple pages, making different selections, etc.
SteveC
+3  A: 

How about Selenium?

testmann
Checked out Selenium, but it says IE 7
SteveC
+2  A: 

How about AutoHotKey?

Craig T
Ooh, hadn't thought of AutoHotkey ... can it automate IE ?
SteveC
Haven't do it personally .. but from the other stuff I have done .. I can't see why not
Craig T
+2  A: 

or autoit: http://www.autoitscript.com/autoit3/index.shtml

Alterlife
+1  A: 

If you can at some time upgrade to Firefox, i highly recommend these tools. Good luck though.

Ólafur Waage
+1  A: 

I've had some reasonable success with iMacros. I use the free Firefox plugin, but the full blown application can do much more.

http://www.iopus.com/imacros/

The addon for Firefox is free, and there is a free plugin for IE too.

scunliffe
Ooo, iMacros for Internet Explorer ... sweet
SteveC
+2  A: 

You can use Powershell. Here is a simple example:

    $ie = new-object -com "InternetExplorer.Application"
    $ie.visible = $true
    $ie.navigate2("www.myweb.com")
    $doc = $ie.Document
    $input1 = $doc.getElementById("username")
    $input1.value = "user"
    $input2 = $doc.getElementById("password")
    $input2.value = "pwd"
    $button = $doc.getElementById("submit")
    $button.click()
santiiiii