@MattFox said in Restoring H2 Database into Mango V3:

mango_no_sql.shtm

I don't think that works. Your screenshot link is broken, and the path you linked to (mango_no_sql.shtm ) says "Page not found".

I looked through the legacy page (accessed through data sources) but the option to restore sql databases (under settings) only shows the core database file, which includes the points and sources, but not the values.

@MattFox said in Restoring H2 Database into Mango V3:

@fishfacs Assuming you have a nosql db there should be nosql export zip files that you use to restore pointvalue data

Fox

I have a zip file that appears to have the pointvalue data (based on the file size). I just have no idea how to restore it. I don't recognize the file format of the files within the archive. There is no option to restore point data in the GUI. The dropdown only includes the zip files with the configuration and points configuration.

Hello,

i'm trying to restore a database backup into a new install of Mango V3.

The backup is in two zip files. The points seem to be in one, and the pointdata seems to be in another file (a bunch of numbered folders with .rev files).

The point information restores fine, but none of the historical data is there. Is there another step for that?

Thanks,
ff

Hello,

I'm trying to locate the documentation for the SQL datasource so I can learn how to use it. I feel like I'm missing something obvious.

Questions I'm trying to get answered:

• Does the SQL data source support insert statements? The field header would imply it only supports select statements.

• If I am able to use insert statements, can I insert the value of other tags, or just static values typed directly into the query?

• If I am able to use tags as part of an insert query, do I use the XiD of the tag, or the name of the tag in the query?

Some examples might help. I feel like there is a piece of documentation that would explain all of this, but I can't seem to find it. I click on documentation on the website and it leads me to a video explaining the datasource menu item, but not information about the specific data source types.

Any help would be appreciated,

Thanks

Is there a way to add custom Alarm Levels to use with my own events, rather than the stock "important", "safety", etc ones?

Hi.

Sorry to drag up this old topic, but I had something very similar happen to me last week and this was the most relevant topic that came up in search.

When I upgraded to 3.6.0 last week, all of my email template ftl's for my excel reports disappeared causing the reports to stop working.

What is the correct directory to store these templates in so they don't get removed between updates?

Hello,

I'm trying to have two values on the Y access of a graph. They are within the same numeric range. (0-100ish)

For example, I have a motor where I monitor Amps, and Hz of the motor speed controller over a period of time which can be selected by the date bar.

I can add Amps alone, and I can add Hz alone, but as soon as I try to add them together using different series, the page comes up blank.

Its also worth noting that I can add the Amps from multiple motors on different series, so I'm guessing it is a conflict with the units of Hz and A being on the same Y axis.

Below is the relevant code I'm using:

<ma-point-values point-xid="DP_motoramps" values="MotorAmps" from="dateBar.from" to="dateBar.to" rollup="{{dateBar.rollupType}}" rollup-interval="{{dateBar.rollupIntervals}} {{dateBar.rollupIntervalPeriod}}">
</ma-point-values>

<ma-point-values point-xid="DP_motorvfd" values="MotorHz" from="dateBar.from" to="dateBar.to" rollup="{{dateBar.rollupType}}" rollup-interval="{{dateBar.rollupIntervals}} {{dateBar.rollupIntervalPeriod}}">
</ma-point-values>

<ma-serial-chart  style="height: 100%; width: 100%" series-1-values="MotorAmps" series-1-title="Motor AMPS" series-2-values="MotorHz" series-2-title="Motor Hz"  legend="true" balloon="true" export="true">
</ma-serial-chart>

Also, while I'm on the topic, I've noticed that when I mess up the syntax in any way, the preview in the page editor just shows up blank. Is there any log or debugger I can use to determine what is causing it not to render?

Thanks for the help.

Disregard. It started working as intended following a server reboot.

Thanks.

Bump

Sorry to drudge this back up. I was encountering the same problem, and the above solution does not appear to work for me.

The pages work fine in the root menu, but as soon as I add them to a menu folder, then refuse to render.

I have the above file added to my public file-store with the string, and this is referenced in the menu items configuration?

Anything else I can try?

Hello,

I've created a few dashboards that work exactly as I need them. When I create a menu item linking to those pages, that also works fine. But as soon as I put those links into a folder on the menu, the pages turn up blank.

Any ideas what I'm doing wrong?

Hello,

I was playing around with the dashboard builder today, and I noticed that if you stack two <ma-serial-chart> objects on top of each other, and set them both to style="height: 50%; width: 100%", the result will be as expected: Two charts taking up the entire screen width, and half of the screen height.

The problem is if you expand the date bar. This seems to cause the charts to both start to increase their height indefinitely. They don't stop until the page is reloaded.

Interesting quirk. Not sure if its just me.

Hello,

I have a MangoES box. It is storing point historical data in an internal NoSQL database. I have configured backups to be made at appropriate intervals, as per the help file.

At the end of the help document regarding automatic backups, there is the following line:

"It is highly recommended that you copy these zip files (either manually or by some automated means) to an offsite location."

Does anyone have a recommended way of doing this automatically? One option is that I have a remote FTP server I could send the zip files to, but I'm not sure how to go about that. I also have access to a number of cloud drives, if that is easier.

Thanks in advance.

Sorry if this has been asked, but where are the log files for excel report generation. Some reports take longer than others, and I'm curious if there is a way to display and diagnose what functions are holding the report generation process up?

I figured it out. There was a typo in my URL. Thanks for this.

I put the data point in exactly as above. Not as an import; just manually. I get the following error when I click the green Test Value checkbutton.

"java.lang.IllegalArgumentException: Illegal character in opaque part at index 6: https://www.timeanddate.com/sun/usa/denver"

My knowledge of regular expressions is not great. Any ideas on what I missed?

Hello,

I'm trying to get sunrise and sunset times for my local area into a data point. I know that there are plenty of websites that serve this data in various forms and there are probably various different ways to approach this.

I am just wondering if anyone has done anything like this before and what the recommended approach would be before I attempt it. I tried the forum search, but I didn't find any applicable results.

Any suggestions?

Thanks,

Nevermind. I rebooted the server and it started working as intended.

Hello,

I have a virtual data source with a number of data points I want the operator to change by periodically setting manually.

The virtual data points are analog. No logging is needed. The only time their value changes is manually from the operator (it is a seed value used in some other formulas). I think I have set everything up correctly, except for one thing I can't figure out.

When I set the value, it seems to round up to two decimal places no matter how I set up the data point.

So when I go to "Data Point Details" screen to set the value to 0.056837 it always sets it to 0.06 no matter what.

The only place I can see to change anything like that is the "Text Render Properties" when I'm setting up the value. I have it set to Analog type and the Format is 0.000000.

What am I missing?

Thanks in advance

I figured meta tags was the way to go.

Ideally I would like separate tags for hour of day (0-23), minute (0-59), day (0-31) month (1-12) year (yyyy) .

So, five tags.

I would set up a modbus publisher so the PLC's can query in and sync up times once per day.

It would be nice to get them as close as possible (within the minute), but to-the-second precision isn't needed.

Hello,

Sorry if this has been asked before. I tried searching.

Is it possible to put the time and date into an internal/virtual tag so I can publish it to other devices that don't support NTP?

Thanks,
-FF