Calc Workspace Migration to Arena

Dear Alex,

there is no workaround, unfortunately. In Collect+Calc based method, a partial copy of Collect DB is imported into the Calc DB, for example files and multi-selection attributes are missing in Calc's schema.

I recommend these steps:

1. In Arena, create a New Survey by importing the Collect backup data.
2. In HOME section, take out the Collect Import Report and fix all remaining issues.
3. test your survey. Publish it again.
4. Create a new calculation chain.
5. Add all categorical & quantitative result attributes similarly as they were in Calc.
6. Select Sampling Design and set the base unit. Publish the survey again.
7. Start RStudio session.

In parallel, start a Calc RStudio session and copy scripts manually into the Arena R project. If Calc does not start, there are two options to get the scripts:

1. get the R scripts from C:\Users\USERNAME\OpenForisCalc\WORKSPACENAME\user (open e.g. with Notepad++), or
2. get the scripts from your postgreSQL DB. Start pgAdmin, and run a SQL Query (as below) and then Export query results into a CSV format file:

SELECT workspace.name, variable.name, script FROM calc.workspace, calc.calculation_step, calc.variable WHERE workspace.name='my_ws_name' AND workspace.id = calculation_step.chain_id AND variable.id = calculation_step.output_variable_id

There are some changes between Calc and Arena R projects:

• In Arena R project, base unit weight and entities sampling areas are in the folder \sampling
• naming of plot area variables is changed. In Calc: tree$plot_area ==> In Arena: tree$tree_plot_area_. The reason for this change is that in a Arena survey, all attribute names must be unique.

In stratified sampling case, areas of strata (AOIs in Calc) are given as Extra property ('area') in that category table, which is assigned to the (categorical) stratification attribute. Only one attribute can work as a stratification attribute. If that is a combination of two or more input attributes, it must be generated as a new categorical attribute in the chain.

In Arena, there is not yet a Saiku type reporting tool. We have started to build a new Result Data Query Tool, that will show result data (means and totals) computed for selected Dimensions and Measures. Secondly, results estimates for a two-phase sampling you can not get out via Arena (analytical) script yet, but were are working on this too.

Hope these advices can help you to take this leap!

Regards, Lauri (OF Arena Team)