[vz-dev] Volkszaehler installation Doctrine path
info at steffenvogel.de
Thu Sep 15 16:14:17 CEST 2011
hey :) Yet another volkzaehler ;)
Am Mittwoch, den 14.09.2011, 23:18 +0200 schrieb Willy Verbiest:
> 1. At this time I want to see the demo data but I don't know what to
> enter in this dialog box.
By default the database is empty. I assume you automatically imported
the demo data via install.sh.
The demo Data is located in /misc/sql/demo/*.sql
Especially the UUID you need to add is in
Thanks for this hint. We are missing this uuid in our setup guide:
I added it now.
> I want to fill the database with values from my house counters. I will
> use 2 counters one for the electricity meter and one for the gas
> My computer board must read the 1-wire counters and put the data in
> the database.
Oh nice :) You are the first one who uses 1-wire counters to read his
meters. Welcome :)
There are 3 options to achieve this:
1. Write a shell sript to import them with curl/wget
2. Write a shell script to directly query your SQL database
3. Use vzlogger (doesn't has this functionally yet)
So theres only method 1 which will work with little effort:
You need to send HTTP requests via curl or wget:
<uuid> is the uuid of your meter
<timestamp> the time in miliseconds since 1970
<relative> the relative count of impulses since last request
Your propably need to save the absolute value of the last request to
calculate the delta.
Hint: you need to create your meter with &resolution=1000 (which stand
for 1000 impulses/kWh = 1 Impule/Wh)
I wouldnt suggest to fill it directly in the DB. Use the middleware.ph
> 3. Which tables do I have to fill with values from the meters?
The "data" table
> 4. What values do I have to insert in the table data?
channel_id as referenced in the "entity" table
timestamp in ms since 1970
value = the amount of pulses since last request.
> I know SQL that's not a problem.
Nice. Feel free to contribute :)
Im currently working on vzlogger. Thats a tool written in C to
read/buffer/log readings for volkszaehler.
At the moment we support SML, S0, D0 meters and OneWire Tempsensors.
It would be nice to support OneWire counters too.
Handy: +49 176 96978528
Mail: info at steffenvogel.de
Jabber: stv0g at jabber.ccc.de
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 490 bytes
Desc: This is a digitally signed message part
More information about the volkszaehler-dev