Different headers in my CSV files

Posted on
Sat May 18, 2019 4:04 pm
norcoscia offline
User avatar
Posts: 1206
Joined: Sep 09, 2015

Different headers in my CSV files

Question I was looking at some of the CSV files

Some have a value in the header of the second column some say sensor value - is that a problem?
Attachments
2019-05-18_15-03-30.jpeg
2019-05-18_15-03-30.jpeg (30.59 KiB) Viewed 2039 times
2019-05-18_15-03-07.jpeg
2019-05-18_15-03-07.jpeg (33.56 KiB) Viewed 2039 times

_______
Norm

Posted on
Sun May 19, 2019 3:52 am
DaveL17 offline
User avatar
Posts: 6744
Joined: Aug 20, 2013
Location: Chicago, IL, USA

Re: Different headers in my CSV files

norcoscia wrote:
Question I was looking at some of the CSV files

Some have a value in the header of the second column some say sensor value - is that a problem?

Hi Norm - assuming that you're using a CSV Engine device to manage those CSV files, the header of the second column should be whatever you have entered into the 'Title' field for that CSV source. You can manually edit the column header of that file, or delete the file entirely and the plugin will recreate it at the next data refresh point.

I came here to drink milk and kick ass....and I've just finished my milk.

[My Plugins] - [My Forums]

Posted on
Sun May 19, 2019 7:02 am
norcoscia offline
User avatar
Posts: 1206
Joined: Sep 09, 2015

Re: Different headers in my CSV files

I took a closer look - since the data is coming from various places the choices I have for the drop down seem to be different (depending on the source). If I just leave it I'm assuming all will be fine - you are not using that in any calculations correct?

_______
Norm

Posted on
Sun May 19, 2019 7:29 am
DaveL17 offline
User avatar
Posts: 6744
Joined: Aug 20, 2013
Location: Chicago, IL, USA

Re: Different headers in my CSV files

Yes, that's right--it's not used in any calculations. The header of the second column is only used as a name for the data sources within the chart device settings and within the CSV Engine devices.

I came here to drink milk and kick ass....and I've just finished my milk.

[My Plugins] - [My Forums]

Posted on
Sun May 19, 2019 7:33 am
norcoscia offline
User avatar
Posts: 1206
Joined: Sep 09, 2015

Re: Different headers in my CSV files

OK, thanks - so if I had a 3 party CSV file the words in the header don't much matter and I could still choose it to graph by picking it when building a graph - only rule is timestamp format and one row of data - Correct?

_______
Norm

Posted on
Sun May 19, 2019 7:41 am
DaveL17 offline
User avatar
Posts: 6744
Joined: Aug 20, 2013
Location: Chicago, IL, USA

Re: Different headers in my CSV files

The rules of thumb are:

  • The first row of the file is the header row. Anything on that line will be treated like a header for its row.
  • The first column is the timestamp value. It should be in the form of YYYY-MM-DD HH:MM:SS.SSSSS, although the plugin should be able to handle other datetime formats.
  • The second column is the data point.

I came here to drink milk and kick ass....and I've just finished my milk.

[My Plugins] - [My Forums]

Posted on
Sun May 19, 2019 7:42 am
norcoscia offline
User avatar
Posts: 1206
Joined: Sep 09, 2015

Re: Different headers in my CSV files

Cool, thanks!!!!!

_______
Norm

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 4 guests