MQTT Client app

[myg]

suddenly with today's auto update mqtt client stopped working for multiple instances. Rolling back to older released helped. In error log i can see initialization error for all objects in the rules. It seems i was too naive to have auto update enabled on LM, this update broke critical functionality right in the evening.
What happend with quality control for releases? i don't remember anything like that before.
   

[admin]

@myg, an update has been published, see if it fixes the issue for you.

[myg]

@myg, an update has been published, see if it fixes the issue for you.

works again, thank you for quick update

[Pierluigi]

Good morning,

I’m trying to use the Logic Machine 5 Lite for integrating a MQTT payload message.

This is a typically Topic/Payload we receive:

Topic: callway/ad75adfd-b72a-4119-a34c-dfb372df9ecf/status/1/1 QoS: 2
{"data":[{"position":0,"position_type":"room","room":1,"status":"assistance","timestamp":"2025-03-28T10:01:06.000Z","ward":1}],"timestamp":"2025-03-28T11:29:16.000Z","type":"snapshot","uuid":"ad75adfd-b72a-4119-a34c-dfb372df9ecf","version":"1.0.0"}

With this metode I receive on the “String Object” the value: (image 1 and 2)

The problem is that I need to export the value throught Bacnet communication and String object is not permitted.
So, i need to convert the string value into a numeric one, like 06.1 1byte signed integer.
Could you help me with the script ?
Thank you.

[Daniel]

Click New Replay then you can attach images

[admin]

Do you have a define mapping between text and numeric values?

[Pierluigi]

Click New Replay then you can attach images

i modified the previous message.

Thank you.

---

Do you have a define mapping between text and numeric values?

idle : 0
call: 1
presence: 2
unhooked: 3
assistance: 4
emergency: 5
technical: 6
speech: 7

[admin]

Remove JSON value path, use this Input script:

Code:

1234567891011121314151617

local map = {   idle = 0,   call = 1,   presence = 2,   unhooked = 3,   assistance = 4,   emergency = 5,   technical = 6,   speech = 7, } local msg = json.pdecode(payload) if type(msg) == 'table' then   local status = msg.data[1].status   return map[ status ] end

[Pierluigi]

Remove JSON value path, use this Input script:

Code:

1234567891011121314151617

local map = {   idle = 0,   call = 1,   presence = 2,   unhooked = 3,   assistance = 4,   emergency = 5,   technical = 6,   speech = 7, } local msg = json.pdecode(payload) if type(msg) == 'table' then   local status = msg.data[1].status   return map[ status ] end

It works, really thank you. 

[tomnord]

Hello, MQTT client app works fine, but it would be nice to be able to edit topics in a texteditor or excel etc? If you have many topics, it is timeconsuming to add them all, or is this something that could be made in a script?

[admin]

Try this:

Code:

1234567891011121314151617181920

data = {   direction = 'both',   topic = 'test2',   address = '0/0/1',   retain = '1',   buswrite = '1',   qospub = '0',   qossub = '0',   delta = '',   throttle = '',   jsonpath = '',   boolon = '',   booloff = '', } dofile('/www/apps/data/mqtt-client/lua/lib.lua') res = save_topic(data) log(res) reload()

[tomnord]

thanks. Is there any easy way of implementing timestamp in the script?

[admin]

Timestamp for what? Explain your task in more detail.

[tomnord]

I would like a timestamp as an object in the JSON sendt from LM, can it be done in the script section. i see that "timestamp = os.time()" worked in script.
That returns unix time?

[admin]

Yes, os.time() returns UNIX timestamp.

[tomnord]

Try this:

Code:

1234567891011121314151617181920

data = {   direction = 'both',   topic = 'test2',   address = '0/0/1',   retain = '1',   buswrite = '1',   qospub = '0',   qossub = '0',   delta = '',   throttle = '',   jsonpath = '',   boolon = '',   booloff = '', } dofile('/www/apps/data/mqtt-client/lua/lib.lua') res = save_topic(data) log(res) reload()

Regarding this, any good ideas on how to implement this based on GA names? As far as I can see we need to run the "save_topic" once for each new topic.

[admin]

Use tags. You can filter object list using wildcard search and assign tags using mass edit option.

[jmir]

Hi,
I'm trying to use certificates and I get this message:

"Save failed: unable to get local issuer certificate"

I've seen that someone had this same issue... How can it be fixed?

Using MQTT-Explorer and the same certificates it works.

Thanks.

[admin]

@jmir, see PM.

[jmir]

Hi,

Is there any way to use $ caracter in topic name? 
I'm trying to use aws and need that topic name start with $aws/....