IE Library in AutoIt

[Benji]

Having spoken to locodarwin, he advised me to put a post up in here asking for help with IE Library in AutoIt.

My question involves the site CLICKY!!!. The area with I have highlighted in the following picture, as seen HERE is the area I am focusing on.

I basically want to extract that information into Microsoft Excel. That is step one.

If I can get this done, step two is slightly more difficult. If you visit the above site, you can login with my test account, Username: testage Password: test123, and click on any one of the odds available by any of the bookmakers, you will see this bring up a betting slip. I'm told its possible to do but I personally have no idea how to go about it. I would like the cells in Excel to link to the corresponding betting slips.

I'm not great on AutoIt as it is, so please keep any responses to a n00b minimum

Many thanks

Edited November 30, 2006 by Benji

[mikehunt114]

If you're new to the IE library, start with

$url = "whatever"
$oIE = _IECreate($url, 1)
$clip = _IEDocReadHTML($oIE)
ClipPut($clip)
Run("Notepad.exe")
Send("^v")
oÝ÷ Ù6¤y©h¢F­¶¬¢êÜy©Ýuë^®h§{^­ì¨º·^²*Þv)ߢ¹¶*'À%µêçjدz¢*.${az¥¥ø¥z+l,Ê¡£¨¹Æ§ëbú+«b¢v¢ë_­©±ú+Ç­pLZ^jëh×6
#include <IE.au3>
$oIE = _IE_Example ("frameset")
$oFrames = _IEFrameGetCollection ($oIE)
$iNumFrames = @extended
For $i = 0 to ($iNumFrames - 1)
    $oFrame = _IEFrameGetCollection ($oIE, $i)
    MsgBox(0, "Frame Name", $oFrame.name)
Next

Try working your way down to the information you want, so you can ask more specific questions. I hope that helps and wasn't redundant to stuffs you already knew

[AzKay]

If you're new to the IE library, start with

$url = "whatever"
$oIE = _IECreate($url, 1)
$clip = _IEDocReadHTML($oIE)
ClipPut($clip)
Run("Notepad.exe")
Send("^v")
 oÝ÷ Ù6¤y©h¢F­¶¬¢êÜy©Ýuë^®h§{^­ì¨º·^²*Þv)ߢ¹¶*'À%µêçjدz¢*.${az¥¥ø¥z+l,Ê¡£¨¹Æ§ëbú+«b¢v¢ë_­©±ú+Ç­pLZ^jëh×6
#include <IE.au3>
$oIE = _IE_Example ("frameset")
$oFrames = _IEFrameGetCollection ($oIE)
$iNumFrames = @extended
For $i = 0 to ($iNumFrames - 1)
    $oFrame = _IEFrameGetCollection ($oIE, $i)
    MsgBox(0, "Frame Name", $oFrame.name)
Next
 oÝ÷ Ù:òÂäx2¢êðk'hÂ{h¶¢ú+«b¢|¨»§¶Ê2¢ç«$Þ²øªç¬¶*'°h¥ëajØ^ܲ}ý¶·ºwZÛh²Û~̨¹©ky§rw°?ú®¢×¢é]Ø­m騭éb殶­s`¢b33c·W&ÂÒgV÷C·vFWfW"gV÷C°¢b33c¶ôRÒôT7&VFRb33c·W&¢b33c¶6ÆÒôT&öG&VDDÔÂb33c¶ôR¤6ÆWBb33c¶6Æ¥'VâgV÷C´æ÷FWBæWRgV÷C²¥6VæBgV÷CµçbgV÷C²

[Benji]

I've got to be honest, i cant even get the first script to work when i put in a URL into the first line :s I get an error on line 2

I'm not very good at this

Edited November 30, 2006 by Benji

[Valuater]

the first line should be

#include <IE.au3>

TESTED

#include <IE.au3>

$url = "www.Autoit3.com"
$oIE = _IECreate($url)
$clip = _IEBodyReadHTML($oIE)
ClipPut($clip)
Run("Notepad.exe")
WinWaitActive("")
Send("^v")

8)

Edited November 30, 2006 by Valuater

[Benji]

I get error with that tested script.

Line 2799 (File "C:\Program Files \AutoIt3\Include\IE.au3"):

Return HWnd($o_object.HWND ())

Return ^ ERROR

Error: The requested action with this object failed.

[Valuater]

i actually got a warning.. not an error/crash with this line

$oIE = _IECreate($url, 1)

the "1" above say to "attach" an existing IE object

try the script above 1 more time

8)

[mikehunt114]

Wouldnt it be more like

$url = "whatever"
$oIE = _IECreate($url, 1)
$clip = _IEBodyReadHTML($oIE)
ClipPut($clip)
Run("Notepad.exe")
Send("^v")

@ AzKay: Either IEBodyReadHTML or IEDocReadHTML is appropriate. I prefer looking at the full source code given from IEDocReadHTML, just for completeness. And yes, I did forget a #include <IE.au3> on my first post there.

@ Benji: Try running your script through Scite if you aren't already.

[Benji]

No i am still getting errors. This is beyond me, i know how to do a few very basic things with AutoIt. I am willing to learn its just i'm on a bit of a deadline to get this done. Anyone wanna job?

[mikehunt114]

No i am still getting errors. This is beyond me, i know how to do a few very basic things with AutoIt. I am willing to learn its just i'm on a bit of a deadline to get this done. Anyone wanna job?

Are you running the lastest version of AutoIt?

[Benji]

Are you running the lastest version of AutoIt?

Yes i've just redownloaded the latest version off the website again and i still get the same error

[AzKay]

@ AzKay: Either IEBodyReadHTML or IEDocReadHTML is appropriate. I prefer looking at the full source code given from IEDocReadHTML, just for completeness. And yes, I did forget a #include <IE.au3> on my first post there.

@ Benji: Try running your script through Scite if you aren't already.

Ah

[mikehunt114]

Yes i've just redownloaded the latest version off the website again and i still get the same error

Please run the script through Scite, post the exact script you use, and the console output with errors.

[Benji]

Please run the script through Scite, post the exact script you use, and the console output with errors.

Right i've made progress, i've finally got your script to work! I had half of an old script in there :s

Thats a whole lot date that gets put into notepad. It seems like a tall order trying to put the selected area i want into Excel

[mikehunt114]

http://www.autoitscript.com/forum/index.ph...st&p=271533 contains a link to the IE Dev Toolbar. It has a 'select element by click' option that is sometimes useful. But if you don't know the basics of HTML you may find this entire task difficult. Perhaps you should browse MSDN for basic HTML stuff first?

[Benji]

I do know HTML as i've made several websites, my problem is i don't know what to do with the information when putting it into autoit. Even if i could get the information in, gettings it to do what i want in Excel is a totally different story.

I'm not trying to be rude and unwilling to learn, its just i don't have the time at the moment to get this one done. Can anyone help please? It no scam i do pay, just ask Loco Just contact me on MSN: jon@fcut.co.uk if interested

Edited December 1, 2006 by Benji

[Locodarwin]

I can attest to the fact that Jon/Benji will pay and/or donate to AutoIt in exchange for help. I'd throw some help in myself this time around, only I'm behind at work and on a strict time budget.

-S

[DaleHohm]

I do know HTML as i've made several websites, my problem is i don't know what to do with the information when putting it into autoit. Even if i could get the information in, gettings it to do what i want in Excel is a totally different story.

I'm not trying to be rude and unwilling to learn, its just i don't have the time at the moment to get this one done. Can anyone help please? It no scam i do pay, just ask Loco Just contact me on MSN: jon@fcut.co.uk if interested

I can take a closer look at this over the weekend, but not today.

I will tell you that your site is FULL of embedded frame after embedded frame... just getting to the right document container will be one of the biggest challenges.

Dale

[big_daddy]

I took a quick look at this last night, but there is so much cross-site scripting its not funny.

[DaleHohm]

Took another quick look... the content you are wanting is a java applet. This means, sorry, it is not accessible via normal means and the access to its content are controlled by defined interfaces specific to the applet (i.e. you need api documentation or sources to even figure out what CAN be done).

Sorry.