• Recent
    • Tags
    • Popular
    • Register
    • Login
    1. Home
    2. leoboeng
    3. Topics

    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.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website
    L
    • Profile
    • Following 2
    • Followers 0
    • Topics 13
    • Posts 62
    • Best 0
    • Controversial 0
    • Groups 0

    Topics created by leoboeng

    • L

      Update Data Point

      Scripting general Discussion
      • • • leoboeng
      4
      0
      Votes
      4
      Posts
      2.2k
      Views

      phildunlapP

      I am not certain what you are seeing, you make it sound like it is not running at all? You didn't include validate output. Maybe this is a meta point and the context point is disabled?

      While I omit the wildcard for year in my cron patterns, that shouldn't be the cause.

    • L

      BacNet IP not connected

      Mango Automation general Discussion
      • • • leoboeng
      9
      0
      Votes
      9
      Posts
      3.4k
      Views

      phildunlapP

      You want to read the logBuffer property, I guess.

      I didn't test this script (I don't have a BACnet device with a trend log on hand), but I adapted it from this thread to print the LogRecord objects in the 'logBuffer' property of Trend Log object number 1: https://forum.infiniteautomation.com/topic/3117/bacnet-scheduler

      //Get the local device config from a configured bacnet data source. //Edit DS XID var localDeviceConfig = com.serotonin.m2m2.db.dao.DataSourceDao.instance.getByXid("DS_354e2188-4867-431b-9051-bca39b011ed7").getLocalDeviceConfig(); localDeviceConfig = com.serotonin.ma.bacnet.device.LocalDeviceDwr.getLocalDevice(localDeviceConfig); var listener = new com.serotonin.ma.bacnet.ScriptableDeviceEventListener(); listener.registerListenerExceptionHandler( function(excp) { print("Listener Exception"); }); listener.registerIAmReceivedHandler( function(removeDevice) {print("Remote device");}); listener.registerAllowPropertyWriteHandler( function(from, obj, pv) {print("Allow property write");}); listener.registerPropertyWrittenHandler( function(from, obj, pv) {print("Property written");}); listener.registerIHaveReceivedHandler( function(removeDevice, removeObject) {print("I have received");}); listener.registerCovNotificationReceivedHandler( function(subIdentifier, initDeviceIdentifier, monitoredObjectIdentifier, timeRemaining, listOfValues) {print("COV notification");}); listener.registerEventNotificationReceivedHandler( function(processIdentifier, initDeviceIdentifier, eventObjectIdentifier, timestamp, notificationClass, priority, eventType, messageText, notifyType, ackRequired, fromState, toState, eventValues) {print("Register event notification received");}); listener.registerTextMessageReceivedHandler( function(textMessageSourceDevice, messageClass, messagePriority, message) {print("Text message received");}); listener.registerSynchronizeTimeHandler( function(from, dateTime, utc) {print("Sync time received");}); listener.registerRequestReceivedHandler( function(from, service) {print("Request received");}); var localDevice = com.serotonin.ma.bacnet.device.LocalDeviceFactory.getLocalDevice(localDeviceConfig, listener); //print(localDevice); try { //Create the read request... See com.serotonin.bacnet4j.type.enumerated.ObjectType for object types var objectIdentifier = new com.serotonin.bacnet4j.type.primitive.ObjectIdentifier(com.serotonin.bacnet4j.type.enumerated.ObjectType.trend Log, 1); //EDIT: object instance number var propertyIdentifier = com.serotonin.bacnet4j.type.enumerated.PropertyIdentifier.logBuffer; var readRequest = new com.serotonin.bacnet4j.service.confirmed.ReadPropertyRequest(objectIdentifier, propertyIdentifier); //Get the remote device and send the request, edit the remote device number var remoteDevice = localDevice.getRemoteDeviceBlocking(123); var result = localDevice.send(remoteDevice, readRequest).get(); //result should be a read service ack that we can hopefully get a com.serotonin.bacnet4j.type.constructed.BACnetArray of com.serotonin.bacnet4j.type.constructed.LogRecord from var logRecords = result.getValue(); //now iterate this list and do what for(var k = 0; k < logRecords.size(); k+=1) { print(logRecords.get(k).toString()); } } finally { com.serotonin.ma.bacnet.device.LocalDeviceFactory.releaseLocalDevice(localDevice, listener); }

      You may need to edit the data source xid, object instance number, and remote device id, as noted in the comments.

    • L

      Problem with Pie Chart

      Dashboard Designer & Custom AngularJS Pages
      • • • leoboeng
      17
      0
      Votes
      17
      Posts
      5.1k
      Views

      MattFoxM

      @craigweb that's what I've been trying to get him to do all along. I was going to suggest using toFixed or even parseFloat but he wanted significant figures without rounding.

    • L

      Pie Chart

      Dashboard Designer & Custom AngularJS Pages
      • • • leoboeng
      6
      0
      Votes
      6
      Posts
      1.9k
      Views

      L

      @phildunlap Yes it is a numerical point rendered with unity. They are power measurements, no conversions are made, the values are pulled directly from a ModBus TCP / IP meter.

    • L

      Excel Report

      User help
      • • • leoboeng
      16
      0
      Votes
      16
      Posts
      4.0k
      Views

      L

      @phildunlap said in Excel Report:

      the top section of /system_settings.shtm

      I just checked the top section of /system_settings.shtm and I actually saw that you are using H2.

      I think it was something of the update, because I made an update and since then it did not work anymore, but before that it was like MYSQL.

      I will pass the database to MYSQL and check if the error will continue.

    • L

      Latest point values

      Dashboard Designer & Custom AngularJS Pages
      • • • leoboeng
      5
      0
      Votes
      5
      Posts
      1.6k
      Views

      L

      It worked, thank you.

    • L

      Point Filter

      Dashboard Designer & Custom AngularJS Pages
      • • • leoboeng
      3
      0
      Votes
      3
      Posts
      1.3k
      Views

      L

      @jared-wiltshire When I search the point and select it loads the data, then when I leave the text box the point does not appear, as in the second image I sent, there the only thing I did was click outside the text field of the filter point. I wish that when he clicked off he kept the point there as selected.

    • L

      Data Sources Does Not Appear

      User help
      • • • leoboeng
      17
      0
      Votes
      17
      Posts
      6.0k
      Views

      N

      @dan I have the same issue after updating Mango to the core v3.7.7
      Chrome version is 92.0.4515.131 (Official Build) (64-bit)

      When I switch to the old interface and switch to the Datasources tab, the list of data sources does not appear, just the empty white space. The data point tab works well. In the new interface, everything is alright.

      When checking the browser's console I found there a bunch of errors like this ones:

      Note: The actual IP address is removed and changed with <IP_address> tag.

      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/layout/TabController.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/layout/StackController.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/Menu.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/DropDownMenu.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/_MenuBase.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/_KeyNavContainer.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/_KeyNavMixin.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/MenuItem.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/layout/ScrollingTabController.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/PopupMenuItem.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/_WidgetsInTemplateMixin.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/CheckedMenuItem.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE
      DevTools failed to load source map: Could not load content for http://<IP_address>/resources/dijit/MenuSeparator.js.map: HTTP error: status code 404, net::ERR_HTTP_RESPONSE_CODE_FAILURE

    • L

      system drops

      User help
      • • • leoboeng
      9
      0
      Votes
      9
      Posts
      2.3k
      Views

      phildunlapP

      @phildunlap said in system drops:

      You would need a license or Mango would shut down on a timer. But yeah, you could install it and migrate your data from your existing H2 database on the /mango_no_sql.shtm page.

      I told you that you would need a license to use NoSQL. This is all in the context of the memory issue. If that is not occurring any longer, great! It's possible you either increased the available memory as discussed, or that your point values table was large.

    • L

      Point Values

      User help
      • • • leoboeng
      3
      0
      Votes
      3
      Posts
      1.3k
      Views

      phildunlapP

      Hi guys,

      Series are limited to millisecond resolution for storing values and if using the NoSQL database will not have more than one value at one millisecond.

      The charting limit is indeed 5001 by default and can be changed. https://forum.infiniteautomation.com/topic/2983/increase-the-5001-limit-on-values-in-the-new-dashboards-ui

      TLDR Administration --> UI Settings

    • L

      Excel Report

      Mango Automation general Discussion
      • • • leoboeng
      2
      0
      Votes
      2
      Posts
      914
      Views

      phildunlapP

      Hi leoboeng,

      The error implies that you have created a formula in your excel report based on a named range that is not defined. So, if you have a named range like 'range' but your forumla is '=SUM(arange)' that mismatch will produce the shown error (provided there is no named range 'arange' in the worksheet).

      Posting a screenshot of error text is not as useful as posting the content of the error. Images are not searchable.

      Here's the text of the error from my reproduction:

      ERROR 2018-05-04T13:29:19,095 (com.infiniteautomation.mango.excelreports.rt.ExcelReportWorkItem.execute:673) - Specified named range 'BARange' does not exist in the current workbook. org.apache.poi.ss.formula.FormulaParseException: Specified named range 'BARange' does not exist in the current workbook. at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:910) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:501) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:322) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1540) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1498) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1485) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1858) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1986) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1970) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1927) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.Arguments(FormulaParser.java:1471) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:1343) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:896) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:586) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:322) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1540) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1498) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1485) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1858) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1986) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1970) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1927) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.intersectionExpression(FormulaParser.java:1900) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1880) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:2028) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:170) ~[poi-3.17.jar:3.17] at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:85) ~[poi-ooxml-3.17.jar:3.17] at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:276) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:220) ~[poi-3.17.jar:3.17] at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:64) ~[poi-ooxml-3.17.jar:3.17] at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateFormulaCellEnum(BaseFormulaEvaluator.java:192) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateAllFormulaCells(BaseFormulaEvaluator.java:267) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateAllFormulaCells(BaseFormulaEvaluator.java:258) ~[poi-3.17.jar:3.17] at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateAllFormulaCells(XSSFFormulaEvaluator.java:72) ~[poi-ooxml-3.17.jar:3.17] at com.infiniteautomation.mango.excelreports.rt.ExcelReportWorkItem.execute(ExcelReportWorkItem.java:649) [excel-reports-3.4.1-SNAPSHOT.jar:?] at com.serotonin.m2m2.rt.maint.BackgroundProcessingImpl$WorkItemRunnable.run(BackgroundProcessingImpl.java:676) [classes/:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) [?:?] at java.lang.Thread.run(Thread.java:844) [?:?]
    • L

      Gauges Function AmCharts

      Dashboard Designer & Custom AngularJS Pages
      • • • leoboeng
      35
      0
      Votes
      35
      Posts
      20.8k
      Views

      Jared WiltshireJ

      @leoboeng The new UI module has been released.

    • L

      Add point value to amCharts

      Dashboard Designer & Custom AngularJS Pages
      • • • leoboeng
      16
      0
      Votes
      16
      Posts
      4.2k
      Views

      Jared WiltshireJ

      @leoboeng said in Add point value to amCharts:

      Hello, I was trying to see other graphics and I could verify that some graphs of example also do not appear, I add values but nevertheless does not appear image.

      Already add values to the Pie Chart and no picture appears.

      This was a bug in the UI module which was fixed in the latest release.