XML to MYSQL - website or simple data entry
$30-250 AUD
Оплачується при отриманні
Creating a database in MYSQL.. And loading data into the database from XMLs available on another website.
The job is to create a database and create a script to download the following XML files and load them into the MYSQL database (with a custom schema)
XML FILE 1:
[login to view URL]
This file needs to be loaded daily at 8AM. It can go into a table called Meeting and can be truncated before the script to download this file runs.
Meeting table:
(Meeting, Meeting ID, Meeting Code, Meeting Name, Race Number, Race Time, Race Date, Race Name, Status, Racetime)
The above table will be used to format the xml file 2 html string.
XML FILE 2:
[login to view URL]"YYYY"/"M"/"D"/"MEETINGCODE""RACENUMBER".xml
THESE FILES CHANGE EVERYDAY.
XML FILE 2:
[login to view URL]
This file needs to be loaded half an hourly at 8AM to 8PM. It will go into a table called Racing and can be truncated once a day at 7AM (or before the first run). Everytime it runs it will stamp the results with a date loaded column (getdate()).
Racing table:
(Race Date, Meeting Code, Venue Name, Mtg Type, TrackRating, RaceNo, RaceTime, Runner No, Runner Name, Rider, Weight, Last Result, Rtng, FixedOdds Win Odds, FixedOdd Place Odds, Scratched, LateScratching, Date loaded into MYSQL table)
ID Проекту: #10821989
Про проект
Доручено:
Hi There, PHP/MySQL expert. I need CPANEL access of your server. Waiting for your reply and look forward to work with you. Thank you!
13 фрілансерів(-и) готові виконати цю роботу у середньому за $191
Hi, I'm senior web developer and I'm very interested in your project. I've done many projects. Hope I will have a chance to work for you on this project. Please contact me. Thanks
Can help... I am an Expert... Lets Start! Please start a Discussion with me and we can discuss the cost and timeline based on your detailed requirements and get started from there... Please check the past projects I Більше
Hi, I am an expert PHP/ MySQL developer with 15 years of experience. I can automize the project with setting cron in cpanel which will run every half an hour from 8 am to 8 pm. Thanks & Regards Manoj Kalya
I can develop a small windows service for you to scrap those xml files an add to your database. The windows service is quit stable and runs in background.
hello, sir: c/c++/python expert worked for samsung & huawei maybe more details will be helpful a sample can be provided before hired. hope to get message from u ty