Custom XML Application

We developed a command line application which takes either 4 or 6 parameters. Parameters are “–c” with “application config file”, optional “–d” with “database config file” and “–x” with “Xml file”. It parses whole XML file content and inserts content in two different MySQL databases with different needs.

It also handles duplicate products present in the XML file while inserting them into database. If it finds same product in the database while inserting product in the database, it updates old product with the new product based on unique product number or duplicate product name.

It inserts product using unique product number in one database and using unique product name in another database. It stores all the product related information in different tables for different purposes.