Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

hi, in the end the datapoint started working by itself and seem to work 100%, I used /value as JSON pointer for value in this message: {"tsE":1589204279000,"tsM":"20200511153800","value":23118} I also need to use the topic type "JSON with Timestamp" but I could not get the right value as timestamp so for example for the message: {"tsE":1589204279000,"tsM":"20200511153800","value":23118} tsM = timestamp in format yyyyMMddHHmmss I used the following parameters but is not working: [image: B9f9XDE.png] the error is: MQTT Client': Error during read topic: "gipo/inv7/wh/eday" datapoint: "MQTT Client - 0gipo/inv7/wh/eday -- /tsM" payload: "{"tsE":1589207111000,"tsM":"20200511162512","value":25105}" error: "Text '20200511162512' could not be parsed: Unable to obtain Instant from TemporalAccessor: {},ISO resolved to 2020-05-11T16:25:12 of type java.time.format.Parsed" I also want to upgrade the Mqtt module but in the modules pages I see:[image: cEKBmus.png] What I can do? Thanks for your help Rgards

I see that the warning is related to releases of JDK 9 and up https://issues.apache.org/jira/browse/GROOVY-8339 I reverted to JDK 8 as a work around. Ran the installServices.bat without any issues; however, I am having problems with starting the service as an administrator, this time I am not getting any warnings on the command prompt. [image: wKn1TQ8.png] I am not getting logs on C:\Mango\log and C:\Mango\yajsw\log Please advise

Hi @mauricio-souza Your best option would be to use a script event handler and build an HTTP post which conforms to the system you are integrating to. Here are some links on how to use the HTTPbuilder https://forum.infiniteautomation.com/topic/3137/how-http-publisher-to-firebase-cloud-messenger/3 Otherwise, you could customise the meta point to include the value and then only send the meta point on the publisher.

@cwangv said in Mango performance issues on Windows 10 PC: for the Java with free ram of 1.9GB as Hi @cwangv Terry would probably give better support here but I would start off by suggesting to send a trial request so you can use the NoSQL module and see if you are still having performance issues. The free version is not intended for commercial trials but for small home use cases and for students.

Thanks @MattFox

I can probably help here. I use it to construct my data reports into an email. Javascript: var model = {"crit": crit, "urgent": urgent, "warn":warn}; //print(JSON.stringify(model)); var template = com.serotonin.m2m2.Common.freemarkerConfiguration.getTemplate("datapoint_email.ftl"); var writer = new java.io.StringWriter(); template.process(model, writer); var emailContent = new com.serotonin.web.mail.EmailContent(null, writer.toString(), com.serotonin.m2m2.Common.UTF8); var recipients = ["fox@domain.com"]; com.serotonin.m2m2.rt.maint.work.EmailWorkItem.queueEmail(recipients, "Datapoint Summary", emailContent, null); Template <#assign key_list = crit?keys/> <!-- get keys --> <#list key_list as c> <!-- c is your array index --> <!-- markup fluff here --> <#list crit[c] as k,x> <!-- this point here would be your tmpRecs object --> <#assign row = row + 1/> <#if row == 2><#assign row = 0/></#if> <tr class="critrow<#if row == 1>Alt</#if>"> <td colspan="4">${x["id"]} </td> <td colspan="4"><span style="font-weight:bold">${x["deviceName"]}</span><span> : ${x["pointName"]}</span></td> <td colspan="4">${x["time"]} </td> <td colspan="4">${x["value"]} </td> </tr> <#else> <tr><td colspan="12">No Critical Items</td></tr> </#list> Would be good to see how you've laid out your model because that's what affects how the loop has to parse the data. Fox

@craigweb Hey Craig, thanks for helping with this. That is really strange since the user and workspaces are both very much active. I am using core version 3.7.7 and slackPublisher module 3.7.0.

Hi Christiaan If you need to keep your time-series data on the new instance you will need to use the full backups on the SQL and NoSQL DBS. If time-series data is not required you can use the JSON export and just move over what you require.

Hi @Robmalone You should also look at the document for <ma-point-statistics> it returns a statsObject which you can then use statsObject.last, statsObject.max etc. this would be a lot easier to use than <ma-point-values> you for purpose.

Thanks guys for checking. I wasn't sure if the new core upgrade was checking the database name and version. Cheers Brian

@iperry you have not missed anything, 1 attempt is made, there is no setting for the number of attempts.

Nicely done man! At least you know why now. Glad I could be a sounding board! Fox

@aniluoh said in QModMaster Simulator for Mac OS: Simulator QModMaster ModBus Looking for the mac supported simulator.

Basically you cannot represent 30.03 exactly in binary. The publisher is sending the raw value of the data point, which is represented by a Java double as the value you are seeing sent out 30.029... When using a TextRenderer (which only happens for display purposes) you can set it to round the value via the pattern on it. That is why in the UI it looks correct but it is actually stored as 30.029.... (11110.00000111101011100001)₂ = (1 × 2⁴) + (1 × 2³) + (1 × 2²) + (1 × 2¹) + (0 × 2⁰) + (0 × 2⁻¹) + (0 × 2⁻²) + (0 × 2⁻³) + (0 × 2⁻⁴) + (0 × 2⁻⁵) + (1 × 2⁻⁶) + (1 × 2⁻⁷) + (1 × 2⁻⁸) + (1 × 2⁻⁹) + (0 × 2⁻¹⁰) + (1 × 2⁻¹¹) + (0 × 2⁻¹²) + (1 × 2⁻¹³) + (1 × 2⁻¹⁴) + (1 × 2⁻¹⁵) + (0 × 2⁻¹⁶) + (0 × 2⁻¹⁷) + (0 × 2⁻¹⁸) + (0 × 2⁻¹⁹) + (1 × 2⁻²⁰) = (30.02999973297119140625)₁₀

@terrypacker said in Datafile Source - Datetime is in UTC: .withZone(DateTimeZone.UTC); Terry Packer for the win! Thanks for the amazing help.

@tungthanh500 said in Device disconnect and data logging: From 3PM to 9PM, the server is disconnected so I expect the value should be 0. Is there are any setting so I can make sure the logging value is 0 if server/power meter disconnected, therefore I or anyone can realize the abnormal and check the server/meter? Setting a point that is unhealthy to zero. would have a lot of unwanted consequences and create a lot of noise in your data when doing analytics on it... The point does indicate that it is unhealthy, just not on the chart. The live value will have an exclamation mark next to it. Also even if you do not log the point when it is unhealthy, your chart will still have the same shape... IF you want to be get notified when the point goes unhealthy you can set a "has not updated" event detector on the point and link the detector to an email event handler.

Check your ma.logs, if this thing is internet facing someone may have been hammering it causing the login to drop out in relation to max non-authenticated attempts being tripped.. Fox

The latest DNP3 module should solve your problem. Let us know if you have any problems with it. https://store.infiniteautomation.com/module/dnp3

This wholly depends on if you're using the SQL database to store values or the NoSQL database because it's on mango unit or a cloud installed setup. I'd wager you're using the NoSQL system which means you're gonna have to export, open with notepad, copy and paste the data to maintain the correct date-time format (excel likes to screw with it) then filter by the value column. With all of your filtered values, append the delete value in the final column, save, and reimport values to delete all unwanted values. Also note you can change your datapoint properties to filter and ignore extreme/unwanted values so they won't go into your system. Hope this is of some help Fox

@meverett without knowing exactly what the problem is it will be hard for us to diagnose/fix the bug. Can you provide a pcap file from WireShark for the communication for a few polls? It is either the read request for the data points OR the connection request to initialize the connection. Once I have some time I will take a look. I will admit it has been some time since I've decomposed any ABeIP packets but hopefully it will come back to me quickly!