IE.au3 ---> ForexFactory.com --

[darzanmihai]

I need some help collecting some information from the table "Today's Calendar " from www.forexfactory.com

Could someone help me please?

Thx in advance

[PsaltyDS]

Help with what? What have you tried? What happened when you tried it?

[darzanmihai]

Help with what? What have you tried? What happened when you tried it?

ok

I used the debug bar and I saw that the information I try to extract is not in a form but in a table so I managet just to get the number of tables from the page...but I do not know what to do next since there are just 2 table functions...

Thx for reply

I could really need some help on this

[PsaltyDS]

Get an object reference to the table you want with _IETableGetCollection(). If there are only two, an index of 0 = first table, and 1 = second.

Get the data as a first experiment with _IETableWriteToArray() and view the resulting array with _ArrayDisplay().

Drilling in further to the table will require some learning curve about the DOM, table row <TR> and table data <TD> tags, and what you want from inside them.

[darzanmihai]

Thx for help. It did the job.

[darzanmihai]

Sorry to disturb again...

How could I get the details for each row (on the detail column)?

Thx again.

[PsaltyDS]

What kind of details? And do you mean from the array you already got, or from the TR elements in the actual table?

[darzanmihai]

What kind of details? And do you mean from the array you already got, or from the TR elements in the actual table?

From the TR elements. There is a button in the table for each row. When you press that button it will pop a smaller window with some details about that specific row. I would like to grab that information for each row, but I don't know how.

Thax again

[PsaltyDS]

Time to climb the learning curve. Get yourself a copy of DebugBar (a common 'DOM Inspector') installed and start looking at the DOM and how those <button> or <input> tags are formatted.

Do they have ID or name attributes? If so, they can be addressed very simply and directly. If not, there are other work-arounds.

It's worth learning and very useful once you start understanding it.

[darzanmihai]

Time to climb the learning curve. Get yourself a copy of DebugBar (a common 'DOM Inspector') installed and start looking at the DOM and how those <button> or <input> tags are formatted.

Do they have ID or name attributes? If so, they can be addressed very simply and directly. If not, there are other work-arounds.

It's worth learning and very useful once you start understanding it.

Thx again for the reply.

I attached a screenshot of the tables I am talking about:

1- the details about each row - it is a button with an id (found with DebugBar) but I think it will change in time because the data from the table changes weekly.

When you press the "details" button it will popup a window (3) on top of the firs one, and the initial button turns into (2)- with the same id - so you can close the popup window.

I am interested in collecting the information from the table (4) of the popup window - I managed to do this from Autoit (up to this point), but there is a BUT:

- Knowing that the "details" buttons have dinamic IDs how could I get all the IDs from that column, and to know from what row is that ID?

[darzanmihai]

I found a way of doing what I needed in the last post:

expandcollapse popup

#include <IE.au3>
#include <array.au3>
#include <String.au3>

$oIE = _IECreate("www.forexfactory.com/calendar.php", 0, 1)
_IELoadWait($oIE)

$oTable = _IETableGetCollection($oIE)
$iNumTables = @extended

$colection = _IETableGetCollection($oIE, 9)
;$tables = _IETableWriteToArray($colection, 1)
;_ArrayDisplay($tables)

$Tbl_html = _IEDocReadHTML($colection)
$res_arr = _StringBetween($Tbl_html, "<TR id=detail_row_seek_", ">")

For $i = 0 To UBound($res_arr) - 1
    $Detail_id = "detail_" & $res_arr[$i]
    $detail_butt = _IEGetObjById($colection, $Detail_id);"detail_load_25550"
    $detail_butt.click
    $ok = wait_for_new_table($oIE, $iNumTables);1- ok , 0 - fail
    If $ok = 1 Then  ;if the popup window opens 
        ;$oTable_new = _IETableGetCollection($oIE)
        ;$iNumTables_new = @extended
        ;$colection_new = _IETableGetCollection($oIE, 13)
        ;$tables_new = _IETableWriteToArray($colection_new, 1)
        ;_ArrayDisplay($tables_new)
    EndIf
    Sleep(500)
    $detail_butt.click
Next

Func wait_for_new_table($oIE, $iNumTables);if the number of tables in the page changes then it means that the popup window opened
    $c = 1
    $sleep = 500
    While $c * $sleep <= 60000
        $oTable_n = _IETableGetCollection($oIE)
        $iNumTables_n = @extended
        If $iNumTables <> $iNumTables_n Then 
            Return 1
            ExitLoop
        EndIf
        $c += 1
        Sleep($sleep)
    WEnd
    Return 0
EndFunc   ;==>wait_for_new_table

, but I stil have a question: How could I get the index of the new table opened in the page?...I mean without searching all the tables in that page and identifying the one I am looking for (this is labour intensive...for the PC)

Do you have any ideea?

Thx again

[PsaltyDS]

You can use _IETableGetCollection() with an index to get the 1st, 2nd, 3rd, etc. table. For example, _IETableGetCollection($oForm, 1) would get the second (0-based) table.

Then use _IETagNameGetCollection() to get to the right table row "TR" tag, and as required get the data cell "TD" tag(s) under that, etc.

Eventually, you will drill down to what you want.

Start coding on it and see how it goes. When you get stuck, post your code for more help.

Edit: Didn't see your previous reply while typing this one. You can get a collection of all tables with _IETableGetCollection($oIE, -1), then loop through them and save an array or string of all the IDs:

$sTableIDs = ""
$colTables = _IETableGetCollection($oIE, -1)
For $oTable In $colTables
    $sTableIDs &= $oTable.id & ";"
Next

When you see the count of tables change, you do it again and find the one whose .id was not previously listed.

Edit: Oops. Should be .id, not .uniqueId.

Edited January 15, 2010 by PsaltyDS