|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | UPR database build | |
| pdavid6 6/11/2013 9:13:29 AM | I'm sure this has been asked and answered before, however should I build database from scratch or is it okay to build it from append if I have made a new UPR from HDW data that I want to apply? ~Edited by: pdavid6 on: 6/11/2013 at: 9:13:29 AM~
| |
| Charli125 6/11/2013 11:39:31 AM | I'll say that if I change UPR, which I've only done once, I rebuild everything from scratch. I THINK it's a requirement, but don't quote me on that. Because other factors rely on UPR, I think you have to start over otherwise when you run something broken out by say UPR rank, you'll get your new UPR values from when you changed it, and your old UPR values from before.
| |
| pdavid6 6/11/2013 1:21:51 PM | That makes sense and is what I thought. I just wanted to make sure. Thanks for the reply.
| |
| jeff 6/11/2013 3:58:00 PM | Here's how it works... When you build a database, the program performs the following: 1. Data gets written to the text file (filename: pl_profile.txt) on the folder where the build is run. (True for all modes: 1,2,3,4,5.) 2. Data gets written to the StarterHistory table in the c:\JCapper\Exe\JCapper2.mdb file. (True for modes: 3,4,5 only.) Note that data written to disc during the above 2 steps is based on definitions for UPR and UserFactors as they exist at the time each build database routine is run. If you later modify your definitions for UPR and UserFactors - that by itself doesn't change existing data already sitting in pl_profile.txt files and/or the StarterHistory table. To change existing data in pl_profile.txt files and/or the StarterHistory table - you have to rebuild databases from scratch. Use Mode 3 on the very first folder. Use Mode 4 on each subsequent folder until you've brought everything current. At this point, once you've brought everything current - your pl_profile.txt files and StarterHistory table will be populated with data based on your new UPR and/or UserFactor definitions. From here - use Mode 5 as you add new files on a daily basis to your current data folder. -jp .
| |
| pdavid6 6/11/2013 6:13:48 PM | Got it. Thanks Jeff.
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |