XML to MySQL data feeds with PHP
27 april 2012 09:59
Websites & Applicaties
€ 20 tot € 80 p.u.
Freelancer of ZZP'er gezocht voor de volgende opdracht:
XML to MySQL feeds with cronjobs I have a Joomla 2.5 based website with Jreviews installed to handle content (jreviews is an extension to joomla) installed with a basic MySQL databse.
After completion of this project this website should hold data information of skiresorts and snowreports which comes out of 4 XML datafeeds provided by another company and automaticly perform daily updates of the feed with simple cronjobs.
The data feed should be processed into the (already setup) JRreviews & Joomla MySQL Fields per listing of the skiresort in different Joomla categories. Technically the scripts should write in 2 mysql tables at the same time, connected by two content ID's. Some solid data has to be inserted dependable on the directory where the data is stored (in this case the "state" maps a category in Joomla).
Three times a day there should be a "getRegionResortsLastUpdated" with a cronjob locally to retrieve the latest updated data and update it into the correspondating contents.
Once a week a global cronjob/script should check for new skiareas or deprecated skiareas.
A simple .htaccess will deny all extrernal traffic to the scripts.
Not all data mentioned in the our webservices are required, i'll provide a list with mapping items i want to receive and provide the correspondating mysql field with that, see attachment.
My ideal idea is that you setup the feeds together with the cronjob scripts in that way that i can easily extend the scripts adding new fields when required (i can edit/alter php if it is documented in the code).
Based on the above info can you please give me an estimated price of your work or hourly work.
My terms are:
- 50% payment when scripts are running locally on your server
- Local testing of your scripts (you may use ioncube to protect your code) before 2nd 50% payment
- Initial error support within the first 30 days after delivery
- Works made for Hire (The Independent Contractor transfers to the Customer the copyright of the work described in the Agreement for the term of the copyright defined by law)
- Scripts usable by me :-)