Automatic Export to Excel User Manual V.1.01
Contents
1. 16 e Group select the first grouping of measured variables e g Accumu lators Depending on your selection the contents of the subgroup subgroup 2 and measured variables list change 3 Electro Industries GaugeTech Doc E134747 The Leader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export to Excel Subgroup select the second grouping of measured variables e g Energy Depending on your selection the contents of the subgroup 2 and measured variables list change Subgroup 2 select the third grouping of measured variables e g Scaled Primary Depending on your selection the contents of the measured variables list changes Variables list select a measured variable and click the Add button under this field to copy it to the Expression box at the bottom of the screen b Select the operator to include select an arithmetic operation e g multiply and click the Add button under this field to copy the oper ation to the Expression field c Include a numeric constant if you want enter a numeric constant in this field and click the Add button under the field to add the constant to the Expression field d Click the Validate Expression button under the Expression field to make sure your expression is mathematically correct e Click Save to save your custom variable click Exit to close the screen without saving I MPORTANT In order to export the custom variab2. Nexus 1500 Meter Designation Serial Num ber logs INTERVAL_ n g _ Electro Industries GaugeTech Doch E134747 3 3 The Leader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export to Excel Example for the Nexus amp 1500 meter s Log 4 C Documents and Settings All Users Documents Electro ndustriesY Communicator_Ext Retrieved Logs Nexus 1500 0000000028203621 logs INTERVAL_4 5 To create a Template click the Create New Template button You will see the screen shown below Rm z 9 iF Automatic Export to Excel Template Definition HE X Configuration Template Device Type Nexus 1200 Nexus 1250 60 70 52 62 72 Template name Il Active Only Active Templates will be considered for the Automatic Export process Logs to Export Export Formats Log 1 Log 2 E PE csv Variables to Export Special Variables Ea ES ES Devices to Export Selectable Devices Selected Devices 1272_IP73 Nexus 1 rs Ea e CY 6 Device Type is the same as your selection on the Main screen Enter the following information Template Name enter a name for the Template here Active Checkbox this setting is for the Automatic export mode Click this box to activate the Template process it when the Automatic export process runs If you don t want this Template to be processed when Automatic export runs leave the checkbox empty 3 Electro Industries GaugeTech Doc E1347
3. click Exit to close the screen without saving the Template You will be on the Main screen again Electro Industries GaugeTech Doc E134747 The Leader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export to Excel 8 To perform a Manual export click the Export Now button in the middle of the Main screen You will see a Confirmation window click OK and you will see the screen shown below NOTE If you are running the Auto Export application in Automatic mode a message window opens telling you that the Auto Export Windows based Service was stopped Click the OK button to continue Automatic mode must be selected again after the Manual export it will not restart automatically Automatic Export to Excel Manual Expo Manual Export Select the input database Time Range Selection Options Between During the previous hour s amp During the previous day s S During the previous week s During the previous month s S During the previous year s 9 Make the following settings Select the input database click the Browse button to select the log file db you want to export Time Range Selection Options use these settings to specify a date and time range for the export process All of the Template s log file variables that fall within this time range are exported amp Electro Industries GaugeTech Doc E134747 The Leader In Power Mon
4. 2012 0 Energy Primary Internal KYZ Relay 2 During the previous month s Energy Primary Internal KYZ Relay 3 02 26 2012 Energy Primary Internal KYZ Relay 4 F 8 During the previous year s Energy Scaled Quadrant 1 2 3 4 VAh 5 Energy Scaled Quadrant 1 2 VARh Energy Scaled Quadrant 3 4 VARh Energy Scaled Quadrant 1 4 Wh Energy Scaled Quadrant 1 VAh Energy Scaled Quadrant 1 VARh Energy Scaled Quadrant 4 VAh Fnerav ScaledY Quadrant 4 VARh Im Me s historical Logs in the meters Lm wo Y a SHARK200 E 9 me fe 5 2 2 Installation amp Operation Manual V 1 01 February 27 2012 Electro Industries hauge Tech The Leader In Power Monitoring and Smart Grid Solutions 1800 Shames Drive Westbury NY 11590 Tel 516 334 0870 Fax 516 338 4741 Email sales electroind com This page intentionally left blank Auto Export Installation and Operation Manual Version 1 01 Published by Electro Industries GaugeTech 1800 Shames Drive Westbury NY 11590 All rights reserved No part of this publication may be reproduced or transmitted in any form or by any means electronic or mechanical including photocopying record ing or information storage or retrieval systems or any future forms of duplication for any purpose other than the purchaser s use without the expressed written permission of Electro Industries GaugeTech O 2012 Electro I
5. this setting lets you specify the variables to be included in the export file You have the following options for variables amp Electro Industries GaugeTech Doc E134747 3 5 The Leader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export to Excel Select Variables to Include click this button to select the log variables you want in the export file You will see the screen shown below S Atomatic Expo rog Variables tancum a NN Select Variables to Include Selectable items normal and custom variables Selected items in the position thatthey will appearin the export file Group Subgroup Subgroup2 Energy Primary Internal KYZ Relay 2 Energy Primary Internal KYZ Relay 3 Energy Primary Internal KYZ Relay 4 IMPORTANT The Selected Items must match with the Data Points programmed in the historical Logs in the meters ok O eu 9 a Enter the following settings Group select the first grouping of measured variables e g Accumu lators Depending on your selection the contents of the subgroup subgroup 2 and measured variables list change Subgroup select the second grouping of measured variables e g Energy Depending on your selection the contents of the subgroup 2 and measured variables list change Subgroup 2 select the third grouping of measured variables e g Scaled Primary Depending on your selection the contents of the mea
6. to Excel This page intentionally left blank Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Doc E134747 A Troubleshooting A Troubleshooting A 1 Manually Uninstalling the Windows Based Service In the event that the Windows based Service used for the Automatic export pro cess is modified in the PC where the Auto Export application is installed and the service can t be uninstalled or the service is orphaned perform the following proce dure to manually uninstall the service 1 Run command prompt cmd exe from the Windows Start menu run it as admin istrator if the Windows version is Vista or 7 2 Type the following command sc delete EIG Automatic Export to Excel This will uninstall the Windows9 based Service in the PC After that you can run the Auto Export installer program to perform a new installation of the exporter software see Chapter 2 for instructions Electro Industries GaugeTech Doc E134747 The Leader In Power Monitoring and Smart Grid Solutions A Troubleshooting This page intentionally left blank Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Doc E134747
7. 0 92896 14212 80579 424 5727539 411 8530273 417 2668457 _12 02 26 2012 00 15 00 14297 77588 14274 43909 14163 73718 426 1230469 414 0014648 415 637207 13 02 26 2012 00 30 00 14341 45752 14249 90479 14167 92664 427 4963379 413 482666 414 3432617 _14 02 26 2012 00 45 00 14277 43103 14273 24158 14178 09814 425 5187988 413 9160156 416 8395996 _15 02 26 2012 01 00 00 14339 66309 14224 1748 14196 64856 426 1230469 411 3342285 414 1723633 _16 02 26 2012 01 15 00 14280 42297 14240 3302 14212 80579 425 3479004 412 1948242 417 7001953 _17 02 26 2012 01 30 00 14272 64282 14270 24963 14186 47522 425 5187988 413 659668 417 5231934 _18 02 26 2012 01 45 00 14315 12878 14223 57605 14212 20703 426 550293 412 0239258 416 6687012 _19 02 26 2012 02 00 00 14299 57031 14276 23352 14160 74524 425 604248 413 482666 414 7766113 _20 02 26 2012 02 15 00 14342 05627 14245 71533 14172 11426 427 154541 412 8845215 413 9160156 _21 02 26 2012 02 30 00 14289 3988 14234 94507 14214 00146 426 4648438 412 8845215 418 3837891 _22 02 26 2012 02 45 00 14342 65503 14238 53577 14175 70496 426 9836426 412 5427246 414 0014648 _23 02 26 2012 03 00 00 14313 93127 14269 65088 14158 95081 426 6357422 413 9160156 414 7766113 _24 02 26 2012 03 15 00 14339 66309 14250 50354 14168 52539 427 7526855 413 9160156 414 7766113 _25 02 26 2012 03 30 00 14278 02795 14275 63477 14176 30371 426 1230469 414 3432617 417 3522949 _26 02 26 2012 03 45 00 14277 43103 14276 83228 14170 91858
8. 0579 424 5727539 411 8530273 417 2668457 8 2 26 2012 0 15 14297 77588 14274 43909 14163 73718 426 1230469 414 0014648 415 637207 Hoa 2 26 2012 0 30 14341 45752 14249 90479 14167 92664 427 4963379 413 482666 414 3432617 10 2 26 2012 0 45 14277 43103 14273 24158 14178 09814 425 5187988 413 9160156 416 8395996 ELE 2 26 2012 1 00 14339 66309 14224 1748 14196 64856 426 1230469 411 3342285 414 1723633 pee 2 26 2012 1 15 14280 42297 14240 3302 14212 80579 425 3479004 412 1948242 417 7001953 13 2 26 2012 1 30 14272 64282 14270 24963 14186 47522 425 5187988 413 659668 417 5231934 _14 2 26 2012 1 45 14315 12878 14223 57605 14212 20703 426 550293 412 0239258 416 6687012 15 2 26 2012 2 00 14299 57031 14276 23352 14160 74524 425 604248 413 482666 414 7766113 _16 2 26 2012 2 15 14342 05627 14245 71533 14172 11426 427 154541 412 8845215 413 9160156 17 2 26 2012 2 30 14289 3988 14234 94507 14214 00146 426 4648438 412 8845215 418 3837891 18 2 26 2012 2 45 14342 65503 14238 53577 14175 70496 426 9836426 412 5427246 414 0014648 E 2 26 2012 3 00 14313 93127 14269 65088 14158 95081 426 6357422 413 9160156 414 7766113 _20 2 26 2012 3 15 14339 66309 14250 50354 14168 52539 427 7526855 413 9160156 414 7766113 E23 2 26 2012 3 30 14278 02795 14275 63477 14176 30371 426 1230469 414 3432617 417 3522949 _22 2 26 2012 3 45 14277 43103 14276 83228 14170 91858 425 177002 413 3972168 416 0644531 23 2 26 2012 4 00 14319 31641 14267 85645 14159 54956 427 0690918 414 086
9. 2 0 select this if you are using Microsoft Office 2007 OS Electro Industries GaugeTech Doc E134747 3 11 The Leader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export to Excel e Microsoft ACE OLEDB 14 0 select this if you are using Microsoft Office 2010 OS b Click the OK button to save the selection Click Exit to close the screen without saving your selection 13 Click the X in the right corner of the Main screen to close the application 3 2 2 Modifying or Deleting a Device or Template You can modify or delete a previously saved device or Template 1 From the Main screen select the Device or Template in the Available Templates Available Devices fields See the screen shown below Automatic Export to Excel Main on Templates and Devices p MEM Nexus 1200 Nexus 1250 60 70 52 62 72 AwiebeTempees MEEEITAZTS seo CresteNew Device Template 1 Inactive Nexus 1 Selected Template Manual Export Manual Export will use the current selected Template Automatic Export Automatic Export will use all the Active Templates for all the Device Types IMPORTANT Click the button to save the Il Enable Disable Asiam 9 fio configuration Checked Box starts a Windows Service for aut c export Unchecked Box stops the u Save mj Windows Service Version 2 0 48 Click the Modify button to open the Template or Device screen
10. 425 177002 413 3972168 416 0644531 _27 02 26 2012 04 00 00 14319 31641 14267 85645 14159 54956 427 0690918 414 0869141 414 7766113 _28 02 26 2012 04 15 00 14322 9071 14264 8645 14160 74524 427 8442383 414 6057129 415 4602051 _29 02 26 2012 04 30 00 14345 04822 14234 34631 14176 90247 427 2399902 412 713623 414 3432617 _30 02 26 2012 04 45 00 14273 24158 14275 63477 14175 70496 425 604248 413 9160156 416 8395996 _31 02 26 2012 05 00 00 14330 68726 14257 68311 14159 54956 427 6672363 414 3432617 414 7766113 _32 02 26 2012 05 15 00 14282 81616 14236 14258 14214 00146 426 4648438 413 0554199 418 9880371 _33 02 26 2012 05 30 00 14309 1449 14269 05212 14160 14648 426 0375977 413 3117676 414 5141602 34 02 26 2012 05 45 00 14345 04822 14233 74756 14180 49133 427 6672363 412 9699707 414 8620605 M 4 gt 02 26 2012 02 27 2012 Complete month az i Electro Industries GaugeTech Doch E134747 The Leader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export to Excel Each csv output file contains data for the complete month only See the example file below B E D E F G H 1272 IP73 Start Date amp Time 2 27 2012 18 00 2 Meter Serial 90000010 End Date amp Time 2 27 2012 18 00 3 Company Name EIG _4 Meter Allocation Westbury 5 6 Date Time Inst Van Inst Vbn Inst Vcn Inst la Inst Ib Inst Ic Inst In pio 2 26 2012 0 00 14276 83228 14240 92896 14212 8
11. 47 3 4 The Leader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export to Excel Logs to Export checkboxes click the checkbox to select the log s you will export using this template You can select Log 1 Log 2 and or Log 3 one or more logs NOTE For the Nexus 1500 meter select Log 1 ONLY e Export Formats checkboxes click the XLS checkbox to export the log as an Excel file click the CSV checkbox to export the log as a csv file You can select either or both formats Email Configuration button when you are using Automatic export mode you can set up the email feature to automatically send the exported file s to the email address es you specify Click the button to configure the email settings You will see the screen shown below Email Configuration If you wantto include more than one email separate them with the character Example email1 yahoo com email2 gmail com Sender Ema BEBNRPEREAREMEEEEEEEEEEEEEBA N IMPORTANT Email Configuration only works with Automatic B l a Enter the following settings SMTP Server enter the IP address of the SMTP Server or the Hostname Destination emails enter the email address es you want to send the file s to Separate emails with a semicolon Sender Email enter the sender s email address b Click OK to save your settings click Exit to close the screen without saving settings Variables to Export
12. 9141 414 7766113 _24 2 26 2012 4 15 14322 9071 14264 8645 14160 74524 427 8442383 414 6057129 415 4602051 25 2 26 2012 4 30 14345 04822 14234 34631 14176 90247 427 2399902 412 713623 414 3432617 _26 2 26 2012 4 45 14273 24158 14275 63477 14175 70496 425 604248 413 9160156 416 8395996 E25 2 26 2012 5 00 14330 68726 14257 68311 14159 54956 427 6672363 414 3432617 414 7766113 28 2 26 2012 5 15 14282 81616 14236 14258 14214 00146 426 4648438 413 0554199 418 9880371 E291 2 26 2012 5 30 14309 1449 14269 05212 14160 14648 426 0375977 413 3117676 414 5141602 30 2 26 2012 5 45 14345 04822 14233 74756 14180 49133 427 6672363 412 9699707 414 8620605 _31 2 26 2012 6 00 14340 85876 14234 34631 14181 68884 428 1860352 413 5742188 415 3747559 _32 2 26 2012 6 15 14337 26807 14225 37048 14191 26343 427 154541 412 1948242 415 1184082 _33 2 26 2012 6 30 14285 80811 14275 63477 14162 5415 425 5187988 413 482666 415 637207 _34 2 26 2012 6 45 14296 57837 14231 35437 1421400146 426 1230469 412 0239258 417 5231934 35 2 26 2012 7 00 14305 5542 14224 77173 14214 60022 426 8981934 412 3657227 417 7856445 36 2 26 2012 7 15 14341 45752 14236 14258 14176 90247 426 8127441 412 109375 413 8305664 M 4 gt n 1272 IP73 logi 022012 The output file name is as follows Device Name Log Number Month Year xls or csv e Electro Industries GaugeTech Doc E134747 3d The Leader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export
13. AUTO EXPORT The Automatic Export to Microsoft Excel Spreadsheet Software Application m we 09 00 ce gt Electro Industries haugeTech Eg The Leader in Power Monitoring and Control 5 Meter Name 1272 IP73 Start Date amp Time 0 6 Meter Serial 90000010 End Date amp Time Oz 7 Company Name EIG 8 Meter Allocation Westbury 9 10 Date Time I Inst Van I Inst Vbn I 11 02 26 2012 00 00 00 14276 83228 14240 92896 12 02 26 2012 00 15 00 14297 77588 14274 43909 13 02 26 2012 00 30 00 14341 45752 14249 90479 14 02 26 2012 00 45 00 14277 43103 14273 24158 15 02 26 2012 01 00 00 14339 66309 14224 1748 16 02 26 2012 01 15 00 14280 42297 14240 3302 17 02 26 2012 01 30 00 14272 64282 14270 24963 18 02 26 2012 0 o 14315 12878 14223 57605 19 02 26 2012 0 14299 57031 14276 23352 20 02 26 2012 02 15 00 14342 05627 14245 71533 21 02 26 2012 02 30 00 14289 3988 14234 94507 22 02 26 2012 0 23 02 26 2012 0 Automatic Export to Excel Variables to Include 24 02 26 2012 03 15 FESTETT 25 02 26 2012 0 SEA EE ES EEERSENTUTTS T 26 02 26 2012 0 poeta tme i fovea te 27 02 26 2012 0 Group s Between 28 02 26 2012 04 15 23 021282012 08 ae During the previous hour s 31 02 26 2012 05 00 pene el During the previous day s 32 02 26 2012 0 Subgroup2 During the previous 33 02 26 2012 0 Scaled Primary 34 02 26
14. Automatic export mode Access this User Manual online Click the Help button Change Connection Settings 3 2 1 Creating a Device Template You need to set up both at least one device and at least one Template for the device s The device is the meter you are downloading files from and the template lets you specify the input and output directories and the output configuration settings for your data file data points calculations totalizing and header data 1 Select the Device Type that you want to configure from the pull down menu The available types are Nexus amp 1200 Nexus amp 1250 60 70 52 62 72 meters Nexus amp 1500 or Shark amp 200 meters Any available Templates and devices for that Device Type will be shown in the Available Templates and Available Devices fields in the screen 2 To create a device click the Create New Device button You will see the screen shown below Device Information aT ETT N Nexus 1200 Nexus 1250 60 70 52 62 72 Input Path C Users Public Documents Electro Industries Communicator_Ext Browse I Output Path 3 Electro Industries GaugeTech Doc E134747 The Leader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export to Excel 3 Device Type is the same as your selection on the Main screen Enter the following information Device Name this must be the same as the Device Name programmed for this meter e Input Path thi
15. Follow the instructions in Section 3 2 1 to make any changes to the Template or Device 3 Electro Industries GaugeTech Doc E134747 The Leader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export to Excel Click the Delete button to delete a saved Template or Device You will see a Confirmation window click OK to delete click Cancel to not delete NOTE Before you are able to delete a device it must be removed from any Templates that use it Use the Modify Selected Template button and remove the meter from the Selectable Devices field see page 3 9 for instructions 3 2 3 Exporting and Importing Templates You can export a Template to another PC or import a Template from another PC You do this by copying the Templates database which contains all of the Template files on the host PC the PC where the Template database files are stored The Templates are saved in the Data directory on the host PC The location of this directory depends on your PC s OS e For Windows XP OS C Documents and Settings All Users Application Data Elec tro Industries Automatic Export to Excel DB Templates mdb e For Windows Vista and Windows 7 OS C ProgramData Electro Indus tries Automatic Export to Excel DB Templates mdb NOTE In Windows 7 OS the ProgramData file may be hidden If you do not see the file follow these steps to make it visible Electro Industries GaugeTech Doc E134747 The Le
16. ader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export to Excel 1 From the C drive click Organize gt Folder and Search Options Organize Share with New folder Burn Cut Copy Paste Undo Redo Select all Layout Folder and search options Delete Rename Remove properties Properties Close amp Computer Network BA Control Panel 3 Recycle Bin J Adobe FrameMaker Adobe CS E145751 dsgn ers EULA PATH k Windows dell sdr Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Doc E134747 3 Using Automatic Export to Excel 2 Click the View tab and click the Show hidden files folders and drives radio button Once you copy the Templates database you can import it into another computer in the same program path i e ProgramData Electro Industries VAutomatic Export to Excel DB r Folder Options General View Search Folder views You can apply the view such as Details or Icons that you L are using for this folder to all folders of this type Apply to Folders Reset Folders Advanced settings kF iles and Folders _ Always show icons never thumbnails E Always show menus Display file icon on thumbnails Display file size information in folder tips Display the full path in the title bar Clas
17. cation e g if you are going to be installing a newer version of the program 1 Click Start Control Panel gt Programs gt Uninstall a program You will see a list of the programs on your computer 2 Double click the Auto Export application You will see the message shown below m Adobe AIR Adobe Systems Incorporated 1 26 2012 n Adobe Community Help Adobe Systems Incorporated 1 26 2012 E Adobe Connect Add in 1 26 2012 M Adobe Creative Suite 5 Master Collection Adobe Systems Incorporated 1 16 2012 169GB BB Adobe Flash Player 11 ActiveX 64 bit Adobe Systems Incorporated 2 20 2012 6 00 MB Il Adobe Flash Player 11 Plugin Programs and Features 6 00 MB ll Adobe FrameMaker 10 0 1 927 MB Bl Adobe Media Player A Are you sure you want to uninstall Automatic Export to Excel BB Adobe Reader X MUI 470 MB i din ipid rt In the future do not show me this dialog box ae fe Apple Software Update Rpp T 238MB Ask Toolbar Ask com 2 6 2012 3 27 MB T Automatic Export to Excel Electro Industries 2 10 2012 3 55MB S Bing Bar Microsoft Corporation 12 14 2011 v Bonjour Apple Inc 3 8 2012 204MB E Communicator Ext Electro Industries GauaeTech 3 13 2012 3 Click Yes and follow the prompts to uninstall the program i Electro Industries GaugeTech Doch E134747 The Leader In Power Monitoring and Smart Grid Solutions 2 Installation This page intentionally left blank Electro Indu
18. e The Auto Export application can be used along with EI G s Script amp Scheduler You can set up Script amp Scheduler to perform log retrieval on a regular interval then set up the Automatic mode of the Auto Export application to convert the retrieved logs into the Excel file See Chapter 15 of the Communicator EXT User Manual for instructions on using Script amp Scheduler A separate Excel file is created for each month for which data exists in the log database Each Excel file contains a sheet for each day in the month as well as a sheet for the month as a whole When you are running the Automatic mode of the Auto Export application the retrieved logs are checked at the intervals you specify and any new data is written to the Excel file This software can automatically email monthly usage spreadsheets to users This feature is very useful for sending data to load planners and estimators When you set up the Template for your Excel file you specify the values data points you want to bring in from the retrieved logs You can also specify totalizing fields sum average etc and calculated fields The Leader In Power Monitoring and Smart Grid Solutions i Electro Industries haugeTech Doch E134747 1 1 1 Overview I MPORTANT You must specify the data points you want to see on your spreadsheet both in the Auto Export application and in your meter See the Communicator EXT User Manual for inst
19. es folders You can also run the Setup Windows 4 The setup file for the Auto Export application is located on the Installation CD in 4 8 2009 3 30 PM Configuration setti 5 2011 10 40 PM Application 5 5 2011 10 40 PM Windows Installer 4 17 201111 57 PM Adobe Acrobat D installer if necessary 1KB 458 KB 1 945 KB 1 532 KB the Content AutomaticExcelExport folder see the previous section 5 Double click the setup Application file not the Setup Windows installer see the screen capture below 8 setup fe Setup Double click this icon 5 5 2011 10 40 PM Application 5 5 2011 10 40 PM Windows Installer Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Doc E134747 2 Installation 6 You will see the screen shown below P fe Automatic Export to Excel Welcome to the Automatic Export to Excel Setup Wizard The installer will guide you through the steps required to install Automatic Export to Excel on your computer WARNING This computer program is protected by copyright law and international treaties Unauthorized duplication or distribution of this program or any portion of it may result in severe civil or criminal penalties and will be prosecuted to the maximum extent possible under the law 7 Click Next You will see the screen shown below fe Automatic Export to Excel Confirm I
20. ion 3 1 3 2 1 Creating a Device Template 3 2 3 2 2 Modifying or Deleting a Device or Template 3 12 3 2 3 Exporting and Importing Templates 3 13 3 3 Output File Structure 3 15 A Troubleshooting A 1 A 1 Manually Uninstalling Windows based Service A 1 i Electro Industries GaugeTech Doc E134747 TOC 1 The Leader In Power Monitoring and Smart Grid Solutions Table of Contents This page intentionally left blank 3 Electro Industries GaugeTech Doc E134747 TOC 2 The Leader In Power Monitoring and Smart Grid Solutions 1 Overview 1 Overview The Auto Export application is a Windows based Service that lets you export retrieved EIG meters log data from Communicator EXT 3 0 software directly to a Microsoft Excel spreadsheet or a Comma Separated Values csv file Additionally you can set up the application to automatically email the exported files to any addresses you choose NOTE A Windows based Service is a program that is under the control of Win dows Service Control Manager A Windows based Service program launches and runs in the background as long as the Windows operating system is running After you install the Auto Export application you can program it to automatically take historical log database files and export them into a customized Excel spread sheet or csv file at whatever frequency you specify e g daily You also have the option of performing a Manual export
21. itoring and Smart Grid Solutions 3 Using Automatic Export to Excel 10 Click Export Now to begin the export process You will see a progress bar while data is being exported Click Exit to close the screen without performing a Manual export 11 Automatic Export use this part of the Main screen to configure automatic exporting of the log files All active Templates see page 3 4 for all Device Types will be exported during an Automatic export Also if you have configured the email feature the exported files will be sent to the email addresses you specified see page 3 5 for instructions a Make these settings Enable Disable button click the checkbox to enable Automatic export leave the button empty to disable it Frequency of Data Export select the frequency using the Hours Minutes pull down fields b Click the Save button to save the Automatic export configuration 12 Connection Settings Depending on the version of Windows OS you are running you may need to change the Connection settings Click this button to open the screen shown below Automatic Export to Excel Connection Settings ne Lo S jme Connection Settings Data Provider for DB files Microsoft Jet OLEDB 4 0 Y ro ONE C a Select one of the Data Providers for DB files from the pull down menu e Microsoft J et OLEDB 4 0 select this if you are using Microsoft Office 2003 OS e Microsoft ACE OLEDB 1
22. le you must select it from the Variables to Include window see the instructions on pages 3 6 3 7 Electro Industries GaugeTech Doc E134747 The Leader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export to Excel Group Variables click this button to choose group variables to be included in the Template You will see the screen shown below Define Group Variables Selectable items Selected items This screen allows you to choose totalizing options for your Excel file These variables operate upon an entire data set column for a given date They are placed after the last date record in the set a Select a group variable e g Average from the Selectable Items list and click the Add button to move it to the Selected Items list To remove a group variable from the Selected Items list select it and click Remove It is moved back to the Selectable items list b Click OK to save the selected group variables They will now be included in the export file Click Exit to close the screen without sav ing any added group variables Devices to Export this setting lets you specify one or more devices for log downloads for this Template Select the device and click Add to add it to the Selected Devices list To remove a device from the Selected Devices list click on it and click Remove NOTE You can assign a device to more than one Template 7 Click Save to save this Template
23. ndustries GaugeTech Nexus and Shark are registered trademarks of Electro Industries GaugeTech The distinctive shapes styles and overall appearances of the Nexus amp 1500 meter and all Shark meters are trademarks of Electro Industries GaugeTech Auto Export is a trademark of Electro Industries GaugeTech Microsoft Excel and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and or other countries Software version 2 0 48 amp Electro Industries GaugeTech Doc E134747 The Leader In Power Monitoring and Smart Grid Solutions This page intentionally left blank Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Doc E134747 Customer Service and Support Customer support is available 9 00 am to 4 30 pm Eastern Standard Time Monday through Friday Please have the serial number and a detailed problem description available When returning any merchandise to EIG a return materials authorization number is required For customer or technical assistance phone 516 334 0870 or fax 516 338 4741 Product Warranty Electro I ndustries GaugeTech warrants all products to be free from defects in material and workmanship for a period of four years from the date of shipment During the warranty period we will at our option either repair or replace any product that proves to be defective To exercise this warranty fax
24. nstallation The installer is ready to install Automatic Export to Excel on your computer Click Next to start the installation Cancel Back Electro Industries GaugeTech Doc E134747 The Leader In Power Monitoring and Smart Grid Solutions 2 Installation 8 Click Next You will see the screen shown below f fe Automatic Export to Excel Installing Automatic Export to Excel Automatic Export to Excel is being installed Please wait 9 Once the application is installed you will see the screen shown below fr ie Automatic Export to Excel Installation Complete Automatic Export to Excel has been successfully installed Click Close to exit Please use Windows Update to check for any critical updates to the NET Framework Cancel Back Close 10 The installation is now complete Click Close and restart your PC Electro Industries GaugeTech Doc E134747 The Leader In Power Monitoring and Smart Grid Solutions 2 Installation NOTE The installation program size is 110 MB It contains the following components to insure correct performance of the Auto Export application Microsoft NET Framework 1 1 Internet Explorer 6 0 Microsoft MDAC 2 6 and Windows Installer 2 2 Uninstalling the Application Follow this procedure in the event that you need to uninstall the Auto Export appli
25. or call our customer support department You will receive prompt assistance and return instructions This warranty does not apply to defects resulting from unauthorized modification or misuse THIS WARRANTY IS IN LIEU OF ALL OTHER WARRANTIES EXPRESSED OR IMPLIED INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABIL ITY OR FITNESS FOR A PARTICULAR PURPOSE ELECTRO INDUSTRIES GAUGETECH SHALL NOT BE LIABLE FOR ANY INDIRECT SPECIAL OR CONSEQUENTIAL DAMAGES ARISING FROM ANY AUTHORIZED OR UNAUTHORIZED USE OF ANY ELECTRO INDUSTRI ES GAUGETECH PRODUCT LIABILITY SHALL BE LIMITED TO THE ORIGINAL COST OF THE PRODUCT SOLD Disclaimer The information presented in this publication has been carefully checked for reliability however no responsibility is assumed for inaccuracies The information contained in this document is subject to change without notice i Electro Industries GaugeTech Doc E134747 Hi The Leader In Power Monitoring and Smart Grid Solutions This page intentionally left blank Electro Industries GaugeTech Doc E134747 The Leader In Power Monitoring and Smart Grid Solutions Table of Contents Table of Contents Customer Service and Support iii Product Warranty iii Disclaimer iii 1 Overview 1 1 2 Installation 2 1 2 1 Installing the Application 2 1 2 2 Uninstalling the Application 2 5 3 Using the Auto Export Application 3 1 3 1 Opening the Application 3 1 3 2 Using the Applicat
26. robat D Adobe Acrobat D Adobe Acrobat D 9 302 KB 7 675 KB 1 624 KB 1 284 KB 1 662 KB 1 161 KB 1 200 KB 1 225 KB 1 156 KB 01 2 7 201 10 39 AM 10 39 AM 2 7 2012 10 39 AM 2 7 2012 10 38 AM 7 2 2 2 ComEXT manual F 200s manual F 100s manual A Setup CDM 2 04 06 Virtual COM port VCP Driv a dotnetfx2 readme a dotnetfx G Locuriurv JL USB TO IrDA Driver k AutomaticExcelExport 11 17 2011 5 08 PM 6 9 2011 11 15 AM 9 12 2008 8 10 AM 9 4 2007 11 14 AM 3 2007 5 24 PM 11 16 2011 8 38 A 1 16 2011 8 33 A 10 20 2011 9 24 A 12 2 2009 12 03 PM 11 21 2011 10 14 11 21 2011 10 13 Adobe Acrobat D Adobe Acrobat D Adobe Acrobat D Application Application Application Text Document Application Application File folder File folder 15 877 KB 19 831 KB 19 969 KB 71 780 KB 2 160 KB 22 960 KB 1 KB 23 698 KB 52 KB Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Doc E134747 2 Installation 3 Double click the AutomaticExcelExport folder to open it You will see the screen shown below Name JL OtherPrograms Date modified Type 11 21 201110 13 File folder SetupFiles 11 21 2011 10 13 File folder 45 settings 8 7 setup qe Setup User Manual for Automatic Export to Excel You will find the files you need in the Other Programs and Setup Fil
27. ructions on programming data points through Communicator EXT The next chapter contains instructions for installing the Auto Export application Electro Industries GaugeTech Doc E134747 The Leader In Power Monitoring and Smart Grid Solutions 2 Installation 2 Installation 2 1 Installing the Application I MPORTANT If you previously installed an earlier version of the Auto Export application you must uninstall the previous version before installing this version If you do not do that the new installation will fail Write down the previous version s meter settings as the current version of the application is not backward compatible i e the previous version s settings are not preserved See Section 2 2 for uninstall instructions 1 To access the folder insert the Product CD into your PC and choose Open folder to view Files Using Windows Explorer or open the CD through My Computer 2 You will see a folder labeled Content Double click the file to open it See the sample screen shown below Name Date modified Type Size b shark200 manual m shark manual F Quickstart 100S F Quickstart 200T F Quickstart 100BT 7 F Quickstart 100B 2 7 F Quickstart 100 X Quickstart 200 F Quickstart 100T 5 09 PM 1 113 PM 2 05 PM 0 39 AM 2 2 2 2 2 10 39 AM 2 2 Adobe Acrobat D Adobe Acrobat D Adobe Acrobat D Adobe Acrobat D Adobe Acrobat D Adobe Acrobat D Adobe Ac
28. s is the location of the historical log database files Click the Browse button to locate the files on your PC Output Path this is the location for the exported files Click the Browse button to choose a location Device Serial you can enter the meter s serial number here Any entry is included in the export file s header Company Name you can enter your company s name here Any entry is included in the export file s header Device Location you can enter the meter s location here Any entry is included in the export file s header 4 Click Save to save this device click Exit to close the screen without saving the device IMPORTANT NOTE REGARDING NEXUS amp 1500 Meter The Nexus 1500 meter has eight historical logs and you must set up a separate Device ID for each of the historical logs you want to export from the meter The Input Path for the device should point to the Interval log in the Retrieved logs database For Windows Vista 2008 7 OS the path is C Users Public Documents Electro I ndustries Communicator_Ext Retrieved Logs Nexus 1500 Meter Designation Serial Number logs INTERVAL_ nj Example for the Nexus amp 1500 meter s Log 4 C Users Public Documents Electro I ndustries Communicator_Ext Retrieved Logs Nexus_ 1500 0000000028203621MogsM NTERVAL 4 For Windows XP OS the path is C Documents and Settings All Users Documents Electro Industries Communicator_Ext Retrieved Logs
29. sic theme only Hidden files and folders Don t show hidden files folders or drives Q Show hidden files folders and drives V Hide empty drives in the Computer folder Hide extensions for known file types Hide protected operating system files Recommended _ Launch folder windows in a separate process Restore Defaults Cancel Apply Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Doc E134747 3 Using Automatic Export to Excel 3 3 Output File Structure The file generated by the Auto Export application is in either an Excel spreadsheet format or a Comma Separated Values csv format Each Excel output file contains data for a month or less depending on your set tings This data is divided into worksheets which each contain the data for one day A worksheet for the complete month is included in the last position See the example file below B c D E F G Eg i Electro Industries GaugeTech a The Leader in Power Monitoring and Control 5 Meter Name 1272 IP73 Start Date amp Time 02 27 2012 18 00 15 6 Meter Serial 90000010 End Date amp Time 02 27 2012 18 00 17 7 Company Name EIG 8 Meter Allocation Westbury 9 10 Date Time inst Van Inst Voen Inst ven mstia instib istic inst _11 02 26 2012 00 00 00 14276 83228 1424
30. stries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Doc E134747 3 Using Automatic Export to Excel 3 Using the Auto Export Application 3 1 Opening the Application You access the Auto Export application from the Window s Start menu If you are using Windows XP Operating system OS the path is Start Programs Electro Industries2 Automatic Export to Excel If you are using Windows 7 OS the path is Start gt All Programs gt Electro Industries2 Automatic Export to Excel 3 2 Using the Application When the Auto Export application opens you see the Main Screen shown below W Automatic Export to Excel Main Ae o gt iol Templates and Devices Boe Nexus 1200 Nexus 1250 60 70 52 62 72 EmA v Available Templates E Available Devices Manual Export Manual Export will use the current selected Template Automatic Export Automatic Export will use all the Active Templates for all the Device Types Ill Enable Disable ts a Windows Service for Unchecked Box stops the Windows Service Version 2 0 48 This screen allows you to Create modify or delete an export configuration Devices and Templates e Perform a Manual export to an Excel file or a csv file Electro Industries GaugeTech The Leader In Power Monitoring and Smart Grid Solutions Doc E134747 3 Using Automatic Export to Excel Set up
31. sured variables list changes Measured Variables list select a measured variable and click Add to move it to the Selected Items list To remove a measured variable from the Selected Items list select it and click Remove It is moved back to the measured variables list Electro Industries GaugeTech Doc E134747 The Leader In Power Monitoring and Smart Grid Solutions 3 Using Automatic Export to Excel To change the position of a measured variable in the export file click on the variable and click the Up or Down button The Up button moves the measured variable one column to the left in the Excel file and the Down button moves it one column to the right b Click OK to save your settings click Exit to close the screen without saving settings Custom Variables click this button to configure up to 16 variables using arithmetic expressions These variables can then be included in the Tem plate You will see the screen shown below a F Automatic Export to Excel Define Custom Variab ee Define Custom Variables Select a custom variable Custom Variable 01 Arithmetic Expression Select the normal variable to include Include a numeric constant Group Subgroup2 Energy Scaled FrernulSraled Oiadrant 4 VARh 2809n9Y 4 m Expression Variables are represented by their Data ID a Enter the following settings e Select a custom variable select from Custom Variables 1
Download Pdf Manuals
Related Search