{"_id":"57620e1fc4b4191700751a88","version":{"_id":"574a3bc0d1d1381900b73fae","project":"574a3bc0d1d1381900b73fab","__v":7,"createdAt":"2016-05-29T00:45:52.939Z","releaseDate":"2016-05-29T00:45:52.939Z","categories":["574a3bc0d1d1381900b73faf","574be6d52aa7221700c51bed","574c0b6d281b010e00008f89","574c1afbcf99610e00ef7d2b","574d13b9a1f0be2000ae3803","574d14140db0870e0075382d","591eb3a72c1b1f0f000fa9f2"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"3517.0.0","version":"3517"},"__v":85,"category":{"_id":"574d13b9a1f0be2000ae3803","project":"574a3bc0d1d1381900b73fab","__v":0,"version":"574a3bc0d1d1381900b73fae","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2016-05-31T04:31:53.407Z","from_sync":false,"order":9999,"slug":"2-optimisation","title":"2. Optimization"},"githubsync":"","project":"574a3bc0d1d1381900b73fab","user":"574bfb9290d8b32000864973","parentDoc":null,"metadata":{"title":"","description":"","image":[]},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-06-16T02:25:35.154Z","link_external":false,"link_url":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":0,"body":"The optimization software interface is used to import the 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.\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Importing a Standard Forest Description\"\n}\n[/block]\nThe steps below show how to import a standard forest description.  For new users then the easy way to test this process is to open the software and navigate to Tools / Templates as shown below.  Then open the standard forest description template called '**Description - Standard Forest Description template will all worksheets present.xlsb**'.  Once this is open then save it to a new location on your hard drive.  The Templates are read-only in their installation directory.  Once of copy of the template has been saved then follow the steps below to import and optimize the forest description.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/pbxFW8cSCaGZS8xSA0JF_import-template.jpg\",\n        \"import-template.jpg\",\n        \"1105\",\n        \"480\",\n        \"#d4282f\",\n        \"\"\n      ],\n      \"sizing\": \"full\"\n    }\n  ]\n}\n[/block]\n<br />\n##Step 1 - Navigate to the Forest Description Workbook\nOpen the software and click the button at the top-left-hand-side labelled 'Forest Description', and then click the button labelled 'Import Forest Description'.  This will open a navigation window that can be used to select the Microsoft Excel workbook that holds the forest description.\n<br />\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/yH4F1yRsWdje5Qqq1gzA_import-description.jpg\",\n        \"import-description.jpg\",\n        \"1107\",\n        \"782\",\n        \"#d32830\",\n        \"\"\n      ],\n      \"sizing\": \"full\",\n      \"caption\": \"\"\n    }\n  ]\n}\n[/block]\n<br />\n##Step 2 - Select a New Description Name or Overwrite Existing\nIf 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.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/tJDipPBSpy06PRE79mBW_import-overwrite.jpg\",\n        \"import-overwrite.jpg\",\n        \"711\",\n        \"424\",\n        \"#2583ce\",\n        \"\"\n      ],\n      \"sizing\": \"80\"\n    }\n  ]\n}\n[/block]\n<br />\nAlternatively, click the 'Enter a name for the new forest description' radio button to import the forest description using a different name.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/aLXcVswhSdahXrmtDfEL_import-new.jpg\",\n        \"import-new.jpg\",\n        \"711\",\n        \"424\",\n        \"#227ec6\",\n        \"\"\n      ],\n      \"sizing\": \"80\"\n    }\n  ]\n}\n[/block]\n<br />\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Additional Importing Options\"\n}\n[/block]\nThere 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 previously defined settings.\n[block:callout]\n{\n  \"type\": \"info\",\n  \"body\": \"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, and the discount rate used to determine the objective function.  Other optimization check box settings are also retained.\",\n  \"title\": \"Replacing an Existing Forest Description\"\n}\n[/block]\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/r1O3YQD6S8SBIUx3WKR7_import-options.jpg\",\n        \"import-options.jpg\",\n        \"711\",\n        \"424\",\n        \"#1f7ec8\",\n        \"\"\n      ],\n      \"sizing\": \"80\"\n    }\n  ]\n}\n[/block]\nThe 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.\n[block:callout]\n{\n  \"type\": \"danger\",\n  \"title\": \"Prerequisites for Using Parallel Import Routines\",\n  \"body\": \"1. 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.\\n\\n2. 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.\\n\\n3. 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'.\\n\\n5. 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'.\"\n}\n[/block]\n<br />","excerpt":"How to import a standard forest description data into the system.","slug":"how-to-import","type":"basic","title":"How to Import"}

How to Import

How to import a standard forest description data into the system.

The optimization software interface is used to import the 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. <br /> [block:api-header] { "type": "basic", "title": "Importing a Standard Forest Description" } [/block] The steps below show how to import a standard forest description. For new users then the easy way to test this process is to open the software and navigate to Tools / Templates as shown below. Then open the standard forest description template called '**Description - Standard Forest Description template will all worksheets present.xlsb**'. Once this is open then save it to a new location on your hard drive. The Templates are read-only in their installation directory. Once of copy of the template has been saved then follow the steps below to import and optimize the forest description. [block:image] { "images": [ { "image": [ "https://files.readme.io/pbxFW8cSCaGZS8xSA0JF_import-template.jpg", "import-template.jpg", "1105", "480", "#d4282f", "" ], "sizing": "full" } ] } [/block] <br /> ##Step 1 - Navigate to the Forest Description Workbook Open the software and click the button at the top-left-hand-side labelled 'Forest Description', and then click the button labelled 'Import Forest Description'. This will open a navigation window that can be used to select the Microsoft Excel workbook that holds the forest description. <br /> [block:image] { "images": [ { "image": [ "https://files.readme.io/yH4F1yRsWdje5Qqq1gzA_import-description.jpg", "import-description.jpg", "1107", "782", "#d32830", "" ], "sizing": "full", "caption": "" } ] } [/block] <br /> ##Step 2 - 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. [block:image] { "images": [ { "image": [ "https://files.readme.io/tJDipPBSpy06PRE79mBW_import-overwrite.jpg", "import-overwrite.jpg", "711", "424", "#2583ce", "" ], "sizing": "80" } ] } [/block] <br /> Alternatively, click the 'Enter a name for the new forest description' radio button to import the forest description using a different name. [block:image] { "images": [ { "image": [ "https://files.readme.io/aLXcVswhSdahXrmtDfEL_import-new.jpg", "import-new.jpg", "711", "424", "#227ec6", "" ], "sizing": "80" } ] } [/block] <br /> <br /> [block:api-header] { "type": "basic", "title": "Additional Importing Options" } [/block] 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 previously defined settings. [block:callout] { "type": "info", "body": "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, and the discount rate used to determine the objective function. Other optimization check box settings are also retained.", "title": "Replacing an Existing Forest Description" } [/block] [block:image] { "images": [ { "image": [ "https://files.readme.io/r1O3YQD6S8SBIUx3WKR7_import-options.jpg", "import-options.jpg", "711", "424", "#1f7ec8", "" ], "sizing": "80" } ] } [/block] 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. [block:callout] { "type": "danger", "title": "Prerequisites for Using Parallel Import Routines", "body": "1. 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.\n\n2. 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.\n\n3. 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'.\n\n5. 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'." } [/block] <br />