Welcome to the Cumulus Support forum.

Latest Cumulus MX release 3.6.10 (build 3086) - 24 June 2020 (please see important announcement regarding releases since 3.5.0)
Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014 (a patch is available for 1.9.4 build 1099 that extends the date range of the NOAA report and Snow Index drop-down menus to 2030)

See the Wiki to download the software or click on the Downloads link in the Forum Banner.

Dayfile.txt Column Headers - Where Are They?

Discussion and questions about Cumulus weather station software version 1. This section is the main place to get help with Cumulus 1 software developed by Steve Loft that ceased development in November 2014.
Post Reply
philbertp2
Posts: 45
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?

Post by philbertp2 »

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
Phil
Tigard, Oregon USA
http://www.climateservices.net

milos.jirik
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?

Post by milos.jirik »

Hi Phil,

the column headers are in the file cumulus\dayfileheader.txt in the Cumulus program installed on your computer

Milos

philbertp2
Posts: 45
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?

Post by philbertp2 »

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
Phil
Tigard, Oregon USA
http://www.climateservices.net

philbertp2
Posts: 45
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

Post by philbertp2 »

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
Phil
Tigard, Oregon USA
http://www.climateservices.net

User avatar
steve
Cumulus Author
Posts: 26704
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?

Post by steve »

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

philbertp2
Posts: 45
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?

Post by philbertp2 »

Steve,

That will teach me to copy and paste. Worked perfectly!
Sometimes the obvious isn't. :roll:

Thank you!
Phil
Phil
Tigard, Oregon USA
http://www.climateservices.net

philbertp2
Posts: 45
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?

Post by philbertp2 »

Steve,

Thanks again. A pivot table can provide some really nifty analysis of your wonderful datasets.
Great software product.

Phil
Phil
Tigard, Oregon USA
http://www.climateservices.net

Phil23
Posts: 495
Joined: Sat 16 Jul 2016 11:59 pm
Weather Station: Davis Vantage Pro2 Plus
Operating System: Win7 Pro
Location: Australia

Re: Dayfile.txt Column Headers - Where Are They?

Post by Phil23 »

milos.jirik wrote:Hi Phil,

the column headers are in the file cumulus\dayfileheader.txt in the Cumulus program installed on your computer

Milos
I notice the header files are not present in MX. Are they exactly the same as the final version of Cumulus 1?

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.

User avatar
steve
Cumulus Author
Posts: 26704
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?

Post by steve »

Phil23 wrote:I notice the header files are not present in MX. Are they exactly the same as the final version of Cumulus 1?
Yes.
Also if they were delimited with commas like the data files they could be easily copied and pasted.
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.
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?
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.
Steve

philbertp2
Posts: 45
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?

Post by philbertp2 »

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
Phil
Tigard, Oregon USA
http://www.climateservices.net

Red Raspberry
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?

Post by Red Raspberry »

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.

Post Reply