Import XML datas -> parsing data -> to MYSQL

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 6

Project Description

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.

Get free quotes for a project like this
Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online