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
Problems with downloading pictures
Re: Problems with downloading pictures
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 (,).
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
The Helium Scraper Team
Re: Problems with downloading pictures
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.
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.
Re: Problems with downloading pictures
You would need to create a similar table in your destination database before importing the file.
Juan Soldi
The Helium Scraper Team
The Helium Scraper Team