Home

Promis User Manual

1. SELECT timeOfMeasurement MeasuredValue FROM Measurements WHERE tagID 8 AND timeOfMeasurement gt startOfPeriod AND timeOfMeasurement lt endOfPeriod Page 33 of 60 This query retrieves the measurements of the tag with TAGID 8 over the selected period The list returns a table with two columns timeOfMeasurements and MeasuredValue Note MeasuredValue is returned in the default unit of the parameter associated with the tag The XML lt dataset gt contains a list with column names In this case the list will be lt co name timeOfMeasurement gt lt col name Measuredvalue gt The XML lt dataset gt contains a list of rows which equals the number of records returned by the SQL query Each lt row gt contains a list of values that equals the number of columns returned by the SQL query The XML tag for a column equals the name of the SQL column In this case lt timeOfMeasurement gt timestamp lt timeOfMeasurement gt and lt MeasuredValue gt value lt MeasuredValue gt When creating a new report Promis generates a report with default queries Each query results in a summary over the selected period for one of the tags of the concerned location A default query looks as follows SELECT Count as Cnt Min MeasuredValue as MinVal Max MeasuredValue as MaxValue Avg MeasuredValue as AvgVal FROM measurements WHERE measurements tagID 8 AND timeOfMeasurement gt startOfPeriod AND timeOfMeasurement lt endOfPeriod The
2. The overall Chart appearance characteristics are a grouped into these categories General Axis Titles Legend Panel Wall and 3D These are the groupings you will find if you open the Chart Editor and browse the Chart pages Other properties affect the look of your Chart These include Series colors and mark characteristics individual Axis and Grid display properties and labeling Right click on the chart and select Properties from the menu to access the Chart Editor The first page is the Series page which is empty of Series at the moment and which we ll look at in another tutorial Select the second Chart tab General to access the General Chart properties page General Chart Options General options include Print Preview and Chart plus the 3 following sections Margins Zoom and Allow Scroll Margins Margins are defined as the distance between the Chart Border and the Chart Frame and are expressed as a percentage of the overall dimensions of the Chart Panel Moving the spin boxes in the Chart Editor Margins box will show you at design time the effect of changing each Margin Measurements 29 x Chart Series Data Tools Export Print ny i Axis Titles Legend Panel Paging Walls 3D Series l Zoom Scroll Print Preview Allow Scroll I Clip Points C None Horizontal C Vertical Both Mouse Button Right x Page 27 of 60 Axis Properties Control of
3. table which is connected via its tagID to 2 the tags table which is connected via its ParID to the params table The measurements table has three fields TagID TimeOfMeasurement and MeasuredValue The tags table has a o the following fields TagID ParID TagName Target MinRange LoLim HiLim and MaxRange The Params table has a o the following fields ParID Unit AltUnit AltUnitFactor AltUnitOffset AltUnitFactor and AltUnitOffset are specifying how to convert from the default unit to the alternative unit The formula is as follows value alt Unit measured value factor offset Page 24 of 60 Visual properties Charts can be built and implemented using the Chart Editor You may define the Chart appearance titles legend characteristics and 3D aspect Everything comes together to make the final Chart with Chart axes being the interface between Chart and Series A Series has data and its values will influence the label characteristics of the Chart axes The axes appearance colors grid frequency and label fonts may all be defined for the Chart before adding data Series Promis will make a best estimate of most values to minimize the need for you to manually define Chart and Series properties The Chart Editor contains access to most commonly used Chart properties To add a new Series from the Chart Editor click the Add button and select the Series type from the Series Ga
4. 3 Footer positioned below the chart Page 29 of 60 REPORTS Report D Name Description a 2994 a Monthly Summary 2996 Annual Summary 2990 Evapotranspiracion Angular Gauge HTMLS Canvas anon Mina Dann Mind Dana UTA E Aaminn Humedad Relativa Radiacion Solar w M2 Minimum Average Maximum Minimum Average Maximum 51 55 60 74 0 27 78 87 424 76 x 32 87 51 09 62 02 0 01 84 72 392 95 0 39 90 63 60 85 50 0 00 267 10 957 00 79 60 1008 00 83 70 981 00 45 10 65 84 83 70 0 00 175 39 993 00 48 50 71 10 93 80 1 00 239 99 1031 00 41 30 7117 E oo 233 29 960 00 1 00 1 00 202 40 209 58 41 20 38 20 62 08 62 02 41 30 64 63 80 20 1 00 193 99 818 00 37 70 60 41 78 10 1 00 197 86 946 00 67 10 70 20 74 10 0 00 1 08 2 00 ER EEE sical atta xl v E Tags Map WB Recent p Player x Charts Reports History E Assets Comments The Report page is used to show user defined reports You can define several reports per location When creating a new report Promis pops up a list with report templates to choose from After picking a template Promis pops up if applicable a list with tags and you can select which one s you want to include in the report Reports can be printed or saved or e mailed as Html compatible documents The list with templates contains a standard tabular report in html csv xls xm
5. De pending on the type of DAQ source Port coma z Baudrate 3600 zi J you can let the Collector Manager Data bits B of stopbis 1 Fi automatically add new tags to Promis Parity Even x Hand shake None The Collector Manager supports four types of connections Driver Properties Collector Driver MODBUS Driver Ea Configure SLAVE 1 amp TIMEQUT 3000 1 Local serial connection for serial devices busses connected to a local communication port Properties 2 Remote serial connection for serial device bussus which can be accessed via a PSTN or GSM phone network 3 An on line network connection commonly used to access TCP IP enabled devices e g a MODBUS TCP slave or TCP IP services e g an E mail or FTP server 4 TCP server connection the Collector Manager acts as TCP server and TCP client devices can connect to it See the next chapter for details For each collector an appropriate driver should be selected and configured Configuration of the driver properties is driver specific E g for a MODBUS driver you must specify the slave address of the MODBUS device For an OPC Server you must specify the server and the system hosting the server For an XML Server you must specify the type of transfer protocol http ftp or file and the URL of the XML file to be processed TCP server connection GPRS or UMTS is a perfect and cost effective replacement for legacy PS
6. 01 00 00 1 s month s w Backup file name format Prefix Date Time part format Trail Extension backup yyyymmdd X bak File name of next backup backup20120201 bak Directory on disk or network share V After backup delete measurement data older then The deleted measurement data still 3 El monthis exists in your backup file This backup service is meant for backing up an Ms Access or Ms SQL Express database only Close and Save changes Schedule Specify the backup interval and the date and time when you want the next backup to take place If a backup fails it is retried every 5 minutes If a backup succeeds the next backup will be scheduled one interval further Backup file name format The file name of a backup file may start with a certain prefix and end with a certain trail the file name extension is fixed mdb for Ms Access and bak for Ms SQL The part between prefix and trail can be formatted based on the Backup time The default format to prevent your disks becoming overloaded with backup files is yyyymm e g 201104 which will cause max one backup file per month even when backing up every day If a backup file already exists it will be overwritten with the new one with the same name The Date Time part format string is composed from specifiers that represent values to be inserted into the formatted string Some specifiers such as d simply format numbers or strin
7. Description L Supervisors Delete C Administrators C Nobody Clone z Change Edit Chart 3 000 77 H H H 7 H H H H i H i i i i i i i JV Mass ton Ss i l i Import 2000 V Volume m di a 1000 V Level m Export 0 3000 2 2000 i SR NERY Ur aaia a AES sins NDES y ONE A EN E ANSE AE ANE OAD D gt 0 6 4 3 3 2 OK 0 Ql 10 15 10 30 10 45 11 00 11 15 11 30 11 45 12 00 12 15 12 30 12 45 13 00 13 15 13 30 13 45 3 Oct 3 Oct 3 Oct 3 Oct 3 Oct 3 Oct 3 Oct 3 Oct 3 Oct 3 Oct 3 Oct 3 Oct 3 Oct 3 Oct 3 Oct Cancel Display option At default a chart is displayed to all granted users However it s possible to show a chart to a certain type of granted user while hiding it from another See chapter users Page 22 of 60 Defining chart queries The Data needed to draw chart lines Series has to be extracted from the database Promis uses SQL queries to extract data from the database The meaning of a query is to retrieve a list of records from a database according to defined search criteria In the context of Promis every record represents a Series point Consult chapter Binding Series to a Query to see how X Y and Z values can be bound to fields in a record Chart properties iof x Query name fai flow Query code SELECT timeOfMeasurement Measured alue FROM measurements WHERE taglID 8 AND timeOfMeasurement gt startOfPeriod AND timeOfMeasurement lt endOf
8. System services will automatically start after re boot this assures that data collection will continue even after an un attendant re boot e g after a power failure When the Collector Manager is running visible you can hide it by clicking the close cross and a small icon in the Windows icon tray will occur right bottom corner Clicking this icon will pop it up again When the Collector Manager is running it will start scheduling collection moments If you want to introduce an intermediate collection you can right click with your mouse on Collector and initiate a Manual Collection Page 52 of 60 Collector Properties For each collector an automatic read out schedule can be applied ranging from once per minute to several weeks The next read out date time specifies when 210 x DATACOLLECTOR 1 Read out interval fi Collector Name the next read out should take place This a Next read out Thursday Jul 06 2006 v 03 00 00 date time will automatically be shifted sob AEA each time a scheduled collection has Retries 3 Time between retries is 5 minutes or less been performed successfully Setting this Rann aes date time to the future will delay le hee a mee obviously the next read out till that date time setting this date to the paste Connection type Local serial connection x will start the data collection a s a p M Connection Properties
9. generated the file To avoid import failures specify where the last record row occurs counted from the bottom of the file Page 44 of 60 A file may contain several informational rows not part of the header or footer rows which are not containing valid importable record data To avoid import failures while trying to import such rows filters can be specified to include or exclude those rows A row is included if it contains at least one of the include phrases leave blank if all records should be included A row is excluded if it contains any of the Exclude phrases leave blank if none of the records should be excluded Phrases are separated by each other with spaces If a phrase exits out of multiple words the phrase should be enclosed between single quotes When done click the Next button to go to the Column properties page Column properties r E Import Data Wizard gt The column properties iie page is used to specify EATEMP 1092411 TXT which columns from the file you want to import Raw data File format Column properties Preview Timestamp columns If Date and Time are combined in one column choose the same column nr for both g g Date Time Column nr Example value A file may contain several D columns but only a few of 2 09 48 00 i them could be interesting Tag columns i for im porti ng Assign to database Tag Column nr Example value Name Code L gt
10. measurements table has three fields TagID TimeOfMeasurement and MeasuredValue XML Data Click the XML Preview tab to see the XML data generated from your SQL queries The XML data generated by Promis exists out of several nested levels the levels from outer to inner are lt report name report name gt giving the name of the report location and selected period lt params gt this section contains a list of lt param gt sections gt One lt param gt for every defined Parameter lt param name parameter name gt this section contains the name and the value of a defined Parameter lt datasets gt this section contains a list of lt dataset gt sections Each SQL query results ina separate lt dataset gt lt dataset name query name gt this section contains a list of columns equal to the number of columns returned by the SQL query and it contains a list of rows equal to the number of records returned by the SQL query lt col name col name gt a lt co gt does not contain any data it just specifies the name of a column as returned by the SQL query lt row gt this section contains the field values for a specific record as returned by the SQL query lt col name gt value lt co name gt the name between lt gt is set to the SQL column name of the concerned value Page 34 of 60 XML example lt xml version 1 0 gt lt report name Example report width 120 height 2
11. 6 operations are possible 1 Delete above base line data points above the base line will be deleted 2 Delete below base line data points above the base line will be deleted 3 Follow base line the value of a data point will be set to the interpolated value between the two nearest surrounding anchor points so the data line will follow the base line 4 Follow reference line the value of a data point will be set to the interpolated value between the two nearest surrounding reference points so the data line will follow the reference line 5 Merge from reference the data line will be extended with points from the reference line with timestamps not existing in the data line 6 Restore from original all existing data points will be deleted and replaced by the original collected data points Page 42 of 60 Data Import Wizard Mostly the measurement data stored in the database is automatically collected without any human intervention It could however because of equipment malfunctioning or any other exceptional reason that you have to import measurements from text files The Date Import Wizard can be used to manually import measurements from tabular oriented text files like CSV files The files should contain lt line feed gt or lt carriage return gt terminated rows and each row should contain an equal number of columns with a date time column s and separated columns for each individual measurement parameter In example a sepa
12. ADO OLEDB to store its data The default database as automatically installed with the setup is an Ms Access database C Projex promis database promis mdb However It s also possible to use an SQL Server or Oracle database To use a licensed Oracle or SQL Server database you have to ask your DBA Database administrator to create an empty database Promis itself will create the necessary tables When clicking the Change Data Source button in the denen Promis Login screen you can change the database Password Change Data Source used by Promis Change Data Source A Data Source can be specified by its ADO Microsoft Acces Data Objects connection string Database systems like SQL Server require that you specify authentication info to get access to the database Please ask your DBA for the right info m gt o mm Click the Edit button to Edit the Database ADO OLEDB Data Source existing connection string within a Connection String Provider Microsoft Jet OLEDB 4 0 User ID Admin Data Edit co nfi gu ration wi nd OW of the Source c mydbtabaseltest mdb Persist Security Info False according provider Database Login Authentication Click the New button if you want User ID Admin Password to choose another type of database provider Compact Repair MS access database Cancel ADO Connection string examples Ms Access Micros
13. Field type TagID INTEGER TimeOfMeasurement DATETIME MeasuredValue FLOAT Parameter A tag must be associated to one of the defined parameters Type The type of tag can be one of the following Default tag visualization presentation and calculation behavior can differ per tag type E g calculating an average wind direction is different than calculating an average temperature Description A measurement sample of a continues signal A level E g the fuel level in a storage tank Each registration represents an absolute quantity E g a registration of a mass from a weighting bridge A registration of an continues increasing counter value E g a kWh counter A registration of a non continues signal E g an impact A measurement sample of a discrete signal e g wind direction important in case of average calculations Minimum range must be between 0 360 Maximum range may exceed 360 to be able to set alarm boundaries on a Northly direction e g GPS coordinate g GPS coordinate Number of Decimals Specify the number of relevant decimals to be displayed Target The target value set point for this tag Range Specify the Min and Max range for the tag Measurements outside this range will not be displayed The Y axis of the Player will be scaled to the specified range Limits If a measurement is outside its limits it will be displayed in red and if required an alarm can be passed to the Messenger for further
14. Locations tags instruments etc can be mapped on a background picture to create control panels dashboards and or graphic navigation Supports Drag amp Drop to move tags locations charts and reports Search for locations based on several criteria a o limit exceeding values View recent values per location View summary values per location min max avg count quantity and std dev Playback measurements in time with double time axes to compare measurements in time View measurements in tabular form View measurements in graphical form Define your own charts data queries as well as visual properties More than 20 graphical types like line column bar Gantt pie plane bubble arrow point surface polar radar and contour More than 15 graphical functions like curve fitting standard deviation moving average cumulative and trend Complete control of titles legends labels axis colors and other visual properties Define your own reports by using templates and or SQL XML and XSLT transformation Supports printing exporting and e mailing charts as JPEG pictures Supports printing exporting and e mailing historical data as Excel compatible sheets Supports printing exporting and e mailing reports as Html documents Free integrated Web Server to few recent values and simple trending Optional extended Web Server to few historical data user defined charts and reports Optional Report Scheduler to schedule au
15. Right arrow simultaneously or Alt amp Left arrow for the previous one When a data point is snapped by the vertical hairline you can delete the data point by clicking the Ctrl amp Del keys simultaneously You can manually add data points by moving your mouse to the wished X Y position time value in the chart window followed by clicking the left mouse button or Ins key while holding the Shift key Range of values mode If multiple points have to be modified dragging single data points to their wished values can be time consuming In Range of values mode you can specify a certain range period of time on which you want to perform your modification operations The range on which a modification operation is performed is determined by the so called Base line You can add Anchor point to the Base line by moving your mouse to the wished X Y position time value in the chart window followed by clicking the left mouse button or Ins key while holding the Shift key When an Anchor point is snapped by the vertical hairline you can delete the Anchor point by clicking the Ctrl amp Del keys simultaneously The range on which a modification operation is performed is the time between the Anchor point with the youngest timestamp and the one with the oldest but must be within the visible part of the charts X axis time axis The following
16. To Rate pcs which calculates the rate per hour at which the minimum value is changed to the maximum value over the selected aggregation period or registration interval of an input tag of type counter E g to calculate the flow rate based on a water counter Dewpoint pcs which calculates the dew point based on a Temperature C and Relative humidity input tag GPS drift pcs which calculates the GPS drift in meters based on the difference between a recorded position and a target position The script requires a latitude and a longitude input tag Wet bulb temperature pcs which calculates the wet bulb temperature based on a Temperature C a Relative Humidity and a Barometric Pressure kPa input tag Windchill pcs which calculates the wind chill based on a Temperature C and Wind speed m s input tag Switch on high limit pcs which sets the value of a tag to 1 if one of the input tags exceeds its high limit set point Sets the value to 0 again if all input tags are below their high limits Switch on low limit pcs which sets the value of a tag to 1 if one of the input tags falls below its low limit set point Sets the value to 0 again if all input tags are above their low limits Page 16 of 60 Custom Calculation Scripts A user definable script Microsoft J Script does the actual calculation The calculation is fed by a multi dimensional J Script Array supplying the data to be used in the calculation The Array
17. a file can be separated by each other by means of a separation token e g a or space or starting at fixed character positions Please study the date time format as well A lot of different notations exists e g d m y h n s or mmddyyhhnnss or yyyy mm dd hh nn Verify also which character is used for the decimal separator When done click the Next button to go to the File format page Page 43 of 60 File format E Im ta Wizard alaks Import Dai ar _ Import file c TEMP4 1092411 TXT Raw data File format Column properties Preview Data presentation Field seperator _y Decimal seperator dot Text marker double quote x i i Date Time format i Format frmn dd yyyy hh nn ss ZI Time zone offset hours 0 L Row settings Names row 1 Codes row 1 z Units row f1 z First record row 2 Last record row counted from bottom of file 1 is last row f1 Import record only if a row contains one of the following phrases Put a single phrase between quotes if it exists out of multiple words Skip record if a row contains one of the following phrases Load properties from file Save properties to file Cancel Previous Next Data presentation Specify the Field separator the character that is used to separated the different columns in the file or choose Fixed positions if the columns are starting at fixed positions Speci
18. a non number can prevent a recording to the database Page 17 of 60 Tag Data Normally tag data is collected automatically however it could be that the collected data needs to be corrected or that you want to insert some values manually To edit tag data select the tag from the Tags list and select Data from the Edit gt Tags or pop up menu 2 Data O x Tag code Tag ID TEMP 29 Close Tag name Temperature T 31 Mar 06 00 43 47 31 Mar 06 01 30 00 31 Mar 06 02 11 22 J So Edit Timestamp Value E 3 31 2006 12 50 00 A 13 936 3 31 2006 1 00 01 AM 13 845 3 31 2006 1 10 004M 13 845 3 31 2006 1 20 01 AM 13 805 CEPTA 13 755 3 31 2006 1 40 01 AM 13 774 373172006 1 50 00 4M 13 734 3 31 2006 2 00 01 AM 13 604 3 31 2006 2 10 01 4M 13 585 40 35 30 25 20 00 00 00 01 00 00 02 00 00 03 00 00 04 00 01 31 Mar 31 Mar 31 Mar 31 Mar 31 Mar The tag data is shown in chart and tabular form The chart shows all the data over the selected period The chart has a left and a right marker both colored maroon which can be dragged horizontally to mark a certain portion of the data only this data will be displayed in tabular form The chart has a data cursor colored blue that can be used to select a particular data record in the table To enter a single data record manually click the button below the table and enter a valid timestamp and value Click th
19. at Host E mail address DK support projex nl Cancel Reports can be delivered to several Host types and in several formats e g CSV HTML Excel The different supported Host types to delivery reports at are 1 Local File System storing report files on disk 2 SMTP Server e mail reports 3 FTP Server store report files on a remote file 4 HTTP Server post reports to a HTTP Server Web Service From the Edit menu you can pop up the Report Hosts editor to define the Hosts to be used for automatic report delivery Timing Start time the Start time defines the beginning of the period you want to report about After every successful delivery the Start time time is shifted with the Duration of the report period Delivery time the Delivery time defines when a report should be delivered After every successful delivery the Delivery time time is shifted with the Duration of the report period Normally the Delivery time should be a time later then End time of the period you want to report about Delivery time gt Start time Duration Page 37 of 60 Report file name format The file name of a report file to be delivered may start with a certain prefix and end with a certain trail The part between prefix and trail can be formatted based on the Delivery time The Date Time part format string is composed from specifiers that represent value
20. can include chart s into it as well To include charts add HTML img elements in lower case to the HTML code as follows lt img src chart jpg chartid x gt where x is the ID of the chart to be included Page 35 of 60 A simple XSLT transformation example to list the raw result of your SQL queries lt xml version 1 0 gt lt xsl stylesheet xmins xsl http www w3 org 1999 XSL Transform version 1 0 gt lt xsl output method html omit xml declaration yes media type text html gt lt xsl template match report gt lt html gt lt style gt body font family Arial font size 12pt color black table font family Arial font size 8pt color black h1 font family Arial font size 1l6pt font weight bold color black lt style gt lt body gt lt hl gt lt xsl value of select name gt lt h1 gt lt table gt lt tr gt lt td gt lt b gt Location lt b gt lt td gt lt td gt lt xsl value of select location gt lt xsl value of select locationpath gt lt td gt lt tr gt lt tr gt lt td gt lt b gt Start of period lt b gt lt td gt lt td gt lt xsl value of select startofperiod gt lt td gt lt tr gt lt tr gt lt td gt lt b gt End of period lt b gt lt td gt lt td gt lt xsl value of select endofperiod gt lt td gt lt tr gt lt table gt lt xsl for each select datasets dataset gt lt br gt lt b gt lt xsl value of select name gt lt b
21. devices is that they are not easily accessible for remote configuration However we have implemented an Intercept mechanism to make remote configuration possible If you connect to the server with HyperTerminal or any other TCP terminal emulator and you type within 8 sec the Intercept command then the next time the remote device connects all communication will be redirected to your terminal window and vice versa The intercept command is INTERCEPT lt DAQ unit ID gt in example INTERCEPT STATION1_AE762345 and if accepted your terminal will display while waiting for the client INTERCEPTING lt DAQ unit ID gt or INTERCEPTED lt DAQ unit ID gt when connected Page 54 of 60 Backup Service In case you don t make use of a sophisticated database server with features like database mirroring and automated backups it is recommend to regularly backup the database manually see Chapter Database Backup or automatically The Backup Service is meant for backing up an Ms Access or Ms SQL Express automatically at regular intervals e g every day at 07 00 to disk or removable media e g USB stick Oracle is not supported by the Backup Service To configure start the Backup Service please click from the Menu bar gt Control gt Start Backup Service and the following screen will pop up r Backup Service Properties s Schedule Next backup scheduled at Backup interval Wednesday February 01 2012 v
22. dispatching Page 12 of 60 Additional Properties A tag has a o the following additional properties l Tao properties aolxi Base properties Additional properties Collector properties This tag is a calculated tag using other tags as input J m Display options Display on Display on Display on Map page for Recent page for History page for Anybody Anybody C Anybody M Visitors L Visitors L Visitors M Operators M Operators Operators M Supervisors v Supervisors v Supervisors vr v emer Administrators O Nobody CO Nobody Nobody m Alarm Options The Alarm Scanner if installed and running will check if values are within limits and if a tag is recorded in time If not an alarm message is passed to the ProjexMessenger for further dispatching JV Alarm if values are out of range Hysteresis fos Alarm if the most recent value is out of range Alarm if the most recent average value is out of range Calculate average over time period foo 00 00 hhimnmss JV Alarm if no value is recorded within o0 30 00 hh mm ss M Name Table used to display values as text e g 0 Closed and 1 Opened None x T This Tag is a product density tag and is linked to Product Tag B Cancel Calculated tag If switched on the measured value is a value calculated based upon the measured values of other tags
23. gt lt br gt lt table gt lt tr gt lt xsl for each select col gt lt td gt lt b gt lt xsl value of select name gt lt b gt lt td gt lt xsl for each gt lt tr gt lt xsl for each select row gt lt tr gt lt xsl for each select node gt lt td gt lt xsl value of select gt lt td gt lt xsl for each gt lt tr gt lt xsl for each gt lt table gt lt xsl for each gt lt body gt lt html gt lt xsl template gt lt xsl stylesheet gt Page 36 of 60 Defining a report schedule Promis has an optional module to schedule automatic report deliveries Click the Schedule tab to define a delivery schedule ioi xi Report name Description Example Report a JV International data format E Parameters SOL l 2 XML Preview ke XSLT Report Preview oJ Schedule IV Schedule automatic report deliveries only possible when the optional Promis Report Scheduler is installed Refresh M Timing Start time of next period to report Duration of report period Import zaterdag 19 november 2005 00 00 00 fi days 7 Next delivery scheduled at Export zondag 20 november 2005 aa 00 00 00 m Report file name format Pretix Date Time part Delivery time Trail File name of next report fest ddmmyyyy E htm test20112005 htm Date Time formatting symbols y year m month d day h hours n minutes and s seconds Deliver report
24. has the following format var aInputData lt first inputTagID gt lt tagCode gt lt average or instant Value gt lt Min value gt lt Max value gt lt Count gt lt Time of min value gt lt Time of max value gt lt Values gt lt sec inputTagID gt lt tagCode gt lt average or instant Value gt lt Min value gt lt Max value gt lt Count gt lt Time of min value gt lt Time of max value gt lt Values gt lt last inputTagID gt lt tagCode gt lt average or instant Value gt lt Min value gt lt Max value gt lt Count gt lt Time of min value gt lt Time of max value gt lt Values gt For each input tag there is a sub array in the alnputData array The order of the sub array s is accordingly to the order of input tags Each sub array has the following 9 fields 1 inputTagID the unique ID of the tag integer 2 tagCode the userid defined code of the tag string 3 average or instantaneous value the most recent average averaged median or instantaneous value float If the input tag is of type Counter the value is the last counter value within the aggregation period 4 Min value the minimum value within the aggregation period This value equals the instantaneous value if no aggregation period was specified 5 Max value the maximum value within the aggregation period This value equals the instantaneous value if no aggregation period was specified 6 Count
25. limit violations The Messenger category for TIMEOUT alarms is Support and the Messenger severity is Error Page 59 of 60 Integrated WebServer Promis has an integrated WebServer When this WebServer is started the information stored in the Promis database can be consulted via a WebBrowser from any computer that has access to the Promis WebServer either via an Intranet or Internet The Promis Standard WebServer license which is included in a regular Promis license enables a user to view recent values and pop up a trend of a single tag over the last 24h The Promis Extended WebServer license enables the user to view charts reports and long term history To enable the WebSever select Start WebSever from the Control menu The WebServer is a service that will run in the background and keeps running even if you close Promis and will start running after a re boot automatically To stop the WebServer select Stop WebServer from the Control menu To consult the Promis WebServer open a WebBrowser and type in the address bar of the Web Browser the name or IP address of the computer running the WebServer The WebServer listens by default to TCP port 80 But this could be conflicting if you have already running another WebServer e g Microsoft Internet Information Server on your system The default TCP port can be changed to any other value ask your network administrator fo
26. options a b Multiple aggregated values per period The aggregation will be performed over a shifting time window e g to calculate a rolling average Each time a new input value is recorded a calculation will be perform and a calculated record will be recorded The aggregation will be performed over a period right aligned in time with the timestamp of the recorded input value One aggregated value per period The aggregation will be performed over a discreet time window and only one value will be recorded e g if the period is 1 hour only one value per hour will be recorded Each time a new input value is recorded a calculation will be performed and a a new record will be recorded if no value was recorded within the aggregation period yet or b an existing record in the aggregation period will be updated The timestamp of the calculated record can be set to the begin middle or end time of the aggregation period Calculation Scripts When you define a calculated tag you can choose from 5 basic functions copy sum subtract multiply and divide but you can also load a calculation script from disk The following standard calculation scripts are pre installed on your system Counter To Quantity pcs which calculates the difference between the maximum value and minimum value over the selected aggregation period or registration interval of an input tag of type counter E g to calculate the energy usage based on a kWh counter Counter
27. simultaneously or All amp Up arrow for the previous one You can add tags to the list by clicking the corresponding Add button It s possible to add tags from other locations to the list as well To compare the measurements of the tag you want to edit verify with measurements of a similar tag you can select a tag from the Reference tag list The data of the reference tag will be displayed as a green line You can add a tag to the reference list by clicking the corresponding Add button Its possible to add tags from other locations to the list as well Only Administrators are allowed to add remove tags to from the lists Note Modifications are not posted to the database immediately If modifications are made a confirmation question asking if you want to save your changes will be raised when closing the Editor Page 41 of 60 Single point mode Data points are displayed as small dots to change the value of a data point select the data point with your mouse click and hold the left mouse button while dragging the data point to the wished value Data points can be dragged vertically only To select an individual data point move the mouse cursor near the data point until it is snapped by the vertical solid hairline The Data line point box at the right bottom site of the chart will display its timestamp and value You can also select the next data point by clicking the Alt amp
28. the axes is quite an involved area at its greatest level of intricacy and is dealt with in greater depth in a later tutorial Here we will cover the fundamentals of Axis and Frame display The second Chart page holds the properties for defining axis and frame characteristics There are 5 Standard axes in the Chart Left Top Right Bottom and Depth The Chart Frame displays as a surround to the Chart s plot able area and has no data corresponding features The Depth initializes by default as not Visible All other Axes are visible from the moment that a Series is added to the Chart and associated with those Axes Left and Bottom as default Measurements 24 x Chart Series Data Tools Export Print Series General Axis Titles Legend Panel Paging Walls 3D 7 Visible Scales Title Labels Ticks Minor Position IV Behind Position 0 Start J0 End 100 P Other side I Horizontal The key properties to enable display of axes and frame are Show Axis The Show Axis checkbox enables or disables display of all 4 axes If the Frame is visible then a Chart surround is still visible when the axes are hidden The result will be the appearance of a larger Chart as no area is reserved for axis labels Axis Left Right Top Bottom and Depth Visible Select the radio button of the axis that you wish to display or hide and toggle the Visible checkbox to control the display for that spe
29. the instrument for instance to display the most recent value If an instrument report is in HTML format the instrument can sent action events to the application To inform the application that the report can initiate actions the lt body gt element of the HTML should contain the action string attribute E g lt body action gt The action attribute can be set by JavaScript enclosed in the HTML e g triggered by an event after clicking a button The action attribute is a formatted string that may contain up to three fields separated with semi colons The first field specifies the type of action 1 Edit set points 2 Set tag value and 3 Change location The second field specifies the ID of the tag or location to perform the action on The 3 field is optional and can be used to specify the value of a tag to be written to the database E g action 2 1 1 23 will cause the application to log 1 23 for the tag with tagID 1 into the database Defining report parameters Defining report parameters is not a must but can be handy The XML data of the report is constructed from the result of SQL queries Within SQL queries you could decide to use fixed variables for your search and filter criteria it could however be handy to use variables instead Besides using a Parameter as an SQL variable the parameters are also copied to the XML data so you can use the Parameters directly in the XSLT transformation as well Click the Parameters t
30. the location has sub locations the last known positions of all sub locations with a latitude and longitude tag will be displayed on the map as well without their tracking trails If a location has a heading tag the position marker will be displayed as an arrow pointing in the direction of the heading If quality parameters e g turbidity are assigned to the sub locations the color of the position markers will be displayed in yellow for a high or low limit violation and red in case of a high high or low low limit violation A marker will blink red in case one of the quality parameters of a particular sub location has aged out oo oy ee gt gt Nd oS Tags Map HE Recent gt Player x Charts Reports History Gl Assets E Comments The report has a o the following parameters a MAPTYPE 0 to display a roadmap or 1 to display a satellite view b ZOOM the GoogleMaps zoom factor or 0 to use automatic zoom c TRACKINGENABLED 0 to hide tracking or 1 to show if tracking positions are logged d TAGCODEOxx Tag codes of the quality parameters to be checked for limit violations e INTERVAL if set tag values will be displayed with INTERVAL seconds in between f TIMEOUT the maximum allowed age of a quality parameter in seconds O infinite ATTENTION gt GoogleMaps requires Internet access Page 39 of 60 HISTORY The History page shows the measurements over the select period of the tags
31. the locations must be deleted from the Deleted Items location as well You can move locations to other locations by dragging amp dropping File Edit Control About S8 58 8 a E Locations 2 C Hitcount P AAE Cuxhaven Netherlands a arem A Norden Brome E aa A Q Zona Centro a aie e Same Varel Castelo Bode Oost Vlieland 1 Westerstede 5 6 aa beer o Zona Norte een Boticas Leeuwarden Drachten w Pa a Bad Brem g ischenahn Curalha British Den Helder Heerenveen mite Folgosinho bles Tem npe sali re LOWER SAXONY C Fragas da Torre Horwich S Meppen Nelas k Alkmaar Hoorn eaa Vechta gen C Rebordelo Sean yi Zuid Lelystad Zwolle Pa x Vale Giestoso U K Almere ge Nor io briick in 5 Great Amsterda lle J Videmonte FERT ofmer ome die Zona Sul EA The Hague Utrecht j 9 recall iolofeld Herfordi Spail 9 gt M nster o pain 5 C amp New location Felixstowe o Bacal NORTH RHINE WESTPHALIA J Deleted tems je Hamm kanea hel k Paderborn on pore DE Park nenk el z Herne 2 Middelto a nent POrtmund Barer Margate F i Knokke Heist aoe isburg Essen Farmsber o 3 Bruges o o A Otten ame Koksijde Ghent tie Geef prices ladbach D sseldorf wat es alais Deinze reuzig u Tu ae ae Leuven eeren Cologne a ns HESSEN FRANCE a Lo Bilzen Ertstaot Siegen aa fattrelos Brassel Burb Boulogne sur Mer b T Halle B ye B
32. two columns 7imeOfMeasurement which can be used to bind to the Page 23 of 60 X axis of a Series and MeasuredValue that can be bind to the Y Axis of a series Note MeasuredValue is returned in the default unit of the parameter associated with the tag When creating a new chart Promis generates a chart with up to 8 default queries Each query results in a list of measurements over the selected period for one of the tags of the concerned location A default query looks as follows SELECT timeOfMeasurement MeasuredValue loLim hiLim MeasuredValue altunitfactor altunitoffset As AltValue LoLim altunitfactor altunitoffset As AltLoLim HiLim altunitfactor altunitoffset As AltHiLim FROM tags params measurements WHERE tags parID params parID AND tags tagID measurements tagID AND measurements tagID 8 AND timeOfMeasurement gt startOfPeriod AND timeOfMeasurement lt endOfPeriod This query retrieves also the measurements of the tag with TAGID 8 but it accomplishes it with some additional information Besides the measured value it returns the low and high limit values which is defined in the tags table It also returns the measured value in the possible alternative unit E g level measurements could be stored in meter but you want display them in liter The conversion info between default units and the alternative units is stored the params table Therefore the query uses three tables 1 the Measurements
33. 13 0x2003 48196 24 Wind Direction average 1 0 Gad Print Register Mappping Add Delete Change Start MODBUS Server After clicking Start MODBUS Server you can choose to run it as a Service or as an Application When started as a Service the first time the MODBUS Server will be installed as a system service System services will automatically start after re boot this assures that it starts running even after an un attendant re boot e g after a power failure When the MODBUS Server is running visible you can hide the MODBUS Server by clicking the close cross and a small icon in the Windows icon tray will occur right bottom corner Clicking this icon will pop it up again Properties Communication port Specify the serial communication port the MODBUS Server should listen at for incoming requests from a MODBUS RTU master Note MODBUS TCP and MODBUS RTU over TCP can be selected as well Baud rate The default baud rate is 9600 all other serial communication parameters are set to fixed values 8 data bits 1 stop bit no parity and no handshake Slave address The MODBUS Server does not have to be the only MODBUS RTU slave in the MODBUS RTU network Different slaves can be distinguished from each other by giving them all a unique slave address between 0 and 255 the default is 1 Page 57 of 60 Refresh map every Specify at which in
34. 3 hh Displays the hour with a leading zero 00 23 n Displays the minute without a leading zero 0 59 nn Displays the minute with a leading zero 00 59 s Displays the second without a leading zero 0 59 SS Displays the second with a leading zero 00 59 Displays the date separator character given by the DateSeparator global variable Displays the time separator character given by the TimeSeparator global variable xx xx Characters enclosed in single or double quotes are displayed as is and do not affect formatting Starting the Report Scheduler To enable the Report Scheduler select Start Report Scheduler from the Control menu You need a Report Scheduler license to be able to start the Report Scheduler The Report Scheduler is a service that will run in the background and keeps running even if you close Promis and will start running after a re boot automatically To stop the Report Scheduler select Stop Report Scheduler from the Control menu Page 38 of 60 Use GoogleMaps to display and track locations Promis comes with several report templates to visualize or report your data The GoogleMaps prd template can be used to display your locations as markers on GoogleMaps When the report is included in a location and the location has a latitude and longitude the last known position along with its logged tracking trail will be displayed on the map If
35. 40 gt lt startofperiod gt 2008 01 12T00 00 00 lt startofperiod gt lt endofperiod gt 2008 01 13T2 00 00 00 lt endofperiod gt lt location gt Compressor lt location gt lt locationpath gt Location A Site 1 Floor 1 lt locationpath gt lt params gt lt param name parX gt 100 lt param gt lt param name parY gt Some text lt param gt lt params gt lt datasets gt lt dataset name Air flow gt lt col name Cnt gt lt col name MinVal gt lt col name MaxVal gt lt col name AvgVal gt lt row gt lt Cnt gt 615 lt Cnt gt lt MinVal gt 517 lt MinVal gt lt MaxVal gt 798 lt MaxVal gt lt AvgVal gt 586 484 lt AvgVal gt lt row gt lt dataset gt lt datasets gt lt report gt XSLT Transformation If you use the report templates of Promis you probably don t have to worry about XSLT transformations But if you want to create your own reports you might need knowledge about XSLT transformations It is possible to define very complex transformations so it s possible to create very advanced reports Promis makes use of the Mircosoft MSXML component which even allows to incorporated scripting JavaScript en VB Script in your transformations The output format of a report can be flat text e g csv or XML based like HTML To learn more about XSLT transformations consult the web site of the World Wide Web Consortium W3C www w3c org Note When implementing an HTML report you
36. 800 00 Air Pressure 8 90 Bar 1 dec 2003 02 02 00 8 00 0 00 16 00 Air temperature 72 00 C 1 dec 2003 02 02 00 15 00 0 00 100 00 This sheet can be printed or saved or e mailed as an Excel compatible sheet PLAYER File Edit Control About HYG 8 oa m Player Y Axes 3 0 Location A jiw o i D Air FI be l is z Site 1 Left top Air FLow Right top Administration Left bottom Air FLow T Right bottom J Logistics TEn Vemeon 0 2f fen lt i 4 m eea xf H 3 Compressor Generator 27 sep 27 sep 27 sep 27 sep 27 sep 27 sep 27 sep Hall 2 22 00 22 05 22 10 22 15 22 20 22 25 22 30 Site 2 Site 3 Location B Location x Deleted Items 22 09 22 14 22 19 22 24 22 29 22 34 22 39 27 sep 27 sep 27 sep 27 sep 27 sep 27 sep 27 sep ajajalle S E Tags Map EE Recent p Player Ez Charts Reports 2 History The Player page is used to play back measurements in time With the Player measurements can be played back and forward in time The player chart is divided into two vertical parts which are having their own time axis and their own player controls Each vertical part has a left and right Y axis For each Y axis a tag associated to the selected location can be selected Because the same tag can be selected in the upper part as well as in the lower it is possible to compare measurements of the same ta
37. Create new database Tag v3 0 Precipitation Precipitation L Create new database Tag v4 10 1 Pyranometer Pyranometer ml Add Delete Load properties from file Save properties to file Cancel Previous Next Timestamp columns Each record to import should have a timestamp specifying the time at which the values in the row are acquired measured or recorded Please specify which column is used for the date part and which for the time part If the data and time parts are combined in one column then please specify the same column for both of them The example value taken from the first record row should show a valid date or time value Tag columns To be able to import the data of a column the column must be assigned to a Tag in the database You can select a corresponding tag from a list listing all the tags of the particular location If a corresponding tag is not in the list the Wizard can create one for you during import the new tag will be created with the Name Code and Unit as specified by you or taken from the import header rows When specified the right column the example value should show an expected value from the first record row NOTE It might be that the values in the import file are not in the expected engineering values matching the corresponding tag You can specify a factor offset and conversion table to convert the raw device values to expected engineerin
38. NNECT SYSTEM as SYSDBA 5 Enter your SYSTEM password yourPassword 6 Create a user for the promis database SQL gt CREATE USER promis IDENTIFIED BY yourPassword DEFAULT TABLESPACE USERS 7 Note The term DEFAULT TABLESPACE USERS is very imported otherwise all your data will be stored in the TABLESPACE SYSTEM which has limited space causing your database to bloat after 3 million measurement records 8 Grant rights to the user SQL gt GRANT CONNECT RESOURCE TO promis 9 Optional steps to prepare Oracle Express to allow online backup backup while the database is in use a SQL gt SHUTDOWN IMMEDIATE b SQL gt STARTUP MOUNT c SQL gt ALTER DATABASE ARCHIVELOG d SQL gt ALTER DATABASE OPEN e SQL gt ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE 16G 10 Start Promis and change the data source connection string to Provider OraOLEDB Oracle 1 Persist Security Info False User ID promis Data Source localhost 1521 xe 11 Specify as database credentials User promis and Password yourPassword Page 49 of 60 Database backup In case you don t make use of a sophisticated database server with features like database mirroring and automated backups it is recommend to regularly backup the database manually or automatically see Chapter Backup Service To backup your database manually select the backup option from the Promis File menu K Backup the database to file l 5 8 Dat
39. Period You may use the period variables startOfPeriod and endOfPeriod within the query Resulting data set These variables will automatically be set to the selected period of Promis timeOMeasurement_ MeasuredValue gt 30 11 2003 13 11 00 30 11 2003 13 12 00 30 11 2003 13 13 00 30 11 2003 13 14 00 30 11 2003 13 15 00 30 11 2003 13 16 00 30 11 2003 13 17 00 30 11 2003 13 18 00 30 11 2003 13 19 00 Query name Specify a unique name for the query Query code You have to specify a complete SQL SELECT statement You may use the parameters startOfPeriod and endOfPeriod to narrow the number of records in the Query to the selected period To select a period open the Period Selector from the Control menu Besides startOfPeriod and endOfperiod you can also use similar parameters rounded down or up to the nearest discrete time boundaries startDayOfPeriod startMonthOfPeriod startYearOfPeriod endDayOfPeriod endMonthOfPeriod and endYearOfPeriod Besides time parameters you may use the parameter locationID and any of your own defined Parameters see previous chapter A simple query could look as follows SELECT timeOfMeasurement MeasuredValue FROM Measurements WHERE tagID 8 AND timeOfMeasurement gt startOfPeriod AND timeOfMeasurement lt endOfPeriod This query retrieves the measurements of the tag with TAGID 8 over the selected period The list returns a table with
40. R 57 PROPERTIES 57 MESSENGER ALARM MANAGEMENT 59 INTEGRATED WEBSERVER 60 CUSTOMIZING 60 CROSS PLATFORM 60 Page 3 of 60 INTRODUCTION Promis is an application to organize view and visualize measurement data You can organize your data by location in a hierarchical structured tree You can define multiple tags per location which are used to register measurements on a o a tag for registration a room temperature Drag amp Drop can be used to move tags as well as locations to different positions in the hierarchical structure of course without losing the registered measurement history Locations tags instruments etc can be mapped on a background picture to create control panels dashboards and or graphic navigation Data can be printed saved and emailed in graphical jpg tabular xls and report html form Promis comes with an integrated Data Collector Manager to input measurements from data acquisition sources Features gt Define as many tags as required gt Time stamped tag values measurements can be collected automatically entered manually or being calculated using other tags as input gt Import measurements from flat text files manually a o csv files gt Data Collector Manager to collect measurements from multiple remote DAQ sources automatically Organize measurements by location in a hierarchical structure Assign view only users to locations they are permitted to consult
41. See chapter Calculation properties Display option At default a tag is displayed on the Recent values and History page for all granted users However some tags may not be that interesting to be displayed on a certain page and can therefore be marked as invisible for that particular page It s also possible to show the tag to a certain type of granted user while hiding it from another See chapter users Alarming If the Alarm Scanner is running see chapter Messenger checking the Alarming box will pass the alarms for this tag to the Messenger When exceeding a low or high limit a Warning will be passed to the Messenger When exceeding a low low or high high limit a Error will be passed to the Messenger To avoid bouncing alarms it is required to specify a hysteresis value Record rate Promis can report an Error if the value of a tag is not recorded in time Please specify a reasonable record rate If you specify the record rate to almost matching or higher than the real record rate alarming can become very nervous If you specify a low record rate it will take longer before you get notified about it Page 13 of 60 Name Table If you want to display measured values as texts instead of numbers you can define tables to map number ranges to texts Name tables can be edited via the Menu bar gt Edit gt Name Tables Collector Properties Tag properties Base properties Add
42. TN GSM MODEM communication The problem is that mobile internet devices mostly don t have fixed IP addresses and therefore not easily remotely accessible If the mobile device is smart enough it can use Dynamic DNS to link its dynamic IP address to a fixed domain name every time it connects to internet In that case the device should a maintain a Dyn DNS subscription b should be connected 24 7 to be remotely accessible c needs security provisions as it s TCP server is 24 7 online and accessible from anywhere Page 53 of 60 To solve the above situations the remote device should act as a TCP client and connect to the TCP server of the Collector Manager When connected the Collector Manager will use the appropriate collector driver to read out the remote device Because the remote device does not have to host a TCP server it can stay if it has sufficient power 24 7 connected without being vulnerable for hacker attacks Port The TCP port the Collector paint sto Manager should listen at You can TCP port 23 zl DAQ unit recognizers J Force read out on client connect and its preferable define the same DAG unitiD _ STATION1_AE762345 IT Disconnect client after read out port for a II you r col lecto rs with the When a TCP client connects and the related DAQ unit does not support ID recognition than the TCP client same d river type should first sent the DAQ unit ID string surroundig square brackets before pa
43. User Manual Promis Version 3 Jan 2015 CONTENTS CONTENTS 2 INTRODUCTION 4 FEATURES 4 MINIMUM SYSTEM REQUIREMENTS 4 OPERATION 5 LOCATIONS 6 LOCATION PROPERTIES 7 LOCATION MAP 8 USERS 9 USER RIGHTS 9 PARAMETERS 10 TAGS 11 BASE PROPERTIES 11 ADDITIONAL PROPERTIES 13 COLLECTOR PROPERTIES 14 CALCULATION PROPERTIES 15 TAG DATA 18 RECENT VALUES 19 PLAYER 19 CHARTS 21 DEFINING A CHART 22 DEFINING CHART QUERIES 23 VISUAL PROPERTIES 25 BINDING SERIES TO A QUERY 26 BINDING SERIES TO A FUNCTION 26 CHART DISPLAY PARAMETERS 27 General Chart Options 27 Axis Properties 28 Titles Properties 29 REPORTS 30 DEFINING A REPORT 31 DEFINING REPORT PARAMETERS 32 DEFINING REPORT QUERIES 33 XML DATA 34 XSLT TRANSFORMATION 35 DEFINING A REPORT SCHEDULE 37 USE GOOGLEMAPS TO DISPLAY AND TRACK LOCATIONS 39 VISUAL DATA EDITOR 41 SINGLE POINT MODE 42 RANGE OF VALUES MODE 42 DATA IMPORT WIZARD 43 DATA IMPORT WIZARD 43 FILE FORMAT 44 Page 2 of 60 COLUMN PROPERTIES 45 PREVIEW amp IMPORT 46 DATABASE 47 MS ACCESS 48 SQL SERVER 48 Installing SQL Server Express 48 ORACLE 11G 49 Installing Oracle 11g Express 49 DATABASE BACKUP 50 DATABASE STRUCTURE 50 DATA COLLECTOR MANAGER 52 COLLECTOR PROPERTIES 53 TCP server connection 53 BACKUP SERVICE 55 MODBUS SERVE
44. a power failure If a backup has to be made to a network shared disk this disk may not be available to every user Default the Service logs in as a System account If the System account has no rights to the shared network disk you could setup the service to logon as a different user with the proper rights This account Password Confirm password SomeUsed Browse Help me configure user account log on options Cancel Apply Page 56 of 60 MODBUS Server The MODBUS Server is used to turn a PC running Promis into an MODBUS RTU slave device The PC will by means of a serial port be connected into an MODBUS RTU network where a MODBUS RTU master can query for recent actual values of certain Promis tags To configure start the MODBUS Server please click from the Menu bar gt Control gt Start Promis MODBUS Server and the following screen will pop up z MODBUS Server Properties elaks Properties Communication port com4 v Baudrate 9600 v Slave address 1 5 Refresh map every 4000 j ms Expose values as Double QWORD IEEE754 64 bit v V Most Significant WORD first MODBUS Register Mapping Value Register Status Register Tag ID Tag Name Factor Offset 0x0000 40001 0x2000 48193 37 Weather Air Temperature 1 0 0x0004 40005 0x2001 48194 38 Weathe Relative Humidity 1 0 0x0008 40009 0x2002 48195 31 Wind Wind Speed average 1 0 0x000C 400
45. a removable media storage e g an USB stick In case of saving to a removable media the backup file will be saved to the removable media with the lowest Driver letter E g if two USB sticks are connected one with Driver letter E and one with F the backup file will be written to E As soon as a removable media is attached and the next backup schedule date was already reached the Service will immediately start to backup to the removable media When a backup to a removable media is completed the service will play the Windows confirmation sound or the Windows warning sound in case of an error Errors are logged to promisbackup log and also passed to Projex Messenger Delete old data To avoid that your database will reach its physical size limit you can specify that data older then a certain time e g 1 month 2 years etc should be deleted after a successful completion of the backup operation Starting the Backup Service After closing the properties screen you can choose to run the backup utility as a Service or as an Application When started as a Service the first time the Backup Service will be installed as a system service System General Log On Recovery Dependencies Log on as C Local System account J Allow service to interact with desktop services will automatically start after re boot this assures that it starts running even after an un attendant re boot e g after
46. ab to list all the defined Parameters Click the Add button to create new Parameters You may define as much Parameters as required To modify or delete an existing Parameter select the Parameter from the list and click the Delete or Change button A Parameter should have a name and a value The name may only contain alphanumeric tokens and the underscore token _ The name may not start with a numeric digit The value can be of type string integer or floating point To use a Parameter within an SQL query or in the XSLT text enter its name preceded with a colon token For instance if the name of a Parameter is x then x should be referred to in a query as x Page 32 of 60 Defining report queries The XML data needed to construct the contents of a report has to be extracted from the database Promis uses SQL queries to extract data from the database The meaning of a query is to retrieve a list of records from a database according to defined search criteria In the context of Promis the result of a query forms a collection of XML data Consult chapter XML data to see how the XML data will look like Chart properties iof x Query name fai flow Query code SELECT timeOfMeasurement Measured alue FROM measurements WHERE tagID 8 AND timeOfMeasurement gt startOfPeriod AND timeOfMeasurement lt endOfPeriod You may use the period variables startOfPeriod and endOfPeriod within the query Resultin
47. abase backup file e TEMP testbackup mdb E V After Backup Delete measurement data older then e f months x The deleted measurement data still exists in your backup file Start Close K Ms Access You can back up the database to or restore from ms access files mdb SQL Server You can back up the database to SQL server backup files bak and restore from SQL server backup files as well as ms access files The purpose of restoring from ms access files is to setup your initial database from an ms access template database Oracle You can t backup or restore your database from Oracle backup files please use the backup restore tools that comes with Oracle You can however setup your initial database by restoring from an ms access template database Attention 1 When backing up the entire backup database will be cleared and all existing data tables and indices will be erased After a successful backup the backup database will be an exact copy of the original database When using the default backup database you can copy the promisbackup mdb file to where ever you like in order to archive consecutive backups If you want to consult the data of an old backup you could install a free version of Promis on another system and Restore the backup on that system Attention 2 To avoid that your database will reach its physical size limit you can specify that data older then a certain time e g 1 month 2 years
48. associated to the selected location in tabular form It also includes a summary at the bottom of the sheet TimeStamp Air flow Air Pressure Air temperature m h Bar C 1 dec 2003 01 51 00 583 00 8 90 72 50 1 dec 2003 01 52 00 594 00 8 90 72 60 1 dec 2003 01 53 00 590 00 8 90 72 70 1 dec 2003 01 54 00 551 00 8 90 72 40 1 dec 2003 01 55 00 550 00 8 90 72 20 1 dec 2003 01 56 00 564 00 8 90 72 20 1 dec 2003 01 57 00 565 00 8 90 72 30 1 dec 2003 01 58 00 570 00 8 90 72 40 1 dec 2003 01 59 00 567 00 8 90 72 40 1 dec 2003 02 00 00 549 00 8 90 72 40 1 dec 2003 02 01 00 526 00 8 90 72 20 1 dec 2003 02 02 00 544 00 8 90 72 00 Count 772 772 772 Minimum 517 00 8 80 62 50 Maximum 883 00 9 20 79 20 Average 623 409 8 915 73 282 Quantity Std Dev 98 733 0 049 2 089 Variance 9748 00 004 This sheet can be printed or saved or e mailed as an Excel compatible sheet Page 40 of 60 Visual Data Editor Mostly the measurement data stored in the database is automatically collected without any human intervention It could however that those measurements are not what they supposed to be because of equipment malfunctioning or any other exceptional reason The Visual Data Editor can be used to manually correct your measurements quick and easily in a graphical manner Each location has its own Editor To pop up the Editor select a location from the Loc
49. ateTime y MeasuredValue 7 T DateTime Binding Series to a Function With the Chart Editor on the first Chart page click the Add button to add a new Series to the Chart In the Series Gallery choose the Functions tab to select the Function you require Each Function is presented as a Line Series you may change the Series Type associated with the Function later by clicking the Change button on the first Chart page Function definitions are easily changed afterwards on the Data Source page of the Function Series Editing x Using the Chart Editor after adding a Function opat Series the Function Series Data Source page will Source page wil Se i show a list of available Series for inclusion in 55 ax lina Sees the Function definition Here you may change Feimat General Marks Data Source the Function Type you wish to apply to the Funcion x Series and select Series from the Available list r Function Average 7 and add them to the right Selected list M Source Sq Moving Average Pr Ave age Page 26 of 60 Chart Display Parameters Chart display features are those which affect the overall appearance of the Chart They include those properties and methods that define the color of the Chart background Titles and their position margins borders and bevels background images frame and axis visible pen colors and widths 3D walls etc
50. ation list and select Visual Data Editor from the Edit gt Locations or pop up menu To edit data administrator or supervisor rights are required Visual Data Editor 5 x Reference Tag Temperature Location A Temperature M M Original ae ia M Data line eee ie Tag to edit e pA 15 N SEER 7 amer Remove Add 1 Curso z 39 Mar 2009 15 22 30 0 14 00 00 00 02 00 00 04 00 00 06 00 00 08 00 00 10 00 00 12 00 00 14 00 00 16 00 00 18 00 00 20 00 00 22 00 00 00 00 00 Base line pit 3 Mar 3 Mar 3 Mar 3 Mar 3 Mar 3 Mar 3 Mar 3 Mar 3 Mar 3 Mar 3 Mar 3 Mar 4 Mar fe 3 Mar 2009 14 07 30 EE a Tr lala 31 37 K A kaS ES S mode Single point Range of values Range is determined by the start amp end time of the Base line i i Delete below base line Follow base line Follow reference Merge from reference Restore from original Cancel OK Before you can edit measurements of a tag you have to select the tag from the Tag to edit list When a tag is selected the originally collected data will be displayed as a blue line and the modified current measurements as a purple line the data line Only the data points of the data line can be modified When you are done modifying verifying a tag and want to continue to the next you can either select the next tag with your mouse or by clicking the Alt amp Down arrow keys
51. ations a licensed database server should be used e g SQL Server 2012 Web Edition or Oracle 11g Standard Edition To prevent your database from overloading you can 1 Regularly backup the database see chapter Database backup and delete old data in order to create space for future records 2 Specify in the conversion amp logging properties of a tag that you automatically want to delete the measurement records of the concerned tag if they are older than a certain amount of days Note Ms Access can t reach the 45 million measurements record limit without regular database maintenance as Ms access does not free temporarily used disk space and is vulnerable for unexpected power outages as well You should perform a Compact Repair database at a regular bases to reclaim unused disk space or to try to recover from odd database behavior SQL Server When using SQL Server Express the physical database size is limited to 10GB and therefore the maximum number of measurement records that can be stored is approximately 120 million When logging only one tag with a frequency of 1 measurement per minute you will be capable to log for 225 years before the database reaches its limits This looks long but if you log 225 tags once per minute the database will reach its limits within 1 year To avoid these limitations a licensed SQL Server database server should be used e g SQL Server 2012 Web Edition To prevent your database from over
52. cation list and select Granted Users from the Edit gt Locations or pop up menu and the following window will pop up Page 9 of 60 Granted Users Access Right User Name Full Name Access Denied aLi CE Alice Aliceson Visitor View only John Johnson Paul Paulson Peter Peterson te There are five types of access rights 1 Access Denied the user is not allowed to see access the location 2 Visitor The user is allowed to see access the location 3 Operator The user is allowed to see access the location and if applicable able to enter measurement values e g enter a manually measured temperature 4 Supervisor same as Operator but has rights to change set points 5 Administrator An Administrator has access rights to all locations and cannot be denied or granted access to an individual location An Administrator has the right to configure the application create delete modify reports charts tags locations etc For each tag report chart or asset an Administrator can define if it should be visible to visitors operators or supervisors So Confidential data of a certain location can be visible for a Supervisor and hidden for a Visitor PARAMETERS Parameters can be used to line up similar tags with a common name and a common unit Assume you have to measure a flow at several locations In this case you could de
53. cific axis Custom Axis Custom Axis can be added or removed by clicking the or button below the Axis list This can amongst other be used to create stacked Y axes Assume you want to have two stacked Y axes Click the button and click the Position Tab and define a Start value of 52 and an End value of 00 Click the button again and define a Start value of 0 and an End value of 48 The second axis is stacked above the first To become visible the axes must be bound to one or more Series See the General Tab of a Series Properties page Page 28 of 60 Titles Properties The Titles page of the Chart Editor controls the characteristics of the Chart Titles Header and Footer Measurements 24 x Chart Series Data Tools Export Print Series General Axis Titles Legend Panel Paging Walls 30 Title ad Style Position Format Text Gradient Shadow W Visible J7 AdjustFrame Alignment Text Measurements C Left Center C Right The following types of Titles are used 1 Title positioned above the chart The default value of Title equals the chart title as defined within Database Properties The user may overrule the chart title 2 Sub Title positioned below the Title is used by Promis to show the selected Query parameters The user can t overrule the text but is able to make it invisible
54. e Edit button to edit either the single selected record or all graphically marked records The following operations are possible 5 6 7 Set the value s of a single record or all marked records to a fixed value Multiply the existing value s of a single record or all marked records with a certain factor Add an offset to the existing value s of a single record or all marked records Add an offset slope to the existing value s of a single record or all marked records The slope is linearly scaled over the graphically marked period So a record in the middle of the marked period will be added with an offset equal to a half of the difference between the minimum and maximum slope value Convert the value s of a single record of all marked records by using a conversion table Conversion tables can be edited via the Menu bar gt Edit gt Conversion Tables Delete a single record or all marked records Restore a single record or all records within the marked period from an archive with original values AS soon as a record is modified deleted for the first time its original value will be archived Note following modifications will not alter the originally archived value Page 18 of 60 RECENT VALUES The Recent page shows the most recent values of the tags associated to the selected location in tabular form Tag Value Unit Timestamp Target Low Limit High Limit Air flow 544 00 m h 1 dec 2003 02 02 00 500 00 400 00
55. e 11g When using Oracle 11g Express the physical database size is limited to 11GB and therefore the maximum number of measurement records that can be stored is approximately 125 million When logging only one tag with a frequency of 1 measurement per minute you will be capable to log for 235 years before the database reaches its limits This looks long but if you log 235 tags once per minute the database will reach its limits within 1 year To avoid these limitations a licensed Oracle database server should be used e g Oracle 11g Standard Edition To prevent your database from overloading you can 1 Regularly clean up the database File menu gt Database gt Clean up by deleting old data in order to create space for future records 2 Specify in the conversion amp logging properties of a tag that you automatically want to delete the measurement records of the concerned tag if they are older than a certain amount of days Installing Oracle 11g Express 1 From Oralce com download and install Oracle 11g Express During installation you are asked to specify a password for the SYSTEM account Please note and don t forget it For now we assume the password is yourPassword 2 From Oracle com download the 32 bit Client Software as well and install the Oracle OLEDB driver 3 Start the Oracle SQL command prompt C oraclexe app oracle product 11 2 0 server bin sqlplus exe nolog 4 Login to Oracle SQL gt CO
56. e tag to the Deleted Items location Deleted tags are transferred to the Deleted Items location To delete tags forever the tags must be deleted from the Deleted Items location as well You can move tags to other locations by dragging amp dropping You can change a tag s order in the list by clicking the Ctrl amp Up arrow or Alt amp Down arrow keys simultaneously The order of the list is applicable to the Recent values amp History pages as well Base Properties lolx Base properties Additional properties Collector properties Tag code Tag ID BUFFERTANE Tag name Buffer Tank Tag description Parameter Type Decimals Flow x Level 2 Target value setpoint Minimum range Maximum range 50 neh jo 100 Low Low limit Low limit High limit High high limit fio fi 5 25 30 Remarks Page 11 of 60 A tag has a o the following base properties Tag code As accomplishment to the name a tag can have a code the meaning of this code is up to the user Tag name Each tag should obviously have a name Tag ID The tag ID is automatically generated by Promis The TagID is used to uniquely identify a tag The TagID can be used in site report and chart queries The TagID is also very important when importing measurements into the database Measurements are stored in the Measurements table this table has three fields Field name
57. ed and XML files The following content types are most commonly used a text html HTML pages b text plain Flat text files Page 31 of 60 c text csv CSV files d application vnd ms excel XML based Excel sheets e application vnd openxmlformats officedocument wordprocessingml document Office Open XML Spread sheet Display option At default a report is displayed to all granted users However it s possible to show a report to a certain type of granted user while hiding it from another See chapter users Note The option Passer by can be used to display the report on the Map page only if a user has no access rights to the location hosting the report but is passing by during navigating to under laying sub locations Packaged Report A packaged report is an archive file in ZIP format containing a collection of XML files e g an Office Open XML document A packaged report originally created designed in an external program e g Microsoft Excel 2007 can be imported in Promis and Promis can update the contents of the packaged report by replacing one of the XML files in the package The edit box File name in package is used to specify which XML file in the package should be replaced with the result of the performed XSLT translation Display report as instrument A report looking like an instrument e g a temperature gauge can be displayed on the Map page A refresh rate can be specified to automatically refresh
58. es per period e g a rolling average C One aggregated value per period centered in time window C One aggregated value per period right aligned in time window The result of the default calculation script is 4 multiplication of the average or instantaneous values of all input tags A calculation is triggered as soon as a value on one of the input tags is registered by an integrated data collector r Conversion Table In addition the value calculated by the script can be passed thru a conversion table e g to convert from a level to a volume based on the shape of a tank None 1 1 x OK E Cancel Input Tags Calculation Script For a calculated tag the measured value is calculated from the measured values of other tags As soon as one of these input tags is recorded a calculation is triggered and a query is performed to get the recent values of all the input tags This can be either the most recent instantaneous recent values or the most recent values aggregated over a certain aggregation period The aggregated value e g an average can be calculated over all values or over a portion Median span of the values with the Median as center If the aggregation period is set to 00 00 00 then the actual aggregation period is dynamic and will be set to the time between two successive registrations e g to calculate the delta count between two counter registrations Page 15 of 60 Aggregation
59. essenger is installed alarms high or low limit violations or if values are not recorded in time can be passed to the Messenger which takes care of dispatching the alarm to the right person A license free version of the Messenger supports the dispatching of alarms to at max 4 different recipients Alarms can be send via e mail SMS GSM Modem required or to other PC s running Messenger Passing alarms to the Messenger is switched off by default To enable passing of alarms to the Messenger select Start alarm scanner from the Control menu The Alarm scanner is a service that will run in the background and keeps running even if you close Promis and will start running after a re boot automatically To stop the Alarm scanner select Stop alarm scanner from the Control menu The Messenger is provided with a hierarchical fallback mechanism to ensure that alarms are being noticed Messages can be introduced in the system at different levels When a message is introduced at a certain level a list will be built of all recipients DSSS Pe assigned to that level and who are scheduled at that time The message will be sent to the first recipient in the list which must respond within a certain amount of time If he does not respond in time the message will be sent to the next recipient etc If nobody has responded at all the list can be tried again and again If still nobody has responded then the non sched
60. etc should be deleted after a successful completion of the backup operation When using Ms Access you should perform a Compact Repair afterwards to let Ms Access free unused physical disk space Database structure The database exists out a lot of table of which most are meant for visualization and organization of the data Normally a database administrator DBA does not have to bother about this structure as it is maintained by Promis itself In case of a corporate database server all the DBA has to do is create and empty database and assign a database user with full rights to Promis Filling the database is performed by Promis data collectors which are aware of the database structure Filling the database with non Promis data collectors is possible but not advised as they could cause corruption of the internal organization Page 50 of 60 Reading historical data from the database is easy as all collected measurements are stored in just one table named measurements The measurements table contains records with just three fields 1 2 3 TAGID an integer identifying the ID of the tag of a recorded value TIMEOFMEASUREMENT a date time value specifying the time at which a value is recorded by the data acquisition source MEASUREDVALUE a floating point value representing the value recorded by the data acquisition source at the given TIMEOFMEASUREMENT Information about what is measured and where measureme
61. fine a parameter named flow with unit m3 h For each location you define a measurement tag for flow registration and you associated all these tags to the same parameter To edit parameters select Parameters from the Edit menu and the following window will pop up Parameters O x Name Unit Description Add Flow Level Delete Pressure Relative Humidity Clone Temperature Wd A parameter should have a unique code name and a unit Parameter properties 5 x Parameter name Parameter ID j2 Parameter code Unit default TEMP fe OK Parameter description Page 10 of 60 TAGS File Edit Control Help Boe T shld ao ae dec 2003 3 10 14 E Locations ic Ga Location A Site 1 F ie Pressure Sample cs 7 at Air temperature Sample PE 15 0 100 2 Generator Heatexchanger FA Flanr 2 You can define several tags per location To define a new tag select New tag from the Edit gt Tags menu or from the menu that pops up when you click the right mouse button To edit an existing tag select the tag from the Tags list and select Properties from the Edit gt Tags or pop up menu To delete an existing tag select the tag from the Tags list and select Delete from the Edit gt Tags or pop up menu Deleting a Tag is also possible by dragging th
62. from the Menu bar gt Control gt Start Promis Collector Manager and the following screen will pop up Collector Manager Properties gt M Unlock code 34786944 4 Collectors Collector Name Driver Name Read out Interval Connection Properties Change DATACOLLECTOR 1 DAG_MODBUS h days TYPE 528 Clone gt Delete 4 Start Collector Manager Depending of the type of DAQ source one collector can behave more intelligent then another For instance if a DAQ source has the capability to provide the collector with device tag channel info then the collector manager is capable to automatically create a Promis location and assign Promis tags to device tags channels If the DAQ source cannot provide the collector with proper device tag channel info e g a generic MODBUS device Then a Promis location should be created and bound to the collector manually and Promis tags must be linked to their corresponding device tags channels manually as well However locations and tags may always be bound manually It is allowed to link multiple Promis tags to the same device tag channel and bind multiple Promis locations to the same DAQ source After clicking Start Collector Manager you can choose to run it as a Service or as an Application When started as a Service the first time the Collector Manager will be installed as a system service
63. fy the character that is used for the Decimal separator in floating point numbers The Wizard can be used to import numbers only but it could be that the file contains text columns as well Text columns are normally because they could contain tokens equal to the Field separator enclosed between Text markers Please specify which character is used as the Text marker Date Time format Timestamps can be notated in several formats please pick a matching format from the list or edit one yourself Use the following characters for the date part y year m month d day and use the following characters for the time part h hour n minute s second You can specify a Time zone offset in hours in case the timestamps in the file are not matching your time zone This offset is added to the imported timestamps Row settings A file may start with one or more header rows giving info about the process generated the file and or describing the columns in the file 1 Names row a row specifying a name for each column Set to 0 if such a row does not exist 2 Codes row a row specifying a code for each column Set to 0 if such a row does not exist 3 Units row a row specifying a unit for each columns Set to 0 if such a row does not exist 4 First record row the row in the file where the first data record starts 5 Last record row a file may contain one or more footer rows giving info about the process
64. g data set These variables will automatically be set to the selected period of Promis E timeO Measurement gt 30 11 2003 13 11 00 30 11 2003 13 12 00 30 11 2003 13 13 00 30 11 2003 13 14 00 30 11 2003 13 15 00 30 11 2003 13 16 00 30 11 2003 13 17 00 30 11 2003 13 18 00 30 11 2003 13 19 00 Click the SQL tab to list all the defined SQL queries Click the Add or Clone button to create new SQL queries You may define as much queries as required To modify or delete an existing query select the query from the list and click the Delete or Change button Query name Specify a unique name for the query This name will be used as the name in the XML Dataset lt dataset name query name gt Query code You have to specify a complete SQL SELECT statement You may use the parameters startOfPeriond and endOfPeriod to narrow the number of records in the Query to the selected period To select a period open the Period Selector from the Control menu Besides startOfPeriod and endOfperiod you can also use similar parameters rounded down or up to the nearest discrete time boundaries startDayOfPeriod startMonthOfPeriod startYearOfPeriod endDayOfPeriod endMonthOfPeriod and endYearOfPeriod Besides time parameters you may use the parameter locationID and any of your own defined Parameters see previous chapter A simple query could look as follows
65. g in time Page 19 of 60 The player control has the following buttons 1 De a Fast play back when clicking this button several times the play back speed toggles from 2x 4x 8x to 16x Play back with 1x speed Stop Terminates play back When play back is on hold the scroll bar can be used to position the view port Play Forward with 1x speed Fast Play Forward when clicking this button several times the play forward speed toggles from 2x 4x 8x to 16x To define the total play back period select the Period Selector from the Control menu Within the total period a View port can be defined ranging from 1 minute to many days Normal playing speed 1x equals 1 view port per 10 seconds Page 20 of 60 CHARTS File Edit Control About A234 Aza 27 sep 2004 27 sep 2004 Compressor 22 00 00 22 59 59 Locations Location A I Site 1 Administration C Logistics 2 0 Production a Hal 1 3 Compressor C Generator 4 H i Hall 2 i i i i i j i i i j i J Air FLow mh Site 2 j Air Pressure Bar Site 3 i H i i 1 i I Air Temperature C 2 Location B a i Gaus yy iia i es al a 1 i i as ies ae 2 Location x Deleted Items 22 00 22 05 22 10 22 15 22 20 22 25 22 30 22 35 22 40 22 45 22 50 22 55 Gy Tags Q Map EE Recent P Player fe Charts E History The Char
66. g units If you select an existing tag from the database the factor offset and conversion table settings will be copied from the corresponding tag If however the values in the file are already in the expected engineering units set factor to 1 offset to 0 and conversion table to none When done click the Next button to go to the Preview page Page 45 of 60 Preview amp Import i Se Po 3 Import Data Wizard a Import file CATEMP 1 092411 TXT Raw data File format Column properties Preview Timestamp Precipitation Pyranometer dd mmm yyvyy t t Pyranometer j 22 jul 2010 09 48 00 o 0 1 fi 22 jul 2010 09 57 57 10 0 5 22 jul 2010 10 06 06 11 0 1 22 jul 2010 10 18 00 12 0 2 22 jul 2010 10 32 00 12 0 4 22 jul 2010 10 51 00 13 0 4 22 jul 2010 10 55 00 14 0 2 22 jul 2010 11 04 00 15 0 3 22 jul 2010 Load properties from file Save properties to file Cancel Previous Import After specifying the correct import properties the Preview page should display a tabular preview of the selected data you want to import If the Preview page appears without any errors and you have verified that the data is matching your expectations you can start the actual import process by clicking the Import button Importing can take a few minutes depending of the amount of data to be imported Page 46 of 60 DATABASE Promis deploys an open database
67. gin screen If estau a user forgets its password only an Webserver root location administrator can reset the password TEST Phone If the user is not an Administrator you can ok specify a date at which the account maiadaress expires this might by handy for temporary Cancel accounts when hosting the Webserver If you are hosting a webserver it could be that you want to have different web appearances for different groups of users and this can be accomplished by assigning different webserver profiles See the Webserver chapter for more info regarding webserver profiles If the first location applicable to a user is deep down the hierarchic location tree then it might be handy to specify a webserver root location for this user so you don t have to bother him with uninteresting upper parent locations User rights Default a new user has no rights to see any of the locations in the locations tree However it s possible to grant access to certain locations When a user is denied access to a location he can t access see that location and underlying sub locations unless access is granted for an underlying location When a user is granted access to a location he can access see that location and underlying sub locations unless access is denied for an underlying location To Deny Permit certain users to access a location and underlying sub locations select the location from the Lo
68. ginal report shared to by clones can t be permanently deleted and when you try it will stick in the root of the trash can location Page 30 of 60 You can change a report s order in the list by clicking the Ctrl amp Up arrow or Alt amp Down arrow keys simultaneously Defining a report olx Report name Display to Description Report gt 4 L Anybody ji C Visitors Content Type Operators tert html z M Administrators C Nobody z width 400 aj Height 400 Refreshrate 60 Sec File name in package HY Display report as instrument on the Map page Packaged report e g Office Open XML E Parameters Esa 2 xMLPreview gxsir Report Preview GY Schedule Refresh Parameter Value Description Add Import COLORALARM red Alarm color low low amp high high limit violations COLORDISCHARGE blue Discharge color Delete Beie COLORHINT blue COLOROUTLINE FFA500 Outline color of tank ae COLORRECEIVE yellow COLORREST green Status rest color COLORTEXT navy Text color 1 Parameters can be used as variables within your SQL queries To use a Parameter within a query enter its name preceded with a colon sign Using Parameters within queries is not obligatory 2 The Parameters are included in the XML data as welll er Cancel Note Knowledge of SQL HTML XML and XSLT transformation is required
69. gs Other specifiers such as refer to locale specific strings from global variables Page 55 of 60 In the following table specifiers are given in lower case Case is ignored in format specifiers Specifier Displays d Displays the day as a number without a leading zero 1 31 dd Displays the day as a number with a leading zero 01 31 ddd Displays the day as an abbreviation Sun Sat using the strings given by the ShortDayNames global variable dddd Displays the day as a full name Sunday Saturday using the strings given by the LongDayNames global variable m Displays the month as a number without a leading zero 1 12 If the m specifier immediately follows an h or hh specifier the minute rather than the month is displayed mm Displays the month as a number with a leading zero 01 12 If the mm specifier immediately follows an h or hh specifier the minute rather than the month is displayed mmm Displays the month as an abbreviation Jan Dec using the strings given by the ShortMonthNames global variable mmmm Displays the month as a full name January December using the strings given by the LongMonthNames global variable yy Displays the year as a two digit number 00 99 yyyy Displays the year as a four digit number 0000 9999 Save backup to Specify the location where a backup file should be saved to this can be a fixed location on a network disk or this could be
70. itional properties Collector properties COLLECTOR 1 Collector tag properties used by a collector to address this tag JREGTYPE 38DATATYPE 1 amp REGADR 1 M Conversion from device units to engineering units Eng unit conversion able dey unit factor offset Factor Offset ConversionT able fi fo None 1 1 7 J Reciproke Eng unit conversionT able 1 dev unit factor offset A tag has a o the following collector properties Collector tag properties If a Promis location is bound to a Data Collector then tags assigned to this location can be linked to tags channels of the DAQ source How a Promis tag can be linked is very specific and is dependent of the type of DAQ source The collector tag properties can be entered manually but you will need to be an expert By clicking the button you can pop up a DAQ Source specific properties editor that will 7 Properties help you to specify the right properties In the ModBus register ype HOLDING 3 example beside the Promis tag is linked to a register in a MODBUS device ModBus data type shor 2 byte x ModBus register address fi zj Cancel Some DAQ source are not recording physical values in their right engineering units but in raw ADC values For instance a temperature ranging from 30 to 70 C could be recorded as an ADC value ranging from 0 4095 By supplying a factor and an offset the ADC
71. l and txt format The list contains a o the following instrumentation reports angular gauge linear gauge tank gauge pie gauge compass and a traffic light The standard report displays the measurement history of the selected tags in tabular form over the selected period To define a new report select New report from the Edit gt Reports menu or from the menu that pops up when you click the right mouse button To edit an existing report select the report from the Reports list and select Properties from the Edit gt Reports or pop up menu To delete an existing report select the report from the Reports list and select Delete from the Edit gt Reports or pop up menu Deleting a Report is also possible by dragging the chart to the Deleted Items location Deleted reports are transferred to the Deleted Items location To delete reports forever the reports must be deleted from the Deleted Items location as well You can move reports to other locations by dragging amp dropping Note 1 If you create new reports by cloning it from others or by cloning a location containing reports the clones and original report will share their queries and XSLT If you change a query or the XSLT within a clone or the original your changes will be applied to all clones and the original as well You can of course unshare a clone from others and the original report as well An ori
72. llery If after selecting a Series type now you wish to change it later you may do so with a few exceptions where Series data content may be incompatible by returning to the first Editor screen and selecting the Change button i Series Data Tools Export Print Series General Axis Titles Legend Panel Paging Walls 3D Series Standard Financial Other Stats Extended Line Bar Horiz Bar Area Delete TeeChart Gallery itle Clone eeke Change Point Fast Line Horiz Line Bubble 0 Shape amp e 000 Page 25 of 60 Binding Series to a Query To bind a Series to a Query you have to take the following steps 1 From the Chart Editor click the Series tab and select the appropriate series name 2 From the Series tab click the Data Source tab and select Dataset from the first selection list 3 Select the appropriate Query from the Dataset list Consult the chapter Defining Queries to see how Queries can be defined 4 Specify which fields from the Query should be used as the Series points X Y and Z values and labels Edit chart properties 29 x Chart Series Data Tools Export Print airflow o bax Line Air flow Format Point General Marks Data Source Dataset xl Dataset ChartPropDlg Q1_Air_flow Ne Apply Labels imeOfMeasurement 7 ftimeO Measurement V D
73. loading you can 1 Regularly backup the database see chapter Database backup and delete old data in order to create space for future records 2 2 Specify in the conversion amp logging properties of a tag that you automatically want to delete the measurement records of the concerned tag if they are older than a certain amount of days Installing SQL Server Express 1 From mircosoft com download and install SQL Server Express with tools When asked for during installation choose Express and not LocalDB 2 Start the SQL Server Management Studio connect to your local database engine lt computer name gt SQLEXPRESS using Windows Authentication 3 In the Object Explorer right mouse click Databases and click New database and give the database a name e g YOURDATABASE 4 In the Object Explorer right mouse click Databases gt Logins gt sa and click Properties 5 Select the General page choose SQL server Authentication and specify a password for the sa login e g yourPassword 6 Select the Status page enable the login and grant it connect permission 7 Start Promis and change the data source connection string to Provider SQLNCLI11 1 Integrated Security Persist Security Info False User ID sa Initial Catalog YOURDATABASE Data Source SQLEXPRESS 8 Specify as database credentials User sa and Password yourPassword Page 48 of 60 Oracl
74. measuring e g Temperature TAGCODE a user defined code to specify what is measured e g TEMP_C VOLUME_M3 etc To make querying for tags of interest easy you could agree upon a certain codification e g TEMP_C for Temperature in C MINRANGE MAXRANGE floating points giving the minimum and maximum range of the measured values e g 30 to 70 C LOLIM LOLOLIM HILIM HIHILIM floating points giving the low low and high high limits of the measured values Example query a query to get all temperature TEMP_C readings from all refrigerators FRIDGE_ between Aug 12 2013 10 00 and 11 00 could look like SELECT LOCCODE TAGCODE TIMEOFMEASUREMENT MEASUREDVALUE FROM MEASUREMENTS TAGS LOCATIONS WHERE LOCATIONS LOCCODE like FRIDGE_ AND TAG LOCID LOCATIONS LOCID AND TAGS TAGCODE TEMP_C AND MEASUREMENTS TAGID TAGS TAGID AND MEASUREMENTS TIMEOFMEASUREMENT gt 08 12 2013 10 00 00 AND MEASUREMENTS TIMEOFMEASUREMENT lt 08 12 2013 11 00 00 Page 51 of 60 DATA COLLECTOR MANAGER The Data Collector Manager is used to input measurements from Data Acquisition sources like OPC servers XML servers serial devices and text files Promis comes standard with drivers for MODBUS SMS ASCII OPC and XML To configure start the Data Collector Manager please click
75. most recent values of the selected location Player playing back measurements in time Charts showing custom defined charts Reports showing custom defined html reports History showing measurements of the selected location in tabular form DON Ole ON From the File menu the contents of the right window can be printed saved to file or send by e mail From the Edit menu parameters users locations tags and charts can be added deleted and modified From the Control menu you can pop up the Period selector to define over which period you want to consult the measurements and the Search dialog to search for locations Page 5 of 60 LOCATIONS You can organize your measurement data by location in a hierarchical structured tree To define a new location select New location from the Edit gt Locations menu or from the menu that pops up when you click the right mouse button To edit an existing location select the location from the Location list and select Properties from the Edit gt Locations or pop up menu To delete an existing location select the location from the Location tree and select Delete from the Edit gt Locations or pop up menu Deleting a Location is also possible by dragging the location to the Deleted Items location Deleted locations are transferred to the Deleted Items location To delete locations forever
76. nts are taking place is stored in the tables tags and locations A location specifies where measurements are taking place The locations table contains records with multiple fields but just three of them are of interest when reading historical data 1 2 3 LOCID an integer value to uniquely identify each location this ID is automatically generated by Promis or its data collectors at initial creation of the location LOCNAME a user defined readable string representing the name of the location LOCCODE a user defined string to uniquely identify a location by the users own codification e g TANK_001 FRIDGE_005 etc Not all locations have to host measurements as some of them can be meant for hierarchical organization only To make querying for locations of interest easy you could agree that the LOCCODE of all locations hosting actual measurements are starting with a certain prefix e g TANK_ A tag specifies what is measured e g temperature flow etc The tags table contains records with a lot of fields but just a few of them are of interest when reading historical data 1 2 3 LOCID an integer value to identify the location where the measurements are taking place TAGID an integer value to uniquely identify each individual tag this ID is automatically generated by Promis or its data collectors at initial creation of the tag TAGNAME a user defined readable string representing what you are
77. ocation s station code or the identification at the site of the source will break the link between them Page 7 of 60 Location map If a location has child locations they can be projected on the map as blue labels Clicking the labels will jump to that location If a location has tags they can be projected on the map as well It s also possible to place instrumentation reports e g an angular gauge charts and digital assets e g a logo picture on maps to construct instrumentation dashboards or control panels Location map with background picture bmp gif or jpg Angular Gauge a ely S Location 1 d 5 oe Load picture Location 2 at sd i s Q jl Eit in Map aiia 7 a 4 t Original Size aye item Positions r H Map Item Positions Chart Chart Report Angular Gauge Tag Tag1_ Tag Tag 2 Location Location 1 Location Location 2 n Map Size The size of the Map in pixels if the size of the map exceeds the size of the screen scroll bars will be added automatically Backgroud Each location can have its own background picture bmp jpg or gif however it s not obliged and does not have to cover the complete map You can specify a background color for the map area that is not covered by the background picture Positioning Items the background picture Location Tag labels instrumentation reports charts or digital asset
78. oft Jet 4 0 OLE DB Provider Provider Microsoft Jet OLEDB 4 0 Data Source c Projex promis database promis mdb In case your MS access file got too big or corrupted you can try to compact repair it by clicking the Compact Repair button SQL Server Microsof OLE DB Provider for SQL Server s Provider sqloledb Data Source lt Server gt Initial Catalog lt Database gt SQL Server SQL Native Client preferred if installed on your system Provider SQLNCLI 1 Data Source lt Server gt Initial Catalog lt Database gt Oracle 11g Express oracle Provider for OLEDB Provider OraOLEDB Oracle 1 Persist Security Info False User ID promis Data Source lt Server gt 1521 xe Oracle 1ig Oracle Provider for OLEDB Provider OraOLEDB Oracle 1 Persist Security Info False User ID promis Data Source lt Database gt Where lt Server gt is the IP address or name of the computer running the database server lt Database gt the name of the SQL server database or Oracle TNS Page 47 of 60 MS Access When using Ms Access the physical database size is limited to 2GB and therefore the maximum number of measurement records that can be stored is approximately 45 million When logging only one tag with a frequency of 1 measurement per minute you will be capable to log for 85 years before the database reaches its limits This looks long but if you log 85 tags once per minute the database will reach its limits within 1 year To avoid these limit
79. pting a HTML file never remove elements having an id property Cross platform The Web interface is designed for desktop PC s laptops and tabloids and can be viewed with all mayor browsers IE 8 FF 8 Chrome 15 Safari 4 0 Opera 11 0 Android 2 3 We have implemented a basic HTML web interface for smart phones with a tiny screen or basic browser as well showing recent values and simple 24h charts To use this basic interface open the indexce htm page in your browser e g http 127 0 0 1 indexce htm Page 60 of 60
80. r a suitable number to avoid problems with other applications or firewalls When the port number is not set to 80 you have to provide the port number in the URL e g http 127 0 0 1 81 If reports using HTML5 Canvas rendering don t show up it could be that your browser does not support the HTML5 Canvas element Customizing The look and feel of the web portal can within certain boundaries be customized to your needs think about fonts and colors Visual properties like fonts and colors are defined in so called style sheets css The default style sheets are stored in the webdata folder To customize a style sheet you can copy it from webdata to webdata profiles common and adapt it to your needs If you are hosting clients and want to give each client his own look and feel you can add additional sub folders to webdata profiles e g webdata profiles acme and you copy style sheets to it that should differ from the default and custom profile Each individual user can be linked to a specific profile Edit gt Users Besides style sheets you could also copy any other file from webdata like button or logo pictures gif jpg etc You could even copy HTML and Javascript files but you should be aware that adapting those files could cause miss behavior of the web portal You can also add your own sub folders to the webdata folder e g webdata download where you can put your own static files to be accessed by any user Note When ada
81. rated column for Temperature and Level Each location has its own Import Wizard To pop up the Wizard select a location from the Location list and select Data Import Wizard from the Edit gt Locations or pop up menu To import data administrator or supervisor rights are required The import properties are saved after a successfully completed import so you don t have to specify them again for a next import F Ei Import Data Wizard 2 8 ss Import file ec TEMP4 1092411 TXT ta File format Column properties Preview Row Data 0001 DATET TIME Precipitation Pyranometer 0002 07 22 2010 09 48 00 0 0 1 0003 07 22 2010 09 57 57 10 0 5 0004 07 22 2010 10 06 06 11 0005 07 22 2010 710 18 00 12 0006 07 22 2010 10 32 00 12 0007 07 22 2010 10 51 00 13 0008 07 22 2010 10 55 00 14 0009 07 22 2010 11 04 00 15 0010 07 22 2010 11 11 00 11 oococosccsosse amp e UN eb BM Load properties from file Save properties to file Cancel Next K After selecting a file to import the Wizard pops up and will show the contents on the Raw data page Please study the contents of this page first its needed to be able to configure the correct import properties A file may start with one or more header rows giving info about the process generated the file and or describing the columns in the file Columns in
82. rial number The location code is also used as a reference when passing tag limit violations to the alarm system See chapter Messenger Refresh rate The rate at which the Recent Values page and Tag values on the Map page of this location will be refreshed Display on Map page A location label can be displayed on the map of the parent location The position of the label on the parent map can be configured in the location properties of the parent It s also possible to show the label to a certain type of granted user while hiding it from another See chapter users Collector Manager compatible data source To let he Collector Manager import data to this location please link this location to the appropriate Collector Manager compatible data source collector Data source identified by station code To let another type of Collector import data to this location you can specify a code to identify a data source that should be linked to this location The code to specify depends on the rules of the Collector and could be for instance a serial of a remote data acquisition station gt Its allowed to link one single data source collector to multiple locations not the other way around gt When a data collector receives data from a new source no location with a matching station code is found in the database it will automatically create a new location with the correct station code gt Changing a l
83. s can be positioned by dragging them to a certain position or by specifying coordinates Click the Item Positions button to specify coordinates or to resize items The visual order of items from back to front is background color background picture digital assets charts instrumentation reports tag labels and finally location labels Page 8 of 60 USERS Promis knows two types of users Administrators and View only users An Administrator is allowed to configure on a licensed system Promis and to view all locations View only users are only permitted to view granted locations The maximum number of users is dependent of your license the standard license includes the right to define 4 users To edit users select Users from the Edit menu and the following window will pop up a BH Users rrn User Name Administrator Full Name Add ADMINISTRATOR v The user who is allowed to add modif p JOHN John Johnson TEES r E36 User properties 2 8 User name User ID jonn Administrator 2 Password Verify Password p corse A user should have a unique Name this name is always in capitals This is the Fullname Name used to login into Promis A omonms password is not obligatory and can be left Accountexpires Expiration date Saturday Apri 19 2014 blank If a password is specified the user webserver proie can change it himself in the lo
84. s to be inserted into the formatted string Some specifiers such as d simply format numbers or strings Other specifiers such as refer to locale specific strings from global variables In the following table specifiers are given in lower case Case is ignored in format specifiers Specifier Displays d Displays the day as a number without a leading zero 1 31 dd Displays the day as a number with a leading zero 01 31 ddd Displays the day as an abbreviation Sun Sat using the strings given by the ShortDayNames global variable dddd Displays the day as a full name Sunday Saturday using the strings given by the LongDayNames global variable m Displays the month as a number without a leading zero 1 12 If the m specifier immediately follows an h or hh specifier the minute rather than the month is displayed mm Displays the month as a number with a leading zero 01 12 If the mm specifier immediately follows an h or hh specifier the minute rather than the month is displayed mmm Displays the month as an abbreviation Jan Dec using the strings given by the ShortMonthNames global variable mmmm Displays the month as a full name January December using the strings given by the LongMonthNames global variable yy Displays the year as a two digit number 00 99 yyyy Displays the year as a four digit number 0000 9999 h Displays the hour without a leading zero 0 2
85. ssing thru any other data DAQ unit ID As IP addresses are mostly dynamic the Collector Manager cannot detect the origin of the DAQ unit by its IP address However some DAQ units are foreseen with an unique or configurable unit ID The Collector Manager s DAQ unit recognizer mechanism can be used to recognize a DAQ unit by sending a command to requests its unit ID You can define one DAQ unit recognizer per TCP port If a particular DAQ unit protocol does not support ID recognition e g simple humidity transponder or no DAQ unit recognizer is defined the remote device should sent an identification string as first directly after connecting to the server The remote device should sent the string including the surrounding square brackets You should treat the DAQ unit ID as a strong password and avoid for security reasons the choosing of obvious names If you want to use an ID like STATION1 please add a kind of arbitrary verification code to it like in this case _AE762345 In this example the remote device should sent the string STATION1_AE762345 on connect gt Ifthe remote device is a legacy serial device it can be connected to the internet with a GPRS DTU or GPRS router with DTU port DTU Data Terminal Unit or transparent Serial to TCP converter gt Please choose a DTU or Serial to TCP converter that is capable of sending a user defined string on connect The disadvantage of mobile internet
86. t page is used to show user defined charts You can define several charts per location When creating a new chart Promis generates a default chart based on the tags you selected The default chart displays the measurements of max 8 tags over the selected period The user may alter the queries or modify the visual properties A o attaching tags to a specific Y axis changing colors or adding function series e g curve fitting or moving average Charts can be printed or saved or e mailed as JPEG compatible pictures To define a new chart select New chart from the Edit gt Charts menu or from the menu that pops up when you click the right mouse button To edit an existing chart select the chart from the Charts list and select Properties from the Edit gt Charts or pop up menu To delete an existing chart select the chart from the Charts list and select Delete from the Edit gt Charts or pop up menu Deleting a Chart is also possible by dragging the chart to the Deleted Items location Deleted charts are transferred to the Deleted Items location To delete charts forever the charts must be deleted from the Deleted Items location as well You can move charts to other locations by dragging amp dropping You can change a chart s order in the list by clicking the Ctrl amp Up arrow or Alt amp Down arrow keys simultaneously Note 1 If yo
87. terval the MODBUS register map should be refreshed with the most recent actual values from the Promis database Expose values as MODBUS is a protocol to read write certain portions of an addressable memory an area consisting out of up to 65536 WORD 2 bytes registers The MODBUS protocol does not specify how this area should be formatted The memory area of the MODBUS Server starts at holding register Ox0000 40001 with the recent value of the first selected Promis tag At which register the recent value of the next tag starts depends on how many WORD registers are used to represent a recent value Some MODBUS masters can deal with short integer numbers using 1 WORD register per value only while others can deal with double precision floating point numbers using 4 WORD registers per value A maximum of 1000 tags can be published thru the MODBUS Server The following types can be specified Type _ Range Length Remarks First tag starts at register 0 short 32768 1 WORD Second tag starts at register 1 32767 n th tag starts at register n integer 2 147 483 648 2 WORDs Second tag starts at register 2 2 147 483 647 n th tag starts at register 2n float IEEE754 32 bit 2 WORDs Second tag starts at register 2 n th tag starts at register 2n double IEEE754 64 bit 4 WORDs Second tag starts at register 4 n th tag starts at register 4n Most significant WORD first For val
88. the number of input values found within the aggregation period Count is 1 if no aggregation period was specified 7 Time of min value the timestamp of the Minimum value float the number of days that have passed since 12 30 1899 The fractional part is the time of day 8 Time of max value the timestamp of the Maximum value float the number of days that have passed since 12 30 1899 The fractional part is the time of day 9 Values is a sub array listing all the values within the aggregation period ordered by timestamp n case the input tag is of type Counter the counts per aggregation period can be calculated by subtracting the Minimum from the Maximum counter value or by the difference between the first and the last value in the lt Values gt sub array Note to be able to calculate the correct quantity the first counter value before the aggregation period will be included in the calculation as well The calculation script as shown below performs a multiplication of the average or instantaneous values of all input tags function CalculateValue aInputData var dResult 1 0 for var iTag 0 iTag lt aInputData length iTag if aInputData iTag 5 lt 0 return dResult alInputData iTag 2 return dResult The function should return a number float as the result of the calculation A recording will be made to the database if a valid number is returned only If wished returning nothing or
89. to define custom reports A good site to start you self education is http www w3schools com A report exists out of XML data which will be translated to a document by using an XSLT transformation An XSLT transformation describes how XML data should be transformed into another data format The power of using XML and XSLT is the possibility to separate the data from the layout of a document XML contains the document data while XSLT describes the document layout To learn more about XML and XSLT consult the web site of the World Wide Web Consortium W3C www w3c org The XML data for a report is constructed from the result of SQL queries see chapter Defining report queries and XML data Instead of building a textual report it s also possible to create graphical reports for instance by making HTML5 Canvas drawings using Java or VB script in an HTML report Promis comes with a few report templates a o a standard HTML report a Canvas linear gauge tank compass pie etc If Canvas does not work it could be that you have installed Internet Explorer 8 or older on your system HTML5 Canvas requires IE9 at least unfortunately IE9 is not available for XP or W2000 Content Type The content type specifies the type of document that should be generated a lot of different content types exist however the only content types that make sense from a Promis point of view are XML or flat text based documents e g HTML pages CSV fil
90. tomated report deliveries to SMTP FTP HTTP Servers or Local File Systems v VVVVVVV VV VV Vv VVVVVVVV Minimum System Requirements Microsoft Windows 2003 XP preferred 2008 W7 or W8 Display resolution 1024x768 or higher Microsoft Internet Explorer 8 Microsoft Internet Explorer 9 to use Canvas graphics VVVV Page 4 of 60 OPERATION When you open Promis you are asked to login at first aneia time with an empty database you should login with Password e Change user name Administrator and a blank password Change Data Source File Edit Control About Has AJA Compressor 27 sep 2004 27 sep 2004 22 00 00 22 59 59 t ean coenk Tao Name Type t Target Low Limit High Limit Z Site 1 Co Air FLow Administration Air Pressure Sample Logistics Air Temperature Sample Production Hall 1 Generator Hall 2 Site 2 Site 3 Location B Location x Deleted Items WB Recent Reports History The left window shows the hierarchical location structure while the right window shows information associated to the selected location The displayed information at the right depends on the selected page at the bottom of the Window There are 7 pages Tags showing the list of tags associated to the selected location Map showing a geographical map or control panel dashboard Recent showing the
91. u create new charts by cloning it from others or by cloning a location containing charts the clones and original chart will share their queries and visual properties If you change a query or a visual property within a clone or the original your changes will be applied to all clones and the original as well You can of course unshare a clone from others and the original chart as well An original chart shared to by clones can t be permanently deleted and when you try it will stick in the root of the trash can location Page 21 of 60 Note 2 Charts can be included in HTML reports as well you can do it by adding HTML img elements in lower case to the HTML code of the concerned report as follows lt img src chart jpg chartid x gt where x is the ID of the chart to be included in the HTML report Defining a chart Note Knowledge of SQL is required to define custom data queries Chart properties exist out of data queries which are supplying the data points for the chart series and visual properties Click the Add or Clone button to create new data queries You may define as much queries as required To modify or delete an existing query select the query from the list and click the Delete or Change button To edit the charts visual properties click the Edit Chart button amp Chart properties E 5 x Chart name Display to Data queries Mass Volume amp Level Add
92. ues consisting out of multiple WORDS e g float some MODBUS masters wants to have the most significant WORD first and others as last Each tag has a Status WORD register as well the Status register of the first tags starts at holding register 0x2000 48193 the next at 0x2001 48194 etc The Status WORD can exists out a combination of bits Bit 0 0x0001 Value not recorded in time All 0 0x0000 Okay Bit 1 0x0002 Minimum range exceeded Bit 4 0x0010 High limit exceeded Bit 2 0x0004 Low low limit exceeded Bit 5 0x0020 High high limit exceeded Bit 3 0x0008 Low limit exceeded Bit 6 0x0040 Maximum range exceeded MODBUS Register mapping Use the MODBUS register mapping to define which tags from the Promis database should be included in the MODBUS memory area The order in this list determines where the value will appear in the memory area The order in which the values appear should be in accordance with the master so be careful with changing the order or deleting tags from the list The value registers are starting at holding register address 0 In case of shorts or integers decimal numbers lose their fractions but by specifying a factor when adding a tag to the map decimal numbers could be represented as values multiplied by 10 100 1000 etc E g a temperature of 25 23 C could be represented as 2523 C 100 Page 58 of 60 Messenger Alarm management If the alarm management system M
93. uled recipients will be tried once jada If still nobody has responded or if there are no recipients assigned to She this specific level the recipients at the ee parent level will be tried etc etc until os the recipients assigned to the Dispatchers Default level Monitor FPP PR ER RE To be able to distinctively dispatch alarms for each individual tag an alarm is passed to the Messenger with a sub process path Alarms appear in Messenger under Local Monitor and with sub process name promisALARM and for each Promis sub location appended with its Location Code and finally append with the Tag Code of the concerned tag and the type of violation that occurred UNDERRUN for a low limit violation OVERRUN for a high level violation and TIMEOUT if a value is not recorded in time Let s assume a low level pressure violation of a compressor at Promis location Location A Site 1 Production Hall 1 Compressor than the sub process path passed to the Messenger might look like promisALARM LOCA S1 PRO H1 COMP PRESS UNDERRUN The Messenger category for UNDERRUN OVERRUN alarms is Operator and the Messenger severity is Warning in case of low or high limit violations and Error in case of low low or high high
94. urbacl an der 4 Tournai Hanna Bonn Lahn aa Vig NORD PAS DE CALAIS Louvi re Andenne Li ge Na Mechernich Butzbach Malmedy AIN a M LAND PALATINATE CofE ETNA oh EOE i CDEN its suppliers Waurights reserved G LU M E Tags Map DE Recent p gt Player p2 Charts Reports m History E Assets Comments If a location has child locations they can be projected on the map as blue labels Clicking the labels will jump to that location If a location has tags they can be projected on the map as well It s also possible to place instrumentation reports charts and digital assets e g pictures on maps to construct instrumentation dashboards or control panels Page 6 of 60 Location Properties A location has a o the following fields r EX Location properties iii n E Properties Map Location name Location code Display on Map page for lEnergy Logger1 1 fet 2 Anybody Visitors Location description Refresh rate of Map amp Recent values page Operators 60 sec Supervisors Administrators Nobody Remarks IV This location is linked to a data acquisition source Collector Manager compatible data source a Energy Logger1 X Data source identified by station code Location name Each location should obviously have a name Location code As accomplishment to the name a location can have a code the meaning of this code is up to the user for instance a zip code or se
95. value can be re scaled to the right engineering value A factor can be calculated as Max Eng value Min Eng value Max ADC Value Min ADC Value in this example the factor will be 70 30 4095 0 0 02442 The offset can be calculated as Min Eng value Min ADC value factor in this example the offset will be 30 0 0 02442 30 Page 14 of 60 In some other cases it could be that the 10 x engineering value couldn t be calculated able name with a factor and offset Assume you Convert level cm to flow m3 h OK want to register the flow in a river but pie Device value Engineering value A Cancel 0 0 7 you measure level in ADC values in that case you could first apply a factor and offset to re scale to cm and then apply a conversion table to re scale cm to m3 h Conversion tables can be edited via the 1 Menu bar gt Edit gt Conversion Tables Beside an example of a conversion table Calculation Properties Li lolx Base properties Additional properties Calculation properties Input Tag ID Code Name Add 518 VOLUME Volume gt 516 DENSITY Density Delete 4 w A Calculation based on the most recent instantaneous input values Calculation based on the most recent aggregated input values Aggregation options Aggregation period 01 00 00 hh mm ss Median span 100 4 Multiple aggregated valu

Promis User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents