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

Thanks guys ;)

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'". "

Thank so much @Jared-Wiltshire and @phildunlap ;)

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

@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

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

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

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 ;)

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

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.

It is possible to set "tags{}" field ?
Eg. tags:{"nameProduct" : "productAlpha" , "id": "164", xid": "DP_RomeElettricoScrPotenza","name":"RomeElettricoScrPotenza"}

Thanks in advance

@Jared-Wiltshire

Is there a set of data points x,y,z per machine, and multiple machines?
Yes, my project involves the construction of n-machines that have n-data points. But I would start to implement only one with 3 data points.

Is the start/stop for each machine just a binary data point?
I have inserted a binary button that is read by a scripting data source that when set to true starts reading 3 data points.
In this regard, I wanted to ask you if you can activate and deactivate a data point and / or a data source using a script command. Eg by pressing the active button and deactivating the data source and its data points

What is the "product object" and how is this information obtained/entered?
I'll give you an example. Let's say that I have to create a glass object, this object can be a glass, a plate or a bottle. Each of these can be characterized by the various chemical components, because a glass must be transparent a bottle of green color a dish must be more resistant than both. So to realize this I have to observe how long it takes to make an object? I need to get some energy consumption data for a glass,
derive the consumption for the realization of a dish. These data will then be used for statistical purposes ie to make a stronger glass takes 1 hour of time, I have to melt the components at 1500 ° C instead of 1000 ° C. So every time I start production of an object I can not take into account a period of time. But I have to take into account an ID that identifies a single production process process for both immediate consultation and future data consultation.

How is the product id generated?
I do not know, this was my question, I was trying to understand how to associate a production process with an object.
Example:
ID: 001
XID: dhsflhdsfdhskfhdsfhds001
type: Yellow glass
realization time: 2 hours
realized on: 2018-05-30 9.30 AM
maximum temperature: 1000 ° C
temperature per minute 1: 500 ° C - power per minute 1: 500W
temperature per minute 2: 800 ° C - power per minute 1: 2000W
temperature at minute 3: 1000 ° C - power per minute 1: 3000W
temperature per minute 4: 500 ° C - power per minute 1: 1000W
temperature per minute 5:30 ° C - power per minute 1: 500W

What sort of reports do you need? We can build a dashboard to display a report like view which could be printed, however using a scheduled/emailed report would be trickier
I think reporting is the least of my problems because Mango has these customizable tools

@CraigWeb How could I create a batch? I do not know where to start. I can not take the time as a point of reference, but I need to give an ID to every series of processes that take place between a start and a stop. I did not understand how to accomplish this

@CraigWeb are you referring to this example?

I hope this image can be explanatory. Pressing start the machine performs various steps. For each step I have values that are acquired by the sensors until you press stop.

Once the process is finished, the system will have to return a history of the parameters collected with relative timestamp and it will generate a graph of the values trend. My problem is that I have to associate all these data to a specific product, as this machine does not produce only a type of product but different, so how will I distinguish product A with its values from product B with its own? I had thought about creating a table. At the start, I performed an insert using a SQL datasource (for example, with Product ID, timestamp, val1, val2, val3). So to get the final data I would query the table for Product ID and I would have finished.
@MattFox thanks i hope this is helpful for mango users not only for me ;)

Hello guys :)
I have this situation: three machines produce different objects each.
Each object is produced from the moment an operator presses start and ends when he presses stop.
To produce these objects there is no defined time, even those of the same type may have different manufacturing times.
What I would like to know is if it is possible:

1. Obtain for each product object the data acquired over time of its production.
2. Of each object obtain the machine that produced it
3. Of each machine obtain the sector to which it belongs

In practice it is possible to create identifiers to perform these associations at the DB level? Since I have to get some graphs and reports for each product item (production time, temperature values etc.), I would like to know if it is possible to create a set of relational tables linked by keys so that I can query the IDs through queries and derive the related data through ma-point-query?
Thanks !

@phildunlap I solved, even with Fiddler assigns the value to the variable by making a call to both GET and POST.
I will try to pass more values.

@phildunlap thanks for helping me. The DS http works. At this point I can not understand how to set the value of "HTTP parameter name" through a "post" request of an windows application outside of Mango.

I guess I have to check the settable for the datapoint. What is meant by the "Set point name"?

"Requests are delivered using normal HTTP parameterized request formats. When using the GET method, the format is 'http: // localhost: 8080 / httpds? Point = 1'". I tried to call this Mango with Fiddler, but the value is not set to 1.

HTTP Receiver "Set point name"

Does it have anything to do with what I have to do? or did I misunderstand something?

Hello guys, could someone explain to me how to set the "HTTP Receiver" step by step? I read several posts in the forum and the guide that appears by clicking "?" but I have no idea where to start ...
In practice I should do a POST to the DataSource. I tried to ping it but without success.
Thanks ;)

@CraigWeb problem solved i hope that this could help you.

<button onclick="goBack()">Go Back</button>

<script>
function goBack() {
    window.history.back();
}
</script>

It's only an user case schema. Your code works good ;) but the problem is how i can preserve the path through the pages.
I try to do it by JQuery script with a sobstituition of button properties