TABLE: Extract Data Row by Row...

Discussions and Tech Support related to website data extraction, screen scraping and data mining using iMacros.

Moderators: Community Moderators, iMacros Moderators

Forum rules
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the Google search box (at the top of each forum page) to see if a similar problem or question has already been addressed. This will search the entire contents of the forums as well as the iMacros Wiki.
3. We can respond much faster to your posts if you include the following information:

CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST

Answering your own posts (e.g. attempting to "bump" your topic) drops your topic from the list of unanswered threads, so it may actually receive less views.

TABLE: Extract Data Row by Row...

by pandax on Fri Feb 03, 2017 12:21 am

iMacros: 10.4.28.1074
Firefox: 50.1.0
OS: Windows 8.1 Pro


I come up with a solution like this to extract the first 5 row of a table from this website: "https://datatables.net/examples/data_sources/js_array.html"

My question: Is there a way to shorten the query like to extract the full row instead of every cell in a row?

Code: Select all
VERSION BUILD=10.4.28.1074
TAB T=1
TAB CLOSEALLOTHERS
SET !EXTRACT_TEST_POPUP NO
URL GOTO=https://datatables.net/examples/data_sources/js_array.html
TAG POS=1 TYPE=TD ATTR=TXT:Airi<SP>Satou
TAG POS=1 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=2 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=3 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=4 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=5 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=6 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=2 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=8 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=9 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=10 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=11 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=12 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=3 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=14 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=15 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=16 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=17 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=18 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=4 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=20 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=21 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=22 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=23 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=24 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=5 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=26 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=27 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=28 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=29 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=30 TYPE=TD ATTR=* EXTRACT=TXT
Last edited by pandax on Fri Feb 03, 2017 9:30 am, edited 1 time in total.
pandax
 
Posts: 3
Joined: Thu Feb 02, 2017 4:49 pm

Re: TABLE: Extract Data Row by Row?

by chivracq on Fri Feb 03, 2017 8:36 am

pandax wrote:
Code: Select all
iMacros: 10.4.28.1074
Firefox: 50.1.0
OS: Windows 8.1 Pro

I come up with a solution like this to extract the first 5 row of a table from this website:
"https://datatables.net/examples/data_sources/js_array.html"

My question: Is there a way to shorten the query like to extract the full row instead of every cell in a row?
Code: Select all
VERSION BUILD=10.4.28.1074
TAB T=1
TAB CLOSEALLOTHERS
SET !EXTRACT_TEST_POPUP NO
URL GOTO=https://datatables.net/examples/data_sources/js_array.html
TAG POS=1 TYPE=TD ATTR=TXT:Airi<SP>Satou
TAG POS=1 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=2 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=3 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=4 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=5 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=6 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=2 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=8 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=9 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=10 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=11 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=12 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=3 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=14 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=15 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=16 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=17 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=18 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=4 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=20 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=21 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=22 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=23 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=24 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=5 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=26 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=27 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=28 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=29 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=30 TYPE=TD ATTR=* EXTRACT=TXT

Yep, there is always a way in iMacros (and usually more than one), ah-ah...! :D

Before I give you some possible Solutions, I would like to know the Reason why you want to extract the Data from this Table Row by Row...?
Is is because of (1) Speed or is it because of "Maintenance Headache" (2) with all those 'POS=n'...?
Or is it because, not shown in your Script what you do with all those Extracts, but I reckon you save the Data to some '.CSV' File with 'SAVEAS'...?, and indeed, your Data will currently be saved in one big Row with 30 Cells (3).

If it is because of (3), you need to insert a 'SAVEAS' every 6 Extracts at the end of each Row:
Code: Select all
URL GOTO=https://datatables.net/examples/data_sources/js_array.html

TAG POS=1 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=2 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=3 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=4 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=5 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=6 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
TAG POS=2 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=8 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=9 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=10 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=11 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=12 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
TAG POS=3 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=14 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=15 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=16 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=17 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=18 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
TAG POS=4 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=20 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=21 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=22 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=23 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=24 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
TAG POS=5 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=26 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=27 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=28 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=29 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=30 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}


Now for Reason (2), for Maintenance Ease, if you want to quickly be able to modify your Script to add/remove Rows, you can use Relative Positioning as you've already managed to identify the first Cell of each Row with an "easy" 'TAG POS=1' / 'TAG POS=2' / etc... for each Row:
Code: Select all
URL GOTO=https://datatables.net/examples/data_sources/js_array.html

TAG POS=1 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
TAG POS=2 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
TAG POS=3 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
TAG POS=4 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
TAG POS=5 TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
Like that, you only have to take care of the 'POS=n' for each first Cell in a Row and quickly copy&paste Blocks if you want to add Rows.

Or even easier and you then don't even have to take care of the 'POS=n' for each Row and you can "blindly" copy&paste the Block, is to use the following "Trick":
Code: Select all
URL GOTO=https://datatables.net/examples/data_sources/js_array.html
SET Row_Nb 0

ADD Row_Nb 1
TAG POS={{Row_Nb}} TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
ADD Row_Nb 1
TAG POS={{Row_Nb}} TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
ADD Row_Nb 1
TAG POS={{Row_Nb}} TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
ADD Row_Nb 1
TAG POS={{Row_Nb}} TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
ADD Row_Nb 1
TAG POS={{Row_Nb}} TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}

And the Code above could easily be used with just one Block to loop... :idea:

Hum..., and not sure if you are aware of it, but you can extract the whole Table in just one Statement, with Table Header and all Rows of Data:
Code: Select all
URL GOTO=https://datatables.net/examples/data_sources/js_array.html

TAG POS=1 TYPE=TABLE ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}

Well, I hope this answers your Qt, give more Details otherwise on why and what you want exactly and what the Pb is...?

>>>

Oh...!, and your Thread Title is not very-very usefully Descriptive, only the Term "Table" is relevant, as all Threads on this Sub-Forum are about "Extract Data from a...", a better Thread Title could be: "TABLE: Extract Data Row by Row?". (You can still edit your Post and your Thread Title...)
(A Descriptive Thread Title is important for other Users searching the Forum with a similar Case/Question to know what a Thread is about without having to read the whole Thread...)
- (F)CIM = (Full) Config Info Missing: iMacros + Browser + OS with all 3 Versions...
- I usually don't even read the Question if that (required) Info is not mentioned...
- Script & URL usually help a lot for a more "educated" Help...
chivracq
 
Posts: 5980
Joined: Sat Apr 13, 2013 6:07 am
Location: Amsterdam (NL)

Re: TABLE: Extract Data Row by Row...

by pandax on Fri Feb 03, 2017 11:22 am

Thank you very much for a detail explanation on how to extract data from a table.
You are right I did not mention clearly how I want to extract the data.
My initial wish is to extract data row-by-row to speed up the process as you explain in the first 2 examples.
But when you show the third option which could extract data as a whole, then this is really what I want but I did not know that iMacros could handle that.

I have another question though, in the example #2 that you show me, is there a way kind like looping so that you could enter a block of data once and start the execution from the beginning of that block like this:

Code: Select all
URL GOTO=https://datatables.net/examples/data_sources/js_array.html
SET Row_Num 1
TAG POS={{Row_Num}} TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
ADD Row_Num 1
IF (Row_Num < 10)
   GOTO LINE "TAG POS={{Row_Num}} TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
ELSE
   EXIT
ENDIF
pandax
 
Posts: 3
Joined: Thu Feb 02, 2017 4:49 pm

Re: TABLE: Extract Data Row by Row...

by chivracq on Fri Feb 03, 2017 12:46 pm

pandax wrote:Thank you very much for a detail explanation on how to extract data from a table.
You are right I did not mention clearly how I want to extract the data.
My initial wish is to extract data row-by-row to speed up the process as you explain in the first 2 examples.
But when you show the third option which could extract data as a whole, then this is really what I want but I did not know that iMacros could handle that.

I have another question though, in the example #2 that you show me, is there a way kind like looping so that you could enter a block of data once and start the execution from the beginning of that block like this:

Code: Select all
URL GOTO=https://datatables.net/examples/data_sources/js_array.html
SET Row_Num 1
TAG POS={{Row_Num}} TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}
'>
ADD Row_Num 1
IF (Row_Num < 10)
   GOTO LINE "TAG POS={{Row_Num}} TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
ELSE
   EXIT
ENDIF

OK, good to hear that 'TYPE=TABLE' was actually what you were looking for, and this is actually the "Standard" way to extract Tables.
It doesn't always work, on complex Pages for example with several Tables, then it can be tricky to find out which one is "your" Table, or if you don't want all the Data from the Table.
Hum, and that Example was Example #4 from my Post, not #3.

... Just like your "Example #2" was "Example #3" in my Post...
But yep, to only use one Block of Code to extract 1 Row and to loop the Script with the 'Play (Loop)' Button from the iMacros Side-Panel, you can easily adapt the Script to base it on '!LOOP':
Code: Select all
'URL GOTO=https://datatables.net/examples/data_sources/js_array.html
SET !LOOP 1
TAG POS={{!LOOP}} TYPE=TD ATTR=CLASS:sorting_1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Tablename_{{!NOW:yyyymmdd}}

=> If you want to extract the first 10 Rows of Data, you simply specify "10" in the 'Max' Field and you loop the Script 10 times.
(I have btw disabled the 'URL GOTO' Statement which would otherwise load the Page 10 times (for each Loop), which usually takes the longest time, it is better to first load the Page manually...)

Now if you only wanted to extract/save Row #7 for example, you simply edit the Macro with "SET !LOOP 7" and using the 'Play' Button, the Script will extract and save only Row #7.

If you want to extract and save the 3 consecutive Rows #7 until #9, still with "SET !LOOP 7", but you need to specify "9" in the 'Max' Field because otherwise, iMacros will only handle the first Row (=Row #7).

(Because when looping a Macro, iMacros reads the "SET !LOOP n" Statement only on the first Loop to know from which Row (usually when taking Data from a DataSource) it has to start, and it does the +1 Increment automatically for the following Loops until it has reached the 'Max' Value.)

And don't forget after running/looping your Script for Rows [7-9] to edit your Script again with "SET !LOOP 1", otherwise if you forget, next time you want to extract Rows [1-10], it will then only extract Rows [7-10], ah-ah...!
- (F)CIM = (Full) Config Info Missing: iMacros + Browser + OS with all 3 Versions...
- I usually don't even read the Question if that (required) Info is not mentioned...
- Script & URL usually help a lot for a more "educated" Help...
chivracq
 
Posts: 5980
Joined: Sat Apr 13, 2013 6:07 am
Location: Amsterdam (NL)

Re: TABLE: Extract Data Row by Row...

by pandax on Fri Feb 03, 2017 2:09 pm

Thank you once again, that is all I wanted for now. :D
pandax
 
Posts: 3
Joined: Thu Feb 02, 2017 4:49 pm

Re: TABLE: Extract Data Row by Row...

by chivracq on Fri Feb 03, 2017 3:46 pm

pandax wrote:Thank you once again, that is all I wanted for now. :D

8)
- (F)CIM = (Full) Config Info Missing: iMacros + Browser + OS with all 3 Versions...
- I usually don't even read the Question if that (required) Info is not mentioned...
- Script & URL usually help a lot for a more "educated" Help...
chivracq
 
Posts: 5980
Joined: Sat Apr 13, 2013 6:07 am
Location: Amsterdam (NL)


Return to Data Extraction and Web Screen Scraping

Who is online

Users browsing this forum: No registered users and 3 guests

-->