# Historian Import (iFix)

**URL:** <https://forum.inductiveautomation.com/t/historian-import-ifix/7753>\
**Category:** Ignition\
**Created:** [December 23, 2013, 2:27pm UTC](https://forum.inductiveautomation.com/t/historian-import-ifix/7753 "2013-12-23T14:27:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tomt](https://avatars.discourse-cdn.com/v4/letter/t/90ced4/32.png) [@tomt](https://forum.inductiveautomation.com/u/tomt)\
**Post date:** [December 23, 2013, 2:27pm UTC](https://forum.inductiveautomation.com/t/historian-import-ifix/7753/1 "2013-12-23T14:27:21Z")

</div>

Has anyone done a mass import of data from another historian? I’d like to explore the possibilities of importing an iFix database. Ideally, I would duplicate the tag structure in Ignition, let it start logging data, then backfill the Ignition database with the iFix data.

I know that the historian has an ODBC connector, so I can write queries against it in SQL. I know that I could populate that in Ignition. However, there are intricacies such as the iFix historian compression, Ignition’s compression, and getting all the other database requirements right in Ignition.

Any pointers?

---

<div class="post-metadata">

**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\
**Post date:** [December 28, 2013, 1:02am UTC](https://forum.inductiveautomation.com/t/historian-import-ifix/7753/2 "2013-12-28T01:02:13Z")

</div>

I know that we’ve done imports from Wonderware, but I haven’t seen anything from iFix. Getting this done will depend completely on how easy it is to get that data out of the iFix historian in the first place.

If I were doing this project, I would export the iFix data, go through it until I have only value change events, and then stuff that back into the Ignition SQLTH tables.