Is it possible to use (numerical) logic variables for export?
Thanks
Is it possible to use (numerical) logic variables for export?
Thanks
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?
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.
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.
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?
It is caused by the language setting in your excel. Try English. Or try importing the JSON in stead of the csv.
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.
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).
New version 5.3.0 is ready for testing: Archive Insights | Homey
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!
I ran my regular flows: daily and weekly exports of all insights saved on my NAS via SFTP. They completed succesfully.
v5.3.1 was just released as stable to the app store: Archive Insights | Homey
Enjoy!
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
New version 5.4.0 is released:
please test @MrChucky74 , this probably fixes the issue for you too
@Staffan_Rosendahl Many thanks for your kind donation! ![]()
![]()
I’ve been trying to export data of an app I want to decommission. I can set things up with an sftp from my nas and see that directories are created fine. So it can log in and has write permissions in the sftp session. This is what I get when I run an export from the app settings:
Am I doing something wrong? is there a permissions issue on the homey itself?
What if you try using the export flowcard instead of the export option in the settings screen?
Tried using a flow: Logs look exactly the same.
I will have a look next week (away from my laptop the next few days)
Thanks! I appreciate that a lot ![]()
Hi Robin,
I would very much like to use your app to archive my insights and clean up my HP26. Unfortunately I’m having a problem connecting to my NAS’s SMB shares, and I believe it is because of the SMB version. I have had a similar error with another Homey app, and when it was updated to be able to use SMB version 3 (3.0 & 3.0.2 & 3.1.1 released 2016) that my NAS uses it started working. It is the security setup of my NAS that prevents older and less secure versions of SMB due to the vulnerabilities in version 2 of SMB from 2008.
Is there any chance you might be able to update your app to also use SMB version 3.x please?
Thank you kindly good sir ![]()