I've been looking for a useful tool for data mining, and I hope I have found one iMacros! So far so good, apart from the fact that I'm having difficulty with my very first "macro". I would appreciate any help
I am having issues with extracting the data from a LOOP into a CSV. The code is as follows:
The problem is that it's saving multiple CSV's. I believe this is because I don't know how to place the "save extracted data" command outside the loop. Ultimately, I would like it to save each set of extracted data into ONE CSV and separated by new line / row.VERSION BUILD=7401598
TAB T=1
SET !EXTRACT_TEST_POPUP NO
TAB CLOSEALLOTHERS
URL GOTO=xxxxx (URL REMOVED DUE TO BEING A PRIVATE LINK)
TAG POS={{!LOOP}} TYPE=TD FORM=ID:form1 ATTR=TXT:2011/12*
TAG POS=20 TYPE=TD FORM=ID:form1 ATTR=TXT:* EXTRACT=TXT
TAG POS=22 TYPE=TD FORM=ID:form1 ATTR=TXT:* EXTRACT=TXT
TAG POS=34 TYPE=TD FORM=ID:form1 ATTR=TXT:* EXTRACT=TXT
TAG POS=38 TYPE=TD FORM=ID:form1 ATTR=TXT:* EXTRACT=TXT
TAG POS=42 TYPE=TD FORM=ID:form1 ATTR=TXT:* EXTRACT=TXT
TAG POS=8 TYPE=TD FORM=ID:form1 ATTR=TXT:* EXTRACT=TXT
TAG POS=66 TYPE=TD FORM=ID:form1 ATTR=CLASS:labelBold EXTRACT=TXT
BACK
WAIT SECONDS=1
SAVEAS TYPE=EXTRACT FOLDER=C:\iMacrosExports\ FILE=Extract_{{!NOW:ddmmyy_hhnnss}}.csv
Essentially, I would like it to do the following:
Any help would be greatly appreciated.LOOP {
GO TO PRODUCT
EXTRACT DATA
}
Save data as ONE CSV file with each 'result set' as a NEW LINE or ROW.