|
JCapper Message Board JCapper 101
|
| 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~
| |
| 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~
| |
| Caveat 4/1/2014 11:44:05 PM | :)
| |
| 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 .
| |
| 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
| |
| jeff 4/2/2014 10:56:54 AM | Done. SELECT * FROM STARTERHISTORY WHERE [DATE] >= #01-01-2013# AND [DATE] <= #12-31-2013# -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |