Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- IMPORTANT REMINDER - New Year - Folder Structure -

Home Register
Log In
By IMPORTANT REMINDER - New Year - Folder Structure -
jeff
12/31/2013
2:03:34 PM
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 2013 files with 2014 files... But you also risk corrupting your 2013 databases in the event you run a db build using a 2013 data file and a 2014 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 2013 folder structure looks like this:

C:\2013
C:\2013\Q1_2013
C:\2013\Q2_2013
C:\2013\Q3_2013
C:\2013\Q4_2013
C:\2013\Folder2
C:\2013\Folder3


And my NEW 2014 folder structure looks like this:

C:\2014
C:\2014\Q1_2014
C:\2014\Q2_2014
C:\2014\Q3_2014
C:\2014\Q4_2014
C:\2014\Folder2
C:\2014\Folder3

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



-jp

.


Reply
joe_muller
1/1/2014
12:50:02 PM
Thanks for the reminder Jeff!

Additionally, would we use Mode 3 for our first database builds of the new year, and then mode 5 until the quarter change in April?

Thanks,
Joe M

Reply
jeff
1/1/2014
10:12:20 PM
If you want to (start over) and remove all prior year StarterHistory data from your StarterHistory table: Use Mode 3 for the first build on your 2014 folder (and Mode 5 for each subsequent build thereafter on that folder.)

If you want to KEEP prior year StarterHistory data in your StarterHistory table intact: Use Mode 4 for that first build on your 2014 folder (and Mode 5 for each subsequent build thereafter on that folder.)


-jp

.


Reply
Reply

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