Welcome, Guest
Username: Password: Remember me

TOPIC: Lire une base de donnée MySql avec proview

Lire une base de donnée MySql avec proview 9 years 1 month ago #7267

  • BenjiPERET
  • BenjiPERET's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 13
  • Karma: 0
Bonjour, j'utilise depuis peu Proview dans le cadre de mes études.

Grâce aux différents tutoriels, j'ai réussi à créer un programme qui permettait d'écrire des informations sur une base de donnée MySql.

Je voudrai savoir s'il était possible de lire une information depuis une base de donnée MySql (ex : une mesure réalisée avec un capteur arduino et qui est stockée ensuite dans une base de donnée) avec le logiciel Proview.

Si c'est le cas, comment fait-on cela et comment on peut traiter ensuite cette information avec le logiciel ?

Je vous remercie d'avance pour votre réponse.

Benjamin
The administrator has disabled public write access.

Lire une base de donnée MySql avec proview 9 years 1 month ago #7276

  • deiKruve
  • deiKruve's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 65
  • Karma: 0
hallo all,
here is a google translation of Benjamins question. Could someone answer please
I have never done this.

jan.

Hi, I recently started using Proview as part of my studies.

Thanks to the various tutorials, I managed to create a program that allowed to write information on a MySql database.

I want to know if it is possible to read information from a MySQL database (eg a measurement made with Arduino sensor and which is then stored in a database) with the Proview software.

If this is the case, how do you do this and how we can then process this information with the software?

Thank you in advance for your response.

Benjamin
The administrator has disabled public write access.

Lire une base de donnée MySql avec proview 9 years 1 month ago #7280

  • claes
  • claes's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 3170
  • Thank you received: 497
  • Karma: 133
Hi Benjamin,

The normal way to retrieve history data in the storage server is to view a curve for example by activating the History entry in the popup menu for the SevHist object in the runtime navigator.

There is also an API, sevcli, that can be used in c applications. Read about sevcli in Programmer's Reference Manual.

/Claes
The administrator has disabled public write access.

Lire une base de donnée MySql avec proview 9 years 3 weeks ago #7303

  • BenjiPERET
  • BenjiPERET's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 13
  • Karma: 0
I thank you Claes for your advices.

I try to do the first solution but I have a problem because I don't see the popup menu in the runtime navigator to activate the History entry.

During this week, I will try the solution with sevcli and I will tell you if I achieve the solution.

Thanks

/Benjamin
The administrator has disabled public write access.

Lire une base de donnée MySql avec proview 9 years 3 weeks ago #7305

  • claes
  • claes's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 3170
  • Thank you received: 497
  • Karma: 133
You can also use the program sev_xtt that displays all stored attributes in a tree structure. Select an attribute and activate Functions/Open Process History in the meny, or the graph button in the toolbar.

/Claes
The administrator has disabled public write access.

Lire une base de donnée MySql avec proview 9 years 3 weeks ago #7307

  • BenjiPERET
  • BenjiPERET's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 13
  • Karma: 0
Hi Claes,
I follow your advice and I use the program sev_xtt. For that, I follow the instructions of this document (proview.se/doc/en_us/man_dg_dg_sev.html).

But I have a problem because when I open the History of my value, there are any information about it.
Also, I see in the document that in the configuration of the object "SevNodeConfig", a address must be written.

So what is this address?

In the message , I send you screenshot of my problems in the programm.

Thanks

/Benjamin

Capture.JPG



2015-03-04--1425464251_1920x976_scrot.jpg


2015-03-04--1425464805_1920x976_scrot.jpg


2015-03-04--1425464935_1920x976_scrot.jpg
Last Edit: 9 years 3 weeks ago by BenjiPERET.
The administrator has disabled public write access.
Time to create page: 7.909 seconds