Multiple Tables to 1 excel file?

Support for iMacros. The iMacros software is the unique solution for automating every activity inside a web browser, for data extraction and web testing.

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.

Multiple Tables to 1 excel file?

by Lphenneger on Fri Feb 24, 2017 10:12 am

I am attempting to tables demo page (http://demo.imacros.net/Automate/ExtractDemo), and to get both tables at the same time on the same excel sheet. Is this possible? I tried this
"VERSION BUILD=11.5.499.3066
TAB T=1
TAB CLOSEALLOTHERS
SET !EXTRACT_TEST_POPUP NO
SET !PLAYBACKDELAY 0.2
URL GOTO=http://demo.imacros.net/Automate/ExtractDemo
TAG POS=1 TYPE=TABLE ATTR=TXT:* EXTRACT=TXT
TAG POS=2 TYPE=TABLE ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=C:\Users\lphenneger\Documents FILE=LarryTable_{{!NOW:yymmdd_hhnnss}}.csv"

But I just get two lines from the second table.

Larry
Lphenneger
 
Posts: 1
Joined: Fri Feb 24, 2017 9:55 am

Re: Multiple Tables to 1 excel file?

by chivracq on Fri Mar 10, 2017 5:01 pm

Lphenneger wrote:I am attempting to tables demo page (http://demo.imacros.net/Automate/ExtractDemo), and to get both tables at the same time on the same excel sheet. Is this possible? I tried this
"
Code: Select all
VERSION BUILD=11.5.499.3066
TAB T=1
TAB CLOSEALLOTHERS
SET !EXTRACT_TEST_POPUP NO
SET !PLAYBACKDELAY 0.2
URL GOTO=http://demo.imacros.net/Automate/ExtractDemo
TAG POS=1 TYPE=TABLE ATTR=TXT:* EXTRACT=TXT
TAG POS=2 TYPE=TABLE ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=C:\Users\lphenneger\Documents FILE=LarryTable_{{!NOW:yymmdd_hhnnss}}.csv
"

But I just get two lines from the second table.

Larry

Tja sorry, never replied in this Thread as you had not mentioned your FCI, even if I had done a little bit of Testing when you had posted...
Similar Thread where I give some bit of Explanation / and a possible Solution/Workaround...:
- Re: CSV formatting issue with Firefox imacro data extraction

Your FCI is still missing in this Thread btw, and you should have bumped it already a while ago and/or shared your Solution if you managed to solve it by yourself...
- (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: 6479
Joined: Sat Apr 13, 2013 6:07 am
Location: Amsterdam (NL)


Return to General Support & Discussions

Who is online

Users browsing this forum: No registered users and 4 guests

-->