Good Cheap Source for CSV Program\PPs (<$1\card)

[podonne]

Hello all,

What's a good cheap source for comma delimited race programs (w/ pps). I use BrisNET at the moment but the cheapest I can get is $1\track\day. But they don't ofer a volume discount, and I want to buy in volume (6-7 tracks\day). I'd be willing to go for a monthly unlimited if it's cheaper per card...

Any ideas?
-Phil

[headhawg]

Try their sister company: TSN (http://www.tsnhorse.com/)

I think they have unlimited PPs for $60/month including results files.

[sq764]

Agreed, us TSN, they have $.50 data files

[podonne]

Wow, thanks. I don't get it though. If they are the same company (they have the same look and feel for the website), why does one charge double what the other charges for the same thing? Is there less info in the file?

[Tom]

TSN has somewhat less info.

[BIG49010]

I use Bris multi-file at a Dollar, does anybody have a good way to break up the 50 cent single-files?

[Tom]

Infotran will do the job, but it kind of a sluggish way to go.
What would nice is a program that would take a comma file, break it up into two three or four smaller files, containing user-specified fields. I would probably like to inclue the fields "Horse" and "date" in several files, but you get the idea.

Like I say, Infotran, but its not too direct and you would need to run several
templates.

Any other ideas?

Like maybe a spreadsheet program that would hold a lot of columns? THAT would be nice.

[hcap]

Tom Infotran will do the job, but it kind of a sluggish way to go.
What would nice is a program that would take a comma file, break it up into two three or four smaller files, containing user-specified fields. I would probably like to inclue the fields "Horse" and "date" in several files, but you get the idea.

Like I say, Infotran, but its not too direct and you would need to run several
templates.

Any other ideas?

Like maybe a spreadsheet program that would hold a lot of columns? THAT would be nice.
I mentioned this before. I use excel primarily.



"For historical study, what I do is extract raw info from TSN procaps files in excel-all 1400+fields, and construct compounded factors in the same excel program. Same program also imports results info with stuff like closing odds, scratches, etc, from the corresponding xrd files for each horse. Runs automatically. On my old machine takes about 10 seonds per card.

I copy to another excel program to rank each horse by factor by race."

It is setup so that you put data files in 1 directory and result files in another.
You can run over 50 cards automatically. Creates a table with any factor(s) you want, including any you may want to create. Can be setup to create up to 256 columns of output. 10 seconds I mentioned is for a very complicated set of approx 100 compounded factors.

If any one is interested PM me. A bit busy. Just got a newer machine. Had an interesting time switching everything over. Also am now using Thuderbird as my email program-highly recomended.

Tom, no politics or cartoons included in the program :lol:

[hcap]

Here's the original discussion
post #28

http://www.paceadvantage.com/forum/showthread.php?t=23935&page=2&pp=15

[zerosky]

Infotran will do the job, but it kind of a sluggish way to go.
What would nice is a program that would take a comma file, break it up into two three or four smaller files, containing user-specified fields. I would probably like to inclue the fields "Horse" and "date" in several files, but you get the idea.

Like I say, Infotran, but its not too direct and you would need to run several
templates.

Any other ideas?

Like maybe a spreadsheet program that would hold a lot of columns? THAT would be nice.


Excel 2007 contains 16,384 columns and over 1 million rows
you can download a fully functional beta from the office homepage

I use formulator which allows export of several files, unfortunatly it doesn't contain any pace figs.

[sjk]

Is there a new Access? Does it increase the 2 GB size limtation?

[zerosky]

Is there a new Access? Does it increase the 2 GB size limtation?

the beta is for the office package, including access, I think the 2 GB limit still applies.

[sjk]

Thanks for the info. Upgrading is always chancy anyway so I may be better off to keep working around the size limits even if it were changed (last time they went from 1 Gb to 2 Gb but the files got twice as big).

[Rook]

Is there a new Access? Does it increase the 2 GB size limtation?

Here is a link that discusses the "new" Access:
http://blogs.msdn.com/access/archive/2006/06/05/618366.aspx

Microsoft blows an opportunity to bring Access into the 21st century. 255 fields and 2gb is a joke in this day and age. Isn't it great that Excel has now been dramatically expanded but when you try to bring the data into Access 2007, it just imports the first 255 fields?:mad:

One of the developers says they wanted to increase the size limitations but they just ran out of time. I guess if Microsoft had a just a bit more than $56 billion dollars of cash lying around, they would be able to hire a competent and adequetely staffed team.

[tahoesid]

Instead of using Access they are recommending you use SQL Express if you have anything needing more storage capacity. It uses the same engine as SQL and is upgradable to SQL if you need to get bigger. It has a 4Gig limit.

And it's also free:eek:

[Rook]

Instead of using Access they are recommending you use SQL Express if you have anything needing more storage capacity. It uses the same engine as SQL and is upgradable to SQL if you need to get bigger. It has a 4Gig limit.

And it's also free:eek:

How helpful of Microsoft to recommend another one of their products. I and I'm sure hundreds of other people recommended to them in emails over the years that the 255 field/2gb limitation needed to be upgraded in the next version of Access. I'm impressed by how much they respect their customer base and how closely they've integrated Excel and Access in Office.:mad:

I wish I had bit the bullet a few years ago, and made the leap to Oracle, then I wouldn't have to be exasperated by the incompetence and arrogance of a company which is widely hated for well deserved reasons.

I could still make the transition but learning a new DB system is not my idea of a good time and I would certainly not look forward to duplicating the countless hours of time spent linking tables, queries and reports.

[sjk]

Will it run an Access database? I have no taste for rewritting a perfectly good application that has close to 1000 objects.

[eqitec]

All of this come from the 1$ .drf file

http://members.aol.com/eqitec/1eitPNCStart.htm

Dave

[podonne]

The link didn't work :bang:

[Murph]

Quote:
Originally Posted by banacek
If it isn't the DRF variant, it is close. (I do adjust it with my software to my personal variant.)

According to the data structure explanation on the Bris site, fields 856-865 are the DRF speed rating and 866-875 is the DRF variant for up to the last 10 races. I thought this information was the reason why the Bris files are $1, when the TSN files are .50. The TSN's don't have the DRF info.
__________________
http://www.paceadvantage.com/forum/showpost.php?p=293478&postcount=46

The above is quoted from the last thread on this subject. I had not yet
thanked everyone for setting me straight on the data file differences.

Here is a link to the $1 Brisnet (http://www.brisnet.com) single file data structure:
http://www.brisnet.com/cgi-bin/static.cgi?page=drfsff

Here is a link to the TSN (http://www.tsnhorse.com) .50c single file data structure:
http://www.tsnhorse.com/downloads/eqb_sing.txt

Murph