En cours

parse HTML and insert into db (mysql)

Hello, We sell digital cameras and need to populate products specs within oscommerce 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.

I would prefer a friendly script - not killing [url removed, login to view] or using a lot of resources.

Here is what the script needs to do:

1. From our db, pull the manufacturer name and sku (i can write in this query).

2. from starting page: [url removed, login to view] insert manufacturer name and sku

3. the product page should be found. The example of "Fuji S5000" will give

[url removed, login to view]+s5000

4. on the right side of this page there will be a box. we need to visit the link that reads: "See product details"

5. from this page is where data will be collected and stored into our db. here is the breakdown

===========================

find:

COLLECT EVERYTHING BETWEEN THIS TAGS

do: "insert into product_desc" into db according to product SKU

find:

// product specs

DoWhile exist

ForEach spec header:

COLLECT THIS TEXT

find spec header info:

COLLECT THIS TEXT

do: insert spec header and spec header info into db according to sku

End ForEach

End DoWhile

Jump to step one

Continue until no more query results from step one

=============================

Ok, that is the breakdown. Now, you do not have to actually write the program as I have indicated but, what is important is that I get all Spec Headers with the correct Spec Header Info. If you want to use arrays, that is fine by me.

I need this script to be in one file - for cron purposes. Since [url removed, login to view] website changes from time to time - I am also looking for the code to be clean in case I need to make modifications. I am not a real programmer but I can modify and make small changes when needed. I can only read clean code.

I need this done ASAP. This job shouldn't take more than 3-4 hours with testing included. I am willing to pay $35/hour or a max of $140. Please don't bid if you can't finish this within 2 days from the closing date of bidding.

Compétences : Linux, Perl, PHP, XML

Voir plus : oscommerce insert mysql, need get manufacturer, script pull data website, pull pay, programmer find one, programmer mysql, perl programmer job, need small manufacturer, need digital advertising, html programmer job, html program code, html date, get found, foreach php mysql, fine products, find programmer job, find programmer code, find perl, find job programmer, find job advertising, buy resources website, buy sell php script, all spec

Concernant l'employeur :
( 7 commentaires ) West Lafayette, United States

N° du projet : #7741

12 freelance ont fait une offre moyenne de 272 $ pour ce travail

siddhartha1

dear sir, we can do it in the above budget and in 2 days or at the max 3 days. Thanx

180 $ USD en 3 jours
(40 Commentaires)
7.6
webxtor

I am an expert in web extraction

200 $ USD en 0 jours
(112 Commentaires)
5.6
ispg

Please see PMB for more details.

500 $ USD en 2 jours
(5 Commentaires)
4.7
crvenk

Our company would like to bid on your project. We will be able to provide you with our expertise in this field and meet your requirements. We have handled similar projects and have got a massive team of 140+ employees Plus

500 $ USD en 15 jours
(6 Commentaires)
4.6
NetHunter

Hi, I have plenty of experience with MySQL/OSC and PHP to build this very quickly and efficiently. I think most of the other bids are overpriced, and so I bid what I think is fair enough. I assure you you won't be disa Plus

115 $ USD en 1 jour
(10 Commentaires)
4.3
jlcreat

Hello, We are capable and willing of putting this script together for you, cleanly coded and commented, and most importantly, completed on time. However, we feel your estimate of 3-4 hrs is really on the low end and Plus

250 $ USD en 2 jours
(4 Commentaires)
3.9
halwasiyainfosys

Dear Sir, We have understood your requirements and can easily do the project as we are having more than 5 years of experience in IT industry and we are India's leading IT company. We offer 100% satisfaction and money Plus

200 $ USD en 2 jours
(1 Commentaire)
2.5
xenon79

Hi, I'll do the job, just need your database structure. Regards, Valentin

150 $ USD en 1 jour
(1 Commentaire)
1.6
tanuj99

please see pmb for details

500 $ USD en 10 jours
(1 Commentaire)
3.2
phpXpert

Hire me and consider the job done. My portfolio: www.amitdeopanwar.com

400 $ USD en 2 jours
(0 Commentaires)
0.0
qcosol

I am interested, Bid is for the complete work as per your specification, I have done many similar site scraping and parsing jobs. Thanks.

140 $ USD en 2 jours
(0 Commentaires)
0.0
erhardsmit

Hello. I can write this script for you in less than 2 days. I have experience with these type of scripts.

130 $ USD en 2 jours
(1 Commentaire)
0.0