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...
- 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.
v1.9.4 to current
Copy and paste these values into your datafile > Upgrade Database form
