Synchronize xml tot mysql

Closed Posted Jan 13, 2007 Paid on delivery
Closed Paid on delivery

Needed:

One or more php classes that synchronize a productdatabase in remote xml-files to a mysql database.

What I have:

- xml files on a remote server, that contain the data of a product-database. One xml file is an index-xml file, with created- and updated attributes, and links to other xml files.

- 21 empty mysql tables

What I need:

- One or more php classes that fetch the remote xml files, parse the xml files, and checks what data needs to be inserted/udateted/deleted in de mysql table, in an efficient and safe way. The class(es) will have to run once a week, and:

- compare the created- and updated attributes in the xml files with the created- and updated fields of the mysql tables, and only fetch data from the xml-files that has been changed

- delete data from the mysql tables that excists no longer in de xml-files

- update data in the mysql tables, if the corresponding data in the xml fields has changed

- insert data in the mysql tables that is new in the xml files

- the class(es) need to check if the remote xml files are available before data gets modified in the mysql tables(otherwise the mysql tables wil be emptied if the xml files are temporary unavailable)

- images that are referenced in the xml file needs to be inserted/updated/deleted in filesystem

specifications of the php code:

- the class(es) needs to be a inheritance of Pear’s XML_Serializer

specifications of the platform it needs to run on:

- php 4.x

- mysql 5.0

- apache on windows 2000

Part of this project is to find out which xml field corresponds to which mysql table- and mysql field. Good understanding of English is necessary.

It is possible that de mysql dump contains more fields than there are fields in the xml. Only the information that is available in the xml needs to synchronized.

Please give an indication of the time you need to finish this project

PHP XML

Project ID: #118780

About the project

9 proposals Remote project Active Mar 4, 2007

9 freelancers are bidding on average $198 for this job

Georgia

Here is my timeframe and cost.

$250 USD in 10 days
(86 Reviews)
7.2
tlchung

i just finished several project that involve data transformation and syncronization, I am sure my skill set meet your requirement.

$190 USD in 5 days
(34 Reviews)
7.1
vip

Dear Sir/Madam, I have all required knowledge and experience to achieve success of this project with best quality and professionalism. Please see my profile. Before accepting my bid offer please contact me via proj More

$299 USD in 10 days
(14 Reviews)
6.3
ShimaSoft

Please check the PM.

$150 USD in 2 days
(27 Reviews)
6.0
Shmihulets

Hi, We have a lots of IT experience on PHP/MySql, Flash/XML... I have completed good number of web based solutions and client server applications using PHP/MySql. We can manage this work .. Thank you!

$200 USD in 3 days
(0 Reviews)
0.0
nyoka

I have been working as a systems programmer for the last 13 years, specialising in web-based applications for the last 5 years. I have a very good understanding of XML that I have been using regularly for business to b More

$185 USD in 8 days
(0 Reviews)
0.0
slaw173

I'm interested to do this project

$160 USD in 7 days
(0 Reviews)
0.0
rakeshpar

hy, we can do it for you. thnkx

$230 USD in 15 days
(0 Reviews)
0.0