String that data in mysql database

Hello,

how i can store the data that is given from emontx v3 in my own Mysql database? 

Robert Wall's picture

Re: String that data in mysql database

I do not know enough about the Raspberry Pi nor about MySQL to be able to help you.

The format of the data transmitted by the emonTx is defined in this line in the sketch:

  typedef struct { int power1, power2, power3, power4, Vrms, temp; } PayloadTX;    
     // create structure - a neat way of packaging data for RF comms

(That is for the default sketch, yours may be different. Powers are Watts, Vrms is the actual voltage × 100, temperatures are deg.C × 10)

Mkj's picture

Re: String that data in mysql database

Thank you so much

do you know what is the tables that i have to create in my database in order to store these data ?

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.