<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Dear Thorben,<div><br></div><div>I think I understood what and where I should enter the date and avoid using vzlogger. So I extend my Perl script with putting or POST data to the DB.</div><div><br></div><div>Trying to get that data from my Perl into Mysql DB I am getting the following result ( example from <a href="http://wiki.volkszaehler.org/development/api/reference">http://wiki.volkszaehler.org/development/api/reference</a>)</div><div><br></div><div><br></div><div><div><font class="Apple-style-span" size="2" color="#1f00ff">POST <a href="http://192.168.0.187/volkszaehler.org/htdocs/middleware.php/data/a301d8d0-903b-1234-94bb-d943d061b6a8.json?ts=1284677961150&value=12">http://192.168.0.187/volkszaehler.org/htdocs/middleware.php/data/a301d8d0-903b-1234-94bb-d943d061b6a8.json?ts=1284677961150&value=12</a></font></div><div><font class="Apple-style-span" size="2" color="#1f00ff">[1] 5749</font></div><div><font class="Apple-style-span" size="2" color="#1f00ff">pi@raspberrypi ~/Iskra_read $ Please enter content (application/x-www-form-urlencoded) to be POSTed:</font></div></div><div><font class="Apple-style-span" size="2">(no prompt returning)</font></div><div><br></div><div>Must be something I didn’t read or understood?, Do you know what I miss?</div><div><br></div><div>Question about timestamp, why is timestamp in absolute value and not in a readable format?</div><div><br></div><div>thks</div><div><br></div><div>Henry</div><div><br></div><div><br></div><div><div><div>On Jan 9, 2013, at 10:00 AM, Thorben Thuermer wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>On Tue, 08 Jan 2013 14:40:09 +0100<br>Henry van Gestel <<a href="mailto:henry.van.gestel@gmail.com">henry.van.gestel@gmail.com</a>> wrote:<br><blockquote type="cite">Questions:<br></blockquote><blockquote type="cite">1)<br></blockquote><blockquote type="cite">Do you know what the datamodel is (name of fields and format) , what <br></blockquote><blockquote type="cite">schould I sent : timestamp, used KW, produced kw, PV generated KW?<br></blockquote>[...]<br>you have to create a separate channel for each value.<br>the middleware stores tuples of (channel,timestamp,value).<br>(both via the api, and in it's sql database.)<br><br><blockquote type="cite">2)<br></blockquote><blockquote type="cite">Where is the calculating taking place as I sent only status values at <br></blockquote><blockquote type="cite">that time (every 5 minutes)?<br></blockquote><br>what calculating?<br>the middleware stores the data as reported,<br>the frontend loads the data from the middleware,<br>(i guess a total/average is calculated in the process)<br>and displays it...<br><br><blockquote type="cite">Henry<br></blockquote><br>- T.<br><br><blockquote type="cite">Op 1/8/2013 8:41 AM, Thorben Thuermer schreef:<br></blockquote><blockquote type="cite"><blockquote type="cite">Hello,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">so you want to use the middleware/frontend to store/visualize your data,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">but can't use vzlogger to import it.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">(the prefered fix would ofcourse be to fix vzlogger to work with your<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> meter! maybe if you give us the details of how you made it work,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> i.e. which timings are critical etc., we can fix hat for you...)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">but there are two alternatives:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">- send the data to the middleware API from your script.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> the api is quite simple, and documented:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> <a href="http://wiki.volkszaehler.org/development/api/reference">http://wiki.volkszaehler.org/development/api/reference</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> (in german, if that's a problem, please complain!)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> basically all you need is:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> <a href="http://.../middleware.php/data">http://.../middleware.php/data</a>/<uuid>.json?operation=add&value=<value><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">- insert the data directly into the middleware's database,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> no need to put it into an intermediate database first.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> the format is relativey simple, just look at the database<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> after installing the middleware (and maybe loading the test data).<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">- T.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">On Tue, 8 Jan 2013 00:35:41 +0100<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Henry van Gestel <<a href="mailto:henry.van.gestel@gmail.com">henry.van.gestel@gmail.com</a>> wrote:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">Maybe somebody can help me.<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">I am strugling now how to continue , I am be able to get the data from 2<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">Iskra MT171 meters .<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">I also can put the data in a Mysql DB wondering what data model is used.<br></blockquote></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">e.g timestamp, actual value used , actual generated , PV_collected.<br></blockquote></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">A) I wonder where various values like the avg, max , min is calculated?<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">B) Maybe somebody can give me a hint or a detailed description of vzlogger<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">where and what it is doing.<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">Or<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">How to let vzlogger get the data from sql stored data or a file.<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">Configuration:<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">I have 2 ir heads (from Udo) connected to Rpi, a perl script reads the 2<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">heads every 5 minutes, puts data in a mysql dB e.g fields are (Timestamp,<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">headnr, PV_produced, normal_tarrif_used, norma_tarrif_produced).<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">Rgrds<br></blockquote></blockquote></blockquote><blockquote type="cite"><br></blockquote></div></blockquote></div><br></div></body></html>