Campbell PC208W Manuel d'utilisateur

Entebbe August, 1998Retrieval, Processing and Final Storage in the LVBD of Hydrometeorological Data from the Lake Victoria Monitoring Network ManualNI

10Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseDetailed Outline of Data TrajectoryThe datalogger works under a spec

11ManualDetailed Outline of Data TrajectoryCampbell Scientific for communication between datalogger and PC. It consists of 8 modules of which only two

12Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseStep Operation Hardware Involved Software Involved User Action 1 ~

13Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseHardware and Software Installation3.1 Installation of SC532 Interfa

14ManualRecommended Directory Structure4.1 GeneralFor standardization and instruction purposes, this chapter proposes a Recommended Directory Structu

15Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseRecommended Directory StructureFor the creation of the various folde

16ManualRecommended Directory Structure

17Data Retrieval, Processing and Final Storage in the Lake Victoria Basin Database5.1 IntroductionPC208W Datalogger Support Software is a Window

18ManualPC208W Datalogger Support Softwareare found, named CSM1/MCR1, SM192/SM716 and PCCard, each dealing with a different storage medium. Since the

19Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabasePC208W Datalogger Support SoftwareStep A7: Select the COM Port

The designations employed and the presentation of material throughout this book do not imply the expression of any opinion whatsoever on the part of t

20ManualPC208W Datalogger Support SoftwarePC and Storage Module are now connected. The user can proceed with retrieving data files or other SM192 rela

21Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseStep B4: Mark the “Auto Increment Name” option in the Auto Name Cont

22ManualIf the user has opted for the Recommended Directory Structure (see paragraph 4.2), data files captured from the SM192 should be stored in the

23Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabasePC208W Datalogger Support Software This option is used to re-do

24ManualPC208W Datalogger Support SoftwareThe Erase Control box contains three different options, each having self-explanatory names. Since it is advi

25Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabasePC208W Datalogger Support SoftwareStep C2: Choose Open from the File

26ManualPC208W Datalogger Support SoftwareStep C3: Navigate to the location on hard drive which contains the parameter files. This is “C:\CAMPBELL\FIL

27Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabasePC208W Datalogger Support SoftwareStep C5: Switch to the Output File

28ManualPC208W Datalogger Support SoftwareStep C6: Select location for, and give a name to, the resulting Output file. To this end click “Browse” in t

29Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabasePC208W Datalogger Support SoftwareFor every hour, the following info

3ManualI Introduction 71.1 General 71.2 Overview of the Contents of the Manual 71.3 Manual Version

30ManualPC208W Datalogger Support SoftwareThis concludes the user activities in Report with respect to the hourly hydrograph information.For ease of r

31Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabasePC208W Datalogger Support SoftwareFor every day the Hydro Station

32ManualPC208W Datalogger Support SoftwareThis concludes the user activities in Report with respect to the Summarized Daily Water Level information.5.

33Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabasePC208W Datalogger Support Software5.3.3.2 HyetographOnly in case of

34ManualPC208W Datalogger Support SoftwareFor every five minutes interval for which rainfall is recorded, the following information is generated: stat

35Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabasePC208W Datalogger Support SoftwareThis concludes the user activities

36ManualPC208W Datalogger Support SoftwareFor every full hour the Met Station has been operational, the following information is generated: station-ID

37Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseThis concludes the user activities in Report with respect to the hou

38ManualPC208W Datalogger Support SoftwareStep C7: Complete the routine by selecting Go from the Run menu. The results, as presented on screen, are si

39Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabasePC208W Datalogger Support SoftwareFor every day the Met Station has

4Data Retrieval, Processing and Final Storage in the Lake Victoria Basin Database 5.3.2.1 General 5.3.2.2 Hourly Hydrograph 5.3.2.3 Summa

40ManualProcessing in MS Access and Final Storage into the LVBD6.1 GeneralFinal destination of the hydro-meteorological data obtained from th

41Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseProcessing in MS Access and Final Storage into the LVBD6.2 MS Acces

42ManualProcessing in MS Access and Final Storage into the LVBDThe individual database items in a particular object class are subject to similar final

43Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseProcessing in MS Access and Final Storage into the LVBDIn the above

44ManualProcessing in MS Access and Final Storage into the LVBDStep D5: Close MetHour.The auxiliary MetHour table is now empty. No data duplication wi

45Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseProcessing in MS Access and Final Storage into the LVBDStep D7: In

46ManualStep D8: Click Import.The following Text Import Wizard pops up.The Report output files are comma-separated and thus fall into the category ‘de

47Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseStep D10: Select ‘comma’ and click ‘Next’. The subsequent window is

48Manualtable. If no importing errors are encountered, the Text Import Wizard finishes the process by presenting the following message.Step D12: Click

49Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseFor ease of reference, all steps discussed in this paragraph are aga

5ManualList of FiguresFigure 1: Hardware Components Involved in Data Acquisition Process 9Figure 2: Software Components and File Formats Involv

50ManualProcessing in MS Access and Final Storage into the LVBDContinue the data processing exercise by performing step 13.Step D13: Finalize data pro

51Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseProcessing in MS Access and Final Storage into the LVBDIn order to v

52ManualProcessing in MS Access and Final Storage into the LVBD6.5 Appending the fully processed new data set to LVBDData processing has been finalize

53Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseProcessing in MS Access and Final Storage into the LVBDIn order to

54ManualProcessing in MS Access and Final Storage into the LVBDStep D21: Click Yes.Depending on the type and origin of the copied data, a desti

55Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseProcessing in MS Access and Final Storage into the LVBDStep D25: Cli

56ManualProcessing in MS Access and Final Storage into the LVBDObviously, the append exercise for the other source and destination objects in table 6

57Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseAnnexesAnnex 1: Consecutive Steps in Connecting Storage Module SM4M/

58ManualAnnexesAnnex 3: Consecutive Steps in Processing Raw Data Files in Report.StepC1C2C3C4C5C6C7ActionActivate Report by clicking the Report tab on

59Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseAnnex 4: Consecutive Steps in Final Processing of Report Output File

6Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseAnnexesAnnex 1: Consecutive Steps in Connecting Storage Module SM192

60ManualAnnexesAnnex 5: General Design of the Append Queries for Final Processing of the Report Output Files in MS Access.The function of the pre-

61Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseAnnex 6: Design of the ID Converter TableThe ID Converter table serv

7ManualIntroductionIntroduction1.1 GeneralThe Lake Victoria Monitoring Network comprises of Automatic Hydro-meteorological Stations equippe

8Data Retrieval, Processing and Final Storage in the Lake Victoria Basin DatabaseIntroductionChapter 3 focuses on the instructions for installing the

9ManualDetailed Outline of Data Trajectory2.1 GeneralThis chapter gives an overview of the complete track a measurement value has to go from sensor t