Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- whole database table extract

Home Register
Log In
By whole database table extract
SILVER01HDW
8/10/2015
4:46:49 PM
Hi,

I would like to extract all of the data in the database and analyze it using data mining tools that I have developed.. How do I do that? Thank you!!

Sincerely,

tom

Reply
Caveat
8/10/2015
10:40:37 PM
Might help..


Try "System Setting"
then

JCX File Exports

Then use starterhistory...

this will output a csv or txt file of your whole starter history table..

mike

Reply
jeff
8/12/2015
2:46:50 PM
Adding to what Caveat posted if I may...

You might want to check out the JCX File Exports Module Only Download Package available on the Silver program downloads page.

Unlike the JCX File Exports Module that came with your initial Silver program install - the JCX File Exports Module Only Download Package will get you the ability to use custom sql expressions to drive your exports.

This will give you complete control over what table data fields (or columns) get written to your export as well complete control over filtering parameters such as [date], track, intsurface, dist, tkcond, fieldsize, paceindex, classdescriptor, rider, trainer, etc.


-jp

.

Reply
SILVER01HDW
8/12/2015
9:34:10 PM
Thank you!!!

Reply
SILVER01HDW
8/14/2015
5:01:20 PM
Hi Jeff,

I have looked through most of the messages in the downloads and tech report and cant find the JCX File Exports Module Only Download Package.. Am I looking in the wrong place? Thank you!!

Sincerely,

tom

Reply
SILVER01HDW
8/14/2015
8:34:35 PM
Hi,

When try to export the starterhistory table that way I get "error-2147217900 Description Syntax error in string in query expression "railposition".. Any ideas on what is going wrong and what I can do? Thank you!!

Sincerely,

tom

Reply
jeff
8/15/2015
7:53:12 AM

--quote:
"I have looked through most of the messages in the downloads and tech report and cant find the JCX File Exports Module Only Download Package.. Am I looking in the wrong place? Thank you!!"
--end quote


Log into the message board. Then goto the Downloads & Tech Support forum. From there click the link for the JCapper Program Downloads page (hint: far upper right hand corner.)

Once you are at the JCapper Program Downloads page you should see the download and release notes links for the JCX File Exports Module Only Special Download Package.

Link to screenshot:
http://www.JCapper.com/MessageBoard/Avatars/SilverProgramDownloadsPage08142015.jpg

Read the release notes for instructions. Then download and install.


-jp

.


Reply
jeff
8/15/2015
8:02:10 AM

--quote:
"When try to export the starterhistory table that way I get "error -2147217900 Description Syntax error in string in query expression "railposition".. Any ideas on what is going wrong and what I can do? Thank you!!"
--end quote


An error code beginning with the characters "-214" indicates the sql expression you are trying to execute is invalid in some way.

Try posting the sql expression here or emailing it to me - and I'll have a look.

jeff @ jcapper . com
(remove the blank spaces first)


-jp

.


Reply
Reply

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