Datasheet

39
Manual
Data Processing in MS Access and Final Storage into the NBD
6.1 General
Final destination of the meteorological data obtained from the Automatic Weather Stations in The Nile Basin
Monitoring Network is the NBD: The Nile Basin Database developed in MS Access. But prior to reaching the final step
of adding newly observed data to this database, one more intermediate operation has to be performed: importing the
ASCII files generated by Report (as described in chapter 5 of this Manual) into MS Access and restructuring them
into a final NBD format.
Figure 5 shows the remaining part of the data trajectory, i.e. the preprocessing actions in MS Access.
Final Processing in MS Access and Final
Storage into the NBD
Import an ASCII text file,
generated by “Report” utility in
chapter 5, into auxiliary table
“NBD_PreProcessing” in MS
Access database
Run pre-defined MS Access query
for final data processing
The results are automatically
stored into the final NBD data
table in standard format
Move raw input and preprocessed
output data files (with file
extensions “dat” & “txt”) into the
Backup sub
-
folder for temporary
storage
Figure 5: Final data processing steps in MS Access and subsequent removal and storage of raw files as backups.
The following paragraphs will present the detailed instructions for performing the tasks indicated in the above
figure.
6.2 MS Access Database “NBD_NEW DATA”
The remaining data processing activities are carried out in an MS Access database file called “NBD_PreProcessing.
mdb”. The users will find this file in one of the following folders (given with full path name), depending on the country
and this file structure is required to be kept unchanged at all times:
• UsersinKenya: C:\MyDbase\NBDNEWDATA\KenyaPreprocessing
• UsersinRwanda: C:\MyDbase\NBDNEWDATA\RwandaPreprocessing
• UsersinUganda: C:\MyDbase\NBDNEWDATA\UgandaPreprocessing