Home

DEMASdb

1. Introduction 9 2 2 Overview The following chapter will show you the operation of DEMASdb step by step For a short summary please read the short description below Chapter 1 This introduction Chapter 2 Chapter 2 2 will show the system requirements of DEMASdb and explains the installation and the first start of DEMASdb In addition to this the configuration management will also be explained in this chapter Chapter 3 Chapter 3 3 shows the operating concept of DEMASdb more precisely After a short introduction the individual procedures will described exactly Please read this chapter carefully Chapter 4 The desktop of DEMASdb is explained at Chapter 4 4 This chapter will explain the Toolbars which are significant in DEMASdb Chapter 5 The handling with the map system is the topic of the 5th chapter 5 This will explain the working with group and measurement windows for graphical representation Chapter 6 Chapter 6 6 simplifies the working with the measurement system It will describe the structure and the configuration of the measurement system and the various ways to import measurement values Chapter 7 The content of Chapter 7 7 describes the Devicemanager and the Devices for data exchange of measurement values This chapter explains also the backup of objects and measurement values Chapter 8 Chapter 8 8 explains how to use the document management of DEMASdb Chapter 9 The chapter 9 9 describes the
2. 36 Desktop 37 5 Desktop The Desktop of DEMASdb consists of several variant components After the first start of DEMASdb you will find an empty Desktop To show the Object Explorer the Object Toolbar the Logbook and the Object File please choose the components from the Menu Window Toolbars which you want to display If all predefined components are displayed the Desktop will have the following view fl DFMASdh 1 N4 ial ES Fle Edit Window Hep lt lt ala ei Menubar Objecttoolbar gt El Gall Murich TER 3 H gt AY Turbidity Emi Properties of Measurement Project fam 02Conzentration An 5 Infoimatior tie ff Lozger Pressure Fy a Proxesties Securty L N A 721 Theme Temp 3 p E 1 Measurernen System Tribu Objectproperties E Gal Neasurement System Folder Maat 02 10 00 17 33 29 noda Objectfile Keyworce Wass f FA MeasurementProjest Object Explorer E Germany Changed at 200100827 oH cita EU Berlin Content changed at 02 10 00 17 33 29 E ce fu Logger CC ic m Logger Presstre Mi L m Frankfurt ee mi Kaufbeuren Cancel asl a Italy Augs co El Fotriowal Eo Single Senso TA HLG 2 Mans Xl E Mm dl 372812 00 09 52 44 Information Reading measurement vales from fil2 DIOLD_DIFERNWARTUNGIBADLIEBEN A 3 2812 00 09 52 45 Information Logger A00998 created 9990 49 00 00 57 48 Information Cimnla Nay Bins Concor ANNAR E AN
3. DEMASdb Setup creates the following subdirectories Database Contains the working database Bitmaps Contains the used bitmaps Registry Contains the local settings 2 Dialog Selection of the active Database This dialog will only appear if the setup program is not able to locate the path to the working database Please enter the correct directory path where the database is located 3 Dialog Information about the Configuration In this dialog you can insert additional information of creating date creator and comment This information will be stored as text in the config ini file After the confirmation of the 3rd dialog with Next DEMASdbSetup will backup the configuration files If no error occur the dialog Configuration Management of DEMASdb would be displayed again otherwise an error message will be shown and the backup process will cancel Do not try to load a aborted configuration 3 8 2 Load configuration as active configuration This function will make a saved configuration to an active configuration All data of your active configuration will be overwritten DEMASdb Setup will ask you if the active configuration shall saved before Is this the case please select Yes in order to start the Backup The setup program shows the following dialogs 1 Dialog Select the saved Configuration Folder Please insert the destination folder which contains the backuped configuration 2 Dialog Selection of the active Database This di
4. 3 4 1 Setup The setup of DEMASdb will direct you with dialogs during the installation Are the settings in a dialog finished please click to the Next button for the subsequent dialog or use the Back button in order to get to the dialog before You can cancel the installation process by using the Cancel button 3 4 1 1 Start the Installation You can start the installation of DEMASdb by a double click on Setup exe on the CD ROM After the start the welcome dialog will appear which follows you to the installation of DEMASAab The next dialog shows the licence information Please click on Yes if you agree to the licence conditions The following Information dialog shows further notices 13 DEMASdb 14 Select the type of installation After this introduction you can select in the dialog Select Components with the following options a retain he fect lato on a Comput choose an Instal Option 1 you hive abnady ralalied DEMASA on your System chome an Update option jra Cerne Cieri M inaa Deman08 Chere Update Dema0 Chera Databaie Update DemarD8 Chera Ya mH J Cancel Overview about the Databasesystems used with DEMASdb e Install DEMASdb Database Installation on the first workstation Please select this kind of installation if you did not use DEMASdb before This means that neither program files nor databases are installed The database have to installed only one time for the multi user v
5. Information Properties of File ASCII Bulk Select charts Security Filename c Mtemp _test txt Filetype ASCII Bulk y Properties of File At the Page Properties of File the following settings can be selected e Filename In this field the filename of the created exportfile shall be set If the export will create only one file it is possible to use a filename But if the export shall create more than one exportfile it is necessary to use a replacing command at the filename in order to create unique filenames see below e Format of the File In this list it is possible to select the format of the exportfile Depending on the required fileformat additionally settings will shown 103 Taskmanagement 104 Page Formatsettings Properties of Exporting task Information Properties of File ASCII Bulk Select charts Security General format options Separator Oh oF C Others Column Titles Column format options SensorlD Serial Channelnumber x Date Windows short v Time Windows short y Value Decimal symbol Standard x Post decimal 2 E yes X 0 ue Example Formatsettings of an Exportfile Dependent of the selected fileformat an additionally page with further settings will shown See example above Page Selecte Charts Properties of Exporting task Information Properties of File ASCII Bulk Select charts Security Last expor
6. Measurement System E al Measurement System Folder EE Measurement Project B Berlin m ig Logger EC m f Logger Pressure HE Frankfurt Ea Kaufbeuren a Itay iY Retrieval H 2 Maps o 3 Desktop a Toolbars E Event Viewer m Exec ToolBar Object Explorer Objectfile Objecttoolbar SJ 4 Devicemanager Archive Ger t 3 Chart Device 3 File Device 4 HT100 Lo100 s3 Manual Input S Monthly Report Ei a 5 Documents Templates The Object Explorer Through a single click up the symbol all child elements will opened With one click up the symbol the sub tree will be closed Both action can also executed with a double click on the Object Symbol 41 41 Desktop 42 The Context Menu of an Object can opened by clicking the right mouse button A double click with the left mouse button on the Object Name will execute the default action Objects can move copy etc to other positions using Drag amp Drop For the actual selected Object further actions with the keyboard are possible The Del key remove the Object The Ins key creates new subjects Through the return the default action will executed The Context Menu can also opened with the Context Menu key on windows keyboards In addition to the selected Object mostly used Menu Entries can also execute over the Object Toolbar Context Menu The Context Menu of the Object Explorer contains the additional menu entry Show Properti
7. The accessdata for the Database Examples WORK SDEFAULT Fritz SDIALOG is conform to Fritz SDIALOG ARCHIVE SDEFAULT Dietmar SDEFAULT is conform to ARCHIVE Dietmar 19 DEMASdb 20 3 8 Configuration Management DEMASdbhave an built in configuration management This means that it is possible to save all data of the active configuration and restore a configuration which was backed up before Configuration data are global information which are stored in the working database e g measurement values properties of the groupwindows as well as all pictures and local settings e g parameter for the query of LG100 HT100 All data in the archive database are not backuped by the configuration management NOTICE At this time the configuration management of DEMASdb is only be able to save data from Paradox Databases Further esp SOL Databases will exists soon The configuration management of DEMASdb can use for the following actions e Creating a backup of the actual configuration save e Copy a configuration to other target systems save and load e Upgrade from a single user version to a multi user version move The DEMASdb Setup program which is located in the program group of DEMASAdb is responsible for the configuration management Several dialogs will ask for required information With a click to the Next button you reach the following dialog The Cancel button can abort the current acti
8. 7 1 5 Step 5 Links Below measurement catalogues and normal catalogues it is able to create links to other objects So it is possible to create direct Links to a group window in which the measurement values of a measurement station or a region can display It is also possible to generate a report with selected Sensors For this you have to create a new measurement catalogue and rename it in the manner of the report Please drag all necessary Sensors Logger or Catalogue Objects to this catalogue Select the entry Link from the displayed menu where the link shall be insert to the Sensor When a report will create with the menu entry Write measurement values all Objects which are linked will included in this report How to create Links 62 Measurementsystem 63 7 2 Import Measurement Values DEMASdb stores measurement values into a database therefore the measurement values have to import The import will done by the Retrieval Object which must create and configured for this action Only after this it is able to import new measurement values from Files or Devices HT100 or LG100 which are connected to the computer by serial interface This measurement values will distributed to the Sensors below the Retrieval Object identified by their serial and channel numbers Is no Sensor found with this identification a new one will create and configrate automatically 7 2 1 Distribution method for measurement values The distribution of m
9. Each entry in the Objecthierarchy is an Object Therefore a Sensor is an object but also the Desktop or the Object Explorer The basic properties of each object will be determined by the Objecttyp An object can be compared with a concrete fruit a certain kind of crop It exists as a kind of crop an apple An concrete apple is conform to an object A kind of crop is the Objecttyp in generally objectproperties About the object properties it is able to configure the objects This can be select at a dialog which consists of several pages On each page the settings for the object are placed thematically The object properties where display by the selection of the menuentry Properties in the Context Menu objecthierarchy The most important component of DEMASdb is the objecthierarchy The object hierarchy display all objects as a hierarchical directory structure Each Object except DEMASdb possesses an superior Object According to the Objecttyp it is able to append similar to a directory structure subordinated Objects But it is also possible that an object has no child Objects The objecthierarchy is display in the Object Explorer and can also change there objecttypes The properties for each Object will basically define by it s type Different object types exists An object can be compared with a certain kind of crop apple lemon pear In DEMASdb Logger catalogue and Toolbars exists One of the basic properties on an object is the c
10. In order to insert new objects you chose the menuentry New in the Context Menu A dialogbox as shown below appears and display all the Object which are able to create on this place in the Objecthierarchy Select objecttype x Le Calculation Filter Catalog i Logger A Simple Day Block Sensor A Simple Sensor Co j c Choose an Object Choose the requeasted Objecttype and confirm with OK The new Object gets an standardname automatically which can changed in the following Dialog The User must have the Userright Change Configuration in order to create an new Object 4 2 2 Delete Objects With the help of the menuentry Delete from the Context Menu you are able to delete an Object If this Object have one or more Subobjects all this Subobject will also be removed Attention There is no possibility to undone a deleted Object For important Objects or deleting more as one Objects together DEMASdb will ask a request that must be confirmed by the user The User must have the access right Change Configuration in order to delete Objects 24 Operation 25 4 2 3 Rename Objects You are able to rename an Object by using the menuentry Rename in the Context Menu or press F2 At the the Dialogbox which appears you can change the name If you finished please press OK to use the new name Rename an Object The User must have the access right Change Configuration for this Object to rename this Objects 4 2
11. Information Properties Calculation Events Security Type of Calculation e Polynomcalculation Description jatasources Name Sourceobject x FPOZEC Parent Coefficients Propertypage Calculation As shown above the configuration consists of three steps 1 The field Type of Calculation contains a list with all the existing calculating functions The open combobox will list all available functions in a tree structure as like as the Windows Explorer With the help of the cursor keys it is able to navigate to the listed functions SPACE key will open or close a sub tree The RETURN key will select this entry Some calculation functions allows adjusting the calculating methods In this case the button with the three dots will be activate Depending on the selected calculating function it is able to select Datasources from a list which can connect to one or more sensors The column Name will show the name of the measurement parameters The second column shows symbol and name of the connected sensors Change the sensor by activating the item then click onto the button with the three dots In the following dialog you are able to change or add other sensors as Datasource Notice the text Parent means that the parent sensor was linked to this object as data source for calculation instead of a manual selected Sensor This means that after you had moved this object to a new object
12. where the Objects should be inserted and the inserted Objects it is possible to select more than one Objects at once After this please click on the button A The 97 Devicemanager 98 assigned Objects will marked with the x sign at the end of the Object name With a mouse click on to the V button the Objects will move back to the list Options for Sensors For Objects which contains restore has Sensors it is possible to decide if it s measurement values also shall restore Select Restore measurement values In the input fields Left and Right it is able to set the required time interval begin end date Attention All measurement values which are stored within this interval in the working database will overwritten Overwriting measurement values The action that should execute in order to overwrite measurement values or not select one of the following possibilities Do not overwrite Measurement values will never overwrite 2 Request User A dialog box will appear in which you can decide if the measurement value for this Sensor should be overwrite 2 Overwrite Always To overwrite measurement values always Notice 2 No measurement values of the Sensor will archived if the existing measurement values should not be overwritten A click on Start Restore will start the backup for all selected Objects The progress will show in a separate dialog You can also cancel the backup in this dialog 98 Documents 99
13. which is given to the Serial Device in the Device Manager Therefore it is meaningfull that the Objects get the name HT100 respective LG100 91 Devicemanager 92 Device properties On the Device properties page of the Objectproperties for the Serial Devices it is able to configure the access to the hand held equipment Information Device properties Security C Deactivate Device Activate Device Devicename HT100 Interface COM1 X Baudrate 9600 X Cancel after 600 seconds The Properties of Serialdevice in DEMASdb e Deactivate activate Device Deactivate or activate the Device In order to set up the properties the Device must be activate and only than the Device will be display in the menu read measurement values from e Devicename If this device is used to read out the hand held equipment HT100 the text HT100 have to set to this field Please set LG100 for the hand held equipment LG100 e Interface Insert here the number of the serial port of the computer which the hand held equipment is connected e Baudrate speed Set the transfer rate of the hand held equipment here The LG100 works with Baudrate 9600 The transfer rate of the HT100 can set in the handheld device However mostly used Baudrate 19200 e Cancel after seconds In this dialog field it is able to set the length of time as a maximum period for transferring measurement values Is the transfer not finished until this time an e
14. 1998 B00070 1 24 5759 14 09 1998 B00070 1 24 2621 31 08 1998 B02105 1 19 8525 07 09 1998 BO2105 1 19 9983 14 09 1998 BO2105 1 19 5663 31 08 1998 B00190 1 14 7875 14 09 1998 B00190 1 14 8452 NOTICE If the Export of Middle Values per Week do not exist in your DEMASdb version you have to activate the device Middle Values per Week at Devicemanager first 82 Measurementsystem 83 7 5 The Measurement System Catalogues Measurement System Catalogue Objects are build for organize the Retrieval Objects and can create directly below the Measurement System It is also possible to use Measurement System Catalogues to gather Sensors for Reports or to create links to Groups and or Document windows Context Menu With the selection of Chart or List in the Context Menu it is able to show the measurement values of the Sensors below in MGMDS or MLDMS In order to generate a Report for all child Sensors please select the menuentry Write measurement values 7 6 The Catalogue Catalogue Objects can create in the measurement system in order to organize Retrieval Objects Logger and Sensors in an easy to follow manner It is able to subdivided Catalogues in any case e g to represent a region Below the Catalogues you can create Links to other Objects e g Group or Document windows Context Menu With the selection of Chart or List in the Context Menu it is able to show the measurement values of the Sensors below in MGMD
15. 4 Link Objects The Link Object in DEMASdb means that an Object owns a link to an other Object This was applied to Measurement Window Objects which owns a Link to a Sensor showing the actual measurement value A Link exists till the linked Object will be deleted or a new Link is created from or to an other Object Objects which are Link to other Objects receive the name of the linked Objects Furthermore their Context Menu will extended with the menu from the linked Object Links also could be created and renamed with the help of Drag amp Drop About this the Object on which shall referred dragged to this Object which shall own the Link Here by the appearance of the mouse cursor will change if the Link is valid a little box with a hooky arrow appears After you release the mousebutton the Link will be created Ref to the example above the Sensor must dragged to a measurement value window The User must have the accessright Change Configuration to this Object in order to create or change Links to other Objects 25 Operation 26 4 2 5 Search Objects DEMASdb provides a comfortable possibility to search for Objects It is able to use different search criteria which are applied to the Object It starts in a hierarchical manner from the point which 1t was started The Objects that are found will be shown in the Objectfile In order to search for Objects please select the place at which you will start the search in the Objec
16. 7 1 3 Step 3 Create Directory Structure jis scenic seaaigacieiaddoanusatuianudane 61 FLA Step A A EEEE ESE 62 PANES s LINKS e a a a a a E de T 62 T27 Import Measurement MS ae a e a a A tia 63 7 2 1 Distribution method for measurement values ooooococnnococonoccnoonnnononcnnnnnccnonaccnnnnno 63 7 2 2 Import Measurement values from Pile iicsi s cccesssec scesseedcntsstesescadesscedosnteceveanedantacs 64 7 2 3 Import Measurement Values automatically from Files 65 7 2 4 Import Measurement Values from HT100 and EG 100 oooconncccnccnnocnnonncnoncnannninnnon 66 7 2 5 Manual Input of measurement controlvalues ooooconnnococnnncccnoncnonnnccnnancnnnnnccnnnnoss 66 1 3 Evaluation of Measurementdata vei cicciesicesscascsccsessghessanasicesddavetes tobe daceadntabunataetencauwede 67 Fast gt Functions 11 POZA A E as 67 1 3 2 Braliation with Sensor Saas dd 68 Povo Calculating FUNCHONS id iii 70 LIA Otganization cc read da 78 O E 0 E E E AE 79 TAT Monthly Reports E E E EE TAE E a E 79 7 4 2 Middle Values per Week scisisicccsscssdeacisssidesinsdeaasa svagaacsanescaes nccsantebageletaasieaes Gedadaase 81 Na The Measurement System Catalogues Measurement System Catalogue 83 TO The AIO OU Ses As 83 Usb TER A ae ae Ga dane ccch A oa a ER Ea 83 7 8 The Lori 86 TY 1 ThE SENSO aii nl ip 87 LOL Thesimple ES is 88 143927 The Simple Day Block SEO ds 89 19 3 The Calculating ens a 89 7 9 4 The Calculating Day Block S nsO0y
17. 865 Car 240800 1206 Tia 0312 2405 00 1206 Wassers 7 964 PR 24 05 00 1208 Redoxs 103 700 Measurement value window 24 05 00 12 06 2 Ke p 2405 00 1206 pt 7 188 Multitext hwab 24 05 00 12 06 Leitf h 0 628 5 Measurement value window Text Measurement value window Wamlicht The Groupwindow in DEMASdb By using Groupwindows you are able to show very descriptive the allocation of the measurement stations in any regions About this you have to load a map of the region as a backgroungpicture into the Groupwindow On the respective place on the map you can set up measurement value windows which display a different view of actual measurementvalues of a Sensor You can also create Grouplinks to Groupwindows which refer to other Groupwindows within a more detailed view of the region or point to a Document window with further information You can create a new Mapwindow where you select the Mapfolder in the Object Explorer and create new Object Choose the Objecttype Groupwindow and a new empty Groupwindow will appear Context Menu A Groupwindow can also make invisible by selecting the menuentry Close in the Context Menu You can show closed windows again if you choose the Menu Entry Show at the Objects Context Menu 49 Mapsystem 50 Setting up the backgroundpicture You can insert the backgroundpicture by the Objectproperties when you select the page backgroundpicture You get access to the Context Men
18. 9 Documents With the Documentation Management of DEMASdb it is able to work with any documents which are supported by OLE Servers Programs which supports OLE are for example Microsoft Word Microsoft Excel CorelDraw and so on The documents will be store in the working database of DEMASdb but the OLE Server is responsible to display or edit the documents The most used OLE Server has the property of inserting into the Desktop of DEMASdb so the file can be viewed and edit by DEMASdb In DEMASdb it is also able to administrate additional Document templates This are Documents which are the base for normal Documents e g templates for letters and so on 9 1 Documents 9 1 1 The Document Folder The Document Folder is used for hierarchical organisation It is possible to subordinate and name the Document Folders in any case Below a Document Folder the Documents will create Context Menu In the menuentry Import Documents from file in the Context Menu it is able to import existing documents from a file to the database of DEMASdb In the following dialog you can select one or more files A click on the Open button will start the import process For each file which can edit with an OLE Server an own Document Object will create After this the Documents can move to other Document Folders and rename Such kind of documents which are imported with the help of this Menu Entry can edited in DEMASdb but changes will only store at the docume
19. Properties of the measurement value window bars Top bottom limit Here you can set the top and bottom limit of the displayed measurement value Save as basic adjustment Select this option if you want to save this settings as default for all other new created measurement windows of the same type 55 Mapsystem 56 6 4 3 Measurement Value Window warninglight The measurement value window warnlight The warnlight displays the state of a measurement value of the linked sensor in shape of the color value which is set on the Global Settings page Properties The size of the warnlight can set on the Properties page at the Objectproperties Ir cemalion Properes Global process Socair Properties of measurement value window warnlight Diameter Here you can select the size of the warnlight in Pixels Save as basic adjustment Select this option if you want to save this settings for all new created measurment value windows of the same type The settings will automatically accepted 56 Mapsystem 57 6 4 4 5 4 4 Measurement Value Window multitext Date Time Unit Value 10 05 00 11 38 m3 s 60565 317 DMAS00 10 05 00 13 00 m3 s 172463 417 DMASOO 10 05 00 1200 m3 s 7716 817 DMASOO ee ke v lt 3 DMASOO 10 05 00 12 02 m3 s 7383 97 DMAS0O Measurement Sation EAST The measurement value window multitext This measurement value window show the actual measurement value of all Sensors in a list On the Properti
20. Tasks of DEMASdb Chapter 10 The chapter 10 10 describes the Job Management of DEMASdb Chapter 11 The finally chapter 11 11 contains a glossary which an explanation of the mostly used terms Introduction 10 2 3 Typographic Conventions The following list shows the used conventions in the documentation Save as DEMASdb Surface Link Shift b Function x Dialogs elements of dialogs and Menu Entries are being written in bold letters The way to a Menu Entry will wrote completely Each step is separated by the character I Names of programs and registered trademarks where shown also in bold but upper case Any inputs where shown in slanted fonts Links to further information or descriptions where shown in blue letters A key which should pressed on the keyboard where bordered in square brackets If it is necessary to press more keys together this keys where added with plus signs Code clippings outputs to files or screen where shown in a non proportional font 10 DEMASdb 11 3 DEMASdb 3 1 Distribution DEMASAdb is available on a CD ROM Volume and can ordered at SEBA Hydrometrie GmbH An update or DEMO Version can also be downloaded from our Internet page at URL http www seba de download DEMASdb DEMASdb html The Setup Versions at the Internet could be use as a test installation by using the attached DEMO Licence file but only on one workplace Should you own a licence o
21. The Property page is located in the dialogbox of the Objectproperties Here it is possible to set the Serial and Channelnumber for identification of the Sensor For further information see chapter 6 3 90 Devicemanager 91 8 Devicemanager DEMASdb use Devices for data exchange or to display measurement values By default all Devices are configured properly but for some Devices it is possible to adjust it to the used hardware Ml 4 Devicemanager Archive Ger t Chart Device amp File Device Y HT100 Y 16100 The Devicemanager in DEMASdb The Devices can used at the menu entry read measurement values from and or write measurement values of the Objects in the measurement system The name of Devices will also display there One exception is the Chart Device and the Archive Device which are display in separate menu entries By using the accessrights it is possible to prevent Users only from import measurement values but not to show measurement values with MGMDS MLMDS The assigned accessrights are valid for all Objects which uses Devices 8 1 The Serial Device The Serial Devices in DEMASdb serve to read measurement values from the hand held equipment HT100 and LG100 For each hand held equipment an Object with the type Serial Device have to exist If this device is active the menuentry read measurement values from will appear in the Context Menu of the Object The text of the menuentry is conform to the name
22. Therefore it is possible to create evaluations with depending from measurement values before 7 3 3 4 1 Formula Calculation and Template Formulas can defined in two ways Formulacalulation A Formula will assigned to the sensor object only and can not used with further sensor objecs The advantage of the method is that it is not able to create and configure a template at each using Formulatemplate With the template it is able to use several Sensorobjects and define individually parameters to each sensor object In order to use the Formulartemplates it is possible to create a new object of the type Formulatemplate as achild object of the Calculationmanager or of a Formula collection On the page Formula the Objectproperties it is able to create teh formula with the help ob Formuladesigner 73 Measurementsystem 74 7 3 3 4 2 Configuration Informationen Berechnung Sicherheit Berechnungsart Wa Formelberechnung y J Description Zusammenfassen und Multiplizierenn Datenquellen Name Datenquelle xl Kaufbeuren Parent x2 A Pegel Parameter Name Wert Backviewlnterval 0 Factor 4 0 Calculation function Formula Page Calculation In order to use the formula calcualtion it is necessary to select in the list Type of calculation the entry Formula calculation With a click on the button three dots it will open the dialog Formuladesigner Here it is able to edit the selected formula see below
23. Value Binary datatype with the values true and true false false TSISDateTime Date Time Value Value which represents a Date and or Time for calculation time range 114 Appendix 13 1 2 Operators Existing operators will used to combine measurement values Consisting of two or three operands which can be a constant value variable or function result 115 Symbol Meaning Description Example addition sum of two values 4 9 13 substraction difference of two values 4 5 2 0 4 5 h multiplication multiplication of two values 1 2 4 5 5 4 division division of two values Is the 15 0 3 0 5 divisor 0 the result ist not valid mod modulo the result is the rest of the 11mod5 6 division Zi choice of an alternative Tests the truth of an expression true 4 5 4 false 36 4 4 0 4 0 gt grater than Compares two values 4 0 gt 5 0 false 5 0 gt 1 0 true 3 0 gt 3 0 false lt less than Compares two values 4 0 lt 5 0 true 5 0 lt 1 0 true 3 0 lt 3 0 false gt greater or equal than Compares two values 4 0 gt 5 0 false 5 0 gt 1 0 true 3 0 gt 3 0 true lt less or equal than Compares two values 4 0 lt 5 0 false 5 0 lt 1 0 false 3 0 lt 3 0 true equal as Compares two values 4 0 5 0 false 5 0 1 0 false 3 0 3 0 true lt gt not equal Compares two values 4 0 lt gt 5 0 true 115 5 0 lt gt 1 0 true 3 0 lt
24. at the appendix 111 Glossary 112 12 Glossary In this Glossary you will find short explanations about the used keywords in this User manual The Keywords are listed in alphabetically order working database DEMASdb use two different databases The working database which contains all currently used configuration data and measurement values The second database is the archive database This database is used to backup copy or move configuration data or measurement values in order to reduce the size of the working database If you use the archived data at any time it is able to restore copy the required data back to the working database archive database look at working database Accessrights It is able to grant individual rights to each object for every user By the way of withdrawing rights it is able to prevent objects for unauthorised access or involuntary changes A user will be identified by his login name under Windows To grant accessrights which can configured on the security page at the object properties databases DEMASdb can work with the Desktop Database Paradox and also with Server Databases also SQL Database by Oracle Informix and Microsoft The Desktop Database is designed for single user system but it is also possible to run it in a multi user system Better suited for multi user systems are server based databases Thery are optimised for networking possibilities in order to get a higher processi
25. calculating functions will consists of one or more data sources as measurement supplier and or furhter parameters The result is a list of calculated measurement values 7 3 1 2 Cascading calculating functions The result of a calculation can use as database for the next calculation again Hereby it is also allowed to use the result in several following calculation functions Therefore it is possible to create complexe evaluations functions Notice It must be pay attention to prevent creating direct or indirect recursion loops with the cascading In this case the calculation will endless repeat and DEMASdb will stop working 67 Measurementsystem 68 7 3 1 3 Calculating Period For the calculation only the absolutely necessary measurement values will be used Only the Start and Stop Date Time will limit the calculation period In order to determinate the calculating time period several ways are possible E g for new calculation the user had the posiblility to set the time period by himself or the time period will fixed by using the first and last measurement value which was imported from file 7 3 1 4 Fixed and Variable Datasource The calculating differs between fixed and variable data sources e Variable Datasources do not store measurement values They had only access over a limited range of the measuremen values Such kind of object is the Loggerobjekt when importing measurement values e Fixed Datasources store measurement
26. cats 115 13 1 3 Generic and Predefined Variables o 00 45 sssassssesaecesnaseesssbesennasnenscdesntccereneedaats 116 13 14 Optional Parameters unos ion 116 E is A A A E EEE 116 13 1 6 Mathematical Pune ions a tado 117 13 1 7 Functions for Dates ME IO E da cid 119 13 1 8 Functions for TimeintervalS vs diran irene erica 120 PI A A EEEE vaa 121 Introduction 8 2 Introduction Greatly appreciated to DEMASdb DEMASdb is developed for administration and processing large amounts of measurement values with access by several user at the same time Therefore a special emphasis was multi user functionality flexibility and simple operation Thereby it is possible that a large number of users always have access to the database without any collisions Across the configurable user rights it is able to set different limitations to users The configuration possibilities are global organised so that it is possible to adjust DEMASdb to any special area of work The consistent operating concept and user management enables an intuitive and ergonomic work with DEMASdb DEMASdb supports by now the database systems e Paradox Desktop Database e Microsoft SQL Server Version 7 0 e Oracle SQL Database Version 8 0 5 up to 9 2 e Informix SQL Database Version 7 0 5 MySQL 4 5 For not listed database systems please contact SEBA Hydrometrie GmbH for further information 2 1 Target Group This User manual is written for Users who work with DEMASdb
27. folder exists you must confirm that the configuration will copy to this destination folder After the confirmation with Next DEMASdb Setup will move the configuration files If no error occur the dialog Configuration Management of DEMASdb will display again otherwise an error message will be shown and the move process will cancel 22 Operation 23 4 Operation At the center of DEMASdb stands the Object which is used in various possibilities So exists for e g Objects which represents a Logger or a Sensor But also Groupwindows and Toolbars are some kind of Objects The type of an Object will designated as an Object type All Objects are ordered in an hierarchical tree oriented structure similar to the Windows Filesystem This means that each Object have exact one superior and no or several subordinated Objects The Objects are shown in the Toolbar Objecthierarchy For the execution of actions each Object have an own menu the Context Menu which can be open with a right mousebutton click Some often used actions can also be executed with an double click with the left mousebutton or by using the Drag amp Drop mechanism You are able to configure an Object with the Objectproperties shown in a window and consists of several pages The windows can be shown by itself or in context with the Objectexplorer or the Objectfile It is possible to assign each user individual rights for the Objects In the case to prevent Objects from un
28. functionality implements actions for Objects such as move copy automatically linking and creating Objects Using Drag amp Drop action clicking to an Object and holding the mousebutton Move this Object above to an other Object and release the mousebutton Depending on the target position the figure of the mousepointer will change if an Object will moved linked or copied see below By pressing a key combination by lifting the Object you are also able to select an other mode Shift is standing for the left or right Shift Key Copy Ctrl Move Shift Link Ctrl Shift Copy Content Shift Alt Move Content Ctrl Shift Alt If you use the right mousebutton for Drag amp Drop actions a menu with the possibilities is shown T t Drag amp Drop Menuentry Link This entry creates or changes a links The Object on which the dragged Object was dropped refers to the dragged Object T Drag amp Drop Menuentry Copy This entry creates a new Object which is an exact copy of the dragged Object e Drag amp Drop Men Menuentry Move Move the Object to a new position T Drag amp Drop Menuentry Copy Content Copy the content of the dragged Objects to an existing Object e Drag amp Drop Menuentry Create Link Here you can create a Link on this position where you drop the dragged Object similar to a shortcut under Windows9 and Windows NT ss Drag amp Drop Menuentry Move Content By the selection of this menuent
29. gt 3 0 false Appendix 116 13 1 3 Generic and Predefined variables The special variables below can use always MEASUREMENTVARIABLES The measurementvariable contains for each used datasource the measurement value for the required time It is able to access to the measurementvariables by its name which was decleared at the formuladesigner see chapter 6 3 3 4 3 at the list Measurementvariables t This variables contains the time of a measurement value which is actually used The variables can define within the formula definition CalcStartTime The variable CalcStartTime defines the date and time of the start timerange where the calculation shall start CalcStartTime can also used to define as parameter CalcStopTime The variable CalcStopTime defines the date and time of the stop timerange where the calculation shall stop CalcStopTime can also used to define as parameter 13 1 4 Optional Parameters For the formula calculation the following optional parameters exists BackviewInterval With the parameter BackviewInterval it is able to load measurement values which was created befor the calculation interval This parameter should be used if the calculation had to access to measurement values which was created befor So it is possible to insert measurementvalues with no gap It is not necessary to use this funcion at each calculation therefore this function is optional 13 1 5 Generic Functions These special functions c
30. icse ssceessccessssassvadsnestesynassaneswonsedesvaseaeesecedaness 89 1 9 5 Ri sor a E ancl nds serach se ange caine vases 90 Su WIE VICCMI A A ci 91 8 1 The Se al Dr ici ido 91 8 2 Whe Chart Devil ia 93 8 3 Th Fil DEC A A A A A 93 Contents 7 8 4 The Device for Monthly Report s ssssssssssesssesessseessessersseesseeessseesseesseesseessseeessees 93 8 5 The Device Middle Values per Wet ees 94 S6 The Manual Input Dc n ia E a EA E E E ERER as 94 8 7 The Archive DEVICE ninia a N E a 94 dl E Backup Or ODE dd ad iii 95 8 7 27 Restore OBESA Saab Rennie as 97 OS 99 9 1 A a Oa Sw Aare LAO Reena 99 9 1 1 The Document Polder necio ao eiii 99 92 MEM IOC UME Cs ixcicc uaccascov cites a daa causenest an ceaisan a a AES 100 9 13 Fhe Document trom Temple a EAE TN 101 OD Template aii Ain 101 9 2 1 The Document Template Polder iuris aten 101 92 2 The Doc ment epa de 101 10 as Kiana cm it O ca gaasenduasauca ST 102 10 The EX DOr Metask tn IIA eS E EEEE A Eas 103 10 2 Collection of Exporting tasks 1 cccs shassaasedendcassasesvasceveaed cossacdassienetatecssanisdecnceeseaveaes 107 11 SCAT aT in 108 EA SINS CU NC de 109 A O ati envanaisieatisisea ede ace nasa aie aude Renae 110 A A TAG 3s chen chet apnea ca A ce T 110 NAS 111 12 Rh OS SANG DS 112 13 Appendi K erinnern oe ia a easiest a e t e ea eoii 114 13 1 Formula Referendo E aE E E i 114 SE DD EA 114 AA ssp sche ncteseoxlen ccttate ia a a a a a cates teenie Jat
31. in the Documentation through a procedure different from that set forth in the Documentation or iii to refund the license fee you paid for the Software Contents If you have obtained an evaluation copy of the Software and have not purchased a license to the Software SEBA makes no warranties of any kind with respect to the media if any on which the Software is furnished and such media is provided as is and without warranties of any kind Warranty Disclaimers THE SOFTWARE THE DOCUMENTATION AND EXCEPT AS PROVIDED IN SECTION 5 THE MEDIA UPON WHICH THE SOFTWARE IS RECORDED IF ANY ARE PROVIDED AS IS AND WITHOUT WARRANTIES OF ANY KIND EXPRESS STATUTORY OR IMPLIED INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE The entire risk as to the quality and performance of the Software and the Documentation is with you Should the Software or the Documentation prove defective you and not SEBA or its distributors licensors or dealers assume the entire cost of all necessary servicing or repair SEBA does not warrant that the functions contained in the Software will meet your requirements or operate in the combination that you may select for use that the operation of the Software will be uninterrupted or error free or that defects in the Software will be corrected No oral or written statement by SEBA or by a representative of SEBA shall create a warranty or increase the scope
32. list of the currently used accessrights The column Name shows the name of the account The column Rights shows in the brackets the assigned rights shorted by one character and in front the name of the accessgroup ref Access Use Add to attach a new Account in the list A further Dialog Choose User Groups appears which you can add one or more accounts To delete a selected account from the list click to the Delete button e Access Here you are able to set the accessrights for the selected account On the selection list you can choose for each Usertype a profile which was made before The detailed accessrights are shown in the dialog field below If you choose the profile Userdefined you can put together the individual Rights with a click to the belonging checkboxes To assign the changed accessrights to this Object click on the OK button and the dialog will close The User will ask if the changed accessrights shall also 31 Operation 32 assign to all childobjects too Through a click to the OK button the access rights will assign to all childobjects Choose User Groups User or Usergroups which can added to the accessrights management will shown in this dialog E Choose User Groups x Show Names of SEBANT Names Name Kommentar E Sattler Sattler Marcus 30 e Satzger Satzger Christian Softwareabteilung amp Scheuermann Scheuermann Pe Sekretariat seba SEBA Benutzer Prasentati Softwareabtei
33. of this warranty SEBA DOES NOT WARRANT THE SOFTWARE AGAINST INFRINGEMENT OR THE LIKE WITH RESPECT TO ANY COPYRIGHT PATENT TRADE SECRET TRADEMARK OR OTHER PROPRIETARY RIGHT OF ANY THIRD PARTY AND DOES NOT WARRANT THAT THE SOFTWARE DOES NOT INCLUDE ANY VIRUS SOFTWARE ROUTINE OR OTHER SOFTWARE DESIGNATED TO PERMIT UNAUTHORIZED ACCESS TO DISABLE ERASE OR OTHERWISE HARM SOFTWARE HARDWARE OR DATA OR TO PERFORM ANY OTHER SUCH ACTIONS Any warranties that by law survive the foregoing disclaimers shall terminate ninety 90 days from the date you received the Software as shown by your receipt Limitation of Liability YOUR SOLE REMEDIES AND SEBA s ENTIRE LIABILITY ARE SET FORTH ABOVE IN NO EVENT WILL SEBA OR ITS DISTRIBUTORS OR DEALERS BY LIABLE FOR DIRECT INDIRECT INCIDENTAL OR CONSEQUENTIAL DAMAGES RESULTING FROM THE USE OF THE SOFTWARE THE INABILITY TO USE THE SOFTWARE OR ANY DEFECT IN THE SOFTWARE INCLUDING ANY LOST PROFITS EVEN IF THEY HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE You agree that SEBA and its distributors and dealers will not be liable for defense or indemnity with respect to any claim against you by any third party arising from your possession or use of the Software or the Documentation In no event will SEBA s total liability to you for all damages losses and causes of action whether in contract tort including negligence or otherwise exceed the amount you paid for this product SOME STATES DO NOT ALLOW LI
34. shall display if one of the listed condition change The settings of the colors is fix for all measurement value windows of the whole system You can change the color of the state if you make a double click onto the left mousebutton on the color box In the following dialog you can select a new color If you press the OK or Apply button the settings will accepted for all measurement value windows 52 Mapsystem 53 Access rights Measurement value windows will only display if the User have the accessright Show Contents To change the size and position of a measurement value window the accessright Change Configuration is necessary In order to show the measurement values the user must have the accessright Show Contents for the linked Sensor 6 4 1 Measurement Value Window text The measurement value window text The Measurement Value Window text display the actual measurement value of the linked Sensor in text format It is able to set individual type of representation in the Properties page Properties At the Properties page it is possible to set up the format of Value Infomation Properties Gkbal properes Security Fomat tater innen T Save basic adustments The properties of the measurement value window text 53 Mapsystem 54 e Format of Value In this input field it is able to set up the text which shall display in the window e Save as basic adjustment Choose this option if you want to set t
35. the Sensorname it is also able to use wildcards e Sensorname The inputs in the field Sensorname makes it possible to control the naming of automatically created Sensors This is able with templates where you can also use wildcards The wildcards will replace with the respective values during the import e Collecting Catalogue By the specification of a name in this field all new created Logger and Sensorobjects will created in a separate Catalogue In case that the Catalogue do not exist the Retrieval will create the Catalog automatically e Save basic adjustment Select this option if you want to save the settings of this page as a template for all other pages For new created Objects of the same Type the saved settings will accepted automatically The following wildcards can used in the fields Loggername and Sensorname Serialnumber of the Logger Channelnumber of the Sensor Measurement unit Description of the measurement value file Name of the Objecttype AP A Qe 350 0 de A O Supported wildcards to format values In order to format that the Sensorname consisting of Serialnumber and Channelnumber the following template is necessary Sensor s 5c The new Sensors gets the name Serialnumber Channelnumber Sensorname DMAS00 1 Sensor DMASOO 1 DMAS00 3 Sensor DMASOO 3 84 Measurementsystem 85 Page Automatic Inputdevices At the page Automatic Inputdevices it is possible to import measurement
36. the execute files of DEMASdb should be installed The default directory is C SEBA DEMAS db but it can be select any other directory Please press the Browse button to change it Even though if you install the multi user version of DEMASdb it is better to install the program on the local hard disk in order to increase the operation speed According to the selected type of installation some dialogs which are shown below will not appear 3 4 1 4 Select the Usermode This dialog appears when the database where installed It is necessary to define the single user mode Single User Database or multi user mode Multi User Database to access to the database that you have licensed Ensure that you have licensed a multi user version or a single user version of DEMASdb and select the suitable option If you install a DEMO Version of DEMASAdb you must choose the single user mode Single User Database option in any case Which database option should be configured You must 1 choose the option that You have licensed otherwise the program will not work correctly Multi User Database Selecting the Usermode for DEMASdb 15 15 DEMASdb 16 3 4 1 5 Select the type of Database If you have choosed the installation type Install DEMASdb or Update DEMASdb Database you will prompt in this dialog which kind of database you want to use with DEMASAdb Upon the selection of the Paradox Desktop Database option the next two dialogs
37. the new object will get the parent The new one will used as Datasource The area below the Datasource is reserved for the calculating parameters Depending on the selected claculating mehtod different inputs shall be possible The configuration possibilities will described in the associated calculating functions below 69 Measurementsystem 7 3 2 2 Start Evaluation The following situations will start an evaluation 70 e Import measurement values Each measurement value import will start the evaluation within the time period which is defined e changing values at the Datasource If the values will change into the Datasource e g Sensor the evaluation will start for this time period and the new result will store e Manually input of values During manually inserting new values with the device Manually input device DEMASdb will act as described above e Changing calcualtion parameters If the calculation parameters was changed DEMASdb will ask if he shall recalculate the measuremen values Hereby e itis also possible to decleare the time period which shall used for recalculating 7 3 3 Calculating Functions 7 3 3 1 Function Copy This function will not do any calculations with measurement value it is the standard method after creating new sensors Properties of EC TDS Information Properties Calculation Events Security Type of Calculation t1 Copy Description jatasources Sour
38. tube to the sealevel The top of tube will defined here as an parameter The name contains top of tube and the datatype is double Below the easy formula text top edge x Timecorrection of a measurement value The dataloggers will work with the most used timesystem summertime or wintertime The means that the actual timesystem must be consider With a formula it is able to convert the measurement values to an other used timesystem The following example show a conversion from summertime to wintertime DateTimePeriod t dtpWinterTime x setTime x DateTimeAddSec t 3600 Timefilter Timefilters are further functions It is possible to build an easy weekly filter The following example demonstrates how to save measurementvalues which are created on monday DateTimeDayOfWeek t wkMonday x setTime x DateTimeBad 76 Measurementsystem 77 7 3 3 5 Function Sunshinehours The calculation function Sunshinehours helps to calculate the hours of sunshine during a defined period For this calculation the radiation will check if a defined threshold was exceeded If this the case the time will be accumulated until the value get below the threshold The unit for this calcualtion is hours h Properties of EC TDS Information Properties Calculation Events Security Type of Calculation Aye Duration of Sunshine Description jatasources Name Sourceobject x 202 EC Parent Threshold
39. value to a integer value integer round x double The result is the next rounded integer If the value is between to integers the result will always round to the even number double int x double Will cut a real value to a integer value double frac x double The result are the post decimal positions of the real value double power base exponent double this exponential function will calculate the power from the base base and the exponent double sin x double Calculates the sine of a value double cos x double Calculates the cos of a value double tan x double Calculates the tangens of a value 117 Appendix double arcsin x double Calculates the arcsine of a value double arccos x double Calculates the arccos of a value double cotan x double Calculates the cotangens of a value double sinh x double Calculates the hyperbolic sin of an angel double cosh x double Calculates the cos hyperbolic of an angel double tanh x double Calculates the tangens hyperbolic of an value double In x double Calculates hyperbolic logarithm double log2 x double Calculates logarithm on base 2 double log10 x double Calculates logarithm on base 10 double logn base double x double Calculates logarithm on base of the value base 118 118 Appendix 119 13 1 7 Functions for Date Time TSISDateTime DateTimeNow The result is the actual value TSISDateTime DateTimeBad The result is a Dat
40. values over a long period of time and had permanent access to Calculation Sensors or Calculating Filters which requests values from a Sensor This distinction is important for the calculation functions which uses measurement values outside of the calculation interval One of this method are Minima Maxima calculations Exists an measurement value for a calculation not exact on the borders of an intervall missing measurement values must be reloaded in order to be able to calculate Minima Maxima correctly During an measurement value import from a file the calculation time period will be defined by the first and last value variable data source To reload measurement values from a file is not possible In order to do not lose informations about the measurement values it is meaningful to store the values into a sensor fixed data source and in a second step the calculating function shall be created as a child 7 3 2 Evaluation with Sensors By using the automatic evaluation in Sensors Calculating Sensor or Calculating Filter will be used As Datasource other Sensors or linked Logger and or Retrieval Objects are allowed The calculated values will be stored into the Sensor and after arrival it will be forwarded to the child objects 68 Measurementsystem 69 7 3 2 1 Configuration In opposite to Simple Sensors Calculating Sensors or Calculating Filters will have additionally property pages for the Calculation Properties of EC TDS
41. values periodically from a directory to the database of DEMASdb Properties of Retrieval Information Properties Automatic input devices Security order of device request amp File Device C SEBA evaporation Properties Remove Add Ok Cancel Apply Page Automatic Input Device e Request order for the devices In this list the order for searching for new measurement files was shown With the arrow buttons on the right side it is able to chang this order Each input device is an object which was configured at the Devicemanager of DEMASdb The name of the object will display at the column Name Additionally settings e g the import directory is shown at the column Files e Properties Shows the Properties dialog of the selected objects e Extended Shows additionally parameters which can set for the import For the File Device it is able to set the import directory e Add this will add a new device at the end of the List A dialog will show all available Devices After confirming the button Ok the selected device will appear at the list Request order 85 Measurementsystem 86 7 8 The Logger The Logger Object represents an real existing Measurement Station in the Measurement System of DEMASdb Below this Object it is able to collect several Sensor Objects which have the same Serialnumber Additional to this the Retrieval Object can automatically create Sensor Objects during the import of measurement
42. which you have to confirm with a click to Ok 3 7 Command Line Options The d parameter enables you to set the user account and the password for SQL Databases It is able to set the user account and password for working and archive database The parameter syntax looks like d DATABASE ALIAS USERNAME PASSWORD e DATABASE If WORK is used the following data are relative to the working database ARCHIVE for the Archive Database e ALIAS Used BDE Alias for the connection to the database Defaults are for the working database DEMASdb and for the archive database DEMASdbArchive ATTENTION Other Aliases as the defaults are only allowed for testing 18 18 DEMASdb 19 e USERNAME Username for the database which is connected via the alias If SALIAS is used the username that is stored with the BDE Alias would be use VONE means that the username is empty and DEFAULT locates the username depending on the used database system PASSWORD Password for the database username If DIALOG is set a dialog for the database is set at once If NONE is set the password is empty The password will prompt depending to the used database if SDEFAULT is set NOTICE If no references will used at ALIAS USERNAME or PASSWORD the default values which is set before will not overwritten Default values of SDEFAULT for USERNAME or PASSWORD are Databasesystem Username Password Paradox NONE NONE Others SALIAS DIALOG
43. with start and stoptime DEMASdb 1 Measurement System Cal 2 Maps 3 3 Desktop El 4 Devicemanager 5 Documents Templates 6 Tasks 3 7 Scheduler A Job Tp Rl E The Scheduler Objekt of DEMASdb 108 Jobmanagement 109 11 1 Scheduler The Scheduler shows and monitor all jobs With the help of the Context Menue it is possible to show a list of all active jobs This list contains only jobs which have the status Aktiv Properties of 7 Scheduler xf Information Joblist Security Name NestTime LastTime Status Msg Esport 2 25 2004 4 00 00 PM 2 25 2004 3 32 03 PM 999 2 25 2004 4 00 00 PM 2425 2004 3 32 14 PM 999 The Schedulers Joblist e Name Name of the job It will automatically display the name of the job after it was activated e Next Time Next Execution time e Last Time Last Execution time e Status Returncode of the status message in numeric form Please see also at Msg e Msg Shows the Message in plaintext which was send from the object after the last execution 109 Jobmanagement 110 11 2 Jobs A Job will be automatically subscribed and display at the Schedulers Joblist if the Job will be get active 11 2 1 Event Properties of Export Information Event Actions a I Active CycleTime 3600 Alignment 2 25 2004 12 00 00 AM The Job Events Page e Active Button to activate the
44. 0 ACCESS MS Ra 34 AE EM ODESSA A A hued Capea dates 36 5 Desk si aduaecaauncesaasaavada soapaaeae E A sana R 37 5 1 Bie Iie til Ba ada 38 5 1 1 File Menus OSes a E E EE E E T eee 38 5 12 PACE IVICTIU O ER ASE 38 5 1 3 A enian a e K ES AE A E Ea E tues dade 39 5 1 4 Window Menu siii ed eee eed 39 5 1 5 Hep Men a E O e 39 I2 A E R E a 40 5 2 1 Lam SUaSe Seuin gs merino n a a aai 40 Contents 6 5 3 Do a Eia 40 5 3 1 TAS Object EXplorer na a R E RE A R 41 IIZ Th Edson dd a 42 5 3 3 The OD jeet File viu ta bad 43 5 3 4 E A cota ea esate coe A eid teres a a E REE 43 5 3 5 The Exec Toolbar nO aaa 44 A E a aac E A RENES 48 6 1 The Maplold sieniniai a ee a E T Aaea 48 6 2 AS AA ii E E E a a E S 49 6 3 O neeces 51 6 4 The Measurement Value WiIdO WS sacpoes ead oadoaeetocuasepees 51 6 4 1 Measurement Value Window texXt oonooooocononocnonnnnononanononcononnnnnonononconononnnnonoss 53 6 4 2 Measurement Value Window bars ccononnooononcccnononnnaonnnnonocnononannnnnnnncncononnnns 55 6 4 3 Measurement Value Window warninglight ooonnoccnnnocccnonccononccononcconnnacnnnnoss 56 6 4 4 5 4 4 Measurement Value Window multitext ococcconnonoonanonononnnananananononoos 57 CES SLC INN sites rons chun A gees EEEE tan sens ETES 59 7 1 Create and Setting up Measurement Projects ooococnnococnoncccnonccnnonccononcnonnnccnnnnccnnnos 60 7 1 1 Step 1 Configure the Retrieval Dd O oO eee 60 7 1 2 Step 2 Import Measurement Values a aa 61
45. 05 Taskmanagement 106 The replacing commands are shown at the table 9 1 It is also able to use this commands for directory an path The following Table will show all possible commands Command Description d DATEFORMAT Actual date The output will replace by the parameter DATEFORMAT see below If this parameter do not exist the windows settings will use short dateformat t TIMEFORMAT Actual Time The output will replace by the parameter TIMEFORMAT see below If this parameter do not exist the windows settings will use short time cnt Counter for equal files If the created filename exists a number will append automatically to the new filename This commans had to use always sn Sensorname the name of the chart as shown in the measurement system of DEMASdb sn Serialnumber of the chart cn Channelnumber of the chart cmt Comment of the chart Formatname Char Description DATEFORMAT yyyy Year 4 digits yy Year 2 digits mm Month 2 digits with leading 0 m Month as number dd Day 2 digits with leading 0 d Day TIMEFORMAT hh Hour 2 digits with leading 0 h Hour nn Minute 2 digits with leading 0 n Minute Ss Second 2 digits with leading 0 s Second 106 Taskmanagement 107 Example The generating filename shall have the following format e Save the files at c seba DEMASdb export e The exportfiles shall save each day into a new directory
46. 1 3 Step 3 Create Directory Structure In the next step you can change the Sensor names to more descriptive names and create any directory structure which represents the region structure where the equipment is located To this please create a new Catalogue Object below the Retrieval Object With Drag amp Drop it is possible to move Sensors and Loggers to new catalogues Please notice that the Sensors have to located below the sub tree of the Retrieval Objects DEMASdb 24 1 Grundwassermefstellen El MeBprojelt Gal 2 Kartenordner EJ 3 Desktop Ml 4 Ger temanager How to create the Directory Structure 61 Measurementsystem 62 7 1 4 Step 4 Derived Sensors In order for dual data store or to separate raw data from calculated measurement values in the database you can create new Sensor Objects below existing Sensors Is the new Sensor able to store measurement values the measurement values of the superior Sensor have to copy to the new one All this can be done by Drag amp Drop Click and hold the right mouse button on to the superior Sensor and move it to the new Sensor If you release the mouse button you can select the menu entry Copy Content The new Sensor get the serialnumber channelnumber measurement values and comments This operation have to done only once a time because the next import of new measurement values will transmit it automatically to all sensors below ua How to create derived Sensors
47. A further possibility is to use the Formulatemplate which can also select in the list Type of calculation and edit with a clickon the button three dots But notice with this method it can be possible that changes affects also other connected sensors In both cases it is possible to select the datasource at the list Datasources At the region Parameters it is able to set the parameter for this formula It is also possible to access the the variables CalcStartTime Start of the calculation period and CalcStopTime End of the calculation period Further informations about CalcStartTime and CalcStopTime will describe at the appendix 74 Measurementsystem 75 7 3 3 4 3 Formuladesigner Formeldesigner E 101 x Formelname Beschreibungstext MergeAndFactor Fasst die Werte zweier Datenquellen zusammen und multipliziert das Ergebnis mit einem vorgegebenen Wert Kurzbeschreibung Zusammenfassen und Multiplizieren Messwertvariable Ubergabeparameter Datentyp Vorgabewert___ x1 Backviewinterval Integer 0 x2 Factor double 0 0 Formeltext l x1 x2 Factor Calculation function Edit create Formula At the dialog Formuladesigner it is able to edit or create a formula Formulaname This field contains the name of the formula Notice Only numbers and characters will accept as a name and the first letter must be a character Shortdescription Optional comment for the formula Description Optional extend
48. AVEWATER The properties of the Simple Sensor Object e Serialnumber Serialnumber of the Logger e Channelnumber Channelnumber of the Sensor e Unit Unit for the saved measurement values of the Sensor e Comment CMT Comment to a Sensor of the saved Chart The CMT will automatically set from the measurement value file during the Import of Measurement values e Minimal Maximal Value The Min Max Values are used for displaying the Chart in the modules MGMDS MLMDS They indicates the measurement range which will display at the chart 88 Measurementsystem 89 Events For each Sensor it is possible to declare up to 4 Eventlimits Levels These Levels will evaluate if new measurement values will imported into the database If a measurement value is within this levels the measurement value will display in a different colour The configuration settings will show atthe picture below Properties of A01492 0001 A01492 1 xi Information Properties Events Security N Event limits very low Normal 50 50 Level 1 X 100 100 Level 1 y 150 very high Ok Cancel Apply Sensor Events 7 9 2 The Simple Day Block Sensor The Simple Day Block Sensor differs from the Simple Sensor only in the kind of saving measurement values to the database But he is optimised for Sensors which collects more than one measurement value a day 7 9 3 The Calculating Sensor The Calculating Sensor save measurem
49. G THE SOFTWARE PACKAGE YOU AGREE TO BE BOUND BY THE TERMS OF THIS AGREEMENT IF YOU DO NOT AGREE TO THE TERMS OF THIS AGREEMENT CLICK THE DO NOT ACCEPT BUTTON TO TERMINATE THE INSTALLATION PROCESS OR PROMPTLY RETURN THE UNOPENED PACKAGE AND THE REST OF THE PRODUCT TO YOUR SUPPLIER FOR A FULL REFUND License If you have purchased a license to the Software SEBA Hydrometrie GmbH SEBA grants you a non exclusive right and license to use the Software and the related documentation the Documentation as set forth in this Agreement You may use the Software on a single computer You may also use the Software on a second portable or home computer so long as only one copy is used at a time You may make a single copy of the Software for backup and archival purposesonly provided that any copy must contain all proprietary notices included in the original You may use the Documentation to assist in your use of the Software If you download the Software without physical delivery of Documentation you may review the Documentation online but you may not make further copies of the Documentation You own the media on which the Software is recorded but not the Software itself or any copy of it This license is not a sale of the original or any copy of the Software If you have obtained an evaluation copy of the Software and have not purchased a license to the Software SEBA grants you a 30 day non exclusive license to use the Software free of charge fo
50. Interval 0 1 Day Extraction Time Begin of Interval C End of Interval C Time of Measurement Cancel Apply Calculation Function Sunshinehours Page Calcualtion In order to do the calculation a threshold had to define This theshold is the time at which value the radiation is sunshine In order to do the calculation Sunshinehours in the option list the entry Sunshinhours had to be selected In the option list datasources it is possible to select the datasource see also Chapter 6 3 2 1 In the 3rd area on the page Calculation it is possible to configure the settings for the sunshinehours e Threshold The threshold is the limit above this the measured radiation is sunshine e Interval Defines the intervall within the values will be accumulate In generally the most used interval was day Therefore the entry day had to be selected e Extraction Time Here it is possible to define the point where the calculated values should store Possibilities are Begin of Interval and End of Interval 71 Measurementsystem 78 7 3 3 6 Function Sawtooth The calculation function Sawtooth will extract single results from summation values The single results will calculated between the actual value and the value before It was also consider that the values will be reset not periodically In the following cases it is not able to get a result 1 the actual value ist not valid 2 the value before is not valid 3 not
51. Job This makes it possible to subscribe or unsubscribe the job at the Scheduler e Cycletime Cycletime in seconds If the job will be activate the Scheduler will execute the job after the cycletime is over e Alignment The Aignment shows date and time which shall be the base for calculating and executing the job The Scheduler will align the next execution on this date and time Therefore it is possible to create jobs which will execute periodically 110 Jobmanagement 111 11 2 2 Actions Properties of Export xi Infomation Event Actions Security Executing Programm Patt Parameter Executing DEMASdb Action Action Object f A0492 z Action Name TAST START AUTO Ok Cancel Apply The Job Actions Page e Execution Program If this entry is active it is possible to execute external programs scripts periodically from DEMASdb Path The Path contains a complete path to the programm which shall be executed by DEMASdb Parameter To hand over additionally or necesarry parameters it is possible to enter this parameters into the inputbox e Executing DEMASdbAction This entry enables the posibillity to use predefines DEMASdb actions Action Object The Action Object can enters manually over the button or by using Drag amp Drop Action Name Here it is possible to enter the Action which will applies for the Object For a complete list with predefined DEMASdb Action please look
52. MITATIONS ON HOW LONG AN IMPLIED WARRANTY LASTS AND SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF INCIDENTAL OR CONSEQUENTIAL DAMAGES SO THE ABOVE LIMITATIONS OR EXCLUSIONS MAY NOT APPLY TO YOU THIS WARRANTY GIVES YOU SPECIFIC LEGAL RIGHTS AND YOU MAY ALSO HAVE OTHER RIGHTS WHICH VARY FROM STATE TO STATE High Risk Activities The Software is not fault tolerant and is not designed manufactured or intended for use or resale as online equipment control equipment in hazardous environments requiring fail safe performance such as in the operation of nuclear facilities aircraft navigation or communication systems air traffic control direct life support machines or weapons systems in which the failure of the Software could lead directly to death personal injury or severe physical or environmental damage SEBA and its suppliers specifically disclaim any express or implied warranty of fitness for any high risk uses listed above Entire Agreement This Agreement is the complete agreement between SEBA and you and supersedes all prior agreements oral or written with respect to the subject matter hereof If you have any questions concerning this Agreement you may write to SEBA Hydrometrie GmbH Gewerbestrafe 61a D 87600 Kaufbeuren Germany Tel 49 8341 9648 0 Fax 49 8341 9648 48 eMail info seba de www www seba de Contents 5 1 Contents Ls it 5 DA O e ds cade 8 2 1 Taret Groupe sie E A E tn elite a a a a 8 2 2 9 Ws sea
53. Measurementsystem DEMASdb Measurement system 1 Grundwassermestellen Import Measurement Hal Me amp systemardner Values EA mek projet Biessenhorfen Save Measurement EP 000411 1 2 e Maltes 3A 000411 N NN Measurement system Catalogue Kaufbeuren 484 Kaiser Max Strasse SEBA Wetterstation 77 S Lichtintensit t A Temperatur Windgeschwindigkeit 44 Geschwindigkeit 4 Windrichtung dE K nigsstraBe a f Druck AN Druck 1 Area Structure Retrieval Object Catalogue Logger 2 Kartenordner Sensor The DEMASdb Measurementsystem The measurement system of DEMASdb contains all Objects for administration and configuration measurement values The picture above shows a simple measurement system in the Object Explorer With the available Object Types and the arrangement of the Objects in any hierarchy it is possible to build an easy to follow display of measurement value regions in the measurement system of DEMASdb A new Logger with schild Sensors represents for e g a measurement station with the measured parameters Catalogues allows to emulate region structures By using Measurement System Catalogues it is able to subdivided a measurement system in different measurement projects The Retrieval Object is the starting point of the measurement value import for the child Objects With the Context Menu of the Objects in the measurement system it is able to do all actions for administration of m
54. NANE E aratan of gt Logbook The Desktop of DEMASdb 37 Desktop 38 5 1 The Menu Bar File Edit View Window Help The menu bar of DEMASdb collects the most used actions which can selected at the Context Menu of each Object e File Change the Language settings and quit DEMASdb e Edit Copy Objects to the Clipboard e View Updates all changes which are made by any other User only available in the Multiuser Version e Window Arrange windows lists of the Toolbar and opened windows e Help Call the Online Help and show the Info Dialog 5 1 1 File Menu Menu entries of the File Menu e Properties Throughout the selection of this menuentry a dialog shows global settings of DEMASAdb Here it is able to change the the language of the menu items and texts e Quit Finish DEMASdb 5 1 2 Edit Menu The choice of an Menu Entry refers to the currently selected Object within the Object Explorer or the selected objects in the Object File Menu entries of the Edit Menu of the Menu Bar e Cut Copy the Contents of an Object into the Clipboard and delete this Objects e Copy Copy the Contents of an Object into the Clipboard e Paste Paste the Contents of an Object from the Clipboard e Delete Delete Objects 38 Desktop 39 5 1 3 View Menu Menu entries of the View Menu e Refresh only visibly in the Multiuser Version Modifications to the database of DEMASdb are normally set up in a short period o
55. S or MLDMS In order to generate a Report for all subordinated Sensors please select the menuentry Write measurement values 7 7 The Retrieval Object The Retrieval Object is used to import measurement Values to the database The measurement values can come from files or read out directly from devices such as HT100 and LG100 but you have to configure and create a measurement project at first Context Menu The selection of Read measurement values in the Context Menu will show you several devices from which you can read measurement values For generation Reports for all existing Sensors in the sub tree please choose the entry write measurement values Properties You will find the settings for automatically configuration on the property page at Loggers and Sensors Here you can set which kind of Objects should create e Created Logger In this field you can set which kind of object type is used for a Logger If you do not set any Object Type no Logger will create Information Properties Security Created Logger flogger tt tst S Created Sensor Simple DayBlockSensor Name of Logger fs ss Sensomame ns o S Collecting catalogue y TT Save basic adjustments The properties of the Retrieval Object 83 Measurementsystem 84 e Created Sensor Which kind of Sensor shall save the measurement values e Name of Logger Here you can set the format of the name which shall use if a new Logger is creating For
56. Show A second possibility is that you choose the menu entry Backup or Restore from the Context Menu of the Object which you want to restore or backup In both possibilities the window which is shown below will appear but it can takes a few seconds because the archive status needs take time to generate 94 Devicemanager 95 Accessrights The user must have the accessright Show Configuration and Show Contents in order to Backup or Restore Objects In order to backup Objects the user must have the accessright Show Configuration for these Objects For Sensors the user need additional the accessright Show Contents In order to restore Objects the user must have the accessright Change Configuration for these Objects For Sensors the user need the additional accessright Change Contents 8 7 1 Backup of Objects In the window of the Archive Device it is able to select the backuped Objects A click with the left mouse button to a box before a menu entry will change the selection status of the Objects as well If all Objects shall be select please use the Select All Button or click on Clear Selection Button if no Objects should be archived im Backup Restore of Objekts BEES Backup Restore EX A DEMASdb Options of Sensor 1 Measurement System S E Gal Measurement System Folder IV Backup Values S E E Measurement Project I Reduce Values 0 0 amp Germany t 1 H 0 Gl Berin Left Loro 69 00 E Frankf
57. The Taskmanagement of DEMASdb allows to define or group different Tasks which can execute manually or automatically Additionally it is possible to use Drag amp Drop to assign a Job to a Task Therefore it is possible to create periodically Jobs for often used Actions With the actual Version of DEMASdb it is possible to define different Exporting Tasks grouped by Collections of Exportingtasks DEMASdb 48 1 Measurement System Lal 2 Maps 3 3 Desktop E 4 Devicemanager Th Exporting task 3 7 Scheduler The Taskmanagement of DEMASdb 102 Taskmanagement 103 10 1 The Exportingtask Exportingtasks at DEMASdb allows you to define specially exports for measurement values e Output directory and fileformat Page Properties of File e Optional formatsettings Page Fileformat e List of sensors which can used for the export Page Select charts Notice If more than one file should created during the export it is possible to use replacing commands at the field Filename at the page Propperties of File This replacing commands will use to create unique filenames Contextmenu In order to execute a Job automatically it is necessary to select the entry Execute at the Contextmenu At the following dialogbox is is able to set the time range between the measurement values shall export The dialogfields left and or right can be used Execute will start the export Page Fileoptions Properties of Exporting task
58. User Manual SEBA Hydrometrie amp S I S SEBA Information Service DEMASdb HYDROMETRIE k Contents DEMASdb user manual Copyright O 2002 2004 SEBA Hydrometrie GmbH amp S I S SEBA Information Service GmbH All rights reserved When creating this handbook we attached greatest importance to the correctness and completeness of the contents However SEBA HYDROMETRIE and S I S SEBA INFORMATION SERVICE do not assume any liability for direct or indirect harms or lost profits which can be put down to contents errors or omissions Changes are to be subject Goods names are used without guarantee regarding the free usability Almost all hardware and software labels which are mentioned in this handbook are also simultaneously registered trademarks or should be viewed as such September 2005 DEMASdb Software version 1 17 Build 53 and higher User manual version 1 02 2nd Revision Dipl Inf FH Christian Satzger Dipl Inf FH Marcus Sattler SEBA Hydrometrie GmbH amp S I S SEBA Information Service GmbH Gewerbestr 61 a D 87600 Kaufbeuren Tel 49 8341 9648 0 Fax 45 8341 9648 48 Internet www seba de eMail info seba de Contents SEBA Hydrometrie GmbH SOFTWARE LICENSE AGREEMENT IMPORTANT PLEASE READ THIS AGREEMENT CAREFULLY BEFORE OPENING THE ACCOMPANYING SOFTWARE THE SOFTWARE PACKAGEOR CONTINUING WITH THE INSTALLATION PROCESS OF THE SOFTWARE BY CLICKING ON THE OK OR ACCEPT BUTTON OR BY OPENIN
59. accessright Change Content it is able to export measurement values to files 8 4 The Device for Monthly Report This device will generate a monthly report of the selected measurement values which is detailed explained in the chapter Monthly Report Is it not possible to create the Monthly Report than either a new Object by the type of Monthly Report have to create below the Devicemanager or the user have not enough accessrights Accessrights In order to create the report the user must have the accessright Show Configuration Show Content and Change Content 93 Devicemanager 94 8 5 The Device Middle Values per Week This device creates an report with Middle Values per Week which is detailed explained in the chapter Middle Values per Week Is it not possible to create the middle values per week Report than either a new Object by the type of Middle Values per Week have to create below the Devicemanager or the user have not enough accessrights Accessrights In order to create the report the user must have the accessright Show Configuration Show Content and Change Content 8 6 The Manual Input Device With the Manual Input Device it is very comfortable to add or insert measurement and control values to charts A detailed explanation you will find in the chapter Manual Input Device Is it not possible to add measurement and control values than either a new Object by the type of Manual Input Device have to create below the Devicem
60. account DEMASdbAdmin and as type Administration Confirm by clicking to OK Repeat these operation for the Groupaccounts DEMASdbUser which the access mode user and DEMASdbGuest at which the access mode guest di Step Confirm the dialog Userright by clicking OK and confirm the following dialog that all child objects shall have the same rights too For new Users the respective Accounts must ever still assigned to the three Groupaccounts Should a users access completely removed to any Object please also remove his membership from the Groupaccounts 35 Operation 36 4 7 Link Objects The Link is an entry in the Object Explorer which owns a link to any other Object The Link like exactly the linked Object and is comparable with an shortcut to a file under the operating system Windows This means that all actions such as rename show Context Menu executes to the linked Object The Link shows the name and the symbol of the linked Objects The symbol for a link is shwon below El The Link Object Create a link by using Drag amp Drop and move the linking Object on the requested position in the Object Explorer Use the right mousebutton in order to show the Drag amp Drop menu In this menu please choose the entry Create Link In the Context Menu of a link the menu of the linked Object is shown but an additional item Delete Link exists By the selection of this menuentry the Link will delete by himself but not the linked Object
61. alog will only appear if the setup program is not able to locate the path to the working database Please enter the correct directory path of the database is located 21 DEMASdb 22 3 Dialog Select the bitmap folder The setup program will select the bitmap folder automatically by the help of the destination path of the working database If it is not able DEMASdb Setup will prompt you to set the right folder After the confirmation with Next DEMASdb Setup will load the configuration files If no error occurs the dialog Configuration Management of DEMASdb would be displayed again Otherwise an error message will be shown and the load process will cancel 3 8 3 Move active configuration Move the active configuration to an other directory is used to make an easy upgrade from a single user version to a multi user version of DEMASdb This is necessary because in a multi user version the clients must have access to the folders which contains the working database and the bitmap files In the following dialogs you are able to select 1 Dialog Selection of the active Database This dialog will only appear if the setup program is not able to locate the path of the working database Please enter the correct directory path to the database 2 Dialog Select the target directory Please insert here the destination folder in which the saved configuration should be stored All data in this directory will deleted If the selected destination
62. an have side effects to measurement values which are befor or after the actual measurement value double MEASUREMENTVARIABLE t TSISDateTime With this function it is able to access measurement values which are not part at the actual point of time The text MEASUREMENTVARIABLE is the name of the measruementvariable and the function can have the following structure e g fx fsensor1 ftemperature The param t defines the point of time of the measruement value The result is a new measurement value 116 Appendix 117 double setValid x double This value will set the result of a funktion to valid The parameter x gets the actual calculated value which is also the return value of the calling function double setTime x double t TSISDateTime The function setTime will set the point of time of the calculated measurement value With that it is able to implement time shifts for measuremnet values The parameter x gets the actual calculated value which is also the return value of the calling function The parameter t contans the point of time for the new measurement value With the function maeasurement time DateTimeBAD it is able that the value will not store into the database This will reduce the number of the values 13 1 6 Mathematical Functions boolean isValid x double Check if the parameter value x is a true number If it is true the result is True otherwise the value is False integer trunc x double Will round a real
63. anager or the user have not enough accessrights Accessrights In order to insert measurement and control values the user must have the accessright Show Configuration and Change Content 3 7 The Archive Device The Archive Device provides the possibility to backup and to recover data Is it not possible to backup with the Archive Device than either a new Object by the type of Archive Device have to create below the Devicemanager or the user have not enough accessrights The following reasons can selected Duplicate data storage The duplicate data store will increase the security of the data By this it is able to restore by mistake deleted information to the working database Reduction of the data set Archived data can restore to the working database this will increase the operating and display speed especially for large data sets Archived data will be stored in a separate database which is called Archive Database with an own database alias called DEMASdbArchive This means that you can set for each Object 1f it shall possible to archives or not Basically all data belong to an Object will backup or restore Additionally for Sensor Objects it is possible to decide in what kind of shape the measurement values shall be archive In order to backup or restore data please select the Object Archive Device in the Object Explorer which can be found in the Devicemanager After this please open the Context Menu and select the menuentry
64. and rename it e Open the properties dialog of the job and select the page event The field cycle time contains the intervall in seconds after the job will be repeated The field alignment contains the time which the scheduler shall start this Job Active will start the processing through the Jobmanagement e In the page actions of the job the option Executing DEMASdb Action shall be activated In the field Action Object insert the DEMASdb Action which should execute In this case the above Retrieval OBJECT The Action name for this action is the text AUTO RETRIEVE During the import from directories the following steps will perform 1 All Files of an directorys will import by using wildcard signs e g tmp 2 Trying to open the file using the exact file extention or open the files by using the built in filetype detection 3 If the import was successful the file will moved to the subdirectory success yyyymmdd If the import was not successful DEMASdb will move the file into the subdirectory failed yyyymmdd In the described directories above the naming is yyyy for the year mm for the month and dd for the day of the import 65 Measurementsystem 66 7 2 4 Import Measurement Values from HT100 and LG100 Before you can import measurement values by the devices HT100 and LG100 in DEMASdb you have to configure the measurement system at first Open the Context Menu of the Retrieval Object and select the entry Read Measureme
65. are possible In the Appendix you will find a description of all possible DEMASdb commands Access Rights Only user who have the accessright Show Contents can execute actions 47 Mapsystem 48 6 Mapsystem The Mapsystem of DEMASdb is able to administrate any maps from common overview maps down to detail maps or pictures of measurement stations The pictures are shown windows which are called Groupwindows Groupwindow is a measurement window at the position of the geographic location of the measurement points The measurement window display a graphical representation of actual values from the measurement stations Additional to this it is possible to jump with Grouplinks directly to other Groupwindows for more details For the hierarchical organisation of Groupwindows in the Objecthierarchy Mapfolders are available 6 1 The Mapfolder The Mapfolder is used to organize the Groupwindows in the Objecthierarchy It is able group in any dept and can renamed individual With the help of Mapfolders 1t is possible to create an easy to follow hierarchy which is able to brake down to much detailed section maps Access rights In order to create child Mapfolders or Groupwindows the User must have the Accessright Change Configuration or Show Configuration for show the Mapfolder in the Objecthierarchy 48 Mapsystem 49 6 2 The Groupwindow Grouplink Measurement value window Bar ha E0 oe EN chowabisth Hal 24 05 Tempers 9
66. ase if it is able to own subordinated Objects and which kind The logbook for example can not own any child Objects The Catalogue may be owns child elements such as Sensors Logger and Catalogues again Wildcard Characters With the help of wildcard characters and it is able to select more than one filenames at once The question mark will substitute one character on this position the asterix substitute any number of characters nae All Files bmp All Files which ends with bmp a bmp All Files which ends with bmp and begins with character a MDS340 mds All Files begins with MDS340 follows by a single character ends with mds 113 Appendix 114 13 Appendix 13 1 Formula Reference The syntax for creating formulas uses the most common programming language Pascal because it was programmed for programming beginners and easily to learn The following will describe an overview over the most used functions 13 1 1 Datatypes Each information of a formula e g measurement value or measuremet time range owns a datatype and a fix range of values and a new datasource The following list shows the mostly used datatypes Symbol Meaning Description Example double Floatingpoint value Rational numbers with post decimal 1 144 These values will always written with the 1 0 decimal dot also the decimal value 0 3666 1254 integer Integer Value Numbers without post decimal positions 1 466 400000000 boolean True False
67. ask you for the destination folder of the work and archive Database Please select the type of Database do you want to use If your Database System is not listed below choose Paradox for first installation and choose Dther for update an installation C Oracle SQL Database C Microsoft SQL Server Selection of the used Database for DEMASdb 3 4 1 6 Destination Folder for Paradox Databases With two further dialogs you are able to enter the directory folders for the working and archive Database of DEMASdb If you have selected the installation type Install DEMASdb Database choose in this dialog the destination folder which the database shall be copied The default destination folders can changed 1f you use the Browse button Please notice that you must use different destination folders for each database You should be aware that if you use a multi user version of DEMASAdb all connected workstations must have full access to the folder which contains the database files Did you select the installation type Install DEMASdb you have to set the folder to the already installed working and archive Database in the network You should choose the path of an existing DEMAS db database in order to run an update Destination Folder C Seba DemasDb DataBase Paradox Browse Select the destination of the Database for DEMASdb Install an Update with the installation type Update DEMASdb Database The right des
68. authorised unmeant changes by setting Userrights The following part we will explain the individual concepts more precisely 4 1 Quickstep After the first start of DEMASdb only the Objectexplorer is shown on the Desktop At the top root of the Objectexplorer the entry DEMASdb is located A double click on DEMASdb open the first level Objects The entry Measurementsystem is the genus for the whole Measurementsystem Open the Measurementsystem with a single click on the symbol or double click to the front symbol of the Retrieval Object is located In order to read measurement values and for automatically configuration open the Context Menu of the Retrieval Object by a single click with the right mouse button Here will you find the menuentry read measurement values from 23 Operation 24 File Device A dialogwindow appears in which you can choose one or more measurement datafiles After you have clicked to the OPEN button measurement values will read from the files and the Measurementsystem is being configured automatically This means that Loggers and Sensor objects will create automatically Through a double click on the Logger Object all the measurement values of the belowed Sensors are shown in the chart as lines This chapter gives you an short overview how to use DEMASdb Additionally you should read all the items that are listed in the chapter Operating Concept 4 2 Working with Objects 4 2 1 Create Objects
69. ay Block Sensor Name of Logger Logger s Sensorname Sensor Ps Yc Collection Catalogue this field stays empty 60 Measurementsystem 61 7 1 2 Step 2 Import Measurement Values As next please select Read Measurement Values from File Device from the Context Menu of the Retrieval Object In the following dialog box choose the directory which contains the values and select the measurement value file s If more than one file should be imported you can use Wildcard Signs in the field Filename In the input field Filetype it is able to select a special filetype After successfull import the measurement system look likes the structure which is shown beside The Logger get the serialnumber as its name the Sensors gets the serialnumber and channelnumber as name The measurement project now is automatically configured This means information such as serialnumber channelnumber measurement unit and so on are assigned to Loggers and Sensors and can see on the Property page Further measurement values will automatically assigned to the right Sensors by the next import DEMASdb al 1 GrundwassermeRstellen Gal MeRsystemordner El MeBprojett Ex Logger 000411 Sensor 000411 1 f Logger DRUCK_ A Sensor DRUCK_ 1 Si Logger GESCHW A Sensor GESCHW 1 Shi Logger LICHT_ A Sensor LICHT_ 1 Eff Logger RICHTU J Sensor RICHTU 1 e Gi 2 Kartenordner E 3 Desktop m 4 Ger temanager Importing Measurmenet values 7
70. bject Copy to the Clipboard EX Insert from the Clipboard Lal Show Objectproperties Open MGMDS Open MLMDS 5 3 5 The Exec Toolbar With the Exec Toolbar it is able to show freely configurable buttons which can execute different actions This buttons are Objects of the type Tool Button and are linked with an Exec Tool respective to the Remote Tool The buttons can create as an Object by the type of Tool Button in the Exec Toolbar The tools will collected in the Toolbox which is created in the Object Explorer below the Toolbar Access Rights Toolbox and Tool Button can only create if the user has the accessright Change Configuration 5 3 5 1 The Tool Button Tool Buttons are buttons within the Exec Toolbar and can execute actions by mouse click or Drag amp Drop Therefore they have a Link to an Exec Tool or a Remote Tool in which it is able to configure the requested action Additional to this it is also possible to tie up an image for each Tool Button which can display inside the button Creating Tool Buttons by moving Exec or Remote Buttons per Dra amp Drop to the Toolbar It is also able to change the Link by using Drag amp Drop The linked action will execute by clicking on the button When an Object is drag per using Drag amp Drop and Copy Content to an on screen button it is able to execute the object based action 44 Desktop 45 Context Menu In the Context Menu of the Tool Button an additional entry of the linked E
71. ceobject x FPOZEC Parent boa bah Calculation function Copy Page Calculation It is only possible to select the Datasource 70 Measurementsystem 71 7 3 3 2 Function Polynomials The calculation method Polynomial allows converting measurement values with the help of a 3rd degree Polynomial Functions third grades y Ax3 Bx2 Cx D A By Es D3 Constants Xt source value y new calculated value Properties of EC TDS Information Properties Calculation Events Security Type of Calculation e Polynomcalculation Description atasources Name Sourceobject x FPO2EC Parent Calculating Function Polynomial Page Calculation In order to work with polynomial calculation select at Type of calculation the entry Polynom calculation In the list of Datasources it is possible to select a Datasource siehe also Chapter 6 3 2 1 The values of the coefficients A B C D can be set by the user and will depend on the kind of calculation Example for the size an value of the constants The following example shall show how you can convert your obtained sensor data for Groundwater to Sealevel NN data Top of pipe high is 732 m The coefficients shall had the folowing values D 732 Top of the tube C l B 0 A 0 71 Measurementsystem 72 7 3 3 3 Function Interval With the function Interval it is possible to evaluate all measurement val
72. d Bar ad Warmlight For the measurement value windows it is not able to assign its own name It will always receive the name of the linked Sensors Furthermore it is possible to show all sensors which are located below a Catalog or Logger in the same measurement value window For creating please look ahead in this chapter how a measurement value window multitext will create El Multitext The link of a measurement value window will change if you drag other Sensors or Loggers with the help of Drag amp Drop to this measurement value window It is also possible to give the measurement value window a new position at the Groupwindow or move it to an other Groupwindow Context Menu The Context Menu is the same for all measurement value windows In order to show the Context Menu please click with the right mousebutton inside the measurement value window If a Sensor is linked to the measurement value window the name of the Sensor will appear on the top of the menu If you select this opinion the menu of the linked Sensor will open Furthermore two menuentries exists for changing the position move and size Change size For both press the left mousebutton if you have reached the new position or size With the Menu Entries to front or hide it is possible to fix the position of Grouplinks and measurement value windows Global Settings Global Settings On this page it is possible to change the color in which the measurement value
73. e For each logger create also a new direcory e The filename consists of Serial and Channelnumber e Ifa file exists add a counter to the new file Do not overwrite existing files The complete command looks like c seba DEMASdb export d yyyymmdd 1lsn 1lsn _ lcen cnt asc The created files for the 10 08 2004 looks like Seba DEMASdb export 20040810 A01790 A01790_l asc Seba DEMASdb export 20040810 A01790 A01790_2 asc Sseba DEMASdb export 20040810 F30303 F30303_15 asc Seba DEMASdb export 20040810 F30303 F30303_15l asc Sseba DEMASdb export 20040810 F30303 F30303_152 asc 0Q00 00 10 2 Collection of exporting tasks The Collection of Exportingtasks allows you to create a hierarchy tree for organizing Exportingtasks Additionally the Collections supports a sequential execution for all childed Exporting Tasks This feature is possible for manually Menuentry Execute and automatically Execution see Chapter 10 2 Contextmenu In order to execute a Task manually it is necessary to selecr the menuentry Execute at the contextmenu After that it is possible to set the timerange in the following dialog the range will set by activating the dialog fields Left and or Right and setting the point of time Execute will start the Export with all child exports 107 Jobmanagement 108 11 Jobmanagement With the Job management of DEMASdb it is possible to create automated jobs
74. e Time which was marked as not valid boolean DateTimelsBad dt TSISDateTime Check Date Time if is is valid integer DateTimeCompare dt1 TSISDateTime dt2 TSISDateTime Compares two Date Time values The result had the following meaning lt 0 dtl before dt2 0 dtl equal dt2 gt 0 dtl after dt2 TSISDateTime DateTimeAddSec dt TSISDateTime secs integer Adds secs seconds to the Date Time If the count of seconds is negative the seconds will subtract from the Date Time DateTimeAddSecPeriod will change automatical from Winter to Summertime integer DateTimeDiff dt1 TSISDateTime dt2 TSISDateTime The result is the difference between to dates DateTimeAddSecPeriod will change automatical from Winter to Summertime integer DateTimeYear dt TSISDateTime The result is the number of the year integer DateTimeMonth dt TSISDateTime The result is the month integer DateTimeDay dt TSISDateTime The result is a day from the month integer DateTimeHour dt TSISDateTime The result is the hour of a time integer DateTimeMinute dt TSISDateTime The result is the minute of a time integer DateTimeSec dt TSISDateTime The result is the second of a time TSISDateTime DateTimeMin dt1 TSISDateTime dt2 TSISDateTime The result is the earlier date of the both TSISDateTime DateTimeMax dt1 TSISDateTime dt2 TSISDateTime The result is the later date of the both 119 Appendix 120 13 1 8 Functions f
75. easurement values e g import and export of measurement values creating reports show measurement values as chart or list in the MGMDS MLMDS modules archiving from measurement values and so on Some menuentries will also execute for sub ordered Objects The configuration of the measurement system can do with the Objectproperties Here you can also insert additional information about the measurement places 59 Measurementsystem 60 7 1 Create and Setting up Measurement Projects The measurement system of DEMASdb will automatically configure the measurement system during the import of measurement values This means that for all not existing Objects new Logger Objects and Sensor Objects will create automatically Which Objecttype will create exactly can define in the Retrieval Object After the import the new created Objects can renamed and moved to a user defined directory structure The following part will explain step by step by an example how to create your own measurement project 7 1 1 Step 1 Configure the Retrieval Object To import all measurement values from a directory into the database it is necessary to create a new Retrieval Object in the Object Explorer DEMASdb 24 1 Grundwassermegstellen MeRsystemordner El MeBprojelt a Gal 2 Kartenordner 3 3 Desktop m 4 Ger temanager How to configure the Retrieval Object Please insert in the property page Created Logger Logger Created Sensor Simple D
76. easurement values will do hierarchically This means start from the Retrieval Object the Objects below where ask if they will accept the measurement values with its identification Catalogues Logger and Sensors will do in thesame manner Catalogues do not check the identification and will pass it to all child objects below Loggers will test and if if the serial number matches they pass the values to their child objects Sensors will check the serial number and the channel number if both matches they will store the measurement values to the database Additionally they will also distribute the measurement values to existing child objects DEMASdb o Bl 1 Grundwassermefstellen Gal MeRsystemordner a El MeRprojekt A Biessenhofen oy 21 000411 1 Kaufbeuren E a Kaiser Max Strasse SEBA Wetterstation A Lichtintensitat J Temperatur Elfie Windgeschwindigkeit J Geschwindigkeit A Windrichtung a K nigsstra e EY Druck ESA Druck 1 gj 2 Kartenordner m2 3 Desktop H 4 Ger temanager Y Distribute the imported data 63 Measurementsystem 64 7 2 2 Import Measurement values from File For data imports from files please choose the menuentry Read measurement values from File device in the Context menu of the Retrieval Object In the following dialog box you can select the directory which contains the files and select the measurement value which shall import If you want to import more tha
77. ed description for the formula Measurementvariable The number and the name of the datasources for the formula will be set in this list The user is able to assign at the page Calculation the Datasources to this parameters Within a formula the measurement values will access over the name which is defined here Notice Only numbers and characters will accept as a name and the first letter must be a character Parameters The calculation can be controlled by parameters On the page Calculation it is possible to assign a value in the area below in order to use this parameter for this calculation A special parameter is the BackviewInterval see appendix A With this parameter it is able to use measurement values before the calculation periode into a formula The BackviewInterval defines the timeperiod in seconds This parameter is optionally and can use on demand Notice Only numbers and characters will accept as a name and the first letter must be a character T9 Measurementsystem 76 Formulatext The formula will registered at the field Formulatext and will execute for each measurement value within the datasource once a time Further informations about all the possibilities will described at the appendix A Examples will show in chapter6 3 3 4 4 7 3 3 4 4 Examples Formula examples Conversion level from top of tube to main sea level This funktion will use very often This calculation will convert the measuremenvalues from top of
78. efault 81 Measurementsystem 82 Raginis Due jor PRES a Wile greso to day First day the week aa Po O e C Thesdy thous than compite muro days Caga Middles Values per Week e First day of week Insert the day of week where you will start creating the average e Outputfile Select the file name in which the middle values shall store Use the button in order to select the filename within a dialog e Write average to day Select the day of week should store the middle value The date which is write to the file is always lay within the middled week on the selected day of week Additional to this you can set the action e g no output should happen if a gap of measurement values exists For weeks with existing measurement values gaps no middle values will write Press OK if you want to start the export otherwise press Cancel All middle values which are calculate from measurement values of Sensors and are suborderd below the selected Object will export in one file If the file exists you can select in the following dialog if the old values in the existing file shall overwrite or the new middle values should append The output file consist of three columns separated by tabulators e 1 Column Date of the Middle Value on the selected day of week e 2 Column Name of the Sensor maximum 15 Character e 3 Column Middle Value 4 post decimal positions Example file 31 08 1998 B00070 1 24 4932 07 09
79. ement values to the Windows clipboard Insert will insert the measurement values from the Windows Clipboard into the selected Sensor But all old measurement values of the Sensor will be lost However not all configuration settings can accepted A better way to copy measurement values is to use Drag amp Drop Accessrights You can change the configuration of a Sensor if you have the accessright Change Configuration Configuration parts are also e g Serial and Channelnumber In order for saving measurement values in DEMASdb the user 87 Measurementsystem 88 must have the accessright Change Content The measurement values can display and exported if the user have the accessright Show Contents For displaying and changing the contents the user must have the accessright for the devices Chart Device and File Device too 7 9 1 The Simple Sensor The Simple Sensor save measurement values to a dedicated Serial and Chan nelnumber to the database Property Page The Property Page is located in the dialogbox of the Objectproperties Here it is possible to set the Serial and Channelnumber for the identification of a Sensor Furthermore the unit and the comment from the measurement value file You will find Minimum Maximum by displaying the values with MGMDS Information Properties Security Channelnumber fj Unit fn minimal Value 1 1234568392012494583 maximal Value 4 5341 2238495065938274 Serialnumber Fos o CMT SURF
80. ent values to a dedicated Serial and Channelnumber to the database The Sensor calculates the measurement values at the Import based to a 3rd graded function You can set the parameter for the calculation on the Properties page at the Objectproperties The parameters have to set before saving the measurement values Properties The Property Page is located in the dialogbox of the Objectproperties Here it is possible to set the Serial and Channelnumber for identification of the Sensor Furthermore the unit the comment from the measurement value file You will find Minimum Maximum by displaying the values with MGMDS 7 9 4 The Calculating Day Block Sensor The Calculating Day Block Sensor differs from the Calculating Sensor only in the kind of saving measurement values to the database But he is optimised for Sensors which collects more than one measurement value a day 89 Measurementsystem 90 7 9 5 The Calculating Filter The calculating Filter have the property to converting measurement values based on a 3rd graded polynomial function The Filter will save the imported measurement values not to the database by itself as the Sensors The Calculation Filter only feed the measurement values forward to his sub ordered Objects When displaying the measurement values in MGMDS MLMDS the converting measurement values of the superior Sensors where shown It is not possible to edit or save the measurement values in MGMDS MLMDS Property Page
81. ersion of DEMASdb Further workstations could be installed by using the option Install DEMASdb If you are using the single user version of DEMASdb you must select this option e Install DEMASdb Installation on further workstations Use this kind of installation if you have installed the database for the multi user version before and further workstations should have access to the existing database e Update DEMASdb Database Update on the first workstation Select this option if a new version of DEMASdb shall install over an previous version Both the program files and the database will updated You have to do it only once a time in the course for an update of DEMASdb If you use the single user version of DEMASdb you must use this option for the update e Update DEMASdb Update further workstations Use this kind of installation to update further workstations of the multi user version of DEMASAdb when the database is already updated to the latest version 14 DEMASdb 3 4 1 2 Language Selection After selecting of the type of installation it will prompt in which kind of language DEMASdb shall display components menus and dialogs Which language specific version of DEMAS db should be installed C English C French iG C Portuguese Spanish Supported Languages for DEMASdb 3 4 1 3 Destination Folder The next dialog with the title Enter path for application ask you for the Destination Folder in which
82. es This Menu Entry open a further window which shows steadily the Objectproperties of the currently selected Object Access Rights An Object will only display on the Object Explorer if the User has grant the accessright Show Configuration to the Object 5 3 2 The Logbook 20 28 12 00 09 52 51 Information Simple Day Block Sensor ADO996 1 ADO996 1 created 2011 01 01 15 54 41 Information Measurement values of device HT100 read 11 01 01 15 54 41 Transaction did not process The Logbook records important actions and error messages An entry is made up of the kind of the message the point of time the appearance and the message text The kind of the Errormessage will identified by a symbol Fatal Error Errormessage 3 Information A Warning The messages will stored in the file Error log at the install directory of DEMASdb Is the count of the entries very large the file can deleted or renamed On the next start of DEMASdb the file will created automatically Context Menu All entries in the Logbook also can deleted by using the menu entry delete Logbook at the Context Menu All existing messages will be lost 42 Desktop 43 5 3 3 The Object File In the Object File you are able to group Objects which shall execute the same action New Objects can insert to the list by using Drag amp Drop or to search after Objects You can execute the same action on several Objects by marking the Objects and display the Cont
83. es page it is able to set the kind of measurement value output headline and footer Properties On the Properties page it is able to format the measurement value headline and footer Intowration Piopeter Siobal propaties Secusty Header TTT g n Fomati Vake PAE Eset O Propterties of measurement value window multitext Header Footer In this input field it is able to set a string for header and footer Format of Value This setting is explained at the Measurement Value Window text Save as basic adjustment Select this option if you want to save this settings for all new created measurement value windows of the same type The settings will automatically accepted 57 Mapsystem 58 The text for header footer can also containing wildcards with the following meaning n Name of the Loggers Catalogs p Name of the linked Loggers Catalog type oA o Wildcards In addition to the above you can use t to force tab stop and n for a line feet Example In order to show the name of the linked Loggers Catalogs in the header and separate it from the listed Sensors the input should have the following construct Sn n Additionally you must insert in the input field for the measurement the following AS AS d AS AS AS n t Sv u The measurement value window will display Logger TEMPER Sensor A 04 06 98 14 500 C Sensor B 03 06 98 12 430 C 58 Measurementsystem 59 7
84. ettings where also accepted but the dialogbox do not close If you do not want to use the settings please press the button Cancel button An alternative possibility to show the Object Properties will explain at the chapter Toolbars Object Explorer and Objectfile 28 Operation 29 4 4 1 Information Page On the page Information you will find generally information about an Object E Properties of Logger Eg Information Properties Comment a Theme y Keywords Po a Created at 05 01 01 16 02 04 Changed at 05 01 01 16 02 04 Content changed at 05 01 01 16 02 04 Informations about Objects Graphic and Comment Here you can insert a comment and show a picture for the Object Insert a picture by clicking the right mousebutton inside the comment field and chose the entry Open Bitmap In the dialogbox witch appears you can select the Windows Bitmap File with the extension bmp or JPEG files jpg To delete a bitmap please choose the entry Delete Bitmap in the Context Menu Theme and Keywords In this fields you are able to insert a Theme and several Keywords separated by blanks Within the search dialog it is able to search about Objects which have the same Theme or Keywords very quickly Time of creating and changing Objects and the contents These three fields contains information when an Object was created and or changed the properties and or contents You can search about these fields w
85. ext Menu of any marked Object The Menu Entry will executed ordered for all selected Objects With the help of the buttons the following actions can execute 102 Conzentration iw Logger Pressure A Measurement Project The Object File Global Search If you choose this button the Global Search Dialog will appear Here it is able to search in the whole Objecthierarchy up to Objects Delete selected Objects With this button it is able to delete selected Objects only on the view of the Object File These Objects will not deleted in the database You can choose this button only you have selected one or more Objects in the List Delete all Objects With this button you are able to delete all Objects only on the view of the Object File These Objects are not deleted in the database 5 3 4 Context Menu By selecting the menuentry Show Properties a separate window will open and display the Objectproperties of the currently selected Objects Are more Objects marked only the properties of this Object will display which has the focus dotted border around the name Die Object Toolbar The Object Toolbar shows a quick selection of the most used actions The actual Object is this Object marked in the Object Explorer or in the Object File which has the focus dotted border around the name 43 Desktop 44 BEE olele 3 0 el ela Figure 4 6 The Object Toolbar 0 Create Object 65 Delete Object hal Search O
86. ext Menu Each Object owns a Context Menu which can be open with a click on the right mousebutton in the Object Explorer The highlighted menuentry within some Context Menus represented the most used action of this Object which can also used by a double click on the Object directly without opening the menu A further possibility to choose actions is to use the Object Toolbar New Remove Rename Search Chart Report Write measurement values gt Backup Restore Properties The Context Menue of an Object 27 Operation 28 4 4 Object Properties All properties which can create and set at a Object can accessed over the window Properties of You reach this dialog when you open the Context Menu It is also possible to show the Properties of more than one Objects at the same time il Properties of Logger x Information Properties Theme Keywords Created at 05 01 01 16 02 04 Changed at fos 01 01 16 02 04 Content changed at 05 01 01 16 02 04 Cancel Apply Propperties of an Object It depends on the Object whether one or more Propertie Pages wheree shown Only the Information page is present for each Object You can choose a page by clicking on the title line A part from the shown page are the creating and changing date If you change the settings you must confirm it by pressing the OK button and close the dialogbox close By the selection of Apply the s
87. ext Menu Write measurement values of a Logger all Objects which are located below will include Alternative it is possible that links can created over measurement catalogues to Sensors for creating a report 7 4 1 Monthly Report You have the possibility to create a Monthly Report query report from your measurement values Please click to the Context Menu of the Object and select Write measurement values Monthly Report to start the evaluation The following dialog box will appear Month year to report C Merthyr lo report Fasi week begra on e lee Ch F fink Monday of month nis 7 days Fetan Chuan Vahl norih Inet 7 ds ran Moen 7 tal manih uril orm day bone the frond C May Morente Takadstion cf mosh y arsi morihiy average Cine F December if allele a Yew 2001 4 e Fro day of wosk attune megat T H h day d wask E Hody C Fiday rteapolated vaise ot 1 4 dap ot week Tuesday Stay TELI C Wedrerday F Sunday Thaseday Dapa wits T ES decimals aher comma EE es G Cate Cmd e The Monthly Report Here you can select month an year for the report You can select the year directly into the input field or by using the little arrows aside e First day of week In Germany the first day of week is always Monday until Sunday but here you can also select an other day e First week begins on In this place you can select the exact day when the first week in this month begin Have
88. f time interval about all 20 seconds This entry updates the changes before this period of time 5 1 4 Window Menu Menu entries of the Window Menu e Cascade Cascade all windows in DEMASdb e Tile Arrange all windows in DEMASdb side by side e Arrange Symbols Arrange all minimised Windows of DEMASdb e Minimize all Minimize all Windows in DEMASdb to symbols e Toolbars This sub menu lists all Toolbars of DEMASdb The visible Toolbars have a little hook before the Menu Entry Through selection of a Menu Entry the corresponding toolbar will be shown or hidden At the bottom of the window menu all opened windows will listed Through the selection of a window this will put to front 5 1 5 Help Menu Ment entries of the Help Menu e Helptopics The selection of this Menu Entry will show the Online Help e Info The dialog window shows the number of the currently used version of DEMASdb 39 Desktop 40 5 2 Global Settings 5 2 1 Language Settings In this dialog window it is able to choose the language in which the texts and dialog windows shall display To change teh language by choosing the Menu Entry File Settings on the Menu Bar on the desktop Language selection At the Language Page it is possible to select or change the language The settings can be accepted by pressing the Ok button Cancel close the dialog an do not change the settings 5 3 Toolbars Toolbars are windows which are able
89. f the Full Version you can use the Internet Setup files to upgrade your existing DEMASdb Two setup versions of DEMASdb are available on our Internetpage which differs by the shipped components e DEMASdb selfextracting Program complete This Setup Version contains all Components of DEMASdb Use this if you install DEMASdb for the first time of an Computer The filesize is about 13 MB e DEMASdb selfextracting Program without BDE This Setup Version contains all Components of DEMASdb except the Borland Database Engine Only use this version if DEMASdb is already installed on your workstation and you only want to update the program files and the database The filesize is about 6 MB 3 2 Licensing The range of function of DEMASdb contains the Dongle and a licence file for the modules MGMDS MLMDS and will be created for each customer separately The Dongle and the licence file will be created with the desired functions by SEBA Hydrometrie GmbH and sent together with the installation media of DEMASdb If the Dongle is not connected at the workstation DEMASdb will execute as a DEMO Version This version will enable a detailed test but with some restrictions of course 11 DEMASdb 12 33 2 3 System requirements At the fixing of the system requirements of DEMASdb it is necessary to differ between the DEMASdb Workstation and the Database Server If the Database Server and the Workstation run on the same computer please use the requi
90. g database and backup in the archive Database Thereby it is able to reduce the amount of data and increase the operating speed Attention If the measurement values are not backup it is not possible to restore it Overwriting of measurement values The action that should execute if measurement values overwrite as a whole or in part in the archive database can select by one of the following possibilities Do not overwrite Measurement values will never overwrite 1 Request User A dialog box will appear in which you can decide if the measurement value for this Sensor should be overwrite 1 Overwrite Always To overwrite measurement values always Notice 1 No measurement values of the Sensor will archived if the existing measurement values should not be overwritten A click on Start Backup will start the backup for all selected Objects The progress will show in a separate dialog where you can also cancel the backup 96 Devicemanager 97 8 7 2 Restore Objects Just as at the backup it is also able to select detailed which Objects should be restored form the Archive Device The selection can change in the tree structure in the archive window Please select the boxes in front of the entries with a left mouse button click You can change the selection status for all with Select all or Clear Selection imi Backup Restore of Objekts BEES Backup Restore EX fi DEMASdb la olaa S E 1 Measurement Sys
91. he settings of this page to all other pages as default setting The saved settings will automatically accepted for new created measurement value windows of the same type In the input field Format of Value you can also insert wildcards to the text You can use the followed wildcards Name of the Sensor Actual measurement value 3 post decimal positions Collection date of the measurement value Collection time of the measurement value Measurement unit Serialnumber of the Sensor Channelnumber of the Sensor 5 Qa lt vu E AP A AP AP AP Ae AY ct o Wildcards to format values In addition to the above you can use t to force tab stop and n for a line feet Example In order to display the name of the Sensor measurement value the collection date and the measurement unit in the measurement value window use the following format string oo oo d oo n v u _ Sensor A 04 06 98 45 500 m shall the measurement value and the date display in the same line use nAn d v 3u Sensor A 04 06 98 45 500 m 54 Mapsystem 55 6 4 2 Measurement Value Window bars The measurement value window bars The measurement value window bars display the actual measurement value of the linked sensor as a bar chart Properties In the Properties page it is possible to set the maximum and minimum of the displayed measurement value Irboma on Properties Global properties Secuaty Tem fas Dotan it 103
92. indow will hide CLICKED This action can be carried out to tools in oder to execute a stored action In some cases additional parameters could be necessary For some actions this option ist not available CASCADECHILDS The desktop object will cascade all child windows TILECHILDS The desktop object will tile all child window ARRANGEICONS The desktop object will arrange all windows as icons MINIMIZECHILDS The desktop object will minimize all child windows SETSTATUSTEXT Will set the text of the statusbar This action need aditional parameters therefore it is not able to use this action for all objects SELECTBACKUPOBJECT Will archive the actual selection SELECTRESTOREOBJECT Will restore the actual selection OBJECTSEARCH Opens a search dialog with the selected object starting at the selected object NEWDOCUMENT Creates a new child document at the document folder NEWFROMFILE Creates a new child docuemnt from a file WRITEDOCUMENT Stores the document into the Database DOPRIMARYVERB Executes standard processing method of a dokument PASTESPECIALFROMCLIPBOARD Paste the content of the clipboard in an empty document PASTEFROMOBJECT Pastes the content of an other document into the selected document This action is not available for all object 121
93. ink exists on this position it will create automatically The Grouplink You also can give a new position to an existing Grouplink or move it to an other Groupwindow with the help of Drag amp Drop Context Menu Open the Context Menu by clicking with the right mousebutton inside the rectangle If the Grouplink is linked with a target group the name of the Groupwindow will display on the top of the menu If this name is selected the menu of the target group will appear Two menuentries exists for changing the position move and the size Change size For both actions lift the left mousebutton if you have reached the new position or size With the menuentries to front or hide it is possible to fix the relative position of Grouplinks and measurement value windows Access rights To show Grouplinks the user must have the accessright Show Contents To change the size and position of a measurement value window the accessright Change Configuration is necessary 6 4 The Measurement Value Windows With the help of a measurement value window it is possible to show the actual measurement values of Sensors in Groupwindows You can create a measurement value window in order to drag a Sensor to a Groupwindow and drop it by releasing the mousebutton Thereupon a dialog will appear in which you are able to select the required type of representation 51 Mapsystem 52 You can choose the following measurement value window types al Text a
94. isplay in a window of DEMASdb but it is a difference between the preview and the edit mode The preview shows only the first page of the document and is also show on the Document page of the Objectproperties The edit mode displays the whole document for showing and editing It is possible to open the edit mode within DEMASdb or in an external window of the OLE Server To display the edit mode inside the desktop of DEMASdb the menus and toolbars of DEMASdb will substitute with the menus and toolbars of the OLE Application To switch to the normal representation please click to an other window inside of DEMASdb or choose the menuentry Close of the Context Menu for the document If the document is display in an external window the Document Window will hatched in order to show that somebody is working on the document yet 100 Documents 101 It is possible to move Documents to other Document Folders per Drag amp Drop In order to create a new template from an existing document please Drag amp Drop the document to a Document template Folder If the Document will Drag amp Drop over the Template Folder it is able to create with copy a duplicate copy of the Document Context Menu Press with the right mousebutton in the Document Window on the symbol left top will open the Context Menu In the preview it is able to open the Context Menu by a click with the right mousebutton within the window To execute the default action in this mode please doub
95. ith the Searchdialog 29 Operation 30 4 4 2 Properties Page This page of the Objectproperties contains fields for special settings of an Object According to the Objecttype each object has its own structure For further Information please look at the description for the appropriate Objecttype E Properties of FODA523 x Information Properties Serialnumber Fona523 Channelnumber 3 Unit mn CMT ss minimal Value 1 30239447893354 maximal Value 2 34567232747284 The Properties of an Object 4 4 3 Security Page Information Security E Show Modify Security Settings of an Object For the assigning of accessrights to Objects DEMASdb provides the Security at the Objectproperties With a click on the button Show Modify the following Dialog appears 30 Operation 31 5 Accessrights Name of Object DEMASdb Owner SEBANTSsattler Rights Name Zugriff Add amp Sattler Administrator KARW de SYSTEM Administrator KARW Delete Access Administrator x K Show configuration A Change configuration R Show content w Change content B Show security S Change security Cancel Accessrights for Objects e Name of the Object This will show the name of the Object in detailed whose accessrights are shown currently e Owner This is the name of the Windows Account which was logged on if the Object was created e Rights Shows the
96. l define the size of the interval Values from year down to minute are available The interval will be align always to the 1st of January of a year Therefore the interval e g 5 minutes will start always at midnight of a day 72 Measurementsystem 73 Extraction Time Here it is able to define the point of time where the extracted values shall be store The available Settings are Begin of Interval or End of Interval For some functions e g Minima it is also possible to select Time of Measurement In this case the value will store on the point of time when it occur 7 3 3 4 Function Formula An evaluation with formulas provides a flexible way to change measurement values With the help of mathematical expressions it it possible to combine different data sources and join it together for evaluation The basic procedure for calculation function is to collect all measurement values at each time from the data source and send it to a defined formular for execution the calculation The result of tis calculation will store to the sensor If more than one datasource are used the formular will execute for each measurement time also when a measurement value not exists in a datasource at tihs time Normally only measurement which are within the calculation periode will load from the datasource for calculation With the BackviewIntervall it is able to load measurement values from the datassource which are located before the calculation periode
97. l placed in extra documents but the SEBA Hydrometrie GmbH can also do the data migration for you 17 DEMASdb 3 4 3 Connecting the Dongle The Dongle have to be connected to the parallel port on your computer You plug the male plug pins of the Dongle into the 25 pole hub onto the computer In order to prevent mistakes mixing up ports the right socket adapter is labelled with COMPUTER Printers and other peripheral devices using the parallel port can continue to utilise You have to connect them to the female port hub of the Dongle Up to that time we do not know any problems NOTICE In order to prevent damage please turn off the power of the computer if you connect the Dongle or other devices 3 5 Uninstall DEMASdb If you want to uninstall DEMASdb please open the Start Settings Control Panel Double click to the symbol Software Mark DEMASdb in the Install Uninstall page and press the Add Delete button All components of DEMASdb will uninstall but not the data which you have entered during the use of DEMASdb 3 6 Start DEMASdb DEMASdb could be started over the program group SEBA Software in the start menu of windows If you use DEMASdb with a SQL Database you have to login to the working database with your database account Please enter your username and password into the login dialog and press Ok Paradox Databases do not have a login dialog If you use a DEMO Version of DEMASdb only the DEMO Dialog will appear
98. le click with the left mousebutton The appearance of the Context Menu depending on the kind of document The Menu Entries on the top have the form of Edit Document and Open Document The first entry open the document inside of DEMASAdb for editing and displaying The second entry will open the document in an extra window of the OLE Server It may be exists further menuentries such as Print etc this depends on the used OLE Server The menuentry Show open the preview of the document in a window of DEMASdb Close will close the window With Copy it is able to copy the document to the Windows Clipboard Accessrights In order to show Documents the user must have the accessright Show Contents For any changes the Change Contents accessright must assign to a user 9 1 3 The Document from Template The Object Document is conform to the Document but if a new Document was create a dialog will appear in which it is able to select a Document Template This Document Template is the base for further new documents 9 2 Templates 9 2 1 The Document Template Folder The Document Template Folder is conform the normal Document Folder The difference is that below this Object it is only able to create Document Templates 9 2 2 The Document Template The Document Template is conform to the Object Document The difference consists of that the Document is used as a template for other Documents 101 Taskmanagement 102 10 Taskmanagement
99. lung ServerLogon Logon f r SEBAS Logon fiir SEBAServer ServiceAccount Service Account fur Replikati Sieber Sieber Stefan Konstruktion hd reabteilung Selected Names SEBANT Sattler Accesstype Administrator X Cancel Select Users to have access to Objects e Show Names of Choose here the Windows Domain where the accounts shall be listed After a Domain was selected the available accounts will show If you also want to show the Useraccounts please press the Show User button e Name The existing User and Group accounts which are available in the selected Domain are listed there A picture in front of the name symbolises the kind of account The second column shows a comment to each account given by the Administrator Select a entry by double clicking or by mark and press the Add button e Selected Names This field shows the names of accounts which are selected and added separated by semicolons The accounts also can added directly in this field Please notice that in most domains the domainname must added in front of the Username followed by a backslash e Accesstype Choose here the kind of access which all selected accounts should have You can change the accesstype at any time A click on the Ok button accepts the settings An errormessage will appear if a account does not exists 32 Operation 33 4 5 Drag amp Drop DEMASdb supports the full functionality of Drag amp Drop This
100. n one file please use Wildcard Signs see Glossary in the input field Filename In the field Filetype you can select a special one The import will start when the OK button was pressed The following dialog shows the file which is currently read in In this dialog it is also possible to Cancel the import ffnen HE Suchenin E Samples El ex fs sl ss 200691 dr uck E 200691ge sch 2006911i cht 200691ri cht 200691te mpe a wobreg1 411 TF Mit Schreibschutz ffnen How to import measurement values from file NOTICE If the import of measurement values by the File Device do not exists in DEMASdb it is necessary to activate the File Device in the Devicemanager first 64 Measurementsystem 65 7 2 3 Import Measurement Values automatically from Files Additionally to import measurement values manually it is also possible to import measurement values automatically Hereby one or more directorys where scan and if new measurement files exists the files will import automatically into the database of DEMASdb The following steps will show how to configurate the automatically import e In the context Menu of the Retrieval object which shall perform the IMPORT select the entry properties In the appearing properties dialog activate the page automatic input devices Now create an entry for all import directories in the way which described in the chapter 6 7 e Create a new job below the object Jobmanagement
101. ng power and suitable methods to maintain the data consistency default menu entry The mostly used Context Menus Entry for Objecttyps are highlighted in bold font This means that for this menuentries it is also able to execute it directly with a double click to the object in the Object Explorer or in the window of each object single user mode look at multi user mode Context Menu In the Context Menu it is able to choose actions which can execute with an object The structure of the menu depends on the kind of the object A single mouse click with the right mouse button will open the Context Menu if the object is selected within the Object Explorer Sometimes it is also able with a direct click on a window multi user mode It is able to use DEMASdb for a single user or a multi user version It depends on the license With the single user version only one workstation is able to connect to the database The multi user version allows the connection from more than one workstation to the database in order to use the configurationdata and the measurement values at the same time 112 Glossary 113 MGMDS MLMDS The modules MGMDS graphical and MLMDS list are used to display or evaluate charts of a Sensor In order to display the measurement values please choose the entry Chart or List in the Context menu eof a Sensor For further information to the operation of MGMDS MLMDS please read the optional documentation objects
102. nt values from HT100 or Read Measurement values from LG100 The dialog below is shown and prompting you to start the data transfer on the HT100 or LG100 The progress of the reading measurement values is shown during the data transfer in a dialog You are able to stop the transfer by pressing the Cancel button EA LG100 Read Memory Card x e Please activate transmission at HT100 2 To stop action press CANCEL Cc e a How to import measuremen tvalues from HT100 or LG100 NOTICE Are the menuentries HT100 or LG100 not available in DEMASdb it is necessary to activate the Serial Device in the Devicemanager first 7 2 5 Manual Input of measurement controlvalues It is also possible to insert measurement values of a Sensor manually in one dialog You will reach it by opening the Context Menu of a Sensor and select the menuentry Read measurement values from Manual Input Input Values of F02139 1 F02139 1 x si i a Close Serialnumber Channelnumber 0 Value Date Type Value C Referencevalue Value 0 000 List de Manual input of measurement values e Serialnumber Channelnumber This will show the Serialnumber and the Channelnumber of a Sensor for which measurement values shall imported 66 Measurementsystem 67 e Value Insert here the new measurement value and the kind of measurement value e Da
103. nt version in the database and not in the file version The menuentry Insert allows to insert a OLE Document from the clipboard to DEMASdb A new Document Object will create in the database which is able to store the new document in the database Accesssrights To show the Document Folder the user must have the accessright Show Configuration In order to create Documents below the folder the accessright Change Configuration is necessary 99 Documents 100 9 1 2 The Document The Object Document also named Document Window stores any OLE capable documents in the working database and then it is able to show and edit the documents in DEMASdb ete Media Clip Create ftom File MIDI Sequence Create New D o 3 Paintbrush Picture Video Clip 3 Wave Sound T Display As Icon WordPad Document Result Inserts a new Bitmap Image object into your 9 document The Document Object of DEMASdb When creating a Document it is necessary to define the kind of the new document first as shown in the picture Select Create New if you want to create a new document Search in the list Objecttype for the required kind of document Choose Create from File if an existing document is stored as a file In the following dialog it is able to select the directory path to the existing file Please press Ok for accept the settings After the new Document was renamed it will open in the edit mode The documents are d
104. ntil this Agreement is terminated You may terminate this Agreement at any time by destroying all copies of the Software This Agreement will terminate immediately and without further notice if you fail to comply with any provision of this Agreement All obligations of confidentiality and restrictions on use and all other provisions that may reasonably be interpreted to survive termination of this Agreement will survive termination of this Agreement for any reason Upon termination you agree to destroy all copies of the Software If you have obtained an evaluation copy of the Software and have not purchased a license to the Software this Agreement and license are effective for a period of 30 days from the date of installation of the Software Limited Warranty If you have purchased a license to the Software if the Software is delivered using a computer storage media such as a CD ROM or diskette SEBA warrants that the media on which the Software is furnished will be free from defects in materials and workmanship under normal use for ninety 90 days from the date you received the Software as shown by your receipt This warranty is limited to you and is not transferable This warranty does not cover damage caused by improper use or neglect SEBA s entire liability and your exclusive remedy shall be at SEBA s option i to replace the defective media ii to advise you how to achieve substantially the same functionality with the Software as described
105. on NOTICE We will explicit prompt that during the configuration process save load or move no other program shall execute which use the BDE Borland Database Engine After the start of DEMASdb Setup the welcome message appears With Next you will reach the dialog In the dialog below it is able to select the required action Configuration Management of DEMASdb Choose one of the options below or press CANCEL Save active configuration EN This option will copy files of your configuration to a specified directory Load configuration as active configuration eT This option will overwrite your active configuration with an existing configuration Move active configuration This option will move your active configuration to anew directory The DEMASdb Configuration Management 20 DEMASdb 21 3 8 1 Save active configuration In this function DEMASdb Setup will copy the data of the actual configuration into a folder This data are able to save with a backup program or can copy to other workstations In order to save the active configuration you will directed thru a list of dialogs which is shown below 1 Dialog Setting up the Configuration Folder Please insert here the destination folder in which the saved configuration should be stored All data in this directory will deleted If the selected destination folder exists you must confirm that the configuration will copy to this destination folder
106. or Timeintervals With this functions it is possible to create easy operations within intervalborders The intervals can have the following resolutions and can set at a function with the parameter interval Name Description DTI_YEAR Year DTI_HALFOFYEAR 6 Months DTI_QUATEROFYEAR 3 Months DTI_MONTH 1 Month DTI_WEEK 7 Days DTL 10DAYS 10 Days DTILDAY 1 Day DTI_12HOURS 12 Hours DTI_6HOURS 6 Hours DTI_3HOURS 3 Hours DTI_2HOURS 2 Hours DTI_HOUR 1 Hour DTI_30MINUTES 30 Minutes DTI_15MINUTES 15 Minutes DTI_10MINUTES 10 Minutes DTI_5MINUTES 5 Minutes DTI_2MINUTES 2 Minutes DTI_MINUTE 1 Minute Existing functions Existing functions TSISDateTime DateTimelntStart dt TSISDateTime interval integer Begin of the interval TSISDateTime DateTimelntPrior dt TSISDateTime interval integer Begin of the interval before TSISDateTime DateTimeIntNext dt TSISDateTime interval integer Begin of the next interval 120 Appendix 121 13 2 Actions Name Description AUTO RETRIEVE Starts the configured import of measurement values which was set at the Retrieval Object TASK START Starts a task manually TASK START AUTO Starts a task automatically OPENMLMDS Opens the all child objects with the list module MLMDS OPENMGMDS Opens the all child objects with the graph module MLMDS SHOW If the object is a windows the window show HIDE If the object is a windows the w
107. r the purpose of evaluating whether you wish to purchase an ongoing license for the Software Copying Transferring or Modifying Software The Software contains copyrighted material trade secrets and other proprietary intellectual property You may not permit concurrent use of the Software unless each user has an applicable license You may not permit other individuals to use the Software except under the terms listed above You may not decompile disassemble reverse engineer or otherwise display the Software in human readable form You may not modify translate rent lease distribute or lend the Software and you may not sell to others the right to use the Software on your computer You may not remove any proprietary notices or labels on the Software You may not copy transfer transmit sublicense or assign this license or the Software except as expressly permitted in this Agreement You agree that the terms of this paragraph apply to the Software or any portion thereof whether owned by SEBA or SEBA s licensors License to Use Content All artwork graphics icons and other files contained in the Software including without limitation AutoSites SiteStyles Design Parts Plug In Parts and Smart Objects collectively the Content are copyrighted material owned by SEBA or its licensors Term If you have purchased a license to the Software this Agreement and license are effective from the time you accept the terms of this Agreement u
108. reate a Sub object delete and move Objects move Measurementwindow or changing the serialnumber of a Sensor e Show Content Allows showing of the contents of an Object The contents refers to the data which do not belong to the configuration Show e g measurement values of a Sensor or Toolbars and Windows e Change Content Use this right for changing contents A user who owns this right is able to change the measurement values of a Sensor e Show Security With this right you can show the assigned Rights but it is not allowed to change the rights e Change Security With the help of this access right you are able to grant or withdraw rights to users for Objects 34 Operation 35 In order to simplify the allocation of accessrights DEMASdb will supply different Usertypes with predefined access rights profiles e Administrator The Administrator configures DEMASdb and have full access e User A User works with contents He should able to show and modify measurement values e Guest A Guest can change neither the configuration nor the contents of DEMASdb but e g showing measurement values Should a User or Usergroup is suitable in no profiles the profile user defined exists Rather than it is possible to adjust the individual accessrights The allocation of accessrights in DEMASdb takes place in the dialog Userrights Please read after the first installation the notices in the chapter Accessrights after the ins
109. rements of the Database Server or add both values The descriptions below are minimum specifications 3 3 1 DEMASdb Workstation e Operating system Windows95 Windows98 or WindowsNT 4 0 with ServicePack 5 e CPU Pentium II or Celeron more than 266 MHz e primary memory 128 MB or higher e hard disk space 20 MB e graphic resolution 1024x768 NOTICE If you want to use the User management of DEMASdb you must use the operating system WindowsNT 4 0 or higher 3 3 2 Database Server Paradox Desktop Database e Operating System WindowsNT with ServicePack 5 or Windows 2000 ServicePack 4 e CPU Celeron higher than 1 GHz e Primary Memory 256 MB e Hard Disk Space 200 MB e Network Interface Card 100 Mbit Fast Ethernet Informix SOL Database Oracle SOL Database Microsoft SOL Server e Operating System WindowsNT with ServicePack 5 or Windows 2000 ServicePack 4 e CPU Pentium 4 1GHz or Dual Processor e Primary Memory 256 MB better 512 MB e Hard Disk Space 5 GB e Network Interface Card 100 Mbit Fast Ethernet 12 DEMASdb 13 3 4 Installation of DEMASdb Please notice the following instructions to succeed your Installation e On ainstallation to WindowsNT or Windows 2000 the user must logged on as Administrator e During the installation no other programs may run especially programs which uses and have access to the Borland Database Engine BDE Please quit all such programs before the installation of DEMASdb
110. rror may be exists 92 Devicemanager 93 Accessrights If the User have the accessright Show Configuration and Show Contents the menu read measurement values from will display and measurement values can be transferred For setting up the device properties the accessright Change Configuration is necessary 8 2 The Chart Device With the Chart Device it is able to show measurement values within MGMDS MLMDS Is it not possible to show charts in MGMDS MLMDM than either a new Object by the type of Chart Device have to create below the Devicemanager or the user have not enough accessrights This Device must not be configured Accessrights In order to work with MGMDS MLMDS the user must have the accessright Show Configuration The accessright Show Content is used to show charts User who should change Charts they must additionally have the accessright Change Content 8 3 The File Device With the help of the File Device it is able to import or export measurement values in files Is it not possible to import or export measurement values than either a new Object by the type of File Device have to create below the Devicemanager or the user have not enough accessrights This Device must not be configured Accessrights In order to use the import or export of measurement values the user must have the accessright Show Configuration For the import of measurement values the additionally accessright Show Contents is necessary By using the
111. ry the contents of the dragged Object will copy to a existing Object The Contents of the dragged Object will deleted Drag amp Drop Menuentry Cancel Cancel the current Drag amp Drop action 33 Operation 34 4 6 Access Rights The accessrights protect the data which are stored in DEMASdb It can be used to allow only a closed Usergroup to access change or showing the stored data Attention The management of the accessrights based on the Usermanagement of WindowsNT 4 0 Windows 2000 in Domains therefore it is not possible to use this functionality of DEMASdb under the operating system Window 9x In this case all Users have full access to all data of DEMASdb without any limits The management of the accessrights based on the Security attributes of the Filesystem of Windows This means that each Object in DEMASdb can restricted to show and or change Objects A user must have an WindowsNT Domain account and logged on under this account The accounts must created by an Administrator on the local Computer or in a network from the Networkadministrator of the WindowsNT Domain The following Rights are able to set to a User account for a Object e Show Configuration Show the configuration of an Object A User who own this right for an object is able to showi the Information page or the serialnumber of a Sensor e Change Configuration Only with this right it is able to change the configuration of an Object Allowed actions are c
112. splay in measurement windows which are located at the Groupwindows The Sensortyps are splited in three groups Simple Sensors Simple Sensors save the measurement values in unmodified form to the database 4 Simple Sensor A Simple Day Block Sensor Calculating Sensors Calculating Sensors will perform calculating the measurement values before they will save to the database So for an example an automatically conversion from measuring point to Sealevel NN is possible 14 Calculating Sensor 14 Calculating Day Block Sensor Filter Filter will also calculate measurement values but they do not save it to the database They can used e g when the calculated measurement values raw data are only used to display as chart with MGMDS MLMDS Calculating Filter It is able to move the Sensors within the measurement system by using Drag amp Drop The content of a Sensor Serial Channelnumber Comments as well Measurement and Control values can copy to an other Sensor by using Drag amp Drop But all existing Settings of the old Sensor will overwrite Context Menu By the selection of Chart or List in the Context Menu the measurement values of a Sensor will display in MGMDS or and MLDMS If you want to generate a Reports for Sensors please select the entry Write measurement values In the submenu Read measurement values from you will find several menuentries e g manual input of measurement control values Copy copies the measur
113. t Explorer Choose the Context Menu Entry Search or Click to the flashlight symbol The Search Dialog Search from appears for entering the search criteria Search 1 Measurement System x it Change date Owner Group Object name a Stop m AA Keywords Ss Content Search for an Object The Contents Page e Objectname Character string be content of the Objectname e Theme Character string looked for the field Theme at the Information Page e Keywords Character string looked for the Field Keywords at the Information Page e Content Character string which shall seeked in content of an Object The Content of an Object depends on the Objecttype For an Objecttype Logger the Serialnumber belongs to the Content The Search for contents of an Object will increase the terms of Search seriously The Change Date Page e Objects whose Change the date after having search You are able to select the creating date changing date or the date of changing any content of an Object More than one can also select e between and lies period of search The User Group Page This search criteria will be implemented in a later version of DEMASdb To start the search by clicking on Start During a search is running it is able to stop the search with a click on the Stop button If you press the New search button all search criteria will reset 26 Operation 27 4 3 The Objects Cont
114. tallation of DEMASdb Notice When loading the DEMASdb Configuration on a other computer as the computer on which the configuration was created be aware that the accessrights can only used if the new computer is located in the same domain Is this not the case all the accessrights have to create if they are not available Because the account Administrator is available on every system this account should maintain and possess all legitimations see also Accessrights after the installing of DEMASdb Access Rights after the installation of DEMASdb After the installation of DEMASdb you will find an open system This means that every user have full access to all Objects In order to restrict the users access rights accessrights for this user had to be set For the simplest method please use the following agenda please log on with administrator privileges to WindowsNT 1 Step Set up the three Groupaccounts DEMASdbAdmin DEMASdbUser and DEMASdbGuest by using the user manager under WindowsNT Is the PC located in the network the accounts have to created in the domain 2 Step Assign users as members to the group DEMASdbAdmin which configure DEMASdb Do so with normal users to DEMASdbUser and Guests to the group DEMASdbGuest 3 Step Start DEMASdb and open the dialog Access right across the Object Explorer for the Object on the top mostly named DEMASdb 4 Step Click to Add and select in the next dialog the Group
115. te Date and Time of the new measurement value e Type Please select the kind of the new measurement value e Value numeric value of the measurement value The measurement value will store to the database if you press the Set Value button List Chart Here you can point the List or the Chart of the Sensor which is actual edited If all measurement values are inputed you have to press on the Close Button to leave the dialog NOTICE Is the menu entry Manual Input not available in DEMASdb it is necessary to activate the Manual Input in the Devicemanager first 7 3 Evaluation of Measurementdata DEMASdb will provide a lot of functions in order to calculate measurement values automatically The evaluation of measured data will made by calculating functions The functions starts from easy Minima maxima evaluations over predefined built in evaluations e g shunshine hours up to input user defined formulas The calculating functions are very free configurable and provides the possibility to create own formularies For each of the used calculating functions it is possible to set access rights for authorized or and unauthorized users or groups The following describes the procedure of DEMASdb by evaluation measurement values in prinziple After this each method will described in a detailed manner 7 3 1 Functions in prinziple 7 3 1 1 Calculating functions The base of the evaluation are the calculating functions Depending of the type the
116. ted ct Ee ee aE EAE AE ESA ESKERA ET eee ede 9 2 3 Typosraphio Conventions siisi issin ARS 10 A O 11 3 1 DA O 11 3 27 A TO 11 3 3 2 3 Systemi reguire ments iia E E E a dianas 12 Z3 DEMASAD WOrkS ta OA is a 12 JIZ Databasc Servens orien a ts 12 3 4 Installation of DEMASAD wisccisscccicsseasisiisiccciinnsversibessacodenasaeda ss doedtaascsactasdencsaapeveateds 13 3 4 1 E 13 3 4 2 Install Process for SQL Databases cconnoooocononocccnnonononanonoccononannn no nononcononannnnn nooo 17 3 4 3 Connecting the Donde tor oie iaa da 18 20 Uninstall DEMAS A O oo 18 3 6 StatDEMASd cui 18 3 7 Command Line OOM 45 e eaa a A E A ES EA acta ia 18 3 8 CONTA i a eae a 20 3 8 1 A einni i a ii 21 3 8 2 Load configuration as active configuration ocoococnnoccconaccnonncnononcnononcnnnnnncnnnncnnns 21 3 8 3 Move ACH VE CONSUMO 22 A A este E A eels cs nae ects ca ce sssoarpe ios oc gus ncaa os uae san N 23 4 1 QUICK SUG ass iio iia 23 4 2 Working With Objects iii csissciscegeacivsssdeaisassazsvecheceta segeastnaved cats E E 24 4 2 1 Create DIAS e 24 4 2 2 Delete ODESSA 24 4 2 3 Rename Oboe iii 25 4 2 4 LINK ODJECE sd 25 4 2 5 Search ODJECIS A a A a a ee 26 4 3 The Objects ContextMenu ide N Eas 27 4A ObjectPropertie senh aee e n e a dss Ee A E E EEE an seae ase 28 4 4 1 nforme ach nee on cence ato lam neath N Kae hle Mea ten car 29 4 4 2 Properties Pape coche tesa Slee N dade dares cease cee 30 443 Security PASE aaa 30 4 5 Drag amp Drop ici di ii ile 33 4
117. ted value time 409 Soil Temp 20cm A 04 Windspeed A 03 AIR Pressure Select Sensors for a Job At the Page Select Charts it is possible to select the required Charts for this Export and the Sensors will added to the list e Chartlist This list contains all selected Charts which shall export The Column Name displays the Name of the sensor The Column Last exported value time shows Date and Time of the last Export 104 Taskmanagement 105 With the arrows on the right side it is able to change the selected entries e Add Adding new sensors to the Exportlist e Delete Delets the seleted Sensors from the Exportlist e Properties Calls the Propperties dialog of the selected Exportlist e Format For some fileformats it is possible to set additional options for each chart With a click to the button Format the options will display Creating unique Filenames If a Job shall create more than one files it is possible to use replacing commands at the filenames in order to create unique filenames Unique Filename Generating The unique filename generating is using commands within the filenames which will replace during the export and had the following struct CMD PARAM1 PARAM9 more precisely CMD Name of the command for replacement PARAM1 PARAM9 optional parameters for a command separated by semicolon If control characters will used within the parameters they had a Sign in front 1
118. tem E E Gal Measurement System Folder F Restore Values S E A Measurement Project 5 0 amp Germany 18 01 01 6 0 E Berin Left a Bight 18 01 01 E E fg Logger TEMP Dverwriting measurement values aia FE 00740 0004 E00740 4 aio S O fil Kaufbeuren on 0G Itay patua DE Retrieval C Always overwrite O 2 Maps H 3 E 3 Desktop Select all a 4 Devicemanager E Danmante Tamniatan a Clear selection Restore Objects Selection of the recoverable Objects The selection can make at the tree structure in the archive window Please select the boxes in front of the entries with a left mouse button click lv The Object and all sub Objects will restore The Object will restored however at least one of the sub ordered Objects not This Object and all sub ordered Objects should not restore This Object will not restored but at least one of the sub ordered objects will restore For this Object do not exists any data to restore X This symbol means that for this Object restore is unsupported Objects which was deleted in the working database after backup where labelled with the x on the end of the Object name Only in Archive It is not possible to assign an Object to his parent object because the parent Object does not exists in the working database Such kind of Objects will displayed in the list Only in Archive In order to restore such kind of Objects please insert it in the tree view Select the Object in the tree view
119. time the value will interpolates from the next neighbouring measurement value The average per month is calculated from the arithmetic average of all middle values per week Further Settings Here it is able to set the post decimal positions which shall used for the report output Additional to this you can set two different headlines If you want to export the data as an EXCEL File you have to insert a file name or search anyone by using the button After this you have three possibilities for the output Print Output directly to the printer Before the final output you have the possibility to set the printer in the known dialog box The Windows Default Printer is set by default Preview Output on the screen at first and then possible to the printer The following dialogbox will show this Toolbar for print preview e Zoom You can select three different Scaling factors 80 Measurementsystem 81 Oe gt SS We schicsen The Monthly Report print previw e Browse For more than one page it is able to browse with the arrows e Print The query report will printed to the Windows Default Printer You have not the possibility to change the printer If you want to print to an other printer as the default printer please do not use the preview Print directly e Save and Open Reports Instead of printing a report and store it as paper it is also able to save it to a file for later printing Excel File Outp
120. tination folder will be set automatically but you are able to check it 16 17 DEMASdb 3 4 1 7 Setup Type and Program Folder You are able to select the installed components in the dialog Setup Type Please use the Typical Option in order to install all required components You can select the name of the Program group in the next dialog Select Program Folder The Program icons will be created there 3 4 1 8 Finish the Installation The finally dialog Check Setup Information shows a summary of all settings A click to the Next button will start the installation of DEMASdb After successful installation the workstation had to reboot to complete the installation 3 4 2 Install Process for SQL Databases For using SQL Databases the install process of DEMASdbis splitted into two parts At first DEMASAdb is installed with the Paradox Database on the first workstation Installation type Install DEMASdb Database The second step starts the migration from the Paradox Database to the target database After a successful data migration further workstations could be installed Installation type Install DEMASdb But it is necessary to change the asked database type to the target database On this workstations additional configuration changes need to be set manually because the Installer can not do this during the installation progress Further information to the installation progress and to the data migration to server databases wil
121. to placed on a border of the mainwindow docked or as a single free positioned windows undocked In order to move any Toolbar please click with the left mouse button to the border drag it with the pressed mouse button and drop it to the new position During the drag operation the new position of the toolbar will hinted by a hatched rectangle The representation of the Toolbar in an own window Undocked is reached when release the Toolbar by pressing the Ctrl key Pais ES a BEKLEDEN roc s oj 80 Arrangement of Toolbars For some Toolbars it is able to change the size e g Object Explorer Within the docked mode for that toolbar an additional bar will appear By clicking an moving this bar with the pressed mouse button the size will changed 40 Desktop A list with the available Toolbars is listed in the menuentry Window Toolbars Context Menu The Context Menu of a Toolbar will show if you click with the right mouse button to the border of the Toolbar Window Always the items visible and docked are available With help of visible you can display or close a toolbar With Docked you are able to fix the toolbar on the desktop or show it in an own free positioning window Access Rights In order to show a Toolbar the user must have the right Show contents for that Toolbar 5 3 1 The Object Explorer The complete Objecthierarchy of DEMASdb will show in the Toolbar Object Explorer 69 Demasdb Sl g
122. u if you click with the right mousebutton to the blank field into Groupwindows The Backgroundpicture of a Groupwindow e Preview of the backgroungpicture Shows the actual used backgroungpicture of the Groupwindow e Type of representation Here you can choose how the backgroundpicture shall display Simple means the normal display Do you select Tile the bitmap will repeated among each other and side by side e Search Bitmaps and Delete With Search Bitmap you are able to search for a Windows Bitmap File bmp jpg which shall use as backgroundpicture With Delete you can delete a graphic and the Groupwindow display only a gray background The graphic will not stored in the database If you use the multi user Version of DEMASdb Please notice that the Bitmaps must have to distribute to a directory on which all users have the access Access rights A Groupwindow will only show if the user have the right Show Contents For changing the backgroundpicture user needs the accessright Change Configuration This accessright will also used to create or delete child Group and measurement value windows 50 Mapsystem 51 6 3 The Grouplink A Grouplink is a rectangle in a Groupwindow which allows you to jump by an double click with the left mousebutton to an other group or document window The target of the Group Documentfolder can set up by dragging the target window over the Grouplink per Drag amp Drop If no Groupl
123. ues witin a defined interval Examples are minimas average Notice When a calculation uses a time period which is not defined within the interval borders the measurement values must be reloaded Therefore it is important that the source sensor stores the measurement values Properties of EC TDS Information Properties Calculation Events Security Type of Calculation Interval Calculations Fl Description atasources Name Sourceobject x 202 EC Parent Function Interval Sum y 1Day Extraction Time e Begin of Interval C End of Interval Time of Measurement Cancel Apply Calculating Function Interval Page Calculation In order to work with Interval calculations in the input windows Type of Calculation the entry Intervalcalculation hat to selected In the list of Datasources it is possible to select a Datasource siehe also Chapter Configuration above 6 3 2 1 Into the section Settings the following functionality is available Function In this option list it is possible to select the calculation function which shall use an interval Name Description Minima The smallest value will extract in the intervall Maxima The largest value will extract in the intervall Summe All values within the interval will accumulated arithmetic mean All values within the interwall will accumulated and divide to the count of values Interval This entry wil
124. urt Bight 18 01 01 K O fj Kaufbeuren AAA DB tay f Overwriting measurement values 4 eee C Do not overwrite a a 6 Request User 1 9 Raingauge C Overwrite always Y 4 Redox 0 4 Temp Select al O Winddirection O 41 Windspeed Clear Selection 6 0 BH Retrieval ic mie 2 Maps Start backup 5 2 E 3 Desktop 36 E 4 Devicemanager 1 17 B 5 Documents Templates Backup Objects 95 Devicemanager 96 Selection of the Objects which should archived In this window you can take the selection of the archived Objects For this a little box in front of each entry will show the status which have the following meanings W The Object and all sub Objects will archived The Object will archived however at least one of the sub ordered Objects should not archived Ll This Object and all sub ordered Objects should not archived This Object and all sub ordered objects will not archived This symbol means that for this Object backup is unsupported By a click with the left mouse button on a box the selection status of the Object and all sub ordered Object will change Options for Sensors If Sensors with stored measurement values should archived you can select the kind of state how the measurement values should store Shall the measurement values backed up please select Backup Values and fill the period of time into the two input fields Left Right With Reduce Values the measurement values will remove from the workin
125. ut to an ASCII File which can imported in EXCEL for further processing NOTICE To open it in EXECL you must select Textfile The values will directly write to the file whose name is insert in the field Excel File Each line in the output represents an sub object e g a Sensor of the selected Object The name of the selected Object is the headline of all this sub objects Please group the Sensors which shall included for periodically reports to a own Catalogue Create a new Measurement System Catalogue and create Links to the respective Sensors or Loggers NOTICE If the Monthly Report is not available in DEMASdb you must activate the Device Monthly Report at the Devicemanager 7 4 2 Middle Values per Week With this menuentry it is possible to export measurement values from Sensors which are middled during a week to an ASCII File To start the export please select the menuentry Write measurement values Middle Values per Week in the Context Menu of a Sensor Logger Measurement System Catalogue or in the Retrieval Object In the dialog which is shown below you can set the settings for the data export e Rangelimits Please insert here the rangelimit which contains the exporting measurement values Only middle values will create for weeks which lays complete inside the Rangelimits For the right rangelimit the actual date is default The left rangelimit gets the value of the right rangelimit of the last data export by d
126. value before exists 4 the value befor is higher than the actual value Properties of EC TDS Information Properties Calculation Events Security Type of Calculation Aye BawTooth Calculations Description atasources Name Sourceobject x 202 EC Parent Calculation function Sawtooth Page Calcualtion In order to use this function you had to select in the Type of Calcualtion the entry Sawtooth This calcualtion mehtod do not use any other configuration therefore the area below was empty 7 3 4 Organization 7 3 4 1 Calculation Manager The parent object for all evaluation functions ist the calculation manager Therefore only one can exist and can not delete Below the calculation manager it is able to create any evaluation functions and Formular Collection 7 3 4 2 Formular Collection With the Formular Collection it is able to create Calculation Functions arranged by themes Formular Collections can contain each evaluation method as child 78 Measurementsystem 79 object It is also possible to casscade the funtions in any depth Therefore it is possible to create a conversion of untits by using templates A conversion for different untis can looks like m mm inch m 7 4 Reports It is able to create Reports for each Object in the measurement system All Objects which are located below the starting object will included into the report If a report is started from the Cont
127. values if no Sensor with the respective Serial and Channelnumber exists Context Menu With the selection of Chart or List in the Context Menu it is able to show the measurement values of the Sensors below in MGMDS or MLDMS In order to generate a Report for all subordinated Sensors please select the menuentry Write measurement values The Property Page You will find the settings for automatically configuration of Sensors on the Property page when you select the dialog at the Objectproperties Here you can set which kind of Objects shall create and how to name it during the import Information Properties Security Created Sensor Simple Day Block Sensor Sensomame fn 4s c Serialnumber fanosas The properties of the Logger Object e Serialnumber Serialnumber of the Logger e Created Sensor Which kind of Sensor shall save the measurement values e Sensorname The inputs in the field Sensorname makes it possible to control the naming of automatically created Sensors This is able with templates where you can also use wildcards for a certain value The wildcards will replace with the values during the import 86 Measurementsystem 87 7 9 The Sensors Sensor Objects in DEMASdb save the measurement values to a real existing Sensor to the Database This measurement values can show and evaluate with the Modules MGMDS MLMDS and export it to Reports for later output The latest measurement value of a Sensor can also di
128. xec responsible Remote Tool appears Preview Type of representation Simple iiled Fitting mB c Gentere A Delete j The Icon Toolbutton e Icon On the page Icon at the Objectproperties it is able to configure the picture which is shown on the button e Preview Display a preview of the picture e Type of representation Only Fitting is available The picture is always adjust to the button size e Search Bitmap Delete With a click to the button Search Bitmap a open dialog will shown where it is able to select any bmp or jpg picture Press Delete if no picture shall display 5 3 5 2 The Toolbox Into the Toolbox it is able to collect Exec Tools and Remote Tools which are configured for Actions The Toolbox is located below the Exec Toolbar 5 3 5 3 The EXEC Tool In the Exec Tool it is able to configure actions for executing external programs which are store in the Toolbox This action can be common or object based Because of common actions only the named program will execute The operation takes place if the menu entry Start Program in the Context Menu is selected or by a mouse click on the linked Tool Button For object based actions a command for the Object of DEMASdb will execute first Than the external 45 Desktop 46 application About this the requested Object have to drag per Drag amp Drop Command Copy Contents on to the Exec or on the Tool Button Context Menu The Menu Entr
129. y Start Program execute the external application Properties On the Properties page in the Objectproperties it is possible to set the command for the executed action and for the external application Actionname co PYTOCLIPBOARD Applicationpath je WINNTSNOTEPAD EXE Parameter The Properties of the EXEC Tool Actionsname Shows the name of the command which shall execute the object based action Remains the field free only the external application will execute For further information please look at the Objecttyp Remote Tool Applicationpath Set up the path for the specified application which shall start Insert the entire path Parameter Please set in this field the command line options which are necessary for the executing application Access Rights Only user who have the accessright Show Contents can execute actions 46 Desktop 47 5 3 5 4 The Remote Tool With the help of the Remote Tool it is able to configure object based actions It will create inside the Toolbox For object based actions a command will execute for the Object Drag the respective Object per Drag amp Drop command Copy Contents on the Exec Tool or on the Tool Button In the Properties page at the Objectproperties it is possible to set the command for the executed action Actionname SHOW The Properties of the REMOTE Tool Commands are simple actions which can execute by an object Depending upon the kind of Objecttype several Actions
130. you select the first entry the first week of the evaluating month begins on the day which is selected at First day of week The days of this month which stay before the first day will not report If you choose the second entry the setting First day of week will ignored 79 Measurementsystem 80 The first day of week of the month will always begin on the 1st of month and takes seven days The third entry means that the first week of the month is shorter than all following weeks Calculating of weekly and monthly average Here you can set how to calculate the averages of week or month e arithmetic average The average per week is the arithmetic average of all measurement values of a week the average per month is the arithmetic average of all measurement values of a month e geometric Average The average per week is the geometric average of all measurement values of a week the average per month is the geometric average of all measurement values of a month e arithmetic average of the n th day of week The average per week is calculated as average value from all measurement values of a certain day of week All measurements from all other days will ignored The monthly average is calculated from the arithmetic average of all values per week e interpolated value of n th day per week at a specified time The average per week is the measurement value on a specified day per week at a certain time Are no measurement value measured on this

DEMASdb

Contents

Download Pdf Manuals

Related Search

Related Contents