finally got the setup to work(thanks Paul for helping). Successfully post data into emoncms.org. :)
The second phase is to post all these data into my own database without sending them to emoncms.org, I usually use MSSQL but I can't find any documentation to do that.
I know that the posting data part from raspberry pi is as below:
[[ unique emoncms themed name ]]
Type = EmonHubEmoncmsReporter
[[[init_settings]]]
[[[runtimesettings]]]
url = http://emoncms.org
apikey = 32 character read write apikey
I know that the posting data part from emonTxV3 is as below: typedef struct { int power1, power2, power3, power4, Vrms, temp; } PayloadTX; // create structure - a neat way of packaging data for RF comms
I know that I will need to create a database and a table to receive the data. But first that data has to be able to send from Pi to server. From this forum, it is said that the core of emoncms is mysql, so technically, I should be able to pass data from the Pi to my own database.
Any hint or help I can get to send these data to a local database and pass the data in this local database to my laptop database? [emonTxv3 -->Raspberry(local database) ---> laptop database]
(I am thinking of doing it this way because I don't want my data to lost when the communication between the Pi and the laptop is down. If the communication is down, at least the data is stored in my Pi. Once the communication is up, it should be able to pass that information to my laptop database)
Passing data into my own database
Submitted by chuayq on Wed, 24/06/2015 - 03:06Hi all,
finally got the setup to work(thanks Paul for helping). Successfully post data into emoncms.org. :)
The second phase is to post all these data into my own database without sending them to emoncms.org, I usually use MSSQL but I can't find any documentation to do that.
I know that the posting data part from raspberry pi is as below:
[[ unique emoncms themed name ]]
Type = EmonHubEmoncmsReporter
[[[init_settings]]]
[[[runtimesettings]]]
url = http://emoncms.org
apikey = 32 character read write apikey
I know that the posting data part from emonTxV3 is as below:
typedef struct { int power1, power2, power3, power4, Vrms, temp; } PayloadTX; // create structure - a neat way of packaging data for RF comms
I know that I will need to create a database and a table to receive the data. But first that data has to be able to send from Pi to server. From this forum, it is said that the core of emoncms is mysql, so technically, I should be able to pass data from the Pi to my own database.
Any hint or help I can get to send these data to a local database and pass the data in this local database to my laptop database? [emonTxv3 -->Raspberry(local database) ---> laptop database]
(I am thinking of doing it this way because I don't want my data to lost when the communication between the Pi and the laptop is down. If the communication is down, at least the data is stored in my Pi. Once the communication is up, it should be able to pass that information to my laptop database)