Datasheet

E Meteo_Hourly :
Record:
14 I _4_1
Table
1 r
11*1 of 186
Avg-T 1Datalogger-ID Year MM-DD Time
IF
-7)001 9 8 801D
19.13
5
?I:101 9 8 91DCI
21.83
T.'001 9 8 1000
23.47
5
2001 9 8
.11 w
24.85
2001 9
17)00
?5.5?
2 0 0 1 9 8
!=, 2001 9 8
1400
26.91
5
2001
!=.i 8 .151:10
27.5
'7)001 9 8
buu
27.8
!E, 7)001 9 8 .171_11_1
27.55
26.42,
2001 9 8
16uu
T.'001 9E:
1900
24.63
'7)001 9 Ft .7.11:11:11:1
24.08
47
Manual
Data Processing in MS Access and Final Storage into the NBD
This step concludes description of procedures for transfer of the contents of the Report Output file “methrXX.txt”
into the appropriate location in MS Access in preparation for final processing of data.
As already stated at the beginning of this paragraph, the import procedures for “metdayXX.txt” and “metrnXX.txt”
are analog to the procedures presented above for the file “methrXX.txt”. To import these ASCII files into “NBD_Pre
Processing.mdb”, the user is requested to change file and table names where and when necessary.
For easy reference, all steps discussed in this paragraph are again presented, in proper sequence, in Annex 4. This
time however without accompanying comments and illustrations.
6.4 Processing of Imported Data in MS Access and Final Transfer into the NBD
After being imported into an auxiliary table in MS Access, the new data sets are subject to the following processing
and final storage of processed data records into NBD:
two separate text fields containing day, month and year respectively, have to be converted into a single date •
field;
short datalogger ID (due to the logger’s memory configuration limited to a number below 255) has to be •
converted into an official numerical station identifier, for example in case of Hydromet-IDs consisting of 8
digits;
automatic quality control: checking if the data values are within an expected range of variation;•
adding of ‘source’ value: indicating the origin of the data set;•
re-arranging column structure in accordance with the NBD database format.•
final automatic storage of the processed new data records into the appropriate NBD file and table.•
For each data type, all these actions are automatically performed in one go with a pre-defined query. When the
Queries tab is activated in the database view, 3 pre-defined queries appear, as shown in the window below: