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 GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider NickolaS)

Status:	Closed
Budget:	$30-250
Created:	06/05/2008 at 11:57 EDT
Bidding Ends:	06/10/2008 at 11:57 EDT
Project Creator:	jzender   Buyer Rating: (No Feedback Yet)
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
Job Type:	Data Processing Script Installation XML
Database:	MS SQL
Operating system:	Linux
Bid count:	9
Average bid:	$ 184