Find the right Colum to Extract Data, on the 3rd tab opened

[BrunoPessoalCred]

Hi everyone,
good morning,

My name is Bruno, I'm brazilian. Sorry by the English. I need to build a code of a extraction in the site http://consulta.plus (with login and password, I can pass if you ask), but first I need to fill the number of CPF (individual registration) and find the data of the client I'm look for.

Second, the site presents a table to click in anyone data (image1), I click in the line of the table, and the site goes to the table I want do extract the colum of "Vlr Disponível" and below, "Margem Livre", right below "Margem Livre" (credit card) but I cant to find de right code to find the correct extraction on the table, in a correct column "Vlr. Disponível"

I tried to do this code:

macro = "URL GOTO=http://consulta.plus#!" + vbNewLine
macro = macro + "'Get the values" + vbNewLine

'Verifing the extraction
macro = macro + "TAG POS=1 TYPE=TH ATTR=TXT:Vlr Disponível" + vbNewLine
macro = macro + "TAG POS=R1 TYPE=TD ATTR=CLASS:bdytxt&&TXT:*.* EXTRACT=TXT " + vbNewLine

Summing up, I need a code that extract the colum "Vlr Disponível" and down, "Margem Livre" and "Margem Livre" right below, and make a seach by CPF but when the site find the data of CPF he opens 3 tabs (image2_extract),

Image 2 extract

How can I find this datas and build the code to find the correct colum?

Any doubt contact me, please.
Thank You

[chivracq]

Hi everyone,
good morning,

My name is Bruno, I'm brazilian. Sorry by the English. I need to build a code of a extraction in the site http://consulta.plus (with login and password, I can pass if you ask), but first I need to fill the number of CPF (individual registration) and find the data of the client I'm look for.

Second, the site presents a table to click in anyone data (image1), I click in the line of the table, and the site goes to the table I want do extract the colum of "Vlr Disponível" and below, "Margem Livre", right below "Margem Livre" (credit card) but I cant to find de right code to find the correct extraction on the table, in a correct column "Vlr. Disponível"

image1.jpg

I tried to do this code:

Code: Select all

macro = "URL GOTO=http://consulta.plus#!" + vbNewLine
macro = macro + "'Get the values" + vbNewLine

'Verifing the extraction
macro = macro + "TAG POS=1 TYPE=TH ATTR=TXT:Vlr Disponível" + vbNewLine
macro = macro + "TAG POS=R1 TYPE=TD ATTR=CLASS:bdytxt&&TXT:*.* EXTRACT=TXT " + vbNewLine

Summing up, I need a code that extract the colum "Vlr Disponível" and down, "Margem Livre" and "Margem Livre" right below, and make a seach by CPF but when the site find the data of CPF he opens 3 tabs (image2_extract),

Image 2 extract

image2extract.jpg

How can I find this datas and build the code to find the correct colum?

Any doubt contact me, please.
Thank You

(F)CIM...! (Read my Sig...)
OK..., using '.vbs' Script... => iMB with Scripting Interface... => v12.0...?/v11.5...?/v11.0...?/v10.x...?
+ Which Browser...? + Version...? + OS...?

But OK, from a look at your Screenshots and from your Scenario/Explanations, this sounds like a fairly "typical" Data Extraction Case with use of "Relative Positioning"...
The 3 Tabs btw shouldn't cause any Pb (for iMacros) I would think, as they are all 3 within the same HTML Page, unless they only get populated upon being activated, but then OK, you'll simply need to make sure to "activate" them, like a User would do "manually" anyway...