I would like to get rid of all the zeros and spikes to make a clean history.
Just supposing I stop CMX and duplicate the data directory into my old Cumulus setup on Windows. Using select-a-graph I can look at each month and easily see what is wrong. I will be able to use a text editor to cut out great swathes of corrupt history from the logs. I then use the Cumulus editor to fix up the monthly, yearly and alltime summaries. I estimate that 6 months of the past two years need drastic surgery, but I could run over all of them to make sure the monthly files are consistent.
The fly in the ointment is the date format difference in the ini files; the monthly logs are compatible between CMX and C1 - possibly needing a line ending change.
Changing the date format in the ini files is simple, a sed script will do it. Changing back is also not a problem.
After all the files are edited, it is just a matter of copying them back over the original CMX files (NB taking backups first) and restarting CMX.
Can anyone see a flaw in this approach? Are there any other files that need to be changed? (all the ini files in the data directory, and cumulus.ini itself)
ToWindowsDates.sed
Code: Select all
s,([0-9]{4})-([0-9]{2})-([0-9]{2})T,\3/\2/\1 ,g
Code: Select all
s,([0-9]{2})/([0-9]{2})/([0-9]{4}) ,\3-\2-\1T,g
Code: Select all
for %%i in ("*.ini") do (
sed -r -i -f ToWindowsDates.sed %%i
)