Hi,
I need some help with Mango 4.2.x to delete some historical values in the nosql-db.
I know how to export the values via the watchlist, get an excel-list but then...
In Mango 3.x was in the export sheet a table column "modify", in version 4 nothing like that?
Thanks
Hi zenvakil,
My working example for Mango:
<wind value="10" unit="km/h" dir="S" symbol="13" symbolB="37"/>
If I want the winddirection (=S) I have to code:
dir="(.*?)"
So try
SoC"(.*?)"
If you have more than 1 SoC in your webpage:
<hour value="01:00">
<temp value="0" unit="°C"/>
<symbol value="1" desc="Sonne" value2="1" desc2="Sonne"/>
<wind value="10" unit="km/h" dir="S" symbol="13" symbolB="37"/>
<wind-gusts value="27" unit="km/h"/>
<rain value="0" unit="mm"/>
<humidity value="88"/>
<pressure value="1006" unit="mb"/>
<clouds value="0%"/>
<snowline value="600" unit="m"/>
<windchill value="-4" unit="°C"/>
<uv_index value="0"/>
</hour>
try this:
01:00"><.*?><.*?><.*?><.*?><.*?><humidity value="(.*?)"
Hi Joel,
is there already a release date for the OPC UA module?
Any beta-version we can test?
Hi NinoK,
if you create a new BACnet-Data-Source your local device IP (old system settings / BACnet local devices: 192.168.100.105:47808) should be the same as the Mango-Server has:
If you create a new BACnet data point it should look like:
where the "Device instance number" is the given Device ID, here 5.
If all BACnet-Devices are in the same IP-Range you don't need a BBMD.
Be carful if you scan a large BACnet-Network with many devices and objects. It can take a long time and need server-resources. Better is to scan one ID.
A person who never made a mistake never tried anything new. - A.Einstein
Edit and thank you Fox!
Like Fox I would use a meta data point, run it every hour. Try this code:
return b.past(HOUR, 1).get(true).percentage;
Check the docs:
Hi Chad,
we're using AdoptOpenJDK 11.0.8.10 (x64) without any problems...
Maybe use this Version?
Exit Mango, backup your mango folder, delete all files inside your existing mango\lib folder and unzip the mango-download-zip file to your mango folder. Accept override existing files.
Hi Ricardo,
maybe:
create a SQL-Data-Source and connect to the h2-db,
Select statement: SELECT COUNT(ID) FROM events WHERE ISNULL(ackTs)
create one numeric datapoint, run the query and log the history.
Or:
Check the alarm-icon with the counter inside the header.
There is something like
<span ng-bind="$ctrl.renderCount($ctrl.events.totalCount)">16</span>
Hi Chad,
I always turn the logs off. Only if there are any problems with the data-source I turn it on to find the reason.
If you config the data-source correct, what is the reason to log the things continuously?
It needs r/w-recources and if you have many to log CPU Power.
If something went wrong you can get an event and check the data-source.
It would be a good thing to have a limit for a "message shower" (logs or events).
Hi Chad,
increase the thread pools a bit, that will help you I think.
Our system is running over one year without any problems (restarts only for updates). 268 Data Sources, 32,359 Data Points and 9 publishers.
Another thing I do for each mango-installation is to config the Mango-internal-data-source to the max (Mango process CPU load, System CPU load etc.) to get an overview what happens with the system and the data-sources (= PLCs). Don't forget to set "override system purge settings" for this ds or you will get a very large database...
Also check your update period versus poll duration for the modbus-ds. Maybe you have to increase your update period because the PLC needs to much time or the network-traffic is limited?
Hi cwangv,
sorry, I don't check the docu v4...
I have installed on a WIN10PRO PC AdoptOpenJDK 11.0.8.10 x64 - not Oracle! - install the service via cmd as Admin switch to the mango folder "boot" and run "java -jar ma-windows-service.jar install" and Mango 4.0 beta 3 is runing via service.
No problems, all works fine!
@wingnut2-0 said in Installing Windows Service:
javaws.jar is not included in AdoptOpenJDK which is required for YAJSW to work.
I think that's the reason.
My last productive 4.0 installation runs with this solution:
https://forum.mango-os.com/topic/4632/windows-10-services-for-mango/3
Hi Mango-Team,
Mango 4.0.0 beta 3 needs a mangoUI update like version 3.7.8 to fix bug where sub-menu would not open in Chrome 87...
We have a productive system running and can't update the client-browser.
Thanks,
Ralf
Hi,
we have a new project that is to be developed with mango 4.0-beta. Are there any restrictions when updating to Mango 4.x if this is available?
Hi,
I do this with the Mango Internal Data Source and create points with "mydatasource-last poll duration" or "poll success percentage" or "previous sequential successful polls" and watch them with a meta-data-point.
But you get the values? If you increase your timeout to 5-10 seconds, it's the same?
Usually I deactivate the events and do it with watchdogs -> create slave monitor points.
Hi Nurr,
all my windows installations work with this configuration:
https://forum.infiniteautomation.com/topic/4632/windows-10-services-for-mango
Hi Cristian,
you can make a configuration backup
and import this file in a new Mango installation without the history-values,
If you want the history-values, make a backup from the noSQL-db
To import this backup in the new system check the help via ?
If you have a new system and want only import a few data-sources, you can export this inside the old ui-system via xml:
