Database import from XML documents (database synchronization)

Completed Posted Jun 7, 2012 Paid on delivery
Completed Paid on delivery

We need java classes that, once a day , uses XML documents to populate a MYSQL database.

The XML documents are created by other procedures outside this project.

Every XML file contains N records; the classes must insert/update/delete the right records on the Mysql tables;

Please read advanced project options.

## Deliverables

The classes must :

* Be written in JAVA6; installed on a TOMCAT enviroment

* Use a TOMCAT pool connection provided

* Use XML documents found in a specific location (on local filesystem or to be downloaded from spedific URL)

* Elaborate the XML document, one XML object = one table record.

* Download images set in XML fields from specific URLS, resize images, save them in specific BLOB fields

* Delete records present in database tables but not present in XML file any more. XML documents have 'last modified date and time' information

* Check if the XML document has to be elaborated (i.e. has an 'account' record on a specific table); not all file must be elaborated.

* Move XML documents in safe location after elaboration

* Create a log for every operation (to easily debug)

* Send an email on completion with a report

* Use a file to set all the obvious parameters (directories, timeouts etc.)

* Take care of specific (and obviously ) situations (records not found, filenames incorrected etc. etc.)

* Every XML documents has a filename the contains the key to find the right records on the database.

* There can be a maximum number of records, related to a specific 'account', that can be inserted in the tables

We provide :

* Help to fields mapping between XML fields and table fields.

* SQL queries to create destination tables.

Amazon Web Services PHP Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #2748591

About the project

8 proposals Remote project Active Jun 22, 2012

Awarded to:

standsed

See private message.

$300.05 USD in 5 days
(9 Reviews)
4.0

8 freelancers are bidding on average $272 for this job

DandDSolutions

See private message.

$297.5 USD in 5 days
(205 Reviews)
6.7
gireeshgiri

See private message.

$210.8 USD in 5 days
(62 Reviews)
6.1
namhaminh

See private message.

$300.05 USD in 5 days
(98 Reviews)
5.7
dsysoft

See private message.

$300.05 USD in 5 days
(29 Reviews)
4.2
alchemistsoft

See private message.

$120.7 USD in 5 days
(4 Reviews)
2.0
manojks029

See private message.

$300.05 USD in 5 days
(1 Review)
1.0
janih

See private message.

$350.2 USD in 5 days
(0 Reviews)
0.0