Hi, I would like to understand a bit more how you split the historical data in the database so I could export it to excel. I am using SQL server 2008 R2. My goal is to get the tag name, the value and the timestamp. I find out that you are using a number to identify time after googling this I fou…

The Unix way of recording time is normally the number of seconds since 1/1/1970 00:00:00. In Ignition’s case, it looks like they are also appending the number of milliseconds since that date, so if you follow instructions like the website here to convert the timestamps in Excel, you will have to re…

Using Ignition’s built in tag history function will help with a lot of tricky situations, like bringing back multiple months of data, or dealing with Unix timestamps. Bringing it the dataset using the built in tag history will bring back the timestamps in a more “readable” format. Using custom pro…

Inductive Automation Forum

Historical data to excel

General Discussion

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled