# Insight Data Import

**URL:** <https://community.homey.app/t/insight-data-import/8359>\
**Category:** Questions & Help\
**Created:** [January 31, 2019, 8:24am UTC](https://community.homey.app/t/insight-data-import/8359 "2019-01-31T08:24:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paul\_Lavelle](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/paul_lavelle/32/8821_2.png) [@Paul\_Lavelle](https://community.homey.app/u/Paul_Lavelle)\
**Post date:** [January 31, 2019, 8:24am UTC](https://community.homey.app/t/insight-data-import/8359/1 "2019-01-31T08:24:30Z")

</div>

Hi,

I’m a homey newbie and so far very much enjoying my new product.

I have a lot of data from the past few years that is stored in mysql or can be transferred to a CSV file. Is it possible to import this data into Insights/homey so that historical temperatures can be tracked in the same sensor path as it now sits?

Thanks

---

<div class="post-metadata">

**Author:** ![bvdbos](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bvdbos/32/2352_2.png) [@bvdbos](https://community.homey.app/u/bvdbos)\
**Post date:** [January 31, 2019, 8:36am UTC](https://community.homey.app/t/insight-data-import/8359/2 "2019-01-31T08:36:47Z")

</div>

Maybe with [https://apps.athom.com/app/nl.rebtor.sql](https://apps.athom.com/app/nl.rebtor.sql) ? But as storage is limited Athom compresses older insights-data (averages). So that might happen with your data too. I’m looking for the opposite, store data from Homey to an external database…

---

<div class="post-metadata">

**Author:** ![Jeroen\_Somhorst](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jeroen_somhorst/32/184_2.png) [@Jeroen\_Somhorst](https://community.homey.app/u/Jeroen_Somhorst)\
**Post date:** [January 31, 2019, 8:53am UTC](https://community.homey.app/t/insight-data-import/8359/3 "2019-01-31T08:53:41Z")

</div>

As @bvbos already pointed out the storage on Homey is limited. My guess is that the oposite direction ( so retrieving data from Homey insights and putting it into mysql) is better on the long run.

---

<div class="post-metadata">

**Author:** ![Paul\_Lavelle](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/paul_lavelle/32/8821_2.png) [@Paul\_Lavelle](https://community.homey.app/u/Paul_Lavelle)\
**Post date:** [January 31, 2019, 8:56am UTC](https://community.homey.app/t/insight-data-import/8359/4 "2019-01-31T08:56:22Z")

</div>

Thanks both. I have the data in a report mysql database is it possible to get homey to store data to that rather than internally?

---

<div class="post-metadata">

**Author:** ![Jamie](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jamie/32/5274_2.png) [@Jamie](https://community.homey.app/u/Jamie)\
**Post date:** [January 31, 2019, 3:48pm UTC](https://community.homey.app/t/insight-data-import/8359/5 "2019-01-31T15:48:17Z")

</div>

Possibly with an app, the inisghts data is returned to the website as json.

So get all devices - loop through - call the insights URL and then convert to cvs for mysql import

`api/manager/insights`