{"_id":"5763a67f2884ab0e00fb01d6","__v":11,"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"},"parentDoc":null,"user":"574bfb9290d8b32000864973","githubsync":"","project":"574a3bc0d1d1381900b73fab","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"},"metadata":{"title":"","description":"","image":[]},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-06-17T07:27:59.661Z","link_external":false,"link_url":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":3,"body":"It is possible to create a file that contains the complete optimization solution, along with all the planning unit metadata that were defined in the forest description.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Exporting the Complete Solution\"\n}\n[/block]\nAfter a successful optimization the complete solution can be exported as a text file by clicking the menu item `Results` and then `Export Solution` as shown below.  Browse to a directory into which the solution file can be saved and then click `OK` to continue.  The entire optimization solution will be exported and saved as a comma delimited (CSV) compliant file.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/WtKVWyC4Tr6BoX2uzujI_export-solution.jpg\",\n        \"export-solution.jpg\",\n        \"1104\",\n        \"562\",\n        \"#257cbf\",\n        \"\"\n      ],\n      \"sizing\": \"full\"\n    }\n  ]\n}\n[/block]\n<br />\nThe resulting CSV file can be double clicked and opened using Microsoft Excel.  It can then form the basis of temporary pivot tables or any other comprehensive data analysis that may be of interest.\n[block:callout]\n{\n  \"type\": \"danger\",\n  \"body\": \"The exported solution file will be large because it will contain every single event that generates information across the entire planning horizon of the forest estate model.  There may be anyway between 50,000 to 500,000+ lines in this file, and the file could be between 50MB and 500MB in file size.\",\n  \"title\": \"Warning\"\n}\n[/block]\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/fgewwSwrR8av2Z1QdX88_export-results.jpg\",\n        \"export-results.jpg\",\n        \"1185\",\n        \"774\",\n        \"#6ca484\",\n        \"\"\n      ],\n      \"sizing\": \"full\",\n      \"caption\": \"An example of the solution data.  All planning unit metadata are also included on the right-hand-side of the CSV file.\"\n    }\n  ]\n}\n[/block]","excerpt":"How to export the entire optimization solution and all associated plunit information","slug":"how-to-export","type":"basic","title":"How to Export"}

How to Export

How to export the entire optimization solution and all associated plunit information

It is possible to create a file that contains the complete optimization solution, along with all the planning unit metadata that were defined in the forest description. [block:api-header] { "type": "basic", "title": "Exporting the Complete Solution" } [/block] After a successful optimization the complete solution can be exported as a text file by clicking the menu item `Results` and then `Export Solution` as shown below. Browse to a directory into which the solution file can be saved and then click `OK` to continue. The entire optimization solution will be exported and saved as a comma delimited (CSV) compliant file. [block:image] { "images": [ { "image": [ "https://files.readme.io/WtKVWyC4Tr6BoX2uzujI_export-solution.jpg", "export-solution.jpg", "1104", "562", "#257cbf", "" ], "sizing": "full" } ] } [/block] <br /> The resulting CSV file can be double clicked and opened using Microsoft Excel. It can then form the basis of temporary pivot tables or any other comprehensive data analysis that may be of interest. [block:callout] { "type": "danger", "body": "The exported solution file will be large because it will contain every single event that generates information across the entire planning horizon of the forest estate model. There may be anyway between 50,000 to 500,000+ lines in this file, and the file could be between 50MB and 500MB in file size.", "title": "Warning" } [/block] [block:image] { "images": [ { "image": [ "https://files.readme.io/fgewwSwrR8av2Z1QdX88_export-results.jpg", "export-results.jpg", "1185", "774", "#6ca484", "" ], "sizing": "full", "caption": "An example of the solution data. All planning unit metadata are also included on the right-hand-side of the CSV file." } ] } [/block]