Database import from XML documents (database synchronization)
$30-5000 USD
完了済み
投稿日: 12年近く前
$30-5000 USD
完了時にお支払い
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.