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.

Thank you very much Terrypacker. That works.

For anyone else wishing to use HTTP to retrieve these values from the SMA Webbox (if you cannot open another port to the device to use Modbus, for example), here an export of my data source and data point configuration that you may import into Mango:

{ "dataSources":[ { "xid":"DS_261176", "name":"PLANT_NAME", "enabled":true, "type":"HTTP_RETRIEVER", "alarmLevels":{ "PARSE_EXCEPTION":"NONE", "DATA_RETRIEVAL_FAILURE":"NONE", "SET_POINT_FAILURE":"NONE" }, "purgeType":"YEARS", "updatePeriodType":"MINUTES", "quantize":false, "retries":2, "setPointUrl":"", "timeoutSeconds":5, "updatePeriods":5, "url":"http:\/\/IP_OF_WEBBOX\/home.htm", "purgeOverride":true, "purgePeriod":1 } ], "dataPoints":[ { "xid":"DP_973514", "name":"Power", "enabled":true, "loggingType":"ON_CHANGE", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"INSTANT", "purgeType":"YEARS", "pointLocator":{ "dataType":"NUMERIC", "ignoreIfMissing":false, "setPointName":"", "settable":false, "timeFormat":"", "timeRegex":"", "valueFormat":"", "valueRegex":"<td id=\\\"Power\\\" class=\\\"tdcol1\\\">(.*) W<\/td>" }, "eventDetectors":[ ], "plotType":"STEP", "unit":"W", "chartColour":"", "chartRenderer":null, "dataSourceXid":"DS_261176", "defaultCacheSize":1, "deviceName":"DEVICE_NAME", "discardExtremeValues":false, "discardHighLimit":0.0, "discardLowLimit":0.0, "intervalLoggingPeriod":15, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "purgeOverride":true, "purgePeriod":1, "textRenderer":{ "type":"ANALOG", "useUnitAsSuffix":true, "unit":"W", "renderedUnit":"W", "format":"####.##" }, "tolerance":0.0 }, { "xid":"DP_348506", "name":"Daily Yield", "enabled":true, "loggingType":"ON_CHANGE", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"INSTANT", "purgeType":"YEARS", "pointLocator":{ "dataType":"NUMERIC", "ignoreIfMissing":false, "setPointName":"", "settable":false, "timeFormat":"", "timeRegex":"", "valueFormat":"", "valueRegex":"<td id=\\\"DailyYield\\\" class=\\\"tdcol1\\\">(.*) kWh<\/td>" }, "eventDetectors":[ ], "plotType":"STEP", "unit":"kW\/h", "chartColour":"", "chartRenderer":null, "dataSourceXid":"DS_261176", "defaultCacheSize":1, "deviceName":"DEVICE_NAME", "discardExtremeValues":false, "discardHighLimit":0.0, "discardLowLimit":0.0, "intervalLoggingPeriod":15, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "purgeOverride":true, "purgePeriod":1, "textRenderer":{ "type":"ANALOG", "useUnitAsSuffix":true, "unit":"kW\/h", "renderedUnit":"kW\/h", "format":"####.##" }, "tolerance":0.0 }, { "xid":"DP_288031", "name":"Total Yield", "enabled":true, "loggingType":"ON_CHANGE", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"INSTANT", "purgeType":"YEARS", "pointLocator":{ "dataType":"NUMERIC", "ignoreIfMissing":false, "setPointName":"", "settable":false, "timeFormat":"", "timeRegex":"", "valueFormat":"", "valueRegex":"<td id=\\\"TotalYield\\\" class=\\\"tdcol1\\\">(.*) MWh<\/td>" }, "eventDetectors":[ ], "plotType":"STEP", "unit":"MW\/h", "chartColour":"", "chartRenderer":null, "dataSourceXid":"DS_261176", "defaultCacheSize":1, "deviceName":"DEVICE_NAME", "discardExtremeValues":false, "discardHighLimit":0.0, "discardLowLimit":0.0, "intervalLoggingPeriod":15, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "purgeOverride":true, "purgePeriod":1, "textRenderer":{ "type":"ANALOG", "useUnitAsSuffix":true, "unit":"MW\/h", "renderedUnit":"MW\/h", "format":"####.###" }, "tolerance":0.0 } ] }

BTW, an alternative to using Modbus on the SMA Webbox is to use RPC (which requires no set up and can run on port 80). SMA have published the specification for it: http://files.sma.de/dl/4253/SWebBoxRPC-eng-BUS112713.pdf

When queried at a particular URL, the Webbox returns a JSON string of the entire plant parameters. All it needs is for someone to write a Mango module for it!

Attachment: download link

Thanks your detail answer!!!

:) :) :)

yes .

I find the meta module have the funcation for this .

I have built a module that meta module .

and I connect a datapoint .then
I setting condition for this .

then I in report module choose the meta point .

Every is ok.

Thank you for your tips.

I have change my log in /M2M2/WEB/logo.png.

Then When I test report modules I can received the newest modules.

ok.I will test if first for every function.

Thanks phildunlaps!!!

In the forum have lot of meta point example.

Thanks JoelHaggars for your detail answer!!!

The mango version is 2.4.0.

Yes .Thank JoelHaggars.

You are right. When I use bleow command .the covert db is ok.

grant all privileges on db.* To 'username'@'localhost' identified by 'password';

Thank for your suggestion!

I will follow your suggestion and step to post my question in the fu
ture.
I think this is misunderstand. If you have any suggestion,please let me know.If you donot tell me and maybe I will misunderstand deeply.

Thanks again!!!

When I in Port find "dev/ttys0" and "dev/ttys1", When I choose "/dev/ttyS0", In "point locator test" test and display "There was a problem testing the locator. (com.serotonin.io.serial.SerialPortException: Port In Use: /dev/ttyS0)" ,when I choose "/dev/ttyS1", In "point locator test" test and display “Main equipment malfunction:1”,

Any suggestion?

BR

Hi.
I spent 4 days to research the mango connect the RS232 /RS485 device .it is not sucessful. so unhappy for this .

I use hypertermial is very easy to connect the device and can received the data .but I want to mango to conncet the device .so I use Serial Test Data Source .and setting as attachment.

But test it for many time . I donot know how to solve it . whether mango conncet serial (rs232) is so complex?

thank in advance!

Attachment: download link

Thanks,Joels.
In meta if I have 15 value,(I have set cron in the meta),from the 15th value start ,when 15th.value>2,then end.no need to continute 14th value. if 15th<2, then 14th value to compare with 2.if 14th.value>2 ,then end . if 14th.value<2, then 13th will compare with 2. if every value all 15 is less than 2.then will undisplay vlaue. this is my script. Is it right? Need your modify.

Thanks

var n=1
switch (n)
{
case 1:
if (p15.value>2.0)
{ return p15.value;}

break;
case 2:
if (p15.lastValue(1)>2.0)
return p1.lastValue(1);
break;
case 3:
if (p15.lastValue(2)>2.0)
return p1.lastValue(2);
break;
case 4:
if (p15.lastValue(3)>2.0)
return p1.lastValue(3);
break;
........
case15
if if (p15.lastValue(15)>2.0)
return p1.lastValue(3);
break;
return (NaN);

}

No this is not supported.

Thanks Phil. Historical syncing mostly works fine now with both instances running the latest core (2.4.2) and persistent module (1.4.7). I still have a few questions, mainly on the historical syncing behaviour and point replication behaviour, but I'll work on those myself before posting again.

yes. I will purchase the mango later.

Hi

I have a MangoES system with about a hundred points that I want to publish using persistent TCP. I plan to add more, too.

Is there a way to bulk add all points on the system to the publisher rather than select them one by one?

It would be nice too (feature suggestion!) if there were a checkbox to say 'automatically add new points created on this mango instance to publisher' or similar.

Cheers

Hi, thanks for the information.

We have identified some improvements in the serial data source. Take a look at this thread: http://forum.infiniteautomation.com/forum/posts/list/15/1813.page there is an updated serial module you can download and test at the bottom of the thread. If you could also send your scripts we can take a look at those but I think upgrading the serial data source would be a good first step.

Thanks,
Joel.

Hi, I am just starting out with Mango Automation. My hardware is Spark Core (spark.io).
I am trying to use HTTP Retriever to get sensor values exposed through spark API.
I am having similar trouble with parsing the html response with regex. I haven't been able to replicate the results that worked at regexpal.com. Any help with this would be very much appreciated. Thanks!

My response looks like:

{
"cmd": "VarReturn",
"name": "Outlet4State",
"result": 0,
"coreInfo": {
"last_app": "",
"last_heard": "2014-08-25T00:55:52.299Z",
"connected": true,
"deviceID": "xx"
}
}

All I care about now is the binary output "result"

Good that you solved your issue and props to you for following up with how you solved it.

Just so you know, 'localhost' (or its IP equivalent, 127.0.0.1) are special addresses that always refer to the loopback interface of the machine you're on. Typing 'localhost' into your mobile phone tells it to look for a website being served on.. itself!