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:

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:

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:

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:

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