Calculate Missing Values: Difference between revisions

From Cumulus Wiki
Jump to navigationJump to search
m
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style="background: LemonChiffon;padding:5px; margin:2px;">
[[File:Crystal Clear info.png|40px]] This document was written for the (legacy) Cumulus 1 software.  It has been updated to cover MX, but that was for a MX release that is no longer latest!
<big>Mark Crossley has now written a utility (download at https://github.com/cumulusmx/CreateMissing) that can update dayfile.txt.</big>
</div>
=Introduction=
=Introduction=


Line 6: Line 14:




For these, and other reasons, this page explains various ways in which you can edit log files, (and for MX users, database tables) so all lines contain all the fields that can be calulated for the weather station you are using.
For these, and other reasons, this page explains various ways in which you can edit log files, (and for MX users, database tables) so all lines contain all the fields that can be calculated for the weather station you are using.


[[Category:Log Files]]
[[Category:Log Files]]
Line 29: Line 37:
# Current air pressure (absolute or sea-level)
# Current air pressure (absolute or sea-level)


By default [[Cumulus.ini#Read-only_parameters_in_the_Station_section|see here]], Cumulus will stop processing any readings from a weather station unless the above 4 source values are being supplied and reveal they are being updated (failure is set is after a total of 6 unsuccessful consecutive attempts to read each of these).
By default [[Cumulus.ini_(Cumulus_1)#Read-only_parameters_in_the_Station_section|see here]], Cumulus will stop processing any readings from a weather station unless the above 4 source values are being supplied and reveal they are being updated (failure is set is after a total of 6 unsuccessful consecutive attempts to read each of these).


Cumulus also expects that your weather station can provide:
Cumulus also expects that your weather station can provide:
Line 45: Line 53:
* Air pollution measurement
* Air pollution measurement


There are some configuration settings [[Cumulus.ini#Read-Write_parameters_in_the_Station_section|here]] where you can decide whether to use a weather station supplied dewpoint temperature and whether to use a weather station supplied wind chill temperature.
There are some configuration settings [[Cumulus.ini_(Cumulus_1)#Read-Write_parameters_in_the_Station_section|here]] where you can decide whether to use a weather station supplied dewpoint temperature and whether to use a weather station supplied wind chill temperature.


===How Cumulus might transform a Source Value===
===How Cumulus might transform a Source Value===
Line 51: Line 59:
*For some weather data processed by Cumulus the value sent by the weather station and that used by Cumulus will be different:
*For some weather data processed by Cumulus the value sent by the weather station and that used by Cumulus will be different:
** This can be because the units used by the weather station, and the units required by the Cumulus user are different (and Cumulus allows the user to select the units in which values will be stored)
** This can be because the units used by the weather station, and the units required by the Cumulus user are different (and Cumulus allows the user to select the units in which values will be stored)
** This can be because the user has entered some calibration settings. The exact settings available vary for different weather data, but in some cases a second order multiplier is available (the square of the input value is multiplied by the second order multiplier), a first order multiplier is available (the input value is multiplied by the first order multiplier), and an offset is available (added to the input value). If you want to understand how this works, please see [[Cumulus.ini#Offsets]] for the details
** This can be because the user has entered some calibration settings. The exact settings available vary for different weather data, but in some cases a second order multiplier is available (the square of the input value is multiplied by the second order multiplier), a first order multiplier is available (the input value is multiplied by the first order multiplier), and an offset is available (added to the input value). If you want to understand how this works, please see [[Cumulus.ini_(Cumulus_1)#Offsets]] for the details
**A weather station might use a rainfall counter, Cumulus converts it to a rainfall rate (based on difference between two counter readings scaled up to represent amount per hour)
**A weather station might use a rainfall counter, Cumulus converts it to a rainfall rate (based on difference between two counter readings scaled up to represent amount per hour)


Line 149: Line 157:


=Missing fields (or missing lines) in dayfile.txt=
=Missing fields (or missing lines) in dayfile.txt=
'''Please see note at top of page, for a utility that works with MX log files, and updates dayfile.txt'''


==Missing or Corrupted lines==
==Missing or Corrupted lines==
Line 231: Line 241:
===Correcting individual fields in multiple lines of Daily Summary Log in Cumulus MX===
===Correcting individual fields in multiple lines of Daily Summary Log in Cumulus MX===


The only method, available at the time of writing, involves using database functionality and multiple steps:
 
 
'''This section was written before Mark Crossley released the utility that works with MX log files, and updates dayfile.txt, that can be downloaded from https://github.com/cumulusmx/CreateMissing.'''
 
 
Without that utility, the only method, involves using database functionality and multiple steps:
#The first step depends on whether you use the option in MX to create and update database tables...
#The first step depends on whether you use the option in MX to create and update database tables...
#*...If you don't use that option yet, use '''ExportMySQL.exe monthly''' to create a database table called "monthly"  (you can call it another name, but you must have set name in MX, before you run ExportMySQL.exe), and read all the standard logs into that database table,
#*...If you don't use that option yet, use '''ExportMySQL.exe monthly''' to create a database table called "monthly"  (you can call it another name, but you must have set name in MX, before you run ExportMySQL.exe), and read all the standard logs into that database table,
5,838

edits

Navigation menu