Vision EndSight Manual
Contents
1. Y Date Time Secondary Phone Number VY Current Phase A A Y Customer Name Total Energy Delivered kWh Y Current Phase B A Y Radiogate Y Delivered Phase A kWh W Current Phase C A Y Status Y Delivered Phase B kWh 4 Voltage Current Angle A Y Communication Id VY Delivered Phase C kWh Y Voltage Current Angle B Y Serial Number Y Received Phase A kWh Y Voltage Current Angle C Y Acct Y Received Phase B kWh V Received Signal Strength Y Route 7 Received Phase C kWh V Repeated Y Voltage Phase A V V Address Y Voltage Phase B V Y Primary Phone Number Y Voltage Phase C V 4 mW j Filter Communication Id From 0 to 1000000000 Figure 26 SETTINGS User Defined Fields Purge Data Columns Visible Meter Search Columns visible Y Date Time Y Secondary Phone Number Y Current Phase A A V Customer Name V Total Energy Delivered kWh Y Current Phase B A Y Radiogate Y Delivered Phase A kWh Y Current Phase C A Y Status Y Delivered Phase B kWh Y Voltage Current Angle A 4 Communication Id 4 Delivered Phase C kWh Y Voltage Current Angle B Y Serial Number Y Received Phase A kWh Y Voltage Current Angle C Y Acct Y Received Phase B kWh Y Received Signal Strength Y Route V Received Phase C kWh Y Repeated Y Voltage Phase A V 7 Address Y Voltage Phase B V 4 Primary Phone Number Y Voltage Phase C V2. A Select All Clear All Reset Settings Undate Close Figure 27 Page 36 9 13 2012 sion Metering AM AUSTIN NTT RAATIOMAL COMPAMY Chapter 3 Sentry 950 This section of Endsight allows the incorporation of the Vision Sentry 950 handheld reader Click on the Sentry 950 tab located on the Home page This screen is shown below in Figure 28 1 Connect the handheld to the computer using the USB cable select upload flash on the handheld and then select the appropriate COM Port By clicking the Obtain Data button the screen will retrieve the data from the handheld and display it on this screen At this point you may select which radiogate the meters would have been read by and click the save button at the bottom right corner of the screen This action saves the downloaded data to the database com Port 7 se Cee Figure 28 1 Page 37 9 13 2012 sion Metering AN ACTOR Y Chapter 4 Updating Software When updating EndSight it is necessary to change the desktop folder containing the execution files and data data log files The contents of the folder located on the desktop looks like the one pictured below in figure29 Name Date modified Type Desktop F data ld Downloads l data_log 5 Recent Places PA EndSight 5 EndSight exe A Libraries GMap NET Core dll Documents GMap NET WindowsForms dll 6 19 2012 2 49 PM SQL
3. 1 2 9 13 2012 vision Metering ETIK COMPAR Data Streams As mentioned in the system overview the data stream is the data that the meter sends to the radiogate This data contains the information that the customer would like to retrieve from the meter There are currently six segments of the data stream The packet structure is found in the Host Information screen Segments 3 and 4 may be chosen by the customer and the meters are programmed accordingly The packet structure selections in EndSight must match the programmed meters in order to receive the proper data The data stream is shown below along with the selectable segments for segments 3 and 4 More information on the packet structure screen can be found on page 15 e A H unsigned long SerNum 8 numerical symbols unsigned long TotA unsigned long TotB unsigned long TotC Rec_stream unsigned long Tot_rec_A unsigned long Tot_rec_B unsigned long Tot_rec_C kW_stream unsigned long kW unsigned long CUM_kW unsigned long C_CUM_kW mVA stream unsigned long mVA_A unsigned long mVA_B unsigned long mVA_C Date_stream unsigned int Year_Month unsigned int Date_Hour unsigned int Min_Sec Volt_stream unsigned int Volt_A unsigned int Volt_B unsigned int Volt_C Current_stream 4 bytes of Total phase A unsigned int I_A ABC phases Currents unsigned int I_B unsigned int I_C unsigned int p
4. sion _ Me tering Vision Metering EndSight User s Manual ES 080312 REV2 Page 1 9 13 2012 vision Metering AM NTE i COMA A A andreas eee sects tn sd os nese noe tote A 3 8 3 NS 4 System COMI SUF ATION serisidir EEN EEn EEEE E E ER EE E Ea 5 0 E mb T E 12 A E A weenaseaeninais const 12 A A T ISE TI A 13 a A A E COn N 13 17 FR AIO sates Seniat sit dario esas 18 19 MOET S D A o II A 20 E E 23 Modbus Protocol ENEE EEEE SSE 26 27 Update Praa ia 29 Data Manaslu atte 31 NA IDA e PP oO e 33 OS UM Po Un 35 8 37 Ad Pr E A ace ge eee T E 37 0 E 38 II TA 38 Page 2 9 13 2012 wWsion Metering AN ACTOR Y Chapter 1 System Overview The EndSight software is used in conjunction with both Vision meters and the Radio Gate collectors which create the complete DataonDemand system The meters are programmed to customer specifications Several forms of data streams are available and selectable from EndSight The meter firmware has data stream embedded therefore the meter must be ordered with a specific data stream The meter sends this information to the collector which in turn delivers the data to the head end computer This computer houses the software that allows a user to interpret the data print reports and create a historical customer database gt A EA a 22 j Si TA
5. Figure 16 2 i 2012 10 12 18 AM Satellite 7 2012 10 12 18 AM 2012 10 12 18 AM 2012 10 12 18 AM 2012 10 12 18 AM 2 2012 10 12 18 AM Serial Number 1234567890 Communication ID 1001208 2012 10 12 18 AM 2012 10 12 18 AM 2012 10 12 18 AM 2012 10 12 18 AM 2012 10 11 48 AM 2012 10 11 48 AM 2012 10 11 48 AM 2012 10 11 48 AM 2012 10 11 48 AM 2012 10 11 48 AM Iva 2012 10 11 48 AM 2012 10 11 48 AM 2012 10 11 48 AM 2012 10 11 48 AM 2012 10 11 48 AM 2012 10 11 48 AM 2012 10 11 18 AM 9 i 9 2012 10 11 18 AM S US m Report a map error 4910 11 19 4mMm vana RA Page 22 9 13 2012 Vision Metering AM AUSTIN NTT RAATIOMAL COMPAMY After meter locations have been saved in this fashion The user will have the ability to find a meter location from the View Collected Data screen Simply double click on any given meter row and the location will appear in a new window This is shown in Figure 16 3 Customer Setup In addition to customizing meter information EndSight also provides a location to personalize customer data Figure 17 shows the Customer Setup screen From here it is possible to customize individual customer information Here the user can add edit or remove customer information For example clicking the add button opens the screen shown in Figure 17 1 In this screen there are fields to input customer name address and phone
6. Get Coordinates Latitude 35 0044027 Longitude 81 2257436 User Defined Fields Stops me L oh Page 25 9 13 2012 vision Metering AN ACTOR Y Modbus Protocol Tester This selection allows testing the communication of a specific meter and it also provides the latest data When clicking on Modbus Protocol Tester a window will appear as shown in Figure 18 From this point select the radiogates IP address and then click the Read Data button Once the data is retrieved selection of any meter serial number being transmitted from that IP address is accessible An example of this is shown in Figure 19 MODBUS PROTOCOL TESTER Vision Metering Home Administration EndSigh ME DATA ON DEMAND SYST date local time communication status Figure 18 REMAINDER OF THIS PAGE INTENTIONALLY LEFT BLANK Page 26 9 13 2012 sion Metering AN ADETE RAM APIO A COMPAR VISION METERING ENDSIGHT CENTRAL STATION 56 MAINTENANCE MODBUS PROTOCOL TESTER Y MISION IP Adress 208 104 19 184 er Port 503 4 Serial Number 10001865 y Administration Serial Number 10001865 Total Energy KWh 556 97 1 Total Energy Phase A kWh 556 97 1 g J Total Energy Phase B kWh 0 00 DATA ON DEMAND SYST Total Energy Phase C kWh 0 00 Total Full Energy Phase A V mA 138 958 Total Full Energy Phase B V mA 0 000 Total Full Energy Phase C V mA 0
7. Is associated with the jumper which was pictured and labeled as 2 on page 17 This 1s used to change the IP address setting from Static to Dynamic When the jumper is in place the setting is Dynamic and when it is not the setting is Static If the radiogate is connected to the computer when the jumper is applied or removed press the enter key to refresh the setting The Dynamic setting allows the router to assign the IP address When using the Static IP setting the IP address must be entered manually To change the following fields enter the information below and press the enter key IP Enter the IP address only if J3 is off Static IP is in use and click send MASK Enter Mask address only if J3 is off Static IP is in use and click send GATE Enter Gateway only if 13 is off Static IP is in use and click send HOST This is the address of the head end computer To change the address enter the IP address and click send PORT This 18 part of the IP address and can be changed by entering the correct port and clicking send Page 28 9 13 2012 vision Metering AM ADETE NTE Ad 4 TIME This is the time frame of how often the 180108816 transmits the data to the head end computer The time can be changed by entering the desired time in seconds and clicking send SCDA When using modbus master with Endsight the SCDA port must match If it needs to be changed enter the proper number and click send REPEATER This signifie
8. 000 Voltage Phase A V 122 67 Voltage Phase B V 0 00 Voltage Phase C V 0 00 Current Phase A A 1 139 local time Current Phase B A 0 147 Current Phase C A 0 000 communication status Voltage current Angle A 360 8 Voltage current Angle B 0 2 Voltage current Angle C 0 5 Received Signal Strength 93 Figure 19 Radiogate Configuration Before placing the radiogate in the field it must be connected to the computer via mini USB and programmed properly Start by determining the function of the radiogate Functioning as a repeater or a primary unit connected to the internet changes this process slightly Start by plugging the USB cable into the port labeled 5 on page 17 Under the administration tab click Radiogate Config and the screen pictured in Figure 19 1 will be visible The COM Port will automatically be selected and shown in that field Click the connect button to communicate directly to the radiogate Page 27 9 13 2012 vision Metering AN ACEITE COMPANY orl Y COM Port O J3 ON Dynamic IP MAC 00 1a b6 00 80 9f IP Mask Gate 0 0 0 0 0 0 0 0 0 0 0 0 Host Port SCDA 192 1 1 168 1701 502 Repeater Time Send Bootload Refresh OFF 30 Close Figure 19 1 The screen shown in Radiogate is broken down into the following fields MAC Is the assigned number to the board and firmware in each radiogate This can not be changed J3
9. 30 2011 11 33 42 AM 208 104 19 184 503 208 104 19 184 503 208 104 19 184 503 208 104 19 184 503 208 104 19 184 503 Meter Search S S S S S S S 5 5 Figure 3 0 w 4 09 PM 11 30 2011 The meter search function is useful for locating the information on a specific meter In this window pictured in Figure 24 searching for a meter by Account ID Address Last Name or the two User Defined Fields is possible Simply choose your method of search fill in the field and click the Search button An example is shown in Figure 24 1 Hi Figure 24 Page 34 9 13 2012 sion Metering AM AUSTIN NTT RAATIOMAL COMPAMY E secas tosemome rower 9 Figure 24 1 Settings Lastly under the Data Management menu the Settings tab opens the screen in Figure 25 Under User Defined Fields the user can customize two user defined fields In Figure 26 the Data Columns Visible tab opens the selectable information the user wishes to see in viewing collected data Figure 27 shows the Meter Search Columns Visible which allows the user to select which information is viewed from searching Update Close Figure 25 Page 35 9 13 2012 Vision Metering AN ACTI COMPA SETTINGS User Defined Fields Purge Data Columns Visible Meter Search Columns visible
10. SQLEXPRESS IP Port ex 192 168 0 1 1433 ASQLEXPRESS Attached Database radiogates Authentication Type Windows 60 SQL Server User Name sa Password password Test Connection Clear Database Update Database Figure 13 Page 14 9 13 2012 vision Metering AN ACTOR Y The Packet Structure tab allows modification of data stream delivered However the selections made in fields 3 and 4 must be how the meters are programmed The packets can not contain every option at the same time but we do provide these options to the customer This allows for a customized data stream ideal for individuals clients Figure 13A shows the options for field 3 Figure 13B show the selectable options for field 4 HOST INFORMATION 1 Serial Number 2 Total Energy Phase A Phase B Phase C kWh 4 WA gt COME 1 B Phase C A 6 Voltage Current Angle A Angle B Angle Figure 13A HOST INFORMA TION 1 Serial Number 2 Total Energy Phase A Phase B Phase C kWh 3 mVA 4 06 we Volt 5 Date Time 8 Phase C A 6 Voltage Current Angle A Angle B Angle Figure 13B Page 15 9 13 2012 wsion Metering AN ACTOR Y Figure 14 shows the Geo Service screen Here the user may enter the local address which simplifies the map search when locating a meter s geographic location Enter the address and click the Get Coordinates button then cl
11. Server Databa 4 096 KB 2012 2 49 PM SQL Server Databa 7 616 KB 2012 2 49 PM Application 1 857 KB 2012 2 49 PM XML Configuratio 7 KB 2012 2 49 PM Application extens 2 143 KB 6 19 2012 2 49 PM Application extens 69 KB DOO Oo err RR PR 6 oo U a Microsoft Office 201 th Network 6 items Figure 9 Start by selecting the folder on the desktop and delete it Next copy the new folder and paste it to the desktop Now that the new folder is in place open the SQL Sever Management Studio and connect it in the same fashion as described in the initial setup section of this text Double click databases and right click radiogates This will allow the selection of tasks and then select detach This set of windows resembles the ones pictured in Figure 30 A new window will open so that the database to be detached can be checked Select radiogates and then click ok After the process is complete minimize the studio window and return to the folder previously copied to the desktop Select both the data and data log files and save them in the radiogates folder on the hard drive in exactly the same manner as the initial setup section Now that the updated files are once again located in the radiogates folder the database can now be reattached to the server Open the studio windows once again right click databases and select attach After the new window opens click add This is shown in Figure 31 Select the radiogates folde
12. address information remotely The screen shot below shows where the mode change is made Edit Radiogate Information General TCP Connection Settings Radiogate Name r Figure TCP Type Port 3 Page 19 9 13 2012 vision Metering Once the mode has been changed to TCP client the user can enter the desired IP addresses in the same window under the TCP Connection Settings tab Here the Connect to address is the IP address of the radiogate This must be entered to communicate with the radiogate To change the IP address of the computer it must be entered in the Write Data field Once these fields are filled the Read Settings and the Write Settings buttons become available The Read Settings button allows the user to see the current radiogate settings remotely The Write Data button allows the user to change the current settings The screen shown below is the TCP Connection Settings screen and shows the discussed fields Edit Radiogate Information Esl General TCF Connection Settings Connect to IP Adress Figure Write Data TCP2 IP Adress Port Period sec Repeater Level Meter Setup Selecting Meter Setup from the Administration drop down menu will open a window that looks like the one in Figure 16 Editing the information associated with the meters in the field can be done from this location Although the meters are individually entered into the system under the Data Management drop down m
13. number If the user chooses to edit an existing entry click the edit button and the screen in Figure 17 2 opens This screen looks very similar to the add screen however notice the assign meter tab located at the top of the screen By clicking this tab the screen shown in Figure 17 3 opens Lastly the user can edit the meter information associated with the customer by clicking the edit button This action opens the window shown in Figure 17D which allows the customization of meter address user defined fields and even geographic location CUSTOMERS Primary Phone kanow Ivan 123 456 778 Figure 17 Page 23 9 13 2012 Vision Metering AN ACTOR Y General Last Name Middle Initial Physical Address Street City State Billing Address ff different from Physical Address Last Name Name Middle Initial Street City Phone __ __ _____ Mobile __ __ Figure 17 1 LastName Jvanov Middle Initial 1 Street City State Billing Address if different from Physical Address Last Name Name Middle Initial Street City Phone Mobile __ _ Update Figure 17 2 Page 24 9 13 2012 vision AM AUSTIN NTT RAATIOMAL COMPAMY Figure 17 3 Figure 17 4 Account Id Communication Id From the List 1001208 Serial Number 1234567890 New Communication Id Serial Number Address Street 7 Ross Cannon St City York SC State sc Zip 29745
14. the recent entries into the database Now these meters are accessible under Meter Setup and Customer Setup where the data can be customized From this location the user may also edit or remove meters i VISION METERING ENDSIGHT CENTRAL STATION SOFTWARE V 1 0 1 37 e 8 2 Vision Metering Communication Id 1233 DATA ON DE asin chs sai 11472334 111472343 78921822 78921822 78921914 78921914 78922379 78922379 78922616 78922616 78922770 78922770 79197369 79197369 y date local time communication status Figure 21 Page 32 9 13 2012 vision Metering AN ACTOR Y i VISION METERING ENDSIGHT CENTRAL STATION SOFTWARE V 1 0 1 37 X Vision Metering Communication Id gt 4 Add Information DATA ON DE 11472334 Communication ID 78921822 78921914 78922379 78922616 78922770 79197369 Serial local time Figure22 View Collected Data This 1s located under Data Management and is used to view the data transmitted from the radiogates to the head end computer The screen is pictured in Figure 23 From this location meter information on usage and connectivity can be viewed The columns can be widened or narrowed by clicking and dragging the column boarders Click and drag the entire column to move it to a more desirable location with respect to what
15. username or password Next test the connection by clicking the test connection button which is located at bottom left of the screen This is shown in Figure 8 Metering Administration Data Management Reports Sentry 950 Host Information Radiogates Setup TM 4 Meters Setup Customers Setup DATA ON Modbus Protocol Tester M Radiogates Config local time communication status Owner Name Common Utility Owner Address 123 Main Street Mode Figure 8 Page 10 9 13 2012 vision Metering AM ACTOR If all is well Connection OK will be displayed in a new window like the one in figure 9 If not the error most likely lies in the INSTANCE ID Simply verify that it is the same HOST INFORMATION Connection Type Instance ex SQLEXPRESS IP Port ex 192 168 0 1 1433 ASQLEXPRESS Attached Database radiogates Authentication Type Connection OK Windows SOL Server User Name sa Test Connection Clear Database Update Database Figure 9 Congratulations the SQL server database and EndSight software have been successfully installed The next chapter will cover all aspects of EndSight software and how to utilize them REMAINDER OF THIS PAGE INTENTIONALY LEFT BLANK Page 11 9 13 2012 vision Metering Chapter 2 Home Page Now that everything is installed and running properly it is time to become familiar with the EndSigh
16. A data 10 27 2011 11 09 AM SQL Server Databa 4 096 KB Jl Downloads El data_log 10 27 2011 11 09AM SQL Server Databa 7 616 KB El Recent Places Libraries En Documents a Music Pictures F Videos 18 Computer E Acer C Gi Network Figure 3 Page 7 9 13 2012 WISIOn Metering AN ADETE RAM COMPAR Next open the Server Management Studio and verify that the server is still connected If itis not reconnect and right click on database and select attach This is where to select the files located in the radiogates folder This is shown in figure 5 and figure 6 Po Microsoft SQL Server Management Studio File Edit View Debug Tools Window Community Help peak PA OM Object Explorer gt Microsoft SQL Server Management Studio File Edit View Debug Tools Window Community Help a a A Attach Databases Select a page Add Remove Server TONY PC SGLEXPRESS Connection Tony PC Tony View connection properties Add Catalog Remove z 8 8 5 Figure 5 Page 8 9 13 2012 vision Metering AN ADETE RAM COMPAR Once the attach databases screen window is up left click on the add button This will show you the folders listed on the hard drive Select the radiogates folder and then the data file If the error message appears and will not attach then return to the radiogates folder and right click on each of the two folder
17. enu in Import Meters Into the Database customizing meter information is done here The Serial Number field will already be filled in after importing the meters however from here you can add Comm ID Account ID and Customer Name This customization can be extremely helpful with regard to record keeping and reports This information may be edited by clicking on the Edit button which will provide the screen shown in figure 16 1 From here the user can edit address geographic location account number or user defined field data Page 20 9 13 2012 sion Metering AN AUSTIN NTT RAATIOWAd COMPANY METERS SETUP Commumication Id Se al Number 10002046 10002046 LOWER LET 1 Customer Name Ivanow Livan Serial Number 1001208 Account Id 4 Address Street Ross Cannon St City York 6 State sc Zip 29745 Location Latitude 7 Longitude 81 2257436 User Defined Fields Stop Routes Page 21 9 13 2012 vision Metering AN ACTOR Y While in the Edit Meter screen the user may enter the address for the meter location Once the fields are filled in click on the Get Coordinates button Now that the latitude and longitude fields have populated click the Select Location on the Map button The screen below in Figure 16 2 will allow the user to mark the exact location of the desired meter The user may select Map or Satellite and mark the exact location before clicking the save button
18. grammed Com flash 1 Page 30 9 13 2012 vision Metering AN ADETE RAM COMPAR Configuraton Program Flash Utilities Other Utilities Help E New Folder ETH_radio duke Aug 4 11 bin f Erase Entire Flash Faster verify After Program JM Reset MCU After Program Program Address Offset ox 1000 TEXAS INSTRUMENTS Com flash 2 Data Management This 1s the second drop down menu on the home page This menu provides access to Import Meters into Database View Collected Data Meter Search and Settings as shown in Figure 20 Vision Metering Administration Data Management Reports Sentry 950 Import Meters Into the Database 2 View Collected data f NA En dSi Meter Search gt D Settings j N Y N 1 DATA DEMAND SYSTEM local time communication status Figure 20 Page 31 9 13 2012 vision Metering AN ACTOR Y Import Meters Into the Database As mentioned under Meter Setup when adding meters to the system meters are entered in the window pictured below in Figure 21 Here adding editing or removal can be done similarly to the Radiogates Setup When adding a meter click the Add button and a new window will open requesting the communication ID and serial number like the one in Figure 22 Once both fields are filled in click OK After entering the desired meters click the Import button This finalizes the addition by importing
19. h_A unsigned int ph_B unsigned int ph_C unsigned int chksum ABC phases ABC phases phase_A in 10ths phase_B in 10ths phase_C in 10tbhs Page 4 Received Energy Stream kW Stream mVA Stream Date Time Stream Volt Stream 9 13 2012 vision Me terin g AN ACTOR Y System Configuration It is recommended that this software be installed on a PC with at least a 64 bit operating system It is also suggested to use Windows 7 and have a minimum of 2GB of RAM installed This software is used in conjunction with Microsoft SQL Server 2008 R2 Express with tools Two SQL Server installation files have been provided Ensure installation of the correct version depending on whether your system is 32bit or 64bit For 32bit systems use the SQLEXPRWT_x86_ENU exe file For 64bit systems use the SQLEXPRWT_x64_ENU exe file Depending on the computer s operating system it may be necessary to download other service packs in order for the server to be installed and run properly Upon downloading the server follow all of the instructions and prompts provided by the installation guide Once the server is installed on the computer the next step is to connect to the server To access the Microsoft Sever Management Studio left click the start button Then left click on SQL Server 2008 and finally left click on Server Management Studio This access can be simplified by creating a sh
20. ick Update The HTML field 18 only used if the user chooses to use a server other than default HOST INFORMATION Starting Map Search Point Adress York SC 28012 Get Coordnates York Rd Charlotte NC 28278 USA Latitude 35 1008097 Longitude 90 9928408 Google HTMI server Update Close Figure 14 REMAINDER OF THIS PAGE INTENTIONALLY LEFT BLANK Page 16 9 13 2012 vision Metering AN ACTOR Y Radiogate This is a picture of the radiogate with the cover removed In location 1 there are three LED s Green will be illuminated when power 1s supplied Red will pulse and is the heartbeat of the radiogate Yellow will be illuminated as data is being received Location 2 is the jumper used when switching between dynamic and static IP addresses Location 3 is the connection for the internet cable This is only used on the primary radiogates sending the data to the head end computer Location 4 is the power connection for 120 277 Location 5 1s the mini USB connection which is used to program the radiogate with the computer Page 17 9 13 2012 Vision Metering AM AUSTIN NTT RAATIOMAL COMPAMY Radiogates Setup Clicking on this link opens the page shown below in Figure 14 Here is where maintaining control of the radiogates in the field 1s accomplished This is used for the radiogates that have direct access to the internet Other radiogates in the field share information collect da
21. ion Data Management Reports Host Information Radiogates Setup TM 4 Meters Setup Customers Setup DATA ON Modbus Protocol Tester M Radiogates Config local time communication status Figure 11 Host Information Recall clicking on this tab opens the screen shown in figure 8 on page 11 where the connection to the database was made Click on Host Information and open a window like the one pictured below in Figure 12 In this window there are four subsections General Database Packet Structure and Geo Service General provides three fields two of which allow the user to input Owner Name and Owner Address The other additional field is Mode Mode offers the choice of File or Database File is used for systems that do not use a database and server The data is then available in the form of an Excel spreadsheet Database 1s the default By clicking on Database tab a window that looks like the one in Figure 13 opens Because this step has already been completed while connecting to the database and it has been verified that the connection is good leave all of the setting on this page alone for now The Page 13 9 13 2012 vision Metering AN ACTOR Y Update Database button will update the database SQL file which eliminates multiple steps when updating Endight software Owner Name Owner Address 123 Main Street Figure 12 HOST INFORMATION Connection Type Instance ex
22. is seen and in which order Finding a particular meter s geographic location is done easily by double clicking on that meter here Including or excluding certain data from this screen can be controlled from the Settings menu Page 33 9 13 2012 Vision Metering AN ALETE COMPANY 30 20 1 35 40 AM 11 30 2011 11 35 40 AM 208 104 19 184 503 1 aj Jj 11 30 2011 11 35 40 AM 208 104 19 184 503 11 30 2011 11 35 40 AM 208 104 19 184 503 11 30 2011 11 35 40 AM 208 104 19 184 503 11 30 2011 11 35 06 AM 11 30 2011 11 35 06 AM 11 30 2011 11 35 06 AM 11 30 2011 11 35 06 AM 11 30 2011 11 35 06 AM 208 104 19 184 503 208 104 19 184 503 208 104 19 184 503 208 104 19 184 503 OK OK OK OK OK OK OK 208 104 19 184 503 11 30 2011 11 35 06 AM 208 104 19 184 503 11 30 2011 11 35 06 AM 208 104 19 184 503 11 30 2011 11 35 06 AM 208 104 19 184 503 11 30 2011 11 35 06 AM 208 104 19 184 503 11 30 2011 11 34 36 AM 11 30 2011 11 34 36 AM 11 30 2011 11 34 36 AM 11 30 2011 11 34 36 AM 208 104 19 184 503 208 104 19 184 503 208 104 19 184 503 208 104 19 184 503 Q S Q S S 5 11 30 2011 11 34 36 AM 208 104 19 184 503 11 30 2011 11 34 06 AM 208 104 19 184 503 11 30 2011 11 34 06 AM 208 104 19 184 503 11 30 2011 11 34 06 AM 11 30 2011 11 34 06 AM 11 30 2011 11 34 06 AM 11 30 2011 11 33 42 AM 11
23. om flash1 Under configuration make sure that the fields are filled out or selected as shown Quickset is set to manual interface is set to serial with baud rate set to 115200 and transfer size is 60 The COM port may be different as it is selected for you automatically unless it has been saved to reuse Select the program tab which opens the screen shown in Com flash2 Ensure that the reset MCU box is checked and the field for the program address offset is 1000 After selecting the firmware file with the browse button click the program tab in the lower left corner and the process is started The progress of programming 1s displayed by percentage and when the programming is complete it is stated at the very bottom left hand corner of the window Programming Complete Page 29 9 13 2012 vision Metering AN ACTIN NITRA APIOSAL COM Port 0 J3 0ON Dynamic IP MAC 00 1a b6 00 80 9f Ready for programming IP Mask Gate 0 0 0 0 0 0 0 0 0 0 0 0 Hast Part SCDA 192 1 1 168 1701 502 Repeater Time OFF 30 Figure 15A LM Flash Programmer Build 1381 ere e Se Configuration Program Flash Utilities Other Utilities Quick Set Manual Configuration see below Interface COM Port coma he Device Manager Serial UART Baud Rate 115200 e Disable Auto Baud Support Transfer Size 60 JA TEXAS INSTRUMENTS Program Complete 53008 Bytes Pro
24. ortcut link on the desktop or pinning it to the taskbar The link to the server is established with an INSTANCE ID Simply use the same INSTANCE that was created during the installation process and left click the connect tab This INSTANCE is input in the window pictured in figure 1 E E Connect to Server Microsoft SOL Server 2008 2 Database Engine TONY PC SQLEXPRESS User name Torny PEA Tony Password Remember password Cancel Help Options lt lt Figure 1 Page 5 9 13 2012 WISion Metering AN ADETE RAM COMPAR When the server connects properly the screen pictured below will appears which shows the name of the server and that it is connected Disconnecting the server is also accomplished from this screen shown below in Figure 1B File Edit View Debug Tools Window Community Help E New Query Ces 3 3 2 Object Explorer Connect 0 S TES BY TONY PCISOLEXPRESS SOL Server 10 50 1600 Databases Security Server Objects Replication Management Figure 1B Now that the server is installed and connected the next step is to connect the server to the database The database data and data log files needed for this step are provided Both of these files need to be saved on the hard drive in a new folder named radiogates as shown in figures 3 and 4 This can be accomplished by a left click on the start button left click on computer then a righ
25. r and double click the data file Click the ok button and wait for the process to complete The EndSight program can now be opened and run for normal operation Do not forget to check the connection and fill out the fields in the Page 38 9 13 2012 Vision letering AN AUSTIN NTT RAATIOMAL COMPARKY Administration Host Information menu Refer to back to the Host Information section on page 14 Verify that the radio gates are listed in the Administration Radiogate Setup menu Refer back to the radiogate setup section on page 20 File Edit View Debug Tools Window Community Help New Query D D lel Connecty Be THs a 8 tony PC SQLEXPRESS SQL Server 10 50 1617 E LA Databases m A System Databases qQates Security O Server Ok A Replicatic A Manage Take Offline Bring Online Back Up Figure 30 aF Vew connection properties Progress a Ready Cook Figure 31 Page 39 9 13 2012
26. s and select properties Left click on security and ensure that full control 1s checked If not then check full control and click apply Now try to attach once again Now that the server and database are installed and connected the only thing left to do is install the EndSight software and connect it to the database Save the software and right click on the file and create a shortcut to the desktop At this point everything needed is installed and accessible from the desktop Open the EndSight program by left clicking on the shortcut icon and a window will open like the one pictured in figure 6 Vision Metering Administration Data Management Reports Sentry 950 EndSight 6 Y 0 IN DATA ON DEMAND SYSTEM e local time communication status Figure 6 To connect the program to the database left click on the Administration button which opens a drop down menu that looks like the one pictured in figure 7 There are several options located in this menu however the one needed at this point is Host Information This window looks like the one pictured in figure 8 The three categories to choose from are General Database Packet Structure and Geo Service At this Page 9 9 13 2012 vision Metering AN ACTIN COPAN Y point select Database Input the exact same INSTANCE ID that has been used thus far Leave the attached database as radiogates and leave the authentication as windows Do not change the
27. s whether the radiogate is a repeater or not To designate the radiogate as a repeater enter 10 and click send The numbers between and 10 relate to signal strength It is suggested to set signal strength at 10 If the radiogate is not going to be a repeater the enter O and click send BootLoad This is used to update the firmware of the radio gate The radiogate firmware can be updated by clicking the Bootload button This prepares the radiogate for programming which can be done with a flash programmer This will be discussed thoroughly on page 20 The screen can be refreshed by clicking the refresh button To exit the screen pictured in radiogatel click the close button Updating Firmware In order to program the radiogate with updated firmware the use of the LM flash programmer is required which has been provided Start by connecting the radiogate to the computer via mini USB cable as discussed in the radiogate configuration section on page 17 This cable provides power to the radiogate so external power source is necessary Open the radiogate configuration screen and connect to the radiogate Click the bootload button and the message Bootload Command Was Sent will be displayed Also on the radiogate configuration screen under the MAC address Ready for Programming is visible This is shown below in Figure 15A Close the radiogate configuration screen and open the LM flash programmer The main screen is the one pictured below in C
28. t click to open the hard drive which is usually C Once in the hard drive right click and choose new and then choose folder It is imperative that the new folder just created is named radiogates no caps This is recognized and accessed by EndSight software so it must be accurate Copy the data and data log files to the new radiogates folder This folder will be attached to the server REMAINDER OF THIS PAGE INTENTIONALY LEFT BLANK Page 6 9 13 2012 vision Metering AN ADETE RAM COMPAR E Acer 6 go E Computer Acer C Organize Open Indudeinlibrary Share with Burn New folder sk Favorites Name Date modified Type Size HZ Desktop Gh 6684f4c21d182d913dc8 13adaa4bb7 9 15 2011 9 28 AM File folder Je Downloads Ji book 8 17 2011 9 11PM File folder GE Recent Places i ae Perflogs 7 13 2009 8 20PM File folder Mes Ly Program Files 9 18 2011 3 05PM File folder Ed Documents Ly Program Files x86 9 22 2011 3 32PM File folder al Music radiogates 10 27 2011 10 49 AM File folder E Pictures 9 15 2011 8 52 AM File folder BE Videos 9 19 2011 5 25PM File folder 9 15 2011 9 11 Application 235 934 KB Computer NE sQLserver20085P2 KB2285068 x64 ENU 9 15 20119 26 AM Application 358 229 KB Ela Network Figure 2 ae go Computer Acer C radiogates Organize Indudeinlibrary Share with Burn Mew folder sk z Name Date modified Type Size Desktop
29. t software itself Start by dissecting the home page The picture below is the main page where navigation through EndSight begins vision Me terin g Administration Data Management Reports Sentry 950 EnadSight DATA ON DEMAND SYSTEM local time communication status Figure 10 This 1s the home page shown in Figure 10 While in sub categories or different pages returning to the home page can be done with a left click on Home On this page the date and time are displayed in the lower left hand corner In addition notice the communication status which can be either OFF LINE or READ DATA Just below the communication status section are the Start and Stop buttons which begin or cease data collection respectively To begin collection of data left click the Start button and to stop collection of data left click the Stop button Along with the Home button Administration Data Management Reports Sentry 950 and Exit are located on the banner near the top of the page Before continuing forward into each of these segments notice the Exit button A left click on this tab will close this program Page 12 9 13 2012 vision Metering AN ADETE RAM COMPAR Administration Clicking on Administration will offer numerous choices to select from as shown in figure 11 This is a menu for most of the initial setup functions for the radiogates and meters as well as the program itself Vision Metering Administrat
30. ta and retransmit data to the primary radiogates with internet connections which send the information to the head end computer This window provides access to add remove or edit radiogates When adding a radiogate to the system click the Add button and a window that looks like the one in Figure 15 opens There are several fields to input Radiogate Name can be any characters Simply use the IP address or the physical address Type should typically remain modbus master The IP and Port is the actual IP address of the radiogate Period is the time frame of reporting data from the radiogate to head end computer The time is assigned in seconds For example if the request was to have the data transmitted every five minutes the entry in this field would be 300 The user may also edit an existing radiogate by clicking Edit To remove a radiogate from the system click on the chosen radiogate and simply click Remove RADIOGATES SETUP a Radiogate Name Type IP Port Period 1 2914 modbus master 208 104 19 184 503 30 Remove Figure 14 Page 18 9 13 2012 vision Metering AM ADETE Add New Radiogate 0 Radiogate Name Period Figure 15 TCP Client Mode This mode allows the head end computer to standby for transmitted data from the radiogate The user can switch from modbus master to TCP client mode in the radiogates setup menu under the general tab This gives the user the opportunity to change the IP
Download Pdf Manuals
Related Search