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).
