I decided to imported my data (5 years old) using simple perl script querying mysql data with unixtime and then do a post to emoncms using curl (ok I know not the best way but I had so much differents data I've done it quickly) and of course the parameter time. I don't remember exactly the syntax I used but it was something like that ;
For information I got one record on mysql database every 5 minutes so it took some time but worked, and I also wanted to "see" what effect on different feeds type.
That's said, I used value PAPP (total current power on my house). So I log the input data on two feeds one to mysql and the other to phpfiwa (done this before import of course)
Now to emoncms, on mysql feed I have the graph from 2009 year from today, works fine. What is strange if on the phpfiwa feed, it did not get anything, but the feed is working because I've got the data and graph since my migration date (I migrated 3 months ago)
So does anyone tried with success to put input to phpifwa feed with the parameter time ? My inputs was correct because on the mySQL feed all was imported correctly so I suspect phpfiwa feed not supporting "time" ?
Any idea of why it didn't work ?
For those who will ask why using mySQL feed ? I like to have data into a real database such as mySQL because I can query data, change them import them where I need, and see what's going wrong sometimes. Simple and efficient (despite the poor perf with lot of values on emoncms)
By the way is there any possibility to get data back (all datas inputed of course) from phpifwa feed (just curious) ?
Importing Data using curl : strange behaviour on phpfiwa with parameter time
Submitted by Charly86 on Wed, 11/06/2014 - 17:03Hi,
I decided to imported my data (5 years old) using simple perl script querying mysql data with unixtime and then do a post to emoncms using curl (ok I know not the best way but I had so much differents data I've done it quickly) and of course the parameter time. I don't remember exactly the syntax I used but it was something like that ;
/input/post.json?time=1402505367&node=16&json={PAPP,value}
For information I got one record on mysql database every 5 minutes so it took some time but worked, and I also wanted to "see" what effect on different feeds type.
That's said, I used value PAPP (total current power on my house). So I log the input data on two feeds one to mysql and the other to phpfiwa (done this before import of course)
Now to emoncms, on mysql feed I have the graph from 2009 year from today, works fine. What is strange if on the phpfiwa feed, it did not get anything, but the feed is working because I've got the data and graph since my migration date (I migrated 3 months ago)
So does anyone tried with success to put input to phpifwa feed with the parameter time ? My inputs was correct because on the mySQL feed all was imported correctly so I suspect phpfiwa feed not supporting "time" ?
Any idea of why it didn't work ?
For those who will ask why using mySQL feed ? I like to have data into a real database such as mySQL because I can query data, change them import them where I need, and see what's going wrong sometimes. Simple and efficient (despite the poor perf with lot of values on emoncms)
By the way is there any possibility to get data back (all datas inputed of course) from phpifwa feed (just curious) ?
Thanks for reading.