Write some Software

We are developing a browser based application for handicapping horse races utilizing statistics information. Information is collected from various sources utilizing xml data feeds, json data feeds and web page parsing. The reporting end is written in php, html and jquery. The data is stored in a mysql database. Most of the importing of data is done with the exception of a few websites and json data feeds we'd like to check for data updates. We are currently budgeting $100 / week, but demonstrated ability over a few weeks could lead to us increasing our weekly budget. We are looking for a developer or team of developers that can work on data import and reporting features. The reporting engine is curently not using any framework. It is custom PHP, and may be re-structured over time.

Tasks for the comming few weeks will include:

Parsing of table data from websites and updating the mysql database - these scripts do not have to be PHP. Any language that runs on linux is fine, but php is preferred.

Creating customized sql queries and output templates for reporting against the database

This project is going to be long term, and we plan to increase our weekly budget from $100 to $500 as we grow the system.

Below is the functional spec for the first item, more like this to follow...

As a system, the database should be updated periodically and the horses marked as scratched should show as such in the interface


Mysql database has a table called races which has fields race_date (example: ‘2016-06-30’ as date type), track (varchar(5) most are 2 or 3 character uppercase strings and will match our data source), race (integer - this is the race number in the day)

Example - race_date: ‘2016-06-22 | track: ‘bel’ | race: 1

Website to be scraped is specific to day of race, and all updates will only happen on day of race.

(URL to be provided upon acceptance) provides an html table list of available track/date combinations available with links to individual pages to be scraped.

Url pulled from previous step will provide in page body a table with a list of updated data


In a script that can be automated, the list of pages that relate to today’s date will be parsed

For each page related to today’s date, the main table in the main body will be parsed

For each row that denotes a horse was “scratched”, the script will update the database marking the specific horse as scratched (DB field exists. Value 1 = scratched. 0 = not scratched.)

Whenever possible, the script or better yet class and execution script, should be written for future use. The page we’re scraping contains more than just scratches. It also contains Jockey Changes, Track Surface changes, and more. If this is completed well and within budget we have many hours of work to provide.

Week 1 - Parser described above - $100

Additional tasks in the pipeline:

We have a json feed parser script in php that is pulling data for race result information. It is currently only reading US tracks, We need to adjust this script to read canida tracks and determine when a few tracks seem to not work from the US.

We have a complex system that downloads XML files full of race data, uses XSLT to convert it to sql statements, and updates the database. Periodically some tracks do not import properly. This needs to be debugged.

The reporting output needs to be updated to include a number of new fields and the layout needs adjustments as well

Skills: MySQL, PHP, Software Architecture

See more: website templates for developers, websites for software developers, web based sql developers, we are looking for a software developer, templates for developing a website, software for developing web page, software developing web page, software developer updates to web developer, software developers websites, software developer spec, lead scraping software, individual software developer website, html 5 marking, execution table, data scraping from website software, custom web scraping, application web d exception, software write mq4, software write chip epson, useful software write book

About the Employer:
( 5 reviews ) east stroudsburg, United States

Project ID: #11173180

40 freelancers are bidding on average $2921 for this job


Hello [login to view URL] freelancer ranking is top 5th and i am full stack developer. I am very interested in your project and I hope to work with you. I am ready to start work for your project. I have enough experiences with W More

$2500 USD in 30 days
(432 Reviews)

Dear Sir, I have read your project description & understood the initial high level requirements, so please initiate the chat to finalize the contract details, estimate, payment terms etc. As you said that this is a More

$3000 USD in 40 days
(95 Reviews)

Greetings, I am very thankful for this opportunity. It’s really exciting that we have below similar kind of expertise and work experience: Facebook lead management : [login to view URL] Betting system http More

$8113 USD in 40 days
(81 Reviews)

Hello, Thanks for giving me the opportunity to discuss your project. I am a professional PHP developer with an experience of more than 8 years in creating and customizing PHP based websites, themes and plugins/m More

$1578 USD in 10 days
(174 Reviews)

Hope u having a great time! Satisfaction & Quality is our TOP Priority! We are a team of strong UI & UX design with unlimited customization & alteration until YOU Satisfied! We provide bespoke solution to the Front En More

$2842 USD in 30 days
(168 Reviews)

Hello, my name is Victoria. I represent Ukrainian IT Company «Webbook». We provide website design and web development services for organizations, public and government institutions, company or private web-pages. More

$2680 USD in 30 days
(181 Reviews)

Dear Client: I will appreciate if we can have a detailed discussion regarding the project and i will explain how we plan to go about things. I am available on all leading messengers, on phone and on email. Our Po More

$2368 USD in 30 days
(180 Reviews)

Could you kindly share the URL of the page to be parsed, not sure whether there is going to be different site URLs/Format for scrapping. Appreciate if you can kindly respond to enable us further discussion on the r More

$3157 USD in 60 days
(90 Reviews)

I have 291 reviews over http:/ ....... you can check I have a Master degree of Information Technology ....... I am a web program More

$2500 USD in 30 days
(133 Reviews)

Hello, First of all we need to look at the script you wish to be [login to view URL] propose to custom code the website using either CodeIgnitor or Symfony2 both of which are an MVC frameworks based on PHP and is extremely More

$3000 USD in 45 days
(171 Reviews)

I have good experience with web development as well as Android and iOS. I can do your project easily. I am a fast coder and usually write bug-free code. I won about 35 competitions in algorithms and development. You ca More

$3000 USD in 30 days
(125 Reviews)

I have 6+ years experience and I have done more then 50+ projects in my [login to view URL] note I am full feldged developers and work for 17 hours in a day.I am ready to start the project kindly open the private message box More

$2686 USD in 30 days
(72 Reviews)

Hello, Thank you for giving me opportunity to submit a proposal for your Project. = We are experts in PHP,Codeigniter,CorePHP, Wordpress and Mobile Apps also done many websites. = We use core coding/designing sta More

$2500 USD in 30 days
(74 Reviews)

We are Israel based IT solutions and services company, that combines core technical expertise with a global business perspective. The company's key offerings include product development, migration, porting, re-engineer More

$8000 USD in 60 days
(13 Reviews)

Hello, I m Tahsinul Alam, completed Masters in Software Engineering now working as one of the project manager of Workspace Infotech, software/Outsourcing firm located in Dhaka, Bangladesh. We have 13 different team More

$2500 USD in 30 days
(56 Reviews)

We are a London (Shoreditch) based fullstack dev studio. All our projects are version controlled with GIT. Following are some of our recent Laravel projects; [login to view URL] A social media post schedu More

$2970 USD in 30 days
(38 Reviews)

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably More

$3092 USD in 50 days
(27 Reviews)

Queries: 1. Let us know your online timings to discuss more about your project. Inspirational Projects: Custom CMS/Prestashop/Shopify/Woocommerce: [login to view URL] [login to view URL] http://w More

$5555 USD in 60 days
(49 Reviews)

Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i wi More

$3092 USD in 50 days
(55 Reviews)

Hi there.. I have read your project details completely and willing to do it for you... We are a group of experts Full Stack WEB developers (Custom PHP, Laravel5, Ruby on rails, Codova, Yii, Zend, Node.js, Drupal, M More

$3000 USD in 30 days
(78 Reviews)