Hi All,
I've successfully added the pre CMX data I had for this WS (Ecowitt HP2551) sourced from a combination of Ecowitt.net export and the WS SD card CSV data. I used Excel & Notepad++ to perform the required conversion & calculations. Then used Createmissing.exe to create the Dayfiles. I'll share this Excel calculator once I have polished it a bit more.
However I'm now looking at adding the ~16 years of data that I have from my old WS (La Crosse WS3500). This was a very basic WS with no wind, rain or solar data collection. I gather that I can't leave any of the fields blank in the Monthly file. I can see that the wind & solar I can just set to 0 without causing too many problems eg.windchill will just be the same as the outside temp etc. If I set all the rain figures to 0, I guess it will look like the world's longest drought ! I presume that could be avoided from appearing on the records pages if I manually ignore this data for rain when manually editing the all time, yearly, monthly records etc ?
Is there a value that I can put in the monthly files for this wind, rain & solar data that will be ignored by Createmissing & CMX ? Or are zeros the best approach ?
The wiki suggests that Createmissing can calculate some missing derived fields in the monthly file for you but what value do you need to put in to get it to do this ? I couldn't get it to work with empty, space or -9999 etc, but it was useful for creating the dayfiles.
Thanks,
Dave
Welcome to the Cumulus Support forum.
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
Adding Historical Data Without Wind, Rain or Solar
Moderator: mcrossley
- PaulMy
- Posts: 3830
- Joined: Sun 28 Sep 2008 11:54 pm
- Weather Station: Davis VP2 Plus 24-Hour FARS
- Operating System: Windows8 and Windows10
- Location: Komoka, ON Canada
- Contact:
Re: Adding Historical Data Without Wind, Rain or Solar
Hi,
Enjoy,
Paul
CreateMissing is for adding missing fields, or missing days, to the dayfile.txt file. The data must already be in the monthly log file for CreateMissing to add it to dayfile.txt https://cumuluswiki.org/a/Software#Create_MissingThe wiki suggests that Createmissing can calculate some missing derived fields in the monthly file for you
Enjoy,
Paul
Davis Vantage Pro2+
C1 www.komokaweather.com/komokaweather-ca
MX www.komokaweather.com/cumulusmx/index.htm /index.html /index.php
MX www.komokaweather.com/cumulusmxwll/index.htm /index.html /index.php
MX www. komokaweather.com/cumulusmx4/index.htm
C1 www.komokaweather.com/komokaweather-ca
MX www.komokaweather.com/cumulusmx/index.htm /index.html /index.php
MX www.komokaweather.com/cumulusmxwll/index.htm /index.html /index.php
MX www. komokaweather.com/cumulusmx4/index.htm
- mcrossley
- Posts: 12756
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Adding Historical Data Without Wind, Rain or Solar
Create missing assumes that the base data will be there, so the base T/H/W fields cannot be blank, if there is no data then the best you can do is add them as zeros.
Fields beyond 16 can be "null", ie nothing between the commas
See the history of the monthly log file here: https://cumuluswiki.org/a/Standard_log_files
Fields beyond 16 can be "null", ie nothing between the commas
See the history of the monthly log file here: https://cumuluswiki.org/a/Standard_log_files
-
- Posts: 23
- Joined: Fri 01 Apr 2022 10:29 am
- Weather Station: Ecowitt HP2551
- Operating System: Raspberry Pi OS Buster
Re: Adding Historical Data Without Wind, Rain or Solar
Thanks Paul & Mark for the replies, I'll crack on with my approach and start loading the data. It may take a while