• C
    cuihe

    @craigweb I think this protocol is important. And many hardware supports this protocol. Does Mango have a timetable to support this?

    Or is there a way to indirectly support the hardware of this protocol?

    Or is there a manual support method? Now I have passed c# to Read and Write my hardware.

    posted in Mango Automation general Discussion read more
  • C
    cuihe

    I found an OPCDA protocol data-source. And I use Mango OPCDA to connect my OPCDAserver. Successed!
    But I dont find OPCUA protocol data-source. Is there something I missed?
    How to connect my OPCUAserver and read&write data?

    posted in Mango Automation general Discussion read more
  • C
    cuihe

    I was not so clear with this thing, but it do solved!

    here is my solution:
    "connectionUrl":"jdbc:mysql://localhost:3306/test",
    "driverClassname":"com.mysql.jdbc.Driver",

    Note: replace "localhost" "3306" "test" if needed.

    posted in Development general discussion read more
  • C
    cuihe

    //your code here
    {
       "dataSources":[
          {
             "xid":"DS_64b30a4f-d8c2-4b8a-9978-1b9c085893b6",
             "name":"test_SQL",
             "enabled":false,
             "type":"SQL",
             "alarmLevels":{
                "POLL_ABORTED":"URGENT",
                "STATEMENT_EXCEPTION":"URGENT",
                "DATA_SOURCE_EXCEPTION":"URGENT"
             },
             "purgeType":"YEARS",
             "updatePeriodType":"SECONDS",
             "connectionUrl":"192.168.61.191:3306",
             "driverClassname":"MySQL",
             "password":"1234",
             "rowBasedQuery":false,
             "selectStatement":"select * from biao;",
             "updatePeriods":5,
             "username":"root",
             "editPermission":"",
             "purgeOverride":false,
             "purgePeriod":1
          }
       ]
    }
    

    It's not clear what "driverClassname" means.
    The database I use is MySQL, what should i type in ? "com.mysql.jdbc.Driver"(same error below)?

    when I click "SQL Statement Testing", It shows an error: class java.lang.ClassNotFoundException: MySQL

    posted in Development general discussion read more
  • C
    cuihe

    @craigweb thank you first!
    I don't know if what I'm offering is what you want.
    here is "dashboard code":

    <ma-point-value id="e76d6d6c-45f1-440c-90f3-c446aa6c87b6" enable-popup="hide" style="position: absolute; left: 399px; top: 75px; width: 25px; height: 25px;" point-xid="DP_c6eebfd0-d128-4ea2-8bf1-77f7cf355edd"></ma-point-value>
    <ma-switch id="078c0795-8eba-4cc1-9166-f62c62de3af6" style="position: absolute; left: 394px; top: 220px; width: 50px; height: 50px; background-color: rgb(0, 46, 92);" point-xid="DP_da02f5a8-afc1-4ecb-ba8c-403ffe6345dd"></ma-switch>
    

    here is dataSource-dataPoint(SET_LIGHT):
    (also, I use mango-publisher to publish this. In this way I control my light)
    (<ma-switch> Connect with this)

    {
       "dataPoints":[
          {
             "xid":"DP_da02f5a8-afc1-4ecb-ba8c-403ffe6345dd",
             "name":"Light01_print",
             "enabled":true,
             "loggingType":"ON_CHANGE",
             "intervalLoggingPeriodType":"MINUTES",
             "intervalLoggingType":"INSTANT",
             "purgeType":"YEARS",
             "pointLocator":{
                "dataType":"BINARY",
                "changeType":{
                   "type":"NO_CHANGE",
                   "startValue":"0"
                },
                "settable":true
             },
             "eventDetectors":[
             ],
             "plotType":"STEP",
             "rollup":"NONE",
             "unit":"",
             "templateXid":"Light",
             "simplifyType":"NONE",
             "chartColour":"",
             "chartRenderer":{
                "type":"TABLE",
                "limit":10
             },
             "dataSourceXid":"DS_afafb004-8328-49e6-8bbb-1e5520c377d8",
             "defaultCacheSize":1,
             "deviceName":"TEST2",
             "discardExtremeValues":false,
             "discardHighLimit":1.7976931348623157E308,
             "discardLowLimit":-1.7976931348623157E308,
             "intervalLoggingPeriod":15,
             "intervalLoggingSampleWindowSize":0,
             "overrideIntervalLoggingSamples":false,
             "preventSetExtremeValues":false,
             "purgeOverride":false,
             "purgePeriod":1,
             "readPermission":"",
             "setExtremeHighLimit":1.7976931348623157E308,
             "setExtremeLowLimit":-1.7976931348623157E308,
             "setPermission":"",
             "tags":{
             },
             "textRenderer":{
                "type":"BINARY",
                "oneColour":"#99ff99",
                "oneLabel":"",
                "zeroColour":"#c0c0ee",
                "zeroLabel":""
             },
             "tolerance":0.0
          }
       ]
    }
    

    here is dataSource-dataPoint(GET_LIGHT):
    My light send HTTP message to Mango.

    {
       "dataPoints":[
          {
             "xid":"DP_c6eebfd0-d128-4ea2-8bf1-77f7cf355edd",
             "name":"light01",
             "enabled":true,
             "loggingType":"ON_CHANGE",
             "intervalLoggingPeriodType":"MINUTES",
             "intervalLoggingType":"INSTANT",
             "purgeType":"YEARS",
             "pointLocator":{
                "dataType":"BINARY",
                "binary0Value":"false",
                "includeTimestamp":false,
                "parameterName":"light01",
                "setPointName":"",
                "settable":false
             },
             "eventDetectors":[
             ],
             "plotType":"STEP",
             "rollup":"NONE",
             "unit":"",
             "templateXid":"ReadLight",
             "simplifyType":"NONE",
             "chartColour":"",
             "chartRenderer":{
                "type":"TABLE",
                "limit":10
             },
             "dataSourceXid":"DS_0638891e-846e-4413-a3d3-c5b5596f688a",
             "defaultCacheSize":1,
             "deviceName":"light_source",
             "discardExtremeValues":false,
             "discardHighLimit":1.7976931348623157E308,
             "discardLowLimit":-1.7976931348623157E308,
             "intervalLoggingPeriod":15,
             "intervalLoggingSampleWindowSize":0,
             "overrideIntervalLoggingSamples":false,
             "preventSetExtremeValues":false,
             "purgeOverride":false,
             "purgePeriod":1,
             "readPermission":"",
             "setExtremeHighLimit":1.7976931348623157E308,
             "setExtremeLowLimit":-1.7976931348623157E308,
             "setPermission":"",
             "tags":{
             },
             "textRenderer":{
                "type":"BINARY",
                "oneColour":"#eeee00",
                "oneLabel":"亮",
                "zeroColour":"#c0c0ee",
                "zeroLabel":"灭"
             },
             "tolerance":0.0
          }
       ]
    }
    

    [virtual data source] and [<ma-switch> control and show data] work well
    [virtual data publisher] work well
    [hard device (light)] work well
    [<ma-point-value> receive HTTP msg and show value] work well
    The problem is that when someone controls the light from other systems, <ma-point-value> displays normally and the <ma-switch> does not.
    (Of course I know because the data is not connected. but how)
    (Please let me know what else you need.)

    posted in Development general discussion read more
  • C
    cuihe

    Sorry, my title is not very clear.

    • I have a dataSource from HTTP receiver. Here we set the datapoint's name GET_LIGHT.
      I dessigned a dashboard. using "Point Value" to show GET_LIGHT's value. <- work well

    • I have a dataSource from Virtual data source. Here we set the datapoint's name SET_LIGHT.
      at the same dashboard. using "Binary Switch Button" to control SET_LIGHT's value. <- work well

    • when they work together, Control the "Binary Switch Button" and "Point Value" changed(Although they are not directly connected). <- work well

    • BUT, when another controller change the light(such as using light_switch at scene). "Point Value" in dashboard can change. "Binary Switch Button" can NOT change(because the Virtual data source not change). <- problem here

    I'm not very proficient in using Mango system.
    is there a way when GET_LIGHT changed making the Virtual data source SET_LIGHT change as well?
    Or I dont need a Virtual data source, another way to solve this problem?

    review this topic title, How can I describe this problem in one sentence? ^_^

    posted in Development general discussion read more
  • C
    cuihe

    thank you!

    I think I need to improve myself for some time.
    It's simpler to use Mango.

    posted in Development general discussion read more
  • C
    cuihe

    I think I understand. Thank you very much!

    posted in Development general discussion read more