Page 1 of 1

Different headers in my CSV files

PostPosted: Sat May 18, 2019 4:04 pm
by norcoscia
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?

Re: Different headers in my CSV files

PostPosted: Sun May 19, 2019 3:52 am
by DaveL17
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.

Re: Different headers in my CSV files

PostPosted: Sun May 19, 2019 7:02 am
by norcoscia
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?

Re: Different headers in my CSV files

PostPosted: Sun May 19, 2019 7:29 am
by DaveL17
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.

Re: Different headers in my CSV files

PostPosted: Sun May 19, 2019 7:33 am
by norcoscia
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?

Re: Different headers in my CSV files

PostPosted: Sun May 19, 2019 7:41 am
by DaveL17
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.

Re: Different headers in my CSV files

PostPosted: Sun May 19, 2019 7:42 am
by norcoscia
Cool, thanks!!!!!