Power Chart CSV Export Excel Timestamps

Ignition
,
1

I have a few CSV files that I've exported from my power chart. I'd like to make a chart in excel from this data. However, I'm not sure how to go about converting the time values. They're in scientific notation unix (?) time.

2

I use one of two options:

  • Create my own export button on my pages, that way I can have the power chart display a max number of samples to make it run better, but export 'as stored', and can also just configure it to export the data with datetimes converted, or;

  • Convert it in the excel sheet using some kind of equation with the excel DATE function, like on here: How to Convert Unix Timestamp to Date in Excel (3 Methods) - ExcelDemy

3

I found in the PowerChart PROPS.config.export.dateFormat and then also timeFormat. You can change this setting here to whatever date and time format you wish for exporting. Then when you export from the PowerChart, the CSV file will show a meaningful date and time.

image
image316×939 39 KB