Log-reader problem

---

After spending hours getting the logreader coöp with my PV energy log in CSV format. I noticed that i’m missing the unit for values defined as string.

• Log content:
  id, total-on-time, uptime, total-kWh, actual-W, peak-W, resets, time
  cf7d, 34378228, 15349134, 671.79, 162.0, 701.4, 3, 1427723302.97

{
  "id": "PV-Tuinhuis",
  "name": "PV-Tuinhuis",
  "class": "LogWatcher",
  "file": "/home/pi/scripts/ec3k/ec3k2file.log",
  "attributes": [
    {
      "name": "Actual1",
      "type": "number",
      "unit": "Watt"
    },
    {
      "name": "Total",
      "type": "string",
      "unit": "kWh"
    },
    {
      "name": "Peak",
      "type": "string",
      "unit": "Watt"
    }
  ],
  "lines": [
    {
      "match": "\\s*cf7d, \\d*, \\d*, \\d*.\\d*, (.+)",
      "Actual1": "$1"
    },
    {
      "match": "\\s*cf7d, \\d*, \\d*, (\\d*.\\d*)",
      "Total": "$1"
    },
    {
      "match": "\\s*cf7d, \\d*, \\d*, \\d*.\\d*, \\d*.\\d*, (\\d*.\\d*)",
      "Peak": "$1"
    }
  ]
},

The right results are showed in pimatic, but without showing the “Unit”, when I change “string” into “number” “Unit” shows up, but I don’t want a Graph for all available log fields.

Is this a bug in the log-reader plugin? Or do I need to submit the Unit after $1? if so, how?

This is my config:

{
  "id": "temperature-from-logfile",
  "name": "Temperature",
  "class": "LogWatcher",
  "file": "/usr/local/pimatic-app/iobox/pimatic-setpoints.txt",
  "attributes": [
    {
      "name": "tempset1",
      "type": "number",
      "unit": "°C"
    },
    {
      "name": "tempset2",
      "type": "number",
      "unit": "°C"
    },
    {
      "name": "tempset3",
      "type": "number",
      "unit": "°C"
    }
  ],
  "lines": [
    {
      "match": "tempset1: (.+)",
      "tempset1": "$1"
    },
    {
      "match": "tempset2: (.+)",
      "tempset2": "$1"
    },
    {
      "match": "tempset3: (.+)",
      "tempset3": "$1"
    }
  ]
},

and this is my log file:

• TEMPERATURE-SETTINGS
  tempset1: 11
  tempset2: 12
  tempset3: 13
  zz

Works with unit “ºC”.

However there is a little problem.
See the last post in https://github.com/pimatic/pimatic/issues/620

Regards

Edited.- Read negative number are ok.

A good post to learn about log-reader

http://forum.pimatic.org/topic/85/read-data-from-smart-meter-using-p1-usb-cable/28

I don’t have troubels getting the right values out the logfile.

The configured device gives me this output (using examle logfile):
PV-Tuinhuis 162.0 Watt (graph) 671.790 701.4
while I expect to see:
PV-Tuinhuis 162.0 Watt (graph) 671.790 kWh 701.4 Watt
When I change “type” in attributes from string to number, the “units” do show up but also a graphic. And i’m not interested in building a history for these values:
PV-Tuinhuis 162.0 Watt (graph) 671.790 kWh (graph) 701.4 Watt (graph)

I think the “units” makes sense for numeric values.

In my opinion, the correct “type” would be “number”.

I you don’t need history for any values then change the “deviceAttributeLogging” in database options.

See http://forum.pimatic.org/topic/44/database-configuration-howto

by default:

• So the first entry in the default config says that all attributes are logged in an interval of 0 seconds (so all values) and are deleted after 7 days from the database, if not other entry matches. But there is an exception for continuous, temperature and humidity attributes. Continuous attributes (measured values by sensors) are only logged in an interval of 5 mins and temperature and humidity values are stored for the time of 1 year.

• All values with expire set to “0” are not written to the database at all.*

Thanks Tomansi for your support. I saw that last topic yesterday and did gave this a try without the expected result. Just to be sure I did try this again. thoug the database section shows “expire = 0” there still is a graph presented. For now I’ll give up.

Do you want to hide this little graph behind the value?
At the moment this isnt supported.
But with a little hack you can set it off.

Well that’s what I want, but I thought setting “type” to string would do this. And yes it does, but as side effect the “unit” isn’t displayed anymore. While I’m quiet sure i’ve seen someone in this forum with a config using type=string and (i think) unit m3 and a screen dump showing the vallue with "unit"
but i cant find it anymore

It is very easy.
Stop pimatic.
Go to this directory

/home/user/pimatic-app/node_modules/pimatic-log-reader/

open the file log-reader.coffee
and add between the line 72 and 73 this entry

            else
              throw new Error("Illegal type: #{attr.type} for attributes #{name} in LogWatcher.")              #line 72
          @attributes[name].displaySparkline = if attr.displaySparkline? then attr.displaySparkline else true  #this is the line to add
          # Create a getter for this attribute                                                                 #line 73
          @_createGetter name, ( => Promise.resolve @attributeValue[name] )

then open your config and add this to your device

{
  "id": "PV-Tuinhuis",
  "name": "PV-Tuinhuis",
  "class": "LogWatcher",
  "file": "/home/pi/scripts/ec3k/ec3k2file.log",
  "attributes": [
    {
      "name": "Actual1",
      "type": "number",
      "unit": "Watt",
      "displaySparkline": false
    },
    {
      "name": "Total",
      "type": "number",
      "unit": "kWh",
      "displaySparkline": false
    },
    {
      "name": "Peak",
      "type": "number",
      "unit": "Watt",
      "displaySparkline": false
    }
  ],
  "lines": [
    {
      "match": "\\s*cf7d, \\d*, \\d*, \\d*.\\d*, (.+)",
      "Actual1": "$1"
    },
    {
      "match": "\\s*cf7d, \\d*, \\d*, (\\d*.\\d*)",
      "Total": "$1"
    },
    {
      "match": "\\s*cf7d, \\d*, \\d*, \\d*.\\d*, \\d*.\\d*, (\\d*.\\d*)",
      "Peak": "$1"
    }
  ]
},