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
Dayfile.txt Column Headers - Where Are They?
-
- Posts: 51
- Joined: Mon 13 Jan 2014 4:20 am
- Weather Station: Davis Vue Pro 2 #6163
- Operating System: Windows 10
- Location: Tigard, OR
- Contact:
Dayfile.txt Column Headers - Where Are They?
Hi,
It is easy as cake to put Dayfile.txt into Excel, but how do you capture the column headers and paste them into the first row?
Thank you,
Phil
It is easy as cake to put Dayfile.txt into Excel, but how do you capture the column headers and paste them into the first row?
Thank you,
Phil
-
- Posts: 18
- Joined: Wed 19 May 2010 5:02 pm
- Weather Station: Davis Vantage Vue
- Operating System: Windows 10
- Location: Nova Paka, Czech Republic, Central Europe
- Contact:
Re: Dayfile.txt Column Headers - Where Are They?
Hi Phil,
the column headers are in the file cumulus\dayfileheader.txt in the Cumulus program installed on your computer
Milos
the column headers are in the file cumulus\dayfileheader.txt in the Cumulus program installed on your computer
Milos
Milos Jirik, OK5AW
Weather Nova Paka, Czech Rep.
Weather Nova Paka, Czech Rep.
-
- Posts: 51
- Joined: Mon 13 Jan 2014 4:20 am
- Weather Station: Davis Vue Pro 2 #6163
- Operating System: Windows 10
- Location: Tigard, OR
- Contact:
Re: Dayfile.txt Column Headers - Where Are They?
Hi Milos,
So close it could have bit me!!! Already parsed and into the top of my SS! Wonderful!!!
There really isn't any magic in all this, the only mystery is finding the obvious!!
CUMULUS is a wonderful tool because of all the user community!
Thank you very much!
Phil
So close it could have bit me!!! Already parsed and into the top of my SS! Wonderful!!!
There really isn't any magic in all this, the only mystery is finding the obvious!!
CUMULUS is a wonderful tool because of all the user community!
Thank you very much!
Phil
-
- Posts: 51
- Joined: Mon 13 Jan 2014 4:20 am
- Weather Station: Davis Vue Pro 2 #6163
- Operating System: Windows 10
- Location: Tigard, OR
- Contact:
Re: Dayfile.txt Parsing the Date Field Now
Follow-up On Dayfile.txt Date Field,
Anybody have an Excel function to parse the dd/mm/yy to yyyy/mm/dd? The "Data to Columns" function is having problems.
Excel has problems when the text strings vary in width, meaning that a single date value 1-9 gets flipped and mixed with month.
Here is a simple reformatting of the field using Excel. Note what happens when we transition from Jan to Feb.
Thank you!
Phil
Date (dd/mm/yy)
01/10/2014
01/11/2014
01/12/2014
13/01/14
14/01/14
15/01/14
16/01/14
17/01/14
18/01/14
19/01/14
20/01/14
21/01/14
22/01/14
23/01/14
24/01/14
25/01/14
26/01/14
27/01/14
28/01/14
29/01/14
30/01/14
31/01/14
02/01/2014
02/02/2014
02/03/2014
02/04/2014
02/05/2014
02/06/2014
02/07/2014
02/08/2014
02/09/2014
02/10/2014
02/11/2014
02/12/2014
Anybody have an Excel function to parse the dd/mm/yy to yyyy/mm/dd? The "Data to Columns" function is having problems.
Excel has problems when the text strings vary in width, meaning that a single date value 1-9 gets flipped and mixed with month.
Here is a simple reformatting of the field using Excel. Note what happens when we transition from Jan to Feb.
Thank you!
Phil
Date (dd/mm/yy)
01/10/2014
01/11/2014
01/12/2014
13/01/14
14/01/14
15/01/14
16/01/14
17/01/14
18/01/14
19/01/14
20/01/14
21/01/14
22/01/14
23/01/14
24/01/14
25/01/14
26/01/14
27/01/14
28/01/14
29/01/14
30/01/14
31/01/14
02/01/2014
02/02/2014
02/03/2014
02/04/2014
02/05/2014
02/06/2014
02/07/2014
02/08/2014
02/09/2014
02/10/2014
02/11/2014
02/12/2014
- steve
- Cumulus Author
- Posts: 26701
- Joined: Mon 02 Jun 2008 6:49 pm
- Weather Station: None
- Operating System: None
- Location: Vienne, France
- Contact:
Re: Dayfile.txt Column Headers - Where Are They?
When you import a CSV file into Excel, I thought that you could specify how to import a date column, so you could tell it that date format was dd/mm/yy, and that there would therefore be no confusion?
Steve
-
- Posts: 51
- Joined: Mon 13 Jan 2014 4:20 am
- Weather Station: Davis Vue Pro 2 #6163
- Operating System: Windows 10
- Location: Tigard, OR
- Contact:
Re: Dayfile.txt Column Headers - Where Are They?
Steve,
That will teach me to copy and paste. Worked perfectly!
Sometimes the obvious isn't.
Thank you!
Phil
That will teach me to copy and paste. Worked perfectly!
Sometimes the obvious isn't.
Thank you!
Phil
-
- Posts: 51
- Joined: Mon 13 Jan 2014 4:20 am
- Weather Station: Davis Vue Pro 2 #6163
- Operating System: Windows 10
- Location: Tigard, OR
- Contact:
Re: Dayfile.txt Column Headers - Where Are They?
Steve,
Thanks again. A pivot table can provide some really nifty analysis of your wonderful datasets.
Great software product.
Phil
Thanks again. A pivot table can provide some really nifty analysis of your wonderful datasets.
Great software product.
Phil
-
- Posts: 884
- Joined: Sat 16 Jul 2016 11:59 pm
- Weather Station: Davis VP2+ & GW1000 (Standalone)
- Operating System: Win10 Pro / rPi Buster
- Location: Australia
Re: Dayfile.txt Column Headers - Where Are They?
I notice the header files are not present in MX. Are they exactly the same as the final version of Cumulus 1?milos.jirik wrote:Hi Phil,
the column headers are in the file cumulus\dayfileheader.txt in the Cumulus program installed on your computer
Milos
Also if they were delimited with commas like the data files they could be easily copied and pasted.
With regards to adding the headers to the data files themselves, I presume that would require more programming effort than it's worth, or they would already be there?
Phil.
:Now: :Today/Yesterday:
Main Station Davis VP2+ Running Via Win10 Pro.
Secondary Stations, Ecowitt HP2551/GW1000 Via rPi 3 & 4 Running Buster GUI.
:Local Inverell Ecowitt Station: :Remote Ashford Ecowitt Station:
Main Station Davis VP2+ Running Via Win10 Pro.
Secondary Stations, Ecowitt HP2551/GW1000 Via rPi 3 & 4 Running Buster GUI.
:Local Inverell Ecowitt Station: :Remote Ashford Ecowitt Station:
- steve
- Cumulus Author
- Posts: 26701
- Joined: Mon 02 Jun 2008 6:49 pm
- Weather Station: None
- Operating System: None
- Location: Vienne, France
- Contact:
Re: Dayfile.txt Column Headers - Where Are They?
Yes.Phil23 wrote:I notice the header files are not present in MX. Are they exactly the same as the final version of Cumulus 1?
There was a reason for the space delimiters, but I can't remember what it was. Probably to avoid the issues caused by decimal commas and semicolon separators.Also if they were delimited with commas like the data files they could be easily copied and pasted.
It would introduce scope for things to go wrong, particularly when the files were manually edited, and thus increasing the amount of time I and others spend on the forum sorting out issues.With regards to adding the headers to the data files themselves, I presume that would require more programming effort than it's worth, or they would already be there?
Steve
-
- Posts: 51
- Joined: Mon 13 Jan 2014 4:20 am
- Weather Station: Davis Vue Pro 2 #6163
- Operating System: Windows 10
- Location: Tigard, OR
- Contact:
Re: Dayfile.txt Column Headers - Where Are They?
Hi Steve,
Understand. We want to avoid a cascade failure from a single change. I should be able to work with the existing formats.
Separately, Windows 10 supports a CUMULUS reboot in the Start folder! Windows 7 didn't on my machine. They have been pushing Windows 10 updates like crazy the past month.
I do notice however a higher frequency of NULL records in the DAYFILES. Your red Error indicator is very helpful and Notepad++ is a clean way to handle large files. I am not sure what is causing the NULL records. It may well be the Windows 10 push to shutdown/restart is causing a CUMULUS "panic write" to DAYFILES? I think I will change Windows 10 back to manual restart for updates like I did for Windows 7.
All the best!
Phil
Understand. We want to avoid a cascade failure from a single change. I should be able to work with the existing formats.
Separately, Windows 10 supports a CUMULUS reboot in the Start folder! Windows 7 didn't on my machine. They have been pushing Windows 10 updates like crazy the past month.
I do notice however a higher frequency of NULL records in the DAYFILES. Your red Error indicator is very helpful and Notepad++ is a clean way to handle large files. I am not sure what is causing the NULL records. It may well be the Windows 10 push to shutdown/restart is causing a CUMULUS "panic write" to DAYFILES? I think I will change Windows 10 back to manual restart for updates like I did for Windows 7.
All the best!
Phil
-
- Posts: 23
- Joined: Fri 07 Mar 2014 7:05 pm
- Weather Station: Davis Vantage Pro 2
- Operating System: Windows 7 Pro 64 bit
- Location: Ashkum, Illinois
Re: Dayfile.txt Column Headers - Where Are They?
Is there any way to use two lines for each header so you can tell what the header actually says? There already is two color lines as the header.