Upgrading older datafiles: Difference between revisions

From ZDN User Guide
VisualWikitext
 
(9 intermediate revisions by the same user not shown)
Line 8: Line 8:
= If you HAVE entered data about your zoo, feeds, animals, or diets... =
= If you HAVE entered data about your zoo, feeds, animals, or diets... =


==== *New* for version 2.1: ====
==== *New* simpler update process for version 2.1 and beyond: ====


* Open up the new version of ZDN
* In ZDN:
* When asked to link a new datafile, cancel/exit out of all the warnings AND the setup screen to return to Welcome Switchboard.
** Open up the new version of ZDN
* Go to Settings
** Go to Settings (or the Settings Setup pop-up that appears if no datafile is linked yet) V2.2 and later: click the "update datafile" button.
* 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.
** Follow the steps to link to your old datafile (v2.1 and earlier: '''BUT click "NO"''' when asked if you want to '''''<u>load</u>''''' 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.
** Click the "Update datafile Part A" button and follow the pop-up instructions carefully.
* Quit ZDN
**
* Open your old datafile (ZDN Support Files folder > Datafiles)
* In the datafile:
* Click the "Update Datafile Step 2" button.
** Click the "Update Datafile Part B" button.
* Quit the datafile, reopen ZDN, and relink to your shiny updated datafile. If you want to continue using your existing ZDN Support Files folder, add the following files from the new version:
** 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 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
* Move the new DietAnalysis_2.2.xltm file from your new ZDN Support Files > Templates folder to your existing Templates folder


==== Versions 2.0 and earlier: ====
== Upgrading to v2.3 ==
* Download the newest ZDN version and follow the "Install" section (only) of the  [[Installation|Installation instructions]] to setup. Do not open ZDN yet.
Tips and tricks:
* 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"
* Be sure to update your analysis spreadsheets to the new v2.3 ones
|ANIMALS
** File Explorer: Copy 2.3 versions of both templates from your download to ZDN Support Files > Templates
|ParkID
** ZDN: Settings > Diet Analysis - change to 2.3 versions
|INTEGER
* Depending on your updating process, you may run into issues with the NUTR_DEF table. I changed the name of "BGT_Name" to "Local_Name". If you get a message about this:
|-
** Open up your datafile (make sure you and everyone else using it has quit ZDN first)
|PARKS
** Press [F11] to show tables (if they aren't already showing down the left side)
|ZIMS_Park_Name
** Open up "NUTR_DEF" table
|TEXT
** Either:
|-
*** Select the column called "BGT_Name" and copy it to the "Local_Name" column
|GOALS
*** or
|GoalID
*** Rename the column called "BGT_Name" to "Local_Name" (right click on NUTR_DEF and choose "Design View")
|INTEGER
** While you are there, "Compact and Repair" (Database Tools  > Compact and Repair) the datafile.
|-
* Even once you do that, you might run into issues with calories and some other nutrients not showing up in the analysis. If this is the case:
|GOALS
** Download the latest version (2.3.03) and open the sample file.
|GoalCategory
** Open your datafile
|TEXT
** Arrange the two windows so you can see both
|-
** Open the NUTR_DEF table in both windows
|GOALS
** Drag the columns around until they match each other
|GoalTitle
** Delete everything from NUTR_DEF in your file
|TEXT
** Copy and paste everything from the SampleZoo NUTR_DEF table into your table.
|-
** Compact and Repair (Database Tools  > Compact and Repair) the datafile.
|GOALS
** If you get a message about deleting relationships:
|GoalDescription
*** Open Database Tools > Relationships
|TEXT
*** Find the NUTR_DEF table and delete all the lines that go to it
|-
*** Try the above steps again
|GOALS
*** Email Heidi if you have trouble - this can get tricky.
|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... ====
< [[Installation]]
Please keep a list of the items you have modified.


# Open up the new ZDN_vX.X.accdb file
> [[Common issues|Common installation issues]]
# 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.

Latest revision as of 19:22, 7 August 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) V2.2 and later: click the "update datafile" button.
    • Follow the steps to link to your old datafile (v2.1 and earlier: 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 Part A" button and follow the pop-up instructions carefully.
  • In the datafile:
    • Click the "Update Datafile Part B" 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.2.xltm file from your new ZDN Support Files > Templates folder to your existing Templates folder

Upgrading to v2.3

Tips and tricks:

  • Be sure to update your analysis spreadsheets to the new v2.3 ones
    • File Explorer: Copy 2.3 versions of both templates from your download to ZDN Support Files > Templates
    • ZDN: Settings > Diet Analysis - change to 2.3 versions
  • Depending on your updating process, you may run into issues with the NUTR_DEF table. I changed the name of "BGT_Name" to "Local_Name". If you get a message about this:
    • Open up your datafile (make sure you and everyone else using it has quit ZDN first)
    • Press [F11] to show tables (if they aren't already showing down the left side)
    • Open up "NUTR_DEF" table
    • Either:
      • Select the column called "BGT_Name" and copy it to the "Local_Name" column
      • or
      • Rename the column called "BGT_Name" to "Local_Name" (right click on NUTR_DEF and choose "Design View")
    • While you are there, "Compact and Repair" (Database Tools  > Compact and Repair) the datafile.
  • Even once you do that, you might run into issues with calories and some other nutrients not showing up in the analysis. If this is the case:
    • Download the latest version (2.3.03) and open the sample file.
    • Open your datafile
    • Arrange the two windows so you can see both
    • Open the NUTR_DEF table in both windows
    • Drag the columns around until they match each other
    • Delete everything from NUTR_DEF in your file
    • Copy and paste everything from the SampleZoo NUTR_DEF table into your table.
    • Compact and Repair (Database Tools  > Compact and Repair) the datafile.
    • If you get a message about deleting relationships:
      • Open Database Tools > Relationships
      • Find the NUTR_DEF table and delete all the lines that go to it
      • Try the above steps again
      • Email Heidi if you have trouble - this can get tricky.

< Installation

> Common installation issues

Retrieved from "https://zoodiets.com/documentation/index.php?title=Upgrading_older_datafiles&oldid=485"