top of page

Public

Public·11 members

2 days ago · joined the group along with .
16 Views

How to Update a Database

I have a database created for Assisi version 2022.1.15. I'd like to open this database in version 2024.2.6. When I try to do this I see an error message as follows:



What are the steps I need to take to update my database so I can open it in my newer version of Assisi?

55 Views
Rich Howard
Rich Howard
5 days ago

Run the Design Checker to find all the differences an older database has compared to a current version. The tool will highlight the differences that must be fixed before Assisi will properly work with your older data base.

Open the tool by clicking File | Connect. Then select your older database and click the Check Database Design button. The tool will run through all the required tables and fields to find differences from the design standard. The design standard is by definition the sample database that is installed when Assisi is setup. You should see something like the following as it runs its checks. The items in red are differences that must be changed. It can help by opening your old and the design database side by side too. The number of changes can be small to large depending on how old your database is.


Oh, be sure to first update the Version setting in the Configuration table. Version has to match before Assisi will connect or run design checks.


Hope this helps!


Strange IIF Parser Behavior

Hey @Rich Howard,


I noticed today that the parser will error out if I use IIF(X > 0, Y, Z), but accepts IIF(X <= 0, Z, Y). Any idea what's going on there?

51 Views
Rich Howard
Rich Howard
5 days ago

Eli, Sorry for the delay. I have been trying versions of the following and can't reproduce this. Do you have a simple example that errors?


This is for the User Defined equation...

X=0;
Y=1;
Z=0;
User = IIF(X>0,Y,Z)

Feature Request: More Equation Parser Variables

Hey Rich,


I think Assisi would benefit from the addition of the following metrics to the equation parser:


- Elevation

- Aspect

- Slope

- Basal area in larger trees


43 Views

I think the stand-level would be useful; most companies determine those values at the stand-level using rasters rather than at the plot-level.

About

Post questions and answers to the community of Assisi Softwa...

bottom of page