SDB View - Smartec
Contents
1. 501001 mm 054 rea iure 4 1 1 4 900008 mm A AJuYx X 179 1 04 t i 1 1 4 i 1 X 4 1 4 1 4 Qi i aei oe L 2 w 2 H i 1 E 0 2 i 6 E x he ad DN P 02 ii n E os coud MEAS ons 09 04 2008 12 04 2008 15 04 2008 18 04 2009 21 04 2009 24 04 2008 27 04 2009 Session AvgDate 1194 Sessions Fields 2 The graphical output shows a window containing the desired graph The window includes the name of the View in the title bar in this case First Span with the number of Sessions treated and the number of fields displayed given on the status bar 1194 Sessions and 9 fields in the above example How to Zoom and Scroll the Graph 28 Examples of View output formats On a graph view it is possible using the mouse to execute a zoom and a scroll To zoom in on a graph press the right mouse button at the top left hand corner of the area you wish to zoom in on and maintaining the mouse button pressed drag out the rectangle to the bottom right hand corner of the zoom area Release the mouse button and the graph will redraw the area selected To undo the zoom pre2. Start Session First Session C Selected Session Last Session 7 Show only the Last 100 Sessions C Show only the Last 365 pas 21 End Session Last Session Selected Session 06 05 2009 10 16 21 7 Reference Session First Session Selected Session 01 01 2009 01 00 06 7 Auto first session with Field present None show absolute values Include Forgotten Sessions Ok Cancel Help The first recorded monitoring Session from the SDB Measurement database may be selected as the start Session by choosing the option First Session from the Start Session box If the user wishes that the interval starts with the last monitoring Session undertaken the option Last Session is chosen If the user wishes to start the interval with a monitoring Session of choice the option Selected Session is first chosen before selecting the desired Session with the aid of the adjacent scrolling menu that displays the list of Sessions stored within the SDB file If the user wished to visualize only the last N sessions created the option Show only the last N Sessions is chosen Instead if the user wishes to display only the sessions created recently there is the possibility to specify the frame of time to be used in the options Show only the last N DateUnit where DateUnit is the adjacent scrolling menu that displays the unit of time that can be selected Hours Days Mont
3. User s Manual SDB View 04 05 2010 Integrated Structural Health Version 6 4 8 1996 2009 SMARTEC SA Switzerland 1999 2010 SMARTEC SA Via Pobiette 11 CH 6928 Manno Switzerland Tel 41 91 610 18 00 Fax 41 91 610 18 01 E mail smartec smartec ch WWW www smartec ch SDB User s Manual Contents e i ii Contents SDB User s Manual Contents SDB VIEW 5 Welcome fo SDB VIEW FUE 5 Window 98 NT 2000 XP Vista Installation esee 5 SDB VIEW Overview 6 6 Organization of the Data Base sipeer trennen eene enne nete S E 6 VIEW ee tet 6 6 Pena POR bmtenneibitiee 7 SDB View Configuration 8 Options Menu ois ntt eo M ene E eter te Net ese bet tes 8 View User Interface 10 SDB VIEW aeree eek t e t e eter tene ese paret eid es 10 Meu 11 ENE 11 Navigation 11 Th View navigation 10 12 The 7 12 External execution of a rennen 13 Aitranging WIDndOWS siete poe n Pee Here rH 13 Defining a View 14 Create a mew VIEW sista tette OU entis tiet cet er b 14 Edita tiew or exisung 14 The Vi
4. Warnings on page 18 must be fulfilled Examples of View output formats 29 Show Warning Status on Graph Parallel sensors x saeg 01 02 02 2005 17 02 2005 04 03 2005 19 03 2005 Session A amp vgDate 1002 Sessions 2 Fields 2 To have the graphical output with the Pre warning and Warning lines the option Show Warning on Graph has to be selected In this example colored lines are visible The red one corresponds to the Field selected in the View and the others lines represent the Threshold levels Four possible Thresholds are available WM means Warning Maximum Wm means Warning minimum means Pre Warning Maximum PWm means Pre Warning minimum How Map works Please note that an outgoing curve doesn t mean that a Warning or Pre Warning is generated This only means that the Measurement exceeds the defined warning threshold for this Sensor The condition to generate a Warning is to have channels outside the range in the last m Sessions So if one curve exceeds the thresholds this only means that a critical situation has happened for this Sensor To generate a Warning the conditions defined on panel 4 Warnings described on chapter Selection of Warning values Warnings on page 18 must be fulfilled The first time the Map is loaded all Fields are placed in its center To move them in more meaningful positions for example
5. button The type of separator used in the text file by selecting from the scrolling menu File Type Four different types of file can be selected tab separated text file comma separated text file MS Excel and XML With the option Create new file each run a new text file will be created for each new View display whether manually or automatically displayed The software then creates a new file named File Name plus an incremental number attached to the end of the file name The option Copy the file to ftp site allows the possibility to upload the created file on an ftp site If this option is active the following parameters can be chosen The address of the ftp site can be specified on the field ftp site The folder where to upload the created file can be specified in the field folder The login and the password to use for the registration to the ftp site can be specified in the fields Login and Password With the option Generate HTML File an html file will be generated accordingly to a predefined html template uploaded by the user The SDB View software parses the source file and then creates the destination file replacing the keywords with the relative information map graph and table If this option is selected the following options can be chosen name of the html source file to use as template by use of the pm button The name of the destination file that contains the file html up
6. will create a View without any display This option is useful if the output of the view has to be stored on a file but not necessarily shown on the monitor SOFO SDB User s Manual Defining a View 23 7 Selection of output options Storing view first span 1 Description 2 Select Sessions 3 Select Sensors Graph Save to file Graph File Name C Documents and Settings SOFO SDB MANUAL example JPG an File Type JPEG JPG Include Data Labels Create new File each run Copy the to ftp Site ftp site uw smartec ch Folder FolderGraphes Login Jexample Password Table Save to file Table File Name C Documents and Settings example txt TXT Tab separated Create new File each run Copy the file to ftp Site ftp site Jw smartec ch Folder FolderTables Login Jexample Password HTML Generate HTML file Source C Documents and Settings SOFO SDB MANUAL Google html s Destination Googlewarning html Copy the file in a ftp site ftp site Jr smartec ch Folder soFoview Login administrator Password Options associated with the desired stored output are defined in this page option Save to File Graph saves the graph to a specific file If this option is selected the following options can be chosen The name o
7. 01 Tel 41 91 610 18 00 workdays 9 AM to 12 PM and 2 PM to 5 PM GMT 1 Mail SMARTEC SA via Pobiette 11 CP CH 6928 Manno Switzerland To facilitate the user support please be ready to indicate which version of SDB you are running In case of bugs please write down the error message and the situation in which it has occurred Suggestions and bug reports To suggest addition and modifications to SDB or to report bugs please use the form on the next page and send it or e mail it to the above address Your feedback is sincerely appreciated 38 e Support SOFO SDB User s Manual Suggestions and Bug Report SDB Software Date SDB version Operator e Bugs Crash the software stops and or gives an error message Error the software behaves incorrectly O Messages unclear message or spelling error Menu command generating the bug Previous operations Problem description Suggested solution Is the problem reproducible L Yes No e Suggestions Modification of an existing functionality New functionality SOFO SDB User s Manual Support e 39 40 Support SOFO SDB User s Manual SDB User s Manual e 43
8. Shortcut file from the Windows Explorer The SDB program will terminate after the view execution This option may be useful when SDB is used in a batch file for example when generating view automatically at predefined times Arranging Windows SOFO SDB User s Manual The SDB window can be moved resized maximized minimized and closed as any standard Windows window If multiple windows are shown you can Tile the windows horizontally using View Tile Horizontally or the E button in the toolbar Tile the windows vertically using View Tile Vertically or the button in the toolbar Cascade the windows using the command View Cascade or the fe button in the toolbar Arrange the icons using View Arrange Icons View User Interface 13 Defining a View Create a new View A new View is created by selecting the menu Views New View This function can also be attained using the icon jal The software immediately attributes the view name New ViewXX XX represents the first available number Edit a new or existing View Editing a view is achieved by clicking on the menu Views Edit View after having selected the desired view This function can equally be attained using the icon 12 The SDB VIEW program then opens assistant wizard allowing definition of the desired properties The View edit form 14 gt Defining a View The View edit form provides guidance with the following 7 steps 1 Descri
9. at their real positions on the map it is necessary to place the mouse over the textbox press and hold the CTRL key drag the textbox to the desired position and release the mouse button The name of the field is indicated on every box 30 e Examples of View output formats SOFO SDB User s Manual SOFO SDB User s Manual Since all fields are initially superposed in the center of the screen the second textbox will be visible only when the first is moved and so on How ta the text box xj The first tine tha the Map is oadec all Fields are placed in its center To nove they ir more meaningful postions For examole their real positions T itis necassary to place the mouse over tha textbox press and sold the CTRL key A Please note that after a textbox has been moved its new position is stored in the DB This means that in the future when the Map will be activated the position of the box remains the same of its previous position before closing the View When Map is resized the position of all the Sensors will be scaled accordingly to the new dimensions E Map and Warnings 01 04 2005 12 03 32 A Out B 24 0 0634 In the above example it is possible to observe the values for all the selected fields session by session with a combo box indicating the currently displayed Examples of View output formats e 31 Save To HTML Session Each time the map is loaded the plotted values are disp
10. should be selected 3 Selection of Sensors or data fields to display Select Fields 6 Outputs 2 Select Sessions 5 Measurements 7 Storing 3 Select Sensors 1 Description 4 Warnings Select Fields Available session Number C session DateCreated C session AvgDate sensor 1 mm QA sensor 2 mm sensor 3 mm sensor 4 mm Temperature down C M Temperature up user Data mm Empty Column 24 up Down Del Clear Selected sensor 3 mm Ok Cancel Help This third page allows the selection of data fields as defined in the SDB Measurement file which are to be displayed in tabular or graph format The field designated by the first line of the Selected box will be considered as the abscissa horizontal axis in the case where a graphical output is desired Field selection is accomplished either by double clicking over one of the fields listed in the upper box titled Available or by selecting the field and clicking on the arrow The printing order of the selected fields in either tabular or graph format may be modified by highlighting the field in the lower Selected box and then clicking on the button Up or Down to displace the field by one increment To remove a selected field from the list simply highlight it and click Defining a View 17 18 e Defining a View on the Del button To remove all sel
11. the display of certain user messages The Menu bar The SDB View menu bar is part of the SDB menu bar a detailed explanation of the functions available from these menu options is given elsewhere in context The Tool bar 4 Sle The tool bar comprises shortcuts in the form of buttons giving access to commonly used commands defined by the menu options If the mouse pointer is held over a button for longer than 1 second a brief description of its associated command is displayed The icon lives the possibility to edit the selected view The icon the possibility to create a new view The icon gives the possibility to clone the selected view The icon gives the possibility to show the view selected in combo box of the navigation bar The icon gives the possibility to enable or disable the view navigation window Navigation bar dcin KI 4 lt DIESES IKI 4 lt 2 Meas E EL IINEN FUTT 955 of 1061 941 01045 1 in 5 e ASEA Iri To select a View you can use one of the following methods Select the View from the first combo box under Sessions in the Navigation bar Use the buttons in the Navigation bar erst View view D next View Dil last View The commands in the View Last SOFO Views shows the last 10 views used SOFO SDB User s Manual View User Interface e 11 The View navigation window 12 View User Interface The View navigation window is lo
12. 0 20 01 2005 09 03 30 20 01 2005 10 03 28 0 0573 0 0968 20 01 2005 11 03 30 0 0517 0 0907 41193 20 01 2005 12 03 30 0 0469 0 0838 01138 4 20 01 2005 13 03 30 0 0470 0 0938 0 0421 HA 20 01 2005 14 03 30 0 0428 0 0881 0 0386 0 0730 20 01 2005 15 03 30 0 0401 0 0826 0 0336 0 0679 00972 0 20 01 2005 16 03 30 0 0399 0 0802 0 0299 00642 0 0936 00718 20 01 2005 17 03 30 00383 0 0806 0 0320 00668 0 0949 0 0733 1002 Sessions 0 0881 0 0531 0 0900 0 0538 0 0925 0 0536 0 0941 0 0556 0 0942 0 0566 0 0976 0 0584 0 0977 In this example are visible some colored cells These are the cells that are outside the thresholds This output is generated because the option Show Warning on Table has been selected The graphical output is the same window as the Show Table one but with exceeding data displayed in the relevant color Data reaching the pre warning level is displayed in yellow Data reaching the warning level is displayed in red Note that it is also possible to select and copy groups of cells from the resultant table but the Warning indicators will not be copied to the Clipboard A red or yellow colored cell doesn t mean that a Warning or Pre Warning is generated This only means that the Measurement exceeds the defined warning threshold for this Sensor To generate a Warning the conditions defined on panel 4 Warnings described on chapter Selection of Warning values
13. 2 13 6343 10 04 2009 20 03 03 13 6401 10 04 2009 22 03 03 13 6483 11 04 2003 00 03 03 13 6511 11 04 2003 02 03 03 13 6516 11 04 2008 04 03 03 13 6543 11 04 2008 06 03 03 13 6508 11 04 2009 08 03 04 13 6538 11 04 2008 10 03 04 13 6554 11 04 2008 12 03 03 13 6525 11 04 2009 14 03 03 13 6544 11 04 2009 16 03 03 13 6581 11 04 2003 18 03 03 13 6599 11 04 2003 20 03 03 13 6649 11 04 2003 22 03 03 13 6687 12 04 2009 00 03 03 13 6700 12 04 2003 02 03 03 13 6689 12 04 2009 04 03 04 13 6738 12 04 2003 06 03 03 13 6716 12 04 2009 08 03 03 13 6737 12 04 2003 10 03 03 13 6727 12 04 2003 12 03 03 13 6716 12 04 2009 14 03 03 13 6721 12 04 2003 16 03 03 13 6720 12 04 2003 18 03 03 13 6702 The graphical output a window with the name of the View in the title bar in this case Fist Span with the number of Sessions treated and the number of fields SOFO SDB User s Manual Examples of View output formats e 27 Show Graph displayed given on the status bar 1194 Sessions and 9 fields in the above example Once the above window has been displayed it is possible to select a group of cells with a mouse pointer and then send them to the Clipboard using the menu function Edit Copy It is possible to select an entire column by simply clicking on the column header x A First Span 0 6
14. Interface The SDB VIEW user interface is integrated in the SDB software The software SDB VIEW can simultaneously display multiple Views from a single SDB file In addition it is possible to run several Sessions of SDB VIEW on the same PC SDB v6 4 1 Example view sdb Tee Sessions Measurements View Tools Help e Sensors 2 EE Id d gt DIRT SMARTEC 1061 0 E 14 03 2005 03 03 27 14 03 2005 07 03 27 0 14 03 2005 11 0327 0 14032005150327 14 03 2005 19 03 27 14 03 2005 23 03 27 15 03 2005 03 03 27 15 03 2005 07 03 27 15 03 2005 11 03 27 15032005150327 0 15032005 190326 9 15 03 2005 23 03 26 0 0604 00808 4 0 0711 0 0825 15 03 2005 16 03 2005 17 03 2005 18 03 2005 19 03 2005 20 03 2005 21 03 2005 22 03 2005 23 03 2005 Session AvgDate In This example we see The View navigation window enabling View editing at the right hand side Three SDB VIEW windows showing displays of different Views with in the above example clockwise from top left A view displaying a table of data from 6 Sensors A view displaying a map of data from 8 Sensor A view displaying a graph of data from 4 Sensors 10 e View User Interface SOFO SDB User s Manual Each view carries a title bar with the name of the view as well as a status bar identifying the monitoring Session and the number of displayed data fields The principal status bar allows
15. License Manager menu With it you will have the possibility use all the function of this module SDB VIEW gt 5 SDB VIEW Overview Database principals The initials DB indicate the use of standard database concepts within the SDB VIEW software data recorded by the SOFO Measurement system are stored in a file having the extension SDB This is a Microsoft Access data base file type SDB VIEW is based on the Microsoft Jet Engine The SDB VIEW files can also be accessed by the Access Excel or Visual Basic software Organization of the Data Base A SDB VIEW is simply a SDB with additional tables One table View defines the display and output modes for the selected data base fields this output is henceforth call the View The table may comprise one or multiple views The other table Field comprises the field values for display in accordance with the definitions of the View table VIEW Table The fields requiring definition in the compilation of this table are essentially described by The name of the View The access path to the database file SDB from which one wishes to select a display number of monitoring Sessions for which the data base fields SDB must be displayed An option defining whether or not to display the forget monitoring Sessions and or Measurements An option allowing execution of this View upon launching the software desired display type Warni
16. Value is ticked only the minimum value of the Session will be used as the reported Sensor value SOFO SDB User s Manual 6 Selection of data output type Outputs View First Span 1 Description 2 Select Sessions 3 Select Sensors 5 Measurements 6 Outputs 7 Storing Default Output Nothing C Show Graph First Field X Axis Show Table Map picture Show Map and Settingslfavez DesktoplSOFO SDB MANUAL ado Ok Help This page allows selection of the desired output type These options are described in more detail in the following chapter The option Show Table displays a table of Measurements of each Sensor ordered by Session The option Show Graph displays a graph showing the Measurements of each Sensor ordered by Session as a function of the abscissa values field chosen during stage 3 Select Fields The option Map displays the Measurement of each Sensor on a map This option is useful to indicate on a map where the Sensors are located Selecting a Session will display the Sensor values for this session Picture File Name on which the Sensor Measurement will be shown must be selected at this stage The file has to be a picture format file JPG GIF WMF and no specific size nor definition are required The picture will be resized according to the requirement The picture may be loaded by using the button The option Nothing
17. bing the SDB view to show 2 Selecting the Measurement Session interval 3 Selecting the Sensors to display 4 Defining the Warnings thresholds 5 Establishing the type of calculation to be undertaken during the Session duration 6 Defining the output form 7 Defining the storing options Navigation within this form is self evident and consistent with similar form assistants used by Microsoft Corporation software Clicking on the option menu there is the possibility to specify all the view parameters The buttons Cancel and Finish allow the user to cancel or apply all modifications made during operation of the form SOFO SDB User s Manual SOFO SDB User s Manual 1 Describing the View to Show Description New Yiew This first page allows Definition of the View name Description of the type of View The option Autoexecute this View on Open allows one to choose whether or not the SDB VIEW software will automatically execute the defined View upon opened file Note that this option is normally used to automatically create text files comprising spreadsheet or graph plot data 2 Selection of the monitoring Session Select Sessions This second page allows selection of the Session interval over which the Sensor data will be selected Defining a View 15 16 Defining a View 5 Measurements 1 Description 2 Select Sessions 3 Select Sensors 4 Warnings Select Sessions
18. cated to the left of the principal SDB VIEW window The View navigation window The View navigation window shows the different views defined in the open database Each View is identified by name and by an icon indicating the output format for the View The icon EH identifies a view for which the graphical output is in the form of a table of type screen display txt file or direct copy to the Clipboard The icon identifies a view for which the output is in the form of a graph of type screen display file bmp wmf jpg or direct copy to the clipboard The icon identifies a view for which the graphical output is in the form of a drawing picture map The icon identifies a view for which the output is in the form of a table or graph of data for which Warning and Pre warning thresholds are have been defined If the output will be in the table form all the cell that have value outside the threshold value will be of a different color Instead if the form will in the graph form then in the graph will be draw even the threshold lines The icon L identifies a view for which there is no display window This may mean that not all the parameters of the view have been set or that the output is simply stored in a file and not show as a view Having selected one of the views the contextual menu identical to the View menu provides access to the following functions Close View List allows close the View navigation windows This
19. dated in the Destination box The option Copy the file to ftp site allows the possibility to upload the created file on a ftp site If this option is active the following parameters can be chosen The address of the ftp site can be specified on the field ftp site The folder where to upload the created file can be specified in the field folder Defining a View 25 26 Defining a View The login and the password to use for the registration to the ftp site can be specified in the fields Login and Password When the Generate HTML File option is active the view is executed in the html Source file if three different tags are present The available tags are the followings graph2html__ ViewName where graph2htm__ is the keyword indicating that a graph picture has to be generated the ViewName is the name of the view in which the spaces are replaced with the character If during the parsing of the source file this tag 15 present a figure of the graph is generated In the destination file the tag is replaced by a unique picture name Usually in the source file this tag should be inside a img tag for example lt img src graph __ ViewName map2html _ ViewName where map2html __ is the keyword indicating that a map picture has to be generated the ViewName is the name of the view in which the spaces are replaced with the character If during the parsing of the source file this tag is present a figu
20. ected fields in one operation simply click on the Clear button Note that where a graph plot is required all fields apart from the first which is plotted along the horizontal axis should be of the same type The suggested default X axis field should be the Session AvgDate which corresponds to the overall monitoring period for all Sensors selected and recorded during any single Session 4 Selection of Warning values Warnings 5 Measurements 6 Outputs 7 Storing 3 Warnings Session AvgDate To desactivate Pre Warnings and Warnings use 0 values Min Max Pre Warnings n 0 Absolute Default Warnings n 0 Nam PreWarnin Pre Warnin warning Min Warning Max Session AvgDate 0 0 50001 mm 50002 mm 50003 mm 507004 mm 507005 mm 501006 mm 500007 mm 50008 mm e oooooooo ooooooooo eo Show Warnings on Graph Table Map Pre Warningn r Warning Generate Pre Warning if JO channels are Generate Warning if b channels are outside range in the last 5 sessions outside range the last fo sessions Run on Pre Warnings Warnings Pre Warning Warning E Call in m Argument Argument Email on Warnings On Warning Email To SMS Warnings Warning SMS To This page allows the definition of Warning and Pre warning conditions The lo
21. enables the maximum Pre warning threshold value Values outside the max min threshold will be displayed in yellow when the user requests the screen display giving the Warning status The fifth column Warning Min indicates the minimum Warning threshold value The sixth column Warning indicates the maximum Warning value Values outside the max min threshold will be displayed in red when the user requests the screen display giving the Warning status The option Show Warning Status on Graph Table Map allows display the Pre warning and Warning defined on the table of graph If the active output format is a Table then a table with the Measurements from each Sensor ordered by Session is created The values falling outside of the maximum minimum value ranges defined by stage 4 Field Detail are colored in yellow for values exceeding the Pre warning thresholds and in red for those exceeding the Warning threshold If the active output is Graph then the graphs will be drawn with the threshold lines The option Email on Warning allows emails to be sent when values exceed the maximum minimum value ranges defined by stage If this option is selected the field On Warning Email To becomes active and it is possible to specify in the text box the list of valid Email addresses If more than one email 6e o address is specified they must be separated by a The option SMS on Warning allows SMS to be sen
22. ew edit fori 2e treten iere 14 1 Describing the View to Show Description 15 2 Selection of the monitoring Session Select 510 5 15 3 Selection of Sensors or data fields to display Select Fields 17 4 Selection of Warning values Warnings esee 18 5 Selection of the Measurement method Measurements 21 6 Selection of data output type 2 23 7 Selection of output options Storing sese 24 Examples of View output formats 27 Hiper 27 SHOW eer BE e a e ep eie 27 SHOW Graphic Pe a 28 How to Zoom and Scroll the 2 28 Show Warning Status on 29 Show Warning Status on 30 How 5 etate tereti et REA DUREE RO 30 Save DI REPERTA 32 SDB User s Manual Contents e i ii Contents Warning check nne teneret nren TE 33 Switching between Output formats cessere een rennen nennen nen 34 Getting help 36 le ey 36 Support 38 Support 38 Getting the latest Version cep detenta ee i ee eem eme
23. ew output formats SOFO SDB User s Manual TABLE BORDER 1 BORDERCOLOR b5b500 CELLSPACING 1 CELLPADDING 7 WIDTH 450 gt lt tr gt lt td gt Session DateCreated lt td gt lt td gt 2438 ch2 mm lt td gt lt td gt Temp aria CH11 1 C lt td gt lt td gt Temp ROR CH11 0 C lt td gt lt tr gt lt tr gt lt td gt 4 11 2003 11 14 54 AM lt td gt lt td gt 0 0493 lt td gt lt td gt 21 5 lt td gt lt td gt 12 lt td gt lt tr gt lt tr gt lt td gt 4 14 2003 9 42 55 AM lt td gt lt td gt 0 0654 lt td gt lt td gt 21 7 lt td gt lt td gt 12 1 lt td gt lt tr gt lt tr gt lt td gt 4 14 2003 11 30 28 AM lt td gt lt td gt 0 0223 lt td gt lt td gt 21 8 lt td gt lt td gt 12 lt td gt lt tr gt lt TABLE gt lt img src map12 bmp gt Warning check after every scan In SDB View It is possible to update all the views after every cycle of an Agenda This is real useful for many reasons e Store the result after every cycle in a text file or a picture e View in real time what is happening e Check if there are new critical situations and run programs or send emails To perform all this operation it is necessary to set a flag of the Agenda properties form on the pane Options as shown in the figure next page Leaving unchecked the option Don t update the views after each run the Agenda will execute an update of all the views after each agenda run This means that every operati
24. f the saved file by use of the button The file type by selecting from the scrolling menu File Type Three types of file can be chosen Windows Metafile format Metafile WMF Bitmap format Bitmap BMP Jpeg format JPEG JPG With the option Include Data Labels the addition of a graph legend comprising the field names as selected during stage 3 the default option will be displayed on the graph With the option Create new file each run a new picture will be created for each new View display whether manually or automatically displayed The software then creates a new file named File Name plus an incremental number attached to the end of the file name 24 e Defining a View SOFO SDB User s Manual SOFO SDB User s Manual With the option Copy the file to ftp site it is posible to upload the created file on a ftp site If this option is active the following parameters can be chosen The address of the ftp site can be specified on the field ftp site The folder where to upload the created file can be specified in the field folder The login and the password to use for the registration to the ftp site can be specified in the fields Login and Password With the option Save to File Table the Measurement table will be saved on a file in the form of text MS Excel or xml file If this option is selected the following options can be chosen The name of the saved file by use of the
25. function can also be activated by clicking on the if the View Close View List Open A navigation list is active New Edit Open allows display of a selected view This Clone function can also be activated by double click Delete on the wanted View Refresh ee New allows creation of a new View This Create Shorcut for this View function can also be activated by clicking on Last SOFOViews the icon Edit allows editing of the selected View This function can also be activated by clicking on the icon SOFO SDB User s Manual Clone creates a new View having the same characteristics as the selected one This Close View List Open Han N function can also be activated by clicking on ew Edit the icon ES Clone 7 Delete Delete deletes after user confirmation the selected view Refresh Create Shorcut for this View Refresh updates the selected View Last SOFOViews External execution of a View You can execute a View from the Windows Explorer if you create a shortcut to the View with View Create Shortcut file for this View This will prompt you to enter a file name for the Shortcut file with SSV extension This file contains the name and path of the database and the name of the View to be executed If you associate the SSV extension with the SDB exe program you will be able to open the Database and execute the View by double clicking on the
26. here a Sensor was not included in a particular monitoring Session The Measurement entries can either be left empty or given the numerical value zero The lower selection box Sessions with Multiple Measurements allows one to choose how the unique value for reporting is determined if a Sensor has been measured 2 or more times in a single session Defining a View e 21 22 e Defining a View iew First Span 1 Description 2 Select Sessions 3 Select Sensors 5 Measurements 6 Outputs 7 Storing Include forgotten Measurements and Peaks Session with Missing Measurements Leave Empty C Insert 0 Interpolate Extrapolate Session with Multiple Measurements Use First Measurement Use Last Measurement Average Measurements Use Maximum Value Use Minimum Value Note that the choice of reported value affects all displayed data within a particular View if Use First Measurement is ticked only the first value of the Session will be used as the reported Sensor value Use Last Measurement is ticked only the last value of the Session will be used as the reported Sensor value Use Average Measurement is ticked the mean value of the particular Session Measurements will be used as the reported Sensor value This is the default option Use Maximum Value is ticked only the maximum value of the Session will be used as the reported Sensor value Use Minimum
27. hs Years while N specifies respectively how many hours days months and years should be considered The last two options are really important if the user wishes to view the data with a moving window The last recorded monitoring Session from the SDB Measurement database may be selected as the end Session by choosing the option Last Session from the End Session box If the user wishes that the interval ends with a monitoring Session of choice the option Selected Session is first chosen before selecting the desired Session with the aid of the adjacent scrolling menu that displays the list of Sessions stored within the SDB file SOFO SDB User s Manual SOFO SDB User s Manual For each Sensor the Measurement is displayed with respect to the value recorded during a reference Session If the option First Session is selected from the Reference Session zone this the first hierarchical recorded monitoring Session from the SDB Measurement database is used as the reference Session If the user wishes to refer the Sensor Measurements to a monitoring Session of choice the option Selected Session is first chosen from the Reference Session box before selecting the desired Session with the aid of the adjacent scrolling menu which displays the list of Sessions stored within the SDB file If the user wishes to include Measurement Sessions tagged with the option Forget in the SDB Measurement file then the option Include Forgotten Sessions
28. indow appears and allows the selection of the filename and of the format jpeg gif bmp wmf If the window contains a table then you will be asked the filename and the format for the output numeric file excel txt The icon ES redraws the active graph or table showing the Warning and Pre warning thresholds This means colored cells for tables and colored lines graphs The icon gives the possibility to print the active window The icon 3 refreshes the information of the current view This means that if new Measurements have been performed these will appear in the view after the refresh 34 e Examples of View output formats SOFO SDB User s Manual SOFO SDB User s Manual Examples of View output formats 35 Getting help Help An online help can be accessed pressing F1 in any part of SDB or from the Help menu 36 e Getting help SOFO SDB User s Manual SOFO SDB User s Manual Support 37 Support Getting the latest version The registered users will automatically receive new major releases of SDB Minor releases can be sent by e mail to users with specific problems Consult SMARTEC s website at www smartec ch to find out about software updates Getting support Support for the SDB software is provided directly by SMARTEC SA Only registered users are entitled to receive support for this software To get support contact SMARTEC SA by one of the following means E mail support smartec ch Fax 41 91 610 18
29. ituation has been reached in the fifth session there are at least n 3 channels outside the ranges in all the last m 4 Sessions In the following table there is an example in which 4 and 3 but the warning is not generated Channel1 Channel2 Channel3 Channel4 Session Session2 X X X Session3 X Session4 X X X Session5 X X X In this example the critical situation hasn t been reached yet there are at least n 3 channels outside the ranges but not in all the last 4 Sessions So the Warning is not yet generated On the left side is possible to define all the parameters necessary to run a program when a Pre Warning situation appears To select the program to run in this situation you can use the ES button or write directly in the field Call in If the program selected needs some parameters to run they should be put in the field Argument If the parameter S is typed the Session names separated by semicolon involved in the warning state is passed to the program as argument On the right side is possible to define all the parameters necessary to run a program when a Warning situation appears In the following picture there is an example of warning setting SOFO SDB User s Manual 20 e Defining a View SOFO SDB User s Manual View First Span 5 Measurements 6 Outputs 1 Description 2 Select Sessions 3 Select Sensors To desactivate Pre Warnings and Warnings
30. layed for the last Session It is possible to select another Session using the combo box at the top left corner To view whether a Sensor has exceeded the Warning or Pre Warning thresholds or not two methods are available e Select to view the results on the map and activate the option show warning pre warning on map on the definition view form e Click on the icon 4 If the Warning and Pre Warning thresholds have been defined then the results will be exposed in white yellow or red color accordingly to the level of Warning reached Mi Map and Warnings eia eller TE chow Pre Warnings amp Warnings E a 0527 A Dut B 24 0 0603 1 In this example is possible to observe which Sensors have exceeded the thresholds values When the view has to be saved in HTML format the software parses the source file and then creates the destination file replacing the keywords with the relative information If a keyword is missing in the source file the relative information is not placed in the correct destination An example of HTML source of a view with name ViewName may be the following lt img src graph2html ViewName gt lt TABLE BORDER 1 BORDERCOLOR b5b500 CELLSPACING 1 CELLPADDING 7 WIDTH 450 gt Table2html__ ViewName lt TABLE gt lt img src map2html__ ViewName gt the destination HTML file generated from the source will be the following lt img src graph12 jpg gt 32 e Examples of Vi
31. n 38 Getting SUDO reed petere steer perd ee HEP ERR HO DE n 38 Suggestions and bug reports 38 SDB User s Manual SDB User s Manual SDB VIEW e 1 SDB User s Manual SDB VIEW gt SDB VIEW Welcome to SDB VIEW SDB VIEW is one of the essential components of the SDB suite It enables navigation within a Measurement database SDB created by the SOFO Measurement system It provides the flexibility of simultaneously displaying within the same window several different views of fields chosen from the open database over a defined monitoring period The display can be of a tabular or graph plot format with associated options The data output could either be generated as a screen display or saved to a file format txt wmf bmp jpg Excel with the option of manual or automatic display hence allowing the generation of automatic reports that exploit the update of links SDB VIEW allows not only the management of Warning states in the form of Pre warning and Warning condition indicators but in addition triggers a corresponding and user defined display in consequence and sends e mails This document contains detailed information on the use of the SDB VIEW module of SDB suite and guides you through the specific menus and functions Window 98 NT 2000 XP Vista Installation SOFO SDB User s Manual To activate the SDB VIEW software you have to own a valid license number and enter it in the Options
32. ng state sensitivity before triggering the corresponding display FIELD Table The fields requiring definition in the compilation of this table are essentially described by For the given database SDB the Sensor data fields to be displayed in accordance with the View table The Warning values 6 SDB VIEW Overview SOFO SDB User s Manual Output The SDB VIEW output is based on the definition table View For each View table the user can define several different views Each view allows display of the output from one or several Sensors from a given database SDB from a defined number of monitoring Sessions and in comparison with a chosen reference Session The output type is chosen from table text file from table graph plot graph plot sent to file type WMF BMP JPG table or graph plot sent to the Clipboard or table showing the Warning status A particular view can be automatically generated as the SDB VIEW software loads SOFO SDB User s Manual SDB VIEW Overview e 7 SDB View Configuration Options Menu A few basic steps are required to configure the SDB software All settings required to configure your system are found in the Tools Options menu panel SOFO View The SDB View is a powerful tool that offers the possibility to view the measurements in a more consistent way at the same time offers the possibility to perform predefined action when a critical situation is discovered such as one or more value
33. on related to each view will be performed save to file alarm Please note that the update will be done only for the views that are opened The other views present on the right list but closed won t be updated SOFO SDB User s Manual Examples of View output formats 33 Agenda Default E3 Schedule Options Don t ask for user data Don t ask confirmation on Session clone Don t use optical switches Don t ask for manual connection Don t stop on errors Don t update displays between measurements rp vw Use High Sensitivity on all Sensors Use Low Sensitivity on all Sensors Zero on Session After Each Run Exit SOFO DB after finish Log to file v Log only errors Log Filename Switching between Output formats In every View there is a small navigation tool bar Halsa a Using these icons it is possible to switch between different types of views without modifying the View information stored in the SDB The icon gives the possibility to generate a graphical output in table form When this Icon is selected the table will not show the Warnings and Pre warnings but only the values The icon gives the possibility to generate a graphical output in graph form if the fields to show are of the same type The icon gives the possibility to view the result on the Map The icon saves the content of the window in a file If in the window contains a graph then a w
34. re of the map is generated In the destination file the tag is replaced by a unique picture name Usually in the source file this tag should be inside a img tag for example lt img src map2html __ ViewName gt table2html ViewName where table2html __ is the keyword indicating that a table has to be generated the ViewName is the name of the view in which the spaces are replaced with the character If during the parsing of the source file this tag 15 present sequence of row in html format are written in the destination file This tag should always placed between the two tag lt table gt lt table gt for example TABLE BORDER 1 BORDERCOLOR b5b500 CELLSPACING 1 CELLPADDING 7 WIDTH 450 gt table2html ViewName lt table gt SOFO SDB User s Manual Examples of View output formats Introduction The graphical output from each View is obtained by double clicking on the View having highlighted it or by highlighting it and activating the menu item View Open View When the following graphical outputs are selected we obtain Show Table 03 04 2003 18 03 06 13 6139 09 04 2009 20 03 03 13 6187 09 04 2009 22 03 03 13 6222 10 04 2009 00 03 03 13 6248 10 04 2009 02 03 03 13 6253 10 04 2009 04 03 03 13 6254 10 04 2003 06 03 03 13 6268 10 04 2009 08 03 04 13 6303 10 04 2009 10 03 04 13 6274 10 04 2009 12 03 03 13 6270 10 04 2009 14 03 03 13 6258 10 04 2009 16 03 03 13 6313 10 04 2009 18 03 0
35. s out of the thresholds In particularly the SDB View in case of critical situations offers the possibility to 1 Sendemailto a list of email addresses 2 Sendan SMS to a list of cell phone numbers 3 Call an external program For the action 1 and 2 is necessary to specify some parameters under tool gt options gt SOFO View In this panel can be specified all the parameters that are common to all the views The panel to configure these parameters is the following SOFO Reading Unit Other Systems Mail SMTP Server stmp ticinocom ch Sender posenato smartec ch r SMS GSM Modem Port RS232 coms Modem Connection Speed 9600 m In this panel the Mail Server and the SMS options can be defined In particularly the parameters that can be set in this panel are described hereafter In the field SMTP Server the mail server has to be specified 8 e SDB View Configuration SOFO SDB User s Manual SOFO SDB User s Manual In the field Sender the email address of the sender has to be specified this will be the email address of the sender for the email sent on critical situation In the field GSM modem Port RS232 the rs232 port to of the GSM modem has to be specified In the field Modem Connection Speed the communication speed of the GSM modem can be selected for the most part of the GSM modem the default value should be 9600 SDB View Configuration e 9 View User Interface SDB VIEW
36. ss the left mouse button anywhere on the graph area and drag up and left with the mouse button depressed Release the button and the graph will redraw to the originally defined graph area SOFO SDB User s Manual To scroll a graph across press the left mouse button and maintaining the mouse button pressed drag the mouse in the direction you wish to scroll the graph When you release the mouse button the graph will remain at the new location To undo the scroll press the left mouse button any where on the graph area and drag up and left with the mouse button depressed Release the button and the graph will redraw to the originally defined graph area Show Warning Status on Table SOFO SDB User s Manual New View2 o X e e Session AvgDate nt B Int T Out T Int B Int T Out B JB Qut 19 01 2005 20 03 30 0 0434 0 0845 0 0716 0 0980 0 0792 0 0999 19 01 2005 21 03 30 0 0437 0 0877 0 0379 00755 0 0794 19 01 2005 22 03 30 0 0451 0 0885 00402 00768 0 0832 00841 0 1074 19 01 2005 23 03 30 0 0472 00913 0 0443 0 0778 20 01 2005 00 03 30 0 0481 0 0940 0 0466 0 0809 0 0871 20 01 2005 01 03 30 0 0498 0 0955 0 0469 0 0837 20 01 2005 02 03 30 0 0507 0 0976 0 0492 0 0856 20 01 2005 03 03 30 00522 01000 0 0505 20 01 2005 04 03 30 20 01 2005 05 03 30 20 01 2005 06 03 30 20 01 2005 07 03 28 20 01 2005 08 03 3
37. t when values exceed the maximum minimum value ranges defined by stage If this option is selected the field On Warning SMS To becomes active and it is possible to specify in the CEL 66 99 text box the list of valid phone numbers separated by a The option Run on Warning Pre warning allows programs to run when a defined number of values exceed the maximum minimum Warning or Pre warning ranges defined by stage In the case of one of the following options Run on Warning Email on Warning or SMS on Warning is active it is possible to configure the Pre Warning and Warning conditions In these two frames it is possible to define all the parameters that identify a critic situation appearing The sentence Generate Warning if n channels are outside the range in the last m Sessions gives the possibility to define two parameters The parameter m defines how many consecutive measurements must be out of range since the last Session to generate the Warning The number n defines the minimum number of channels that have to exceed their threshold to generate the critical situation n the following table there is an example in which 4 and 3 The character X means that the Measurement exceeds the threshold Defining a View e 19 Channel1 Channel2 Channel3 Channel4 Session X X Session2 X X X Session3 X X X Session4 X X X Session5 X X X In this example is the critical s
38. use 0 values Min Max Pre Warnings fo 6 Relative Default Warnings 0 0 07 Name Pre Warnin Pre Warnin Warning Min warning 0 0 Session AvgDate False 500001 mm True Sofo02 mm True 5 03 mm True 506004 mm True 507005 mm True Sofo06 mm True 506007 mm True 5 08 mm True e oooooooo r Pre Warningn r Warning Generate Pre Warning if E channels are Generate Warning if channels are outside range in the last E sessions outside range in the last E sessions Run on Pre Warnings Warnings Pre Warning m Warning Call in c Posenato PreWRN EXE 0 Callin c PosenatolWRN EXE 0 Argument es al Argument es Email on Warnings On Warning Email To Jposenato smartec ch jexample smartec chjexe SMS on Warnings On Warning SMS To 0041916101800 0041789216892 5 Selection of the Measurement method Measurements This page allows the Sensor calculation mode during a Session to be chosen The first option Include forgotten Measurements and Peaks allows inclusion or exclusion of those Measurements tagged with the option Forget by the SDB software If the option is not ticked default value Measurements tagged with the option Forget are not included in the calculations The selection box Sessions with Missing Measurements allows determination of the action to take in the case w
39. wer list comprises the fields selected for displaying during the previous stage In the box Field Details the warnings and pre warnings parameters can be defined for the active Field To enable a Field to be modified you have to click the name of the field on the Name column All the parameters of the Fields will appear in the Field Details section The Pre warning fields give the possibility to define respectively the Minimum and Maximum threshold for the selected Field The Warning fields give the possibility to define respectively the Minimum and Maximum threshold for the selected Field SOFO SDB User s Manual SOFO SDB User s Manual In the Combo Box it is possible to choose how to consider the value Relative value indicates whether the Warning value should be considered relatively to the reference Session Absolute value indicates that the Warning value should be considered in terms of its absolute value The Name column gives the name of the Sensor field clicking on the cell gives the possibility to modify all the warnings parameters The second column Rel indicates whether the Warning value should be considered relative to the reference Session True or in terms of its absolute value False the direct output value given by the Sensor which can be either positive or negative The third column Pre warning Min indicates the minimum Pre warning threshold value The fourth column Pre warning Max indicates and
Download Pdf Manuals
Related Search