Project Detail

XML to MySQL conversion with initial and daily update script  

XML to MySQL conversion with initial and daily update script is project number 267694
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: NickolaS

Budget: $30-250

Created: 06/05/2008 at 11:57 EDT

Bid Count: 9

Average Bid:
$ 184

06/10/2008 at 11:57 EDT

Project Creator: jzender
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

Description

Our distributor provides inventory data via XML files with daily updates via FTP that we would like to make automatically available in a MySQL database on our webserver.

The project deliverables include:
- provide script to convert initial XML files into MySQL database
- provide script that downloads update files from an FTP server once a day automatically and add/update/delete data in MySQL database
- email notification to specified email account upon completion of script including any errors.

Data comes in ZIP files with the following naming convention:
<date>_<message_id>_<internal_key>.xml.z
<date>: 8-digit, YYYMMDD
<message-id>: 8-digit, numeric, unique
<internal_key>: 4-digit, alpha

Detailed XML documentation, DTD and schema (http://www.editeur.org/onix) as well as testdata will be provided.
A suggested database structure is also available (in MS Access format), but it can be modified if required.

The daily update files are about 10-25 MB big. Attached is the beginning of one of the daily update files. One thing to mention is that not every product element will include all defined fields. The field tags (e.g. <a002>) are short tag names, but they have corresponding reference names and I have included both in the DB structure.

Please bid only if you are absolute comfortable that you can fullfill this request considering all the information above.




Additional files submitted:
onix.txt

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

250

3 days

05-28-2008 17:09 EDT

Ready to start.

help

 

200

1 day

05-28-2008 14:19 EDT

Hi, please, check your PM

help

 

195

2 days

05-28-2008 13:33 EDT

Hi, I sent you more info in your PMB. Best Regards, Yousef

help

e3d

 

150

2 days

05-28-2008 14:16 EDT

Hello. Please check PM. Thanks

help

 

240

10 days

06-06-2008 08:24 EDT

let start now!

help

 

100

3 days

05-28-2008 21:01 EDT

I can do this job for you. See PM for details.

help

 

175

5 days

05-28-2008 22:37 EDT

Let us work out it.

help

 

200

3 days

06-09-2008 11:15 EDT

Hi!! Am ready to begin

help

 

150

5 days

05-28-2008 21:09 EDT

We can do your job and set it up atumatically so it makes trhe conversion as many times a day as you need

help


    Bid on this Project