Upgrading older datafiles: Difference between revisions

From ZDN User Guide
VisualWikitext
mNo edit summary
Line 10: Line 10:
==== *New* for version 2.1: ====
==== *New* for version 2.1: ====


# Enter "Alt-F11" to open up the VBA editor.
* Open up the new version
# Enter "Ctrl-G" to go to the "Immediate Window"
* When asked to link a new datafile, cancel/exit.  
# Paste the following lines of code one-at-a-time into the Immediate Window and hit <Enter>. Nothing will (apparently) happen, but this will update your tables.
* Go to Settings
* Follow the steps to link to your old datafile BUT click "CANCEL" when asked to relink. If you do accidentally click OK, cancel out of all the errors and repeat this step.
* Click the "Update" button in the Settings (upper right corner).
* Click the "Update Datafile Step 1" button
* Quit ZDN
* Open your old datafile (ZDN Support Files folder > Datafiles)
* Click the "Update Datafile Step 2" button.


CurrentDb.TableDefs("Animals").Fields("Current").Name = "Active"
==== Versions 2.0 and earlier: ====
 
CurrentDb.TableDefs("Diet Table").Fields("Current").Name = "Active"
4. Continue with the "All Versions" instructions below.
 
==== Upgrading all versions: ====
* Download the newest ZDN version and follow the "Install" section (only) of the  [[Installation|Installation instructions]] to setup. Do not open ZDN yet.
* 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
* 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

Revision as of 16:40, 27 December 2023

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* for version 2.1:

  • Open up the new version
  • When asked to link a new datafile, cancel/exit.
  • Go to Settings
  • Follow the steps to link to your old datafile BUT click "CANCEL" when asked to relink. If you do accidentally click OK, cancel out of all the errors and repeat this step.
  • Click the "Update" button in the Settings (upper right corner).
  • Click the "Update Datafile Step 1" button
  • Quit ZDN
  • Open your old datafile (ZDN Support Files folder > Datafiles)
  • Click the "Update Datafile Step 2" button.

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.

  1. Open up the new ZDN_vX.X.accdb file
  2. Delete the reports that you have modified
  3. Open up your existing (previous version) ZDN_vX.V.accdb datafile
  4. 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.

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