Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- CSV Help

Home Register
Log In
By CSV Help
Caveat
4/1/2014
9:23:23 AM

I had a feeling that this day will come...
I have a project that uses the Starter History JCX File Export.
I only need the prior 3 months results but JCapper exports the whole history.
That wasn't a problem till recent, now the file is too big since my SH goes back to July 2012 and excel wont let me do what I need to.
What I did prior was to sort by date and then delete the lines that I didn't want. I did this weekly to get the current results into my data...( NOTE: The "append to file" never worked with this big file or adding it onto my condensed one either)

Any suggestions?

Jeff, will it be a big to do if somehow you can get a pop-up box for a date to be plugged in before exporting? or make it list by date instead of track

Thxs

Mike


~Edited by: Caveat  on:  4/1/2014  at:  9:23:23 AM~

Reply
jeff
4/2/2014
10:19:46 AM
Bear with me... I think I got ya covered.

There's a lot of new stuff that hasn't been published yet. Included in that is a newer JCX Exports Module where the user has the ability to check a box that launches a SQL Expression Tool.

From there the user can key in a custom sql expression and hit the APPLY button. A few mouse clicks later - after selecting an output filepath - when you click the Create Export File button - the export itself is driven by the sql expression you keyed into the SQL Expression Tool (instead of the default expression that like you said dumps the entire table into the export file.)

An example sql expression to drive a StarterHistory export for calendar year 2013 might be:

SELECT * FROM STARTERHISTORY WHERE [DATE] >= #01-01-2013# AND [DATE] <= #12-31-2013#

Note: In the above expression I've wrapped the date field in square brackets and wrapped the date text with pound sign characters. (Important.)

I'm not quite there yet so far as publishing a full blown new program update... but if you give me a few hrs I'll make an effort to compile a JCX Exports Only download package and get it uploaded to the program downloads page.

Again, check back in a few hrs...


-jp

.



~Edited by: jeff  on:  4/2/2014  at:  10:19:46 AM~

Reply
Caveat
4/1/2014
11:44:05 PM

:)

Reply
jeff
4/2/2014
4:20:57 AM
It's now up on the Platinum Program Downloads page.

Here's a link to the release notes PDF:
http://www.jcapper.com/helpDocs/JCXExportsOnly.pdf


-jp

.



Reply
Caveat
4/2/2014
7:04:14 AM

Awesome Jeff!!!

Thxs

I just copy and paste your expression in the custom box and change the dates....:)


FYI..Please put the second "R" in your wording of Starterhistory


Reply
jeff
4/2/2014
10:56:54 AM
Done.

SELECT * FROM STARTERHISTORY WHERE [DATE] >= #01-01-2013# AND [DATE] <= #12-31-2013#



-jp

.

Reply
Reply

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