Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- .csv question

Home Register
Log In
By .csv question
Caveat
1/6/2014
7:12:05 PM

Hi...


Dont know if its within jcapper program or my pc..
When exporting a .csv file for "todays starters" , horses names with apostrophe's are missing the apostrophe.

The exported "starterhistory" files are good...

Would anyone know the details with this...

Thxs

mike

Reply
jeff
1/7/2014
6:42:49 PM
Just so you know current JCapper program behavior is as follows:

When the user persists 0 Remove Punctuation Characters as the setting for CXN Names Formatting in the Enhanced Settings Module, ALL punctuation characters are stripped from the following data fields when .JCP files are generated: Rider, Trainer, Owner, Breeder, Sire, Dam, Damssire, Siressire...

However, for Name of Horse:

a. Punctuation characters are NOT YET being stripped out when horsename is written to the .JCP data file.

b. Punctuation characters are NOT YET being stripped out when horsename is written to the StartersToday table during a sql calc races.

c. Punctuation characters in horsename exported to .csv files from the JCX Exports Module are determined by horsename as it exists in your StarterHistory table (see item d. immediately below.)

d. Punctuation characters ARE being stripped out when horsename is written to the StarterHistory table during a sql build database routine.

The reason I didn't initially strip out punctuation characters in (a.) and (b.) above: Horsename as listed in the Equbase scratches xml has always included the punctuation characters. Stripping out punctuation characters in (a.) and (b.) above would have meant burning programming hours to create a cruft or work around to ensure proper name matching between the xml and data file and/or starterstoday table for auto scratching horses internally within Scratch BOT. At the time, it was more important to me to get Scratch BOT published vs. doing another week of programming before making it available to you guys.




Just so you know, the JCapper program behavior I am working towards is as follows:

When the user persists 0 Remove Punctuation Characters as the setting for CXN Names Formatting in the Enhanced Settings Module, ALL punctuation characters will continue to be stripped from the following data fields when .JCP files are generated: Rider, Trainer, Owner, Breeder, Sire, Dam, Damssire, Siressire...

and for Name of Horse:

a. Punctuation characters (in an upcoming program update) WILL be stripped out when horsename is written to the .JCP data file.

b. Punctuation characters (in an upcoming program update) WILL be stripped out when horsename is written to the StartersToday table during a sql calc races.

c. Punctuation characters WILL CONTINUE to be stripped out when horsename is written to the StarterHistory table during a sql build database routine.

d. Punctuation characters (in an upcoming program update) WILL be stripped out when horsename is written to an export file using the JCX Exports Module.

e. A new name matching algorithm - one that handles horsenames that include punctuation characters when horsename is read from the xml - and makes a 100% match against horsename as pulled from the data file and/or the starterstoday table - will be integrated into 1.) Scratch BOT, 2.) Scratch Parser, and 3.) The Manual Changes Module.

FYI, this represents more programming hrs than you might think at first glance. (My estimate for getting it done and having it be RIGHT THE FIRST TIME I publish it is approx 40 hrs start to finish including testing.)




Q. Why am I working towards this info model?

A. It's simple. I'm operating in SQL Mode. One of the more common punctuation characters in a horsename is the apostrophe character... example: "Unbridled's Song" (without the quotes.) If you are trying to query by horsename (or sire, dam, trainer, rider, etc.) the presence of an apostrophe character in the name field of the record(s) you are trying to pull up renders the sql expression incapable of pulling up the records you want.

Examples:

AND HORSENAME = 'UNBRIDLED'S SONG'

AND INSTR('UNBRIDLED'S SONG', HORSENAME) > 0

The above example lines fail/are rendered useless because the database driver is expecting 2 apostrophe characters not 3.




Q. What if I want punctuation characters left intact in the data fields for CXN Names and HorseName?

A. You will have that option (in an upcoming program update) via the setting for CXN Names Formatting in the Enhanced Settings Module.


-jp

.



~Edited by: jeff  on:  1/7/2014  at:  6:42:49 PM~

Reply
Caveat
1/8/2014
8:20:21 AM

Jeff,

Thanks for answering my question..I now know why this is happening.

I am currently fooling around with an Excel project that pulls info from both files. I ran across this and thought it was unknown to you. I can manually change it to work for me ..no big deal.

Since I don't know if I will continue (or be as useful) with this..
I don't want you to waste your time to fix it , if its just for me!!

Is it possible you can list what your planning to do in updates, in priority order?

Thxs as always

Mike

Reply
Reply

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