|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Need help restoring lost JPR entries | |
| jeff 4/7/2013 12:58:57 PM | --quote: "Help! I messed up my jpr and realized that I also saved the wrong database file when saving my mdb. I saved the one that contains the starter history table. Whats the best way of getting my JPR back?"--end quote FYI, The entries for UDM Definitions, UPR, Userfactors, and JPR are found in the following file: c:\2004\JCapper.mdb The JCapper2.mdb file on the c:\JCapper\Exe folder contains entries for SQL Factor Setup, Custom HTML Report Layout, StarterHistory, WagerHistory, and TripNotes. Saving a copy of a JCapper2.mdb file on the c:\2004 folder will not by itself adversely impact JCapper program operation in any way. However, if you have deleted the JCapper.mdb file on the c:\2004 folder - THAT is another matter entirely. JCapper requires that both of its .mdb files be present on their correct folders in order to run. Based on what you wrote, I see two restore options: Option #1: If you have a good backup of the JCapper.mdb file: Copy your last known good backup JCapper.mdb file to the c:\2004 folder - and you will restore your UDM Definitions, UPR, UserFactors, and JPR back to the entries you had at the point in time your backup file was made. Done! note: This is the preferred option. Option #2: If you believe you have somehow hosed the file and/or its entries - and you DO NOT have a good backup file - then your only alternative is to start over: 1. Rename the JCapper.mdb file on the c:\2004 folder to something else (like JCapper_OLD.mdb) - the objective being to get the file out of the way. note: Do not (repeat NOT) delete the file if it contains UDM Definitions, UPR, or UserFactors that you want to recover 2. Navigate to your c:\JCapperBuild folder. There you will find a fresh blank current version JCapper.mdb file put there by the installer during your most recent program install. Note that this file contains the default entries for JPR. 3. Copy this file to your c:\2004 folder. At this point you now have a JCapper.mdb file on your c:\2004 folder that contains a good set of entries for JPR. To recover UDMs out of your old file - the file you renamed in step 1 above: 1. Launch the UDM Wizard and click the Import UDMs button in the upper right hand area of the very first screen. 2, Click the Set Source Database button and use the dialog box to select and open the renamed JCapper_OLD.mdb file on the c:\2004 folder (from step #1 above.) 3. Click the Set Target Database button and use the dialog box to select and open the new JCapper.mdb file that you copied to the c:\2004 folder (from step #3 above.) 4. Double check the source and target database files. 5. Click the GO button. Done! -jp .
| |
| jeff 4/7/2013 1:32:19 PM | I've posted this over and over again - but at the risk of repeating myself I'll post it once more. Back when I lived in the 9 to 5 world I had a boss that used to tell us 9-5 'ers the following: "A hard drive is a great place to store files on a temporary basis." In JCapper, UDM Definitions, UPR, UserFactors, SQL Factor Setup, Custom HTML Report Layout... that represents your work. If some disaster befalls you... hard drive failure, a family member unknowingly wiping the hard drive clean, theft, fire, etc. - I can help you restore a working copy of the program onto your next machine - and if you are an HDW subscriber I can even help you obtain copies of data and results files that you paid for! But the one thing I can't replace for you is your work. If you value your work - get in the habit of making regular backup copies of BOTH JCapper .mdb files: c:\2004\JCapper.mdb c:\JCapper\Exe\JCapper2.mdb But don't store them on the hard drive of the same machine you are using to run JCapper on a daily basis. (That's just asking for trouble.) Instead, store your backups files on multiple thumb drives - and even consider keeping those thumb drives at mutiple separate locations (glovebox of your car, the office, storage locker, etc.) and rotating them out. Also, consider using the cloud... Dropbox, Carbonite, etc. If and when disaster strikes... Recovery is easy because you prepared for it. -jp .
| |
| busseb 4/16/2013 6:20:33 PM | My default (JPR) is messed up. If I deleted the default UPR/JPR from JCapper.mdb... and then saved the JCapper.mdb file... then reinstalled JCapper... then imported my UDM's file (one I saved above) with the default UDM/JPR missing... would the default JPR be back to the Jeff's original and not the one I messed UP?
| |
| jeff 4/21/2013 11:05:52 AM | Doubtful. Tell you what... Zip up the c:\2004\JCapper.mdb file. Then shoot me an email with the zipped up file attached. I'll double check what you send - and paste in the correct entries for the DEFAULT groupname if needed - and shoot it back to you. -jp . ~Edited by: jeff on: 4/21/2013 at: 11:05:52 AM~
| |
| busseb 4/17/2013 3:43:43 PM | On its way. THANKS!!!
| |
| jeff 4/21/2013 11:24:07 AM | One additional point - and this was covered in the email exchange between busseb and myself - and this applies to Platinum customers... Once you edit the DEFAULT entries in the ImpactValues table - at that point you have effectively edited JPR. If you were building databases using the program DEFAULT JPR - and then later edit JPR - if you continue to build databases using the same folders and/or StarterHistory table - you will end up storing the program default JPR values in one part of your database - and you will end up storing the edited version of JPR in another part of your database. Be VERY aware of the following: Under these circumstances when you later use the Data Window to perform R&D - I recommend breaking your data out into 2 separate samples. Make the 1st sample prior to the JPR edit. Make the 2nd sample post JPR edit. Unless you do this, any comparisons between the 2 time periods will find you comparing apples and oranges. Best Practice - If you do decide to edit the DEFAULT entries in the ImpactValues table and edit JPR - it would be a VERY good idea to rebuild databases from scratch. This will cause your folders and/or StarterHistory table to contain stored JPR values that are identical in makeup across all time periods. -jp . ~Edited by: jeff on: 4/21/2013 at: 11:24:07 AM~
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |