Campbell SM4M Datový list

Entebbe October 2001Data Retrieval, Processing and Final Storage into the Nile Basin DatabaseManualNILE B ASIN I NITI ATIVEInitia tive du Bassi n du N

10Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseIntroductionlocation of the concerned files on the PC’s hard disk drive.Chapt

11ManualDetailed Outline of Data Trajectory2.1 GeneralThis chapter gives an overview of the complete data trajectory, starting from values measured b

12Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseDetailed Outline of Data Trajectorythereafter to transfer/upload the raw data

13ManualDetailed Outline of Data TrajectoryThe datalogger works under a specific Campbell Scientific operating system and is controlled by the METST

14Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseDetailed Outline of Data TrajectoryStep Operation Hardware Involved Software

15Manual3.1 Installation of SC532A InterfaceProvided a PC has already been set up successfully, only one hardware item remains to be installed: the S

16Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseRecommended Directory Structure4.1 GeneralFor standardization and instructio

17ManualRecommended Directory Structure*For the creation of the various folders, use the appropriate Windows Explorer commands.4.3 MS Access Database

18Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseRecommended Directory Structure

19ManualPC208W Datalogger Support Software5.1 IntroductionPC208W Datalogger Support Software is a Windows based software package specifically de

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

20Data Retrieval, Processing and Final Storage in the Nile Basin DatabasePC208W Datalogger Support SoftwareThe following toolbar appears:Step A4: Clic

21ManualPC208W Datalogger Support SoftwareStep A7: Select the COM Port settings corresponding to the serial port used by the “9 to 9 pin” computer cab

22Data Retrieval, Processing and Final Storage in the Nile Basin DatabasePC208W Datalogger Support SoftwarePC and Storage Module are now connected. Th

23ManualPC208W Datalogger Support SoftwareStep B4: Mark the “Auto Increment Name” option in the Auto Name Control select box. Each retrieved data file

24Data Retrieval, Processing and Final Storage in the Nile Basin DatabasePC208W Datalogger Support SoftwareIf the user has opted for the Recommended D

25ManualPC208W Datalogger Support SoftwareDump Pointer: The Dump Pointer is an internal pointer used for keeping track of the current ‘start-of-dump’

26Data Retrieval, Processing and Final Storage in the Nile Basin DatabasePC208W Datalogger Support Software5.2.6 Trouble ShootingProblem 1: SM4M do

27ManualPC208W Datalogger Support SoftwareDue to the logger’s memory configuration, all four groups of data time series are written to the same storag

28Data Retrieval, Processing and Final Storage in the Nile Basin DatabasePC208W Datalogger Support SoftwareStep C2: Choose Open from the File menu to

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

3ManualTable of ContentsTable of Contents1 Introduction 91.1 General 91.2 Overview of the Contents of the Manu

30Data Retrieval, Processing and Final Storage in the Nile Basin DatabasePC208W Datalogger Support SoftwareStep C5: Switch to the Output File sub-wind

31ManualPC208W Datalogger Support SoftwareStep C6: In the File Name text box of the Selected Output File sub-screen, type in the name of the appropria

32Data Retrieval, Processing and Final Storage in the Nile Basin DatabasePC208W Datalogger Support SoftwareFor each five-minute interval in which

33ManualPC208W Datalogger Support SoftwareThis concludes the user activities in Report with respect to the extraction of 5-minute rainfall time series

34Data Retrieval, Processing and Final Storage in the Nile Basin DatabasePC208W Datalogger Support SoftwareStep C7: Complete the routine by selecting

35ManualPC208W Datalogger Support SoftwareFor each full hour the Met station has been operational, the following hourly meteorological data are extrac

36Data Retrieval, Processing and Final Storage in the Nile Basin DatabasePC208W Datalogger Support SoftwareStep C7: Complete the routine by selecting

37ManualPC208W Datalogger Support SoftwareFor each day the Met station has been operational, the following daily meteorological data are e

38Data Retrieval, Processing and Final Storage in the Nile Basin DatabasePC208W Datalogger Support SoftwareThere is no need to archive the output file

39ManualData Processing in MS Access and Final Storage into the NBD6.1 GeneralFinal destination of the meteorological data obtained from the

4Data Retrieval, Processing and Final Storage in the Nile Basin Database 5.3.2 Processing Data from Met Station 5.3.2.1 General 5.3.2.2 Fiv

40Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseData Processing in MS Access and Final Storage into the NBDThis database fi

41ManualData Processing in MS Access and Final Storage into the NBDthe actions for importing ASCII text file “metdayXX.txt” into MS Access are equival

42Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseData Processing in MS Access and Final Storage into the NBDIn the above scree

43ManualData Processing in MS Access and Final Storage into the NBDStep D5: Close Meteo_Hourly table.The auxiliary Meteo_Hourly table is now empty. No

44Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseData Processing in MS Access and Final Storage into the NBDStep D8: Click Imp

45ManualData Processing in MS Access and Final Storage into the NBDThe Report output files are comma-separated and thus fall into the category ‘delimi

46Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseData Processing in MS Access and Final Storage into the NBDStep D11: Check

47ManualData Processing in MS Access and Final Storage into the NBDThis step concludes description of procedures for transfer of the contents of the R

48Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseData Processing in MS Access and Final Storage into the NBDTable 4 presents t

49ManualData Processing in MS Access and Final Storage into the NBDStep D14: Click Yes.A message box similar to the one below follows.Step D15: Click

5ManualFigure 1: Hardware components involved in data acquisition process 11Figure 2: Software components and file formats involved in data acq

50Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseData Processing in MS Access and Final Storage into the NBDThe following scre

51ManualData Processing in MS Access and Final Storage into the NBD6.5 Transfer of Raw Input and Report Output Data Files to Backup FolderOnce the me

52Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseExchange of NBD Data with other users7.1 Problem DescriptionThe user may occ

53ManualExchange of NBD Data with other usersA small window called “New Query”, will pop up on the screen with the default option “Design View” automa

54Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseThe view shown above is called “Query 1: Select Query”. It is in this view wh

55ManualStep E7: Select “Datasheet View” under “View” of the MS Access main menu to see if the query is selecting prop-erly the desired data records;

56Data Retrieval, Processing and Final Storage in the Nile Basin Databaseselected data from any main database file/table into the newly created file a

57ManualAnnex 1: Consecutive Steps in Connecting Storage Module SM4M/SM192 to PC.Annex 2: Consecutive Steps in Retrieving Raw Data Files form SM4M/S

58Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseAnnexesAnnex 1: Consecutive Steps in Connecting Storage Module SM4M/SM192 to

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

6Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseList of TablesTable 1: Comprehensive Data Trajectory 14Table 2:

60Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseAnnexesAnnex 5: General Design of the Append Queries for Final Processing of

61ManualAnnexesAnnex 6: Design of the ID Converter TableThe ID Converter table serves to transfer the datalogger IDs to official station identifiers.

7ManualAnnexesAnnexesAnnex 1: Consecutive Steps in Connecting Storage Module SM4M/SM192 to PC.Annex 2: Consecutive Steps in Retrieving Raw Data File

8Data Retrieval, Processing and Final Storage in the Nile Basin DatabaseFAO regional project GCP/INT/752/ITA – Nile Basin Water Resources is committed

9Manual1.1 GeneralThe adopted Monitoring Network in the Nile Basin comprises of Automatic Hydrological and Meteorological Stations equipped with elec