Project Detail

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