Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Multi-Trainer UDM???

Home Register
Log In
By Multi-Trainer UDM???
Jens
12/31/2013
10:09:17 AM
Because I've added a lot of trainer UDM's lately, I was wondering if (for the purpose of creating and later quickly appending one quick index file) it was possible in JCapper to make one inactive UDM with multiple trainers? If so, I haven't figured it out.

Reply
jeff
12/31/2013
1:35:16 PM
It's easy. (The instruction set presented below also applies to rider names.)

Here are the "rules:"

1. The individual names that you use in your UDMs must be an exact match of the individual names as they exist in your data file.

2. Compile a name list consisting of the individual names you want to use in the UDM and separate each of the individual names with a dash or minus character.

Suppose for the sake of argument that your Data Window R&D has you wanting to use the following 4 trainer names in a UDM:

AMOSS THOMAS M
EVANS JUSTIN R
ASMUSSEN STEVEN M
MAKER MICHAEL J

Your compiled name list would look like this:

AMOSS THOMAS M-EVANS JUSTIN R-ASMUSSEN STEVEN M-MAKER MICHAEL J

Note: The above names were pulled from a database built using HDW .JCP files that were in turn built with a JCapper program version published 4/25/2012 or later - with the CXN Names Formatting setting in the Enhanced Settings Module set to: 0 Remove Punctuation Characters causing the software to strip out commas, periods, and the single quote/apostrophe character from the names of riders, trainers, and owners when .JCP files are created. (This makes names for riders, trainers, and owners MUCH much easier to handle in sql mode.)

Examples for both playlist file (text) mode and sql mode are presented below.




SQL Mode
Use the sql INSTR (pronounced 'in string') command to create a match between your name list and the characters stored in the trainer field of the StartersToday and/or StarterHistory table.

Adding the following example line of code to your sql UDM causes your UDM to flag only those starters trained by the trainers on your compiled list:

AND INSTR('AMOSS THOMAS M-EVANS JUSTIN R-ASMUSSEN STEVEN M-MAKER MICHAEL J', TRAINER) > 0

Important: Before hitting the SAVE button on the UDM Wizard's SQL Expression Tool you would also check the Auto Format OFF checkbox. This will prevent the interface from "reformatting" the name list in the event one of the trainer names on your list contains the characters "AND" (without the quotes.)


Playlist File Mode
Paste your compiled name list into the Trainer Name field on the left hand side of the UDM Wizard's Modify UDM Screen - check the Trainer Name Test Box - and hit the SAVE button.

From there, when you click the Calc Races button, the interface will evaluate the trainer name for each starter as read from your data file and determine a True/False match against the name list as persisted to the UDM Definition in the above paragraph.




Also, here's a link to an older thread that provides a more in depth look at building connection name based UDMs:
http://www.jcapper.com/messageboard/TopicReader.asp?topic=1350&forum=JCapper%20101




-jp

.


Reply
Jens
12/31/2013
2:48:40 PM
Thanks Jeff! I was just being lazy. Individual trainer udm's didn't require the whole name and with all the trainers I was using I tried to get by with last name only. Guess it doesn't pay to take shortcuts huh?? Anyhow, thanks again.

Reply
Reply

Copyright 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com