Em Andamento

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]

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.

Habilidades: Linux, Perl, PHP, XML

Ver mais: oscommerce insert mysql, you pull and pay, www kw com, where to find website programmer, where i can find programmer, where i can find a programmer, where do you go to find a programmer, where do i get a programmer, where can i find programmer, where can i find a programmer job, what to do when you can't find a job, what to do if you can't find a job, what do you need to get a manufacturer, what can i do with php and mysql, script to pull data from a website, pull and pay, programmer where i can find one, programmer mysql, programmer find job, programmer can t find a job, perl programmer job, pay by hour, oscommerce 2.3 header php, need a small manufacturer, link no html 5

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

ID do Projeto: #7741

12 freelancers estão ofertando em média $272 para este trabalho

siddhartha1

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

$180 USD in 3 dias
(40 Comentários)
7.6
webxtor

I am an expert in web extraction

$200 USD in 0 dias
(112 Comentários)
5.6
ispg

Please see PMB for more details.

$500 USD in 2 dias
(5 Comentários)
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 Mais

$500 USD in 15 dias
(6 Comentários)
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 Mais

$115 USD em 1 dia
(10 Comentários)
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 Mais

$250 USD in 2 dias
(4 Comentários)
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 Mais

$200 USD in 2 dias
(1 Comentário)
2.5
xenon79

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

$150 USD em 1 dia
(1 Comentário)
1.6
tanuj99

please see pmb for details

$500 USD in 10 dias
(1 Comentário)
3.2
phpXpert

Hire me and consider the job done. My portfolio: [url removed, login to view]

$400 USD in 2 dias
(0 Comentários)
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 in 2 dias
(0 Comentários)
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 in 2 dias
(1 Comentário)
0.0