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.

I modified my named ranges to include only a single cell and tried to run the report again. This time I got this alarm:

This alarm is present for all named ranges and disappears if I include one more cell in the named range.

However when I do so I still cannot read the data from this morning.

I have a series of point that update every day at midnight. I am trying to export an excel report using the excel widget that only includes the values from this morning.

Which settings for the time period will give me those values?

I have tried past 24 hours, previous 24 hours, 11 pm yesterday to 8 am this morning, past 1 days, previous 1 days. None of those options give me the data I am looking for.

Any suggestions?

Here are some screen shots that might help. First is a watch list containing the point containing the script (Time_Stamp) and the alarm that it is connected to (mal_cp_ol). They have the same time stamp:

Here is the script. Perhaps I am not using it correctly:

Here is a screen shot of the point in question in the point details page:

However if I look at a watch list containing this point it displays the time as now, for example 8:37 am as of writing this

I have tried the script but it doesn't work. However if I go in the data point details page for an alarm that is already active it says it become active on aug 10 10:37. Is there a way to export that time to DGLux instead of the current timestamp of the point?

Thanks, Joel.

Will this also work with the NoSQL database?

The H2 database is backuped up as a zip file. When the file is unzipped it becomes a SQL file. My question is how do I reupload that database into Mango?

I have an idea, let me know if I am on the right track:

Open the SQL file in Notepad
Save as a json file
Open import/export in Mango
Copy json text into Mango
Import

The second point is also a binary point. When I click the checkmark it returns "test" status, either true or false

The point "test" is a simple binary point that can be assigned a value.

I have set up the script so that it should run when the value of "test" changes, only it doesn't when I look at the watchlist.

I have been trying to run a meta point script that updates when another binary point changes values. I have set the script update event to context update but the script will not run when I change the binary points value.

Any ideas?

In what way are the folder names different. I downloaded the zip file and the file names in the MangoTSTD directory appear to be the same as in the zip file

Bryan

Hi Woody,

Okay. But you mentioned that this script does not work on the current beta version of Mango.

But once that is updated I will try the new script.

Bryan

I have a scripting data source that executes once per day at midnight and sets the values of the points within it.

eg:

As I understand from the Wiki page:

http://infiniteautomation.com/wiki/doku.php?id=automation:meta_data_points#context_objects

the "past" function will return the number of starts from the last 30 or 31 days from today and the "previous" function will return the number of starts starting from the 1st of the previous month to the end of the previous month.

Is there a way to save a distinct previous months data (say I wanted to see the data from only March)?

Bryan

I have discovered another issue that needs to be solved.

The points that I want to get the timestamp for are in a data source that updates every 2500 milliseconds.

Even if I run the return p####.time script it returns the timestamp of the last update

Is there a way to freeze the timestamp in the data source?

Bryan

Thank you very much for your replies. The script return p####.time works perfectly,

Thank you for the script Woody. For now I will move forward with Joel's suggestion but I will keep the script in mind.

Thank you again

Bryan

I am looking to see if there is a script or function that will let let assign an old timestamp value to a point

For example the point I am interested in was last logged at 11:32:05 and the other points last logged at 12:27:27.

I would like to take the value 11:32:05 and eventually be able to export it to DGLux.

My problem is the functions I have tried:

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/valueOf

all return the current timestamp, if anything at all.

Does anyone know of a function or script that will let me save this timestamp (11:32:05)?

Bryan