Synchronize xml tot mysql


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

Keahlian: PHP, XML

Lihat lebih lanjut: synchronize xml php, synchronize xml mysql, xml tot, php synchronize xml, synchronize table, has been changed, php synchronize xml files, xml &, mysql data files, find remote, xml c, update mysql, ToT, Synchronize, pear, Mysql, mysql index, php xml delete, update images mysql database php, parse table

Tentang Pemberi kerja:
( 0 ulasan ) BARNEGAT, United States

ID Proyek: #118780

9 freelancer rata-rata menawar $198 untuk pekerjaan ini


Here is my timeframe and cost.

$250 USD dalam 10 hari
(86 Ulasan)

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

$190 USD dalam 5 hari
(34 Ulasan)

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 Lebih banyak

$299 USD dalam 10 hari
(14 Ulasan)

Please check the PM.

$150 USD dalam 2 hari
(27 Ulasan)

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 dalam 3 hari
(0 Ulasan)

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 Lebih banyak

$185 USD dalam 8 hari
(0 Ulasan)

I'm interested to do this project

$160 USD dalam 7 hari
(0 Ulasan)

hy, we can do it for you. thnkx

$230 USD dalam 15 hari
(0 Ulasan)

I can do this within two [login to view URL] close the [login to view URL] PMB

$120 USD dalam 2 hari
(0 Ulasan)