I haven’t done it yet, but its still on the list somewhere.
I was able to find an archived copy of that post though, which might be useful for you.
The basics of what I was planning was (similar to the blog post):
- Build a lookup table of iFix tag to Ignition Tag Path (our structure in iFix makes it pretty easy)
- Let Ignition query the iHistorian SQL interface directly for a block of time for a specific tag (either at some useful interval or every raw sample).
2a. If that proved problematic, then one alternative is to build an intermediate csv with the Excel Add-In (slow though) or SQL scripting against iHistorian running on one of the iFix nodes building CSVs that way. - Use the system.tag.storeTagHistory function to get it into the historian (formatting issues in the blog post to be aware of)
- Keep looping through the tags for that time block, and then loop forward in time, etc etc.
The process data I was looking to import at the time is also now rolled up into a separate rollup table, and going back past the year+ we already have collected natively is making this effort slowly drop down the list in priority, but I do still need to get it done just so I can turn iHistorian off finally. The iFix system has about 20,000 tags archived at sub 5 minutes for the last 9-10 years, so getting everything transferred will definitely be very time consuming and resource intensive (lots of processor time)