Home

SCADAview CSX User`s Manual - Micro

1. Send High Low Setpoints to PLC Reference cose sae Name This is the label used on all reports and displays to name each analog input This is also the message printed when the analog is in an alarm state Units Enter the unit of measure for this analog FEET PSI GPM etc Range For analog inputs the range is the multiplier that is used on the raw value from the PLC Example If the PLC analog value of 0 4095 is to be displayed as 240 ft the range would be 0 0586 4095 x Range Full Scale of Measured Displayed Value Preset This pre sets or offsets the starting raw value for an analog input This allow scales that don t begin at zero Displayed values are computed raw preset x range Label Enter an abbreviation for this analog LVL DP SP etc Trend Min Max Trend graphs will use this for the Y Axis scale which can also be changed on the graph Send High Low Setpoints to PLC If checked SCADAview CSX will send a block of up to 32 words to the PLC with High Low setpoint pairs starting at the Reference entered The base reference will depend on the PLC protocol used CTU32 would be just the uloc such as 1000 SLC protocol may be something like N20 0 SCADAview CSX Micro Comm Inc Page 31 General PLC Analogins Discretes HOAs Expansion Analog Outs Setpoints Accumulators Flow Rates and Flow
2. 8 2012 07 01 06 45 00 87 2 53 6 37 6 376 2080 2247 9 2012 07 01 07 00 00 83 9 51 9 35 9 359 2108 2258 2012 07 01 07 15 00 74 9 47 4 31 4 314 2108 2258 SCADAview CSX Micro Comm Inc Page 52 Exporting Historical Data Station Name Selected Columns Tower 1 Tower Level Starting Date AR Test All High Setpoint readback 3 1 12013 Bv AIL Low Setpoint readback End Date ES wane Data Expression 38 2013 gv EE NAS Resolution WELLCLOCK pasas Flow Total VALVE OPEN VALVE CLOSED El26 Name Station data for a given period of time can be exported to a csv file for use in another program such as Microsoft Excel Select the Export History Files from the Files menu in SCADAview CSX Studio The following options are available Station Name The name of the station with the data to be exported Starting End Date Starting and ending Month Day and Year for the exported data Selected Columns Only the input names checked will be exported to the file in the order listed Resolution Time step for the exported data 1 Minute is the maximum resolution SCADAview CSX Micro Comm Inc Page 53 Script Language SCADAview CSX uses a scripting language that is much like Microsoft s Visual Basic or similar variants Scripts can be run as graphics click actions whenever
3. di EH AH AH AH jar AH AH AH ar jar AP AH ar AH AH ar dw AH AH AH jar AH AH AH AH jar ar AH ar AH AH ar AH Name The name of the expansion discrete input This name is displayed on the station display and will also be used for graphics tagging On Msg Enter the label to be shown when the device is on or alarming Off Msg Enter the label to be shown when the device is off Mode Use the item list to select the available operating modes for the expansion input Valid operating modes are A1 Alarm when input is on AO Alarm when input is off 1 Status when input is on SO Status when input is off P1 Pump status RUN or OFF adds an R or O to the label Label This is the label shown on the System Display screen for this input and is also used for graphics tagging SCADAview CSX Micro Comm Inc Page 34 Remote Setpoints General PLC Analogins Discretes HOAs _ Expansion Flow _ Analog Outs Remote Stop Labels Remote Start Labels Stop Label Start Label Lead Backup Stop Lead Backup Start Lag Backup Stop Lag Backup Start 1 2 3 4 5 6 Y 8 9 1 2 3 4 5 6 7 8 9 10 11 12 10 11 12 THER B B rg LETETTE j o o o o oo o o o 9 o o o o o o o o o o o 9 o Remote setpoints are read and sent to rem
4. M M keep 22 Custom Dally Repo voraces kk iaa A ad ka e oka E a kk e IDE PUN EX DERE ee SK EPI CHOSE TU NE aaa ena n 23 Custom Timed Heports 12 21 LU ta bib kn ie ete a e de RR enun enia kk kk ked Ya de Dan de Rn lense LA Bei Red aen n 24 SGADAVIEW CSX STWAJO e oer eee meer cit pec a said am eka ped ba kon me pepe eed 25 GUSIOMENMONNMANON c eka ere a eere E DL MEE 25 Client Server Startup Options sese rn 26 Folders Database a L kk A At 28 Station Setup citan e T LH 29 Control GEO SMP i oen tto w ide e ete su e nt ko ke ba E TNE OE m ML M MEAE ae 38 i e ESCAPE EIE PEDE 41 Global Security System OpItIOris 95 22 139 Us anbake poet ttp t dn ie ak a kaa bees n ni daba eR Age lau e ek Len DAK RU LA RR cetyl did id 41 Web Page Options ideo er creep dola wt ma pe t Heuer eed reverie ne rate Ete rode db Ee decer UP poud ask e noua bak aac 43 Custom Daily Reports atlas CH Ec Ei dure Et ees 45 Custom Timed Reports etenim aka nennen tenen kass tns iiit s tns re resins entes en resins ae n eastern nnne nnns 46 Report Email Scheduling sercis eter Itt tt da nea tede je taeda a tru e eua est doe sata eg np et aset ee de muet CAP ka pe dan deae dare 47 SQL Database Structure ee 1 c dee 48 Exporting hlistorical DATA e 53 SCHIP ELAM QUADS eta rete pete gage ence aaa peti deba ne t aaa keyi kok ak ooo 54 PLC Data Reference as kwi ine enmi kte tak ke kit Deta led ka e
5. i Legacy Touch Screen Misc Alarm Horn Sounds Main ALMHORN wav Pump Fails LOS Alarms Level Alarms Status Log 7 Speak Alarms Text To Speech 7 CTU Alarm Horn E Alarm Station Display Jump E CTU Alarm Ack F Active Alarm Display Jump v Acknowledgment with Operator Comments The Alarm Options are selected from then Preferences item under the setup menu These options allow an administrator to change the behavior of the alarm system Alarm Horn Sounds The sounds selected will be played every 6 5 seconds whenever an alarm occurs and has not been acknowledged Alarm sounds for Pump Fails LOS Alarms and Level Alarms can be different from the main alarm sound If these special alarm sound files are not selected the main sound will be used instead Select the WAV sound files using the Select button and then click on the Test button to try the sound Status Log Sound The sound selected will be played once whenever a status event occurs Speak Alarms All currently active alarms will be read over and over using the operating system s text to speech engine Alarm Station Display Jump When this option is turned on the Station Display window will be opened to the alarming station when a new alarm occurs Active Alarm Display Jump This will open the active alarms window whenever a new alarm occurs Acknowledgment with Operator Comments This will allow the operator to ty
6. E EE EE Pump Station 1 PumpStation l PumpStation l PampStation 1 PumpSStation 1 Prev Total PSI Total Pressure TowerLerel DischargePressure Suction Pressure FlowRate FlwRate amp 2 FlowRate 3 O 00O De rr co cra w n ca DT F8 11 01 2014 00 00 00 70 6 453 293 293 0 2 098 0 22520 656 746 2 11 01 2014 00 15 00 796 498 338 338 0 2 098 0 22560 746 836 11 01 2014 00 30 00 88 6 543 383 383 0 2 088 0 2 238 0 836 926 11 01 2014 00 45 00 824 512 352 3520 2 099 0 22490 926 864 11 01 2014 01 00 00 734 467 30 7 307 0 2 096 0 22500 864 714 11 01 2014 01 15 00 644 422 262 262 0 2 094 0 22490 714 684 11 01 2014 01 30 00 643 421 26 1 261 0 2 094 0 22440 684 682 11 01 2014 01 45 00 732 466 30 6 306 0 2 095 0 22450 682 T2 11 01 2014 02 00 00 822 511 351 3510 2 106 0 22550 772 862 11 01 2014 02 15 00 887 543 383 383 0 2 096 0 22510 862 926 11 01 2014 02 30 00 798 498 338 338 0 2 093 0 2 248 0 92 6 83 6 11 01 2014 02 45 00 70 8 453 293 293 0 2 096 0 2252 0 836 746 11 01 2014 03 00 00 618 408 248 2480 2 101 0 22510 746 65 6 11 01 2014 03 15 00 67 0 435 215 275 0 2 095 0 22490 656 710 11 01 2014 03 30 00 76 0 48 0 32 0 320 0 2 087 0 2 242 0 71 0 80 0 11 01 2014 03 45 00 85 0 52 5 365 365 0 2 0950 22400 80 0 89 0 11 01 2014 04 00 00 86 0 529 369 369 0 2 096 0 22410 89 0 89 8 11 01 2014 04 15 00 71 0 484 324 324 0 2 105 0 22540 89 8 80 8 11 01 2014 04 30 00 68 0 440 28 0 280 0 2 092 0 22410 80 8 72 0 11
7. ENGINE InnoDB DEFAULT CHARSET latin1 AUTO INCREMENT 513 Dumping data for table SVActiveStationData INSERT INTO SVActiveStationData ID DT SADDR AI AIZ AI3 AIF AI5 AI6 AIZ AI8 AI9 AMO AH T ANZ AH AM A5 ANG Flow Rate Flow Total Flow Rate 2 Flow Total 2 Flow Rate 3 Flow Total 3 Flow Rate 4 Flow Total 4 Flow Rate 5 Flow Total 5 Flow Rate 6 Flow Total 6 Flow Rate 7 Flow Total 7 Flow Rate 8 Flow Total 8 DIt DI2 DI3 DIF DI5 DI6 DIZ DI8 DIS DI10 DI11 DI12 DHS DH4 DIS DIG EN EIZ EIS EM EIS EI6 El EIS EIS EMO EHT EH2Z EMS EHA ENS EHG ENT EHE ENS EIDO EI21T EI22 El23 EI24 EI25 EI26 EI27 EI28 El29 EI3O EI31 EI32 VALUES 1 2012 06 12 12 21 32 HH 56094 6 456 56550 6 19936 100 200 90 6 400 O O 0 O 0 O O O 2486 O O O O O O O O O O O O O O O O O O O O O 0 0 O 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 0 2 2012 06 12 12 21 32 HI O 3 55 0 03 8 3 67 84 0 O 0 0 O 0 O 0 O 0 0 4274 O O O O 0 O 0 O O O O O O O O O O O O O O O O O O 0 0 O O 0 0 0 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O O O O 0 0 0 3 2012 06 12 12 21 32 HJ 10 9 0 0 O 0
8. Flow Rate Total Inputs Value The most recent flow rate total readings Units The unit of measure usually GPM and GAL Status Alarm status HIGH LOW Name Pump Station 1 v Addr PH w Levels High Low Rate Outputs Name Value Units Status Discharge Pressure 80 0 PSI RISE Suction Pressure 40 0 PSI FALL Temperature 750 DEG Discretes Expansion HOAs Maintenance Remote Name SYS RTU Mode Status Pump 1 Auto Auto Cal UM Pump 2 Auto Auto Standby Off Bypass Valve Standby Off LOW SUCTION POWER FAILURE ALARM Flow Rate Total High Low Station Status Name Flow Rate 24 hr Flow Total Station Data RTU cru Data Quality Time Stamp Flow High Low Alarms High User settings for HIGH flow rate or high 24hr total Low User settings for LOW flow rate or low 24hr total SCADAview CSX Micro Comm Inc Page 10 Remote Station Commands Poll Now Clicking this button will cause the CTU to skip all the remaining stations in it s polling list and start over with the selected station Accumulators Click this button to display a window that allows reading and writing of remote accumulator variables These may be used for pump runtimes flow totals etc Real Time Clock If the remote station is RTU32 or later this will allow the station s clock to be read back and then set to match the PC s clock Totalizer If the stat
9. Pump 10 OFF STBY OFF Trend Graph Pump 9 Speed 0 0 Pump 11 OFF STBY OFF Trend w Penfiles gt Pump 10 Speed 0 0 Pump8 Hi Lo PS NORMAL Reports Pump 11 Speed 0 0 Pump9 Hi Lo PS NORMAL kontrol Highmore BU Level 224 FT Pump10 HiLo PS NORMAL m A High Control Level 0 0 FT Pi 11 Hi Lo PS NORMAL High Low Setpoints a ka 2S SE Hand Off Auto Flow Rates and Totals Value Units Status Control Groups Active Alarms Event Lo 9 Discretes 9 16 Status Expansion 1 8 Status Expansion 9 16 Status Expansion 17 24 Status Expansion 25 32 Status Station Status Acknowledge VFD 8 FAULT NORMAL Pump 8 HAND PLC Panel Power Surge HIGH LVL Data Valid VFD 9 FAULT NORMAL Pump 8 AUTO 3000 LOS Surge LOW LEVEL Time 11 01 11a VFD 10 FAULT NORMAL Pump 9 HAND Discharg Analog Surge LOW AIR Date 4 4 13 Not Logged in enn VFD 11 FAULT NORMAL Pump 9 AUTO Surge Analog Surge LOW OIL Users Rich Pump 8 Cycle ENABLE Pump 10 HAND Pump 8 Analog Pass pom Pump 9 Cycle ENABLE Pump 10 AUTO Pump 9 Analog Pump 10 ENABLE Pump 11 HAND Pump 10 As Login Logout me oS Em AL nang Pump 11 Cycle ENABLE Pump 11 AUTO Pump 11 Analog SCADAview CSX Micro Comm Demo System Olathe KS MICRCCOMM All Stations a Station Name Input Name Month Day Year Type System Display Sec Se el Tower 1 TH B Tower Level April La 2013 iow Station Display N Tower 1 Tower Level Graphic Screens Trend Graph Trend w P
10. Trend Graph Options Graph Style Grid Lines Gray Pen LOS Data Pen Size Readout Style Date Selection Export Resolution SCADAview CSX Foreground Color Background Color Type days Z 1 v Minutes Set Defaults Micro Comm Inc Page 18 Real Time Trend Graph Similar to the Trend Graph the Real Time trend is a chart that will show up to 12 separate levels for a past number of minutes and is updated every couple of seconds This allows for much greater detail when viewing a rapidly changing value Real time Trend Graph Y Tower 1 Tower Level 15 0 14 5 14 0 13 5 13 0 12 5 120 11 5 11 0 10510095 90 85 80 75 70 65 60 55 50 45 40 35 30 25 20 15 10 0 5 minutes e Tower 1 Tower Level w e Bil Pump Station 1 y Discharge Pressure w e mI y Pump Station 1 y Suction Pressure x J y e 7 a x J Real Time Trend Graph A z FEET Tower 1 Tower Level Real Time Trend Readout 11 6 2013 7 51 10 AM Pen1 Pen 2 Pen 3 Color Station Tower 1 Pump Station 1 Pump Station 1 Input Tower Level Discharge Press Suction Pressure Value 18 6 FEET 80 0 PSI 40 0 PSI High 22 6 FEET 80 0 PSI 50 0 PSI Low 18 0 FEET 70 0 PSI 40 0 PSI Avg 20 061 FEET 71 343 PSI 48 657 PSI 15 0 14 5 14 0 13 5 13 0 125 120 11 5 11 0 10 5 1009 5 90 85 80 75 TO 65 60 55 50 45 40 35 30 25 20 15 1 0 0
11. O 0 O 0 O O O O O O 0 142 O O O O O O O O O O O O O O O O 1 O O O O O O O O O O O O O O O 0 O O O 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O O 0 4 2012 06 12 12 21 32 HK O 132 0 O 0 0 O 0 0 13 2 0 0 O 0 O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 0 O 0 0 O O O O 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O O 0 5 2012 06 12 12 21 32 HL O 142 0 0 0 0 0 0 O 13 2 O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 0 O O 0 0 0 O O O O O O O O O O O O O O O O O O O O O O 0 6 2012 06 12 12 21 32 HM 0 152 0 0 0 0 0 0 0 13 2 0 0 O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O O 0 7 2012 06 12 12 20 47 HN NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL N
12. PH DIS Runtime double DEFAULT NULL PH Flow Rate Low double DEFAULT NULL PH Flow Rate High double DEFAULT NULL PH Flow Rate NZAvg double DEFAULT NULL PH Flow Total double DEFAULT NULL PRIMARY KEY ID ENGINE InnoDB DEFAULT CHARSET latin1 AUTO INCREMENT 66 Dumping data for table SVCustomDailyReport5 INSERT INTO SVCustomDailyReport5 ID DT PH DH Runtime PH DI2 Runtime PH DIS Runtime PH Flow Rate Low PH Flow Rate High PH Flow Rate NZAvg PH Flow Total VALUES 1 2012 07 10 04 59 59 6 52 7 53 0 239 390 314 6729 4437000 2 2012 07 11 04 59 59 7 03 6 55 0 239 390 315 4167 4443000 3 2012 07 12 04 59 59 7 5 6 32 0 239 390 313 3521 4424000 4 2012 07 13 04 59 59 7 57 6 48 0 239 390 314 7507 4437000 5 2012 07 14 04 59 59 6 65 6 87 0 239 390 315 3315 4443000 6 2012 07 15 04 59 59 6 42 7 43 0 239 390 313 3444 4423000 7 2012 07 16 04 59 59 6 48 7 57 0 239 390 314 8632 4439000 8 2012 07 17 04 59 59 6 73 6 75 0 239 390 315 2986 4442000 9 2012 07 18 04 59 59 7 32 6 55 0 239 390 313 3222 4423000 10 2012 07 19 04 59 59 7 5 6 55 0 239 390 314 941 4439000 SCADAview CSX Micro Comm Inc Page 50 Active Station Data Table structure for table SVActiveStationData CREATE TABLE IF NOT EXISTS SVActiveStationData ID int 11 NOT NULL
13. 25 0 23333 21 667 20 0 18 333 0 1 Friday January 01 2010 Trend Readout 8 00AM Tower 1 Tower Level 1 1 2010 3 00 AM 1 1 2010 8 00 AM Pen Start End 21 0 FEET 22 2 FEET 122 0 PSI 123 0 PSI 45 0 PSI 46 0 PSI 850 0 GPM Pump Station 1 Date 11112010 Gy E R tre 10ay y Pens c8 3 amp Tower 2 v Tower Level y el Pump station 2 Discharge Pressure Pump station 1 Suction Pressure ye Pump Station 1 Few Rate Right Clicking on the graph will also show the following menu options Load Pens Save Pens Clear Pens Hide Show Grid Show Hide Readout Area Line Graph Background Color Pen Size Export Data Print Opens a pen file containing the pen selection Saves a pen file withe the current pen selection Clears all the current pen selections This will turn off or on the light gray grid lines Data readout window will be shown or hidden Selects the graph style area graphs will fill with the pen color to each axis Selects a different background color for the graph normally white Data pen width can be selected from 1 4 pixels This option will save a comma delimited file CSV Allows the graph to be printed Various options can also be set by selecting the menu item or clicking on the Graph Options button
14. AUTO INCREMENT DT timestamp NOT NULL DEFAULT CURRENT TIMESTAMP ON UPDATE CURRENT TIMESTAMP SADDR char 2 DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL Al10 double DEFAULT NULL Alit double DEFAULT NULL Al12 double DEFAULT NULL Al13 double DEFAULT NULL Al14 double DEFAULT NULL Al15 double DEFAULT NULL A116 double DEFAULT NULL AIT Al2 AI3 AIL AIS Ale AIT AIS AI AAA DIT DI2 DIS DI4 DIS DIE DIT DI8 DI9 DIO ow Rate double DEFAULT NULL ow Tota ow Rate 2 double DEFAULT NULL ow Tota ow Rate ow Tota ow Rate ow Tota ow Rate ow Tota ow Rate ow Tota ow Rate ow Tota ow Rate double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL double DEFAULT NULL ow Total smallint smallint smallint smallint smallint smallint smallint smallint _2 3 _3 4 LA 5 5 double DEFAULT NULL 6 L6 T SE 8 8 double DEFAULT NULL DEFAULT NULL DEFAULT NULL DEFAULT NULL DEFAULT NULL DEFAULT NULL DEFAULT NULL DEFAULT NULL 1
15. CGSTART cg as integer start as integer as double CGSTOP cg as integer stop as integer as double CGTIHR cg as integer as integer SCADAview CSX Control group analog enable value 1 or 0 given the group number and enable number Control group alternator value given the group number 1 forward 2 reverse 3 auto Control group prefill value given the group number Control group reset value given the group number Control group start value given the group number and start number Control group stop value given the group number and start number Control group time inhibit hours value given the group number Micro Comm Inc Page 57 CGTIMN cg as integer as integer Control group time inhibit minutes value given the group number CGTRHR cg as integer as integer Control group time restore hours value given the group number CGTRMN cg as integer as integer Control group time restore minutes value given the group number DBAND saddr as string ai as integer as Station analog input high low deadband value given the address and input double number Dl saddr as string di as integer as integer Station discrete input value 1 or 0 given the address and input number DICycles sadar as string di as integer as Maintenance system cycle count for the given station and input integer DICyclesAlarm saddr as string di as inte Maintenance system cycle alarm bit 1 or O for the given station and input ger as integer DICycle
16. CLX Examples dtN TestintData O ditN TestintData 0 3 dtD TestDIntData 10 dtF TestFloatData 20 dtB TestBoolData 0 3 dtD TestUDTName PropertyName 0 dtS TestUDTName PropertyArray 8 dtD TestUDTArray 1 PropertyName 0 Modbus References Modbus data locations are referenced using the register type follow by x and then followed by the offset and optional bit number Supported types Holding Registers 4x Input Registers 3x Coils Ox and Discrete Inputs 1x Floats are also supported and can be derived from either 4x or 3x registers 2 words in either MSW LSW or LSW MSW order Fx float from 4x holding registers MSW LSW Rx float from 4x holding registers LSW MSW Qx float from 3x input registers MSW LSW Zx float from 3x input registers LSW MSW SCADAview CSX Micro Comm Inc Page 68 Modbus Examples 4x100 3x1 4x100 1 1x1 Fx100 Rx100 Signed Integer PLC References Normally all 16bit registers from a PLC are assumed to be an unsigned integer By using a Preset 32768 SCADAview CSX will treat it like a signed integer Floating Point PLC References Floating point values from a PLC used for analogs are normally un scaled to a 16bit integer for use in SCADAview CSX This means that the displayed range of values will depend on the range and preset values used divide by the Range subtract the Preset gt 16bit integer Larger values are possible in a Flow Totals since they are un scaled to a 32b
17. DEFAULT NULL 1 1 1 1 1 1 1 1 1 smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL DI11 smallint 1 DEFAULT NULL DI12 DNS DI14 DNS DI16 EH EI2 EIS EI4 EIS EI6 EIT EIS EID EN0 ENT EN2 ENS EN4 EMS ENS ENT ENS EH9 El20 El21 El22 El23 EI24 EI25 El26 EI27 smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL smallint 1 DEFAULT NULL SCADAview CSX Micro Comm Inc Page 51 El28 smallint 1 DEFAULT NULL EI29 smallint 1 DEFAULT NULL EI30 smallint 1 DEFAULT NULL EI31 smallint 1 DEFAULT NULL El32 smallint 1 DEFAULT NULL PRIMARY KEY ID
18. Data Table Expressions dtN TestIntData 0 3 l dtN TestIntData 0 4 dtN TestIntData 1 dtN TestIntData 2 Modbus Examples 4x104 4x105 100 1x1 I 1x2 Station and Control Group Data Expressions SCADAview CSX Micro Comm Inc Page 70 Station and group data can also be referenced and used for station data these expressions can also be used with CTU32 protocol Station Data References Always begin with the station address HH WW shown as xx in examples below followed by an underscore _ Analog Inputs Outputs and Discrete Inputs Outputs are always followed by the input shown always as a 1 below Examples PH AN TH Al2 PI DO1 CALL PI DO1 FAIL PH AN PH Al2 PH_Al1 PH_AI2 PH_AI3 3 TH_DI1 I TH_DI2 TH_DI1 amp TH_DI2 SCADAview CSX Micro Comm Inc Page 71 Group Data References Always begin with G followed by a group number 1 255 shown as n below and then followed by an underscore _ Stop starts and analog disables are followed by the setpoint number shown always as a 1 below Examples G1 STOP1 G2 PREFILL G1 ADISABLE2 SCADAview CSX Micro Comm Inc Page 72 Data Expressions Station Data Expressions are evaluated whenever a station s data changes and are used for custom calculations moving data or other special purposes Expressions can also be used in graphic screen tags Graphic Tags will nomally get data
19. FR 0 0 GPM Et 0 GAL FT 9 GAL Clearwell amp Ammonia LVL 14 3 FT GAS 9 0 ppm FR 0 0 ppd FT lbs FT lbs High Service Control CMD 0 0 DMD 0 0 KW hr PWR 0 0 KW HR PWR O KW PWR O KW Finished Water CL2 0 0 mg L CL2 3 55 mg L TUR 0 03 NTU FR 4 274 0 GPM FT GAL FT GAL Tower 1 Tower Level 21 3 FEET The System Display windows provide an overview of the entire system or part of a system in the form of a spreadsheet Columns in this spreadsheet will display the station name levels and status inputs along with the appropriate alarm status background color Station Name All station names currently selected for display will appear in the first column and will have a gray background color The back ground color will be different whenever the user has added a station note with a special color The text color will change to Red if the station is in Loss Of Signal Analog Input Columns Analog Input levels will be displayed in the next 8 columns if they are selected for display Column labels with be Al1 Al8 by default The background color will change based on the alarm status for that input Flow Rate Total Columns The next 3 columns are used for Flow Rate 24 Hour Flow Total and Flow Total The background color for these will change based on the flow rate total alarm status Discrete Input Columns All discrete inputs selected for display will be shown next in the spreadsheet Column labels for the first six inputs will defau
20. NULL Flow Rate double DEFAULT NULL Flow Total double DEFAULT NULL DIT smallint 1 DEFAULT NULL DI2 smallint 1 DEFAULT NULL DIS smallint 1 DEFAULT NULL DI4 smallint 1 DEFAULT NULL DI5 smallint 1 DEFAULT NULL DI6 smallint 1 DEFAULT NULL DI7 smallint 1 DEFAULT NULL DI8 smallint 1 DEFAULT NULL DI9 smallint 1 DEFAULT NULL DIH10 smallint 1 DEFAULT NULL DI11 smallint 1 DEFAULT NULL DI12 smallint 1 DEFAULT NULL DI13 smallint 1 DEFAULT NULL DI14 smallint 1 DEFAULT NULL DI15 smallint 1 DEFAULT NULL DI16 smallint 1 DEFAULT NULL EI1 smallint 1 DEFAULT NULL EI2 smallint 1 DEFAULT NULL EI3 smallint 1 DEFAULT NULL EI4 smallint 1 DEFAULT NULL EI5 smallint 1 DEFAULT NULL EI6 smallint 1 DEFAULT NULL EI7 smallint 1 DEFAULT NULL El8 smallint 1 DEFAULT NULL EI9 smallint 1 DEFAULT NULL EI10 smallint 1 DEFAULT NULL 1 EH T smallint 1 DEFAULT NULL El12 smallint 1 DEFAULT NULL EH S smallint 1 DEFAULT NULL EH 4 smallint 1 DEFAULT NULL EI 5 smallint 1 DEFAULT NULL El16 smallint 1 DEFAULT NULL EN17 smallint 1 DEFAULT NULL EH8 smallint 1 DEFAULT NULL EH 9 smallint 1 DEFAULT NULL EI20 smallint 1 DEFAULT NULL EI21 smallint 1 DEFAULT NULL El22 smallint 1 DEFAULT NULL EI23 smallint 1 DEFAULT NULL EI24 smallint 1 DEFAULT NULL EI25 smallint 1 DEFAULT NULL El26
21. PUMPT PUMPS FT24 FRMIN FRMAX FRAVG VALUES 1 2012 07 02 04 59 59 6 3 7 3 0 12 05 0 0 12 03 11 95 4444000 239 390 315 5833 2 2012 07 03 04 59 59 5 97 7 82 0 12 03 0 0 11 9 11 98 4426000 239 390 313 4917 3 2012 07 04 04 59 59 6 65 7 42 0 11 98 0 0 11 98 12 4435000 239 390 314 4507 4 2012 07 05 04 59 59 7 18 6 4 0 12 0 0 12 02 11 98 4443000 239 390 315 5326 5 2012 07 06 04 59 59 7 7 6 12 0 12 0 0 11 95 12 08 4425000 239 389 313 4278 6 2012 07 07 04 59 59 7 5 6 55 0 11 97 0 0 12 12 4436000 239 390 314 5549 7 2012 07 08 04 59 59 6 47 7 05 0 11 98 0 0 12 12 11 95 4444000 239 390 315 4972 8 2012 07 09 04 59 59 6 2 7 62 0 12 05 0 0 12 11 9 4424000 239 390 313 4035 9 2012 07 10 04 59 59 6 52 7 53 0 11 95 0 0 12 02 12 4437000 239 390 314 6729 10 2012 07 11 04 59 59 7 03 6 55 O 12 02 O O 11 95 12 08 4443000 239 390 315 4167 Sample Custom Daily Report 5 includes 3 discrete input runtimes flow rate low high avg and flow total Table structure for table SVCustomDailyReport5 CREATE TABLE IF NOT EXISTS SVCustomDailyReport5 ID int 11 NOT NULL AUTO INCREMENT DT timestamp NOT NULL DEFAULT CURRENT TIMESTAMP ON UPDATE CURRENT TIMESTAMP PH DH Runtime double DEFAULT NULL PH DI2 Runtime double DEFAULT NULL
22. TH 1 0 0 format Al PH 2 0 0 RunScript fname as string sparams as Runs another script given the script filename and parameters string string SaveScreen scrname as string pzoom as Saves a snapshot of the given graphics screen jpeg file to the Script Output single fname as string folder Use the pzoom parameter to zoom the picture from 1 to 10095 SCADAdialStatus as string Returns the latest status message string from SCADAdial CSX if installed and enabled Scale dval as double minraw as double Scale the given dval variable given the min max parameters maxraw as double minscl as double maxscl as double as double ScriptParams Parameters string which can be passed in from the Run Script graphics action or the RunScript function SecurityLogin Show the security login window SecurityLogout Logs the current user out SecurityRUserLevel as integer Returns the remote level of the current user O none 9 Operator 99 Supervisor 999 Admin SCADAview CSX Micro Comm Inc Page 63 SecurityUserLevel as integer SecurityUserName as string SecurityUserNum as integer SendEmail emailaddr as string subject as string msg as string SendEmailFile emailaddr as string subject as string msg as string fname as string SendEmailHTML emailaddr as string sub ject as string html as string SetupFileDownload sfile as string allfiles as boolean SetupFileUpload sfile as string allfiles as boo
23. X These HOA labels are used whenever an output needs to be labeled differently from the corresponding input If labels are left blank the discrete input labels will be used instead The HOAs have a Selector Type for what options will be displayed in a drop down list or on a graphical HOA Standard selec tors include Hand Off Auto Start Stop On Off Open Close Auto Open Close Custom selector types may be created by manually entering up to 4 selection labels seperated by the character For example Manual Off Auto Monitor The first selection will write a value of 1 to the PLC the second a value of O the third a value of 2 and if a fourth selection is used it will write value of 3 The default is to use the normal 2 bits for an HOA PLCs can use other options if values or bit references are placed at the end of each label immediately following an equals sign For example Manual 10 Off 11 Auto 12 would set a PLC location to 10 11 or 12 depending on the selection Manual b1 Off b2 Auto b3 would set bit 1 2 or 3 in a PLC location depending on the selection and clear just the other 2 bits Virtual HOAs Like the Remote Setpoints described before these virtual HOAs are read and sent to the remote RTU The variables X9 thru X16 are used to represent 8 different HOA settings Hand 1 Auto 2 Off 0 Both the Central PC HOAs and the Remote Virtual HOAs have a selection for w
24. and hoa number and X y location Use special x y coordinates of 0 0 to center this window in the main window Opens a new Alert Box window with a given title and user message with a red background color that can optionally flash Use x y coordinates of 0 0 to center the alert box window in the main window Opens a new generic Message Box popup window with a given title and user message Use special x y coordinates of 0 0 to center the message box window in the main window Micro Comm Inc Page 64 ShowPCP saddr as string do as integer x Opens the Pump Control Panel HOA window given the station address and as integer y as integer hoa number Use x y coordinates of 0 0 to center the Pump Control Panel window in the main window ShowPopupTemplate scrname as string Opens a popup window given the name replacement list and title Use x y replacelist as string title as string x as inte coordinates of 0 0 to center this window in the main window or use the saved ger y as integer sclperc as double position The popup window can optionally be scaled to a given percentage using the sclperc parameter ShowPopupWindow scrname as string x as Opens a popup window given the name Use x y coordinates of 0 0 to integer y as integer sclperc as double center this window in the main window or use the saved position The popup window can optionally be scaled to a given percentage using the sclperc parameter ShowRemoteSetpoints saddr
25. directly from stations or groups They can also get data from a special tag station source FN Built In Function The Tag Data source can then be either EXA or EXD for analog or discrete expressions Expressions can use station data variables script global variables control group data operators and or functions to return a value Numbers used in all expressions are internally stored as double precision floating point Graphic tags can also use script global array variables B M X Y as well as any user defined global variables In addition to the analog and discrete expressions the following special Static Text messages are available TIMES will display a short format time string HR MN AP DATES will display a short format date string MM DD YYYY xxNAME display station name where xx is the station address GxxxNAMES display group name where xxx is the group address LABELS saddritype inum Itype used to display any station label see the CSX Script LABELS function SCREENNAMES used to display the graphic screen name Note These special strings are entered in the graphic tag Static Text property Examples PHNAMES to display the station name for address PH LABELS PH DI 1 NAME to show the input name for station PH discrete input 1 LABELS PH AI 1 UNITS to show the units label for station PH analog input 1 Operators and Functions po AA A A A A Left and right parentheses for functions or
26. group Example Lead Pump Lag Pump etc Stop Start Labels Special labels for display above the stop start setpoints in SCADAview CSX If something other than Stop and Start are desired such as Cutoff and Restore enter the labels here Override Stop Start Labels Same as above but these labels are displayed above the override setpoints SCADAview CSX Micro Comm Inc Page 39 Custom Group Screen Setup Group Pump Station 1 General PLC Normal Group Custom Group Screen Disable Help Custom Stops Custom Starts Stop Label Start Label MAAA TAE ooo 9 9 9 9 o 1 2 3 4 5 6 7 8 9 ooo osososooooo woman Du 4 UY ny e Show Fail Reset Button E Show Alternator Custom Alternator Setpoints Title Alternator Selections Alternator Label AUTO FORWARD REVERSE Alternator Custom Group Screens allow much more flexibility in how they are displayed in SCADAview CSX The options are as follows Stop Label Start Label Custom labels for each stop or start setpoint stops are on the left side of the control group screen and starts are on the right Units The units label is displayed to the right of each setpoint entry edit field Range Preset The multipliers and offsets used to scale each setpoint scaled raw preset range Show Fail Reset Button If check the group s Fail Reset button is shown on the custom grou
27. numbered 1 Oct Integer As String Returns as a string the octal version of the number passed Pow Double Double As Double Returns the value specified raised to the power specified Redim Resizes the passed array Arrays are zero based a 5 1 lt Rem Used to add comments to your code can also use or Replace String String String As String Replaces the first occurrence of a string with another string ReplaceAll String String String As String Replaces all occurrences of a string with another string RGB Returns a Color based on the RGB red green blue color model Right String Integer As String Returns the last n characters from the string specified Rnd As Double Returns a randomly generated number in the range 0 lt Rnd lt 1 Round Double As Double Returns the passed value rounded to the nearest Integer RTrim String As String Returns the string data type passed with trailing right side whitespaces removed SCADAview CSX Micro Comm Inc Page 56 Select Case Executes one of several groups of statements depending on the value of an expression Sin Double As Double Sqrt Double As Double Str Double As String StrComp String String Integer As Integer Sub End Sub Tan Double As Double Ticks as Integer Titlecase String As String Trim String As String True Ubound array As Integer Uppercase String As String Val String As Double While Wend Returns the sine
28. smallint 1 DEFAULT NULL EI27 smallint 1 DEFAULT NULL El28 smallint 1 DEFAULT NULL EI29 smallint 1 DEFAULT NULL EI30 smallint 1 DEFAULT NULL EI31 smallint 1 DEFAULT NULL EI32 smallint 1 DEFAULT NULL PRIMARY KEY ID ENGINE InnoDB DEFAULT CHARSET latini AUTO INCREMENT 26207 Dumping data for table SVStatLogPH INSERT INTO SVStatLogPH ID DT AIT AIZ AI3 AIF AI5 AIO AI7 AI8 Flow Rate Flow Total DI1 DI2 DIS DI4 DIS DIG DI7 DI8 DID DITO DHT DI12 DITS DH4 DIT5 De EN EIZ EIS EIF EIS EI6 EI7 EIS EIS ENO ENT ENZ ENS ENS ENS EN6 EH 7 EH8 EN9 EI20 EI2T El22 EI23 EI24 El25 EI26 EI27 El28 EI29 EI30 EI31 EI32 VALUES SCADAview CSX Micro Comm Inc Page 48 1 2012 07 01 05 00 00 52 2000007629 36 2000007629 24221 12358 0 96 5299987793 61 70 362 83468 1 0 0 0 O O 1 O 0 O O O O 0 O 1 O 0 O 0 0 O 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O 0 2 2012 07 01 05 01 00 52 5 36 5 24691 12419 O 96 5299987793 61 70 365 83471 0 0 O O O O 1 0 0 0 0 0 O O O 1 O O O O O O O O O O O 0 0 O O 0 0 0 O 0 O O O O O O O O O O O 0 3 2012 07 01 05 02 00 52 7999992371 36 7999992371 25153 12479 0 96 5299987793 61 70 368 83475 0 1 O 1 0 O 1 0 0 O O
29. to force order of operation FULEV Security User Level 9 oper 99 super 999 admin SCADAview CSX Micro Comm Inc Page 73 FUNUM Security User Number O no one logged in FBMSK b0 b1 b2 Returns an integer value with bits set as given in the parameters Bit order b0 b1 b2 b3 b4 up to 16 total bits FBTST x Tests bit n in expression x FABS Absolute Value FTIME computer time or date value depending on the x parameter 1 day of week 1 SUN 2 Month 1 12 3 Day 1 31 4 Year 0 99 5 Hours 0 23 6 Min 0 59 7 Sec 0 59 FSIN x Sine angles are in degrees FIF x y x X y X x x x n Y z If x is non zero true then it will return y else it returns z FSELECT x v1 y1 v2 y2 v n If x is equal to v1 it will return y1 if x equals v2 it returns y2 and so on If no value is y n found it returns O FHASLABEL saddr Itype Inum Lty Discrete function that returns a 1 if a station s label given the input type input pe label number and label type is not blank or optionally if it matches a given label Example FHASLABEL PH DI 1 Name Note Inputs types are Al DI El FR FT AO and HOA The Ltype corresponds to the name of the label column at the top of the station setup panel For instance the analog inputs would have Name Range Preset etc Examples PHFR PIFR PJFR adds together 3 station s flow rates THAI1 TIAI1 compute the difference between 2 ta
30. 0 GLNS Data Quality Valid Flow Rate 2 1 091 0 GPM Time Stamp 6 51 19a Flow Total 2 2 200 658 000 GAL The Station Display allows an operator to view all information and make changes to control parameters on a remote station Note Making changes to setpoints is accomplished by selecting the proper tab clicking once or twice in a text box typing the new value and pressing Enter or clicking out of the text box Name The name given to the remote station being displayed Changing this selector or the ID selector will change the current station being viewed Addr The 2 character address of the station being displayed HH through WW Notes Clicking on this button will bring up a text editor for typing notes related to the station A status color can also be chosen in the editor that will be the background color for the station name on the System Display Information is presented in 4 separate tab panels that will show different items based on each tab selector The following is a list of what each panel will do Upper left panel Levels This panel shows information related to analog input output levels and settings The name of each input used will appear on the left The other columns will change based on the option being viewed Levels Value The most recent level reading for the input Units The unit of measure i e PSI FEET etc Status The most recent status change or alarm RISE FALL HIGH LOW RATE Hig
31. 01 2014 04 45 00 60 7 404 244 244 0 2 100 0 22490 720 648 11 01 2014 05 00 00 697 449 289 289 0 2 103 0 22530 648 733 11 01 2014 05 15 00 787 494 334 334 0 2 100 0 2 250 0 738 82 8 11 01 2014 05 30 00 87 7 539 379 3790 2 098 0 22470 828 918 11 01 2014 05 45 00 833 516 356 356 0 2 098 0 22530 918 872 11 01 2014 06 00 00 743 471 311 3110 2 091 0 22460 872 782 11 01 2014 06 15 00 653 42 6 26 6 266 0 2 092 0 22120 782 692 11 01 2014 06 30 00 63 5 418 258 258 0 2 098 0 22430 692 616 11 01 2014 06 45 00 725 463 303 303 0 2 098 0 22420 676 766 11 01 2014 07 00 00 815 50 8 348 348 0 2 094 0 2 246 0 76 6 85 6 11 01 2014 07 15 00 895 547 387 3870 2 089 0 22410 856 934 r r r r r r T r T This report uses a file that is updated on a user selected time interval 1 minute 15 minute etc and saves snapshot values for any station s data The report window will display the lines from this file based on the period selected High low and average values will be computed and shown at the bottom of the report SCADAview CSX Micro Comm Inc Page 24 SCADAview CSX Studio SCADAview CS File Edit Setup Window Help BO fri mao 5 B Save Project Stations Groups Graphics Security Web Page ScriptEditor SCADAdial RTUCfg32 Customer Information Name Test Name D Client Server Startup Location Test Location EJ Folders amp Database a Security System c Stations T Control Groups Add On Feature Enable Codes MA Graphic Screens
32. 210 000 0 0 343 76 010620010 610 570 000 ooo ooof ooo ooo 0 00 263 000 00 34331 01 07 2010 540 360 000 ooo ovof ooo 000 0 00 194 000 343 58 01 08 2010 10 soo 0 00 ooo 000 000 000 0 00 201 000 01 09 2010 630 440 000 0 00 0 00 00 ooo 0 00 248 000 01 10 2010 29 6 00 0 00 0 00 0 00 0 00 ooo 0 204 000 0 00 0 00 0 00 01 11 2010 280 6 00 000 0 00 0 00 000 000 01 12 2010 690 aso o0o 000 0 00 000 0 00 259 000 01 13 2010 590 300 000 000 000 000 000 01 14 2010 420 540 000 ooo ooo 000 00 01 15 2010 400 680 ooo 0 00 ooo ooo ooo 0 00 01 16 2010 sso 320 0 00 ooo 0 00 0 00 0 00 000 0 00 0 00 0 00 01 17 2010 5 80 aso ooo ooo 000 0 00 000 236 000 01 18 2010 380 550 0 00 000 000 000 0 00 01 19 2010 490 340 000 0 00 ooo ooo ooo 000 1 i 01 20 2010 400 ooo ooo ovof ooo ooo 0 00 239 000 01 21 2010 70 2so 0 00 ooo 0 00 ooof 000 000 01 22 2010 390 000 ooo ooo ooo 0 00 0 00 01 23 2010 10 250 ooof ooo ooo ooo ooo 0 00 01 24 2010 620 ooo 0 00 ooo ooo ooo 0 00 01 25 2010 0 320 ooo ovof ooo 000 ooo 0 00 This report uses a file that is updated every midnight and stores daily totals for Pump Runtimes minimum Flow Rate maximum Flow Rate non zero average Flow Rate and Flow Total The report window will display
33. 5 minutes SCADAview CSX Micro Comm Inc Page 19 Pump Runtime Report Start Date End Date Start HR End HR Y 112010 Gyr 1312010 Ev Zam Bam G SCADAview CSX Demo System Pump Station 1 Pump Runtime Report for January 1 2010 12 00am to January 31 2010 11 59pm Wocmememmuad mur Gen DiscreteImputLabel Hours Cyeles Pump 1 9 0 0 Pump 2 10 0 0 High Discharge 0 0 m 00 Bypass Valve 00 2 0 0 Low Suction 09 13 0 0 Power Fail 0 0 14 00 Entry Alarm 0 0 15 0 0 Station Flood 0 0 16 0 0 MU 7 436 000 GAL 1 100 GPM 0 0GPM 733 26 GPM nf a 8 al S o EI o 5 8 S zi E ojololjololoo clelelelsielecle 2 5 E o This report will compute and display runtimes for discrete inputs DI1 DI16 and expansion inputs El1 El32 In addition to pump runtimes it will also show the minimum maximum and average flow rate and the total flow for a selected period of time The user simply selects the station name start date end date start hour and end hour All runtimes are shown in hours and tenths of hours This report is based on the 1 minute historical files SCADAview CSX Micro Comm Inc Page 20 Analog Report Station Name Start Date End Date Start HR End HR Pump Station 1 112010 Gy 13172010 Er 12am 12am v SCADAv
34. 6 83496 0 1 0 O O O 1 O 0 O O O O 0 O 1 O O O O O O 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O 0 10 2012 07 01 05 09 00 54 9000015259 38 9000015259 28380 12898 0 96 6279983521 61 70 389 83499 0 1 0 0 0 0 0 O 0 0 0 0 0 0 0 1 0 0 O O O 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O O 0 Station Address PH 1 Minute Historical Expanded Data Table structure for table SVStatLogExpPH CREATE TABLE IF NOT EXISTS SVStatLogExpPH ID int 11 NOT NULL AUTO INCREMENT DT timestamp NOT NULL DEFAULT CURRENT TIMESTAMP ON UPDATE CURRENT TIMESTAMP AI9 double DEFAULT NULL Al10 double DEFAULT NULL Al11 double DEFAULT NULL Al12 double DEFAULT NULL Al13 double DEFAULT NULL Al14 double DEFAULT NULL Al15 double DEFAULT NULL Al16 double DEFAULT NULL Flow Rate 2 double DEFAULT NULL Flow Total 2 double DEFAULT NULL Flow Rate 3 double DEFAULT NULL Flow Total 3 double DEFAULT NULL Flow Rate 4 double DEFAULT NULL Flow Total 4 double DEFAULT NULL Flow Rate 5 double DEFAULT NULL Flow Total 5 double DEFAULT NULL Flow Rate 6 double DEFAULT NULL Flow Total 6 double DEFAULT NULL Flow Rate 7 double DEFAULT NULL Flow Total 77 double DEFAULT NULL Flow Rate 8 double DEFAULT NULL Flow Total 8 double DEFAULT NULL PRIMARY KEY ID ENG
35. 71 2251 813787 2424 745971 2625 688584 2864 639403 3150 596773 3475 559474 8 2012 07 01 05 07 00 886 12777 0 0 2183 1784 0 0 2124 895176 2253 813791 2426 745975 2626 688588 2865 639406 3151 596776 3503 559477 9 2012 07 01 05 08 00 892 12839 0 0 2167 1784 0 0 2117 895181 2267 813795 2441 745979 2645 688591 2885 639409 3174 596779 3528 559480 10 2012 07 01 05 09 00 898 12898 0 0 2183 1785 0 0 2111 895185 2261 813800 2435 745983 2638 688595 2877 639413 3134 596782 3484 559483 SCADAview CSX Micro Comm Inc Page 49 Station Address PH Daily Pump Report Table structure for table SVDailyPumpReportPH CREATE TABLE IF NOT EXISTS SVDailyPumpReportPH ID int 11 NOT NULL AUTO INCREMENT DT timestamp NOT NULL DEFAULT CURRENT TIMESTAMP ON UPDATE CURRENT TIMESTAMP PUMP1 double DEFAULT NULL PUMP2 double DEFAULT NULL PUMP3 double DEFAULT NULL PUMP4 double DEFAULT NULL PUMP5 double DEFAULT NULL PUMP6 double DEFAULT NULL PUMP7 double DEFAULT NULL PUMP8 double DEFAULT NULL FT24 double DEFAULT NULL FRMIN double DEFAULT NULL FRMAX double DEFAULT NULL FRAVG double DEFAULT NULL PRIMARY KEY ID ENGINE InnoDB DEFAULT CHARSET latin1 AUTO INCREMENT 19 Dumping data for table SVDailyPumpReportPH INSERT INTO SVDailyPumpReportPH ID DT PUMP1 PUMP2 PUMP3 PUMP4 PUMPS PUMP6
36. Address Q customer Information TH Tower cTu32 192 168 3191 O centi startup a ES Folders amp Database Lowercase ph SLC 192 168 3194 A Security System Raw Water Pumps CTU32 192 168 3191 fa Ste Ground Storage CTU32 192 168 3 191 t Control Groups High Service Pumps None Ul Graphic Screens Lift Station CTU32 192 168 3 191 web Page SLC 5 05 PLC 2 SLC 192 168 3194 Number Formats MO SLC5 05 Station SLC 192 168 3 194 me won O Un ew WI Colors uU uLynx Station UJ Modbus TCP 192 168 3 205 7 Help Tips PW MI550PW CTU32 192 168 3 191 M Pic Central Code M1550 MR CTU32 192 168 3191 Equation Station None Reporting Rapid Mixers None A Custom Dai Reports Flocculator 3 6 CTU32 192 168 3 191 Flocculator 27 210 None Custom Timed Reports Influent Chlorine None Email Scheduling Feeder 6 10 None SS Plant Influent Valve None Backwash Pumps None SEIS Clearwell amp Ammonia None Stations 52 Finished Water None Control Groups 14 Washwater Recovery None Graphic Screens 17 Raw Intake None PLC Tag Count 1960 Raw Intake Control CTU32 192 168 3191 FILTER PLCs amp RTUs None Ala DEC st ce 10341c0 34104 Database Controls Stations Use this list to select the station to edit double click or select and click the edit button This list will show the name address PLC protocol and IP address COM settings for each station Add Click this button to add a new station to the end of the d
37. Daily Report Number Formats Expanded Station Data M Colors Test Flow Totals 7 Help Tips Daily Flow Totals B pio central Code E custom Daily Reports 77 Custom Timed Reports E Misc Options Statistics Stations 52 Control Groups 14 Graphic Screens 7 Daily Custom Daily Custom Timed Graphic Screen Trends and Radio Diagnostic can optionally be emailed to operators on a daily weekly or monthly basis Simply select Enable Email for the report type in question select the reports and type in the email addresses separated by commas as shown in the example above The Daily email will be sent just after midnight each day Weekly email will be sent out on Monday morning and Monthly will be sent on the 1st of each month with the previous month s report Note If an email address of LocalPrinter is used instead of an email address the default local printer will be used In order to email the reports SCADAview CSX needs to also have your email server settings You may need to contact your net work system administrator to get this info SCADAview CSX will also use these settings whenever it needs to email anything else CSX Script may be used to send email 008 AG o SB o cob SaveProject Info Startup Database Security Stations Groups Graphics WebPage Script Editor SCADAdial PLC Report Email Scheduling Daily Reports Custom D
38. HIGHALARM saddr as string ai as integer Station analog input high alarm bit given the address and input number as integer HIHI saddr as string ai as integer as Station analog input high high setpoint given the address and input number double HIHIALARM saddr as string ai as integer Station analog input high high alarm bit given the address and input number as integer SCADAview CSX Micro Comm Inc Page 59 LABELS saddr as string itype as string inum as integer Iname as string as string LOLO saddr as string ai as integer a double LOLOALARM saddr as string ai as integer as integer LOS saddr as string ai as integer as integer LOW saddr as string ai as integer a double LOWALARM saddr as string ai as integer as integer NDS saddr as string as integer PCHOA saddr as string pump as integer as integer RATE saddr as string ai as integer a double RATEALARM saddr as string ai as integer as integer RISERATE saddr as string ai as integer a double RISERATEALARM saddr as string ai as integer as integer RISING saddr as string ai as integer a integer StationAddress sname as string StationName saddr as string SYSHOA saddr as string do as integer as integer TimeStamp saddr as string as string TimeSDataAge saddr as integer TimeSHours saddr as string as integer TimeSMinutes saddr as string as integer TimeSSeconds saddr as string as integer VDS saddr as string as integer
39. HTTP protocol connection to the given url and requests the web string method as string page The socket number must be in the range of 0 32 The optional method parameter can be GET POST OPTIONS HEAD PUT etc as per RFC 2616 describing the HTTP 1 1 protocol If omitted the GET method will be used Example HTMLRequestPage 1 http www micro comm inc com index html HTTPPageReceived sck as integer as Returns the latest web page string data received after using the HTTPRe string questPage function IntToBool ival as integer as boolean Returns a boolean false or true based on whether the given integer value is 0 or non zero KeyPressed as string Returns the last key pressed in SCADAview CSX function keys will be returned as F1 F2 etc LaunchFile filepath as string Runs the given program file opens the given folder name or launches the given file with it s default application LaunchReports Runs the Reports CSX application LaunchTrend penfilename as string Runs the Trend CSX application which will then load the given pen file LaunchSTrend Runs the Single Pen Trend CSX application LogMessage Inum as integer msg as Logs a custom message to the given SCADAview CSX log number string 1 alarm 2 status 3 setpoints 4 security 5 scadadial 6 system MonthNumDays year month as integer Retursn the total number of days in month given the year and month MouseX as integer Current X location of the mouse cu
40. Help Aida Trim A o 5 Save Project Stations Groups Graphics Security WebPage ScriptEditor SCADAdial RTUCfg32 Folders amp Database Setup Customer Information D Client Server Startup History CASTATS 1 Folders a Security System 7 Enable History Backup secondary storage location Setup C MICROCOM Stations History Backup C Program Files SCADAview CSX b Control Groups Bl Graphic Screens E SQL Database Logging o Web Page Number Formats M colors Help Tips PLC Central Code Server Type MySQL Enable Active Station Data Table Enable 1 Minute History Data Tables Enable Daily Pump Report Tables Reporting Host Name or IP Address Database Name T7 Custom Daily Report EXE E m Custom Timed Report User Name Password Port Email Scheduling root T7 Misc Options Stations 49 Control Groups 12 Graphic Screens 11 Setup and History Folders This shows the current paths to where all the project files and history is stored on the computer Click the Select buttons to change the locations Backup History secondary storage location This shows the path to where all history will be logged in addition to the primary location This could be a network location or exter nal drive SQL Database Logging If an SQL database server is available click this checkbox to enable historical information logging to various tables in the database Enable Active Station Data Table If this is checked
41. INE InnoDB DEFAULT CHARSET latin1 AUTO INCREMENT 26210 Dumping data for table SVStatLogExpPH INSERT INTO SVStatLogExpPH ID DT Al9 Al10 AIT ANZ AN3 AI AN15 AN16 Flow Rate 2 Flow Total 2 Flow Rate 3 Flow Total 3 Flow Rate 4 Flow Total 4 Flow Rate 5 Flow Total 5 Flow Rate 6 Flow Total 6 Flow Rate 7 Flow Total 7 Flow Rate 8 Flow Total 8 VALUES 1 2012 07 01 05 00 00 844 12358 0 0 2183 1784 0 0 2122 895144 2274 813762 2448 745948 2626 688563 2865 639383 3149 596754 3499 559457 2 2012 07 01 05 01 00 850 12419 0 0 2183 1784 0 0 2103 895148 2253 813766 2426 745952 2628 688566 2864 639386 3150 596757 3499 559460 3 2012 07 01 05 02 00 856 12479 0 0 2183 1784 0 0 2102 895153 2252 813770 2424 745956 2624 688570 2863 639390 3130 596761 3479 559463 4 2012 07 01 05 03 00 863 12542 0 0 2168 1783 0 0 2124 895158 2252 813775 2425 745960 2625 688574 2864 639393 3150 596764 3500 559466 5 2012 07 01 05 04 00 868 12597 0 0 2183 1784 0 0 2105 895162 2254 813779 2429 745963 2632 688577 2871 639396 3158 596767 3511 559468 6 2012 07 01 05 05 00 875 12663 0 0 2183 1784 0 0 2089 895167 2238 813783 2410 745968 2636 688581 2876 639400 3166 596770 3520 559471 7 2012 07 01 05 06 00 880 12717 0 0 2167 1784 0 0 2101 8951
42. ING saddr as string fr as integer as Station flow rate rising bit 1 or O given the address and input number integer FT saddr as string ft as integer as double Station flow total value given the address and input number FT24 saddr as string ft as integer as Station 24hr flow total value given the address and input number double FT24FALLING saddr as string ft as integer Station 24hr flow total falling bit given the address and input number as integer FT24HIGH saddr as string ft as integer as Station 24hr flow total high setpoint given the address and input number double FT24HIGHALARM saddr as string ft as Station 24hr flow total high alarm bit given the address and input number integer as integer FT24LOW sadar as string ft as integer as Station 24hr flow total low setpoint given the address and input number double FT24LOWALARM saddr as string ft as Station 24hr flow total low alarm bit given the address and input number integer as integer FT24RISING saddr as string ft as integer Station 24hr flow total rising bit given the address and input number as integer FTFALLING saddr as string ft as integer Station flow total falling bit given the address and input number as integer FTRISING saddr as string ft as integer as Station flow total rising bit given the address and input number integer HIGH saddr as string ai as integer as Station analog input high setpoint given the address and input number double
43. L NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Sample Custom Timed Report includes a few analog input and flow rates logged at 15 minute intervals Table structure for table SVCustomTimedReport CREATE TABLE IF NOT EXISTS SVCustomTimedReport ID int 11 NOT NULL AUTO INCREMENT DT timestamp NOT NULL DEFAULT CURRENT TIMESTAMP ON UPDATE CURRENT TIMESTAMP TH AI1 double DEFAULT NULL PH AN double DEFAULT NULL PH AI2 double DEFAULT NULL PH Flow Rate double DEFAULT NULL PH Flow Rate 2 double DEFAULT NULL PH Flow Rate 3 double DEFAULT NULL PRIMARY KEY ID ENGINE InnoDB DEFAULT CHARSET latint AUTO INCREMENT 1751 Dumping data for table SVCustomTimedReport INSERT INTO SVCustomTimedReport ID DT TH AN PH AIT PH AIZ PH Flow Rate PH Flow Rate 2 PH Flow Rate 3 VALUES 1 2012 07 01 05 00 00 84 4 52 2 36 2 362 2122 2274 2 2012 07 01 05 15 00 86 5 53 2 37 2 372 2106 2256 3 2012 07 01 05 30 00 77 6 48 8 32 8 328 2104 2251 4 2012 07 01 05 45 00 68 6 44 3 28 3 283 2122 2273 5 2012 07 01 06 00 00 60 2 40 1 24 1 241 2088 2238 6 2012 07 01 06 15 00 69 2 44 6 28 6 286 2088 2237 7 2012 07 01 06 30 00 78 2 49 1 33 1 331 2108 2258 8 9 10
44. O O 0 O 1 0 0 0 0 0 O 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O 0 4 2012 07 01 05 03 00 53 0999984741 37 0999984741 25636 12542 0 96 4319992065 61 70 371 83478 0 1 O 1 0 0 0 O 0 O O O O O O 1 0 O 0 0 0 0 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O 0 5 2012 07 01 05 04 00 53 4000015259 37 4000015259 26064 12597 0 96 5299987793 61 70 374 83482 0 1 0 0 O O O 1 0 0 0 O O 0 O 1 0 O 0 0 0 0 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O 0 6 2012 07 01 05 05 00 53 7000007629 37 7000007629 26568 12663 0 96 5299987793 61 70 377 83485 0 1 0 0 O 0 O 1 0 0 O O O 0 O 1 0 O 0 0 0 0 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O 0 7 2012 07 01 05 06 00 54 38 26988 12718 0 96 5299987793 61 70 380 83489 0 1 0 1 0 O 1 1 O O O O O O O 1 0 0 O O O O O O O 0 0 0 O 0 0 O 0 0 O O 0 O O O O O O O O O O 0 8 2012 07 01 05 07 00 54 2999992371 38 2999992371 27442 12777 0 96 5299987793 61 70 383 83492 0 1 0 1 0 O 1 1 0 O O O O 0 O 1 O O O O O O 0 0 0 O 0 O O O O O O O O O O O O O O O O O O O O 0 9 2012 07 01 05 08 00 54 5999984741 38 5999984741 27919 12839 0 96 5299987793 61 70 38
45. SCADAview CSX User s Manual Updated November 18 2015 Copyright 2015 Micro Comm Inc Table of Contents Main Graphics Viewer IRURE 3 System Display kis koke ik ka tie kte apa A ede 4 System Display Station Hist a aleta 5 System Display Options 0 A RE RA re A ne e A A e nae eneee ee 5 Station Display amp GON M 6 Discrete TAPUS nenna an ka ki yi te a tek Ge e a O a ta e e tn a pp D a a tb a 8 Expansion INPUTS ieir na AAA ki CAN pe kak ee AR aaa ke aa kon 9 ma Testi 9 Flow Rate Total aUe 10 ROW RON KOW ATANN S oido ona IMEEM ao ke an Aa 10 Remote Station Comtalds nasse eret Dar eis eren ka e ka a a n np k n a pao pulse kk Ra RUM e A RD uo er ARES EE IRAE 11 Control Group S pPONMS 24e abako CERTE 12 Control SEtPONMS ERROREM 12 Alo ats 6 caren peer oer copie eer e no fa e e pea e ki en a a a re kn I S e E 12 PROS OU DTE 12 TIM Clock Controls A AA oon A E 13 Controlling Level Enable ia o A A AA kk arene 13 ao eaneaeaaecaas 14 he aeree Bn PEE 14 PAVE 11418 a 0 MUS LE E n e n e e e 14 Active Alarms WIN krie kou ante oi w ke etan kk cholic aaa 15 Event LoS E EE 16 m ogcH M 17 yer PERRA 17 Real Time Trend Grape coi n havea cus add kak kenn k id nes da ka kt a En a AA ka n ki da a don ie kn boii doce da 19 P rphsunmtme Reportar ccc IMMER a APA A See ke ee w 20 Daily Pump RE BOIS sales kte read
46. SCADAview CSX Station labels and other information given the input type number and label name Inputs types are Al DI El FR FT AO and HOA The label names correspond to the labels at the top of each station setup panel For instance the analog inputs would be Name Range Preset etc Station analog input low low setpoint given the address and input number Station analog input low low alarm bit given the address and input number Station Loss Of Signal bit 1 LOS given the address and input number Station analog input low alarm setpoint given the address and input number Station analog input low alarm bit given the address and input number Returns a 1 whenever the station data is less than 6 seconds old Station PC HOA position given the address and pump number O OFF 1 HAND 2 AUTO Station analog input falling rate alarm setpoint given the address and input number Station analog input falling rate alarm bit given the address and input number Station analog input rising rate alarm setpoint given the address and input number Station analog input rising rate alarm bit given the address and input number Station analog input rising 1 or 0 given the address and input number Returns a station address given the statio name Returns a station name given it s address Station System HOA position given the address and pump number O OFF 1 HAND 2 AUTO Station Data Time Stamp 12 hour clock formatted stri
47. Station 1 Suction Pressure Move Down m Pump Station 1 Flow Rate s Email Scheduling Duplicate Delete Statistics Stations 52 Control Groups 14 Graphic Screens 7 Edit Column Company Logo Up to 50 user defined Timed Reports can be updated at any given rate with live station data The stations and data points can be selected for up to 250 columns to be written to a comma separated file Microsoft Excel compatible If Monthly File is checked a new file will be started each month and the filename will end with MM YYYY month year This reporting option is defined by selecting Custom Timed Reports from the Setup menu in SCADAview CSX Studio SQL database servers can also be updated with this data if so desired Use Folders amp Database to set up the connection SCADAview CSX Micro Comm Inc Page 46 Report Email Scheduling X oegm crmeo 5 si Save Project Info Startup Database Security Stations Groups Graphics WebPage ScriptEditor SCADAdial PLC Report Email Scheduling Daily Reports Custom Daily Reports Custom Timed Reports Trends Graphics Diagnostics Email Server Q customer Information W Client Server Startup EB Folders amp Database Enable Email Frequency a Security System Selected Reports Email Recipients List 3 Stations Main Report Y Control Groups Pump Runtimes gt High Low Averages GB Graphic Screens VEPRE Web Page My Great
48. The unit of measure i e PSI GPM etc Station Display Name Pump Station 1 Levels High Low Rate Outputs Name Value TEST AOL 00 TEST AO2 0 0 TEST AO3 00 TEST AO4 0 0 AOS Setpoint 00 AO6 Setpoint 00 AO7 Setpoint 00 AOS Setpoint 00 Discretes Expansion HOAs Maintenance Remote Name SYS RTU Mode Status Pump 1 Auto Auto Cab n Pump 2 Auto Auto Standby Off Bypass Valve Standby Off LOW SUCTION POWER FAILURE ALARM Flow Rate Total Station Status Name Value Units Flow Rate 283 0 GPM Flow Total 10 234 000 GAL 24 hr Flow Total 24 000 GAL Status Station Data RTU CTU Data Quality Time Stamp Date SCADAview CSX Micro Comm Inc Page 7 Upper right panel Discretes This panel shows information related to discrete inputs at the remote station These inputs are used as status alarm inputs i e Pump Run pressure alarms etc In addition to viewing the status of the inputs controlled discrete outputs may be changed between Hand Off and Auto Discrete Inputs SYS System HOA status This is the final decision combination of all other HOAs in the system It will show either HAND OFF or AUTO for each controlled device RTU Remote monitored HOA status when used The remote station would be wired with an HOA whose status will be reported back to the CTU using the Expansion Inputs Mode The current mode of a controlled o
49. Totals Name li Range Trend Min Trend Max FR1 Flow Rate 0 1400 FT1 Flow Total 1000 Flow Rate and Flow Total Name This is the label used on all reports and displays to label the flow rate or total input Units Enter the unit of measure for this rate or total GPM GALLONS Range For flow rate enter the raw value multiplier raw x range full scale flow rate For flow total enter the increment value for the totalizer Usually either 100 or 1000 gallon increments Preset This pre sets or offsets the starting raw value for an analog input This allow scales that don t begin at zero Displayed values are computed raw preset x range Label Enter an abbreviation for this rate or total FR FT Trend Min Max Trend graphs will use this for the flow rate Y Axis scale which can also be changed on the graph SCADAview CSX Micro Comm Inc Page 32 Discretes General PLC Analog Ins HOAs Expansion Flow _ Analog Outs Setpoints Accumulators Discrete Inputs Name On Msg Off Msg Mode Label Pump 1 RUN OFF CRFHOA 4 P1X Pump 2 RUN OFF CRFHOA 2 Bypass Valve CRF Low Suction Al Power Failure Al Zi gisigisisigigis ariarjariar ah AH ar lah ar lah AH ah la a la ar Ahaha AH ah ah ar jar ar jar AH ah la AS jara N
50. ULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 8 2012 06 12 12 20 47 HO NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 9 2012 06 12 12 20 47 HP NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 10 2012 06 12 12 20 47 HQ NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NUL
51. a e e kek ti ta kn dB e ke kn EE R D D RAPO A D RD bk A A Da seth eke isk kk kan AA 68 Data EXpressi nS cota EA AA A A A A 73 Main Graphics Viewer The main SCADAview CSX display window normally provides a graphical overview of the system depending on how it was set up An example is shown below Bd T aji a m la a Alarm Ack System Stations Groups Alarms Trend RT rend Events Reports SCADAdisl Screen Distribution 1 Tower 1 Tower Level The toolbar at the top allows access to various standard text based displays and reports as well as navigation to other graphics screens The statusbar at the bottom shows who is currently logged in how many alarms are still active and whether or not the con nection is good to the server The example above also shows a toolbar button for the optional SCADAdial add on along with the status message showing that it is currently disabled Other graphic viewer windows may be open at the same time and placed on other monitors if desired Open a new graphic viewer by selecting New Window or New Floating Window from the Graphics menu These additional windows will re open automati cally when the program is launched and will remember their placement as all other standard windows do If windows can no longer be seen due to changing the placement or removing monitors select Gather Windows form the Window menu and they will all be pulled back to the primary dis
52. a station s data changes or continuously in a main script every second Scripts can optionally be set to only run on a SCADAview CSX server This may be necessary when a script is doing server related tasks such as custom data logging or e mail messaging Script Editor SCADAview CSX Studio provides a script editor sample shown below that functions much like any other text edit Syntax help for the currently selected function is shown at the bottom and a list of all available functions is on the right Clicking the Check button will compile the script being edited making sure all syntax is correct Y CSX Script Editor File Edit CSX Main Script New Delete Rename Y Server Only Script dim i as integer dim SDMsg as string SDMsg SCADAdialstatus 5 1 SDMSg S 2 DILastRun PH 1 2 S 3 DILastRun PH 2 2 some radio diagnostic numbers Y 7 RadioDiagvalue MR 7 Y 8 RadioDiagvalue MR 8 Y 9 RadioDiagvalue MR 9 sets some user defined global variables at startup if FirstPass then TestDoublei 123 Testinteger1 1234 TestBooleani true TestStringl Test Message end if if FirstPass and CsXserverMode then ShowMsgBox First Pass Test First Pass 0 0 end if ramp analog level up and down Tf AI HH 4 30000 then Y 1 4 end if if AI HH 4 10 then Y 1 4 end if Close Y 2 Y 2 Y 1 25 19 Not Compiled Variables and Constants All numeric and alphanumeric operators
53. achine is a Backup Server T Help Tips F Auto Update Setup from the Server checking Every Minute A PLC Central Code Default to using Local History for Trends Reports and Event Logs IV Store Trend Graph Pen Files On Server Reporting E 7 sync Script Global Variables with Server 77 custom Daily Report IV Use Data Change Requests T7 Custom Timed Report V Use Data Compression Email Scheduling E Misc Options Use Encrypted Communication Password Headless Server No Graphics Statistics c F Enable Modbus TCP Server Unit ID 0 Stations 49 Enable System Maintenance Schedule pan er Disable Graphics Pre Loading at Startup Graphic Screens 11 Client Mode Makes SCADAview connect to a remote machine SCADAview CSX Server at startup and act as a client Data Update Rate msec This is how often a SCADAview CSX client will request information from the server This should be set higher when using a slow network radio connection or the Internet Primary Server IP Address The IP address or hostname of the SCADAview CSX Server machine Secondary Server IP Address The IP address or hostname of another SCADAview CSX Server that will be used if the primary fails IP Port The IP port number to be used for client server communication as well as SCADAview NET protocol connections Disable Client Historical Logging Clients will not save any history files when this is checked Disable Client Server Alarm Ack Clients will not pass the alar
54. aily Reports Custom Timed Reports Graphics Diagnostics customer Information W Client Server Startup EZ Folders amp Database Security System smtp example com SCADAviewDemo scadaview com 3 Stations 3 Control Groups Wl Graphic Screens Q Wev Page V Use sst Number Formats M Colors 7 Help Tips Bl pic central Code SMTP Server Address From Address Username Password T7 Custom Daily Reports 77 Custom Timed Reports M Misc Options Statistics Stations 52 Control Groups 14 Graphic Screens 7 SCADAview CSX Micro Comm Inc Page 47 SQL Database Structure The following information describes the structure of the various tables and fields within those tables that are created when using the SQL database server logging options These examples are using the MySQL database server in conjuction with an open source web application called phpmyadmin to export the table information along with 10 rows of demo data Station Address PH 1 Minute Historical Data Table structure for table SVStatLogPH CREATE TABLE IF NOT EXISTS SVStatLogPH ID int 11 NOT NULL AUTO INCREMENT DT timestamp NOT NULL DEFAULT CURRENT TIMESTAMP ON UPDATE CURRENT TIMESTAMP AI1 double DEFAULT NULL AI2 double DEFAULT NULL AI3 double DEFAULT NULL AI4 double DEFAULT NULL AI5 double DEFAULT NULL AI6 double DEFAULT NULL AI7 double DEFAULT NULL AI8 double DEFAULT
55. ame The name for the discrete input This name is displayed on the station display and will also be used for graphics tagging On Msg Enter the label to be shown when the device is on or alarming Off Msg Enter the label to be shown when the device is off Mode Use the item list to select the available operating modes for the discrete input in question Valid operating modes are A1 Alarm when input is on AO Alarm when input is off 1 Status when input is on SO Status when input is off CRF Call Run Fail CRFHOA Call Run Fail Hand Off Auto remote HOA monitoring using expansion inputs Label This is the label shown on the System Display screen for this discrete input or controlled device and is also used for graphics tag ging For controlled devices enter an abbreviation ending in X Example P1X the last character will change to display the current status of the device R Run C Call F Fail O Off CG The control group associated with the pump input This is mainly for linking control groups with the Pump Control Panel window SCADAview CSX Micro Comm Inc Page 33 Expansion General PLC Analog Ins Discretes HOAs Flow Analog Outs Setpoints Accumulators Expansion Inputs Name On Msg Off Msg EN PUMP 1 HAND EI2 PUMP 1 AUTO PUMP 2 HAND El4 PUMP 2 AUTO El5 PUMP 3 HAND EI6 PUMP 3 AUTO EI7 DOOR OPEN EI8 OPER PRESENT EB
56. an extra table is created and updated every minute with all current station data The SCADAreport add on may need this for snapshot data Enable 1 Minute History Data Tables If this is checked all 1 minute history will also be logged to the SQL server Separate tables for each station will be created The SCADAreport add on may also need this data to generate reports Enable Daily Pump Report Tables If this is checked all station daily pump reports will be logged to the SQL server Separate tables for each station will be created Server Type The type of SQL server being used Currently the choices are MySQL MS SQL PostgreSQL Oracle and ODBC Host Name or IP Address This could be localhost if the SQL server is running on the local machine or may be a remote IP address Database Name This will need to be a valid database name that already exists on the server User Name and Password A valid login will be necessary to the SQL server This will need to be set ahead of time Port This will selected automatically based on the server but can also be changed to special ports if necessary Test Use this button to open a test connection to the selected server and database SCADAview CSX Micro Comm Inc Page 28 Station Setup SCADAview CSX File Edit Setup Window Help 4 GOOGBASTHMO Si Save Project Info Startup Database Security Stations Groups Graphics Web Page ScriptEditor SCADAdial PLC om Addr Name PLC Protocol PLC
57. are supported _ Mod lt gt lt gt gt Logical operators And Not Or Several forms of comments are supported and REM Data Types CSX Script supports the following data types Integer Single Double Boolean String Arrays can use any of these types Control Structures All the control structures specified in this Language Reference are supported This includes Function Sub For Next Do Loop If Then Else Elself End If Select Case End Select While Wend Return statement SCADAview CSX Micro Comm Inc Page 54 Standard BASIC Language Functions Abs Double As Double Returns the absolute value of the number specified Acos Double As Double Returns the arccosine of the value specified The arccosine is the angle whose cosine is value The returned angle is given in radians Asc String As Integer Returns as an Integer the ASCII value for the first character of a String Asin Double As Double Returns the arcsine of the value specified Atan Double As Double Returns the arctangent of the value specified The arctangent is the angle whose tangent is value Atan2 Double Double As Double Returns the arctangent of the point whose coordinates are x and y The arctangent is the angle from the x axis to a line drawn through the origin 0 0 and a point with coordinates x y Returns a Color based on the CMY cyan magenta yellow color model A Color i
58. ared Train 5 Pump 1 LOW FLOW Alarm Cleared Train 5 Pump 2 LOW FLOW Alarm Acknowledged Train 5 Pump 1 LOW FLOW Alarm Acknowledged No Pumps Available No Pumps Available Alarm Acknowledged Alarm Cleared Train 5 Pump 2 LOW FLOW Alarm No Pumps Available Alarm Train 5 Pump 1 LOW FLOW Alarm GE CAPACITY LIMIT GE CAPACITY LIMIT GE CAPACITY LIMIT Total CL2 LOW Total CL2 LOW Alarm Acknowledged LIMIT Cleared LIMIT Alarm Cleared Alarm Acknowledged Selecting Event Logs from the View menu shows the Event Logs window The Alarm log is stored in a monthly file By default ALL stations from the current year month and day are selected These options can then be changed to show any desired period of time The Filter option will find and display only the lines containing the given text This report also shows the number of events for the given time period and can be printed The types of event logs are as follows Alarm logs when alarms occur clear and when they are acknowledged by an operator Setpoint changes made by operators to any system setpoints such as HOAs Control Group setpoints etc System keeps track of startups setup change re loads and shutdowns etc Security log of all user security system logins logouts Dialer SCADAdial events if this option is installed SCADAview CSX Micro Comm Inc Page 16 Reports The following describes how to use the built in reporting option
59. as string x as Opens the Remote Setpoints window given the station address Use special integer y as integer x y coordinates of 0 0 to center this window in the main window ShowStation saddr as string Opens the Station Display window to the given station address ShowStationNotes saddr as string x as Opens the Station Notes window given then station address Use special x y integer y as integer coordinates of 0 0 to center this window in the main window ShowSystemDisplay display as integer Open the system display given the number 1 3 ShowTimedReport Opens the custom timed report window ShowTrend pens as string year as integer Show the built in trend window and load the given pen file month as integer day as integer ndays as integer shour as double ehour as double The pens parameter can also be a comma separated string formatted StationName PenName yMin yMax for each pen Other optional parameters include the start ing date number of days and x axis start and end hours ShowRTrend penfile as string Show the built in real time trend window and load the optional pen file ShowSTrend Show the built in single pen trend window ShowHTML fname as string Show the built in HTML Viewer and open the given file name ing ing ShowURL urlstring as string Show the built in HTML Viewer and move the given URL i e http www micro comm inc com ShowWindow windowname as string Shows a SCADAview CSX window given th
60. atabase Duplicate Adds a new station with it s setup the same as the selected station Delete Deletes the selected station or stations Move Up Down Changes the order in which the stations appear in SCADAview CSX menu lists and system displays Change IP Will allow changes to multiple selected station s IP address and protocol selection Save Project Use this toolbar button to save any changes made SCADAview CSX Micro Comm Inc Page 29 General General PLC Analog Ins Discretes HOAs Expansion Flow Analog Outs Setpoints Accumulators Address Name PH Pump Station 1 Data Source SV PLC Server m 7 Local Expanded Data E Remote Flow Rate and Total 7 Remote PC HOAs polled on demand E Enable Radio Diagnostics Polling Data Expression Data Change Script None Edit Script Address The two letter code HH WW assigned by Micro Comm for the station when setting up a new system Name Enter a name for this station This name will be displayed on all screens and reports dealing with this station Data Source The data for the station will be acquired from the selected source which can be either SV PLC Server or None Data Entry SV PLC communicates with various PLC types The None Data Entry selection can be used for special purposes such as data consolation or manually entered lab data that needs to be logged analog input values ca
61. base Security Stations Groups Graphics WebPage Script Editor SCADAdial PLC Web Page Setup Customer Information 69 Client Server Startup Web Folder ES Folders amp Database C wamp www a Security System Stations 7 Trends and Reports E Remote Station Setpoints 4 Enable Web Page CSX Server IP 127 0 0 1 g Control Groups E Allow Control Setpoints and HOAs _ Analog Outputs lll Graphic Screens _ Group Time Clock Level Enables Security Login Home Page Web Page Alarm Horn Sound Refresh Rate sec 120 Number Formats Global Alarm Acknowledge a Colors iV Advanced Browser Features 7 Help Tips T Web Page Security if no local security System Displays tr a PLC Central Code Station and Control Group Notes _ Enable Alternate System Control Station Display Event Log Color Scheme Reporting Remote Virtual HOAs 77 custom Daily Reports 77 custom Timed Reports Email Scheduling M Misc Options Page Timeout sec 85 Server Time Zone America Chicago GMT 06 00 Central Time USA Canada Y Enable Graphic Screens JPEG Quality Statistics Graphics Scaling 75 Smoothing Stations 52 Control Groups 14 s Na Sti Graphic Screens 17 pasan e hie PLC Tag Count 1960 Bibi Mop Moune ndo V Distribution 1 Normal Window 7 Distribution 2 Normal Window Selected Screens 4 An optional add on to SCADAview CSX ca
62. colon at the end can specify an optional connection multiple connections to a a single PLC address 192 168 10 117 8 use a comma at the end to specify the slot for a ControlLogix processor card default is zero 192 168 3 194 DHPx use DHPx at the end for a DH Gateway where x is the DH node ID in decimal 192 168 3 194 4002 specifies the port number instead of using the default port for the protocol COM1 9600 N 8 1 serial port baud rate parity databits stopbits SV PLC Server Referencing PLC Data DF1 References DF1 SLC or CLX Protocols SLC style DF1 locations are referenced by File Type File Offset and optional Bit Integer Bit Timer Counter and Float file types are supported Timers and counters with field references are supported for certain locations analog inputs analog outputs or control group stop starts Input and Output module files are supported as well as the status file SLC Examples N7 0 N7 0 1 B3 0 15 F8 20 T4 0 ACC T4 0 13 C5 0 PRE S2 4 1 0 1 0 1 0 CIP Data Table References CLX Protocol Arrays are referenced by the data type followed by the array name or UDT enclosed in parentheses The array element number follows a and the optional bit reference follows a Integer Double Integer Float Small Integer and Boolean array types are supported dtN dtD dtF dtS and dtB Note Bool arrays are referenced using the 16bit word bit instead of the actual element number
63. e name i e ShowWindow Active Alarms Sleep msec as integer Pauses processing the script for a given number of milliseconds Use this in long loops or continuously running scripts to give up processor time to other threads SpeakText msg as string Uses Mac OS X or Windows built in speech engine to speak the given text message SlideshowStart Starts slideshow mode on the main graphics window SlideshowEnd Ends slideshow mode on the main graphics window SlideshowSpeed nsecs as double Sets the slideshow speed delay between screens to the given number of seconds SCADAview CSX Micro Comm Inc Page 65 SOAPInitialize sck as integer wsdIURL as Sets up a SOAP connection given a socket connection and string param String actionURL as string methodURL as eters for the WSDL document Web Services Description Language the string action and the method URLs SOAPParameterBoolean sck as integer Set the given parameter name to a given boolean value paramName as String paramValue as boolean SOAPParameterinteger sck as integer Set the given parameter name to a given integer value paramName as String paramValue as integer SOAPParameterDouble sck as integer Set the given parameter name to a given floating point value paramName as String paramValue as double SOAPParameterString sck as integer Set the given parameter name to a given string value paramName as String paramValue as string SOAPRequest sck as integer o
64. enfiles Reports High Low Setpoints Hand Off Auto Control Groups Active Alarms Event Log Acknowledge Security Not Logged in User Rich Pass sss Login Logout 00 0 20 21 22 23 0 Date 04 04 2013 High 89 8 Low 60 0 Avg 74 967 SCADAview CSX Micro Comm Inc Page 44 Custom Daily Reports File Edit Setup Window Help alo rio s Save Project Stations Groups Graphics WebPage Script Editor SCADAdial Custom Daily Reports Select Report Q Customer Information Custom Daily Report M Add Delete D Client Server Startup FI Folders amp Database Report Name Report Title a Security System Custom Daily Report GF Stations CSV Filename Log Time b Control Groups Custom Report csv 00 00 Hide Station Names Bl Graphic Screens 9 Web Page Station Name Report Data Number Formats vj Valve Open Runtime R1 a Colors Station Name Report Data Help Tips Pump Station 1 Pump 1 Runtime Move Up B Pic central Code Pump Station 1 Pump 2 Runtime A Pump Station 1 Flow Total 24hr Move Down Reporting High Service Pumps Pump 1 Runtime High Service Pumps Pump 2 Runtime m ly R Duplicate EF Custom Timed Report Email Scheduling M Misc Options Delete Edit Column Statistics Stations 26 Control Groups 4 Graphic Screens 15 Company Logo This reporting option is defined by selecting Custom Daily Report from the Setup menu
65. er Returns the name of the PLC or ip address if not named for the requested plc numbers starting with 1 as listed in the SV PLC diagnostics screen PlayAlarmSound num as integer Plays the given alarm horn sound number 1 Main 2 Pump Fail 3 LOS 4 Levels 5 Status PlaySoundFile fname as string Plays the given sound file name The sound file needs to be in the Alarm Sounds folder located in SCADAview CSX programs folder Print msg as string Prints a line of text to the script console normally used for debugging pur poses PrintScreen Prints the current main graphics viewer window RadioDiagReportHTML as string Returns an HTML source string containing a report for all the CTUS2 stations that were selected to collect radio diagnostics RadioDiagValue saddr as string param as Returns a CTU32 radio diagnostic value given the station address and the integer as double requested parameter 1 port 2 type 3 timeout 4 antenna 5 MR 6 MW 7 Dones 8 Fails 9 Percent Done ReportWriteCSV repname as string Appends a given comma separated line of text as well as the current date headcsv as string datacsv as string and time to the given report name The headcsv will be written to the first line if the file does not yet exist Reports are stored in the history folder s ScriptReports folder Example ReportWriteCSV Test Report Tank LevellFEET Discharge PressurelPSI Suction PressurelPSI format AI TH 1 0 0 format Al
66. erver Auto Logout Time 0 Minutes Local Auto Logout Time 0 Minutes FB Folders amp Database V Prevent users from acknowledging alarms for Stations not under their control custom access Ra e at ae V Prevent SCADAview NET protocol from relaying user logins Stations 3 Control Groups MA Graphic Screens Select User web Page 1 Rich Number Formats M Colors User Name Local Security Level Remote Security Level v Login window saves the previous user name 7 Help Tips Rich Administrator Administrator W Pic Central Code Password Supenisor C Supervisor are Operator Operator Reporting Op D Op Ef custom Daily Reports Confirm Password None disabled None disabled M Custom Timed Reports peered Email Scheduling Misc Options A bete Use Statistics Stations 52 Control Groups 14 Graphic Screens 17 PLC Tag Count 1960 Select User Use this pull down list to select the user to edit Add New User Click this button to add a new user to the end of the database Delete User Deletes the currently selected user Note The user will not be deleted until the Save button is clicked Save Project This toolbar button will save the entire user s database You should click this when you are finished making changes Global Security System Options Enable Security System When this option is checked all security features will be enabled for SCADAview CSX Al
67. est test was successful Testing is done every testperiod ger timeout as integer as integer and will fail if no connection is established within the timeout The testperiod and timeout parameters are in seconds TCPDisconnect sck as integer Closes the specified TCP IP Socket connection if connected TCPIsConnected sck as integer as boolean Returns whether or not the socket connection has been successful It may take a while for connections to be established so this function should be used to test a connection before sending data TCPRead sck as integer as String Reads all incoming data from a socket connection if connected TCPWrite sck as integer senddata as Sends the given data string out the socket connection if connected string SCADAview CSX Micro Comm Inc Page 66 Time param as integer as integer Returns the current date or time value given the param 1 DayOfWeek 2 Month 3 Day 4 Year 5 Hour 6 Minute 7 Second TSEC index as integer as integer Timer variables in seconds which count down to zero Index can be 0 100 SCADAview CSX Global Array Variables Note Values will be retained in memory after a script is run but will not be saved whenever SCADAview CSX shuts down Use file functions to load save any variables that need to survive startup shutdown These variables can also be synchronized with the CSX server when running on a client This option is selected in the Client Server Startup page in CSX Stud
68. event log and expanded output status when available for the controlled device Hand Off Auto Controls Read All Option If no pumps are selected all HOA s can be read and displayed with dropdown selectors HOA Selectors User selection for the mode of each controlled device HAND turns the device ON OFF turns the device OFF AUTO lets the system control the device based on stop start setpoints Note Other selection options may be available i e OPEN CLOSE ON OFF etc SCADAview CSX Micro Comm Inc Page 8 Station Display E Name Pump Station 1 Addr PH X Levels High Low Rate Outputs Discretes Expansion HOAs Maintenance Remote Name Value Units Status Name Status Discharge Pressure 80 0 PSI PUMP 1 HAND Suction Pressure 40 0 PSI PUMP 1 AUTO PUMP 2 HAND PUMP 2 AUTO PUMP 3 HAND Temperature 75 0 DEG PUMP 3 AUTO DOOR OPEN OPER PRESENT Flow Rate Total Station Status Name Value Units Status Station Data Status Flow Rate 283 0 GPM RTU Normal Flow Total 10 234 000 GAL CTU Normal 24 hr Flow Total 24 000 GAL Data Quality Valid Time Stamp 6 37 32a Expansion Inputs Expansion inputs are additional discrete inputs usually located on an external input module at the RTU The name and the input status are displayed for each device On Off labels are displayed for the status if they have been entered otherw
69. f the control group is shown and selected here The control group can also be selected by Control Setpoints Normal control groups have up to eight sets of stop start setpoints on this screen the eight are shown down the left hand side of the window The stop start setpoints are values entered by the operator to determine at what value the corresponding controlled device will either stop or start Alternator Use the mouse to select the alternator sequence for the control group The alternator determines the mode of operation for the controlled devices The choices are Forward Device one is always first Reverse Last device is always first Auto Alternation sequence beginning with the first device and continuing through all available devices All Same as Auto Reset If a device fails the system automatically chooses the next device available in auto mode to control The system will not try the failed device again until the operator resets the failed device s by clicking on this button SCADAview CSX Micro Comm Inc Page 12 Time Clock Controls Pre Fill Enter the pre fill rate feet per hour at which the tank fills when the pump is running It will be used to determine when the controlled device will come on prior to the time that inhibit is activated This will allow the system to top off the tank using the lead control level setpoint prior to inhibiting the control group The pre fill value is used whenever Time Inhibit Restore o
70. h Low High User setpoint for the high level alarm Low User setpoint for the low level alarm DBand Deadband for both the high and low level setting level will have to fall rise by this much before an alarm will clear Rate Rise Rising rate of change alarm setpoint Fall Falling rate of change alarm setpoint Note The rate alarm setpoints are entered in units per 2 minute change interval Alarm will generated if the level changes by more that this amount in 2 minutes SCADAview CSX Micro Comm Inc Page 6 Name Pump Station 1 Levels High Low Rate Outputs Name Discharge Pressure Suction Pressure PISS TIME 0 Test Pulse Rate BOX TEMPERATURE Restarts Runtime msec AD Level AND Level E o A a m 4 oooocoocooo o m o Im oI o 9 is occocococcocon7 Name sys RTU Mode Status Pump 1 Auto cn RUNEEN A Pump 2 Monitor Standby Off T Pump 3 off Disabled Off L Off 1 Bypass Valve Off Call LOW SUCTION POWER FAILURE Pump 7 Pump 8 CV FAIL1 CV FAIL 2 Flow Rate Total High Low Flow Setup Station Status Name Value Flow Rate 648 0 Flow Total 62 211 419 000 24 hr Flow Total 29 757 000 Flow Rate 2 1 095 0 Flow Total 2 2 200 665 000 Station Data RTU CTU Data Quality Time Stamp Outputs Value User setpoint for an output value sent to the remote target setpoints speed etc Units
71. hat options are displayed in the drop down list HAND OFF AUTO START STOP ON OFF etc SCADAview CSX Micro Comm Inc Page 36 Accumulators General PLC Analog Ins Discretes HOAs _ Expansion Flow Analog Outs Setpoin Remote Accumulators Name MO Runtime 1 M1 Runtime 2 M2 Runtime 3 M3 Cycles 1 M4 Cycles 2 MS5 Cycles 3 M6 M7 Accumulator Data Source Collect Accumulators at Midnight V Auto Adjust Maintenance Runtimes Cycles with Accumulators Micro Comm remote RTU variables X17 X24 MO M7 M8 M15 or M16 M23 can be labeled scaled and treated as accumulators runtimes cycle counters flow totals etc These variables are then read and sent on demand from SCADAview CSX just like the Remote Setpoints or Remote HOAs A special option is also available to automatically read and save these accumulators at midnight for use with the Accumulator Report Another option allows the accumulators to automatically adjust the maintenance runtimes After they are read at midnight any of the accumulators that have runtime in their name will set the corresponding maintenance runtime equal to the remote value SCADAview CSX Micro Comm Inc Page 37 Control Group Setup Group Pump Station 1 General PLC Normal Group Custom Group Screen Disable Help Group Name 1 Pump Station 1 Data So
72. iew CSX Demo System Pump Station 1 Analog Report for January 1 2010 12 00am to January 31 2010 11 59pm Analog Input Label Units High Low Average NZAwp OO Difference 1 Discharge Pressure PSI 1250 00 81 149 82 196 125 0 2 Suction Pressure PSI 63 0 30 0 49 496 49 496 33 0 3 0 0 00 0 0 0 0 0 0 00 oo 00 00 00 0 0 00 00 00 00 DEG 185 78 5 185 00 00 0 0 00 00 00 0 0 Lvs 0 0 00 00 00 00 Report Generated Monday March 18 2013 6 14 58 AM This report will compute and display the minimum maximum average non zero average and difference all analog inputs in a station for a selected period of time The user selects the station name start date end date starting and ending hour This report is based on the 1 minute historical files SCADAview CSX Micro Comm Inc Page 21 Daily Pump Reports Daily Pump Reports Analog Report Pump Runtime Report Custom Daily Reports Custom Timed Reports Station Name Start Date End Date ump Station 1 112010 Gr 34200 G e SCADAview CSX Demo System Pump Station 1 Daily Pump Report for January 1 2010 to January 31 2010 01 01 2010 201 ai e 01022010 440 410 ooo ooo ooo ooo ooo 000 198 000 00 35152 01 03 2010 soo 470 0 00 000 000 ooof 000 000 212 000 00 324 53 01 04 2010 390 6 00 ooo 0 00 o00 ooo ooo 0 00 206 000 00 313 89 01 05 2010 10 320 000 ooo 000 000 000 0 00
73. in SCADAview CSX Studio Up to 50 user defined Daily Reports can be updated every midnight or at a custom Log Time with 24 hour summary data columns The stations and data points can be selected for up to 250 columns to be written to a comma separated file Microsoft Excel compat ible The first column in the report will always be the date in the format MM DD YYYY SQL database servers can also be updated with this data if so desired Use Folders amp Database to set up the connection Supported servers include ODBC Microsoft SQL PostgreSQL and MySQL SCADAview CSX Micro Comm Inc Page 45 Custom Timed Reports File Edit Setup Window Help 1I1GOOBA crmo B Save Project Info Startup Database Security Stations Groups Graphics Web Page ScriptEditor SCADAdial PLC Custom Timed Reports Select Report Custom Timed Report y Ada Delete o Customer Information Client Server Startup ES Folders amp Database Report Name Report Title a Security System Custom Timed Report Test Report Title j Stations PI Control Groups Update Frequency 15 Minutes MA Graphic Screens 0 Web Page Number Formats M Color 7 Help Tips B Pic central Code Filename Custom Timed Report csv Monthly File Station Name Report Data Tower 1 y Tower Level Station Name Report Data Reporting Tower 1 Tower Level Move Up m A Pump Station 1 Discharge Pressure Custom Daily Reports Pump
74. io B index as integer as boolean Global boolean variable array B 0 through B 500 i M uloc as integer as integer User memory variables integers stored in user memory tags on Micro Comm CTU32 protocol PLCs The uloc range is 0 999 Note When no CTU32 PLC is available these will only be stored in memory S index as integer as string Global string variable array S 0 through S 500 X index as integer as integer Global integer variable array X 0 through X 500 Y index as integer as double Global double variable array Y 0 through Y 500 User Defined Global Variables Variables may also be defined using the Global Vars button on the script editor These can be saved loaded automatically by using the Retentive checkbox Script Global Variables Name Description Type Retentive Log Units TrendMin TrendMax TestDoublel Double v Testintegerl Integer v TestBooleani Boolean TestStringi String Visibility Integer ReportYear Integer ReportMonth Integer Vv v False m This is a T 0 0 0 C3 EI S S S S S Dn Duplicate SCADAview CSX Micro Comm Inc Page 67 PLC Data References SV PLC Server PLC Connections Ethernet or Serial Accessed using the PLC tab in station or group setup the connection can be either an ethernet IP address hostname or a Serial port setting string PLC Connection Examples 192 168 3 194 simple IP address 192 168 3 194 1 a semi
75. ion is RTU32 or later and the flow total value is being computed out at the remote this will allow the flow total value to be changed Note The totalizer is usually displayed in 1000 gallon increments Station Display Levels High Low Rate Outputs Discretes Expansion HOAs _ Maintenance Remote Name Value Units Status Discharge Pressure 70 0 PSI Poll Now Suction Pressure 50 0 PSI Real Time Clock Accumulators Totalizer Temperature 75 0 DEG Flow Rate Total High Low Station Status Name Pump Station 1 v Addr PH Name Value Units Status Station Data Status Flow Rate 0 0 GPM RTU Normal Flow Total 10 234 000 GAL cru Normal 24 hr Flow Total 24 000 GAL Data Quality Valid Time Stamp 6 03 04a Date 3 18 2013 Station Status The Lower Right panel will show all other status information related to the station RTU The current status of the remote Normal Override or LOS Override means that a CTU has placed the remote in Override mode LOS means that the station has stopped responding This also is displayed in the Data Status CTU The current status of the central Normal Monitor or Override Monitor means that this CTU does not control the remote Override means this CTU has taken over control of the remote from the other CTU Data Quality The status of all the displayed data from the remote Valid means that the da
76. ise the input label is displayed whenever the input is on Station Display Name Pump Station 1 Levels High Low Rate Outputs Discretes Expansion HOAs Maintenance Remote Name Value Units Status Name Hours Alarm Cycles Alarm Date Discharge Pressure 70 0 PSI RISE Pump 1 256 500 0 0 3 31 2013 Suction Pressure 50 0 PSI RISE Pump 2 30 1 500 0 0 3 31 2013 High Discharge 0 0 0 0 0 Bypass Valve 0 0 0 0 0 0 0 0 0 Low Suction 0 0 0 0 Temperature 750 DEG Power Fail 0 0 0 0 Entry Alarm 0 0 0 0 Station Flood 0 0 0 0 Flow Rate Total Station Status Name Value Units Status Station Data Status Flow Rate 0 0 GPM RTU Normal Flow Total 10 234 000 GAL RISE CTU Normal 24 hr Flow Total 24000 GAL RISE Data Quality Valid Time Stamp 5 59 09a Date 3 18 2013 Pump Maintenance The current number of runtime hours and pump cycles can be entered here for each discrete input along with alarm setpoints The runtime will automatically increment in tenths of hours whenever the discrete input is ON and the cycle count will increment whenever the discrete input goes from off to on When the runtime or cycles reaches the setpoint a Runtime Alarm or Cycle Counter Alarm is generated A Next Service Date alarm can also be selected for each controlled device by double clicking in the Date column SCADAview CSX Micro Comm Inc Page 9
77. it integer If however a Range of 1 and a Preset of 0 is used for a floating point reference the value will be passed as is to SCADAview CSX without being un scaled first In this case when the floating point reference needs to be scaled a PLC expression should be used Examples Range 1 and Preset 0 values can be any floating point number Range 0 1 and Preset 32768 values can be 3276 8 to 3276 7 Range 0 1 and Preset 0 values possible are 0 to 6553 5 Range 0 01 and Preset 0 values possible are 0 to 655 35 PLC Expressions Expressions using PLC references can also be used for station data not for group data PLC data references inside the expressions are enclosed in square brackets Note Expressions for analogs will result in a scaled value that is then converted back to raw values for SCADview CSX This means you will need to scale the PLC raw values within the expression Expression Operators and Functions SCADAview CSX Micro Comm Inc Page 69 returns a time or date value depending on the x parameter 1 day of week 1 SUN 2 Month 1 12 3 Day 1 31 4 Year 5 Hours 0 23 6 Min 0 59 7 Sec 0 59 i FTC value secs Fail to change will return a 1 whenever the given value has not changed in the given number of secs The can be 1 64 DF1 Examples N7 0 0 1 N7 1 0 1 N7 0 N7 1 N7 2 30 B3 0 0 I B3 0 1 B3 0 0 amp B3 0 1 SIN F8 0 COS F8 1 FTC 1 N7 0 10 CIP
78. ke any setpoint or HOA changes Note When logged off users can only view displays view setpoints and HOAs and run reports Local vs Remote Security Level The local security level will be used whenever a user logs in on at the SCADAview CSX machine The remote security level gets used when logging in over the web page or remotely using TCP IP client server or SCADAview NET data connections Custom Access Select All Select All Control Groups Graphic Screens Pump Station 1 High Service Pumps Raw Water Pumps New Group 4 SLC 5 05 Group Remote Group 6 ulynx Group 7 Custom CLX Group Pump Station 1 Valve C Wells 11 12 13 SLC System Map Distribution 1 Distribution 2 Distribution 3 Water Plant 1 Water Plant 2 Waste Water System Lift Stations Plant Security Embedded Menu V Pump Station 1 Y Lowercase ph V Raw Water Pumps ISI E S S S S SI S S S ISI S S S S S S S SI S V uLynx Station UJ E Prevent user from logging into the Web Page menn The custom access option can be used block the user from making control changes on any station group or graphic screen It can also be used to keep the user from logging in on the web page SCADAview CSX Micro Comm Inc Page 42 Web Page Option File Edit Setup Window Help ib 1 2 008 o rY m Q P Save Project Info Startup Data
79. lean SetXXBIT bnum as integer bval as integer ShellExec cmastr as string ShowControlGroup cg as integer more as boolean x as integer y as integer ShowControlGroups cg as integer ShowCustomReport repnum as integer ShowDailyPumpReport saddr as string ShowHighLows saddr as string x as inte ger y as integer ShowHOA saddr as string hoa as integer x as integer y as integer ShowHOAs saddr as string x as integer y as integer ShowAlertBox title as string msg as string flash as boolean x as integer y as integer ShowMsgBox title as string msg as string x as integer y as integer SCADAview CSX Returns the local level of the current user O none 9 Operator 99 Supervi sor 999 Admin Returns the name of the current user Returns the index number of the current user Sends an email message given the email address subject and text The server used must be set up with SCADAview CSX Studio Reports Email Scheduling options The message should be plain text Sends an email message given the email address subject message and file name for attachment The server used must be set up with SCADAview CSX Studio Reports Email Scheduling options The text message is encoded as plain text and the attached file must be found in the Script Output folder Sends an email message given the email address subject and html source text The server used must be set up with SCADAview CSX Studio Reports Email Scheduli
80. lt to DI1 DI16 and the expansion module inputs will default to El1 El32 Controlled outputs such as pumps will be set up as Call Run Fail so that a label will be changed based on the pump s status i e P1R for pump 1 Run P1C for pump 1 Call and P1F for pump 1 Fail Status inputs will show their label whenever they are on along with the status color as the background SCADAview CSX Micro Comm Inc Page 4 System Display Station List By clicking the right mouse button on the system display the following options can be selected depending of the option clicked on Right Click and select Station List A selection window showing all the stations in the system will be displayed Click on the checkbox next to the station name to show or hide a particular station Close the setup screen when finished Tower 1 Pump Station 1 GROUND STORAGE HIGH SERVICE PUMPS RAW WATER PUMPS LIFT STATION SLC 5 05 PLC Modbus PLC M555 1 196 ulynx Station UJ ulynx Station MR Equation Station System Display Options Right Click and select Display Options A selection window showing the display labels and checkbox for each data column is shown Changes can be made to the system display name column labels text styles and highlight color Click on the checkbox to show or hide a particular column of data Col umns can also be re ordered by clicking on Move Up or Move Down Click Save to sa
81. m acknowledgements to the server when this is checked The server machine will need to be acknowl edged locally This Machine is a Backup Server When checked this machine will become a backup server if necessary The SV PLC data server will be launched in order to become a SCADAview CSX Server in case the primary and secondary servers fail The primary server will then be tested periodi cally and this machine will become a client again when the primary server is back on line Auto Update Setup File from the Server SCADAview CSX Micro Comm Inc Page 26 Whenever a change is made to the setup on the server this option trigger the client to re download all the current setup Default to using Local History for Trends Reports and Event Logs Forces a SCADAview CSX Client machine to use local data instead of requesting data from the server Store Trend Graph Pen Files On Server If checked the save and open dialog boxes will be replaced with a selector that will save or load pen files on the server Pen files are also saved locally Sync Script Global Variables with Server When checked CSX Script variables will be passed from server to client and sent back to the server when changed on a client Normally this is not done and all variables will be local to the SCADAview CSX Use Data Change Requests When checked CSX clients will use special data requests for only the station or group data that has changed since the last request This can be
82. n be entered Local Expanded Data This is used for stations located in the PLC that have been set up to support expanded data Additional analog inputs outputs and flow information can then be gathered for this station Remote Flow Rate and Total When using distributed control the station s flow information will be polled for and the flow total will be remotely changeable Remote PC HOAs When this is checked and used with CTU32 protocol RTUs the Hand Off Auto controsl will be out at the remote and are accessed on demand read send buttons added to the HOA screens Enable Radio Diagnostics Polling This allows CSX script to access the latest radio diagnostic counters for use in graphical diagnostic screens or alarm generation Data Expression Expressions may be used that will take station data values and place results in other station data locations See Data Expressions section later in this manual for more information Data Change Script If selected the CSX script will be run any time data changes for this station Use the Edit Script button to make changes to this script or create a new one SCADAview CSX Micro Comm Inc Page 30 Analog Ins General Pec Analog Ins Discretes HOAs Expansion Flow Analog Outs Setpoints Accumulators Analog Inputs Name i Range Discharge Pressure 0 1 Suction Pressure 0 1 1 ecojojojo ojo oj o ahah ah lah ar jar ar jar
83. n be used to generate Web page versions of the System Display screen Station Display Screens selected Graphics screens High Low Alarms and Control Group setpoints Hand Off Auto controls Reports and Trend graphs and more Current system data and alarms can then be viewed over the Internet using any Web browser such as Internet Explorer Google Chrome Firefox Opera Safari etc Choose Web Page from the Setup menu in the SCADAview CSX Studio and check the various options desired Note A web server application and PHP installation is required for the web page option to work The Web Folder is a full pathname of the Web server s home page folder where all php files will be copied Some sample web pages are shown below SCADAview CSX Micro Comm Demo System Olathe KS MICRCCOMM All Stations System Display Station Display System Map Graphic Screens System Map D CCEE Trend Graph Trend w Penfiles Reports High Low Setpoints Hand Off Auto Control Groups Active Alarms Event Log Acknowledge curity Not Logged in veer Rich Pass ee Login Logout SCADAview CSX Micro Comm Inc Page 43 SCADAview CSX Micro Comm Demo System Olathe KS MICRCCOMM All Stations LONE ron High Service Pumps HS Pret Dopo 4B CNT Station Display Discharge Pressure 72 0 Pump 8 OFF STBY Graphic Screens Surge Tank Level 54 0 INCH Pump 9 OFF STBY OFF Pump 8 Speed 76 8
84. ng Returns the data age in seconds for the given station address Returns the Time Stamp Hours given the station address Returns the Time Stamp Minutes given the station address Returns the Time Stamp Seconds given the station address Station Valid Data Signal bit 1 Valid given the address and input number Micro Comm Inc Page 60 SCADAview CSX Miscellaneous Functions cancel long loops or continuously running scripts BitSet wval as double bnum as integer bval as integer BitTest wval as double bnum as integer as Tests a bit number in the given word and returns the result integer BoolTolnt bval as boolean as integer Returns an integer 0 or 1 based on whether the given boolean value is false or true CSXBackupServer as boolean Returns True if SCADAview CSX is set to run or is currently running as a backup server CSXClientMode as boolean Returns True if SCADAview CSX is currently running as a client CSXServerMode as boolean Returns True if SCADAview CSX is currently running as a server CurrentDate fmt as integer as string Returns today s date string given the desired format 1 ShortDate 2 Long Date 3 SQLDate format YYYY MM DD Given no fmt parameter it will return the ShortDate CurrentTime fmt as integer as string Returns the current time string given the desired format 1 ShortTime 2 LongTime 3 SQLTime HH MM SS Given no fmt parameter it will return the ShortTime CurrentTimeZoneOffset as st
85. ng options The text message can be plain text or HTML Source css styles will be fixed for proper display in email client applications Downloads the requested setup file or all setup files from the SCADAview CSX server Example SetupFileDownload CSX Stations svxml false Uploads the requested setup file or all setup files to the SCADAview CSX server Example SetupFileUpload CSX Stations svxml false Sets or clears a bit in the CTU32 XXbyte utility byte given a bit number and value This shows up at PMEM 110 in a Micro Comm PLC Executes the given command line DOS or Unix commands Opens a single control group window given the group number and x y loca tion Use special x y coordinates of 0 0 to center this window in the main window If the more parameter is true then access to the time clock con trols and level enables will be available Opens the main control groups window given the group number Opens the custom daily report window given the report number to show Opens the daily pump report window given the station address to show Opens the High Low Alarms setpoint entry window given the station address and x y location Use special x y coordinates of 0 0 to center this window in the main window Opens the Single HOA Graphic window given the station address and hoa number and x y location Use special x y coordinates of 0 0 to center this window in the main window Opens the All HOAs window given the station address
86. nk levels THAI1 THAI2 2 averages the first 2 analog inputs at TH G010SP3 gt 120 discrete expression for group 10 1 if stop setpoint is above 120 FIF THAI1 gt 100 1 0 discrete expression returns a 1 if station TH analog input is greater than 100 SCADAview CSX Micro Comm Inc Page 74
87. nteger As String Returns as a String the hexadecimal version of the number passed HSV Returns a Color object based on the HSV hue saturation value color model If Then Else Conditionally executes a group of statements depending on the value of a boolean expression InStr Integer String String As Integer Returns the position of the first occurrence of a string inside another string The first character is numbered 1 IsA operator Used to determine the class of a particular object reference Left String Integer As String Returns the first n characters in a source string Len String As Integer Returns the number of characters in the specified string Log Double As Double Returns the natural logarithm of the value specified Lowercase String As String Converts the given string to all lowercase characters LTrim String As String Returns the string passed with leading left side whitespaces removed Max Double Double As Double Returns the largest value passed to it Microseconds As Double Returns the number of microseconds 1 000 000th of a second that have passed since the user s computer was started Mid String Integer Integer As String Returns a portion of a string The first character is numbered 1 Min Double Double As Double Returns the smallest of the numbers passed Nil Used to determine if an object is nil no value NthField String String Integer As String Returns a field from a row of data The first field is
88. of the value specified Returns the square root of the value specified Returns the string form of the value passed Makes a binary case sensitive or text lexicographic comparison of the two strings passed and returns the result Declares the name parameters and code that form the body of a subrou tine method Returns the tangent of the angle specified Returns the number of ticks 60th of a second that have passed since the user s computer was started Returns the string passed to it with all alphabetic characters in Titlecase Returns the string passed with leading and trailing whitespaces removed sed to set a Boolean object to the value of True or test whether an existing Boolean expression is equal to True Returns the index of the last element in an array Arrays are zero based Element zero may or may not be used Converts the given string to all uppercase characters Returns the numeric form of a string Repeatedly executes a series of statements while a specified condition is True SCADAview CSX Station and Group Data Functions Al sadar as string ai as integer as double Station analog input value given the address and input number AO saddr as string ao as integer as double Station analog output value given the address and output number CGAENABLE cg as integer ae as integer as integer CGALT cg as integer as integer CGPREFILL cg as integer as double CGRESET cg as integer as integer
89. ote stations on demand They could be used at the remote to control outputs when in backup control or for any other purpose These setpoints respresent the variables STOP1 START1 through STOP12 START12 in a Micro Comm RTU Stop Label Label used to describe the stop setpoint i e Pump 1 Stop Start Label Label used to describe the start setpoint i e Pump 1 Start Units Enter the unit of measure for this setpoint FEET PSI GPM etc Range The range is the multiplier that is used on the raw value from the PLC Example If the PLC analog value of 0 4095 is to be displayed as 240 ft the range would be 0 0586 4095 x Range Full Scale of Measured Displayed Value Preset This pre sets or offsets the starting raw value This allow scales that don t begin at zero Displayed values are computed as follows raw preset x range SCADAview CSX Micro Comm Inc Page 35 HOAs General PLC Analog Ins Discretes HOAS Expansion Flow Analog Outs Setpoints Accumulators Hand Off Auto Controls Virtual Hand Off Auto Controls Name Selector Type Name Selector Type Pump 1 Hand Off Auto x9 Hand Off Auto Pump 2 Hand Off Auto Hand Off Auto Pump 3 Hand Off Auto Hand Off Auto Bypass Valve Open Close Auto Hand Off Auto Hand Off Auto Hand Off Auto Hand Off Auto Hand Off Auto Hand Off Auto Hand Off Auto Hand Off Auto Hand Off Auto a T a ka a w a w a a a X a X a
90. p screen Show Alternator If checked the Forward Reverse Auto selector is shown on the custom group screen Setpoints Title This label is shown above all the setpoints this can be left blank Alternator Selections Custom text for auto forward and reverse can be used Separate each one with a slash Alternator Label Custom text shown above the alternator drop down menu Notes Custom Group Screens can also use drop down lists for setpoints instead of text boxes for special mode selection To specify the list enclose it in braces and put it at the end of the setpoint label formatted like label1 value1 label2 value2 label3 value3 etc Example Control Mode Manual 1 Auto 2 Off 3 The Custom Group setpoint labels can also be used to specify a minimum and maximum value allowed To use this option enclose a range in square brackets at the end of the setpoint label Note this will not be displayed on the control group screen Example Target Pressure 0 200 These options can also be easily set up using a special window by right clicking on the stop start label and selecting Edit Special Options SCADAview CSX Micro Comm Inc Page 40 Security System File Edit Setup Window Help looga darm OSP Save Project Info Startup Database Security Stations Groups Graphics WebPage Script Editor SCADAdial PLC Setup Customer Information gt Client Server Startup Mouse Movements Reset Auto Logout S
91. pe in some comments whenever an alarm is acknowledged The comments will be logged to the alarm event log CTU Alarm Horn When this option is turned on the SV PLC Server application will be told to turn ON the CTU alarm horn output bit whenever an alarm occurs It will be turned back off when the operator hits Alarm Acknowledge CTU Alarm Ack If this option is on the CTU alarm horn will be silenced an alarm ack bit will to momentarily turned on whenever the operator hits Alarm Acknowledge SCADAview CSX Micro Comm Inc Page 14 Active Alarms Window oo n Station Name Time Occurred Tower 1 03 18 2013 07 00 06am Pump Station 1 03 18 2013 06 59 38am Pump Station 1 03 18 2013 06 59 55am Selecting Active Alarms from the View menu shows the Active Alarms list This window will show all the current alarms Alarms that have not been acknowledged will be shown in red Alarms that have cleared but still have not been acknowledged will be light brown The list can be re sized and scrolled through with the mouse Double clicking on an alarm line will bring up the Station Display for that alarm Right clicking will allow acknowledgement of individual alarms as well as selecting stations inputs whose alarms are to be disabled Station Alarms All Disabled Alarms Station Tower 1 Input Name Disabled LOS Loss Of Signal All Tower Level DIL VALVE OPEN DI6 POWER FAIL No
92. peration Sends the SOAP request given an operation name string Name as string SOAPResult sck as integer paramName as Returns the SOAP result message given a result parameter name Values string as string are always returned as a string SOAPErrorMessage sck as integer as Returns the SOAP error message if an error occurred during the request string SQLDate yyyy as integer mm as integer dd Formats the given date in SQL date format YYYY MM DD as integer as string SQLDateTime yyyy as integer mm as Formats the given date and time in SQL date time format YYYY MM DD integer dd as integer hr as integer mn as HH MM SS integer sc as integer as string SQLExecute sal as string Executes a given SQL database string uses the global SQL database server setup even if not enabled SQLSelect sql as string as string Executes a given SQL select string and returns the result as a comma seperated list with CR line endings StartCSXSetup spath as string Changes the setup folder to the given path and restarts SCADAview CSX Example StartCSXSetup C MICROCOMA2 TCPConnect sck as integer ipaddr as Opens a TCP IP Socket connection to the given ip address or hostname and string ipport as integer ip port number The socket number must be in the range of 0 32 TCPConnectTest sck as integer ipaddr as Tries to open a TCP IP Socket connection to the given ip host and port and string ipport as integer testperiod as inte returns 1 if the lat
93. peration is also enabled Time Inhibit Enter a time in 24 hour time i e 1 00 PM would be entered as 1300 and press Enter The inhibit time is the time of day that the control group is inhibited from controlling any devices Time Restore Enter a time in 24 hour time and press Enter to continue The restore time is the time of day that the control group is put back in control again Override Enter the stop and start values for which you want control to be reinstated temporarily for one controlled device during Time Inhibit because of a very low level The stop setpoint determines when to inhibit the control again Controlling Level Enables Use the mouse to toggle each of the eight controlling level ON or OFF Each control group has corresponding controlling levels These values determine when the device they control should turn on or off All levels that are currently being used for control should be set to ON The pumps or other controlled devices will run until the setpoints for ALL the levels selected are reached The scaling factor for the control group setpoints will also be determined based on which controlling level is selected SCADAview CSX Micro Comm Inc Page 13 Alarms Acknowledging Alarms To acknowledge alarms press the F4 key or select the Acknowledge All Alarms option from the Alarm menu The time date alarm description and current user name will be added to the event log Alarm Options Preferences
94. play The operation of the custom graphical windows will be different depending on the system The remainder of this manual describes the operation of the standard display screens since their operation is somewhat generic no matter how the system was set up graphically Another option available is to disable the graphics in the main viewer Graphics would only then be available when showing the seperate graphics window by selecting New Window or New Floating Window from the Graphics menu SCADAview CSX Micro Comm Inc Page 3 System Display System Display 1 Entire System Station Name AIT AI2 AI3 Flow Rate Flow Total 24hr Total DI1 DI DI3 DI4 DIS DI6 DI7 DIS Tower 1 LVL 21 3 FEET Pump Station 1 DP 80 0 PSI SP 40 0 PSI FR 283 0 GPM FT 10 234 000 GAL FT 24 000 GAL Ground Storage LVL 20 7 FEET 0 0 Raw Water Pumps LVL FEET FR GPM Lift Station 1 LVL 0 0 FEET High Service Pumps DP 72 0 PSI LVL 54 0 INCH v8s 76 8 PSR Rapid Mixer s MiS 0 0 M2S 0 0 cL2 0 675 mg L PER Flocculator 3 6 F3S 0 0 FAS 0 0 F5S 0 0 Flocculator 7 10 F7S 0 0 F8S 0 0 F9S 0 0 Influent Chlorine c2 0 63 mg L CF1 0 0 CF2 0 0 FRI 0 0 ppd FTL O lbs FT1 O lbs Feeder 6 10 PH 7 3 PH STR VAL LVL 0 0 FT Plant Influent Valve POS 74 3 X TUR 0 27 NTU TMP 68 3 degF FR 320 0 GPM FT GAL FT 9 GAL IR Plant Influent Contr PRC 9 0 PCV 9 0 Backwash Pumps DP 0 0 PSI P5S 0 0 P6S 0 0
95. points will be scaled based on the first level that is enabled Note that if the option to scale each line differently is selected then the Time Inhibit Restore Prefill setpoints will not be scaled Stop Start Column Labels Override Stop Start Labels Stop Start Stop Start 1 Pump Station 1 1 Controlling Levels Station The address and name of the station that controls the outputs for this control group This information will tell SCADAview CSX what scaling factor to use when displaying the setpoints for the group The scaling factor that will be used will also be based on which of the Controlling Levels 1 8 is selected on the Control Group Setpoints window Analog The analog input and name used for control of this group This information will along with the Controlling Station will tell SCADAview CSX what scaling factor to use when displaying the setpoints for this control group unless the option below is checked Use analogs selected above to scale each stop start line differently This option makes it possible for each line on the control group stop start screen to have a different scaling factor Each line will be scaled using the selected station analog Controlling Level Labels Control groups can have up to 8 different controlling sites depending on how the system is set up A label can be used to describe each controlling site TANK1 TH A etc Setpoint Labels A label describing each controlled device in the
96. pon web Page Number Formats M colors Help Tips W Pic central Code Reporting 77 Custom Daily Report E custom Timed Report Email Scheduling M Misc Options Activation Code Is Valid scADAwen meeer Enabled SCADAdial ARRARRARRA RAR RARA AAA Enabled Statistics Stations 49 Control Groups 12 Graphic Screens 11 Customer Information Use this setup screen in SCADAview CSX Studio to put in the customer s name and location These are used when activating the program over the internet and are also used on the Web page and in some reports The Add On features such as the web page are also enabled using this screen paste in the codes and click the Save Project toolbar button SCADAview CSX Micro Comm Inc Page 25 Client Server Startup Options File Edit Setup Window Help a i 2 Alo rima go 5 E Save Project Stations Groups Graphics Security Web Page ScriptEditor SCADAdial RTUCfg32 m Client Server Si Setup a an O Customer Information ee 20019 Client Server Startup Primary Server Address Secondary Server Address El Folders amp Database 192 168 1 114 a Security System Stations Client Server Update Rate 2000 msec Y Control Groups SV PLC Server Update Rate 4500 msec MA Graphic Screens e Web Page Disable Client Historical Logging Number Formats Disable Client Server Alarm Ack M colors _ This M
97. put integer number DOAD saddr as string do as integer as Station discrete output analog disable bit 1 or 0 given the address and integer input number DOPD saddr as string do as integer as Station discrete output pump disable bit 1 or 0 given the address and input integer number DOTD saddr as string do as integer as Station discrete output timeclock disable bit 1 or 0 given the address and integer input number El saddr as string ei as integer as integer Station expansion discrete input value 1 or 0 given the address and input number FALLING saddr as string ai as integer as Station analog input falling 1 or O given the address and input number integer SCADAview CSX Micro Comm Inc Page 58 FR sadar as string fr as integer as double Station flow rate value given the address and input number FRFALLING saddr as string fr as integer Station flow rate falling bit 1 or 0 given the address and input number as integer FRHIGH saddr as string fr as integer as Station flow rate high setpoint given the address and input number double FRHIGHALARM saddr as string fr as inte Station flow rate high alarm bit given the address and input number ger as integer FRLOW saddr as string fr as integer as Station flow rate low setpoint given the address and input number double FRLOWALARM saddr as string fr as inte Station flow rate low alarm bit given the address and input number ger as integer FRRIS
98. ring Returns the current GMT time zone offset string with the format HH MM or HH MM FileAppend fname as string writestr as Adds the given string to a file given the filename files are always in the string Script Output folder inside the History folder FileCopy fname1 as string fname2 as Copies one file to another given the two named files string FileExists fname as string as boolean FileWrite fname as string writestr as string SCADAview CSX Micro Comm Inc Page 61 GotoScreenNum scrnum as integer Changes main graphics window to the given screen number GTagProperty scrname as string objname Returns or sets a property value for any graphics screen tag The tag object as string propname as string as string must be named and the property name will match what appears in the graphics editor property window GTagRedrawAll This will force a redraw of all the graphic screen tags This may be useful after property values are changed GTagScreenCount as integer Returns to total number of graphics screens GTagScreenName scrnum as integer as Returns the graphics screen name given the screen number 1 Screen string Count GTagScreenType scrnum as integer as Returns the graphics screen type O normal 1 popup 2 clone given the integer screen number GTagScreenTagCount scrnum as integer Returns the total number of tags for a given graphics screen number as integer HTTPRequestPage sck as integer url as Opens an
99. rsor in pixels relative to the upper left corner of the primary screen MouseY as integer Current Y location of the mouse cursor in pixels relative to the upper left corner of the primary screen MyLANIP as string Returns the current LAN IP address of this machine MyWANIP as string Returns the current WAN IP address of this machine OSFreeDiskSpace pathnum Returns the amount of free space in Gigabytes for an optional path number O setup folder 1 primary history 2 secondary history as reported by the operating system The default path is the primary history folder SCADAview CSX Micro Comm Inc Page 62 OSFreeMemory Returns the available RAM memory in Megabytes This value will mean dif ferent things depending on the operating system OSR bval as boolean osrnum as integer One shot rising function This function will return True only once whenever as boolean the boolean bval parameter goes from false to true OSR ival as integer osrnum as integer as One shot rising function This function will return True only once whenever boolean the ival parameter goes from 0 to non zero PLCDiagValue plcnum as integer param as Returns a PLC diagnostic value given the plc and the requested parameter integer as double 1 Update Rate msec 2 Total Messages 3 Poll Time sec 4 Reads 5 Read OKs 6 Writes 7 Write OKs 8 Connection Fails 9 Timeouts 10 Status Errors 11 Percent Done 12 TxBytes 13 RxBytes PLCName plcnum as integ
100. s an intrinsic data type that consists of three bytes that define the color Const name value Declares a value as a local constant Cos Double As Double Returns the cosine of the given angle CountFields String String As Integer Returns the number of values fields in the string passed that are sepa rated by the separator string passed Dim Creates a local variable or array with the name and size in the case of an array and data type specified Do Loop Repeatedly executes a series of statements while a specified condition is True Exit Causes control to exit a loop and jump to another line of code without the loop conditions being satisfied Exp Double As Double eturns e to the power of the value specified False Used to set Boolean variables or properties False is the result of a compar ison of two objects that are not equal Floor Double As Double Returns the value specified rounded down to the nearest Integer Executes a series of statements a specified number of times Format Double String As String Returns as a string a formatted version of the number passed based on the parameters specified The Format function is similar to the way spread sheet applications format numbers SCADAview CSX Micro Comm Inc Page 55 Function End Function Declares the name parameters returned value and code that form the body of a function method that returns a value GOTO keyword Jumps to a statement label Hex I
101. s found in SCADAview CSX These can be selected from either the toolbar or from the View menu Trend Graph Tower 1 Tower Level Friday January 01 2010 Date 111200 Gr G E R wee 1Day Pens Z B 89 Tower 1 w Tower Level x e O pono sien i AA je W Pump Station 1 Suction Pressure 0 Pump Station 1 Flow Rate This is a chart that will show up to 12 separate levels for a selected period of time The user options include Date Starting month day and year for the graph Clicking the calendar icon will bring up a calendar selector Left Right Arrows Moves date backward or forward by one day Type This sets the horizontal scale for the graph Four selections are currently available 1 Day 2 Day 7 Day 14 Day and 30 Day Pens Open and save buttons allowing the pen setup to be loaded saved Station Names Selected station for a particular pen color Input Names Selected analog level or discrete input to be graphed for the corresponding pen SCADAview CSX Micro Comm Inc Page 17 Double Clicking on the graph or Right Clicking and selecting from the pop up menu will allow the Data Readout to be shown or hidden The Data Readout will display the exact analog level for each readout line along with statistics for the range between the two lines To change the selected times click and drag the readout lines Trend Graph FEET
102. sSetpoint saddr as string di as Maintenance system cycle alarm setpoint for the given station and input integer as integer DILastRun sadar as string di as integer fmt Maintenance system Last Run date time string in either SQLDate as integer as string Time format YYYY MM DD HH MM SS with 0 for fmt or other formats 1 ShortDate ShortTime 2 LongDate LongTime 3 ShortDate 4 Long Date 5 ShortTime 6 LongTime DIRuntime saddr as string di as integer as Maintenance system runtime in hours for the given station and input double DIRuntimeAlarm saddr as string di as inte Maintenance system runtime alarm bit 1 or O for the given station and ger as integer input DIRuntimeSetpoint saddr as string di as Maintenance system runtime alarm setpoint in hours for the given station integer as double and input DOCALL sadar as string do as integer as Station discrete output call bit 1 or 0 given the address and input number integer DODSBL saddr as string do as integer as Station discrete output disabled bit 1 or 0 given the address and input integer number DOFAIL saddr as string do as integer as Station discrete output failed bit 1 or 0 given the address and input number integer DORUN saddr as string do as integer as Station discrete output run bit 1 or 0 given the address and input number integer DOGD saddr as string do as integer as Station discrete output group disable bit 1 or 0 given the address and in
103. so the next time the SCADAview CSX Studio is run it will require an administrator s user name and password Be careful not to lock yourself out Local Auto Logout Time If a number other than zero is entered SCADAview CSX will log off the current user after the given number of minutes has elapsed This helps keep the system secure even if a user forgets to log out Server Auto Logout Time SCADAview CSX acting as the server will log out any remote logins after this amount of time If set to 0 it will never log remote users out Mouse Movements Reset Auto Logout If selected any time the user moves the mouse the local auto logout timer will be re started SCADAview CSX Micro Comm Inc Page 41 User Options User Name The name a user must type when logging into SCADAview CSX Password The password a user must type when logging into SCADAview CSX Confirm When changing or setting a password it must be entered again here to confirm the change User s Security Level Administrator The user can do anything including changing setup options SCADAview CSX Studio requires at least one administrator Supervisor Supervisors can change setpoints HOA controls etc Basically they can do everything other than program setup Operator Operators can view the display screens run reports etc and can make changes to the Hand Off Auto controls They can t change setpoints or program setup options None The user can log in but can t ma
104. ta is less that 1 polling cycle old Old means the data is more than 1 polling cycle old LOS means the station has not responded for a programmed number of cycles Time Stamp The central s time when the remote data was last received Date The computer s date when the remote data was last updated SCADAview CSX Micro Comm Inc Page 11 Control Group Setpoints Name Pump Station 1 Alternator AUTO Control Setpoints Time Clock Controls Pre Fill Rate Lead al e Time Inhibit 24hr Lag si Time Restore 24hr 3rd Pump E D Override Stop 4th Pump D Override Start The Control Group Setpoints window allows an operator to change the starting and stopping levels for any control group in the system A Control Group is a collection of controlling levels usually an analog input from a remote station such as a tank level and controlled devices usually pumps or valves at another station Note Making changes to setpoints is accomplished by clicking in the text box typing the new value and pressing Enter Changing other parameters such as the Controlling Level Enables is done by just clicking the box to select the new mode Pressing Enter is not required in this case If the control group is located at the remote then buttons for Read Send will appear above the setpoints that allow the operator to change the setpoints at the remote Name and The name o
105. te When alarms have been disabled a special message will appear at the bottom of the Active Alarms window along with a button to show the disabled alarms The main graphic viewer window will also include a warning icon after the active alarms in it s status bar Station Name Input Name User Name None User Level None Active Alarms 0 Connection OK SCADAdial Disabled SCADAview CSX Micro Comm Inc Page 15 Event Logs 01 13 2010 05 55 20p 01 13 2010 05 52 26p 01 13 2010 05 52 08p 01 13 2010 02 28 27p 01 13 2010 02 28 24p 01 13 2010 02 24 58p 01 13 2010 02 24 58p 01 13 2010 02 24 58p 01 13 2010 02 24 19p 01 13 2010 02 20 47p 01 13 2010 02 20 47p 01 13 2010 02 20 43p 01 13 2010 02 13 29p 01 13 2010 01 57 10p 01 13 2010 01 30 49p 01 13 2010 01 11 43p 01 13 2010 01 09 58p Station Name w AllStations Year w 2010 Month Start Day End Day Start HR End HR Filter w January ji 12 13 v 0 Y w Dateime Station Name Rapid Mixer s Rapid Mixer s Rapid Mixer s GE Backpulse Pumps GE Backpulse Pumps GE Backpulse Pumps GE Backpulse Pumps GE Backpulse Pumps GE Backpulse Pumps GE Backpulse Pumps GE Backpulse Pumps GE Backpulse Pumps Plant Influent Valve Plant Influent Valve Plant Influent Valve Finished Water Finished Water Input Name VFD1 Analog ALM VFD1 Analog ALM VFD1 Analog ALM Message Alarm Cleared Alarm Acknowledged Alarm Train 5 Pump 2 LOW FLOW Alarm Cle
106. the lines from this file based on the time period selected along with grand total numbers for each item at the bottom SCADAview CSX Micro Comm Inc Page 22 Custom Daily Reports Custom Daily Report 12000 Gr 1312010 G Custom Daily Report for January 1 2010 to January 31 2010 01 01 2010 01 02 2010 01 03 2010 01 04 2010 01 05 2010 01 06 2010 01 07 2010 01 08 2010 01 09 2010 01 10 2010 01 11 2010 01 12 2010 01 13 2010 01 14 2010 01 15 2010 01 16 2010 01 17 2010 01 18 2010 01 19 2010 01 20 2010 01 21 2010 01 22 2010 01 23 2010 01 24 2010 01 25 2010 01 26 2010 This report uses a file that is updated every midnight and stores custom daily numbers for Pump Runtimes minimum Flow Rate maximum Flow Rate non zero average Flow Rate and Flow Total etc The report window will display the lines from this file based on the time period selected along with grand total numbers for each item at the bottom SCADAview CSX Micro Comm Inc Page 23 Custom Timed Reports xj Reports Report Name Start Date End Date Custom Timed Report y 1 17204 Gy wi Er Micro Comm Demo System Custom Timed Report for November 1 2014 to November 1 2014
107. urce SV PLC Server Remote Group Use Custom Group Screen 1 Pump Station 1 1 Group The control group number 1 99 for the currently displayed group This number is assigned by Micro Comm when a system is created and will usually range from 1 to the number of groups in the system Name A label that describes the control group This is normally the name of a pump station or controlled device Data Source The SV PLC server application will normally be used to acquire data for the control group Currently the choices are None Data Entry or SV PLC Server Remote Group Checked if the control group is located at the remote distributed control Use Custom Group Screen When checked the appearance of the control group screen will reflect what is selected under the Custom Group Screen tab each setpoint line can be labeled and scaled differently with this option Otherwise the group screen will be set up using the Normal Groups tab SCADAview CSX Micro Comm Inc Page 38 Normal Group Screen Setup Group Pump Station 1 General PLC Normal Group Custom Group Screen Disable Help Controlling Levels Controlling Level Labels Setpoint Labels Station Analog Label Label 1 TH Tower 1 All Tower Level 1 North Tower 1 Lead Pump 2 Lag Pump 3 w w a a w a w w 7 Use analogs selected above to scale each line differently Normally all set
108. useful when the TCP connection is slow and the data is not really changing very rapidly on the server which is typical for radio telemetry systems Use Data Compression When checked CSX clients will use data requests that will result in compressed data replies This can be useful when the client server connection is slow Use Encrypted Communication Client Server communication and SCADAview NET protocol connections can use encryption If used the same password must be entered at each client and server Headless Server Mode Graphics Disabled Checking this will make a dedicated server use the least amount of system resources by disabling all local graphics rendering Enable Modbus TCP Server This makes SCADAview act as a Modbus TCP server with each station s data normal station data order located at 4x100 4x200 etc for each station in the list You must also enter the correct Modbus TCP Unit ID default is normally 0 Enable System Maintenance Schedule If checked the server will be re started every 5 days in order to clear memory and perform other maintenance tasks This will occur at 2 08 AM on the 1st 6th etc day of the month Disable Graphics Pre Loading at Startup If checked the graphics screens will be loaded as needed instead of all during startup This speeds up inital startup and reduces memory usage SCADAview CSX Micro Comm Inc Page 27 Folders amp Database SCADA CSX ICADAVIEW File Edit Setup Window
109. utput pump Four modes are possible Standby the controlled device is off in auto and available for use Disabled the controlled device is currently disabled or the HOA is off Fail device has failed to run Call device is being called on by the CTU Status The current status of the input Pumps will always show either OFF or RUN in this column Other discrete inputs will display a user defined label when an input in on Station Display i E 8 Name Pump Station 1 y Addr PH Levels High Low Rate J Outputs Discretes Expansion HOAs Maintenance Remote Name Value Units Name Position Discharge Pressure 40 8 Pump 1 Suction Pressure 248 Discharge If Greater than 50 40 8 TIME 0 52 042 0 Test Pulse Rate 17 0 PLC Temperature 1 051 736 Restarts 357 0 Runtime msec 90 0 Flow Rate Total High Low Flow Setup Name Value Flow Rate 248 0 Flow Total 1 092 511 000 24 hr Flow Total 1 188 000 Gl Status Hours Cycles Flow Rate 2 2 098 0 cou RON 122 568 Flow Total 2 7 181 751 000 24 hr Flow Total 2 1 934 000 l Control Group Setpoints Hand Off Auto Controls Pump Control Panel Double clicking in the the Position or discretes status column will bring up an individual pump s control panel HOA Note The pump control panels can be globally enabled or disabled in application preferences Pump control panels show the control status
110. ve all the changes System Display 1 Options Display Name Main System Column Labels Data Cells Headings Courier New y Aria Size Style Size Style 9 Bota nA 10 v Bold E Hide Input Labels Colors C Background cy Alt Background MM vata text 7 Show Addresses El Grid Lines E Heading Background Bl Heading text Set Defaults Color options like the Alt Bacground will bring up a screen that allows the alternating row color to be changed Click on color desired and click OK to save the change SCADAview CSX Micro Comm Inc Station Display amp Control Name Pump Station 1 Addr PH Notes Name Value Units Status SYS RTU Mode Status Discharge Pressure 70 9 PSI FALL a Pump 1 Auto Suction Pressure 64 7 PSI RISE T Pump 2 Monitor Standby Off PISS 45715 0 RISE Pump 3 Off Disabled Off TIME 0 27824 0 Bypass Valve Off Test Pulse Rate 0 0 PPM LOW SUCTION BOX TEMPERATURE 972 0 POWER FAILURE Restarts 55 0 LV7 Pump 7 Runtime msec 90 0 LV8 Pump 8 AD Level 716 0 ft CV FAIL 1 AI10 Level 278240 ft CV FAIL 2 Flow Rate Total High Low Flow Setup Station Status Name Value Units Station Data Status Flow Rate 647 0 GPM RTU Normal Flow Total 62 211 217 000 GLNS cru Normal 24 hr Flow Total 29 555 00

SCADAview CSX User`s Manual - Micro

Contents

Download Pdf Manuals

Related Search

Related Contents