Search found 6 matches

by JTBProductions
Fri Aug 06, 2010 3:25 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Data Extraction Help!
Replies: 1
Views: 739

Re: Data Extraction Help!

Seems like i'm gunna need to extract the entire paragraph as a whole, and then write some code to interpret/manipulate the string....

any help writing this in visual basic would be extremely appreciated, thanks
by JTBProductions
Wed Aug 04, 2010 6:19 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Date calculations.
Replies: 1
Views: 643

Re: Date calculations.

You can try using a combination of VBS, iMacros and Excel Use VBS to populate the excel spreadsheet with your dates, then using VBS, Macros and the iMacros Browser (or IE) you can fill in the fields based off of the data in the excel sheet. Check Here http://wiki.imacros.net/Form_Filling#Input_from_...
by JTBProductions
Wed Aug 04, 2010 6:12 pm
Forum: Data Extraction and Web Screen Scraping
Topic: SET !ERRORIGNORE YES - ERROR
Replies: 2
Views: 1396

Re: SET !ERRORIGNORE YES - ERROR

Not seeing anything that should result in an error. What is the readout?

You can try moving the SET !ERRORIGNORE YES to the beginning of the macro, either before or after:

Code: Select all

CMDLINE !DATASOURCE cb.csv
SET !DATASOURCE_COLUMNS 2
by JTBProductions
Wed Aug 04, 2010 6:00 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Data Extraction Help!
Replies: 1
Views: 739

Data Extraction Help!

Hi, i'm trying to extract the following data from this block of html: <strong>UPC Code:</strong> 050332154483<br> <strong>Estimated Retail Price:</strong> 2,299.99<br> <strong>D&H Returns Allowed:</strong> yes<br> <strong>Return Period (Days):</strong> 50<br> <strong>Manufacturer...
by JTBProductions
Mon Jun 07, 2010 2:57 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Wait for User Input
Replies: 3
Views: 1038

Re: Wait for User Input

This is not a problem. I do this today with one thing I have written. I usually have iMacros/Excel do most of the navigation but not always. You will need to learn some VBA. You will probably need the scripting edition. Thanks for the info Bill, I was wondering, since you have already written a VBA...
by JTBProductions
Thu Jun 03, 2010 8:13 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Wait for User Input
Replies: 3
Views: 1038

Wait for User Input

Hey guys, here's what I'd like to do: Click a button within Excel that launches iMacros to a predetermined web page, logs in, and then waits. After logging in automatically, the user navigates to the page he'd like to scrape, and then instructs the macro to continue. If this is at all possible, plea...