String that data in mysql database

Submitted by Mkj on Sat, 18/04/2015 - 10:26

Hello,

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

Re: String that data in mysql database

Submitted by Robert Wall on Sat, 18/04/2015 - 13:26.

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)

Re: String that data in mysql database

Submitted by Mkj on Sat, 18/04/2015 - 13:31.

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 ?

Archived Forum