Upgrading older datafiles: Difference between revisions

From ZDN User Guide
VisualWikitext
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 12: Line 12:
* In ZDN:
* In ZDN:
** Open up the new version of 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)
** 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 '''''<u>load</u>''''' 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 datafile" button sand follow the instructions.
** Click the "Update datafile Part A" button and follow the pop-up instructions carefully.
** Quit ZDN
**
* In the datafile:
* In the datafile:
** Open the datafile you just updated (ZDN Support Files folder > Datafiles)
** Click the "Update Datafile Part B" button.
** Click the "Update Datafile Step 2" button.
** Quit the datafile
** Quit the datafile
* Reopen ZDN, and relink it (in Settings) to your updated 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:
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
 
== 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]]
< [[Installation]]


> [[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.

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"