• BG

    0_1576507461805_thumbs up.png Your're a star!

    Have a good Christmas!

    posted in User help read more
  • BG

    Hello Terry, (excelreports module 3.7.1)
    This should probably go in the wish list and I know you have a lot more important things to work on, but it would be nice to be able to sort the entire list of finished Excel reports by clicking the column headings.

    My list of finished reports extends over several pages and on each individual page the finished reports are listed latest to oldest. But I am finding the most recent reports on later pages for some reason.

    Thank you

    Brian

    posted in User help read more
  • BG

    Hello Terry,
    Thank you very much, I just got a chance to update the modules and test the scheduling.
    Working great now.

    Cheers

    Brian

    posted in User help read more
  • BG

    Hello,
    Since our recent Excel Reports Module upgrades from 3.6.2 to 3.7.0, all of our scheduled Excel reports are not running automatically. They were working fine before the upgrades. I can run the reports manually but the CRON schedule is not working.

    I have recreated the schedule from scratch on our test report but is is not running either. There is also nothing showing up in the ma.log file.

    I have noticed that when I click the gear icon next to the report, I get the choices to copy, delete, run or schedule. When selecting schedule the only option there is to set the time period. I have always used the actual report template set up to set the schedule so am not sure if the CRON pattern choice was available from the schedule option of the gear icon.

    I am wondering if the schedule option from the gear icon does not allow setting the CRON pattern for the schedule, has the scheduling been dropped by accident?

    I am eagerly looking forward to your response.

    Cheers,

    Brian

    posted in User help read more
  • BG

    Hello Terry,
    Thank you for you response. This will let me continue with the upgrade. I am sure we can work with the unique email address point. It will just need to make sure I get a separate contact address for each user and explain to the customer it is for password recovery.

    Thank you for your help and I hope you all had a happy Thanksgiving.

    Cheers

    Brian

    posted in Mango Automation Installation read more
  • BG

    Hello IA,
    First of all, my service is running:
    Mango Core: 3.6.6, Mango API: 3.6.4, Mango UI: 3.6.7, Platform: Centos 7.4.1708, Java Version: 1.8.0_161

    I am trying to get everything in place to perform the latest Mango 3 upgrades. However it is like a line of dominoes. You state that we need to be using MySQL 5.7.8 at a minimum for the JSON data type. Our web server that is running Mango 3 is a Plesk web server which is using MariaDB by default. Up til now this has not been a problem and may not be a problem going forward but I need your advice.

    Plesk only supports upto MariaDB 10.3. I checked if this is equivalent to MySQL 5.7.8 for the JSON data type and this is a quote from the MariaDB site:

    The JSON alias was added in MariaDB 10.2.7. This was done to make it possible to use JSON columns in statement based replication from MySQL to MariaDB and to make it possible for MariaDB to read mysqldumps from MySQL.

    JSON is an alias for LONGTEXT introduced for compatibility reasons with MySQL's JSON data type. MariaDB implements this as a LONGTEXT rather, as the JSON data type contradicts the SQL standard, and MariaDB's benchmarks indicate that performance is at least equivalent.

    In order to ensure that a a valid json document is inserted, the JSON_VALID function can be used as a CHECK constraint. This constraint is automatically included for types using the JSON alias from MariaDB 10.4.3.

    Here is the link to their page for further reference: https://mariadb.com/kb/en/library/json-data-type/

    In your opinion, will the upgrade work with my configuration of MariaDB 10.3? It sounds to me that it would and the differences are only noted for replication and export/imports.

    My second question regarding the Mango 3 upgrade concerns the user email addresses. Our customers sometimes provide the Mango service to their customer. So we may have more than one user name to access a display page. But our customer is the only one I have contact with, so the other users are still referenced by the one customer email contact.

    Would it be possible for me to change the "Unique" attribute in the database with out affecting the operation of Mango 3.7.1?

    I need to know what to expect before I attempt the upgrade.

    Thank you for your time.

    Brian

    posted in Mango Automation Installation read more
  • BG

    Hello cwangv,
    If you are just browsing the list from the drop down of the Point Properties - Unit values then you will not see some of the units available. I found that if you type the ones you need such as mm, cm kW and kWh and click save, the point will save with proper validation. %RH is not available for validation, but % is available. The drop down list is not the full list of units available.

    To use non standard units, you would need to go to the Text Renderer Properties and untick "use unit symbol as suffix". Then you can enter in your desired text in the Suffix value.

    Cheers
    Brian

    posted in User help read more
  • BG

    Just adding my 2 cents here.

    I am assuming that the automatic renaming was not created in Mango so as to keep the flexibility and power of configuring the data sources and data points to your own individual configuration styles. As for our organisation, I too have to train my colleagues to set up the logging systems and we also have situations where the customer wants a name changed, has moved the logger to another site or wants to set up an identical system on a new site.

    Since Mango uses the XID to identify the various parts of the system, we make sure the XID’s are very generic, i.e. logger/device id – channel number such as 0001-an1. This way we can change the names to a user friendly description without changing the overall structure of the logging system.

    Just as PhilDunlap said, to make editing the sources and point easier we always export the JSON file, edit the text with a simple find/replace and import the configuration. As long as the XID’s are not changed everything will work. We have also started to use the Bulk Editor in Mango 3. We rarely edit the data sources directly except to tweak a few settings.

    We also have several data sources set up as templates and again we copy the JSON file and edit the data source names, data point names and the this time the XID’s to create new logging systems. We find this quicker to set up and easier to teach. It eliminates a lot of clicking back and forth.

    Cheers,
    Brian

    posted in User help read more