# \[APP\]\[Pro\] Archive Insights - export all your Insights data to a NAS, FTP or web folder

**URL:** <https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976>\
**Category:** Apps\
**Tags:** app, tools, flow, insights, export\
**Created:** [March 24, 2019, 3:04pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976 "2019-03-24T15:04:32Z")\
**Posts on this page:** 20\
**Page:** 7

<div class="post-metadata">

**Author:** ![Lindhardsen](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/lindhardsen/32/16576_2.png) [@Lindhardsen](https://community.homey.app/u/Lindhardsen)\
**Post date:** [March 9, 2021, 7:15am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/121 "2021-03-09T07:15:00Z")

</div>

Thanks for looking into my issue!  
For now I’m happy that I managed to get WebDAV working, so I can start using the archive again.

But, just as you say, most people probably are not even aware of FTPS vs. SFTP, so maybe in your next release you could just make it more clear that it is FTPS that is supported.

Thanks for you help, and for keeping this great app available for all of us!

---

<div class="post-metadata">

**Author:** ![Bos](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bos/32/8527_2.png) [@Bos](https://community.homey.app/u/Bos)\
**Post date:** [March 27, 2021, 8:14am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/122 "2021-03-27T08:14:58Z")

</div>

I checked the connect with drivehq (free account) and it is working over port 21, it does not work over port 990. In the Homey app you can use both FTP or SFTP (in reality FTPS). So, my conclusion is that FTPS with drivehq (free account) only works in the explicit mode. In explicit mode, an FTPS client “explicitly request” security from an FTPS server and then step up to a mutually agreed encryption method.

---

<div class="post-metadata">

**Author:** ![TKroon](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tkroon/32/9504_2.png) [@TKroon](https://community.homey.app/u/TKroon)\
**Post date:** [April 7, 2021, 5:17am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/123 "2021-04-07T05:17:56Z")

</div>

When I export my logic, the file name contains the variable ID. Is it possible to add the variable name I gave it? For example, my file name is: variable-1ec0a59e-9451-4263-96e5-6a67fcf16442.csv  
Since I have a lot of variables, I can’t distinguish them.

---

<div class="post-metadata">

**Author:** ![Wout\_van\_den\_Dool](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/wout_van_den_dool/32/391_2.png) [@Wout\_van\_den\_Dool](https://community.homey.app/u/Wout_van_den_Dool)\
**Post date:** [June 1, 2021, 8:58pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/124 "2021-06-01T20:58:39Z")

</div>

I am able to back-up the data (NICE) and was wondering what you guys are doing with this data… store it for ever or … This is where I am thinking of to use it:

- Rebuild Homey Insights in Google Sheets or XLS
- With the goal to send myself every morning an email dashboard with all kinds of widgets  
_Like I do at work to monitor the Webshops performance with Salesforce 🙂_
- For now I send myself push messages like water usage, electricity and gas, but also the climate in house (temp and humidity)
- But I’m missing the Year to date ore mont to date view, average etc… I’m hoping to get this via the exports

---

<div class="post-metadata">

**Author:** ![Mike1233](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/mike1233/32/20991_2.png) [@Mike1233](https://community.homey.app/u/Mike1233)\
**Post date:** [July 3, 2021, 11:45pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/125 "2021-07-03T23:45:13Z")

</div>

I just installed this app and use it with SMB. It works, i doe get a zip file with the csv files etc…  
But when i make an updat of the app Zonnepanelen and i say backup Yesterday.  
Then i get a csv file that starts at 02-07-2021 22:00 and it stops at 03-07-2021 21:55.  
Is there something wrong? When a flow should start at 14:00 it is starting at 14:00. So the time is right.  
And when i open the csv file i get solar power at 3:40. So the time is way of. It should be around 5:40. So there is also 2 hours difference.  
Can i do something about that?

---

<div class="post-metadata">

**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\
**Post date:** [July 4, 2021, 1:31am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/126 "2021-07-04T01:31:13Z")

</div>

Hi Mike. Great you are using the app!

No, there is nothing wrong. Since Homey is used worldwide, the time is measured in UTC or ‘Zulu time’. Hence the ‘z’ at the end of the time code.

So when you live in the Netherlands, yesterday started at 22.00z and ends at 22.00z.

See the actual UTC time here: [https://zulutime.net](https://zulutime.net)

---

<div class="post-metadata">

**Author:** ![Mike1233](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/mike1233/32/20991_2.png) [@Mike1233](https://community.homey.app/u/Mike1233)\
**Post date:** [July 4, 2021, 8:28am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/127 "2021-07-04T08:28:40Z")

</div>

Thank you. Now I know that there is nothing wrong I can try to change the time with  
a macro or something like that.

---

<div class="post-metadata">

**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\
**Post date:** [July 14, 2021, 1:09pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/128 "2021-07-14T13:09:49Z")

</div>

New version v2.9.0 has been released. In general it improves stability and compatibility.

- Allow unauthorized FTPS certificates.
- Packages update.
- athom-api@3.6.3
- webdav@4.6.0
- basic-ftp@4.6.6
- @marsaud/smb2@0.18.0
- archiver@5.3.0.

---

<div class="post-metadata">

**Author:** ![linper](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/linper/32/38993_2.png) [@linper](https://community.homey.app/u/linper)\
**Post date:** [August 21, 2021, 4:18pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/129 "2021-08-21T16:18:36Z")

</div>

Is there an update ongoing for app Archive Insights to support SMB NTLMv2?  
Since Synology DSM 7.0 Beta, NTLMv1 is disabled, which means that SMB does not work to use in Archive Insights to store the backup to a Synology NAS disk.  
Saw this in the log file on my Synology “User [username] from [192.168.1.12] failed to log in via [SMB] due to [NTLMv1 not permitted].” when I tested.  
I found this information on Synology’s website “NTLMv1 is disabled since DSM 7.0 Beta for security concerns, and only NTLMv2 is supported by default.”

---

<div class="post-metadata">

**Author:** ![Edwin\_D](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/edwin_d/32/136417_2.png) [@Edwin\_D](https://community.homey.app/u/Edwin_D)\
**Post date:** [August 21, 2021, 4:22pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/130 "2021-08-21T16:22:55Z")

</div>

You should not try to change the times in the database, UTC is a common way to store date/time independent of location. What you need to do is to find a way to explain to the tools that use it to display it formatted for your timezone. That is because if you live in an area that has daylight savings, the difference is not always 2 hours.

---

<div class="post-metadata">

**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\
**Post date:** [August 21, 2021, 4:54pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/131 "2021-08-21T16:54:44Z")

</div>

> [@linper](#):
>
> support SMB NTLMv2?

I am not aware of this issue. I have posted an issue with the developer of the SMB package that I use. Please see this link and add any info that could help the dev:

> <https://github.com/Node-SMB/marsaud-smb2/issues/80>
>
> A user of my Homey 'Archive Insights' app is running into this problem:
> 
> Since… Synology DSM 7.0 Beta, NTLMv1 is disabled, which means that SMB does not work to use in Archive Insights to store the backup to a Synology NAS disk.
> Saw this in the log file on my Synology “User \[username\] from \[192.168.1.12\] failed to log in via \[SMB\] due to \[NTLMv1 not permitted\].” when I tested.
> I found this information on Synology’s website “NTLMv1 is disabled since DSM 7.0 Beta for security concerns, and only NTLMv2 is supported by default.”
> 
> Is NTLMv2 indeed not supported at the moment? If not, can you please add it @marsaud . If it is supported, any hints how to use that when setting up the client?

---

<div class="post-metadata">

**Author:** ![Molstie](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/molstie/32/28268_2.png) [@Molstie](https://community.homey.app/u/Molstie)\
**Post date:** [September 4, 2021, 6:07am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/132 "2021-09-04T06:07:06Z")

</div>

Indeed. Took me a while to find this one. First, I notices that there were no exports anymore. I checked SAMBAS setting. The Error in the homey app says: “_Error: STATUS\_LOGON\_FAILURE (0xC0000006d) : the attempted logon is invalid. this is either due to a bad username or authentication information_”.

Thanks to Edwin\_D I looked at the Synology DSM logs: “_User [Myhomey] from [192.168.0.119] failed to log in via [SMB] due to [NTLMv1 not permitted]._”

I now switched to ftp, because the port is closed for external use, but I prefer to use SAMBA instead.

---

<div class="post-metadata">

**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\
**Post date:** [September 4, 2021, 6:16am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/133 "2021-09-04T06:16:27Z")

</div>

I might have to switch to some other SMB package all together. The devs stopped supporting the one I’m using now. But it seems a good SMB library is very hard to find. I will definitely try some though. Will take some time because the packages are all not compatible so it involves quite some rewriting of code.

---

<div class="post-metadata">

**Author:** ![Molstie](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/molstie/32/28268_2.png) [@Molstie](https://community.homey.app/u/Molstie)\
**Post date:** [September 4, 2021, 10:33am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/134 "2021-09-04T10:33:22Z")

</div>

No prob. FTP works fine I see.

---

<div class="post-metadata">

**Author:** ![Rdeursen](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/rdeursen/32/33942_2.png) [@Rdeursen](https://community.homey.app/u/Rdeursen)\
**Post date:** [October 11, 2021, 3:39pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/135 "2021-10-11T15:39:37Z")

</div>

Hello, great App!!  
I encountered a problem. I want to export Plugwise data from last year but my Homey reboots everytime. Strange because with other exports it works fine. It can’t be the volume i think.  
What can be the problem, for example data last month works fine.  
Thanx  
Riny

---

<div class="post-metadata">

**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\
**Post date:** [October 17, 2021, 2:34pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/137 "2021-10-17T14:34:25Z")

</div>

v2.9.1 is pending approval.

- Packages update. athom-api@3.6.7 webdav@4.7.0

---

<div class="post-metadata">

**Author:** ![mroek](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/mroek/32/38044_2.png) [@mroek](https://community.homey.app/u/mroek)\
**Post date:** [December 2, 2021, 3:25pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/138 "2021-12-02T15:25:37Z")

</div>

First let me thank you for creating this app. Very useful tool to have.

I have a question, though. It appears that the resolution of the data is heavily decreased if exporting for a larger time interval. Is that because Homey only stores a low resolution (e.g 1 hour sample time) version of the data as it gets older? I would assume that is the case, just wanted to check.

---

<div class="post-metadata">

**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\
**Post date:** [December 2, 2021, 4:16pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/139 "2021-12-02T16:16:31Z")

</div>

Yes, that is indeed what Homey is doing. This is a know strategy for time series databases to ‘compress’ the data by resampling to a lower resolution. It ensures that the insights data never grow bigger then what Homey can handle. Before Athom introduced this strategy the Insights database was growing out of control rapidly.

So if you need high resolution insights you need to export more often (every day or even every hour). If you need the highest possible resolution you need to set up your own database somewhere and use a real time exporter (influxdb, prometheus or mqtt hub)

---

<div class="post-metadata">

**Author:** ![mroek](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/mroek/32/38044_2.png) [@mroek](https://community.homey.app/u/mroek)\
**Post date:** [December 2, 2021, 4:32pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/140 "2021-12-02T16:32:54Z")

</div>

Ok, thanks. As I guessed, then. Makes sense too, since (as you said) the data would quickly grow very large if they didn’t do that.

---

<div class="post-metadata">

**Author:** ![Krzysiek](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/krzysiek/32/34025_2.png) [@Krzysiek](https://community.homey.app/u/Krzysiek)\
**Post date:** [January 4, 2022, 11:22am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/141 "2022-01-04T11:22:24Z")

</div>

Thank you for a very useful app!

I have 2 questions. The first one is related to the question asked above - resolution of the data. At the moment I am mainly interested in exporting the room temperature data from my thermostats. When I export the data for the past hour, I get readings every 5 seconds even though the thermostats report only every 5 minutes. Is there anything I can do about it or is the only solutuon to export every 7 days for example?

My second question is about the data export format. I have an app which lets me set and read the temperature from my floor heating thermostats. I have 11 thermostats and when I export the data, I end up with 11 folders with couple of .json and .csv files. Is there any way to choose what data I want exported? For example only measured temperature and no target temperature? It would also make it easier to get all the files of interest in one folder but at the same time it is not that much work to move them once a week.

Anyway, thank you for the app once again!

[Previous page](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976.md?page=6)

[Next page](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976.md?page=8)
