Quote:
Originally Posted by OverlayHunter
preferably in csv or text format
|
If you know a little sql, and you know your way around JCapper, it's not terribly difficult to save a sql expression that can be reused to drive an export that creates a .CSV file with the desired info on your hard drive.
The first screenshot shows the SQL Expression Tool in the JCX File Exports Module where I've keyed and saved a sql expression that can be pulled up and reused to create a .CSV file that contains columns for date, track, race, posttime, and wagerlist sorted by date, track, race.
Basically, if you are operating JCapper in SQL Mode, after running your first Calc Races for the day, you'd bring up the SQL Expression Tool in the JCX File Exports Module, pull up the saved sql expression from a drop down (the one in the screenshot is named __WagerList) and hit the Apply button:
WagerListSQLExport1.JPG
The second screenshot shows the JCX File Exports Module after keying a filename for the .CSV file and clicking the Create Export button.
Note that you only need key the filename once. After that, use the Browse button to open up a dialog box (not shown) and select the previously used .CSV file - which gets overwritten with new data each time you hit the Create Export button:
WagerListSQLExport2.JPG
The third screenshot shows the .CSV file itself after opening it in Excel:
WagerListSQLExport3.JPG
If you know what you are doing the whole process only takes a few seconds from start to finish.
-jp
.