km
km copied to clipboard
nygma2004
Tried it, but gave me an error
Hi,
Thanks for answering. In attach you can see my flow. I changed things so to work with my sensors (shellyplusHT). The thing is I can not write to the db. And there is an error coming from the "convert to influxdb”-node.
I did another test with a simple message and value, and that worked. I was able to write to the database.
I will have to deploy 10 of them and later perhaps more, so I would love to copy paste and change as little as data possible to deploy the others.
Anyway, thanks a lot to have a look at this.
Kind regards
Free 
On 13 Dec 2022, at 23:17, nygma2004 @.***> wrote:
OK, what did you try? What is the error?
— Reply to this email directly, view it on GitHub https://github.com/nygma2004/km/issues/1#issuecomment-1349880835, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACGUHZP2KXQ5DTOSAN6JBJ3WNDYX7ANCNFSM6AAAAAAS5SYQVU. You are receiving this because you authored the thread.
Sorry, but I am seeing no attachment anywhere. I will probably also need more. Like what the error message in, what is the data that comes from the shelly, etc. Just the flow will not help. I would not be able to reproduce them in my system.
Hi,
I attached the file again. Strange that you didn’t receive it… The error message I’m getting = TypeError: Cannot read properties of undefined (reading 'temperature’) And it’s comming from function node “convert to influx”.
The part of storing global variables worked. (Just a minor thing here that each time I redeploy the variables are empty until a mqtt message comes trough.)

If I put a debug node just before the function node “convert to influx” I get

So that seems to have read from the stored global variables alright….

Hope this helps.
Kind regards
On 14 Dec 2022, at 09:24, nygma2004 @.***> wrote:
Sorry, but I am seeing no attachment anywhere. I will probably also need more. Like what the error message in, what is the data that comes from the shelly, etc. Just the flow will not help. I would not be able to reproduce them in my system.
— Reply to this email directly, view it on GitHub https://github.com/nygma2004/km/issues/1#issuecomment-1350616326, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACGUHZOL732RJWZKIM5YQULWNF72FANCNFSM6AAAAAAS5SYQVU. You are receiving this because you authored the thread.
Sorry, none of your screenshots or attachments come through. I think you are sending them from email, and Github does not handle that very well. Can you email me at csongor.varga at gmail.com
Hello,
I'm pretty proficient in using Excel VBA but new to SAP scripting. I tried to record the macro in Excel and manually move the code over to Excel but it failed. I downloaded your excel file and still receive an error connecting to SAP.
In your code W_System = "" so Attach_Session is false and the program ends. Do you have an idea how to connect SAP to Excel?
Allan Jackson
@AllanFJackson, it is not able to attach to any SAP session. Just to go through the obvious:
- You are logged into the system/client that you selected in your Excel? (e.g. in the code or in the cell where I store the system/client).
- When you go to Script Recording and Playback, does it enabled? It is possible that scripting is disabled in your client.
Hello,
thank you for the response. The script itself wouldn’t work either. I went from receipt (training mode) to production and the script started to work so I think that is the issue.
I’ll continue to mess around with it some more today. Allan Jackson