Past Performances - Display SQL UDMs
April 30, 2014
Display of SQL UDMs in JCapper Past Performances, a web tutorial
In this write up, I'm going to present the steps (that if followed exactly) will result in both the JCapper Numbers Table and UDM
List being displayed for each horse in your JCapper Past Performances.
"Jeff, How do I go about displaying the numbers table and UDM List as part of my JCapper PPs? Thx in advance,"--end quote
BASIC OPERATING INSTRUCTIONS FOR DISPLAY OF NUMBERS TABLE AND UDM LIST FOR EACH HORSE IN JCAPPER PAST PERFORMANCES:
Preliminary Requirement: You need to be operating the program in SQL Mode in order to display the numbers table and UDM List as part of your JCapper PPs.
Link to a screenshot of the User System Definitions Screen:
Note that in the above screenshot the "Operate JCapper in SQL Mode" box is persisted as checked (causing the program to be operated in SQL Mode.)
Preliminary Requirement: Persist "0 Multi-Folder Select" as the option for the "Main Module Calc Races Button Display" setting in the Enhanced Settings Module. This will make it easy for you to:
a. Break up your race day into up to 3 groups of 8-12 files each when you load card files into the program using the DFM Card Loader.
b. Get Scratches for the card files of a specific folder (without first having to bring up the DFM and switch folders) when you click the XML button in Scratch BOT.
c. Run a Calc Races routine for card files loaded into the program on a specific folder (without first having to bring up the DFM and switch folders.)
Link to a screenshot of the Enhanced Settings Module:
Note that in the above screenshot "0 Multi-Folder Select" is the persisted option for the "Main Module Calc Races Button Display" setting (causing the Main Module to display separate Calc Races buttons for Folders 1, 2 & 3 whenever you mouse oover the Calc Races button.)
Note that this setting also causes Scratch BOT to display XML buttons for Folders 1, 2, & 3 whenever you mouse over the XML button in Scratch BOT.
Step #1. Persist the current active data folder in the DFM.
Link to a screenshot of the DFM:
Note that in the above screenshot the "c:\2014\Q2_2014" folder is persisted/checked as active. (This is the folder where I am downloading/building/storing current quarter files.)
Step #2. Load one or more card files into the program using the DFM Card Loader.
Link to a screenshot of the DFM Card Loader:
Note that in the above screenshot, I have:
a. Used the File Filter Tool to first populate the list of available files for 04-30-2014 on the far right hand side of the interface.
b. Dragged and dropped all of today's files except CDX (I am boycotting that track because they recently raised their takeout rates) into the listbox for Data Folder 1.
c. Highlighted the 7 card files sitting in the listbox for Data Folder 1 using my mouse cursor. (Alternately, I could have highlighted them by ctrl-clicking them one file at a time.)
d. Loaded the highlighted list of files into the program by clicking the Load Selected Files Folder 1 button.
Step #3. Get scratches and changes using the XML Button in Scratch Bot.
Link to a screenshot of Scratch BOT:
Note that in the above screenshot (after first setting up track codes in the Track Abbrev Table Interface) I have clicked the XML Button for Folder 1.
Step #4. Run a SQL Calc Races on the Data Folder that you used in step 2 above for the card file containing the race(s) you want to generate Past Performances for.
Link to a screenshot of Main Module after running a SQL Calc Races on Data Folder 1:
Note that in the above screenshot I clicked the Calc Races button for Folder 1 (the same folder where today's card files were loaded into the DFM in step 2 above.)
Step #5. Launch the Past Performace Generator - and then from inside the Past Performance Generator, select a track code from the Loaded Card Files drop down. From there, select a race from the race number drop down to generate past performances for that race.
Link to a screenshot of Past Performance Generator showing me about to select the .JCP card file for ATL from the list of card files loaded into the program on Data Folder 1:
Link to a screenshot of Past Performance Generator showing JCapper Past Performances for ATL R1:
The above screenshot shows the numbers table embedded (for the Calc Races just run in step #4 above) in the pps for the horse being displayed.
The above screenshot also shows SQL UDMs (for the Calc Races just run in step #4 above) in the UDM list for the horse being displayed.
Note that each time you run a SQL Calc Races, the StartersToday and UDMPlays Tables are cleared and then repopulated with data for the Calc Races just run in step #4 above. That means that the time to look at Past Performances - and the numbers table and UDM List for the horses in that race - is just after running a SQL Calc Races involving that race. (This is just as true whether you run a SQL Calc Races for all card files loaded into the program for an entire folder - or whether you run a SQL Calc Races for a single card file - or whether you run a SQL Calc Races for a single race.)
A "folder conflict" will prevent the numbers table from displaying in PPs when you are operating the program in SQL Mode. (So will operating the program in Playlist File Mode.)
If you are operating the program in SQL Mode but you are not seeing a numbers table embedded in the PPs for each horse: You should assume you have a "folder conflict."
Until you have a better understanding of how things work, try following the above steps (exactly) to avoid introducing a "folder conflict" into things. (Once you are getting a numbers table in your PPs that tells you that you no longer have a "folder conflict.")
If you are getting N/A instead of names for SQL UDMs in your UDM List, you should assume one of the following situations as the cause:
a. You do not have any active SQL UDMS. Hint: You'll need to create your own SQL UDMs when you make the switch from Playlist File Mode to SQL Mode. (There aren't any active SQL UDMs in the initial program download package.)
b. None of your active SQL UDMs are flagging horses in the race you are looking at.
If you are getting N/A instead of names for SQL UDMs in your UDM List, try the following suggestion:
Create a simple SQL UDM where the objective behind the SQL Expression driving the UDM is to merely flag at least one horse in every race. The following SQL Expression (or one like it) can be used to meet this objective:
SELECT * FROM STARTERHISTORY WHERE RANKUPR = 1
Link to a screenshot of the UDM Wizard after creating the UDM mentioned immediately above:
Note that in the above screenshot the UDM is active because the Active box is persisted as checked. (Inactive SQL UDMs will not appear in the UDM List.)
Note that the above UDM is a SQL UDM because it contains a SQL Expression. (UDMs are either Playlist File UDMs or SQL UDMs but never both. Once you add a SQL Expression to a UDM Definition that UDM will remain a SQL UDM until such time as you remove the SQL Expression fom its UDM Definition.)
After you are certain that you have at least one active SQL UDM that should be flagging horses in every race, retry the above (exact) steps.
Copyright © 2008 JCapper Software