|
|
09-23-2011, 08:55 PM
|
#1
|
Registered User
Join Date: Dec 2004
Posts: 875
|
Who here uses Formulator comma-delimited files?
I've wanted for ages to convert the comma-delimited PP data into spreadsheet format like what Raybo has the for Brisnet files, but never seem to get it off the ground. I realize it takes a lot of work, but my goal is to finally get it done.
Where do I start? What do I need? Who can help me out with this?
|
|
|
09-25-2011, 07:50 PM
|
#2
|
Registered User
Join Date: Dec 2004
Posts: 875
|
Guess nobody uses DRF Formulator data...
|
|
|
09-25-2011, 07:59 PM
|
#3
|
@TimeformUSfigs
Join Date: Jan 2002
Location: Moore, OK
Posts: 46,828
|
I use them. They provide the field definitions and several options, including single or multiple file. I don't, however, use them in Excel so I can't help with that.
|
|
|
09-25-2011, 08:40 PM
|
#4
|
Registered User
Join Date: Dec 2001
Posts: 6,128
|
I use them. I put the data in a database. I never use excel, though.
|
|
|
09-25-2011, 09:00 PM
|
#5
|
Registered User
Join Date: Dec 2004
Posts: 875
|
Quote:
Originally Posted by GameTheory
I use them. I put the data in a database. I never use excel, though.
|
Perhaps I can pick your brain. Where do you find the field definitions for single file data? How do you import into a database? Im assuming that you use Access.
|
|
|
09-26-2011, 07:41 AM
|
#6
|
EXCEL with SUPERFECTAS
Join Date: Mar 2004
Posts: 10,206
|
Quote:
Originally Posted by jeebus1083
Perhaps I can pick your brain. Where do you find the field definitions for single file data? How do you import into a database? Im assuming that you use Access.
|
I remember you and I talking about the Formulator csv files, but I have never seen a file format for them, which would be necessary for Excel, or any other program, in order to know which fields contain which data.
Also, I never was clear as to how one would obtain the csv files, are they readily downloadable, or are they created via the Formulator software?
|
|
|
09-26-2011, 08:15 AM
|
#7
|
Registered User
Join Date: Sep 2005
Posts: 1,827
|
Quote:
Originally Posted by cj
I use them. They provide the field definitions and several options, including single or multiple file. I don't, however, use them in Excel so I can't help with that.
|
You wouldn't happen to have a link that would show field definitions for DRF files?
__________________
Every time you are tempted to react in the same old way, ask if you want to be a prisoner of the past or a pioneer of the future.
|
|
|
09-26-2011, 08:31 AM
|
#8
|
Registered User
Join Date: Dec 2004
Posts: 875
|
Quote:
Originally Posted by raybo
I remember you and I talking about the Formulator csv files, but I have never seen a file format for them, which would be necessary for Excel, or any other program, in order to know which fields contain which data.
Also, I never was clear as to how one would obtain the csv files, are they readily downloadable, or are they created via the Formulator software?
|
In the Formulator 4.1 software, there is a "user guide" on the left hand side of the software, which is a PDF file, or one can access it through the C:/Program Files/DRF/Form41 folder. The PDF file is titled drf.pdf. It's basically a user guide, and does go into the file formats for both multiple and single data file formats.
|
|
|
09-26-2011, 09:13 AM
|
#9
|
@TimeformUSfigs
Join Date: Jan 2002
Location: Moore, OK
Posts: 46,828
|
Quote:
Originally Posted by BIG49010
You wouldn't happen to have a link that would show field definitions for DRF files?
|
It is a PDF file that comes with the Formulator program itself.
|
|
|
09-26-2011, 09:14 AM
|
#10
|
@TimeformUSfigs
Join Date: Jan 2002
Location: Moore, OK
Posts: 46,828
|
Quote:
Originally Posted by raybo
Also, I never was clear as to how one would obtain the csv files, are they readily downloadable, or are they created via the Formulator software?
|
They are created via the software with the "export" function.
|
|
|
09-26-2011, 09:54 AM
|
#11
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,858
|
Quote:
Originally Posted by cj
They are created via the software with the "export" function.
|
Not the web version yet, right?
__________________
Who does the Racing Form Detective like in this one?
|
|
|
09-26-2011, 10:19 AM
|
#12
|
Registered User
Join Date: Dec 2001
Posts: 6,128
|
Yes, the field definitions are available in a pdf, and yes you have to export the data yourself from the desktop version of the program. It is very much a pain, plus the program is buggy and will often freeze up during export. And on newer versions of Windows, it goes from being buggy to completely unstable. I run it under a WinXP virtual machine just to get the exports somewhat reliably. I use the multi-format instead of the single format, which is even more of a pain cause you've got match up all the different pieces it spits out, but you get lifetime running lines for each horse that way instead of only 10 or 12 with single. I think there are some other extra tidbits I get that way also -- don't remember the differences off the top of my head.
Been waiting on the export function from the web version for *years* now, but if they ever do get it done, I'm sure that will be a disaster also...
|
|
|
09-26-2011, 11:00 AM
|
#13
|
@TimeformUSfigs
Join Date: Jan 2002
Location: Moore, OK
Posts: 46,828
|
Quote:
Originally Posted by Tom
Not the web version yet, right?
|
Don't get me started.
|
|
|
09-26-2011, 01:26 PM
|
#14
|
Registered User
Join Date: Oct 2001
Location: near Lone Star Park
Posts: 5,152
|
Excel can be used if you're only wanting to process the data for "today", but if you're wanting to retain the data for research, a database is much better. Really, a database is better either way, but I can't imagine trying to maintain historic data using a spreadsheet.
__________________
Ranch West
Equine Performance Analyst, Quick Grid Software
|
|
|
09-26-2011, 02:27 PM
|
#15
|
Registered User
Join Date: Dec 2004
Posts: 875
|
Quote:
Originally Posted by ranchwest
Excel can be used if you're only wanting to process the data for "today", but if you're wanting to retain the data for research, a database is much better. Really, a database is better either way, but I can't imagine trying to maintain historic data using a spreadsheet.
|
I play on my days off, and am not an "everyday" player, so I guess my purpose is to process data for "today".
|
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|