Extract and save to .CSV + LOOP

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.

Extract and save to .CSV + LOOP

by maryread on Sun Feb 21, 2016 8:00 am

VERSION BUILD=11.0.246.4051
Windows 8.1
IE11
Included demo macros work ok
the included VBS sample scripts run ok
encounter the same problm with iMacros IE, Firefox, Chrome

Hello,

It's my 1st macro so being indulgent :oops:
I didn't find solution in Wiki, FAQ and this forum.

My macro is about data extraction and saving into a .CSV

VERSION BUILD=11.0.246.4051
TAB T=1
TAB CLOSEALLOTHERS
SET !PLAYBACKDELAY 0.2
URL GOTO=http://annuaire.agencebio.org/resultats?categorie=2&nom=&product=145&activite=0
TAG POS=1 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT SET !EXTRACT {{!COL1}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT SET !EXTRACT {{!COL2}}
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT SET !EXTRACT {{!COL3}}
TAG POS=16 TYPE=SPAN ATTR=* EXTRACT=TXT SET !EXTRACT {{!COL4}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT SET !EXTRACT {{!COL5}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT SET !EXTRACT {{!COL6}}
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv
BACK
TAG POS=2 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT SET !EXTRACT {{!COL1}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT SET !EXTRACT {{!COL2}}
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT SET !EXTRACT {{!COL3}}
TAG POS=16 TYPE=SPAN ATTR=* EXTRACT=TXT SET !EXTRACT {{!COL4}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT SET !EXTRACT {{!COL5}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT SET !EXTRACT {{!COL6}}
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv

etc. etc. (there is x15 " TAG POS=* TYPE=A ATTR=TXT:en<SP>savoir<SP>+ " per page)


This website is a directory. My goal is to extract contact informations for each company and save it into an excel file (1 company per line) :|
I didn't find command to extract each text element, put each element into an excel column, and save all into a .csv

Many thanks for your help
Last edited by maryread on Mon Feb 22, 2016 5:12 am, edited 1 time in total.
maryread
 
Posts: 5
Joined: Sun Feb 21, 2016 7:39 am

Re: Extract and save to .CSV

by chivracq on Sun Feb 21, 2016 8:39 am

maryread wrote:VERSION BUILD=11.0.246.4051
Windows 8.1
IE11
Included demo macros work ok
the included VBS sample scripts run ok
encounter the same problm with iMacros IE, Firefox, Chrome

Hello,

It's my 1st macro so being indulgent :oops:
I didn't find solution in Wiki, FAQ and this forum.

My macro is about data extraction and saving into a .CSV

Code: Select all
VERSION BUILD=11.0.246.4051
TAB T=1
TAB CLOSEALLOTHERS
SET !PLAYBACKDELAY 0.2
URL GOTO=http://annuaire.agencebio.org/resultats?categorie=2&nom=&product=145&activite=0
TAG POS=1 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT SET !EXTRACT {{!COL1}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT SET !EXTRACT {{!COL2}}
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT SET !EXTRACT {{!COL3}}
TAG POS=16 TYPE=SPAN ATTR=* EXTRACT=TXT SET !EXTRACT {{!COL4}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT SET !EXTRACT {{!COL5}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT SET !EXTRACT {{!COL6}}
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv
BACK
TAG POS=2 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT SET !EXTRACT {{!COL1}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT SET !EXTRACT {{!COL2}}
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT SET !EXTRACT {{!COL3}}
TAG POS=16 TYPE=SPAN ATTR=* EXTRACT=TXT SET !EXTRACT {{!COL4}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT SET !EXTRACT {{!COL5}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT SET !EXTRACT {{!COL6}}
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv


etc. etc. (there is x15 " TAG POS=* TYPE=A ATTR=TXT:en<SP>savoir<SP>+ " per page)

This website is a directory. My goal is to extract contact informations for each company and save it into an excel file (1 company per line) :|
I didn't find command to extract each text element, put each element into an excel column, and save all into a .csv

Many thanks for your help

Ouille-ouille-ouille...! You are making a little mess with your Script as you are mixing Data Extraction (and saving to a .CSV File) and using a .CSV File as a DataSource (to fill in some Form for example). And above that, you include 2 Statements per Line, ouaf-ouaf...!

Your Script should look like that...: (I've commented out the wrong/unnecessary parts...)
Code: Select all
VERSION BUILD=11.0.246.4051
TAB T=1
TAB CLOSEALLOTHERS
SET !PLAYBACKDELAY 0.2
URL GOTO=http://annuaire.agencebio.org/resultats?categorie=2&nom=&product=145&activite=0
TAG POS=1 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT
'SET !EXTRACT {{!COL1}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT
'SET !EXTRACT {{!COL2}}
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT
'SET !EXTRACT {{!COL3}}
TAG POS=16 TYPE=SPAN ATTR=* EXTRACT=TXT
'SET !EXTRACT {{!COL4}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT
'SET !EXTRACT {{!COL5}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT
'SET !EXTRACT {{!COL6}}
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv
BACK

' Etc...!!
TAG POS=2 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT SET !EXTRACT {{!COL1}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT SET !EXTRACT {{!COL2}}
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT SET !EXTRACT {{!COL3}}
TAG POS=16 TYPE=SPAN ATTR=* EXTRACT=TXT SET !EXTRACT {{!COL4}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT SET !EXTRACT {{!COL5}}
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT SET !EXTRACT {{!COL6}}
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv

You do 6 EXTRACCT's in a row, iMacros will automatically save those 6 Extracts in 6 Columns for you when you call the 'SAVEAS' Command.
- (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: 6471
Joined: Sat Apr 13, 2013 6:07 am
Location: Amsterdam (NL)

Re: Extract and save to .CSV

by maryread on Sun Feb 21, 2016 11:38 am

Thanks for your answer chivracq :)

I test this new version of my script :

VERSION BUILD=11.0.246.4051
TAB T=1
TAB CLOSEALLOTHERS
SET !PLAYBACKDELAY 0.2
URL GOTO=http://annuaire.agencebio.org/resultats?categorie=2&nom=&product=145&activite=0
TAG POS=1 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT
TAG POS=16 TYPE=SPAN ATTR=* EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT
BACK
TAG POS=2 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT
TAG POS=16 TYPE=SPAN ATTR=* EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv


It runs, this script is ok

But in my excel file, after convert my CSV data, it looks like :
company name | leader name | adress | phone | mail | website | company name | leader name | adress | phone | mail | website | company name | leader name | adress | phone | mail | website

Whereas it's better like this (1 company informations per line)
company name | leader name | adress | phone | mail | website
company name | leader name | adress | phone | mail | website
company name | leader name | adress | phone | mail | website

How can I do in my script to extract data like this ?
maryread
 
Posts: 5
Joined: Sun Feb 21, 2016 7:39 am

Re: Extract and save to .CSV

by chivracq on Sun Feb 21, 2016 11:57 am

maryread wrote:Thanks for your answer chivracq :)

I test this new version of my script :

Code: Select all
VERSION BUILD=11.0.246.4051
TAB T=1
TAB CLOSEALLOTHERS
SET !PLAYBACKDELAY 0.2
URL GOTO=http://annuaire.agencebio.org/resultats?categorie=2&nom=&product=145&activite=0
TAG POS=1 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT
TAG POS=16 TYPE=SPAN ATTR=* EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT
BACK
TAG POS=2 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT
TAG POS=16 TYPE=SPAN ATTR=* EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv



It runs, this script is ok

But in my excel file, after convert my CSV data, it looks like :
company name | leader name | adress | phone | mail | website | company name | leader name | adress | phone | mail | website | company name | leader name | adress | phone | mail | website

Whereas it's better like this (1 company informations per line)
company name | leader name | adress | phone | mail | website
company name | leader name | adress | phone | mail | website
company name | leader name | adress | phone | mail | website

How can I do in my script to extract data like this ?

Yep, normal, you've now removed the 'SAVEAS' after the first 6 Extracts corresponding to the first Company, you need to issue one 'SAVEAS' for each Company, i.e. after every 6 Extracts, before the 'BACK'... So your Script should look like this:
Code: Select all
VERSION BUILD=11.0.246.4051
TAB T=1
TAB CLOSEALLOTHERS
SET !PLAYBACKDELAY 0.2
URL GOTO=http://annuaire.agencebio.org/resultats?categorie=2&nom=&product=145&activite=0
TAG POS=1 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT
TAG POS=16 TYPE=SPAN ATTR=* EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv
BACK
TAG POS=2 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT
TAG POS=16 TYPE=SPAN ATTR=* EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv


EDIT:
And hum, your 'SAVEAS' doesn't look too good either, because every time you'll be saving Data to your .CSV, you will already be a few Seconds further and you will end up saving the Data in different Files, you need to remove at least the "nnss" Format to '!NOW' in order to create one File per Hour..., or one File per Day, what you want... (And it's better to use "yyyymmdd" rather than 'ddmmyy" if you want your Files to be easily recognizable alphabetically...)
- (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: 6471
Joined: Sat Apr 13, 2013 6:07 am
Location: Amsterdam (NL)

Re: Extract and save to .CSV

by maryread on Sun Feb 21, 2016 1:53 pm

Youpi :o
Thank you !!
(n.b. "ddmmyy" instead of "yyyymmdd" it's because i'm French :lol: )

My script is almost finished :roll:
I'm looking for a solution to scrap all data from the 128 pages of this directory.

My script works on the first page, and it goes to the next page thanks to :
TAG POS=1 TYPE=A ATTR=TXT:suivant<SP>›


But how can I repeat the same actions on this page 2, 3 etc. until 128 (or more) ? a Loop ?
maryread
 
Posts: 5
Joined: Sun Feb 21, 2016 7:39 am

Re: Extract and save to .CSV

by chivracq on Sun Feb 21, 2016 3:23 pm

maryread wrote:Youpi :o
Thank you !!
(n.b. "ddmmyy" instead of "yyyymmdd" it's because i'm French :lol: )

My script is almost finished :roll:
I'm looking for a solution to scrap all data from the 128 pages of this directory.

My script works on the first page, and it goes to the next page thanks to :
TAG POS=1 TYPE=A ATTR=TXT:suivant<SP>›


But how can I repeat the same actions on this page 2, 3 etc. until 128 (or more) ? a Loop ?

"... it's because i'm French..." => Yep, nobody is perfect, my Dear...! :shock:

I haven't looked at your Site but from the 2 Sections in your Script, it looks like only this "TAG POS=1 TYPE=A ATTR=TXT:suivant<SP>" is incrementing with "POS=2" / "POS=3", etc..., meaning that you can probably simply use '!LOOP' to loop your Macro:
Code: Select all
TAG POS={{!LOOP}} TYPE=A ATTR=TXT:suivant<SP>

That is if all 128 Results are displayed on the same Page...

If there are only 20 Results per Page (for example) and every 20 Results, you need to go to a 'Next Page', you will need to use a "Nested Loop" and to compute a 0/1 using 'EVAL()' (+ 'floor()' or 'ceil()') to use with 'POS=n' Modulo[20] to click on the 'Next Page' Button/Link only for !LOOP=20/40/60/etc...

Hum, and I guess I'm not perfect either, as I happen to be French as well... Oops...! :oops: (Pataper-pataper...!!)
- (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: 6471
Joined: Sat Apr 13, 2013 6:07 am
Location: Amsterdam (NL)

Re: Extract and save to .CSV

by maryread on Mon Feb 22, 2016 2:54 am

Houla, it seems complicated :?

Actually, there are 15 results per page, so every 15 results I have to go to "Next page"...

BUT, with Autopager firefox add-on, I can show all results on a same page. No need to manage pagination anymore :D

> So, I just need to repeat this series of action (in bold below) for X times :

VERSION BUILD=11.0.246.4051
SET !ERRORIGNORE YES
SET !EXTRACT_TEST_POPUP NO
TAB T=1
URL GOTO=http://annuaire.agencebio.org/resultats?categorie=2&nom=&product=145&activite=0
TAG POS=1 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy}}.csv
BACK


I don't understand how !LOOP works :?:

Fun that you are French too ^^ I'm living near Belgian border so I regularly go to Amsterdam by train :)
maryread
 
Posts: 5
Joined: Sun Feb 21, 2016 7:39 am

Re: Extract and save to .CSV

by chivracq on Wed Feb 24, 2016 6:44 pm

maryread wrote:Houla, it seems complicated :?

Actually, there are 15 results per page, so every 15 results I have to go to "Next page"...

BUT, with Autopager firefox add-on, I can show all results on a same page. No need to manage pagination anymore :D

> So, I just need to repeat this series of action (in bold below) for X times :

Code: Select all
VERSION BUILD=11.0.246.4051
SET !ERRORIGNORE YES
SET !EXTRACT_TEST_POPUP NO
TAB T=1
URL GOTO=http://annuaire.agencebio.org/resultats?categorie=2&nom=&product=145&activite=0
TAG POS=1 TYPE=A ATTR=TXT:en<SP>savoir<SP>+
TAG POS=2 TYPE=DIV ATTR=CLASS:band_sqr EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:fn EXTRACT=TXT
TAG POS=1 TYPE=DIV ATTR=CLASS:adr EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:email EXTRACT=TXT
TAG POS=1 TYPE=SPAN ATTR=CLASS:url EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Extract_{{!NOW:ddmmyy}}.csv
BACK


I don't understand how !LOOP works :?:

Fun that you are French too ^^ I'm living near Belgian border so I regularly go to Amsterdam by train :)

Yep, French People are fun..., ah-ah...!

But, hum, you were supposed to use the iMB from your FCI, the 'AutoPager' Add-on is only for FF, and not even for FF44, my FF Test Version, I managed to install it but it screwed quite a few things, which I managed to get right again...

But, your last 2 Qt's were a bit "naive" (I don't want to use "stupid"), did you find the Answer...?
(Instead of owing me 1 Beer if you come to A'dam, your Negative Credit will increment like '!LOOP' for every Line I will need to type to answer...!! :twisted: (Hum, and I can be VERY verbose, for the good Cause...!))

Hum..., and not sure if I should get proud of it, but that's actually a good Tip (...!), I think that most of the most "Creative" Solutions I've ever found on this Forum for some (very) tricky Qt/Pb's I've found on my way back Home after some Visit at this Local Brewery... Oops...!? :shock:
- (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: 6471
Joined: Sat Apr 13, 2013 6:07 am
Location: Amsterdam (NL)

Re: Extract and save to .CSV + LOOP

by maryread on Thu Feb 25, 2016 3:11 am

My AutoPager work very fine with my FF... Sorry for your version

I don't get the interest of your answer. Probably because I'm stupid...

Thanks for your first answer to my topic.
No need to reply to me anymore.
maryread
 
Posts: 5
Joined: Sun Feb 21, 2016 7:39 am

Re: Extract and save to .CSV + LOOP

by chivracq on Thu Feb 25, 2016 1:01 pm

maryread wrote:My AutoPager work very fine with my FF... Sorry for your version

I don't get the interest of your answer. Probably because I'm stupid...

Thanks for your first answer to my topic.
No need to reply to me anymore.

Yep, don't worry about 'AutoPager', I only installed it because you mentioned it, to have a look as it could come in handy for other Users, we regularly get Threads about Nested Loops and they can be a bit tricky in pure '.iim' and nobody seems to understand how they work... :roll: , so this Add-on could provide some "easy" Workaround...

Didn't mean to offend you with the rest of my last Reply, I was actually just checking in what I thought was some "humoristic" way if you found out to use ' !LOOP' which is just a simple Built-in Var incrementing itself on every Loop and is mostly used for '!DATASOURCE_LINE' when using a DataSource or 'POS={{!LOOP}}' like in your case, which I btw had already mentioned in some earlier Post..., and checking a bit if you got your Final Script to work, which must be the case, I guess, as you didn't mention it anymore...

Well, glad I could help a bit, and sorry for my "faulty" humour, oops... :oops:
I DJ/VJ on a funny/crazy Boat nearly every Friday evening/night, "Ze_place_to_be_in_A'dam_every_Friday...!", google or check FB on "Azart", next time you are in Amsterdam... :idea:
(And I give regularly Talks and Demos in A'dam on how I use iMacros in Extreme/Creative/AI-QD Programming Events, but that might still be a bit too high Level... :twisted: )
- (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: 6471
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 1 guest

-->