Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board


View Single Post
Old 01-26-2010, 04:09 PM   #7
CBedo
AllAboutTheROE
 
Join Date: Aug 2006
Location: Denver
Posts: 2,411
This is by no means optimal, but here's a patchwork solutions fo those who don't want to parse the xml themselves. Download the Equibase xml file, and then open it as an xml table in Excel (When you try to open the file, it will give you the option). Then save it in CSV format.

I just tried it, and here's an example of what you get:
Code:
race_date,track_name,race_number,change_description,old_value,new_value,date_changed,horse_name,program_number,change_description2,old_value3,new_value4,date_changed5,type,old_value6,new_value7,date_changed8
 12/10/2009,AQUEDUCT,1,,,,,,,,,,,Superfecta,N,Y,2009-12-10 12:16:47.816
 12/10/2009,AQUEDUCT,1,,,,,Badgette,1,Scratched,N,Y,2009-12-10 12:16:41.583,Superfecta,N,Y,2009-12-10 12:16:47.816
 12/10/2009,AQUEDUCT,1,,,,,Badgette,1,Scratch Reason,,Stewards,2009-12-10 12:16:41.583,Superfecta,N,Y,2009-12-10 12:16:47.816
 12/10/2009,AQUEDUCT,1,,,,,Flying Sappho,5,Scratched,N,Y,2009-12-10 12:16:41.583,Superfecta,N,Y,2009-12-10 12:16:47.816
 12/10/2009,AQUEDUCT,1,,,,,Flying Sappho,5,Scratch Reason,,Stewards,2009-12-10 12:16:41.583,Superfecta,N,Y,2009-12-10 12:16:47.816
 12/10/2009,AQUEDUCT,1,,,,,Cash Value,8,Jockey,John R. Velazquez,Alex Bisono,2009-12-10 12:16:41.583,Superfecta,N,Y,2009-12-10 12:16:47.816
 12/10/2009,AQUEDUCT,2,,,,,,,,,,,,,,
 12/10/2009,AQUEDUCT,2,,,,,Bindle Stick,6,Jockey,Victor Santiago,Pablo Fragoso,2009-12-10 12:16:41.583,,,,
__________________
"No problem can withstand the assault of sustained thinking" -- Voltaire
CBedo is offline   Reply With Quote Reply
 
» Advertisement
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 05:50 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.