Thanks. I was able to export the data points and edit them in Excel. The only issue I have is that the textrender format defaults to 0 so I lost all the decimal points but I think this is an issue with Excel loading the CSV because if I save it and load into Mango, it sets the correct format. Reload the same file and bingo, values are all 0 again.

If I log in as admin, the data is visible but if I log in as user, there is no data. In the datasource datapoints, the dataSourcEditRoles is set to superadmin. Should this not be user?

Which setting do I need for the user to be able to read the data? Is it in the readPermissions or should that default to blank?

I want to change an indicate or text colour based on the data being out of date. The data on the system arrives every 15 seconds so I'd like the flag it when there is no data for, say 60 seconds?

Or how to create an LED indicator type display for the same thing?

How to do this?

This is the error from the console.

mangoUi~ngMango~ngMangoServices.js?v=f41ab677f738e8ffe5b8:39 Error: <g> attribute transform: Expected number, "rotate()".

I found some code that Jared had posted previously for a 360 deg component and I am trying to get it to work but the value is not being shown.

I am using the following to get the wind direction from the watch list.

<ma-calc input="designer.points | filter:{name:'Wind Direction'}:true | maFirst" output="myDirection"></ma-calc>

And then using this in the code for the display but the heading remains at 0.

    <g class="direction-cones" transform="rotate(-90)">
        <g id="north" transform="rotate({{myDirection.value}})">
            <circle class="scale-1" r="100"></circle>
            <circle class="scale-2" r="100"></circle>
        </g>
    </g>

What am I doing wrong here?

@jared-wiltshire That works for me as I only have about 20 data points per device. By using the device ID as part of the XID, and the topic, this means a simple find and replace in Excel and then save and import works.

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?

The best way I found to do this was to create a second sheet and have Mango paste the data into that and then on the first sheet you simply link to the data on the second sheet.

See sample below. Highlight at least 2-3 rows and then in the formulas tab choose create from selection. These are now what you select in Mango. Format the columns before you upload the Excel file.

Is the URL correct? On my system the dashboard appears at:

/modules/dashboards/web/yourname/

Just a quick update, My client finally updated the server to a 4GB memory option and for 24 hours now we have not seen any shutdowns. Previously we would see at least 5-6 in that time.