Integrating an XML into MySQL database tables
- or -
Post a project like this2234
$$
- Posted:
- Proposals: 8
- Remote
- #1901525
- Awarded
Application Architect - Full Stack Developer and Designer - Mobile App Design and Development, Swift, React.js, Node.js, HTML5, Javascript, PHP, MySQL, jQuery, API,
Islington
✪Software Developer ✪Web Developer (Java,Python, Android, jee, JSP, JSF, Java Fx,Vue, Blue J, Nuxt) ✪ Processing ✪ Elastic Search ✪ Database
Saitama
18 years expert in PHP, MySQL, HTML, CSS, JavaScript, jQuery, Ajax, Bootstrap, Chrome Extension, VB, VBA, AutIT Programming & Website Data Scraping
Ambala
eCommerce Developer Zen Cart, WordPress/woocommerce, Pinnacle Cart, Magento, OSCommerce, SugarCRM and vTiger CRM
Chennai
43929131680120707446329171244165914466232476403239
Description
Experience Level: Intermediate
We are a vacation homes rental company and our supplier is providing us an XML file containing prices and availability for his properties that are on our catalogue (20 properties).
We need to call, parse and import an those XML files into our database, the two fundamental piece of information are the price and available dates.
The prices are grouped with the following structure:
2018-08-01
2018-08-08
7
n,n,n,n,n,y,n,
n,n,n,n,n,y,n,
<<<< This is what we would like to insert
The availability is grouped like that
2018-02-16
2020-02-16
0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 <<<< This is what we want
We need to call, parse and import an those XML files into our database, the two fundamental piece of information are the price and available dates.
The prices are grouped with the following structure:
2018-08-01
2018-08-08
7
n,n,n,n,n,y,n,
n,n,n,n,n,y,n,
<<<< This is what we would like to insert
The availability is grouped like that
2018-02-16
2020-02-16
0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 <<<< This is what we want
Andrea R.
100% (11)Projects Completed
7
Freelancers worked with
7
Projects awarded
50%
Last project
3 Aug 2018
Spain
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Andrea
Can you send sample or 1 example record from supplier and one example record of how you want it formatted, this is will be clear.
Is this a one time import or cron will be setup?
593431
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies