Visualization on Failure

[Mrinj]

Hi there,

I'm newbie and probably will ask dum questions but ...

Need to make failure visualization and warning on a project with 85 emergency ECGs connected to DALI and HL for wrong searching ECGs and battery change need.
Any suggestions, recommendations or guide lines?
Will touch visualization be the easiest?
Will the HL DALI app help?
How about alerts and logs?

Kind regards!

[Erwin van der Zwart]

Hi,

Yes DALI app shows status but does not generate alerts, you can use the alert manager app for that.

The GW has error object that you can use to trigger alert manager and there you can notify to check the DALI app for detailed information.

BR,

Erwin

[Mrinj]

Thank you for your replay and guides, Erwin!

The DALI app does not show any ECGs og Groups no matter that I imported ESF file from ETS and object are shown. What did I miss?
Is there any manual for these apps online?
Sorry for this but: what is GW?

[Erwin van der Zwart]

Hi,

What brand DALI gateway (GW) do you use? If you use our MTN6725-0001 then you can connect it to IP and add the used IP address in the DALI app, then you can see all info from the GW. The DALI app doesn't use any ETS information. The app does not work on other brand GW's

BR,

Erwin

[Mrinj]

I use MTN6725-0001 with IP, accessible and configured with ECGs and Groups via browser. The app finds the GW, name and IP, but there are no ECGs or DALI Groups present in the app.

[Mrinj]

I solved the problem and ECGs are shown in the DALI app now. Thank you!

Erwin, you say: "The GW has error object that you can use to trigger alert manager and there you can notify to check the DALI app for detailed information."
Do I need to create an Alert script that will be active in the Alert App notifying when errors at the DALI ECGs?
Does the Alert app send email or other modifications? How does the Alert app notify the user or programmer?

[Mrinj]

Hello again,

Did some more testing, reading and forum search. Made scripts for email warning and alerts as Erwin described. Great Apps!!!
Thank you Erwin for your support! Thank you all for at this place exists!

Kind regards!

[Erwin van der Zwart]

Hi,

Good to hear you got it up and running.

Here is another thing you probably would like to use in combination with the DALI app (:

  Mail DALI report as attachment version 1_0.lua (Size: 3.22 KB / Downloads: 43)

Create a scheduled script on the 1th of the month and attach this script to it, you will automatically get a report of the burning hours, failures, etc once a month.

BR,

Erwin

[Mrinj]

Wow! Thanks a lot, Edwin!!!

[FatMax]

@Erwin:

Will the Dali app support the new 2x64 gateway from Schneider?

[Erwin van der Zwart]

Hi,

No it won't as the new DALI gateway's have no IP so there is no API to fetch the data from.

So the app is only usable with the Premium gateway MTN6725-0001 and not with MTN6725-0003 or MTN6725-0004

BR,

Erwin

[FatMax]

Oh, I didn’t know it doesn’t have IP. Is it set up through ETS only then?

[Erwin van der Zwart]

Hi,

Yes it works with ETS app, you can download the application and app from our website:

https://www.schneider-electric.com/en/do...6725-0003/?

BR,

Erwin

[manos@dynamitec]

Hello Erwin, Daniel, admin

We have a project in Brussels (Gare Maritime) where we are using 109 Dali gateways from Schneider (MTN6725-0001, 0003, 0004).
There are 11 buildings with 4 floors each and we have a Spacelynk per building.

The maintenance company asked us if it's possible to check all Dali GWs for errors and send them a report by mail every two weeks.

According to the manual (see attachement), we have made available object 20/22 1byte central diagnostics value 238.600 per Dali channel.

Since my lua skills very basic, could you help me implement this function in a sophisticated way?

Kind regards,

[admin]

238.600 1 byte DALI diagnostics data type is supported out of the box. In scripts you will get the diagnostics value as a table with 3 fields: address (number), ballasterror (bool) and lamperror (bool)

You can use this solution for CSV export: https://kb.logicmachine.net/scripting/ex...-hour-csv/

Currently grp.decodevalue() does not support 238.600 conversion to a readable string value so an additional conversion function is needed:

Code:

function dalidiagtostring(value)
  local stat

  if value.ballasterror then
    stat = 'ECG error'
  elseif value.lamperror then
    stat = 'Lamp error'
  else
    stat = 'OK'
  end

  return string.format('Address %d %s', value.address, stat)
end

[manos@dynamitec]

238.600 1 byte DALI diagnostics data type is supported out of the box. In scripts you will get the diagnostics value as a table with 3 fields: address (number), ballasterror (bool) and lamperror (bool)

You can use this solution for CSV export: https://kb.logicmachine.net/scripting/ex...-hour-csv/

Currently grp.decodevalue() does not support 238.600 conversion to a readable string value so an additional conversion function is needed:

Code:

function dalidiagtostring(value)
  local stat

  if value.ballasterror then
    stat = 'ECG error'
  elseif value.lamperror then
    stat = 'Lamp error'
  else
    stat = 'OK'
  end

  return string.format('Address %d %s', value.address, stat)
end

Hello admin,

Where should I include the function above in the following script?

Code:

require('socket.ftp')

-- ftp file
url = '/home/ftp/%s.csv'
date = os.date('%Y-%m-%d_%H-%M')
ftpfile = string.format(url, date)
-- get past 12 hours data (43200 seconds)
logtime = os.time() - 12 * 3600

-- csv buffer
buffer = {
  '"date","type","destination","name","datatype",' ..
  '"value","source","sender","login/meta"'
}

-- get object logs
query = [[
  SELECT ol.*, o.name, o.datatype
  FROM objectlog ol
  LEFT JOIN objects o ON ol.address=o.id
  WHERE logtime >= ?
  ORDER BY id DESC
]]

function fmtdpt(dpt)
  if dpt >= 1000 then
    dpt = string.format('%0.3f', dpt / 1000)
  end

  return dpt
end

for _, row in ipairs(db:getall(query, logtime)) do
  id = tonumber(row.address) or 0
  ia = tonumber(row.src) or 0

  logdate = os.date('%Y.%m.%d %H:%M:%S', math.floor(row.logtime))
  etype = row.eventtype
  textdpt = nil

  if (etype == 'write' or etype == 'response') and row.datatype then
    textdpt = fmtdpt(row.datatype)
    value = grp.decodevalue(row.datahex, row.datatype)
  else
    value = ''
  end

  buffer[ #buffer + 1 ] = string.format('%q,%q,%q,%q,%q,%q,%q,%q,%q',
    logdate,
    etype,
    buslib.decodega(id),
    row.name or '',
    tostring(textdpt or ''),
    tostring(value),
    ia > 0 and buslib.decodeia(ia) or 'local',
    row.sender or '',
    row.meta or ''
  )
end

if #buffer > 1 then
  data = table.concat(buffer, '\r\n')
  io.writefile(ftpfile, data)
end

Since we log other objects also can we implement this but only for Tagged with  'Dali Error' objects?

P.S. Is there a known issue with email notifications subscription on threads? It seems that I cannot get emails for the last month or so.

[admin]

1. Place the function definition after require('socket.ftp')

2. Replace this line:

Code:

value = grp.decodevalue(row.datahex, row.datatype)

With these:

Code:

if row.datatype == dt.dalidiag then
  value = busdatatype.decode(row.datahex, row.datatype)
  value = dalidiagtostring(value)
else
  value = grp.decodevalue(row.datahex, row.datatype)
end

Thanks for letting us know, we will take a look into email notifications issue.

[manos@dynamitec]

Hello Admin,

When I look into the object value of  238.600 1 byte DALI diagnostics data type, I see that the address starts from 0 but the numbering in the Dali gateway and then on the as built plans starts from 1. I know this is a detail but is there an easy way to visually overcome this issue? It's because once the logs are exported to the CSV file, the maintenance person has to remember to add +1 on each device showing error to point out the correct light in the end.

Kind Regards

[admin]

Use this:

Code:

function dalidiagtostring(value)
  local stat

  if value.ballasterror then
    stat = 'ECG error'
  elseif value.lamperror then
    stat = 'Lamp error'
  else
    stat = 'OK'
  end

  return string.format('Address %d %s', value.address + 1, stat)
end