Find Jobs
Hire Freelancers

Database import from XML documents (database synchronization

$30-250 USD

Cancelled
Posted almost 12 years ago

$30-250 USD

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; it is a procedure that populate a database; no front end. Centos – Kernel [login to view URL] Apache: 2.2.3 Tomcat: 7.0.19 Java: 6u26 MySQL -- version(s): 5.5.18 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. Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.
Project ID: 1682328

About the project

11 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
11 freelancers are bidding on average $253 USD for this job
User Avatar
Please check your inbox. Thanks
$500 USD in 5 days
4.9 (197 reviews)
7.4
7.4
User Avatar
Understood. Please check PM.
$225 USD in 7 days
4.9 (100 reviews)
6.7
6.7
User Avatar
Hi, kindly check your pm for more enquiries, thanks.
$250 USD in 7 days
4.9 (58 reviews)
6.4
6.4
User Avatar
Please check pm. Thanks
$300 USD in 7 days
5.0 (16 reviews)
5.1
5.1
User Avatar
hi, Please check you pm!
$200 USD in 5 days
4.7 (2 reviews)
2.5
2.5
User Avatar
Understood. Looks like a interesting project. Here are my considerations. You could make a simple servlet in WAR that runs under Tomcat. For each request, you could read the XML with XPath and perform the required operations in the database. You need an external configuration file and at the end of the operation should send a mail.
$250 USD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, I have gone through your requirement and find that my profile is best suitable for this project. I have done a lot of work on XML parsing using JAXP and JAXB java apis. I have also good knowledge of Mysql database. I look forward to be awarded by this project. Regards, Himanshu
$180 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings! I have good exposure in java development, handled many projects similar to this batch process. Please check my private message.
$250 USD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
"Understood". I have got more than 5 years of experience in Java/J2EE development. can handle this effectively. Please check PMB.
$200 USD in 5 days
0.0 (0 reviews)
1.0
1.0
User Avatar
I have around 6 years of Java development experience worked with Washington National Insurance Company (CNO Financial Group.) Worked on similar projects, synchronized ACORD standard XML files into DB using SAX Parser and generated emails After XML file is successfully synchronized to DB. IF a failure occurs due to data errors like special XML characters (&,') etc and email will be generated . I could complete this project in 3 days however i would like to keep a buffer 3 days time. We inserted PDF invoices into DB using BLOB
$180 USD in 6 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of EGYPT
Cairo, Egypt
4.8
91
Payment method verified
Member since Aug 15, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.