XML to MYSQL - website or simple data entry

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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)

MySQL PHP Shell Script SQL XML

ID Проекту: #10821989

Про проект

13 заявок(-ки) Дистанційний проект Остання активність 7 роки(ів) тому

Доручено:

brycep

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!

$110 AUD за 5 дні(-в)
(265 відгуків(-и))
8.0

13 фрілансерів(-и) готові виконати цю роботу у середньому за $191

graphicaa

Step 1: 1. The download of XML available from a website and insert the values in mysql table. 2. A custom schema for the mysql to be designed for import of the data. 3. A cron job to be run at 8AM daily. This script Більше

$147 AUD за 3 дні(-в)
(559 відгуків(и))
8.9
inzaghi2006

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

$250 AUD за 2 дні(-в)
(221 відгуків(и))
7.5
ranganathp

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 Більше

$500 AUD за 3 дні(-в)
(78 відгуків(и))
6.9
ssspl

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

$250 AUD за 5 дні(-в)
(55 відгуків(и))
5.8
yeki

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.

$175 AUD за 5 дні(-в)
(22 відгуків(и))
5.2
sylar1015

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

$200 AUD за 2 дні(-в)
(4 відгуків(и))
4.0
itbarduga

A proposal has not yet been provided

$177 AUD за 5 дні(-в)
(5 відгуків(и))
3.1