Database Handicapping Software- JCapper

JCapper Message Board

          General Discussion
                      -- IMPORTANT REMINDER - New Year - Folder Structure -

Home Register
Log In
By IMPORTANT REMINDER - New Year - Folder Structure -
jeff
1/2/2017
11:28:53 AM
It's that time again. (Time to create folder structure for the coming new year.)

One of the things you NEVER want to do is mix and match files from different years on the same folder. The file names of data and results files that you download do not contain a year element.

Unless you create (and use) folder structure for the new year:

Not only do you run the risk of overwriting 2016 files with 2017 files... But you also risk corrupting your 2016 databases in the event you run a db build using a 2016 data file and a 2017 results file (or vice versa) for file names involving the same track code, month, and day of month.

I (personally) use a single folder for each year with 4 separate sub folders (one per calendar quarter) and 2 additional sub folders (to facilitate breaking up my race day into multiple groups in the DFM Card Loader.)


My old 2016 folder structure looks like this:

C:\2016
C:\2016\Q1_2016
C:\2016\Q2_2016
C:\2016\Q3_2016
C:\2016\Q4_2016
C:\2016\Folder2
C:\2016\Folder3


My new 2017 folder structure looks like this:

C:\2017
C:\2017\Q1_2017
C:\2017\Q2_2017
C:\2017\Q3_2017
C:\2017\Q4_2017
C:\2017\Folder2
C:\2017\Folder3


For the next several days, I will be toggling folders back and forth inside the DFM being EXTREMELY careful that all 2016 files are saved to my C:\2016\Q4_2016 folder - and that all 2017 files are saved to my C:\2017\Q1_2017 folder.




Year end is probably a good time to check the file size of your c:\JCapper\Exe\JCapper2.mdb file. The max size for any .mdb file allowed by Windows is 2.0 gigabytes (2000 mb.)

If you are at 1.5 gigabytes or larger it's probably a VERY good idea to bite the bullet now and rename your c:\JCapper\Exe\JCapper2.mdb file to something like c:\JCapper\Exe\JCapper2_YE2013.mdb - which serves to 1. Get the file out of the way and 2. Archive the file in such a way that you can connect to it using the Data Window MENU.

From there navigate to your c:\JCapperBuild folder, find the fresh blank copy of the JCapper.2.mdb file put there by the installer (filename: c:\JCapperBuild\JCapper2.mdb) and copy that file to your c:\JCapper\Exe folder. (Important: Make sure that you complete the file rename process first!)

From there use the JCapper2 Import Module to import the sql factor setup and html report layout out of your old file into your new file - and at this point your're all set for the new year.

Note: Here's a link to an older thread titled JCapper2.mdb file - what you need to know that contains comprehensive background info about folder structure and managing JCapper2.mdb files:
http://www.jcapper.com/MessageBoard/TopicReader.asp?topic=1340&forum=JCapper%20101





-jp

.

Reply
Reply

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