HOWTO: Create SUM Fields for OPC2SQL Data</h1> <article> <h1>HOWTO: Create SUM Fields for OPC2SQL Data</h1> <p>DetailAnalysis — Wed, 30 Apr 2008 14:58:00 GMT</p> <p>With the <font size="2">O2S_FieldCalcSums view installed, using the FieldType for analog values multiple fields can be summarized into a single field.</font></p> <p><font size="2"> Example single meter Pump Volume A and Pump Volume B can be summed into a Pump Volume C.</font></p> <p><font size="2">To do this first add the link to the O2S_FieldCalcSums in the MeterType by doing the following:</font></p> <ol> <li> <div><font size="2">Select MeterTypes using administrator [T] button on top of page</font></div></li> <li> <div><font size="2">Locate MeterType and click Edit</font></div></li> <li> <div><font size="2">Click the Fields button</font></div></li> <li> <div><font size="2">There are 10 summary fields supported in the O2S_FieldCalcSums view</font></div></li> <ol> <li> <div>Alt0Sum - Summarizing items with Field Type Alt 0</div></li> <li> <div> <div>Alt1Sum - Summarizing items with Field Type Alt 1</div></div></li> <li> <div> <div> <div>Alt2Sum - Summarizing items with Field Type Alt 2</div></div></div></li> <li> <div> <div> <div> <div>Alt3Sum - Summarizing items with Field Type Alt 3</div></div></div></div></li> <li> <div> <div> <div> <div> <div>Alt4Sum - Summarizing items with Field Type Alt 4</div></div></div></div></div></li> <li> <div> <div> <div> <div> <div> <div>Alt5Sum - Summarizing items with Field Type Alt 5</div></div></div></div></div></div></li> <li> <div> <div> <div> <div> <div> <div> <div>Alt6Sum - Summarizing items with Field Type Alt 6</div></div></div></div></div></div></div></li> <li> <div> <div> <div> <div> <div> <div> <div> <div>Alt7Sum - Summarizing items with Field Type Alt 7</div></div></div></div></div></div></div></div></li> <li> <div> <div> <div> <div> <div> <div> <div> <div> <div>Alt8Sum - Summarizing items with Field Type Alt 8</div></div></div></div></div></div></div></div></div></li> <li> <div> <div> <div> <div> <div> <div> <div> <div> <div> <div>Alt9Sum - Summarizing items with Field Type Alt 9</div></div></div></div></div></div></div></div></div></div></li></ol> <li> <div> <div> <div> <div> <div> <div> <div> <div> <div> <div>Add each field to the profile, or the number of fields you wish to summarize</div></div></div></div></div></div></div></div></div></div></li> <li> <div> <div> <div> <div> <div> <div> <div> <div> <div> <div>When adding the fields set the following fields:</div></div></div></div></div></div></div></div></div></div></li> <ol> <li> <div> <div> <div> <div> <div> <div> <div> <div> <div> <div>Database: <strong>Customer</strong></div></div></div></div></div></div></div></div></div></div></li> <li> <div> <div> <div> <div> <div> <div> <div> <div> <div> <div>Table Name: <strong>O2S_FieldCalcSums</strong></div></div></div></div></div></div></div></div></div></div></li> <li> <div> <div> <div> <div> <div> <div> <div> <div> <div> <div>Field Name: One of the above field names</div></div></div></div></div></div></div></div></div></div></li> <li> <div> <div> <div> <div> <div> <div> <div> <div> <div> <div>Layout: <strong>Vertical</strong></div></div></div></div></div></div></div></div></div></div></li></ol></ol> <p> <div> <div> <div> <div> <div> <div> <div> <div> <div>Next open the meter, select the settings tab, then select Analog</div> <div> </div> <div>Add the the Alt0Sum or any others you wish to have.</div> <div> </div> <div>Then change the Field Type for each item you want summed to match the Alt0sum. </div> <div> </div> <div>Example Above: Set Pump Volume A and Pump Volume B to Alt 0 Field Type</div> <div>Then Alt0Sum field will contain the summary of values from Pump Volume A and Pump Volume B</div></div></div></div></div></div></div></div></div> </article> <article> <h1>SiteOnline User Access Levels</h1> <p>DetailAnalysis — Fri, 07 Mar 2008 21:45:49 GMT</p> <h2>Read Only Access </h2><p> </p><p>Read Only access provides users with the ability to view the </p><p>meter readings for each meter, and run reports </p><p>but can not view or change any meter settings. </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><h2>Demand Poll Access </h2><p> </p><p>Provides user the ability to initiate a demand poll on meters, </p><p>view the communication, fields, meter settings </p><p>and alarm details but not make any changes. </p><p> </p><h2>User Level Access </h2><p> </p><p>User level access provides the ability to perform demand poll, </p><p>view the polling schedule, communication, fields, </p><p>meter settings and alarm details but not make any changes. </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p><h2>User Admin Access </h2><p> </p><p>Admin Access level provides users the ability to perform demand polls, </p><p> edit the polling schedule, change communication settings, </p><p>Add / Remove /Edit meter Tags / Fields, edit additional meter settings and confirm alarms. </p> </article> <article> <h1>SiteOnline OPC2SQL Communication Errors</h1> <p>DetailAnalysis — Fri, 07 Mar 2008 20:28:40 GMT</p> <p>SiteOnline is a web based software package to display information, OPC2SQL is one of many options SiteOnline has for communicating to remote devices. Errors returned by OPC2SQL are depend on where in the polling process the error occurred. The following is a list of steps to communicate with a remote device and successfully poll the values requested. </p><ol><li>The server assembles the points and registers and sets the requested format for each, which must match the remote meter </li><li>Establish communications to the remote communications device, example: modem, satellite terminal, remote IP terminal server </li><li>Request and establish a connection to the remote meter. This means the Device ID for a TotalFlow, or Modbus address for a modbus meter, is broadcast over the communications link and that meter has to respond within a specified amount of time. </li><li>Groups of registers are sent to the remote meter, the system then waits a limited amount of time for the meter to return the values </li><li>Values returned are then converted to the registers using the formats originally defined </li><li>Data is stored in the database for the website </li></ol><p> </p><p>The following is a list of errors that can show on the website, they error shown is dependent on the meter type and the communications: </p><ul><li><div><strong>Error Reading Item...Quality Bad/Quality Uncertain </strong></div><ul><li>Communication was most likely established, but Step 5 above most likely failed. </li></ul></li><li><div><strong>Comm Error: Attempt to Connect to Communications Channel Failed. </strong></div><ul><li>Step 2 above failed, no basic communications connection was able to be established </li></ul></li><li><div><strong>Comm Error: Attempt to Connect to Device Failed. </strong></div><ul><li>Step 3 above failed, basic communications was established, but not communication to device was made </li></ul></li><li><div><strong>Comm Error: Circuit Connection Disconnected. </strong></div><ul><li>The main communications link was broken, generally after being established. </li></ul></li><li><div><strong>Comm Error: Requested Object or Function has NOT been initialized properly. </strong></div><ul><li>This would be a communications issue within the polling engine. </li></ul></li><li><div><strong>Comm Error: The operation completed successfully. </strong></div><ul><li>This is a very misleading error, the communication link was not able to be established. </li></ul></li><li><div><strong>Comm Error: The Read Request Has Timed Out. </strong></div><ul><li>Communications to the device was successful, however step 4 above failed because the device did not return within the specified amount of time. </li></ul></li><li><div><strong>Comm Error: The value of the handle is invalid </strong></div><ul><li>This is caused when the meter returns unexpected information. </li></ul></li><li><div><strong>Error talking to meter </strong></div><ul><li>Communications was established but step 2 above when trying to talk to the device failed. Generally either the device never answered or the answer was not </li></ul></li><li><div><strong>Item Error...Quality_Bad+Not_Connected </strong></div><ul><li>Communication channel was opened, but communication to end device failed. Step 3 above. </li></ul></li><li><div><strong>Item Error...Quality_Bad+Comm_Failure </strong></div><ul><li>Communication channel in step 2 above failed, either started and then lost communication or was never able to establish communications. </li></ul></li><li><div><strong>Item Error...Quality_Bad+Bad </strong></div><ul><li>Step 5 above had values from the meter that did not fit into the correct format for the registers or the quality of the data could not be trusted. </li></ul></li><li><div><strong>Polling Engine was unable to respond to the request within 30 minutes </strong></div><ul><li>A demand poll was requested but was not able to be responded to by the polling engine within 30 minutes. </li></ul></li><li><div><strong>Read did not complete in (n) seconds </strong></div><ul><li>The polling engine gives the meter a certain amount of time to respond, in addition OPC2SQL gives the polling engine so long to respond. This error occurs when the polling engine did not respond to OPC2SQL within a given amount of time, check the time out and retry settings within the polling engine. </li></ul></li><li><div><strong>Read never completed </strong></div><ul><li>The polling engine gives the meter a certain amount of time to respond, in addition OPC2SQL gives the polling engine so long to respond. This error occurs when the polling engine did not respond to OPC2SQL within a given amount of time, check the time out and retry settings within the polling engine. </li></ul></li><li><div><strong>The remote procedure call failed. </strong></div><ul><li>This is an error within the polling engine. </li></ul></li><li><div><strong>The RPC connection is disconnected. </strong></div><ul><li>This is an error within the polling engine. </li></ul></li><li><div><strong>Timed out waiting for OPC2SQL </strong></div><ul><li>The OPC2SQL server did not respond to the request within a specified amount of time. </li></ul></li><li><div><strong>Unable to talk to meter </strong></div><ul><li>Step 2 or step 3 above, a generic error usually refers to a communications failure or communications never being able to be established. </li></ul></li><li><div><strong>Unspecified error </strong></div><ul><li>Unknown error returned from polling engine. </li></ul></li><li><div><strong>Poll Error </strong></div><ul><li>TMS communication was established, but data did not follow the correct format </li></ul></li><li><div><strong>Poll No Answer </strong></div><ul><li>TMS modem did not answer </li></ul></li><li><div><strong>Poll: Incorrect Function </strong></div><ul><li>Protocol error with remote device, generally requesting a modbus address with an incorrect function code. The error is generated from the remote device.</li></ul></li></ul> </article> <article> <h1>Report: Alarms – Summary Report</h1> <p>DetailAnalysis — Tue, 04 Mar 2008 17:23:09 GMT</p> <p>The Alarms – Summary Report shows recent high and low alarms for meters, how long they were open, and values. The report can be selected for date ranges from the last 24 hours to 30 days past. </p><p>To run, select a company in SiteOnline and select Request Report icon at the bottom of the page and follow the instructions: </p><ol><li>On the Select Report box on the top select "Alarms – Summary Report" </li><li>The report will load the last 24 hours for the current company by default. </li><li>To change the amount of days on the report open the box next to Days to Show and click on desired days or hours </li><li>To change or add companies to display in report open the box next to Companies and check all companies to be included in report </li><li><div>Then click View Report button on the right </div><p> </p></li></ol><p></p> </article> <article> <h1>Entelec 2008</h1> <p>DetailAnalysis — Fri, 22 Feb 2008 22:31:15 GMT</p> <p>Look for us at Entelec </p><p>April 9–11, 2008 </p><p>George R. Brown Convention Center </p><p>Houston, Texas </p><p>Details Coming Soon… </p><p><a href="http://www.entelec.org/conference-and-expo/">http://www.entelec.org/conference-and-expo/</a> </p><p> </p> </article> <article> <h1>HOWTO: Using Codes in Alarm Messages</h1> <p>DetailAnalysis — Tue, 19 Feb 2008 03:31:24 GMT</p> <p>SiteOnline has the capability to insert values from fields within the meter into the alarm messages. What this means is you can insert the meter notes or satellite ID inside the alarm message to be mailed out. </p><p>The usable codes are as follows: </p><div><table style="border-collapse:collapse;"><tr><td style="padding-left:7px;padding-right:7px;border-top:solid black 0.5pt;border-left:solid black 0.5pt;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>@Val</p></td><td style="padding-left:7px;padding-right:7px;border-top:solid black 0.5pt;border-left:none;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>The unscaled / unformatted value of the point when the alarm was triggered</p></td></tr><tr><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:solid black 0.5pt;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>@SID</p></td><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:none;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>Satellite ID</p></td></tr><tr><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:solid black 0.5pt;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>@RID</p></td><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:none;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>Radio ID</p></td></tr><tr><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:solid black 0.5pt;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>@CS</p></td><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:none;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>Connect String</p></td></tr><tr><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:solid black 0.5pt;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>@ML</p></td><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:none;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>Meter Location, Adds a carriage return prior to the notes</p></td></tr><tr><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:solid black 0.5pt;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>@MN</p></td><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:none;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>Meter Notes, Adds a carriage return prior to the notes</p></td></tr><tr><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:solid black 0.5pt;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>@MT</p></td><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:none;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>Meter Type</p></td></tr><tr><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:solid black 0.5pt;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>@NM</p></td><td style="padding-left:7px;padding-right:7px;border-top:none;border-left:none;border-bottom:solid black 0.5pt;border-right:solid black 0.5pt;"><p>Meter Name</p></td></tr></table></div><p> </p><p>For example to insert the Satellite ID in a Low Battery alarm, do as follow. </p><ol><li>Select the meter, go to the settings tab and select COMMUNICATION </li><li>Enter the Satellite ID </li><li>Click Save Changes </li><li>Open the Point in either Analogs, Digitals, or Controls. </li><li>Enter the message containing @SID for the Satellite ID. </li><li>Enter the email address, and click Save Changes </li><li>Once the alarm is triggered the alarm list in both the company and meter will show the value as follows: </li><li>Opening the Alarm screen will show the message as follows: </li><li>Once email is received it will also include the Satellite ID: </li></ol><p> </p><p>Note: Codes can be combined within a message. </p><p>Note: Codes will only work within High and Low messages for Analog, Digital, and Controls.</p> </article> <article> <h1>PROBLEM: RTU’s output 0/1 but require TRUE/FALSE for write</h1> <p>DetailAnalysis — Thu, 14 Feb 2008 21:54:00 GMT</p> <p>Some digital read writes in RTU's output 0/1 as a value, but require TRUE or FALSE be sent to trigger the write. We have found this to be true in the ScadaPack. </p> <p>To handle this situation we suggest you use the picklist function to pass the values, and view the raw values as analog not with digital substitution. </p> <p>This can be done by following the HOWTO document for picklist and using the last example passing a True and False value. </p> <p><a href="http://support.detailanalysis.com/blogs/siteonline/archive/2008/02/14/using-picklist-for-analog-controls.aspx">http://support.detailanalysis.com/blogs/siteonline/archive/2008/02/14/using-picklist-for-analog-controls.aspx</a> </p> <p> </p> </article> <article> <h1>HOWTO: Using PickList for Analog Controls</h1> <p>DetailAnalysis — Thu, 14 Feb 2008 21:49:00 GMT</p> <p>The picklist control allows the control to be set up with predefined values to be sent to the remote device. This restricts to sending only values defined in the picklist. Furthermore labels can be given to picklist values making the selection user friendly. </p> <p>This is first done by selecting Picklist from your control type: </p> <p> </p> <p>Then enter the values to pick from separated by comma's: </p> <p> </p> <p>Then when sending a control you will have those values to select from: </p> <p> </p> <p>To enter labels for the values separate the label from the value with a pipe character | then use a comma to separate the values as shown: </p> <p> </p> <p>This will display as shown: </p> <p> </p> <p>When selecting the actual value will be displayed in the Send Value and will be Read Only: </p> <p> </p> <p>The PickList also supports sending direct Boolean values: </p> <p> </p> </article> <article> <h1>New Cryout Alarm Feature Added</h1> <p>kellyadams — Wed, 06 Feb 2008 00:16:00 GMT</p> <p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><font face="Calibri" size="3">The new cryout alarm feature, allows a user with the proper security level to set email addresses and a message to be run whenever a cryout occurs. At the end of the message “Cryout Received!” the cryout data is appended to the email.</font></p><font face="Calibri" size="3"> </font> <p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><font face="Calibri" size="3">To get to this information select the meter you wish to receive cryouts from, click settings, click communication, Enter the email addresses under “Cryout Email” and the message to be sent in “Cryout Message”</font></p><font face="Calibri" size="3"> </font> <p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><font face="Calibri" size="3">We have also added to the screen a maximum cryout per hour. This will trigger an email to the main email just as poll alarm does, when there are more than the specified number of cryouts per hour. This will alert you when rogue devices cryout continuously.</font></p> <p> </p> </article> </main></body></html>