# \[APP\]\[Pro\] Archive Insights - export all your Insights data to a NAS, FTP or web folder **URL:** \ **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:** 12\ **Page:** 15
**Author:** ![Eep\_Eepo](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/eep_eepo/32/122241_2.png) [@Eep\_Eepo](https://community.homey.app/u/Eep_Eepo)\ **Post date:** [May 17, 2026, 6:41pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/286 "2026-05-17T18:41:47Z")
Is it possible to use (numerical) logic variables for export? Thanks ---
**Author:** ![Crapton](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/crapton/32/15039_2.png) [@Crapton](https://community.homey.app/u/Crapton)\ **Post date:** [May 19, 2026, 12:41pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/287 "2026-05-19T12:41:33Z")
All, I am trying to get this working but something is not OK but unclear what. QNAP TS231 NAS, 2018 Homey Pro, NAS SMB switched on, Domain name set to DOMAIN, IP checked. The SMB test was OK and save the settings. I have enabled the secure connection hence port 443. I did a export test for one insight for SMA and attached log. No message and nothing in the NAS directory. Anyone who can give me a suggestion? What am I overlooking here? ![Schermafbeelding 2026-05-19 140256](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/b/c/bcf3d8c9c0a47ad8f95d27918088dc545fd803f2.png) ![Schermafbeelding 2026-05-19 140231](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/2/4/243a80e40abb756ab3c6d14aebddf87adec2c291.png) ---
**Author:** ![SunBeech](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/sunbeech/32/111391_2.png) [@SunBeech](https://community.homey.app/u/SunBeech)\ **Post date:** [May 19, 2026, 1:31pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/288 "2026-05-19T13:31:03Z")
Does your NAS’ user account have access to the `homes` folder, that is part of the set network share? I mean the top level folder; not your personal subfolder. The SMB port should normally be 445. Not sure if SMB uses the HTTPS 443 port. ---
**Author:** ![Crapton](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/crapton/32/15039_2.png) [@Crapton](https://community.homey.app/u/Crapton)\ **Post date:** [May 19, 2026, 2:22pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/289 "2026-05-19T14:22:53Z")
Yep, thks! I changed to 445 and disabled secure conn requirement on NAS which was port 443. Now it works. In previous attempts on 445 I had not yet disabled the secure conn and that did not work. It appears SMB is not working with that setting. ---
**Author:** ![Crapton](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/crapton/32/15039_2.png) [@Crapton](https://community.homey.app/u/Crapton)\ **Post date:** [May 24, 2026, 7:55am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/290 "2026-05-24T07:55:02Z")
All, as per previous post the export works. However data (CSV) looks like below, with some very odd values sort of random in there, all with too many comma’s at the wrong locations. If I look at the JSON file using a text editor it appears normal. However my Excel version does not import the JSON. Is this a known issue, or just with me? Is there a fix? ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/c/ac28781101185e59451a8f8ba9fa8ed914b158bc.png) ---
**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:** [May 24, 2026, 9:42am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/291 "2026-05-24T09:42:24Z")
> [@Crapton](#): > > my Excel version does not import the JSON. It is caused by the language setting in your excel. Try English. Or try importing the JSON in stead of the csv. ---
**Author:** ![Crapton](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/crapton/32/15039_2.png) [@Crapton](https://community.homey.app/u/Crapton)\ **Post date:** [May 24, 2026, 5:26pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/292 "2026-05-24T17:26:16Z")
Thanks! The issue was hidden in the legacy text import wizard which I frequently use. For some reason the decimal separator and the thousands separator were both set at comma. Changing thousands separator to dot solved it. Also the standard Data\>import from txt/CSV worked fine on this file, while on other situations it is giving me issues with date conversion. Solved. ---
**Author:** ![Machtien](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/machtien/32/121415_2.png) [@Machtien](https://community.homey.app/u/Machtien)\ **Post date:** [June 1, 2026, 9:03am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/293 "2026-06-01T09:03:05Z")
Try importing the csv file from the ‘import data’ → ‘From text/csv’ → ‘Select file’ → ‘Import’ menu option. You then enter the import specification section. Do not load, but use ‘transform data’ option. You then see 3 ‘apllied steps’ in the right window. Select the third option ‘Change Type’. Then you’ll see the source command in the function bar in the top of the form. Change the function to: `= Table.TransformColumnTypes(#“Promoted Headers”,{{“date”, type datetime}, {“value”, type number}},“en-GB”)` by adding `,“en-GB”` just before the last bracket. This wil give you the values in the right format (culture; locale). ---
**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 1, 2026, 9:07am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/294 "2026-08-01T09:07:40Z")
New version 5.3.0 is ready for testing: [Archive Insights | Homey](https://homey.app/a/com.gruijter.insights2csv/test/) - Multiple stability fixes - Major upgrade of dependencies - Lazy loading of dependencies - Reduced memory footprint Most of the dependencies were upgraded. I needed to adapt the code for breaking changes and I introduced new code to further reduce memory and cpu load. So please test and let me know if all is good or not! ---
**Author:** ![SunBeech](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/sunbeech/32/111391_2.png) [@SunBeech](https://community.homey.app/u/SunBeech)\ **Post date:** [August 1, 2026, 9:58am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/295 "2026-08-01T09:58:34Z")
I ran my regular flows: daily and weekly exports of all insights saved on my NAS via SFTP. They completed succesfully. ---
**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 3, 2026, 8:34am UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/296 "2026-08-03T08:34:47Z")
v5.3.1 was just released as stable to the app store: [Archive Insights | Homey](https://homey.app/a/com.gruijter.insights2csv/) Enjoy! ---
**Author:** ![MrChucky74](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/mrchucky74/32/172046_2.png) [@MrChucky74](https://community.homey.app/u/MrChucky74)\ **Post date:** [August 16, 2026, 1:52pm UTC](https://community.homey.app/t/app-pro-archive-insights-export-all-your-insights-data-to-a-nas-ftp-or-web-folder/10976/297 "2026-08-16T13:52:17Z")
Hi everyone, I am using the Homey Energy P1 Dongle and would like to export the energy data daily with Archive insights but when exporting all numbers from app , I don’t see the Energy Dongle P1 in the list. Also when exporting all , there is no zip for the p1. Solar Edge for example works fine. And I see all energy data from the Insights app but not in the Archive Insights. Anyone got any ideas ? Thanks [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=14)