Calculate Missing Values: Difference between revisions

From Cumulus Wiki
Jump to navigationJump to search
m
mNo edit summary
Line 157: 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 239: 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