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

4

The default Power Chart export made our R&D department sad because it gives only the data density as shown with poor sample interval over large sample periods. I had a similar “export as stored” button but selecting the date ranges was awkward. Hero feature would be to export “as stored” a date range selected by the user in the power chart as a preview.

Possibly a useful Exchange resource for someone to make if it doesn’t exist already? Looks like Tom Leijen made a popup tool for a fixed interval export.

5

Look at the embedded time span selector view in the Tag Report Utility resource:

6

This should be marked as the solution here.