_IETableWriteToArray only giving partial records

[Unicornasaurus]

Hey guys,

I've been scouring the internet looking for an answer to the problem I'm running in to. I have a web page that has a table element with a dynamic number of rows (sometimes it's 10, sometimes it's 80). I'm trying to get my script to grab the entire table, but it only seems to grab 2-3 rows out of the entire 80.

This is the code that is grabbing the table:

Global $tableColl = _IETableGetCollection($browser,18)
Global $tablePage = _IETableWriteToArray($tableColl,True)
_ArrayDisplay($tablePage)

I've verified that it is the 18th instance of the <table> on the page. When I do the _ArrayDisplay, it will give me 2 random records inside the table. The data in the 2 rows it returns is perfect, but it will randomly choose say, Row 39 and row 42 and not give me anything else back.

I did a _IEBodyReadHTML and checked to see if maybe the rest of the HTML was hidden or not loading at the right time, but all of the information is there in the source. I also checked the source of the page to see if maybe there was some unclosed tag or something like that, but I couldn't find anything.

I wish I could post the source of the page I'm getting the table information from, but it's an internal website for the company I work for.

Anyone have any ideas? I have no idea why it's doing it..

[DaleHohm]

I can think of nothing that can cause that. The function is pretty straight forward.

I'd suggest you

$sTable = _IEPropertyGet($tablecoll, "outerhtml")

and examine what you get back to insure it is the full table as you expect.

Dale

[Unicornasaurus]

I can think of nothing that can cause that. The function is pretty straight forward.

I'd suggest you

$sTable = _IEPropertyGet($tablecoll, "outerhtml")

and examine what you get back to insure it is the full table as you expect.

Dale

Hey Dale,

Thanks for the response. I inserted the code you provided and gave it another go. Your suspicions were correct in that it's not giving me back the full table HTML. Just those 2-3 records. I'm confused as to how it's only selecting those records as it seems to always be the same 2-3.

[jdelaney]

loop through all your tables, maybe one will return all the data you need:

$oIE = _IEAttach ( $browser )
$oTableCol = _IETableGetCollection ($oIE)
For $oTable in $oTableCol
 $aTable = _IETableWriteToArray ( $oTable, True )
 _ArrayDisplay ( $aTable )
Next

[Unicornasaurus]

loop through all your tables, maybe one will return all the data you need:

$oIE = _IEAttach ( $browser )
$oTableCol = _IETableGetCollection ($oIE)
For $oTable in $oTableCol
$aTable = _IETableWriteToArray ( $oTable, True )
_ArrayDisplay ( $aTable )
Next

I tried that, but it kept telling me Table 18 was the right one. It seems as though the table is getting populated after the page loads or something similar. When I used the _IEPropertyGet($tableColl,"outerhtml"), it told me that the </table> tag was occuring after 3 rows. I went and checked the source code of the loaded page and found the </table> tag nowhere near where the _IEPropertyGet told me it was.

[DaleHohm]

IE.au3 operates on the final loaded page, not the original source. Suggest you try DebugBar.

Dale