I have an XML feed (160MB file on another server) that I need imported into a MySQL database. A file is attached that shows an example of the two sections of the xml feed.
Management Section: I would like a sql statement that will dump this into a database table with all data sections. I don't care about the line. Only about what is inside the … section.
Property Section: I would like a sql statement that will dump this info into a database table.
- All the should be grouped together in a comma separated list.
- Photo source and description should be included in "Rank" order. Something like photo1source=… photo1desc=… photo2source=… photo2desc=…
The script can either pull the XML from the source server, or download it to my server, then create the sql statements. Very important that the script run under the following server requirements though.
- 120 second maximum execution time
- 750 MB maximum memory usage
The script will be run several times a day through a CRON job to update my database.
37 pekerja bebas membida secara purata $139 untuk pekerjaan ini
Hello, We are team of experienced web developers and mobile app developers. I have gone through all the requirements and ready to work with you. Thanks
This is my kind of project, please check my reviews. I'll design a MySQL db based on your XML and a script that downloads the XML and imports it to your DB. Kind regards