Administrator`s manual on the use and management of on
Contents
1. 77 Loo Y TL PS NM pue MM _ Analytical block Status on line and name of IS _ Real load time of interface administrator 0 0566 7 Function Management 1 When clicking on Management a window will be opened to work with IS design and modification algorithms In this window the user can see all main functional blocks IS Information field blocks Functions DB on sectors DB on objects and DB on water resources 2 To return to the data window click on Data Mozilla Firefox 7 http waterdata x php ru admin E3 gt ay 0 A http waterdata uz index php ru admin Or ja 5 egens tral Asie 234 352. A Developing table layout for single type objects falling into one category Meteo stations 1 Choose the created type of objects Meteostations Fill in characteristics that refer to all objects of single type in the opened tab 7 The table layout fields for passport data and values types will be the same for all single type objects Choose type of objects Tabs of object characteristics 0 2 First tab General information was already filled when creating type of objects Then click on tab Passport data Passport data this 1 the description of given object and its technical characteristics 3 Inthe empty field input characteristic describing the object After saving this record is saved and an empty field appears below for input of next characteristic if necessary For example input Year of construction Location Measurement frequency 4 Click on the button Save the field 16 Data Base development for GIZ TWMP component 2 Basins and Irrigation systems G As 2 v 2 Clic
3. 5 Choose type of graph meteo 590098 ett ALL LI m e eom gt i iv Emm 77 0 0051 BASS Des 8 Mozilla Firefox 0 http waterdata uz index php ru data 1 http waterdata ex php ru data E TY New category of DB on object s Meteostations G gum As a i i i 14 7 Data Base development for GIZ TWMP component 2 Basins and Irrigation systems select field Type of object in the pop up list Purp
4. Zip 12 Restore P o 4 Restore 4 twm 34 E 5 A a 34 _ BAD 5 pes arsenald twm 2011 08 15 18 42 sqlu Re 4 Click on X 1 Apply i 5 Choose needed file by tme of its arsenald twr 341 Saving __ 9 Restore arsenald twm 2011 08 15 18 42 sql qz arsenald twm 2011 08 15 18 43 sql qz arsenald twm 2011 08 15 2 2b sgl gz 6 Click on Exit to arsenald twr 2011 10 02 19 25 sdl gz arsenald 2011 10 02 18 57 sql gz return to category gte twm 2011 08 15 16 38 591 92 Functions 6 Return to category is activated by button Bbixog Exit Data Base development for GIZ TWMP component 2 Basins and Irrigation systems Category DB on sectors This category consists of three blocks Territorial division Categories and Sec tors Administrator may change the internal structure of these three blocks depen ding on targets set for construction of hierarchical chain of water management objects and categories 1 Click on respective
5. i I _ DB data interface 12 B Enc Block of management categories Functions DB on sectors DB on objects DB on water resources Category Functions The category is divided into two blocks Users DB backup The administrator has a right to control the list of users assign them different levels of access and remove or register new users 6 Data Base development for GIZ TWMP component 2 Basins and Irrigation systems 1 For switching to adding and deleting of users and for changing their rights click on button Users 1 Click on Users TW MC entral Asia beet Z e O 234 36 Pop up list of users Choose a user from Button to delete a the list user from DB v PWM Cena MEME 7 vane ViTIBXOM d mo Iskandar Abdullaew ida E T ERE iskanda ssaseses Dis
6. Cix ee H 4 i 13 Data Base development for GIZ TWMP component 2 Basins and Irrigation systems Category DB on objects This category is divided into two blocks Categories and Objects Administrator may change the internal structure of these blocks 1 Click on respective button on the left panel in order to switch to the Categories regime 2 In order to create a category of objects choose New type and enter the name of new category parent for example Meteostations thus adding this category to DB structure _ I Switching to Categories regime of DB by object A j b P eee 7 a nee 3 Select field of object in the list _ Purpose no e wee
7. 1 Click on Sectors 12 1 2 From list of categories choose Water quality New new parameter 3 Enter the name of new parameter in the field for example Salinity 4 time interval for information since year to year for example since 2000 to 2011 5 Field Additional column is needed for aggregation of data by months i e to get annual values of given parameter average or total if this field is left unmarked the table will not contain the aggregation column Choose Sum 6 Click on the button Save 511 Data Base development for GIZ TWMP component 2 Basins and Irrigation systems _ 2 Choose category TAA y 3 Enter parameter 1 0 n eee 9999999 77 4 Enter interval c 1986 no 2011 pese aug tm 5 ST 5 Jon New parameter Salinity under subcategory Water quality of the category Ecolo will be added to the interface of DB by sector Y Gc X o http waterdata uz index php ru data j
8. co Data Base development for GIZ TWMP component 2 Basins and Irrigation systems 1 Click on respective button on the left panel in order to switch to Categories regime 234 I Click on Categories 2 add new parameters it is necessary to create corresponding category for example the category Ecology i e block of parameters structured by subject area Choose New category in the list of parameters and enter the name of category in the field Title for instance Ecology 3 Click on the button Save gt 2 Enter the name of new 3 Click on New DB category category Ecology Save Ecology Now new category Ecology is added
9. http waterdata ex php ru data Mozilla Firefox G TWMC A 4 http waterdata uz index php ru data sector 105 i 3 I ees CSV Excel 4 v Vane 2000 0 0 0 0 0 0 0 0 0 0 0 0 0 00 v 2001 0 0 0 0 0 0 0 0 0 0 0 0 0 00 2002 0 0 0 0 0 0 0 0 0 0 0 0 0 00 v 2003 0 0 0 0 0 0 0 0 0 0 0 0 0 00 v 2004 0 0 0 0 0 0 0 0 0 0 0 0 0 00 2005 0 0 0 0 0 0 0 0 0 0 0 0 0 00 v 2006 0 0 0 0 0 0 0 0 0 0 0 0 0 00 iV 2007 0 0 0 0 0 0 0 0 0 0 0 0 0 00 2008 0 0 0 0 0 0 0 0 0 0 0 0 0 00 F 2009 0 0 0 0 0 0 0 0 0 0 0 0 0 00 7 2010 0 0 0 0 0 0 0 0 0 0 0 0 0 00 v 2011 0 0 0 0 0 0 0 0 0 0 0 0 0 00 ic T Geu Eu The number of parameters for each category is unlimited therefore administrator may enter new parameters according to target structure of the developed DB The final structure of categories and their parameters for example in the block Water resources can b
10. average as well 8 Click on Save value types G 66 TWM Centa Asi STENT 5 Click tab i auqueuut Value types RII 8 Click on Save value types 7 Choose calculation method 9 next tab forms layout of tables that will be displayed on interface when selecting parameters of object Choose the tab Table layout af Data Base development for GIZ TWMP component 2 Basins and Irrigation systems G TWMCe Z d 4 xe 11 12 To sol ay click on arrow O O a Mecau no E 7 E mmm 1 7 7 13 Click on Save List of scenarios for laying out the tables 10 Administrator can build a table based on tasks set To this end it is necessary to enter quantity of columns and row
11. f Ten day period Month Year 12 months by ten day q ty of years Epor 1 II 1 1 1 cum year monthi 1 monthi 2 month 3 month1 monthz 1 2000 20 T To finalize the table it is necessary to assign it management characteristics for each of created object under category Meteostations 1 Switch to Objects regime by clicking on respective button on the left panel 2 Choose existing object 1 INAS d CEN v 4 5 a j p 1975 ance 4 Click on Save l 3 Fill the fields of object s technical characteristics 2 Choose an object for example Namangan 3 In earlier created fields input technical information about given object since the layout Month Year was chosen then in the
12. Z 6 uDie104 3 wW Project Transboundary Water Management in the Central Asian Region GIZ TWMP Administrator s manual on the use and management of on line GIZ TWM CA database ii HMELI HO Y lt OIMHEgOEGLIOLIOM OLI 1 dINML 219 oHoMJed uweod oed WWiaHhHHedaoHedi 1 R Federal Foreign Office 7 Project Transboundary Water Management in the Central Asian Region GIZ TWMP Administrator s manual on the use and management of on line GIZ TWM CA database Tashkent October 2011 17 Data Base development for GIZ TWMP component SIC ICWC 2 Basins and Irrigation systems Scientific Information Center of ICWC SIC ICWC Karasu 4 11 Tashkent 100 187 Republic of Uzbekistan Phone 998 71 265 92 95 266 42 01 Fax 998 71 265 27 97 dukh icwc aral uz sda icwc aral uz http sic icwc aral uz Deutsche Gesellschaft fur Internationale Zusammenarbeit GIZ Abdullayeva str 2A Tashkent 100 100 Republic of Uzbekistan Phone 99871 140 04 89 Fax 99871 140 04 45 iskandar abdullaev giz de Prepared by D A Sorokin SIC ICWC Page proof by D Abdurakhmanov SIC ICWC 2 Basins and Irrigation systems 5 1
13. field Add a year type the phrase Long term series contents of this field depends on selected table 590 Data Base development for GIZ TWMP component 2 Basins and Irrigation systems layout and is filled at the discretion of administrator in the field Year of construction 1980 and then follow the cells 4 Click on the button Save 5 view the constructed table click on the button Data in the upper right corner switching to data view interface _ 6 Choose object category L index php ru data Mozilla Firefox http waterdata uz index php ru data obj 75 237 html valueType 8 m parameter mm V e 1 o 7 Choose object a s s 8 s s Technical characteristics of object 1 s 6 Inthe block DB on objects we select type of data Meteostations 7 pop up list of objects select Namangan 8 Inthe window opened in the field Choose interval we choose Long term series 9 Switching of tables on parameters Rainfall Wind speed and Temperature is made by choices in the field of parameters The constructed table is ready for filling Category DB on water systems ae a This analytical block is created and edited by IT Na specialist upon requests of c
14. in the interface of DB on sectors This category can be divided into subcategories 1 Choose New category in the list of parameters 2 Enterthe name of new subcategory in the field Title for example Water quality 3 Inthe section Parent choose category Ecology from the list thus we link given subcategory with the basic parent category 4 Click on the button Save 10 Data Base development for GIZ TWMP component 2 Basins and Irrigation systems no bc L b 4 2 Enter name of new category Water _ _ quality 3 Choose parent category NEN _ Ecology New subcategory Water quality under the category Ecology will be added to the interface of DB by sector This step is not needed if administrator does not intend to create subcategories but does want to start creating the list of parameters immediately 1 In order to add new parameters of categories it is necessary to switch to Sectors regime on the left panel G WMC 234 36
15. 7 Data Base development for GIZ TWMP component SIC ICWC Contents ion Function Category Functions pui Category DB ON Category DB on eDIGCIS Category on water Data Base development for GIZ TWMP component 2 Basins and Irrigation systems Introduction This Manual is designed for administrators of the GIZ TWM Information System and can help changing the DB structure and keeping track of DB operation and management in on line regime This Manual is written on the basis of the User s Guide April 2011 and sup plemented by examples of 15 management and development for individuals who are skilled in DBMS and are the main supporters of trouble free operation of IS at the local level water management divisions Data Base development for GIZ TWMP component 2 Basins and Irrigation systems Log in Every registered user with administrator s rights has his her login and password to access the IS protected zone DB design algorithm in on line regime These rights should be strongly confidential and not be made public in order to avoid unautho rized access to DB algorithms 1 In respective field of any web browser type address of give
16. button on the left panel in order to switch to Territorial division regime 2 Choosean item of territorial division provinces districts and other territorial divisions from the list of existing items or enter name of new one s thus adding it to DB structure 3 After correction of the name or entering new one click on the button Save PUMA s MC G TWMCentrai Asia Z a du T 234 a d 7 36 12 1 Click on Territorial 2 Create new iem of 3 Enter 3 Click on division territorial division or Save aa RE 8 select it from the list for new correction of its name Thus when selecting a parameter in the interface of the Database on sectors the window with data will open Here the user can select needed information according to the chosen territorial division c http waterdata uz index php r A http waterdata ex php ru data List of items of territorial division in DB on sectors in given case districts List of parameters in EL DB On sec t Ors
17. e as follows sd c Data Base development for GIZ TWMP component 2 Basins and Irrigation systems 1 Category Water resources 1 2 Subcategory Water use 1 2 1 Parameter Domestic household 1 2 2 Parameter Irrigation 1 2 3 Parameter Other 1 2 4 Parameter General 1 3 Subcategory Water supply sources 1 3 1 Subcategory Surface water 1 3 1 1 Parameter Canals 1 3 1 2 Parameter Rivers 1 3 1 3 Parameter Heservoirs 1 3 1 4 Parameter Other 1 3 1 5 Parameter General 1 3 2 Subcategory Groundwater 1 3 2 1 Parameter General 324 M ne A 4 d 27 4 Ho bbIT Sd j j b P 4 EM
18. ge 12 months As 1 1 1 1 1 di mornin di eweninc MATH d1l Day Hours Month 31 day 07 00 11 00 15 00 19 00 and average 12 months 1 1 1 7 1119 1 1541 1 19 1 m month di 7h di 11h di 15h di 13h MATH dl E Month Year 12 months q ty of years 4 CT m 1 year month 1 monthz 2000 2000 2001 19 Data Base development for GIZ TWMP component 2 Basins and Irrigation systems e Ten day period Year 12 months by ten day q ty of years Epor 1 I 1 1 E year monthi 1 monthi_2 1 3 monthz _ 2000 2000 c
19. ist Purpose _ ae 4 Choose the required category of To _ objects in the field Parent 777 __ 5 Click on Save 15 Data Base development for GIZ TWMP component 2 Basins and Irrigation systems Repeat these steps if a few objects should be entered For example we add another two objects Fedchenko and Namangan Now when clicking on Categories on the left functions panel one may see the hierarchy of created objects in the list of categories i e the category Meteostations contains such objects as Fergana Fedchenko and Namangan G uw HMM IWMCewa Ass Category Meteostations Papou contains objects Namangan UMK _ Fedchenko and Fergana K no
20. k tab Mu Passport data 2 BAF mM 3 Input the name of object s emt ao VENE b rio cekropaM cekropaM new passport characteristic 4 4 Click on Save the field 9 Switch to the next tab Value types Here the list of value types is created i e for measured parameters Click on Value types 6 Inthe empty field input a value type of given object After saving a new field appears for input of new type if necessary For example add three parameters Rainfall Wind speed and Temperature 7 Inthe pop up list select one of values for cumulative column of the future table Sum or Average i e in the last column the data will be aggregated and computed automatically for selected value of field For example for rainfall sum for wind speed average and for temperature
21. lient water or ney management divisions since this block requires MTB knowledge of PHP programming language MTb HTS MTB Existing first guidelines User s manual will help you operate correctly new DBs and available information 4 Names of given analytical block are different for all pilot basins 21 x 17 Data Base development for GIZ TWMP component SIC ICWC 2 Basins and Irrigation systems For notes 299
22. n resource let s consider Zaravshan IS as an example and type hito waterdata uz 2 Choose Interface language Russian on default 3 Inthe fields Login and Password input administrative data received 4 Click Login Use only Latin alphabet here Mozilla Firefox M 3 http waterdata uz se e LJ Mm loo Enter Internet address Choose Interface language TWM Centra Z HELP kon cas Enter login and password e Available resources that downloaded maps concepts 5 If all fields are filled correctly the IS interface will be opened Then click Management in the upper right corner Data Base development for GIZ TWMP component 2 Basins and Irrigation systems amp Mozilla Firefox FCX http waterdata uz index php ru data 8 P http waterdata ex php ru data B _ Click on functional button _ Management PWM Centra Asis RM roject lt UU uc i
23. ose Type the name of generated table for meteostations for example meteo table names should be in Latin alphabet only In the field Draw graph choose needed option from proposed ones for example Rowwise these graph drawing options for tables are taken from the standard options of MS Excel In the field Sort rows choose desired order list of objects is formed in alphabetical order or on default for example by name Then click on the button Save Hence administrator created and added new type of objects such as Meteo stations in the DB on objects In order to fill this block with a list of single type objects the below steps should be followed 1 Return back to categories of objects by clicking on the button Categories on the left panel of functions 2 Create new type of objects subordinate Type name of object in the field Title for example Fergana 3 Choose Category in the field Purpose and the below fields such as of table and Draw graph will become inactive 4 Inthe field Parent select required record that is Meteostations i e we link our object meteostation Fergana with its category Meteostations 5 Click on the button Save 1 Switching to Categories regime of DB by object 2 Input the name of new object Hopes 3 Choose Category in the l
24. petcher E mail iskandar abdullaev gtz de 2l 2 4 2 T TU 7 P x H E B Field for information about Choosing To confirm changes please click ioh C Save user access 5 On 2 Inthe pop up list the administrator can choose a user from the existing ones or add new one For adding a new user it is necessary to fill in the information field set login and password assign respective rights and click on the button Save 3 For changing information about existing user and or assign another level of access it is necessary to choose this user from the list and make required changes Then click on the button Save The section DB backup allows the administrator to save a copy of the whole DB on the hard disk of his her computer Backup in any moment of time and or upload one of last DB versions on the project server from the hard disk or any other medium Restore This function is similar to the process of independent registration of new users but with assignment of various access rights 2 User view of information Editor cor
25. rection and change of data Administrator full access including possibility to change the DB structure 7 Data Base development for GIZ TWMP component 2 Basins and Irrigation systems 1 When clicking on the button DB backup an information panel is opened for operation with DB file _ I Click on DB backup o a Aj I VVMN ees nC ME ee 234 36 2 file put cursor function Backup name of the file is not changed arsenald twm 34 on default 3 Then from popping up lists choose one of zipping methods BZip2 GZip on default No zipping and degree of zipping from 1 to 9 the higher degree of file zipping the longer time is taken for its backup click on the button Apply 4 For uploading the file put cursor on the function Restore Restore DB from backup 5 Then choose needed file by time of its creation for example arsenald_twm_2011 08 15_18 42 sql gz and click on the button Apply _ 2 Backup 5 Dumper Lite 1 0 8 3 Choose zipping method i S88 pickup E 4 Restore p 5 arsenald twm 341
26. s in the cells Columns and Rows 11 Then click on the arrow key gt gt to display the layout of table 12 For simplified construction of tables the developers provide a mechanism of construction using ready scenarios After selection of one or another scenario click on the arrow key gt gt 13 After selection of scenario or creation of one s own one click on the button Save layout for example let s select the scenario Month Year 14 After saving the model layout the layout of new table will be displayed on the tab If necessary administrator can delete this layout and create new one Days in table s cells are set automatically according to their quantity in each month Reddy table built by scenario Month Year 6 AHDODMALIIMsS MIN p l 4 To delete given table click on Delete table no List of available scenarios and their structure 18 Data Base development for GIZ TWMP component a 2 Basins and Irrigation systems Day Month 31 day 12 moths Asia 1 2 3 1 month di d2 d3 ae v b Day Daypart Month 31 day morning evening and avera
Download Pdf Manuals
Related Search