in

Providing online support options to SiteOnline users.

SiteOnline

HOWTO: Create SUM Fields for OPC2SQL Data

With the O2S_FieldCalcSums view installed, using the FieldType for analog values multiple fields can be summarized into a single field.

 Example single meter Pump Volume A and Pump Volume B can be summed into a Pump Volume C.

To do this first add the link to the O2S_FieldCalcSums in the MeterType by doing the following:

  1. Select MeterTypes using administrator [T] button on top of page
  2. Locate MeterType and click Edit
  3. Click the Fields button
  4. There are 10 summary fields supported in the O2S_FieldCalcSums view
    1. Alt0Sum - Summarizing items with Field Type Alt 0
    2. Alt1Sum - Summarizing items with Field Type Alt 1
    3. Alt2Sum - Summarizing items with Field Type Alt 2
    4. Alt3Sum - Summarizing items with Field Type Alt 3
    5. Alt4Sum - Summarizing items with Field Type Alt 4
    6. Alt5Sum - Summarizing items with Field Type Alt 5
    7. Alt6Sum - Summarizing items with Field Type Alt 6
    8. Alt7Sum - Summarizing items with Field Type Alt 7
    9. Alt8Sum - Summarizing items with Field Type Alt 8
    10. Alt9Sum - Summarizing items with Field Type Alt 9
  5. Add each field to the profile, or the number of fields you wish to summarize
  6. When adding the fields set the following fields:
    1. Database: Customer
    2. Table Name: O2S_FieldCalcSums
    3. Field Name: One of the above field names
    4. Layout: Vertical

Next open the meter, select the settings tab, then select Analog
 
Add the the Alt0Sum or any others you wish to have.
 
Then change the Field Type for each item you want summed to match the Alt0sum. 
 
Example Above: Set Pump Volume A and Pump Volume B to Alt 0 Field Type
Then Alt0Sum field will contain the summary of values from Pump Volume A and Pump Volume B
Published Apr 30 2008, 09:58 AM by DetailAnalysis
Filed under:

Comments

No Comments
Copyright 2008 Detail Analysis, Inc. All Rights Reserved
Powered by Community Server (Non-Commercial Edition), by Telligent Systems