Welcome to the Cumulus Support forum.

Latest Cumulus MX release v3.2.4 build 3060 - 10 December 2019.
    Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014

    See the Wiki for downloading either version.

    Dayfile.txt Column Headers - Where Are They?

    Discussion and questions about Cumulus weather station software version 1. This section and its subforums are the main place to get help with Cumulus. Anything which is not specific to the type of weather station goes in here; for anything specific to a type of weather station, please use the appropriate subforum. Use the 'website development' section for any questions relating to creating or running a web site for Cumulus data. Discussion of the stations themselves in these sections is fine.
    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 » Sat 17 May 2014 3:44 am

    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 » Sat 17 May 2014 4:03 am

    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 » Sat 17 May 2014 5:36 am

    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 » Sat 17 May 2014 4:16 pm

    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: 26717
    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 » Sat 17 May 2014 6:20 pm

    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 » Sat 17 May 2014 6:28 pm

    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 » Sat 17 May 2014 11:02 pm

    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: 347
    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 » Sat 12 Nov 2016 5:52 am

    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.
    Image

    User avatar
    steve
    Cumulus Author
    Posts: 26717
    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 » Sat 12 Nov 2016 11:08 am

    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 » Sat 12 Nov 2016 4:21 pm

    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 » Fri 09 Dec 2016 9:48 pm

    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