• pierjsap

    Hi guys, I would need to know in which DB table the events are inserted. I had read a post about it but I can not find it anymore
    Thanks in advance

    posted in User help read more
  • pierjsap

    Hi guys,
    Is it possible to query an external web service from a mango page?
    I have included a GET and post-AJAX calls on a page.
    The chrome console highlights the error "Refused to connect to" http: // localhost: 62224 / api / products' because it violates the following Content Security Policy directive: "connect-src ws: wss: 'self'". "

    posted in User help read more
  • pierjsap

    @phildunlap said in Convert from H2 to mySQL Database guidelines:

    You need to have installed a MySQL server for Mango to connect to, and created a database with a properly privileged user, before you can convert your existing H2 database.

    You need to have installed a MySQL server for Mango to connect to, and created a database with a properly privileged user, before you can convert your existing H2 database.

    @phildunlap for created database do you mean to create an empty database? or do I have to run some script for the generation of the db with mySQL Server?

    posted in User help read more
  • pierjsap

    @jared-wiltshire said in Convert from H2 to mySQL Database guidelines:

    ${MA_HOME}/overrides/properties I modified this, only that I would need explicit help because I have no idea how to port mysql. I did various tests without results.

    Thanks @Jared-Wiltshire

    posted in User help read more
  • pierjsap

    Hello everyone,
    I followed the guidelines on this page. But I could not create the mySQL database.
    I downloaded "Mango Automation 3.4.3 Free", I started it, I accepted the license and then I closed mango and proceeded to modify the env.properties file.

    convert.db.type=mysql
    convert.db.url=${ma.home}/databases/mySQLMango
    convert.db.username=admin
    convert.db.password=admin

    When I restart mango, the page loading stops and a H2 db is generated even though I had deleted it before starting the application

    Could you explain the procedure step by step?
    Thanks in advance

    posted in User help read more
  • pierjsap

    I linked an external database I did Statement test with a simple select * from my table query and I managed to get the result set. So, I tried to create a datapoint because I imagined that they could be used to derive data through a sql script. As far as I could understand, can only insert and update?
    Thanks in advance for the support

    posted in User help read more
  • pierjsap

    Try setting CSS height and fixed width.
    If you have already done so you probably have not set the parameters well.
    I suggest you go to the examples -> Chart -> Advanced Chart section and visit API Documentation for <ma-serial-chart> & <ma-point-values>.
    Ciao a presto ;)

    posted in User help read more
  • pierjsap

    @Jared-Wiltshire
    Its pretty easy to enable/disable data points from a dashboard using a point's enable() method. And yes you can also enable/disable data points or data sources from a script. However I'm not sure this is necessary, I would probably just leave the data points logging continuously.
    0_1527755660733_disable.JPG

    What's wrong?
    Would you give me an example of how to recall classes and methods for working with datasoruce and datapoint and extracting the fields?
    I do not know the Java architecture you have implemented ...

    Tag each data point with a set of tags to uniquely identify the machine.
    0_1527761820401_tag.JPG
    It is possible to set "tags{}" field ?
    Eg. tags:{"nameProduct" : "productAlpha" , "id": "164", xid": "DP_RomeElettricoScrPotenza","name":"RomeElettricoScrPotenza"}

    Thanks in advance

    posted in User help read more