[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