Em Andamento

Parse HTML and INSERT into mySQL


We sell digital cameras and needs to populate products specs in a quick manner. I am looking for a small script that will extract data from www.shopping.com. Before I go in to details, I do have permission to spider thier site and to use the data since we buy their advertising.

Here is an example page:

[url removed, login to view]

Notice the row in gray, the main Spec Category. The following Sub categories are below. What I need is the data to the right of the sub categories. The HTML is fluent through all digital camera specs. So it should be easy to write the parser to find where to parse and collect and when not to.

So all cameras within:

[url removed, login to view]

need to be parsed. If I am correct, I do beleive they use rdd or xml. Notice the links have xPP and xPF. I guess the parser could check every possible link that has the word digital AND camera then decide to parse the page.

So what needs to be added to the db? The title of the name of the camera - can be collected from header tags TITLE, but only the camera name like FUJI FINEPIX S5000 DIGITAL CAMERA. From there, the specs to be collected then INSERTED into a mysql db which will have the same subcategories name. On the very last row of the specs is a sub category of Product ID, this is not needed.

I need this done ASAP. I suspect it should take 3-4 hours to do this job. I am willing to pay $35/hour or a max of $140.

If you have any questions please reply back. Thanks

Habilidades: ASP, Linux, PHP, XML

Veja mais: parse html mysql, insert html tags mysql, perl parse text insert mysql, parser html mysql insert, parse html insert mysql, awk mysql insert, insert xml mysql, mysql insert parse string, mysql insert html, inserting html tags mysql, parse html insert, where do we find xml, Mysql questions, links html 5, link no html 5, link html 5, i need digital advertising, html 5 link, html 5 header, find a job in advertising

Acerca do Empregador:
( 7 comentários ) West Lafayette, United States

ID do Projeto: #1242

Concedido a:


Hello! It's an interesting project for me... I'm a profy in data extracting applications!

$150 USD em 2 dias
(14 Comentários)

8 freelancers estão ofertando em média $255 nesse trabalho


I am a freelancer working on open source technologies since last three years. I have implemented the similar task in many of my projects. I can complete your task within 3 days. You can view some of my projects for Mais

$100 USD in 3 dias
(292 Comentários)

Dear sir or madam, i wouldlike to suggest youmy experience and strong knowledge. I provide 3 months of support after project will be completed and 24 hours per day online during the project.

$120 USD in 0 dias
(3 Comentários)

Hi! I have done a lot of PPC engines parsing (inside the login area and stuff) and I have complete understanding of spidering and matching in such a manner. I'd like to do the spider and parser in Perl though, which wo Mais

$230 USD in 2 dias
(1 Comentário)

Thank you for the invitation to bid on this project. Relevent experience includes the following: Installation of software, hardware and HTTP servers · Support for on-line documentation, software and code for US and In Mais

$500 USD in 5 dias
(0 Comentários)

The links are straightforward HTML links. You just need an application that will open the [login to view URL] website dig cameras page, parse it to find links and so on repeatedly in a loop, getting down to the page with the Mais

$350 USD in 3 dias
(0 Comentários)

Hi I understand your requirement . and i got 8 years of experience on required skills. I confident that i can give a good solution to you.

$450 USD in 60 dias
(0 Comentários)