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.

Hi Fox,

I've been using CONTEXT.getRuntime() but I strongly get the feeling that this value is constant for when the script is fired - including when I do a force recalculate history.

As in the value is the same for each historical execution? That is not the intended behavior, nor what I observed with an Alphanumeric meta point that was doing,

return CONTEXT.getRuntime();

and then regenerated history. I could clearly see, whether my point was executing on a cron or context update, that the time returned was not the same. However, it does not change throughout the execution of the script, so,

print(CONTEXT.getRuntime()); //time the script kicked off RuntimeManager.sleep(1000); print(CONTEXT.getRuntime()); //still the time the script kicked off

You may also in some occasions want to use CONTEXT.getTimestamp(), which should always be the time of the triggering event without the possibility of server load delaying task execution by a few (or many) milliseconds creeping in as with the runtime (really only affects live values).

If you're still doing the same sort of thing I'm curious why you'd switch over to the PointValueQuery tool instead of using the last() calls like before. I didn't get too deep into what that last script is trying to achieve. Maybe the issue is that during history generation last() doesn't work properly? You could use

var pvt = p.pointValueBefore(CONTEXT.getTimestamp()+1); var pvt2 = p.pointValueBefore(pvt.time);

@craigweb said in How to data logging to database MySQL ?:

HI @training

Do you mean converting your Mango to use MySQL then you can follow this document?
You should already have an instance of MySQL ready for mango to connect to.
https://help.infiniteautomation.com/database-conversions/?rq=mysql
and
https://forum.infiniteautomation.com/topic/3559/convert-from-h2-to-mysql-database-guidelines/6

If you want your time series data to log into MySQL you will need to uninstall the MangoTSDB module. Which will make mango use the MySQL DB.

Thank you ! i don't get to data logging each tag such as logging data Data points

@davide27 said in DataPoint values into a var javascript:

I need to download a csv file with the values ​​of multiple data points, but not all values ​​have the same timestamp. For this reason, I would like to have the values in a variable so I can process it and write it all in one line.

Please have a play with the CSV download from the watch list. Try it with different rollup options and see if you can get something that works for you. If this suffices I can give you an example of a new URL you can use in the example I posted above.

The reason I am suggesting this is because it will be easier for you, I have given you suggestions on how to proceed if you really want to process the values using JavaScript but you haven't given me any indication that you have looked at the documentation I referenced.

Yeah, the JSON receiver has two receive types, one for legacy support and one for the more intuitive way it works. The legacy (Parameter receive type) use is presented here: https://forum.infiniteautomation.com/topic/2642/how-to-use-http-json-receiever-to-receive-the-data-with-is-by-json-format

For the more intuitive format, where the whole POST body is JSON for instance and the content type is application/json, then the "HTTP parameter name" field needs to be a JSON pointer. Someone linked in this thread to a tool to help craft JSON pointers: https://forum.infiniteautomation.com/topic/3029/json-retriever-documentation-missing/5

But in short it's like a path, like
/ on an alphanumeric point should catch the whole JSON object.
/key should get whatever is at {"key":...}
/keyToArray/5 should get the fifth index of the array at {"keyToArray":[...]}

Perfect thanks this worked. I had a disabled data source on the cloud with xid's same as the new ones coming from the ES so I had to remove these and it recreated them in the persistent source, perfect.

Thanks, I will take a look at these options.

Thanks it works fine! I use auto-update so I need live data. Just add "array.slice(1,-1) and remove virtual data.

In the last image you posted, the points' variable names are p385 and p386 but in the script body they're being referred to as passwordPointp385 and passwordPointp386, so that is why you got the reference error. As Craig said you'll want to use the actual hexidecimal password (or if it's just a number remove the 0x before the number for decimal) instead of 0xdeadbeef, which is just one of the many things which can be spelled in hexidecimal.

if the customer change the current password, how we will get the new hex value?
I will appreciate so much your support

You will be told the value they changed it to, I would expect, then you could change it. If you want to, you could store the password in a point and then send the value of the point. Then when the password changes you just set a new value to the point.

Thanks for helping out @CraigWeb @phildunlap @Jared-Wiltshire ,

I couldn't get it to work with a Persistent TCP data on central server, so set up on an ES on Site and it seems to be tracking good. All the 4's and 1's are lining up where I expect them.

Thanks Again.

I got this to work:

var prevVal = p709.lastValue(2); var thisVal = p709.lastValue(1); var nextVal = p709.lastValue(); if (thisVal >= prevVal && thisVal >= nextVal) { // peak return 4; } else if (thisVal >= prevVal && thisVal < nextVal) { // still climbing return 3; } else if (thisVal < prevVal && thisVal < nextVal) { // trough return 1; } else { // falling return 2; }

0_1547002473983_mangoChart.png

Yes, it is possible to have a hyperlink via the HTML component, by using the HTML to create the link as I did in my last post. It is also possible to embed another page into an HTML component via an iframe.

Correct! and point well taken - absolutely dumb mistake.

Hello Terry,
I hope you had a good Christmas.

Thank you for your answer. It is not crucial to get us running on Mango 3 but would be nice. I can foresee problem with our customers changing things with out realising it.

Cheers

Brian

Hi fishfacs,

There are a lot of services that can do offsite backups for you! We use iDrive a fair amount, but you can certainly assess your needs and the service available to you, which may mean another backup service, something like google drive, or even just a USB stick (for issues of computer failure, not adequate for the site catching fire) is another layer of separation between the original copy of the data and its backup.

Almost all of the automating of invoking the service (or just scp'ing to the local fireproof computer) is done in cron tabs, usually, regardless of the service to be used. Edit: If your installation is on windows, I'm not as familiar with scheduling tasks, but I'm sure there is some kind of task scheduler to be had.

Perfect Thanks

Thanks so much, with Your script, now it is working... it is the most important thing, because the customer is testing this Scada platform.

Soon We will start checking what happen with this controller and them kind of SNMP Data.
Again, thanks for Your support

Thanks so much, You are right, we check it and it work. Thank You
The other script... will be for the oficial integration.
till now we are showing to the customer that the platform can work with their controller

Hi Dominik,

Thanks for sharing the resolution!

Thanks Jared, That does the Trick

Thank you Jared.