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
|