Database Handicapping Software- JCapper

JCapper Message Board

          General Discussion
                      -- QUESTION

Home Register
Log In
By QUESTION
Caveat
3/29/2018
5:14:38 AM


Jeff....

Would you know of any data structure change to the HDW files?
I would say around the beginning of March (5 to the 7)

There seems to be something added to it when I import it into a PP generator 3rd party program..

Thxs

Mike

Reply
jeff
3/29/2018
9:13:25 AM
Saw your post on Paceadvantage.

No change in the data coming from HDW that I am aware of.

No change in the file build routine (that reads the HDW data into memory and exports out onto the hard drive as a .jcp file) that I am aware of.

Shoot me an email with a .jcp file attached -- or alternately, use the free area of the WeTransfer.com site to send me a few of your .jcp files.

I'll be happy to compare them to the ones being generated at my end.



-jp

.

Reply
Caveat
3/29/2018
4:24:44 PM
gonna check my end on this.....

its probably something in the "Enhanced " settings that I changed

dealing with comma's in Horses & Jockeys names...

For years I left it alone , maybe I eliminated it this time

or ...at least I hope so...:)

Mike

Reply
Caveat
3/29/2018
8:14:12 PM
All fixed...

I changed a setting pertaining to punctuation characters...

Thxs Jeff

Reply
jeff
4/2/2018
8:36:15 AM
Note about the CXN Names Formatting setting in the Enhanced Settings Module:

If you are using .JCP files generated by JCapper in third party apps and spreadsheets I recommend you ALWAYS persist the CXN Names Formatting setting as "0 Remove Punctuation Characters."

The (several years old now) Enhanced Settings Module Help Doc contains a brief discussion about this setting when it is set to "0 Remove Punctuation Characters."...

The main implication in the help doc being that stripping punctuation characters from rider and trainer names helps the interface perform name matching in the Profile Marker for UDMs that involve rider and trainer names.

But the setting actually controls stripping punctuation characters in much more than just the RIDER and TRAINER fields.

Fast forward to now from when the Enhanced Settings Module was first added to JCapper...

Now the setting strips "illegal" characters from pretty much every field where "illegal" characters can cause problems.

What's an illegal character?

An illegal character is any character - those that are visible on the keyboard - and those that aren't on your keyboard but appear on an ascii chart that:

a. Have shown up in the Equibase data at some point in the past.

b. Have the ability to interfere with text handling in either Visual Basic (the language JCapper is written in) or VBA (the language Excel Macros are written in) or SQL.


In short, if it has the ability to break something in JCapper:

From my perspective it's an illegal character and persisting the CXN Names Formatting setting as "0 Remove Punctuation Characters" will prevent it from showing up in the data and causing problems for you --

As happened here.


-jp

.

Reply
Reply

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