Upgrading older datafiles: Difference between revisions

From ZDN User Guide
mNo edit summary
mNo edit summary
Line 28: Line 28:


> [[Common issues|Common installation issues]]
> [[Common issues|Common installation issues]]
==== Obsolete if using the newest versions: ======== Updating older datafiles to ZDN Versions 2.0 and earlier: ====
* Download the newest ZDN version and follow the "Install" section (only) of the  [[Installation|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"
{| class="wikitable"
|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... =
[https://zoodiets.com/contact-zdn/ Contact Heidi] for assistance upgrading your datafile.

Revision as of 22:32, 16 February 2024

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:

  • In ZDN:
    • Open up the new version of ZDN
    • Go to Settings (or the Settings Setup pop-up that appears if no datafile is linked yet)
    • 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 datafile" button sand follow the instructions.
    • Quit ZDN
  • In the datafile:
    • Open the datafile you just updated (ZDN Support Files folder > Datafiles)
    • Click the "Update Datafile Step 2" button.
    • Quit the datafile
  • Reopen ZDN, and relink it (in Settings) to your 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

< Installation

> Common installation issues