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.

@psysak It me a bit to figure out the right Java version for the Mac M1 but this is the version I installed: java -version openjdk version "11.0.11" 2021-04-20 LTS OpenJDK Runtime Environment Zulu11.48+21-CA (build 11.0.11+9-LTS) OpenJDK 64-Bit Server VM Zulu11.48+21-CA (build 11.0.11+9-LTS, mixed mode)

Hi @psysak As of version 3.4.3 there is a configurable rate limiter in the env.properties file. https://forum.infiniteautomation.com/topic/3552/version-3-4-3-released

Works like a charm.

@phildunlap said in Thank you to everyone for the help: The versatility of Mango could lead you back to it even if you find yourself in another industry, or perhaps even tinkering with home automation systems, and you'll be welcomed back should it! Absolute fact, I'll most likely do some stuff around the house with it. The melding of the old school controls world with modern API's, web based stuff etc is pretty impressive and powerful! I'll be working a lot with Haystack in my next adventure so if there's some opportunity to bring Mango into the fold I will do what I can to make that happen.

Possibly if you split/explode the string (alphanumeric point value) by the separators into an array then convert each value to a numeric.... Then you can apply your mathematical analysis...

Hi psysak, Here are some resources and previous threads that have some example filters defined in the user module in the UI settings. https://help.infiniteautomation.com/getting-started-with-a-user-module/ https://forum.infiniteautomation.com/topic/3503/how-to-chart-with-data-points-in-the-x-axis-instead-of-time https://forum.infiniteautomation.com/topic/2982/problem-with-assigning-value-using-mypoint-renderedvalue Jared also linked to a lot of AngularJS documentation that may be helpful here: https://forum.infiniteautomation.com/topic/3603/sorting-an-output-array-of-ma-point-statistics

Yep, please let me know how you get on, the feedback is always welcome.

The @phildunlap answer bot, now with automated self debugging

No such eureka! picture exists. If you clone the code into an IDE you can at least view the definition of one or another function with a hotkey like F3, which can let you scoot around the code faster. Generally scripts were intended to get something like the name or other DataPointVO information via the DataPointWrapper in the script documentation, like, p.getDataPointWrapper().getName();

Hmm that's interesting, that seems to be a new behaviour for Excel 365 cause my process hasn't changed, I always used to use Excel. Curious... K thanks, at least there's an explanation :)

Hi psysak, There are a few ways you could go about it, Build a UI widget that POSTs to the /rest/v2/point-values endpoint. [ { "xid": "DP_Num_Example", "timestamp": 1557250438657, "dataType": "NUMERIC", "value": 123.456 } ] Encode the date and rate information into one or more points, then trigger a scripting data source which "Saves historic" to .set(value, timestamp) to the appropriate points. I may set an alphanumeric to 52.13~1557250438657 which is a context point that updates the context of a script which simply splits the string on ~ and turns it back to numbers. Neither of these methods would cause point events to run currently (no websocket notification of the new value, , but the value would be available for recalculating meta point histories, for instance.

@psysak This will be a lot easier in Mango 3.6, stay tuned.

Yes. The only thing to add to be fully correct is that start times are inclusive, end times are exclusive (at the millisecond level).

It will be possible in 3.6 via //add ExcelReportVO available under 'report' variable name for post processing script for(var k = 0; k < report.getTimeSeries().length; k+=1) { //epoch time of time series beginning and end, for actual run var startTimestamp = report.getTimeSeries()[k].getStartTimestamp(); var finishTimestamp = report.getTimeSeries()[k].getFinishTimestamp(); }

Check filestore permissions under administration->system-settings->permissions for a start. Fox

Phil, is there a resource I can refer to for documentation on the available methods? Jared showed me the API docs for the front end, I'd love to have something similar for backend. There are certainly many documents about the backend, but the depth of those certainly does leave some questions unanswered. I guess to that hole I try to be the best resource I can to expand that here on the forum for intrepid searchers, but the code is open source which is of course the definitive documentation. https://github.com/infiniteautomation/ma-core-public/blob/main/Core/src/com/serotonin/m2m2/rt/script/PointValueTimeStreamScriptUtility.java perhaps find via https://github.com/infiniteautomation/ma-core-public/search?q=PointValueQuery&unscoped_q=PointValueQuery Definitely a lot easier if cloned into an IDE so that you can easily follow any particular class to its definition (which for some reason I think github willfully will never support). I use eclipse. Kind of on that same note, is there a way to setup something like MS Code for Mango dev and code in that? I'm always just using like a Scripting DS which is frustrating cause there's no auto completion or anything like that. Unfortunately I do not know a way to get code completion to our script edit boxes, but it would be awesome. I have a somewhat skewed perspective of how challenging this issue is since I've committed a lot of class names and package paths and whatnot to memory at this point. The editor is the "ace" editor, and it looks like custom autocompletion does have some amount of support, but I'm not familiar with what's truly possible: https://github.com/ajaxorg/ace/issues/110 I think that combined with being able to print out would be gold. Not sure what you mean print out. Some things do have useful toString methods defined, but others will still give you the classname, which is still useful if you have the source code. Because it's Java, one could write a global scripts function that does the necessary reflection to print out all the method names, for instance (perhaps one is trying to call some of the classes / modules that are not open source!). But, at that point it's maybe easier to ask on the forum!

I don't suppose he's using Linux / Mac, and/or Windows 10 with the bash command? If so, I'd almost certainly do it with some sed commands in a bash script. If not, I agree with Jared that a frontend solution may be good. You could build your colleague a simple sanitize.html page with two textbox elements, and upon change in the input invoke a function to transform it to the output, function transformInputCSV() { var input = document.getElementById("inputTextbox").value; var output = input.replace(/your regex here/, "You're replacement text"); // ouput = output.replace(.....) document.getElementById("outputTextbox").value = output; } Here's the HTML for such a page, which he could open in a browser, <html> <head> <script> function transformInputCSV() { var input = document.getElementById("inputTextbox").value; var output = input.replace(/your regex here/, "Your replacement text"); // output = output.replace(.....) document.getElementById("outputTextbox").value = output; } </script> </head> <body> <div><textarea id="inputTextbox" onchange="transformInputCSV()"></textarea></div> <div><textarea id="outputTextbox" ></textarea></div> </body> </html> But it would be possible to tie Mango into things if there is a reason to. Have you checked out the API endpoints for the data file data source? One permits you to submit files for immediate processing, and there's no reason an importer could not simply place the post-processed file in the filestore for a user this user has access to.

You could also just stick something on your page to reset the date range if they try - <ma-calc input="dateBar.from" on-change="startOfMonth = ('now' | maMoment:'startOf':'month'); $value > startOfMonth && (dateBar.from = startOfMonth.toDate())"></ma-calc> <ma-calc input="dateBar.to" on-change="startOfMonth = ('now' | maMoment:'startOf':'month'); $value > startOfMonth && (dateBar.to = startOfMonth.toDate())"></ma-calc>

Hii You can also use https://onlinejsontools.org/ for json validator,beautify,minify,xml,yaml,CSV,bson,plain text,base64,tsv. Do checkout this site!