We need batch script which run ones weekly(time and day we could set it) and we want that script Import XML data to MYSQL table(fields) use mapping:
1.) Read XML file from URL and connect to MYSQL database.
2.) Parse(use mapping) for some fields in xml. For example in xml file is country name USA and in MYSQL must be United States. We only need sample of ONE mapping xml to mysql fields next 30 xml's we will map alone. Also there should be some error exception when some data are not maped for any reason.
3.) INSERT "mapping" data to MYSQL table, fields which we define for exactly user_id.
note: XML file includes n number of images which we should set to x=3 or x=5 to import in MYSQL database. Images have url's like : [url removed, login to view],.....
Also we want when new INSERT mapping data will be provided, old record(include images from server) must be deleted.
We have more than 30 different XML's which we want to import in same MYQL and same table but to different user_id.