Problems with downloading pictures

Questions and answers about anything related to Helium Scraper
Post Reply
cfardon
Posts: 9
Joined: Fri Mar 04, 2011 9:01 am

Problems with downloading pictures

Post by cfardon » Wed Apr 20, 2011 7:44 am

Hi, i am still trying to scrape home....aw.....

The problem i am having is that it won't download the pictures. Well not that IT won't, but i cannot seem to command it to lol.

I have attached the file and my starting address is this.
http://www.homeaway.com/vacation-rentals/europe/r5

When i run it, it always come up with the error that the pictures cannot be downloaded. Any help would be appreciated.

Also, i am a bit of beginner at SQL, i need to put the data up into an sql database that is already prescripted for rentals......can u guide me on a way to export the data to my online sql database?

Thanks again in advance
Chris Fardon
Fardon Webhosting and Design
http://www.fardonwebhosting.com

webmaster
Site Admin
Posts: 494
Joined: Mon Dec 06, 2010 8:39 am
Contact:

Re: Problems with downloading pictures

Post by webmaster » Wed Apr 20, 2011 1:36 pm

Hi Chris,

Make sure the property of the downloaded picture in the "Extract" action is set to "SrcAttribute" and not to "InnerText". This is a general rule for every time you are downloading pictures.

As for how to put your data into your SQL database, if you are using PHP My Admin, there is an option to import from a CSV file. You can export a table from Helium Scraper to a CSV file. You would need to change the "Fields terminated by" option to comma (,).
Juan Soldi
The Helium Scraper Team

cfardon
Posts: 9
Joined: Fri Mar 04, 2011 9:01 am

Re: Problems with downloading pictures

Post by cfardon » Fri Apr 22, 2011 8:53 am

Hi,

Thanks, i had it set to srce att, but it was my mistake on not selecting the pictures properly. when i import into the database, does it give me chance to marry the field headings up? or do i name them the same as the data base.
Chris Fardon
Fardon Webhosting and Design
http://www.fardonwebhosting.com

webmaster
Site Admin
Posts: 494
Joined: Mon Dec 06, 2010 8:39 am
Contact:

Re: Problems with downloading pictures

Post by webmaster » Fri Apr 22, 2011 3:52 pm

You would need to create a similar table in your destination database before importing the file.
Juan Soldi
The Helium Scraper Team

Post Reply