{"id":782,"date":"2012-04-24T00:04:04","date_gmt":"2012-04-24T00:04:04","guid":{"rendered":"http:\/\/training.edensuite.com.au\/?page_id=782"},"modified":"2026-05-12T14:59:29","modified_gmt":"2026-05-12T04:59:29","slug":"data-migration","status":"publish","type":"page","link":"https:\/\/training.edensuite.com.au\/?page_id=782","title":{"rendered":"Data Upload (Data Migration Interface)"},"content":{"rendered":"<div class=\"pre-requisites\">\n<h2>Pre-Requisites<\/h2>\n<p><a class=\"show_hide\" href=\"#\">Show\/Hide<\/a><\/p>\n<div class=\"slidingDiv\"><\/div>\n<\/div>\n<h2>Description<\/h2>\n<p>The data migration interface can be used to bulk upload data from spreadsheets.<\/p>\n<h2>Data Migration Interface Guide<\/h2>\n<p><a title=\"Data Migration Interface\" href=\"http:\/\/training.edensuite.com.au\/wp-content\/uploads\/2019\/12\/data-migration-interfaceNov19.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Click here to learn more about the Data Migration Interface<\/a><\/p>\n<p>There is one template that can be used for any activity that just has one quantity field and one cost field.<\/p>\n<p><a href=\"https:\/\/training.edensuite.com.au\/wp-content\/uploads\/2025\/06\/DM_Template_OneQuantityOneCostFieldv2.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">Universal Data Migration Template<\/a><\/p>\n<p><a href=\"http:\/\/training.edensuite.com.au\/wp-content\/uploads\/2024\/05\/DataUploadVideo.mp4\">Click here for a video on how to use the Universal Data Migration Template<\/a><\/p>\n<p>The templates below are for activities with more than one quantity or cost field:<\/p>\n<ul>\n<li><a href=\"https:\/\/training.edensuite.com.au\/wp-content\/uploads\/2026\/05\/ComprehensiveElectricityTemplate.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">Electricity<\/a><\/li>\n<li><a href=\"https:\/\/training.edensuite.com.au\/wp-content\/uploads\/2026\/05\/Transport_Fuel_Template.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">Transport Fuel<\/a><\/li>\n<\/ul>\n<h2>Hints and Tips<\/h2>\n<ul>\n<li>Remember to remove any sample rows before uploading<\/li>\n<li>Remove any formulas<\/li>\n<li>Check the asset and measurement device names by running the Measurement Device Register report<\/li>\n<li>Only upload one file at a time and wait for it to process.<\/li>\n<li>Data migration depends on the name of the sheets in the spreadsheets. If you incorrectly name a spreadsheet or remove columns then the system will mark these as failed and you will receive an error spreadsheet that contains the error message and no data<\/li>\n<\/ul>\n<p>If you&#8217;re looking for the old templates you can find them here:<\/p>\n<ul>\n<li><a href=\"https:\/\/training.edensuite.com.au\/wp-content\/uploads\/2025\/06\/AirTravel_Template-2.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">Air Travel<\/a><\/li>\n<li><a href=\"https:\/\/training.edensuite.com.au\/wp-content\/uploads\/2023\/06\/MedicalRefrigerant_Template.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">Medical and Refrigerant gases<\/a><\/li>\n<li><a href=\"https:\/\/training.edensuite.com.au\/wp-content\/uploads\/2026\/05\/Paper_Template.xlsx\">Paper<\/a><\/li>\n<li><a href=\"https:\/\/training.edensuite.com.au\/wp-content\/uploads\/2026\/05\/NaturalGas_Template.xlsx\">Natural Gas<\/a><\/li>\n<li><a href=\"https:\/\/training.edensuite.com.au\/wp-content\/uploads\/2026\/05\/Water_Template.xlsx\">Water<\/a><\/li>\n<li><a href=\"https:\/\/training.edensuite.com.au\/wp-content\/uploads\/2026\/05\/Waste_Template.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">Waste<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pre-Requisites Show\/Hide Description The data migration interface can be used to bulk upload data from spreadsheets. Data Migration Interface Guide Click here to learn more about the Data Migration Interface &hellip; <a href=\"https:\/\/training.edensuite.com.au\/?page_id=782\"><span style=\"font-size: 10px;\">See more<\/span> <span class=\"meta-nav\"><\/span><\/a><\/p>\n","protected":false},"author":6,"featured_media":0,"parent":500,"menu_order":8,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-782","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/training.edensuite.com.au\/index.php?rest_route=\/wp\/v2\/pages\/782","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/training.edensuite.com.au\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/training.edensuite.com.au\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/training.edensuite.com.au\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/training.edensuite.com.au\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=782"}],"version-history":[{"count":36,"href":"https:\/\/training.edensuite.com.au\/index.php?rest_route=\/wp\/v2\/pages\/782\/revisions"}],"predecessor-version":[{"id":2522,"href":"https:\/\/training.edensuite.com.au\/index.php?rest_route=\/wp\/v2\/pages\/782\/revisions\/2522"}],"up":[{"embeddable":true,"href":"https:\/\/training.edensuite.com.au\/index.php?rest_route=\/wp\/v2\/pages\/500"}],"wp:attachment":[{"href":"https:\/\/training.edensuite.com.au\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}