Suoritettu

XML to MYSQL - website or simple data entry

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)

Taidot: MySQL, PHP, Shell Script, SQL, XML

Näytä lisää: php string to html, id to code, html code to create website, hourly charges data entry commerce website india, data entry directory website, data entry joomla website, free data entry forms website templates, delphi data entry simple, data entry inventory website, data entry simple copy paste, data entry simple project work, alibaba website build, handicapping website build service design, data entry simple form filling jobs weekly payment, data entry transfer website, joomla commerce website build, data entry forms website templates, full website build, captcha data entry work website, data entry project website directory

Tietoa työnantajasta:
( 59 arvostelua ) Malvern, Australia

Projektin tunnus: #10821989

Myönnetty käyttäjälle:

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 päivässä
(265 Arvostelua)
8.0

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

$147 AUD 3 päivässä
(559 arvostelua)
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 päivässä
(221 arvostelua)
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 Lisää

$500 AUD 3 päivässä
(78 arvostelua)
6.9
$152 AUD 3 päivässä
(113 arvostelua)
6.7
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 päivässä
(55 arvostelua)
5.8
$50 AUD 3 päivässä
(41 arvostelua)
5.1
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 päivässä
(22 arvostelua)
5.2
nitinvtaurus

Hello Buyer, Greetings of the day...!!! I am Nitin, a professional website designer/developer.I have more then 5 years of excellent experience. My Core Skills:- -Html to Psd -Twitter Bootstrap - Adob Lisää

$155 AUD 3 päivässä
(11 arvostelua)
4.4
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 päivässä
(4 arvostelua)
4.0
itbarduga

A proposal has not yet been provided

$177 AUD 5 päivässä
(5 arvostelua)
3.1
dsi56c48b4ce8bde

Hi, I develop lots of logical websites like - [login to view URL] (health related portal with payment gateway) [login to view URL] (bank related portal with payment gateway) [login to view URL] (health related portal wi Lisää

$155 AUD 3 päivässä
(0 arvostelua)
0.0
$166 AUD 3 päivässä
(0 arvostelua)
0.0