You have chosen to sponsor your bid up to a maximum amount of .
We need an XML file to be read and placed into a MySQL database. There is a single XML file that can contain multiple entries of each of the top elements. Flight_Records, Checkin_Counters, FIDS_Messages.
Each child element would have an associated field in the database within the tables described in the deliverable's below. A sample structure file has been attached. A file with more elements will be given to the successful Freelancer. Access to the MySQL database will be given, but I will need upload the file to the website for testing.
1. 3 MySQL tables - fidsFlightRecords, fidsCounterInfo, fidsMessages
2. PHP script to parse the XML file in the MySQL database tables.
3. MySQL table creation script for the above 3 tables
Please do not bid unless you fully understand the requirements. I am always happy to give more details as required. I have compared similar projects and would not expect it to be more than $80. Thanks.
Additional Project Description:
09/04/2013 at 7:42 EEST
The XML file will either be a local file or one using a file share, UNC etc.
The XML will be updated every minute so will need to be able to purge the data in the table and reload using the script the fresh data in the next XML.