[vz-dev] Neue Baustelle
Michael Baer
mibaer at web.de
Sat Jan 25 19:31:44 CET 2014
Heute bin ich wieder mal über was gestolpert :-)
Voraussetzung: vzlogger in der Version von Peter Evertz (der aktuelle
vzlogger streikt bei s0) mit Aggregation auf 60sec.
Das sieht soweit gut aus. Der Kanal ist im Frontend als "Elektrische
Energie (Zählerstände)" deklariert und funktioniert da auch richtig.
(Entspricht "electric meter" in der DB)
Bild: normal
Bei jedem Neustart des vzlogger oder des Pi kommt es jedoch zu einem
mehr oder weniger starken negativen Ausschlag!
Bild: spike
So wie es aussieht zählt der vzlogger die S0-Impulse in der DB einfach
hoch - bei einem Neustart fängt er dann wieder bei Null an :-(
=================
SELECT * FROM `data`WHERE `channel_id`=14 AND UNIX_TIMESTAMP(
'2014-01-21 16:15' ) *1000 < TIMESTAMP AND UNIX_TIMESTAMP( '2014-01-22
09:30' ) *1000 > TIMESTAMP
"14273550","14","1390317380821","159219"
"14273558","14","1390317473580","159220"
"14273566","14","1390317600837","159221"
"14273577","14","1390317812731","159222"
"14273593","14","1390318112520","159223"
"14273688","14","1390320094355","159224"
"14274152","14","1390328594145","159225"
"14274448","14","1390337455440","1"
"14274549","14","1390339008231","2"
"14276933","14","1390375942924","3"
"14276948","14","1390376143404","4"
"14276959","14","1390376308607","5"
"14276968","14","1390376453181","6"
"14276977","14","1390376568176","7"
"14276984","14","1390376667794","8"
"14276991","14","1390376757478","9"
"14276998","14","1390376841540","10"
"14277003","14","1390376921006","11"
"14277010","14","1390376995716","12"
"14277015","14","1390377061243","13"
"14277024","14","1390377176463","14.5"
"14277031","14","1390377279874","16.5"
"14277038","14","1390377374743","18.5"
"14277043","14","1390377462282","20.5"
"14277050","14","1390377542884","22.5"
"14277057","14","1390377617337","24.5"
"14277062","14","1390377686625","26.5"
"14277067","14","1390377751722","28.5"
"14277072","14","1390377813582","30.5"
"14277077","14","1390377901956","33"
"14277086","14","1390377986444","36"
"14277091","14","1390378067488","39"
"14277096","14","1390378144792","42"
"14277101","14","1390378218194","45"
"14277108","14","1390378287983","48"
"14277114","14","1390378354915","51"
"14277120","14","1390378419708","54"
"14277125","14","1390378482897","57"
"14277130","14","1390378544875","60"
"14277135","14","1390378626144","63.5"
"14277140","14","1390378706245","67.5"
"14277147","14","1390378785387","71.5"
"14277154","14","1390378863370","75.5"
"14277159","14","1390378939666","79.5"
"14277164","14","1390379013697","83.5"
"14277169","14","1390379085548","87.5"
"14277174","14","1390379155315","91.5"
"14277179","14","1390379223037","95.5"
"14277184","14","1390379288712","99.5"
"14277190","14","1390379352429","103.5"
==========================
Stelle ich den Kanal im Frontend jedoch auf "Elektrische Energie (S0-
Impulse)" so entsteht folgende Ausgabe (entspricht "power" in der DB):
Bild: s0-impulse
Sollten noch irgendwelche weiteren Angaben oder Hinweise fehlen bin
ich gern bereit sie, soweit möglich, nachzuliefern....
Da S0vz keine Aggregation kann ist das für mich keine mögliche
Alternative.
--
Gruss,
Michael
GnuPG-ID 0x1E4ED700 http://pgp.mit.edu/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: normal.jpeg
Type: image/jpeg
Size: 99466 bytes
Desc: not available
URL: <http://demo.volkszaehler.org/pipermail/volkszaehler-dev/attachments/20140125/8f4665c6/attachment-0003.jpeg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: spike.jpeg
Type: image/jpeg
Size: 85322 bytes
Desc: not available
URL: <http://demo.volkszaehler.org/pipermail/volkszaehler-dev/attachments/20140125/8f4665c6/attachment-0004.jpeg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: s0-impuls.jpeg
Type: image/jpeg
Size: 111623 bytes
Desc: not available
URL: <http://demo.volkszaehler.org/pipermail/volkszaehler-dev/attachments/20140125/8f4665c6/attachment-0005.jpeg>
More information about the volkszaehler-dev
mailing list