{"id":1393,"date":"2016-10-23T02:07:27","date_gmt":"2016-10-23T02:07:27","guid":{"rendered":"https:\/\/wireless-telemetry.com\/blog\/?p=1393"},"modified":"2016-10-23T02:07:27","modified_gmt":"2016-10-23T02:07:27","slug":"new-data-export-utility-links-scada-system-data-with-engineering-hydraulic-modeling-software","status":"publish","type":"post","link":"https:\/\/wireless-telemetry.com\/blog\/?p=1393","title":{"rendered":"New Export Utility Links Engineering &#038; Hydraulic Modeling Software with SCADA History Data"},"content":{"rendered":"<div id=\"attachment_1843\" style=\"width: 160px\" class=\"wp-caption alignright\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1843\" src=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2023\/06\/Jim_Mimlitz_Newsletter-150x150.jpg\" width=\"150\" height=\"150\" data-srcset=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2023\/06\/Jim_Mimlitz_Newsletter.jpg 2x\" alt=\"admin\" class=\"avatar avatar-150 wp-user-avatar wp-user-avatar-150 photo\" \/><p id=\"caption-attachment-1843\" class=\"wp-caption-text\">Jim Mimlitz, NRI<\/p><\/div>\n<p>Historical Data Presentation is one of the primary functions of a SCADA System. Today, I am excited to introduce a significant upgrade that extends the usefulness of the <strong>History Database Module<\/strong> of your SCADA System!\u00a0\u2014\u00a0a new, powerful\u00a0<strong>Data Export Module<\/strong> that provides the Operator and his Civil Engineers with access to raw, time-stamped data.<\/p>\n<p>The exported data is provided in an open textual format which can be inserted into third party data analysis software such as Excel, or into Civil Engineering hydraulic modeling software.<\/p>\n<p>The familiar browser-based Operator Interface now offers a history data export utility link, as illustrated in the screenshot below:<\/p>\n<div id=\"attachment_1427\" style=\"width: 497px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2016\/10\/Export_Utility_01ss.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1427\" class=\"size-full wp-image-1427\" src=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2016\/10\/Export_Utility_01ss.jpg\" alt=\"Browser-Based User Interface Now Features a New History Data Export Feature.\" width=\"487\" height=\"1018\" \/><\/a><p id=\"caption-attachment-1427\" class=\"wp-caption-text\">Browser-Based User Interface Now Features a New History Data Export Feature.<\/p><\/div>\n<p>When the Operator or Engineer clicks on the &#8220;Export&#8221; link, the following screen is presented, which allows the selection of data tags of interest, as well as the desired date range:<\/p>\n<div id=\"attachment_1428\" style=\"width: 748px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2016\/10\/Export_Utility_02ss.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1428\" class=\"size-full wp-image-1428\" src=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2016\/10\/Export_Utility_02ss.jpg\" alt=\"History Data Export Selection Screen. Operator Selects Date Range and Tags of Interest.\" width=\"738\" height=\"1018\" \/><\/a><p id=\"caption-attachment-1428\" class=\"wp-caption-text\">History Data Export Selection Screen. Operator Selects Date Range and Tags of Interest.<\/p><\/div>\n<p>After the History Data Export Utility is executed with a mouse-click, a link to the finished .CSV file is provided, as illustrated in the following screenshot:<\/p>\n<div id=\"attachment_1429\" style=\"width: 748px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2016\/10\/Export_Utility_03ss.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1429\" class=\"size-full wp-image-1429\" src=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2016\/10\/Export_Utility_03ss.jpg\" alt=\"Export Feedback Window. A Link to the Finished .CSV File is Provided.\" width=\"738\" height=\"1018\" \/><\/a><p id=\"caption-attachment-1429\" class=\"wp-caption-text\">Export Feedback Window. A Link to the Finished .CSV File is Provided.<\/p><\/div>\n<p>At this point, the Operator or Engineer clicks on the &#8220;<strong>Click Here to View CSV File<\/strong>&#8221; link and is prompted to open or store the file:<\/p>\n<div id=\"attachment_1426\" style=\"width: 748px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2016\/10\/Export_Utility_04ss.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1426\" class=\"size-full wp-image-1426\" src=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2016\/10\/Export_Utility_04ss.jpg\" alt=\"Operator is Prompted to Open or Store the File.\" width=\"738\" height=\"1018\" \/><\/a><p id=\"caption-attachment-1426\" class=\"wp-caption-text\">Operator is Prompted to Open or Store the File.<\/p><\/div>\n<p>The .CSV file may then be opened using Microsoft Excel, Civil Engineering hydraulic modeling software, or even a simple text file editor:<\/p>\n<div id=\"attachment_1401\" style=\"width: 1038px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2016\/10\/Export_Utility_07.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1401\" class=\"size-full wp-image-1401\" src=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2016\/10\/Export_Utility_07.jpg\" alt=\"CSV File Imported into Microsoft Excel.\" width=\"1028\" height=\"976\" \/><\/a><p id=\"caption-attachment-1401\" class=\"wp-caption-text\">CSV File Opened with Microsoft Excel.<\/p><\/div>\n<p>&nbsp;<\/p>\n<div id=\"attachment_1399\" style=\"width: 468px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2016\/10\/Export_Utility_05.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1399\" class=\"size-full wp-image-1399\" src=\"https:\/\/wireless-telemetry.com\/blog\/wp-content\/uploads\/2016\/10\/Export_Utility_05.jpg\" alt=\"CSV File Exported into Microsoft Windows Text Editor &quot;Notepad&quot;.\" width=\"458\" height=\"918\" \/><\/a><p id=\"caption-attachment-1399\" class=\"wp-caption-text\">CSV File Opened with Microsoft Windows Text Editor &#8220;Notepad&#8221;.<\/p><\/div>\n<p>The new <strong>Data Export Utility<\/strong> is designed to be 100% compatible with all existing NRI SCADA systems; and it has been thoroughly beta-tested and found to perform extremely efficiently. Now, we are ready to roll it out to our entire SCADA client base.<\/p>\n<p>Although this is not being offered as a free upgrade, the cost is very reasonable \u2014 especially if the target Water Utility is\u00a0enrolled in the <strong>TeamViewer Remote Management System<\/strong>. \u00a0It is important to note that the upgrade purchase provides a perpetual, portable license that can be carried forward \u2014 even if a new Telemetry Server(s) is purchased in the future.<\/p>\n<p>If you feel that this new capability can\u00a0be of value and benefit to you and the Water District, let me know and we&#8217;ll get started.<\/p>\n<p>As always, if you have any questions, please don&#8217;t hesitate to reach out by phone or email.<\/p>\n<p><strong>Telemetry, SCADA, &amp; Controls Newsletter<\/strong><\/p>\n<p>Was this article helpful?\u00a0 Would you be interested in receiving updates such as these in our occasional email-delivered newsletter?\u00a0 If so, here&#8217;s our sign-up page:<\/p>\n<p><a href=\"https:\/\/www.wireless-telemetry.com\/signup\/signup.htm\">Subscribe to\u00a0Navionics Research&#8217;s\u00a0&#8220;Telemetry, SCADA, &amp; Controls Newsletter&#8221;<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Historical Data Presentation is one of the primary functions of a SCADA System. Today, I am excited to introduce a significant upgrade that extends the usefulness of the History Database Module of your SCADA System!\u00a0\u2014\u00a0a new, powerful\u00a0Data Export Module that provides the Operator and his Civil Engineers with access to raw, time-stamped data. The exported <span class=\"ellipsis\">&hellip;<\/span> <span class=\"more-link-wrap\"><a href=\"https:\/\/wireless-telemetry.com\/blog\/?p=1393\" class=\"more-link\"><span>Read More &rarr;<\/span><\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":1400,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,8,10,14],"tags":[131],"class_list":["post-1393","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general","category-historical-trending","category-interface","category-report-generation","tag-scada-history-data-export"],"_links":{"self":[{"href":"https:\/\/wireless-telemetry.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wireless-telemetry.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wireless-telemetry.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wireless-telemetry.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wireless-telemetry.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1393"}],"version-history":[{"count":0,"href":"https:\/\/wireless-telemetry.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1393\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wireless-telemetry.com\/blog\/index.php?rest_route=\/"}],"wp:attachment":[{"href":"https:\/\/wireless-telemetry.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wireless-telemetry.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wireless-telemetry.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}