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.

No, I agree it shouldn't be too easy; my concern was making sure it would restore the correct MangoES configuration, etc. That's the same concern I have with cloning the configuration from a fresh "Enterprise" install on a non-ES instance.

But I have my "default" config file now, so I can move forward simply.

Thanks!

Thanks Craig, so as can be seen @shubham, a cookie is in fact generated and part of the header payload.

Any idea?

I've mulled over what you have stated:

There is sql data source for pulling data in using sql queries but I don't know how complex your system is

A second option is using the http retriever and using the responses given to populate different points based upon the data given.

Not sure there's a 'best practice ' as I'm unaware if you're just bringing data across or you still need events to fire and meta points/scripts to trigger for given point data.
Can you expand on what you want to achieve then perhaps a better route can be taken.

Fox

@terrypacker ok, let me see if I have resolved this correctly or if you have a better method. In meta points, I can create binary points to be set upon Event Detectors. I can then create more meta points to combine those binary meta points into logical statements that can then be assigned Event Detectors. This would effectively be the same as a Compound Event Detector. This will work, albeit kind of an ugly solution.

Is this the best way to handle it or is there a better way?

At first I was hoping there was a way to add Event Detectors as context to a meta point, but not that I could see.

Thanks as always for your help.

what i could imagine to have a over layer chart, stacked column chart 90 deg turned, and hide the Y and X axis. What do you think? could that work? and where do i get this option from?

The url is inside the get call. Not the host part of the header.
You want to 'get' calll the page, you're calling the 192.168... at the root level of the server, not the relay page.

Secondly, your context point var is not used to correlate to being on or off. Since the point is an alphanumeric and not a numeric/binary, your parameters should be:

var parameters = { "turn": info }

You're calling a script but I think you are unaware of how everything works. I take it it has been a long time since you've done this.

I have performed further testing and found the above script needs an Execution delay of at least about 5 seconds to work. This is because if the 2 source data points update within a few seconds, the script is only triggered when the first one is updated, not the second one (ie the script won't trigger again within a few seconds of it running).
Unfortunately, further testing has indicated that the script no longer works reliably where there is a comms outage causing a delay in some of the data.

@jorge-gonzalez said in Script to convert from Hex to Dec:

13:32

@Jorge-Gonzalez, documentation to solve your problems.

Firstly see what parseInt does - https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/parseInt

There you can see that the hexdecimal value has to be in correct format be it with 0x or without. Your string splits 2 bytes in the hexdecimal format by using a colon. You need to remove it. Simply do it by utilizing .replace method on a string before putting it into parseInt. Or if you have a string which contains multiple values utilize .split method on a string and then put the bytes together before putting the value into parseInt.

Replace method explanation
https://www.w3schools.com/jsref/jsref_replace.asp

Split method explanation
https://www.w3schools.com/jsref/jsref_split.asp

Following function is following the detailed explanation you provided in the post.

function stringsplitter (string) { var result = {}; // This contains the bytes of data result.arrayofbytes = string.split(':'); // Get byte count of data inside the string result.bytecount = result.arrayofbytes.length; // Start at the beginning var variablecounter = 0; result.hexdata = []; result.decimaldata = []; // Loop over the array, but taking into account that we have 2 byte data, use try/catch so that function will return if something should fail try{ for (var x = 0;x < result.bytecount / 2;x++){ result.hexdata[x] = result.arrayofbytes[variablecounter] + result.arrayofbytes[variablecounter+1]; result.decimaldata[x] = parseInt(result.hexdata[x],16); variablecounter += 2; } }catch(err){ return err } // return object with all our data which includes hexdecimal data, decimaldata and byte count inside the string return result; } // Example usage var devicestring = '13:30:27:14:01:33:02:6c:02:76'; var data = stringsplitter(devicestring); //get array in hexdecimal and decimal format var hexdata = data.hexdata; var decimaldata = data.decimaldata; // first value in hexdecimal and decimal format var firstvaluehex = hexdata[0]; var firstvaluedecimal = decimaldata[0]; // Second value in hexdecimal and decimal format var secondvaluehex = hexdata[1]; var secondvaluedecimal = decimaldata[1]; // Following that your post had used an example with the last value var lastvalue = decimaldata[4]; // Should be 23 var lastvaluecorrected = lastvalue * 0.1 - 40;

Thomas

I would have thought that the HTTP Receiver would accept multiple point values at once, however I don't have the docs in front of me.

Not sure how your CURL request is authenticating.. You have an XSRF token but no session cookie. I would suggest using an authentication token for this kind of usage, then you don't need the XSRF token either.

@Phillip-Weeks I just implemented a Scripting Data source that runs this script and see no errors on Mango 3.6.6?

var dataPoints = JSON.parse(JsonEmport.dataPointQuery("eq(name,Voltage)&limit(1000)")).dataPoints; print(JsonEmport.dataPointQuery("eq(name,Voltage)&limit(1000)"));

I am searching for a point named Voltage

Output:

"dataPoints":[ { "xid":"voltage", "name":"Voltage", "enabled":true, "loggingType":"ON_CHANGE", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"INSTANT", "purgeType":"YEARS", "pointLocator":{ "dataType":"NUMERIC", "changeType":{ "type":"BROWNIAN", "max":100.0, "maxChange":0.01, "min":0.0, "startValue":"1" }, "settable":true }, "eventDetectors":null, "plotType":"STEP", "rollup":"NONE", "unit":"V", "simplifyType":"NONE", "chartColour":"", "chartRenderer":null, "dataSourceXid":"DS_997094", "defaultCacheSize":1, "deviceName":"Dashboard Demo", "discardExtremeValues":false, "discardHighLimit":0.0, "discardLowLimit":0.0, "intervalLoggingPeriod":15, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "preventSetExtremeValues":false, "purgeOverride":false, "purgePeriod":1, "readPermission":"user", "setExtremeHighLimit":1.7976931348623157E308, "setExtremeLowLimit":-1.7976931348623157E308, "setPermission":"", "tags":null, "textRenderer":{ "type":"ANALOG", "useUnitAsSuffix":true, "format":"#.00" }, "tolerance":0.0 } ] }

The cause must be specific to your system. Perhaps that specific point is corrupt? Try another point and if that doesn't work take a look at the logs and see if anything is being output about the error.

Thanks.

@phillip-weeks said in Bulk edit is giving Validation Error:

No BULK edit feature working is a pain since I the export for csv was removed .

There is a bulk edit feature It does work

@phillip-weeks said in Bulk edit is giving Validation Error:

So am I doing something incorrect here?

Yes, it sounds like you are. Check the value of the action column is set to the correct value, it should be CREATE, UPDATE or DELETE. For CREATE you can either set the xid column or leave it blank to autocreate an XID. For UPDATE you should set the originalXid column and the xid column (this is so you can change the XID of points). For DELETE you only need to set the originalXid column.

@ramhuzaini Were you able to connect to OPC servers on local machine? I am exploring mango and just can't see OPC servers installed locally on my PC. The server dropdown remains empty, which I assume should get filled with all registered OPC servers. Will appreciate any tips on how to correctly configure an OPC DA source in mango.

try to change localhost to 127.0.0.1

I did that and it worked.

If you want localhost to work you need to change your hosts file like the picture below.

I hope it helps.

@craigweb

Well it turns out, the device required the "Use multiple write commands only" to be turned on. Thanks for the help.

Hi David

Your images don't describe what is going wrong when you try to set the point.
Are there any data source alarms?