How to Import¶
The Tigermoth Software Interface is used to import an Excel format standard forest description workbook and store the forest estate data in a SQL Server database. During the importing process the underlying data are checked for error and consistency.
Importing a Standard Forest Description¶
Open and Save a Forest Description Workbook¶
The steps below show how to import a standard forest description. The easy way to demonstrate and test this process is to open Tigermoth and navigate to Tools/Templates as shown below.
Double click the standard forest description template called Description - Standard Forest Description template will all worksheets present.xlsb to open the file in Excel.
Once the file has opened then save it to a new location on the machine's local drive. The templates are read-only in their Tigermoth installation directory.
Follow the steps below to import the standard forest description workbook.
Navigate to the Forest Description Workbook¶
Using the Tigermoth software interface, click the main menu button at the top-left labelled Forest Description to view existing models and import new models.
Click the button labelled Import Forest Description. This will open a file navigation window. Navigate to the standard forest description template that was saved to the machine's local drive in the step above. Select the template and click Open.
Select a New Description Name or Overwrite Existing¶
If the forest description workbook has the same name as an existing forest estate model then that model will be automatically selected and by clicking 'OK' the new data will be imported over the top of the existing data.
Replacing an Existing Forest Description
When a new forest description is imported and overwrites an existing forest description, the new forest description will retain the existing optimization parameters and settings such as the primary year in the first period of the model, the discount rate used to determine the objective function and other optimization check box settings.
Alternatively, click the Enter a name for the new forest description radio button to import the forest description using a different name.
Additional Importing Options¶
There are currently two options that can be used when importing a forest description. At the top right-hand-side there is a check box to toggle the automatic optimization of the description after it has been imported. This is useful when the imported forest description is replacing an existing description because the optimization will automatically start and use the previous settings.
Use Parallel Processing¶
The check box at the bottom left-hand-side toggles the use of the latest parallel processing routines for SQL Server data access. These are not yet the software default, but it is advisable to always use these routines because they have more robust error checking procedures and will become the default data access routines in the future. In addition, forest description importing is much faster when very large datasets are used.
Prerequisites for Using Parallel Import Routines
The parallel processed data access routines for SQL Server requires the presence of the worksheet 'Carbon' and associated carbon definition columns on the worksheet 'Plunits'. There does not need to be data defined o.n worksheet 'Carbon' but the presence of the 'Carbon' worksheet in the forest description workbook is mandatory.
The parallel processed data access routines will no longer allow the use of the 'Origin/All' attribute grouping on either of the 'Allocation' or the 'Balancing' worksheets.
The parallel processed data access routines will now also check that two Groups with the same name do not exist. It is mandatory to use unique Group names in Row 4 of the worksheet 'Plunits'.
The parallel processed data access routines will now also check that two planning units with the same name do not exist. It is mandatory to use unique plunit names in Column B of the worksheet 'Plunits'.