Historian CSV Export Timestamp Conversion to Excel

Ignition
,
1

When I export the trended data from the Perspective Historian to a .csv file, it shows the time as a 13-digit number that does not seem to easily correlate to the correct date/time of the data (it's not just something like yyymmddhhmmss). I figure this is due to how the Ignition dateTime data type is formatted. Is there a way to convert the 13-digit number to the correct date-time in a third-party program like Excel?

The end goal is to be able to compare the data in the Ignition historian with a secondary database the data is being sent to in order to ensure that both sets of data match.

For example: a timestamp that should be between 9:41PM-9:42PM 03/06/2025 came out as 1741297277000 when I opened the .csv file in Excel.

2

Timestamps in Ignition are stored as milliseconds since the epoch.

2 Likes
3

For the record.

2 Likes
4

Sweet, thanks for the help.

As a side question, does the Perspective Historian interpolate data points to show a continuous graph? I also noticed that the .csv has SIGNIFICANTLY more data points than we actually collected during an interval.

5

The Perspective Power Table component has a number of per-pen historian settings that apply.

Ignition's historian can be told to supply "as-stored" data, but there are quirks that make that difficult to chart out of the box.

Consider scripting a dedicated historian query to get exactly the data you wish to export, and deliver it with system.perspective.download().

2 Likes