
12
Data Retrieval, Processing and Final Storage in the Lake Victoria Basin Database
~ Periodic automatic measurement of
hydro-meteorologic paremeters
~ pre-processing and storage in the
datalogger’s RAM
~ Campbell Scientific Datalogger
Operating System (OS)
~ METSTAT or HYDROSTN
datalogger program
Transfer of accumulated measurements
from logger’s RAM to portable SM192
Storage Module; each single transfer
exercise results in a separate data file
Datalogger + SM192
Storage Module +
CR10KD Keyboard
Display
~ Campbell Scientific Datalogger
Operating System (OS)
~ METSTAT or HYDROSTN
datalogger program
- Connect SM192 to datalogger
- Type in proper keyboard
commands
The user can choose between
automatic or manually invoked data
transfer
Transfer of data files from SM192
Storage Module to PC
SM192 Storage
Module + SC532
Interface + PC
StgModule component of
PC208W datalogger support
software
- Connect SM192 to SC532
- Activate StgModule Software
- Establish connection between PC
and SM192
- Invoke data transfer
Separating and/or rearranging individual
hydro-meteorological parameters from a
complete, original data file
Report (Split) component of
PC208W datalogger support
software
- Activate Report software
- Open a ppropriate pre-defined
parameter file
- Select input data file
- Run Split
- First, visual data quality check
Exporting separated/rearranged hydro-
meteorological parameters to comma
separated ASCII file
Report (Split) component of
PC208W datalogger support
software
- Activate Report software
- Open appropriate pre-defined
paremeter file
- Select input data file
- Select and define output data file
- Run Split
~ Importing comma separated ASCII
file into MS Access and restructuring
data to LVBD format
~ Initial (automatic) quality control
MS Access
(predefined tables and query)
- Activate MS Access
- Open appropriate database file
- Import ASCII file in predefined
table
- Activate predefined query to
restructure data format
Final Storage in the LVBD
MS Access
(predefined tables, LVBD)
- Copy contents of above mentioned
query results to the clip board
- Open appropriate LVBD file
- Open appropriate table
- Add data using paste -append
Further quality control of newly added
data
- Open appropriate LVBD file
- Open appropriate table
- Run pre-defined data-quality-
control queries
Back-up and data dissemination
Windows Explorer
CD -Write software
E-mail software
The various user actions involved in
this step will be discussed and
elaborated in a separate document.
Table 1: Comprehensive Data Trajectory
Detailed Outline of Data Trajectory
Comentarios a estos manuales