HOW TO COPY DATA ON A WEB-PAGE AND PAST TO CSV FILE

Discussions and Tech Support related to website data extraction, screen scraping and data mining using iMacros.
Forum rules
iMacros EOL - Attention!

The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.

Thank you again for your business and support.

Sincerely,
The Progress Team

Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
Post Reply
Ebijo27
Posts: 1
Joined: Wed Aug 01, 2018 10:36 am

HOW TO COPY DATA ON A WEB-PAGE AND PAST TO CSV FILE

Post by Ebijo27 » Wed Aug 01, 2018 11:41 am

Hi My fellow Imacros Users,


I am running a imacros code that should enable me copy the balance of a cryptocurrency balance on https://tokenbalance.com/ and past it to csv file on my computer. I try using the extract function but it not working, please i need your asistant. See detalis below:

Code: Select all

VERSION BUILD=1003 RECORDER=CR
SET !EXTRACT_TEST_POPUP NO
URL GOTO=https://tokenbalance.com/
TAG POS=1 TYPE=INPUT:TEXT ATTR=ID:etheraddr CONTENT=0xB4D11A36d08695d13FCE93528412EEd7b24b8580
TAG POS=1 TYPE=INPUT:TEXT ATTR=ID:contractaddr CONTENT=0x177d39ac676ed1c67a2b268ad7f1e58826e5b0af
TAG POS=1 TYPE=A ATTR=ID:getbalancebtn
Wait Seconds=15
TAG POS=1 TYPE=SPAN ATTR=ID:coinbalance EXTRACT = TXT
User avatar
JamesBassdrop
Posts: 7
Joined: Sun Jul 29, 2018 8:51 pm
Location: Canada
Contact:

Re: HOW TO COPY DATA ON A WEB-PAGE AND PAST TO CSV FILE

Post by JamesBassdrop » Wed Aug 01, 2018 8:53 pm

Ebijo27 wrote:Hi My fellow Imacros Users,

I am running a imacros code that should enable me copy the balance of a cryptocurrency balance on https://tokenbalance.com/ and past it to csv file on my computer. I try using the extract function but it not working, please i need your asistant. See detalis below:

Code: Select all

VERSION BUILD=1003 RECORDER=CR
SET !EXTRACT_TEST_POPUP NO
URL GOTO=https://tokenbalance.com/
TAG POS=1 TYPE=INPUT:TEXT ATTR=ID:etheraddr CONTENT=0xB4D11A36d08695d13FCE93528412EEd7b24b8580
TAG POS=1 TYPE=INPUT:TEXT ATTR=ID:contractaddr CONTENT=0x177d39ac676ed1c67a2b268ad7f1e58826e5b0af
TAG POS=1 TYPE=A ATTR=ID:getbalancebtn
Wait Seconds=15
TAG POS=1 TYPE=SPAN ATTR=ID:coinbalance EXTRACT = TXT
Hi Ebijo27,

Try removing the spaces between EXTRACT and TXT on the last line:

Code: Select all

TAG POS=1 TYPE=SPAN ATTR=ID:coinbalance EXTRACT=TXT
iMacros for Firefox v8.9.7 | Firefox 56.0.2, Firefox 52 ESR, Pale Moon 27.9.4
I compare performance using all 3 browsers while troubleshooting but there's rarely a discernible difference. [Installed on PM using "Moon Tester Tool" add-on]
User avatar
JamesBassdrop
Posts: 7
Joined: Sun Jul 29, 2018 8:51 pm
Location: Canada
Contact:

Re: HOW TO COPY DATA ON A WEB-PAGE AND PAST TO CSV FILE

Post by JamesBassdrop » Thu Aug 02, 2018 1:40 am

Also, to save the data to CSV, you'll want to:

Code: Select all

SAVEAS TYPE=EXTRACT FOLDER=* FILE=coinbalance.csv
To keep only the most recent data, you'll have to delete the existing CSV file before SAVEAS runs (otherwise SAVEAS will add rows to the existing file):

Code: Select all

FILEDELETE NAME=coinbalance.csv
(Note: "coinbalance.csv" will be located in your iMacros "Downloads" folder.)
iMacros for Firefox v8.9.7 | Firefox 56.0.2, Firefox 52 ESR, Pale Moon 27.9.4
I compare performance using all 3 browsers while troubleshooting but there's rarely a discernible difference. [Installed on PM using "Moon Tester Tool" add-on]
User avatar
emililadjet
Posts: 2
Joined: Sun Jul 29, 2018 2:18 pm

Re: HOW TO COPY DATA ON A WEB-PAGE AND PAST TO CSV FILE

Post by emililadjet » Sun Aug 05, 2018 3:34 pm

JamesBassdrop wrote:Also, to save the data to CSV, you'll want to:

Code: Select all

SAVEAS TYPE=EXTRACT FOLDER=* FILE=coinbalance.csv
To keep only the most recent data, you'll have to delete the existing CSV file before SAVEAS runs (otherwise SAVEAS will add rows to the existing file):

Code: Select all

FILEDELETE NAME=coinbalance.csv
(Note: "coinbalance.csv" will be located in your iMacros "Downloads" folder.)
Hello JamesBassdrop,
Thank you for your reply
is if we have a .txt file, I think it's the same thing?
21 fascinating ideas on the Inspired Word of Eternal God
Post Reply