GreatCornholio wrote: ↑Tue Dec 01, 2020 7:34 pm
Bingo. The first code you provided works to bring back the value in Output ID. great progress
Working code to bring back Outpud ID value:
Code: Select all
Code: Select all
TAG POS=1 TYPE=TR ATTR=TXT:*Type*OutputId*RunId*
TAG POS=R5 TYPE=TD ATTR=TXT:* EXTRACT=TXT
PROMPT EXTRACT:<SP>_{{!EXTRACT}}__
My two follow up questions are:
1) The Prompt section of the code isnt completing the intended use case, here the code is pulling out the value when I'd ask the script to select the hyperlinked Output id value to progress to the next webpage. Ive had a go at two lines of code below but am unable to get it to work, am I barking up the right tree?
Code: Select all
TAG POS=1 TYPE=BUTTON ATTR=TXT:<SP>_{{!EXTRACT}}_
&
Full section of code:
Code: Select all
TAG POS=1 TYPE=TD ATTR=TXT:NORMAL-2056132-XUKL
TAG POS=1 TYPE=TR ATTR=TXT:*Type*OutputId*RunId*
TAG POS=R5 TYPE=TD ATTR=TXT:* EXTRACT=TXT
wait seconds = 2
PROMPT {{!EXTRACT}} --- attempting here to ask the script to select the hyperlinked output id value
wait seconds = 1
TAG POS=1 TYPE=A ATTR=TXT:CSVs
TAG POS=1 TYPE=LI ATTR=TXT:Eliminated<SP>Asin<SP>Information
2) How do I go one further to pull back the OutputID on say the second row of the output table? Or even better row where FcType-OGL (column 3) = "NORMAL-7-HUK5" / or specific text?
Code: Select all
TAG POS=1 TYPE=TD ATTR=TXT:NORMAL-2056132-XUKL --- wanting it to look for this in column or looking to select X row outpudId
TAG POS=1 TYPE=TR ATTR=TXT:*Type*OutputId*RunId*
TAG POS=R5 TYPE=TD ATTR=TXT:* EXTRACT=TXT
wait seconds = 2
PROMPT {{!EXTRACT}} --- attempting here to ask the script to select the hyperlinked output id value
wait seconds = 1
TAG POS=1 TYPE=A ATTR=TXT:CSVs
TAG POS=1 TYPE=LI ATTR=TXT:Eliminated<SP>Asin<SP>Information
If it helps, table HTML with 2 rows:
<table id="runs-table" class="table"> <thead class="thead-inverse"> <tr> <th>Run For Date</th> <th>Time of Run</th> <th>FcType IOGL</th> <th>Type</th> <th>OutputId</th> <th>RunId</th> </tr> </thead> <!-- ngRepeat: entry in popCtrl.fabRunListFiltered = (fabRunList | startFrom:popCtrl.currentPage*popCtrl.rows_requests | limitTo : popCtrl.rows_requests) --><tbody ng-repeat="entry in popCtrl.fabRunListFiltered = (fabRunList | startFrom:popCtrl.currentPage*popCtrl.rows_requests | limitTo : popCtrl.rows_requests)" class="ng-scope"> <tr> <td class="ng-binding">2020-11-30</td> <td class="ng-binding">2020-11-29T21:02:20.942</td> <td class="ng-binding">NORMAL-7-HUK5</td> <td class="ng-binding">PRODUCTION</td> <td><a href="/#/run-details/f0f7c33e/159a11e8-723a-4394-8fdd-588765fb8a66" class="ng-binding">f0f7c33e</a></td> <td class="ng-binding">159a11e8-723a-4394-8fdd-588765fb8a66</td> </tr></tbody><!-- end ngRepeat: entry in popCtrl.fabRunListFiltered = (fabRunList | startFrom:popCtrl.currentPage*popCtrl.rows_requests | limitTo : popCtrl.rows_requests) --> </table>
Thank you for your continued support.
Alright, good to hear that the 'EXTRACT' using 'Relative Positioning' is "finally" working...
Well, about:
... it is simply meant to debug your Script by following and displaying your Vars, here "only" the Built-in '!EXTRACT' Var...
But if you want to debug and follow several Cells like you mention if you have several Rows of Data in the Table, every Cell from the same Col can be accessed and extracted with 'POS=R6' as your Table has 6 Cols, => for example...:
Code: Select all
'Extract 'OutputId' from 1st Row:
TAG POS=1 TYPE=TR ATTR=TXT:*Type*OutputId*RunId*
SET !EXTRACT NULL
TAG POS=R5 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SET OutputId_1 {{!EXTRACT}}
'>
'Extract 'OutputId' from 2nd Row:
SET !EXTRACT NULL
TAG POS=R6 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SET OutputId_2 {{!EXTRACT}}
'>
'Extract 'OutputId' from 3rd Row:
TAG POS=1 TYPE=TR ATTR=TXT:*Type*OutputId*RunId*
SET !EXTRACT NULL
TAG POS=R6 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SET OutputId_3 {{!EXTRACT}}
'>
'Display all 3 Vals:
PROMPT OutputId_1:<SP>_{{OutputId_1}}_<BR>OutputId_2:<SP>_{{OutputId_2}}_<BR>OutputId_3:<SP>_{{OutputId_3}}_
And you can the reuse the 3 Vals/Vars wherever you want in your Script..., like for example:
Code: Select all
TAG POS=1 TYPE=A ATTR=TXT:{{OutputId_1}}
And, yep of course, you can use your "NORMAL-7-HUK5" from Col_3 to extract the corresponding 'OutPutId', like in:
Code: Select all
SET FcType_IOGL "NORMAL-7-HUK5"
TAG POS=1 TYPE=TR ATTR=TXT:*Type*OutputId*RunId*
TAG POS=R1 TYPE=TD ATTR=TXT:{{FcType_IOGL}}
SET !EXTRACT NULL
TAG POS=R2 TYPE=TD ATTR=TXT:* EXTRACT=TXT
PROMPT EXTRACT:<SP>_{{!EXTRACT}}_
... => With 'POS=R2' for the 'OutPutId' which is in Col_5 while the 'FcType_IOGL' is in Col_3...
Reply typed and finished "a bit quickly" because a Friend just came over... and it's my BDay in 2 hours, ah-ah...!
EDIT:
4 hours later, Friend is gone (home), Post checked on Typos and "Mistakes", I didn't find any... He came a bit "too early", I wanted to post "more Info" in my Reply, OK, didn't have the time, but my Reply is still "correct"...
Oh yeah, and hum, about your "table HTML with 2 rows", I only see 1 Row (of Data), same like your previous Post..., but I think I explained/demonstrated the "Principle" on how to extract with several Rows of Data...
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...