Upgrading older datafiles
From ZDN User Guide
If you have not yet changed/added any data.
- Simply replace your existing ZDN program and files with the new versions
- Remove both the old version and the ZDN Support Files folder
- Download new version
- Follow original installation instructions
If you HAVE entered data about your zoo, feeds, animals, or diets...
*New* simpler update process for version 2.1 and beyond:
- Open up the new version of ZDN
- When asked to link a new datafile, cancel/exit out of all the warnings AND the setup screen to return to Welcome Switchboard.
- Go to Settings
- Follow the steps to link to your old datafile BUT click "NO" when asked if you want to load the new file. If you do accidentally click Yes, cancel out of all the errors and repeat this step.
- Click the "Update" button in the Settings (upper right corner) and follow the instructions.
- Quit ZDN
- Open your old datafile (ZDN Support Files folder > Datafiles)
- Click the "Update Datafile Step 2" button.
- Quit the datafile, reopen ZDN, and relink to your shiny updated datafile.
You may want to move two files from the new ZDN Support Files folder to your existing installation:
- Move the NaviGatorIcon3.ico file from your new ZDN Support Files > Images folder to your existing Images folder
- Move the new DietAnalysis_2.1.xltm file from your new ZDN Support Files > Templates folder to your existing Templates folder
Updating older datafiles to ZDN Versions 2.0 and earlier:
- Download the newest ZDN version and follow the "Install" section (only) of the Installation instructions to setup. Do not open ZDN yet.
- Copy your OLD ZDN datafile from your [old location] > ZDN Support Files > Datafiles > your_datafile_name.accdb into your new ZDN Support Files > Datafiles folder
- Open up your datafile from the NEW location (located inside ZDN Support Files > Datafiles)
- Paste in the table below and click "Update"
| ANIMALS | ParkID | INTEGER |
| PARKS | ZIMS_Park_Name | TEXT |
| GOALS | GoalID | INTEGER |
| GOALS | GoalCategory | TEXT |
| GOALS | GoalTitle | TEXT |
| GOALS | GoalDescription | TEXT |
| GOALS | GoalStartDate | DATE |
| GOALS | GoalEndDate | DATE |
| GOALS | DietID | INTEGER |
| NUT_DATA2 | QualityIndex | INTEGER |
| SPECIALORDERS | DIETID | INTEGER |
| SPECIALORDERS | FOODID | INTEGER |
| SPECIALORDERS | GROUP_AMOUNT | DOUBLE |
| SPECIALORDERS | UNITID | INTEGER |
| SPECIALORDERS | Prep_Loc | INTEGER |
| SPECIALORDERS | LINENOTES | TEXT |
| SPECIALORDERS | OrderDate | DATE |
| SPECIALORDERS | OrderBy | TEXT |
| SPECIALORDERS | CreatedOn | date |
| SPECIALORDERS | RequestedBy | TEXT |
| SPECIALORDERS | Reason | TEXT |
| SPECIALORDERS_PAST | DIETID | INTEGER |
| SPECIALORDERS_PAST | FOODID | INTEGER |
| SPECIALORDERS_PAST | GROUP_AMOUNT | DOUBLE |
| SPECIALORDERS_PAST | UNITID | INTEGER |
| SPECIALORDERS_PAST | Prep_Loc | INTEGER |
| SPECIALORDERS_PAST | LINENOTES | TEXT |
| SPECIALORDERS_PAST | OrderDate | DATE |
| SPECIALORDERS_PAST | OrderBy | TEXT |
| SPECIALORDERS_PAST | CreatedOn | date |
| SPECIALORDERS_PAST | RequestedBy | TEXT |
| SPECIALORDERS_PAST | Reason | TEXT |
| FEEDINGSCHEDULES | DIET_SUB_ID | INTEGER |
| FEEDINGSCHEDULES | F_Orig_Avg_Daily_g | INTEGER |
| FEEDINGSCHEDULES | F_FOODID | INTEGER |
| FEEDINGSCHEDULES | F_UNITID | INTEGER |
| FEEDINGSCHEDULES | F_IND_AMOUNT | DOUBLE |
| FEEDINGSCHEDULES | F_GROUP_AMOUNT | DOUBLE |
| FEEDINGSCHEDULES | F_SU | YESNO |
| FEEDINGSCHEDULES | F_M | YESNO |
| FEEDINGSCHEDULES | F_T | YESNO |
| FEEDINGSCHEDULES | F_W | YESNO |
| FEEDINGSCHEDULES | F_R | YESNO |
| FEEDINGSCHEDULES | F_F | YESNO |
| FEEDINGSCHEDULES | F_S | YESNO |
| FEEDINGSCHEDULES | F_FRQ_WEEKS | INTEGER |
| FEEDINGSCHEDULES | F_FRQ_ROTATION | INTEGER |
| FEEDINGSCHEDULES | F_Feed_Avg_Daily_g | DOUBLE |
| FEEDINGSCHEDULES | F_Matches_orig_amt | YESNO |
| FEEDINGSCHEDULES | F_FeedingCategory | TEXT |
| TBLANIMALENCLOSUREHISTORY | DietChangeDate | DATE |
| TBLANIMALENCLOSUREHISTORY | DIETID | INTEGER |
| TBLANIMALENCLOSUREHISTORY | AnimalGAN | TEXT |
| TBLANIMALENCLOSUREHISTORY | EnclosureID | INTEGER |
| TBLANIMALENCLOSUREHISTORY | Type | TEXT |
| TBLANIMALENCLOSUREHISTORY | AnimalUnits | DOUBLE |
| RECIPEINGREDIENTSTABLE | IngredientNote | TEXT |
If you have made changes to forms and reports...
Please keep a list of the items you have modified.
- Open up the new ZDN_vX.X.accdb file
- Delete the reports that you have modified
- Open up your existing (previous version) ZDN_vX.V.accdb datafile
- Copy the reports from X.V (yours) to X.X (the new one).
Important Note: If your datafile was created prior to v1.9.4...
Contact Heidi for assistance upgrading your datafile.
