Here is my setup.
I have 7 devices in the field that send data via GPRS to a server running an MQTT broker (Mosquitto). Each device sends a topic with the device identification and then the sensor reading, eg device01/pressure and the payload contains the value. Every device sends the data values and only the device ID is different for each unit.
I am trying to work out the best way to create the data points in Mango and handle this with a drop-down selection to select each device so that the data on the screen switches to that device. I will also have an overview display for all the important sensors that will navigate to the more detailed view.
I was thinking to create a single data point for a device and then export this to see the Excel format and then create a PC programme to generate this same format as an Excel file and then import this into Mango or is there an easier way? I could simply edit the Excel by hand but this is prone to errors. A simple software program would allow just the device ID to be input.
What is the best way to create these data points in mango so that adding a new device is quick and doesn't require any lengthly input of data points?