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

@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?