FHEM reference

Perl special

Notes

define onAt at 07:00 set Lamp1 on;;set Lamp2 on;; define offAt at +00:10 set Lamp1 off;;;;set Lamp2 off

define onAt at 07:00 set Lamp1,Lamp2 on-for-timer 600

Device specification (devspec)

[EN DE]

a single device name. This is the most common case.
a list of devices, separated by comma (,)
a regular expression
a NAME=VALUE pair, where NAME can be an internal value like TYPE, a Reading-Name or an attribute. VALUE is a regexp. To negate the comparison, use NAME!=VALUE. To restrict the search, use i: as prefix for internal values, r: for readings and a: for attributes. See the example below. Case sensitivity is being ignored using ~ or !~.
if the spec is followed by the expression :FILTER=NAME=VALUE, then the values found in the first round are filtered by the second expression.

set lamp1 on

set lamp1,lamp2,lamp3 on

set lamp.* on

set room=kitchen off

set room=kitchen:FILTER=STATE=on off

set room=kitchen:FILTER=STATE!=off off

list disabled=

list room~office

list TYPE=FS20 STATE

list i:TYPE=FS20 STATE

the spec may not contain space characters.
if there is a device which exactly corresponds to the spec, then no special processing is done.
first the spec is separated by comma, then the regular expression and filter operations are executed.
the returned list can contain the same device more than once, so "set lamp3,lamp3 on" switches lamp3 twice.
for more complex structuring demands see the structure device.

Attributes

[EN DE]

All devices have attributes. These can be set by means of the attr command, displayed with the displayattr command, and deleted by the deleteattr command.

There are global attributes that are used by all devices and local attributes that apply to individual device classes only.

Some devices (like FHEMWEB) automatically define new global attributes on the first definition of a device of such type.

You can use the command

attr global userattr <attributelist>

for the global device to declare new global attributes and

attr <devicespec> userattr <attributelist>

for individual devices according to devspec to declare new local attributes. <attributelist> is a space-separated list which contains the names of the additional attributes. See the documentation of the attr command for examples.

Be careful not to overwrite additional global attributes previously defined by yourself or a device. Use the attr global userattr <attributelist> as early in your configuration as possible.

Device specific attributes

Device specific attributes are documented in the corresponding device section.

Global attributes used by all devices

alias
Used by FHEMWEB to display a device with another name e.g. when using special characters/spaces not accepted by device definition.

comment
Add an arbitrary comment.

eventMap
Replace event names and set arguments. The value of this attribute consists of a list of space separated values, each value is a colon separated pair. The first part specifies the "old" value, the second the new/desired value. If the first character is slash(/) or comma(,) then split not by space but by this character, enabling to embed spaces. You can specify a widgetOverride after an additional colon (e.g. on-for-timer:OnFor:texField), the default widget is :noArg to avoid extra input fields in cmdList. Examples:
The explicit variant of this attribute has the following syntax:
This variant must be used, if the mapping is not symmetrical, the first part (dev) representing the device to user mapping, i.e. if the device reports on 100 or on-for-timer 100, the user will see open 100. The second part (usr) is the other direction, if the user specified open 10, the device will receive on 10. On both occasions the key will be first compared directly with the text, and if it is not equal, then it will be tried to match it as a regexp. When using regexps in the usr part with wildcards, the fw part must be filled with the exact same keys to enable a correct display in the FHEMWEB set dropdown list in the detail view.

genericDisplayType
used by some frontends (but not FHEMWEB) to offer a default image or appropriate commands for this device. Currently the following values are supported: switch,outlet,light,blind,speaker,thermostat

group
Group devices. Recognized by web-pgm2 (module FHEMWEB), it makes devices in the same group appear in the same box). This is used to further group devices together. A device can appear in more than one group, in this case the groups have to be specified comma-separated.
If this attribute is not set then the device type is used as the grouping attribute.

room
Filter/group devices in frontends. A device can appear in more than one room, in this case the rooms have to be specified comma-separated.
Devices in the room hidden will not appear in the web output, or set the FHEMWEB attribute hiddenroom to selectively disable rooms for certain FHEMWEB instances. The -> string is considered as a structure separator for rooms, e.g. "1st. floor->Master bedroom".

suppressReading
Used to eliminate unwanted readings. The value is a regular expression, with ^ and $ added. Only necessary in exceptional cases.

showtime
Used in the webfrontend pgm2 to show the time of last activity instead of the state in the summary view. Useful e.g. for FS20 PIRI devices.

verbose
Set the verbosity level. Possible values:
- 0 - server start/stop
- 1 - error messages or unknown packets
- 2 - major events/alarms.
- 3 - commands sent out will be logged.
- 4 - you'll see whats received by the different devices.
- 5 - debugging.
The value for the global device is a default for other devices without own verbose attribute set.

readingFnAttributes

The following global attributes are honored by the modules that make use of the standardized readings updating mechanism in fhem.pl. Check the module's attribute list if you want to know if a device supports these attributes.

stateFormat
Modifies the STATE of the device, shown by the list command or in the room overview in FHEMWEB. If not set, its value is taken from the state reading. If set, then every word in the argument is replaced by the value of the reading if such a reading for the current device exists. If the value of this attribute is enclused in {}, then it is evaluated. This attribute is evaluated each time a reading is updated.
The "set magic" described here is also applied.

event-on-update-reading
If not set, every update of any reading creates an event, which e.g. is handled by notify or FileLog. The attribute takes a comma-separated list of readings. You may use regular expressions in that list. If set, only updates of the listed readings create events.

event-on-change-reading
The attribute takes a comma-separated list of readings. You may use regular expressions in that list. If set, only changes of the listed readings create events. In other words, if a reading listed here is updated with the new value identical to the old value, no event is created. If an optional [:threshold] is given after a reading name events are only generated if the change is >= threshold.

If both attributes are not set, any update of any reading of the device creates an event.
If any of the attributes is set, no events occur for updates or changes of readings not listed in any of the attributes.
If a reading is listed in event-on-update-reading, an update of the reading creates an event no matter whether the reading is also listed in event-on-change-reading.

timestamp-on-change-reading
The attribute takes a comma-separated list of readings. You may use regular expressions in that list. If set, the timestamps of the listed readings will not be changed if event-on-change-reading is also set and it would not create an event for this reading.

event-aggregator

This attribute takes a comma-separated list of reading:interval:method:function:holdTime quintuples. You may use regular expressions for reading. If set, updates for the listed readings are ignored and associated events are suppressed for a black-out period of at least interval seconds (downsampling). After the black-out period has expired, the reading is updated with a value that is calculated from the values and timestamps of the previously ignored updates within the black-out period as follows:

function	description
v	the last value encountered
v0	the first value encountered
min	the smallest value encountered
max	the largest value encountered
mean	the arithmetic mean of all values
sd	the standard deviation from the mean
median	the median of all values (requires holdTime and function none)
integral	the arithmetic sum (if not time-weighted) or integral area (if time-weighted) of all values
n	number of samples
t	timestamp of the last value
t0	timestamp of the first value

If method is none, then that's all there is. If method is const or linear, the time-weighted series of values is taken into account instead. The weight is the timespan between two subsequent updates. With the const method, the value is the value of the reading at the beginning of the timespan; with the linear method, the value is the arithmetic average of the values at the beginning and the end of the timespan. Rollovers of black-out periods are handled as one would expect it.

One would typically use the linear method with the mean function for quantities continuously varying over time like electric power consumption, temperature or speed. For cumulative quantities like energy consumed, rain fallen or distance covered, the none method with the v function is used. The constant method is for discrete quantities that stay constant until the corresponding reading is updated, e.g. counters, switches and the like.

If the holdTime in seconds is defined, the samples will be kept in memory allowing the calculation of floating statistics instead of blocked statistics. With holdTime defined the interval can be kept undefined so that the readings update rate is unchanged or it can be set to a value less then holdTime for downsampling as described above with a full history of the readings in memory. Note that the historic samples are not persistent and will be lost when restarting FHEM.

The event aggregator only takes into consideration those updates that remain after preprocessing according to the event-on-update-reading and event-on-change-reading directives. Besides which, any update of a reading that occurs within a timespan from the preceding update that is smaller than the resolution of FHEM's time granularity is ditched.

When more than one function should be calculated for the same reading, the original reading must be multiplied (e.g. by using a notify) before applying the event-aggregator to the derived readings.

Examples:
attr myPowerMeter event-aggregator EP_POWER_METER:300:linear:mean,EP_ENERGY_METER:300:none:v
attr myBadSensor event-aggregator TEMP::none:median:300
attr mySunMeter event-aggregator SUN_INTENSITY_24H::const:integral:86400

event-min-interval
This attribute takes a comma-separated list of reading:minInterval pairs. You may use regular expressions for reading. Events will only be generated, if at least minInterval seconds elapsed since the last reading of the matched type. If event-on-change-reading is also specified, they are combined with OR: if one of them is true, the event is generated.

oldreadings
This attribute takes a comma-separated list of readings. You may use regular expressions in that list. For each reading in the list FHEM will internaly store the previous value if the readings value changes. To access the storead value use the OldReadings.* functions.

userReadings
A comma-separated list of definitions of user-defined readings. Each definition has the form:
After a single or bulk readings update, the user-defined readings are set by evaluating the perl code{ <perl code> } for all definitions and setting the value of the respective user-defined reading <reading> to the result. If <trigger> is given, then all processing for this specific user reading is only done if one of the just updated "reading: value" combinations matches <trigger>, which is treated as a regexp.
Examples:
<modifier> can take one of these values:
- none: the same as it would not have been given at all.
- difference: the reading is set to the difference between the current and the previously evaluated value.
- differential: the reading is set to the difference between the current and the previously evaluated value divided by the time in seconds between the current and the previous evaluation. Granularity of time is one second. No value is calculated if the time past is below one second. Useful to calculate rates.
- integral: reverse function of differential. The result is incremented by the product of the time difference between the last two readings and the avarage of the last two readings.
  result += (time - timeold) * (oldval + value) / 2
- offset: if the current evaluated value is smaler than the previously evaluated value the reading is incremented by the previous value. the reading can then be used as an offset correct for a counter that is reset for example due to a power loss.
- monotonic: if the difference between the current and the previously evaluated value is positive the reading is incremented by this difference. this allows to derive a monotonic growing counter from an original counter even if the original will be rest by a power loss
Example:
Notes:
- user readings with modifiers difference and differential store the calculated values internally. The user reading is set earliest at the second evaluation. Beware of stale values when changing definitions!
- the name of the defined Readings consists of alphanumeric characters with underscore (_) and the minus (-) sign.

Common attributes

The following local attributes are used by a wider range of devices:

IODev
Set the IO or physical device which should be used for sending signals for this "logical" device. An example for the physical device is an FHZ or a CUL. Note: Upon startup FHEM assigns each logical device (FS20/HMS/KS300/etc) the last physical device which can receive data for this type of device. The attribute IODev needs to be used only if you attached more than one physical device capable of receiving signals for this logical device.

Special: attribute disable can be toggled
Attribute "disable" can be toggled by issuing the following command:

attr <device> disable toggle

Attribute "disable" must be offered by the corresponding module

attr

[EN DE]

attr [-a|-r] <devspec> <attrname> [<value>]

define


    attr global verbose 3

    attr lamp room kitchen

    attr lamp group lights

    attr lamp loglevel 6

    attr weatherstation event-on-update-reading wind,temperature,humidity

    attr weatherstation event-on-change-reading israining

    attr weatherstation event-on-change-reading israining,state

    attr heating stateFormat Temp:measured-temp, Valve:actuator

    attr -a TYPE=SVG room ,SvgRoom

    attr -r TYPE=SVG room ,SvgRoom

See deleteattr to delete attributes.

cancel

[EN DE]

cancel [<id> [quiet]]

sleep

define

[EN DE]

define [option] <name> <type> <type-specific>

-temporary
Add the TEMPORARY flag to the definition, which will prevent saving the device to fhem.cfg.

-ignoreErr
Reduce the number of errors displayed when a certain FHEM-module cannot be loaded. Used by fhem.cfg.demo, as using the RSS example requires the installation of several uncommon perl modules.

defmod

[EN DE]

defmod [-temporary] <name> <type> <type-specific>


    define mdNtfy notify motionDetector defmod mdOff at +00:10 set lamp off

delete

[EN DE]

delete <devspec>

define

delete lamp

deleteattr

[EN DE]

deleteattr <devspec> [<attrname>]

attr

deleteattr lamp follow-on-for-timer

deleteattr lamp

deletereading

[EN DE]

deletereading <devspec> <readingname>

deletereading mySensor temp1

deletereading mySensor temp\d+

displayattr

[EN DE]

displayattr <devspec> [<attrname>]

attr


    fhem> di WEB

    menuEntries AlarmOn,/fhem?cmd=set%20alarm%20on

    room Misc.

    fhem> di WEB room

    Misc.

get

[EN DE]

get <devspec> <type-specific>

get <device> ?

include

[EN DE]

include <filename>

inform

[EN DE]

inform {on|onWithState|off|raw|timer|log|status} [regexp]

on
switch the inform mechanism on
onWithState
show the additional state event too
off
switch the inform mechanism off (both events and logs, see below)
raw
show only raw events from physical devices
timer
prepend a timestamp to each event
log
show messages written by the FHEM Log interface
status
show the current status

list

[EN DE]

list [devspec] [value]

list {-r|-R} devspec

  fhem> list

  Type list  for detailed info.

  Internal:
    global               (Internal)

  FHZ:
    FHZ                  (fhtbuf: 23)

  FS20:
    Btn4                 (on-old-for-timer)
    Roll1                (on)
    Stehlampe            (off)

  FHT:
    fl                   (measured-temp: 21.1 (Celsius))

  KS300:
    out1                 (T: 2.9  H: 74  W: 2.2  R: 8.2  IR: no)

  at:
    at_rollup            (Next: 07:00:00)

  notify:
    ntfy_btn4            (active)

  FileLog:
    avglog               (active)

name

  fhem> list fl

  Internals:
    CODE       5102
    DEF        5102
    NAME       fl
    NR         15
    STATE      measured-temp: 21.1 (Celsius)
    TYPE       FHT
    IODev      FHZ
  Attributes:
    room       Heizung
  Readings:
    2006-11-02 09:45:56   actuator        19%
    [...]

modify

[EN DE]

modify <name> <type-dependent-options>

define lampon at 19:00 set lamp on

modify lampon *19:00

modify lampon 19:00 set lamp on-for-timer 16

quit

[EN DE]

quit

reload

[EN DE]

reload <module>

reload 99_PRIV

rename

[EN DE]

rename <oldname> <newname>

rename FHT_1234 fht.kitchen

rereadcfg

[EN DE]

rereadcfg [fhem-config-file]

statefile

rereadcfg

save

[EN DE]

save [<configfile>]

statefile

configfile

save only writes out definitions and attributes, but no (set/get) commands which were previously part of the config file. If you need such commands after the initialization (e.g. FHTcode), you should trigger them via notify, when receiving the INITIALIZED event.
save tries to preserve comments (lines starting with #) and include structures, but it won't work correctly if some of these files are not writeable.
before overwriting the files, the old version will be saved, see the restoreDirs global attribute for details.

set

[EN DE]

set <devspec> <type-specific>

set <name> ?

[device:name] with the reading, internal or attribute of the device, if both device and the reading, internal or attribute exists.
- You can use the r:, i: or a: prefix to restrict the search to one type, analogue to the devspec filtering.
- The suffix :d retrieves the first number
- The suffix :i retrieves the integer part of the first number.
- The suffix :r<n> retrieves the first number and rounds it to <n> decimal places. If <n> is missing, then rounds it to one decimal place.
- The suffix :t returns the timestamp (works only for readings)
- The suffix :sec returns the number of seconds since the reading was set.
Example:
[device:name:d] same as above, but only the number is retrieved
[device:name:sec] same as above, but only the number is retrieved
{(perlExpression)} with the result of perlExpression. The $DEV variable is additionally available, designating the set device name.

set extensions

on-for-timer <seconds>
Issue the on command for the device, and after <seconds> the off command. For issuing the off command an internal timer will be scheduled, which is deleted upon a restart. To delete this internal timer without restart specify 0 as argument.
off-for-timer <seconds>
see on-for-timer above.
on-till <timedet>
Issue the on command for the device, and create an at definition with <timedet> (in the form HH:MM[:SS]) to set it off. This definition is visible, and its name is deviceName+"_till". To cancel the scheduled off, delete the at definition. Note: on-till is not active, if the specified time is after the current time, in order to make things like
easy.
on-till-overnight <timedet>
Like on-till, but wont compare the current time with the timespec, so following will work:
off-till <timedet>
see on-till above.
off-till-overnight <timedet>
see on-till-overnight above.
blink <number> <blink-period>
set the device on for <blink-period> then off for <blink-period> and repeat this <number> times. To stop blinking specify "0 0" as argument.
intervals <from1>-<till1> <from2>-<till2>...
set the device on for the specified intervals, which are all timespecs in the form HH:MM[:SS]. The intervals are space separated.
toggle
Issue the off command, if the current STATE is on, else the on command. dim XX is also interpreted as on, if XX is not 0.


    set switch on-for-timer 12.5

    set switch on-till {sunset()}

    set switch blink 3 1

    set switch intervals 08:00-12:00 13:00-18:00

setdefaultattr

[EN DE]

setdefaultattr [<attrname> [<value>]]

setdefaultattr room kitchen

setdefaultattr loglevel 4

define lamp1 FS20 1234 11

define lamp2 FS20 1234 12

define lamp3 FS20 1234 13

setdefaultattr

There is no way to delete a single default-attribute from the list

setreading

[EN DE]

setreading <devspec> <reading> <value>

<name>

setreading lamp state on

setstate

[EN DE]

setstate <devspec> <value>

<devspec>

statefile

setstate lamp on

shutdown

[EN DE]

shutdown [restart|exitValue]

state information

shutdown

shutdown restart

shutdown 1

sleep

[EN DE]

sleep <sec> [<id>] [quiet]

cancel

trigger

[EN DE]

trigger <devspec> <state>

Wiki page for AMAD (german only)

trigger btn3 on

global

[EN DE]

Define

N/A

Set

N/A

Get

N/A

Attributes

archivedir
archivecmd
nrarchive

archivesort
archivesort may be set to the (default) alphanum or timestamp, and specifies how the last files are computed for the nrarchive attribute.

autoload_undefined_devices
If set, automatically load the corresponding module when a message of this type is received. This is used by the autocreate device, to automatically create a FHEM device upon receiving a corresponding message.

autosave
enable some modules to automatically trigger save after a configuration change, e.g. after a new device was created. Default is 1 (true), you can deactivate this feature by setting the value to 0.

backupcmd
You could pass the backup to your own command / script by using this attribute. If this attribute is specified, then it will be started as a shell command and passes a space separated list of files / directories as one argument to the command, like e.g.:
Note: Your command / script has to return the string "backup done" or everything else to report errors, to work properly with update!
This Attribute is used by the backup command.
Example:

backupdir
A folder to store the compressed backup file. This Attribute is used by the backup command.
Example:

backupsymlink
If this attribute is set to everything else as "no", the archive command tar will support symlinks in your backup. Otherwise, if this attribute is set to "no" symlinks are ignored by tar. This Attribute is used by the backup command.
Example:

blockingCallMax
Limit the number of parallel running processes started by the BlockingCall FHEM helper routine. Useful on limited hardware.

configfile
Contains the name of the FHEM configuration file. If save is called without argument, then the output will be written to this file.

commandref
If set to "full" (default), then a full commandref will be generated after each update. If set to modular, there is only a short description at the beginning, and the module documentation is loaded from FHEM dynamically.

dnsHostsFile
If dnsServer is set, check the contents of the file specified as argument. To use the system hosts file, set it to /etc/hosts on Linux/Unix/OSX and C:\windows\system32\drivers\etc\hosts on Windows. Note: only IPv4 is supported.

dnsServer
Contains the IP address of the DNS Server. If some of the modules or user code calls the HttpUtils_NonblockingGet function, and this attribute is set, then FHEM specific nonblocking code will be used to resolve the given address. If this attribute is not set, the blocking OS implementation (inet_aton and gethostbyname) will be used.

featurelevel
Enable/disable old or new features, based on FHEM version. E.g. the $value hash for notify is only set for featurelevel up to 5.6, as it is deprecated, use the Value() function instead.

holiday2we
If this attribute is set, then the $we variable will be true, if the value of the holiday variable referenced by this attribute is not none.
If it is a comma separated list, then it is true, if one of the referenced entities is not none.
Example:

httpcompress
the HttpUtils module is used by a lot of FHEM modules, and enables compression by default. Set httpcompress to 0 to disable this feature.

keyFileName
FHEM modules store passwords and unique IDs in the file FHEM/FhemUtils/uniqueID. In order to start multiple FHEM instances from the same directory, you may set this attribute, whose value will appended to FHEM/FhemUtils/

logdir
If set, the %L attribute in the logfile attribute (or in the FileLog modules file definition) is replaced wth the value of the attribute. Note: changing the value won't result in moving the files and may cause other problems.

logfile
Specify the logfile to write. You can use "-" for stdout, in this case the server won't background itself.
The logfile name can also take wildcards for easier logfile rotation, see the FileLog section. Just apply the archivecmd / archivedir / nrarchive attributes to the global device as you would do for a FileLog device.
You can access the current name of the logfile with { $currlogfile }.

modpath
Specify the path to the modules directory FHEM. The path does not contain the directory FHEM. Upon setting the attribute, the directory will be scanned for filenames of the form NN_<NAME>.pm, and make them available for device definition under <NAME>. If the first device of type <NAME> is defined, the module will be loaded, and its function with the name <NAME>_Initialize will be called. Exception to this rule are modules with NN=99, these are considered to be utility modules containing only perl helper functions, they are loaded at startup (i.e. modpath attribute definition time).

motd
Message Of The Day. Displayed on the homescreen of the FHEMWEB package, or directly after the telnet logon, before displaying the fhem> prompt. SecurityCheck is setting motd if it is not defined upon startup, to avoid this set the motd value to none. motd is also used to show collected error messages upon FHEM start.

mseclog
If set, the timestamp in the logfile will contain a millisecond part.

nofork
If set and the logfile is not "-", do not try to background. Needed on some Fritzbox installations, and it will be set automatically for Windows.

pidfilename
Write the process id of the perl process to the specified file. The server runs as a daemon, and some distributions would like to check by the pid if we are still running. The file will be deleted upon shutdown.

proxy
IP:PORT of the proxy server to be used by HttpUtils.

proxyAuth
Base64 encoded username:password

proxyExclude
regexp for hosts to exclude when using a proxy

restoreDirs
update saves each file before overwriting it with the new version from the Web. For this purpose update creates a directory restoreDir/update in the global modpath directory, then a subdirectory with the current date, where the old version of the currently replaced file is stored. The default value of this attribute is 3, meaning that 3 old versions (i.e. date-directories) are kept, and the older ones are deleted.
fhem.cfg and fhem.state will be also copied with this method before executing save into restoreDir/save/YYYY-MM-DD. To restore the files, you can use the restore FHEM command.

If the attribute is set to 0, the feature is deactivated.

sendStatistics
statefile
Set the filename where the state and certain at information will be saved before shutdown. If it is not specified, then no information will be saved.

title
useInet6
try to use IPv6 in HttpUtils for communication. If the server does not have an IPv6 address, fall back to IPv4. Note: IO::Socket::INET6 is required.

userattr
A space separated list which contains the names of additional attributes for all devices. Without specifying them you will not be able to set them (in order to prevent typos).
userattr can also specified for other devices, in this case these additinal attribute names are only valid for this device.

dupTimeout
Define the timeout for which 2 identical events from two different receiver are considered a duplicate. Default is 0.5 seconds.

showInternalValues
Show data used for internal computations. If the name of an internal value, reading or attribute starts with dot (.), then it is normally hidden, and will only be visible, if this attribute is set to 1. The attribute is checked by the list command, by the FHEMWEB room overview and by xmllist.

sslVersion
Specifies the accepted cryptography algorithms by all modules using the TcpServices helper module. The current default TLSv12:!SSLv3 is thought to be more secure than the previously used SSLv23:!SSLv3:!SSLv2, but it causes problems with some not updated web services.

stacktrace
if set (to 1), dump a stacktrace to the log for each "PERL WARNING".

restartDelay
set the delay for shutdown restart, default is 2 (seconds).

Events:

INITIALIZED
after initialization is finished.
REREADCFG
after the configuration is reread.
SAVE
before the configuration is saved.
SHUTDOWN
before FHEM is shut down.
DEFINED <devname>
after a device is defined.
DELETED <devname>
after a device was deleted.
RENAMED <old> <new>
after a device was renamed.
UNDEFINED <defspec>
upon reception of a message for an undefined device.
MODIFIED <defspec>
after a device modification.
UPDATE
after an update is completed.

ALL3076

[EN DE]

Define

define <name> ALL3076 <ip-address>

define lamp1 ALL3076 192.168.1.200

Set

set <name> <value>

value

    dimdown
    dim10%
    dim20%
    dim30%
    dim40%
    dim50%
    dim60%
    dim70%
    dim80%
    dim90%
    dim100%
    dim[0-100]%
    dimup
    off
    on
    toggle

set lamp1 on

set lamp1 dim11%

set lamp2 toggle

Toggle is special implemented. List name returns "on" or "off" even after a toggle command

ALL4000T

[EN DE]

Define

define <name> ALL4000T <ip-address> <port> <delay>

define AUSSEN.POOL.TEMP.vorlauf ALL4000T 192.168.68.20 t2 120

ALL4027

[EN DE]

Define

define <name> ALL4027 <ip-address> <port> <relay_nr> <delay>

define lamp1 ALL4027 192.168.8.200 0 7 60

Set

set <name> <value>

value

    off
    on
    on-for-timer <Seconds>
    toggle

set poolpump on

Toggle is special implemented. List name returns "on" or "off" even after a toggle command

AMADCommBridge

[EN DE]

AMAD - Automagic Android Device

AMADCommBridge - Communication bridge for all AMAD devices

Define

define <name> AMADCommBridge

define AMADBridge AMADCommBridge

For Autoremote:

For Tasker:

Readings

JSON_ERROR - JSON Error message reported by Perl
JSON_ERROR_STRING - The string that caused the JSON error message
fhemServerIP - The IP address of the FHEM server, is set by the module based on the JSON string from the installation wizard. Can also be set by user using set command
receiveFhemCommand - is set the fhemControlMode attribute to trigger, the reading is set as soon as an FHEM command is sent. A notification can then be triggered.
If set instead of trigger setControl as value for fhemControlMode, the reading is not executed but the set command executed immediately.
receiveVoiceCommand - The speech control is activated by AMAD (set DEVICE activateVoiceInput), the last recognized voice command is written into this reading.
receiveVoiceDevice - Name of the device from where the last recognized voice command was sent
state - state of the Bridge, open, closed

Attributes

allowFrom - Regexp the allowed IP addresses or hostnames. If this attribute is set, only connections from these addresses are accepted.
Attention: If allowfrom is not set, and no kind allowed instance is defined, and the remote has a non-local address, then the connection is rejected. The following addresses are considered local:
IPV4: 127/8, 10/8, 192.168/16, 172.16/10, 169.254/16
IPV6: ::1, fe80/10
debugJSON - If set to 1, JSON error messages are written in readings. See JSON_ERROR * under Readings
fhemControlMode - Controls the permissible type of control of FHEM devices. You can control the bridge in two ways FHEM devices. Either by direct FHEM command from a flow, or as a voice command by means of voice control (set DEVICE activateVoiceInput)
- trigger - If the value trigger is set, all FHEM set commands sent to the bridge are written to the reading receiveFhemCommand and can be executed using notify. Voice control is possible; readings receiveVoice * are set. On the Android device several voice commands can be linked by means of "and". Example: turn on the light scene in the evening and turn on the TV
- setControl - All set commands sent via the flow are automatically executed. The triggering of a reading is not necessary. The control by means of language behaves like the value trigger
- thirdPartControl - Behaves as triggered, but in the case of voice control, a series of voice commands by means of "and" is not possible. Used for voice control via modules of other module authors ((z.B. 39_TEERKO.pm)

AMADDevice

[EN DE]

AMAD - Automagic Android Device

using the Android app "Automagic" or "Tasker"

How to use AMADDevice?

first, make sure that the AMADCommBridge in FHEM was defined
Using Automagic

install the "Automagic Premium" app from the PlayStore
install the flowset 74_AMADDeviceautomagicFlowset$VERSION.xml file from the $INSTALLFHEM/FHEM/lib/ directory on the Android device
activate the "installation assistant" Flow in Automagic. If one now sends Automagic into the background, e.g. Homebutton, the assistant starts and creates automatically a FHEM device for the android device

Using Tasker

install the "Tasker" app from the PlayStore
install the Tasker-project 74_AMADtaskerset_$VERSION.prj.xml file from the $INSTALLFHEM/FHEM/lib/ directory on the Android device
run the "AMAD" task in Tasker and make your initial setup, by pressing the "create Device" button it will automatically create the device in FHEM

Define a AMADDevice device by hand.

Define

define <name> AMADDevice <IP-ADRESSE> <AMAD_ID> <REMOTESERVER>

define WandTabletWohnzimmer AMADDevice 192.168.0.23 123456 Automagic

Readings

airplanemode - on/off, state of the aeroplane mode
androidVersion - currently installed version of Android
automagicState - state of the Automagic or Tasker App (prerequisite Android >4.3). In case you have Android >4.3 and the reading says "not supported", you need to enable Automagic/Tasker inside Android / Settings / Sound & notification / Notification access
batteryHealth - the health of the battery (1=unknown, 2=good, 3=overheat, 4=dead, 5=over voltage, 6=unspecified failure, 7=cold) (Automagic only)
powerPercent - state of battery in %
batterytemperature - the temperature of the battery (Automagic only)
bluetooth - on/off, bluetooth state
checkActiveTask - state of an app (needs to be defined beforehand). 0=not active or not active in foreground, 1=active in foreground, see note below (Automagic only)
connectedBTdevices - list of all devices connected via bluetooth (Automagic only)
connectedBTdevicesMAC - list of MAC addresses of all devices connected via bluetooth (Automagic only)
currentMusicAlbum - currently playing album of mediaplayer (Automagic only)
currentMusicApp - currently playing player app (Amazon Music, Google Play Music, Google Play Video, Spotify, YouTube, TuneIn Player, Aldi Life Music) (Automagic only)
currentMusicArtist - currently playing artist of mediaplayer (Automagic only)
currentMusicIcon - cover of currently play album Not yet fully implemented (Automagic only)
currentMusicState - state of currently/last used mediaplayer (Automagic only)
currentMusicTrack - currently playing song title of mediaplayer (Automagic only)
daydream - on/off, daydream currently active
deviceState - state of Android devices. unknown, online, offline.
doNotDisturb - state of do not Disturb Mode
dockingState - undocked/docked, Android device in docking station
flow_SetCommands - active/inactive, state of SetCommands flow
flow_informations - active/inactive, state of Informations flow
flowsetVersionAtDevice - currently installed version of the flowsets on the Android device
incomingCallerName - Callername from last Call
incomingCallerNumber - Callernumber from last Call
incomingWhatsAppMessage - last WhatsApp message
incomingTelegramMessage - last telegram message
incomingSmsMessage - last SMS message
intentRadioName - name of the most-recent streamed intent radio
intentRadioState - state of intent radio player
keyguardSet - 0/1 keyguard set, 0=no 1=yes, does not indicate whether it is currently active
lastSetCommandError - last error message of a set command
lastSetCommandState - last state of a set command, command send successful/command send unsuccessful
lastStatusRequestError - last error message of a statusRequest command
lastStatusRequestState - ast state of a statusRequest command, command send successful/command send unsuccessful
nextAlarmDay - currently set day of alarm
nextAlarmState - alert/done, current state of "Clock" stock-app
nextAlarmTime - currently set time of alarm
nfc - state of nfc service on/off
nfcLastTagID - nfc_id of last scan nfc Tag / In order for the ID to be recognized correctly, the trigger NFC TagIDs must be processed in Flow NFC Tag Support and the TagId's Commase-separated must be entered. (Automagic only)
powerPlugged - 0=no/1,2=yes, power supply connected
screen - on locked,unlocked/off locked,unlocked, state of display
screenBrightness - 0-255, level of screen-brightness
screenBrightnessMode - Adaptive brightness on,off
screenFullscreen - on/off, full screen mode (Automagic only)
screenOrientation - Landscape/Portrait, screen orientation (horizontal,vertical)
screenOrientationMode - auto/manual, mode for screen orientation
state - current state of AMAD device
userFlowState - current state of a Flow, established under setUserFlowState Attribut (Automagic only)
volume - media volume setting
volumeNotification - notification volume setting
wiredHeadsetPlugged - 0/1 headset plugged out or in

checkActiveTask

attr Nexus10Wohnzimmer checkActiveTask com.android.chrome

Set

activateVoiceInput - start voice input on Android device
bluetooth - on/off, switch bluetooth on/off
clearNotificationBar - All/Automagic, deletes all or only Automagic/Tasker notifications in status bar
closeCall - hang up a running call
currentFlowsetUpdate - start flowset/Tasker-project update on Android device
installFlowSource - install a Automagic flow on device, XML file must be stored in /tmp/ with extension xml. Example: set TabletWohnzimmer installFlowSource WlanUebwerwachen.xml (Automagic only)
doNotDisturb - sets the do not Disturb Mode, always Disturb, never Disturb, alarmClockOnly alarm Clock only, onlyImportant only important Disturbs
mediaPlay - play command to media App
mediaStop - stop command to media App
mediaNext - skip Forward command to media App
mediaBack - skip Backward to media App
nextAlarmTime - sets the alarm time. Only valid for the next 24 hours.
notifySndFile - plays a media-file which by default needs to be stored in the folder "/storage/emulated/0/Notifications/" of the Android device. You may use the attribute setNotifySndFilePath for defining a different folder.
openCall - initial a call and hang up after optional time / set DEVICE openCall 0176354 10 call this number and hang up after 10s
screenBrightness - 0-255, set screen brighness
screenBrightnessMode - turn Adaptive brightness on,off
screenMsg - display message on screen of Android device
sendintent - send intent string Example: set $AMADDEVICE sendIntent org.smblott.intentradio.PLAY url http://stream.klassikradio.de/live/mp3-192/stream.klassikradio.de/play.m3u name Klassikradio, first parameter contains the action, second parameter contains the extra. At most two extras can be used.
sendSMS - Sends an SMS to a specific phone number. Bsp.: sendSMS Dies ist ein Test|555487263
startDaydream - start Daydream
statusRequest - Get a new status report of Android device. Not all readings can be updated using a statusRequest as some readings are only updated if the value of the reading changes.
timer - set a countdown timer in the "Clock" stock app. Only minutes are allowed as parameter.
ttsMsg - send a message which will be played as voice message (to change laguage temporary set first character &en; or &de;)
userFlowState - set Flow/Tasker-profile active or inactive,set Nexus7Wohnzimmer Badezimmer:inactive vorheizen or set Nexus7Wohnzimmer Badezimmer vorheizen,Nachtlicht Steven:inactive
userFlowRun - executes the specified flow/task
vibrate - vibrate Android device
volume - set media volume. Works on internal speaker or, if connected, bluetooth speaker or speaker connected via stereo jack
volumeNotification - set notifications volume

Set (depending on attribute values)

changetoBtDevice - switch to another bluetooth device. Attribute setBluetoothDevice needs to be set. See note below! (Automagic only)
nfc - activate or deactivate the nfc Modul on/off. attribute root
openApp - start an app. attribute setOpenApp
openURL - opens a URLS in the standard browser as long as no other browser is set by the attribute setOpenUrlBrowser.Example: attr Tablet setOpenUrlBrowser de.ozerov.fully|de.ozerov.fully.MainActivity, first parameter: package name, second parameter: Class Name
screen - on/off/lock/unlock, switch screen on/off or lock/unlock screen. In Automagic "Preferences" the "Device admin functions" need to be enabled, otherwise "Screen off" does not work. attribute setScreenOnForTimer changes the time the display remains switched on! (Tasker supports only "off" command)
screenFullscreen - on/off, activates/deactivates full screen mode. attribute setFullscreen (Automagic only)
screenLock - Locks screen with request for PIN. attribute setScreenlockPIN - enter PIN here. Only use numbers, 4-16 numbers required. (Automagic only)
screenOrientation - Auto,Landscape,Portait, set screen orientation (automatic, horizontal, vertical). attribute setScreenOrientation
system - issue system command (only with rooted Android devices). reboot,shutdown,airplanemodeON (can only be switched ON) attribute root, in Automagic "Preferences" "Root functions" need to be enabled.
takePicture - take a camera picture Attribut setTakePictureResolution
takeScreenshot - take a Screenshot picture Attribut setTakeScreenshotResolution

Attribut

setAPSSID - set WLAN AccesPoint SSID to prevent WLAN sleeps (Automagic only)
setNotifySndFilePath - set systempath to notifyfile (default /storage/emulated/0/Notifications/
setTtsMsgSpeed - set speaking speed for TTS (For Automagic: Value between 0.5 - 4.0, 0.5 Step, default: 1.0)(For Tasker: Value between 1 - 10, 1 Step, default: 5)
setTtsMsgLang - set speaking language for TTS, de or en (default is de)
setTtsMsgVol - is set, change automatically the media audio end set it back
set setTakePictureResolution - set the camera resolution for takePicture action (800x600,1024x768,1280x720,1600x1200,1920x1080)
setTakePictureCamera - which camera do you use (Back,Front).

attr <DEVICE> BTdeviceName1|MAC,BTDeviceName2|MAC

attr Nexus10Wohnzimmer setBluetoothDevice Logitech_BT_Adapter|AB:12:CD:34:EF:32,Anker_A3565|GH:56:IJ:78:KL:76

state

initialized - shown after initial define.
active - device is active.
disabled - device is disabled by the attribute "disable".

Further examples and reading:

Alarm

[EN DE]

FHEM module to set up a house alarm system with 8 different alarm levels

Usage

German Wiki page

Define

define <name> Alarm
Defines the Alarm system.

This module uses the global attribute language to determine its output data
(default: EN=english). For German output set attr global language DE.
This module needs the JSON package.

Set

set <name> canceled <level>
cancels an alarm of level <level>, where <level> = 0..7
set <name> armed <level>
set <name> disarmed <level>
sets the alarm of level <level> to armed (i.e., active) or disarmed (i.e., inactive), where <level> = 0..7
set <name> locked
set <name> unlocked
sets the lockstate of the alarm module to locked (i.e., alarm setups may not be changed) resp. unlocked (i.e., alarm setups may be changed>)
set <name> save|restore
Manually save/restore the arm states to/from the external file AlarmFILE (save done automatically at each state modification, restore at FHEM start)

Get

get <name> version
Display the version of the module

Attributes

attr <name> hiddenroom <string>
Room name for hidden alarm room (containing only the Alarm device), default: AlarmRoom
attr <name> publicroom <string>
Room name for public alarm room (containing sensor/actor devices), default: Alarm
attr <name> lockstate locked|unlocked
locked means that alarm setups may not be changed, unlocked means that alarm setups may be changed>
attr <name> testbutton 0|1
1 means that a test button is displayed for every actor field
attr <name> statedisplay simple,color,table,none
defines how the state of all eight alarm levels is shown. Example for the case when alarm no. 0 is disarmed and only alarm no. 2 is raised:
- simple = OXOOOOO
- color = 0 1 2 3 4 5 6 7
- table = HTML mini table with colored fields for alarms
- none = no state display
attr <name> noicons 0|1
when set to 1, animated icons are suppressed
attr <name> iconmap list
comma separated list of alarm levels for which the main icon/widget is set to disarmed/mixed/armed. No default=icon static
attr <name> disarmcolor|armwaitcolor|armcolor|alarmcolor color
four color specifications to signal the states disarmed (default lightgray), armwait (default #ffe658), armed (default #53f3c7) and alarmed (default #fd5777)
attr <name> armdelay mm:ss
time until the arming of an alarm becomes operative (0:00 - 9:59 allowed)
attr <name> armwait action
FHEM action to be carried out immediately after the arm event
attr <name> armact action
FHEM action to be carried out at the arm event after the delay time
attr <name> disarmact action
FHEM action to be carried out on the disarming of an alarm
attr <name> cancelact action
FHEM action to be carried out on the canceling of an alarm
For each of the 8 alarm levels, several attributes hold the alarm setup. They should not be changed by hand, but through the web interface to avoid confusion: level<level>cond, level<level>start, level<level>end, level<level>autocan, level<level>msg, level<level>onact, level<level>offact
Standard attributes alias, comment, event-on-update-reading, event-on-change-reading, room, eventMap, loglevel, webCmd

Apt Update Information

[EN DE]

AptToDate - Retrieves apt information about Debian update state state

Define

define <name> AptToDate <HOST>

define fhemServer AptToDate localhost

Readings

state - update status about the server
os-release_ - all information from /etc/os-release
repoSync - status about last repository sync.
toUpgrade - status about last upgrade
updatesAvailable - number of available updates

Set

repoSync - fetch information about update state
toUpgrade - to run update process. this will take a moment

Get

showUpgradeList - list about available updates
showUpdatedList - list about updated packages, from old version to new version
showWarningList - list of all last warnings
showErrorList - list of all last errors

Attributes

disable - disables the device
upgradeListReading - add Upgrade List Reading as JSON
distupgrade - change upgrade prozess to dist-upgrade
disabledForIntervals - disable device for interval time (13:00-18:30 or 13:00-18:30 22:00-23:00)

Air Quality Index

[EN DE]

Define

define <name> Aqicn

define aqicnMaster Aqicn

Readings

APL - Air Pollution Level
AQI - Air Quality Index (AQI) of the dominant pollutant in city. Values are converted from µg/m³ to AQI level using US EPA standards. For more detailed information: https://en.wikipedia.org/wiki/Air_quality_index and https://www.airnow.gov/index.cfm?action=aqi_brochure.index.
CO-AQI - AQI of CO (carbon monoxide). An AQI of 100 for carbon monoxide corresponds to a level of 9 parts per million (averaged over 8 hours).
NO2-AQI - AQI of NO2 (nitrogen dioxide). See also https://www.airnow.gov/index.cfm?action=pubs.aqiguidenox
PM10-AQI - AQI of PM10 (respirable particulate matter). For particles up to 10 micrometers in diameter: An AQI of 100 corresponds to 150 micrograms per cubic meter (averaged over 24 hours).
PM2.5-AQI - AQI of PM2.5 (fine particulate matter). For particles up to 2.5 micrometers in diameter: An AQI of 100 corresponds to 35 micrograms per cubic meter (averaged over 24 hours).
O3-AQI - AQI of O3 (ozone). An AQI of 100 for ozone corresponds to an ozone level of 0.075 parts per million (averaged over 8 hours). See also https://www.airnow.gov/index.cfm?action=pubs.aqiguideozone
SO2-AQI - AQI of SO2 (sulfur dioxide). An AQI of 100 for sulfur dioxide corresponds to a level of 75 parts per billion (averaged over one hour).
temperature - Temperature in degrees Celsius
pressure - Atmospheric pressure in hectopascals (hPa)
humidity - Relative humidity in percent
state- Current AQI and air pollution level
status - condition of the data
pubDate- Local time of publishing the data
pubUnixTime - Unix time stamp of local time but converted wrongly, if local time is e.g. 1300 GMT+1, the time stamp shows 1300 UTC.
pubTimezone - Time zone of the city (UTC)
windspeed - Wind speed in kilometer per hour
windDirection - Wind direction
dominatPoll - Dominant pollutant in city
dewpoint - Dew in degrees Celsius
healthImplications - Information about Health Implications
htmlStyle - can be used to format the STATE and FHEMWEB (Example: stateFormate htmlStyle

get

stationSearchByCity - search station by city name and open the result in seperate popup window
update - fetch new data every x times

Attribute

interval - interval in seconds for automatically fetch data (default 3600)

ArduCounter

[EN DE]

Prerequisites

This module requires an Arduino Uno, Nano, Jeenode, NodeMCU, Wemos D1 or similar device based on an Atmel 328p or ESP8266 running the ArduCounter sketch provided with this module
In order to flash an arduino board with the corresponding ArduCounter firmware from within Fhem, avrdude needs to be installed.

Define

define <name> ArduCounter <device>

define <name> ArduCounter <ip:port>

define AC ArduCounter /dev/ttyUSB2@38400

define AC ArduCounter 192.168.1.134:80

Configuration of ArduCounter counters

attr AC pinX falling pullup 30

        define AC ArduCounter /dev/ttyUSB2
        attr AC factor 1000
        attr AC interval 60 300
        attr AC pinD4 falling pullup 5
        attr AC pinD5 falling pullup 30
        attr AC verboseReadings5
        attr AC pinD6 rising

Set-Commands

raw

flash

-b 57600

reset
saveConfig

Get-Commands

info

Attributes

do_not_notify
readingFnAttributes

pin.*

rising

falling

change

pullup

interval normal max min mincout

factor
readingNameCount[0-9]+
readingNameLongCount[0-9]+
readingNameInterpolatedCount[0-9]+
readingNamePower[0-9]+
readingFactor[0-9]+
readingStartTime[0-9]+
verboseReadings[0-9]+

flashCommand

avrdude -p atmega328P -c arduino -P [PORT] -D -U flash:w:[HEXFILE] 2>[LOGFILE]

-b 57600

keepAliveDelay

keepAliveTimeout
nextOpenDelay

openTimeout
silentReconnect
disable

Readings / Events

pin.*
long.*
interpolatedLong.*
reject.*
power.*
pinHistory.*

countDiff.*
timeDiff.*
seq.*

Astro

[EN DE]

FHEM module with a collection of various routines for astronomical data

Define

define <name> Astro
Defines the Astro device (only one is needed per FHEM installation).

Readings with prefix Sun refer to the sun, with prefix Moon refer to the moon. The suffixes for these readings are

Age = angle (in degrees) of body along its track
Az,Alt = azimuth and altitude angle (in degrees) of body above horizon
Dec,Ra = declination (in degrees) and right ascension (in HH:MM) of body position
Lat,Lon = latitude and longituds (in degrees) of body position
Diameter = virtual diameter (in arc minutes) of body
Distance,DistanceObserver = distance (in km) of body to center of earth or to observer
PhaseN,PhaseS = Numerical and string value for phase of body
Sign = Circadian sign for body along its track
Rise,Transit,Set = times (in HH:MM) for rise and set as well as for highest position of body

Readings with prefix Obs refer to the observer. In addition to some of the suffixes gives above, the following may occur

Date,Dayofyear = date
JD = Julian date
Season,SeasonN = String and numerical (0..3) value of season
Time,Timezone obvious meaning
IsDST = 1 if running on daylight savings time, 0 otherwise
GMST,LMST = Greenwich and Local Mean Sidereal Time (in HH:MM)

An SVG image of the current moon phase may be obtained under the link <ip address of fhem>/fhem/Astro_moonwidget?name='<device name>' Optional web parameters are [&size='<width>x<height>'][&mooncolor=<color>][&moonshadow=<color>]

Notes:

Calculations are only valid between the years 1900 and 2100
Attention: Timezone is taken from the local Perl settings, NOT automatically defined for a location
This module uses the global attribute language to determine its output data
(default: EN=english). For German output set attr global language DE.
The time zone is determined automatically from the local settings of the
operating system. If geocordinates from a different time zone are used, the results are
not corrected automatically.
Some definitions determining the observer position are used
from the global device, i.e.
attr global longitude <value>
attr global latitude <value>
attr global altitude <value> (in m above sea level)
These definitions are only used when there are no corresponding local attribute settings.
It is not necessary to define an Astro device to use the data provided by this module
To use its data in any other module, you just need to put require "95_Astro.pm";
at the start of your own code, and then may call, for example, the function
Astro_Get( SOME_HASH_REFERENCE,"dummy","text", "SunRise","2019-12-24");
to acquire the sunrise on Christmas Eve 2019

Get

get <name> json [<reading>]
get <name> json [<reading>] YYYY-MM-DD
get <name> json [<reading>] YYYY-MM-DD HH:MM:[SS]
returns the complete set or an individual reading of astronomical data either for the current time, or for a day and time given in the argument.
get <name> text [<reading>]
get <name> text [<reading>] YYYY-MM-DD
get <name> text [<reading>] YYYY-MM-DD HH:MM:[SS]
returns the complete set or an individual reading of astronomical data either for the current time, or for a day and time given in the argument.
get <name> version
Display the version of the module

Attributes

<interval>
Update interval in seconds. The default is 3600 seconds, a value of 0 disables the automatic update.

Some definitions determining the observer position:
attr <name> longitude <value>
attr <name> latitude <value>
attr <name> altitude <value> (in m above sea level)
attr <name> horizon <value> custom horizon angle in degrees, default 0
These definitions take precedence over global attribute settings.

Standard attributes alias, comment, event-on-update-reading, event-on-change-reading, room, eventMap, loglevel, webCmd

Aurora

[EN DE]

Define

define <name> Aurora <ip> [<interval>]

Aurora

define aurora Aurora 10.0.1.xxx 10

Readings

bri
the brightness reported from the device. the value can be betwen 1 and 254
colormode
the current colormode
ct
the colortemperature in mireds and kelvin
hue
the current hue
pct
the current brightness in percent
onoff
the current on/off state as 0 or 1
sat
the current saturation
state
the current state

with current bridge firware versions groups have all_on and any_on readings, with older firmware versions groups have no readings.
not all readings show the actual device state. all readings not related to the current colormode have to be ignored.
the actual state of a device controlled by a living colors or living whites remote can be different and will be updated after some time.

Set

on [<ramp-time>]
off [<ramp-time>]
toggle [<ramp-time>]
statusRequest
Request device status update.
pct <value> [<ramp-time>]
dim to <value>
Note: the FS20 compatible dimXX% commands are also accepted.
color <value>
set colortemperature to <value> kelvin.
bri <value> [<ramp-time>]
set brighness to <value>; range is 0-254.
dimUp [delta]
dimDown [delta]
ct <value> [<ramp-time>]
set colortemperature to <value> in mireds (range is 154-500) or kelvin (rankge is 2000-6493).
ctUp [delta]
ctDown [delta]
hue <value> [<ramp-time>]
set hue to <value>; range is 0-65535.
humUp [delta]
humDown [delta]
sat <value> [<ramp-time>]
set saturation to <value>; range is 0-254.
satUp [delta]
satDown [delta]
effect <name>
rgb <rrggbb>
set the color to (the nearest equivalent of) <rrggbb>

set extensions are supported.

<ramp-time> is given in seconds
multiple paramters can be set at once separated by :
Examples:
set LC on : transitiontime 100
set bulb on : bri 100 : color 4000

Get

rgb
RGB
devStateIcon
returns html code that can be used to create an icon that represents the device color in the room overview.

Attributes

color-icon
1 -> use lamp color as icon color and 100% shape as icon shape
2 -> use lamp color scaled to full brightness as icon color and dim state as icon shape
transitiontime
default transitiontime for all set commands if not specified directly in the set.
delayedUpdate
1 -> the update of the device status after a set command will be delayed for 1 second. usefull if multiple devices will be switched.
devStateIcon
will be initialized to {(Aurora_devStateIcon($name),"toggle")} to show device color as default in room overview.
webCmd
will be initialized to a device specific value

BDKM

[EN DE]

km200

get myBDKM INFO

Define

define <name> BDKM <IP-address|hostname> <GatewayPassword>
    <PrivatePassword> <MD5-Salt>

define <name> BDKM <IP-address|hostname> <AES-Key>

<name>

<IP-address>

<GatewayPassword>

<PrivatePassword>

<MD5-Salt>

Set

set <name> <ID> <value> ...

ID

get myBDKM INFO

set myBDKM /heatingCircuits/hc1/temporaryRoomSetpoint 22.0

set myBDKM RoomTemporaryDesiredTemp 22.0

set myBDKM /gateway/DateTime now

set myBDKM DateTime now

Get

get <name> <ID> <[raw|json]>...

ID

raw

json

get myBDKM /heatingCircuits/hc1/temporaryRoomGetpoint

get myBDKM RoomTemporaryDesiredTemp

get myBDKM DateTime

get myBDKM /gateway/instAccess

get myBDKM INFO

get myBDKM INFO temp

get myBDKM INFO Heaven Hell

get myBDKM INFO .*

INFO

Attributes

BaseInterval
The interval time in seconds between poll cycles. It defaults to 120 seconds. Which means that every 120 seconds a new poll collects values of IDs which turn it is.

InterPollDelay
The delay time in milliseconds between reading of two IDs from the gateway. It defaults to 0 (read as fast as possible). Some gateways/heatings seem to stop answering after a while when you are reading a lot of IDs. (verbose 2 "communication ERROR"). To avoid gateway hangups always try to read only as many IDs as really required. If it doesn't help try to increase the InterPollDelay value. E.g. start with 100.

ReadBackDelay
Read back delay for the set command in milliseconds. This value defaults to 500 (0.5s). After setting a value, the gateway need some time before the value can be read back. If this delay is too short after writing you will get back the old value and not the expected new one. The default should work in most cases.

HttpTimeout
Timeout for all HTTP requests in seconds (polling, set, get). This defaults to 10s. If there is no answer from the gateway for HttpTimeout time an error is returned. If a HTTP request expires while polling an error log (level 2) is generated and the request is automatically restarted after 60 seconds.

PollIds
Without this attribute FHEM readings are NOT generated automatically!
This attribute defines how and when IDs are polled within a base interval (set by atrribute BaseInterval).
The attribute contains list of space separated IDs and options written as
GatewayID:Modulo:Delta:Alias
Where Gateway is the real gateway ID like "/gateway/DateTime".
Modulo is the value which defines how often the GatewayID is polled from the gateway and checked for FHEM readings update. E.g. a value of 4 means that the ID is polled only every 4th cycle.
Delta defines the minimum difference a polled value must have to the previous reading, before a FHEM reading with the new value is generated.
Alias defines a short name for the GatewayID under which the gateway ID can be accessed. Also readings (Logfile entries) are generated with this short alias if set. If not set, the original ID is used.
In detail:
ID:1:0:Alias - poll every cycle, when difference >= 0 to previous reading (means always, also for strings) trigger FHEM reading to "Alias"
ID:1::Alias - poll every cycle, no Delta set => trigger FHEM reading to "Alias" on value change only
ID:0::Alias - update reading on startup once if reading changed (to the one prevously saved in fhem.save)
ID:1:0.5:Alias - poll every cycle, when difference => 0.5 trigger a FHEM reading to "Alias"
ID:15::Alias - poll every 15th cylce, update reading only if changed
ID:::Alias - update reading on (get/set) only and only if value changed
ID::0:Alias - update reading on (get/set) only and trigger reading always on get/set
ID - without colons ":", poll every cycle, update reading allways (same as ID:1:0:)
Also some usefull defaults can be set by the special keyword RC300DEFAULTS, RC35DEFAULTS, RC30DEFAULTS.
As I don't know anything about RC35 or RC30 the later keywords are currently empty (please send me some info with "get myBDKM INFO" :-)
Definitions set by the special keywords (see the module code for it) are overwritten by definitions later set in the attribute definition
Example:
Which means: Use RC300DEFAULTS, trigger FHEM reading "Date" when date has changed on startup only. Trigger FHEM reading "/system/info" (no aliasing) always on startup, poll water temperature every cycle and trigger FHEM reading "WaterTemp" when difference to last reading was at least 0.2 degrees.

BOSEST

[EN DE]

Note:

libwww-perl
libmojolicious-perl
libxml-simple-perl
libnet-bonjour-perl
libev-perl
liburi-escape-xs-perl
sox
libsox-fmt-mp3

sudo apt-get install libwww-perl libmojolicious-perl libxml-simple-perl libnet-bonjour-perl libev-perl

sudo apt-get install cpanminus

sudo cpanm Mojolicious

Link

Define

define <name> BOSEST

define bosesystem BOSEST

Set

set <name> <command> [<parameter>]

autoAddDLNAServers

General commands

on - power on the device
off - turn the device off
power - toggle on/off
volume [0...100] [+x|-x] - set the volume level in percentage or change volume by ±x from current level
channel 0...20 - select present to play
saveChannel 07...20 - save current channel to channel 07 to 20
play - start/resume to play
pause - pause the playback
stop - stop playback
nextTrack - play next track
prevTrack - play previous track
mute on|off|toggle - control volume mute
shuffle on|off - control shuffle mode
repeat all|one|off - control repeat mode
bass 0...10 - set the bass level
recent 0...15 - set number of names in the recent list in readings
source bluetooth,bt-discover,aux mode, airplay - select a local source

addDLNAServer Name1 [Name2] [Namex] - add DLNA servers Name1 (and Name2 to Namex) to the BOSE library
removeDLNAServer Name1 [Name2] [Namex] - remove DLNA servers Name1 (and Name2 to Namex) to the BOSE library

set BOSE_1234567890AB volume 25

Timer commands:

on-for-timer 1...x - power on the device for x seconds
off-for-timer 1...x - turn the device off and power on again after x seconds
on-till hh:mm:ss - power on the device until defined time
off-till hh:mm:ss - turn the device off and power on again at defined time
on-till-overneight hh:mm:ss - power on the device until defined time on the next day
off-till-overneight hh:mm:ss - turn the device off at defined time on the next day

set BOSE_1234567890AB on-till 23:00:00

Multiroom commands:

createZone deviceID - create multiroom zone (defines <name> as zoneMaster)
addToZone deviceID - add device <name> to multiroom zone
removeFromZone deviceID - remove device <name> from multiroom zone
playEverywhere - play sound of device <name> on all others devices
stopPlayEverywhere - stop playing sound on all devices

set BOSE_1234567890AB playEverywhere

TextToSpeach commands (needs Google Translate):

speak "message" [0...100] [+x|-x] [en|de|xx] - Text to speak, optional with volume adjustment and language to use. The message to speak may have up to 100 letters
speakOff "message" [0...100] [+x|-x] [en|de|xx] - Text to speak, optional with volume adjustment and language to use. The message to speak may have up to 100 letters. Device is switched off after speak
ttsVolume [0...100] [+x|-x] - set the TTS volume level in percentage or change volume by ±x from current level
ttsDirectory "directory" - set DLNA TTS directory. FHEM user needs permissions to write to that directory.
ttsLanguage en|de|xx - set default TTS language (default: en)
ttsSpeakOnError 0|1 - 0=disable to speak "not available" text
autoAddDLNAServers 0|1 - 1=automatically add all DLNA servers to BOSE library. This command is only for "main" BOSEST, not for devices/speakers!

set BOSE_1234567890AB speakOff "Music is going to switch off now. Good night." 30 en

Get

n/a

BRAVIA

[EN DE]

Define

define <name> BRAVIA <ip-or-hostname> [<poll-interval>]

set register

s_*	: status
ci_*	: content information

remotecontrol

Set

set <name> <option> <value>

application
List of applications. Applications are available with modells from 2013 and newer.
channel
List of all known channels. The module collects all visited channels. Channels can be loaded automtically with modells from 2013 and newer. (number of channels, see channelsMax).
channelDown
Switches a channel back.
channelUp
Switches a channel forward.
input
List of input channels. Imputs are available with modells from 2013 and newer.
mute
Set mute if Upnp is activated.
off
Switches TV to off. State of device will have been set to "set_off" for 60 seconds or until off-status is pulled from TV.
on
Switches TV to on, with modells from 2013 using WOL. State of device will have been set to "set_on" for 60 seconds or until on-status is pulled from TV.
pause
Pauses a playing of a recording, of an internal App, etc.
play
Starts playing of a recording, of an internal App, etc.
record
Starts recording of current content.
register
One-time registration of Fhem as remote control in the TV.
With requestFormat = "xml" registration works without parameter.
With requestFormat = "json" registration has to be executed twice.
The register option offers an additional input field:
1. Call with empty input. A PIN for registration has to be shown on the TV.
2. Insert PIN into input field and register again.
requestFormat
"xml" for xml based communication (modells from 2011 and 2012)
"json" for communication with modells from 2013 and newer
remoteControl
Sends command directly to TV.
statusRequest
Retrieves current status information from TV.
stop
Stops recording, playing of an internal App, etc.
text
Includes the given text into an input field on display.
toggle
Toggles power status of TV.
tvpause
Activates Timeshift mode.
upnp
Activates Upnp service used to control volume.
volume
Straight setting of volume. Upnp service has to be activated.
volumeDown
Decreases volume.
volumeUp
Increases volume.

Attributes

attr <name> <attribute> <value>

channelsMax
Maximum amount of channels to be displayed, default is 50.
macaddr
Enables power on of TV using WOL.

BS

[EN DE]

FHZ

busware wiki

brightness

lux

flags

Define

define <name> BS <sensor#> [<RExt>]

<sensor#>

<RExt>

define bs1 BS 1 40000

Set

N/A

Get

N/A

Attributes

do_not_notify
showtime
model (bs)
ignore
readingFnAttributes

Babble

[EN DE]

FHEM module for speech control of FHEM devices

Usage

German Wiki page

Define

define <name> babble
Defines the Babble device.

This module uses the global attribute language to determine its output data
(default: EN=english). For German output set attr global language DE.
This module needs the JSON package.
Only when the chatbot functionality of RiveScript is required, the RiveScript module must be installed as well, see https://github.com/aichaos/rivescript-perl

Usage

Babble_DoIt("<name>","<sentence>"[,<parm0>,<parm1>,...])

Babble_DoIt

If no stored command ist found, the sentence is passed to the local RiveScript interpreter if present
To have a FHEM register itself as a Babble Device, it must get an attribute value babbleDevice=<name>. The name parameter must either be unique to the Babble system, or it muts be of the form <name>_<digits>
Devices on remote FHEM installations are defined in the babbleDevices attribute, see below

Set

set <name> locked
set <name> unlocked
sets the lockstate of the babble module to locked (i.e., babble setups may not be changed) resp. unlocked (i.e., babble setups may be changed>)
set <name> save|restore
Manually save/restore the babble to/from the external file babbleFILE (save done automatically at each state modification, restore at FHEM start)
set <name> rivereload
Reload data for RiveScript Interpreter
set <name> test
Run a few test cases for normalization

Get

get <name> version
Display the version of the module
get <name> tokens
Obtain fresh csrfToken from remote FHEM installations (needed after restart of remote FHEM)

Attributes

attr <name> babbleDevices [<babble devname>:<FHEM devname>:1|2|3]*
space separated list of remote FHEM devices, each as a group separated by ':' consisting of
- a Babble device name
- a FHEM Device name
- an integer 1..3, indication which of the remoteFHEM functions to be called
The Babble device name may contain a *-character. If this is the case, it will be considered a regular expression, with the star replaced by (.*). When using Babble with a natural language sentence whose device part matches this regular expression, the character group addressed by the star sequence is placed in the variable $STAR, and used to replace this value in the command sequence.
attr <name> helpFunc <function name&rt;
name of a help function which is used in case no command is found for a certain device. When this function is called, the strings $DEV, $HELP, $PARM[0|1|2...] will be replaced by the devicename identified by Babble, the help text for this device and parameters passed to the Babble_DoIt function
attr <name> testParm(0|1|2|3) <string&rt;
if a command is not really excuted, but only tested, the values of these attributes will be used to substitute the strings $PARM[0|1|2...] in the tested command
attr <name> dnuFile <filename&rt;
if this filename is given, every sentence that could not be analyzed is stored in this file
attr <name> confirmFunc <function name&rt;
name of a confirmation function which is used in case a command is exceuted. When this function is called, the strings $DEV, $HELP, $PARM[0|1|2...] will be replaced by the devicename identified by Babble, the help text for this device and parameters passed to the Babble_DoIt function
attr <name> noChatBot 0|1
if this attribute is set to 1, a local RiveScript interpreter will be ignored even though it is present in the system
attr <name> remoteFHEM(0|1|2|3) [<user>:<password>@]<IP address:port&rt;
IP address and port for a remote FHEM installation
attr <name> remoteFunc(0|1|2|3) <function name&rt;
name of a Perl function that is called for addressing a certain remote FHEM device
attr <name> remoteToken(0|1|2|3) <csrfToken&rt;
csrfToken for addressing a certain remote FHEM device
attr <name> babbleIds ...
space separated list of identities by which babble may be addressed
attr <name> babbleSubs :,:, ...
space separated list of regular expressions and their replacements - this will be used on the initial sentence submitted to Babble (Note: a space in the regexp must be replaced by \s).
attr <name> babblePlaces ...
space separated list of special places to be identified in speech
attr <name> babbleNoPlaces ...
space separated list of rooms (in the local FHEM device) that should not appear in the list of place
attr <name> babbleStatus ...
space separated list of status identifiers to be identified in speech. Example: Status Value Weather Time
attr <name> babblePrepos ...
space separated list of prepositions to be identified in speech. Example: by in at on
attr <name> babbleTimes ...
space separated list of temporal adverbs. Example: today tomorrow
attr <name> babbleQuests ...
space separated list of questioning adverbs. Example: how when where
attr <name> babbleArticles ...
space separated list of articles to be identified in speech. Example: the
attr <name> babbleVerbs ,...: ,...:
space separated list of verb groups to be identified in speech. Each group consists of comma separated verb forms (conjugations as well as variations), followed by a ':' and then the infinitive form of the verb. Example: speak,speaks,say,says:speaking
attr <name> babbleWrites ...
space separated list of write verbs to be identified in speech. Example: send add remove
attr <name> babbleVerbParts ...
space separated list of verb parts to be identified in speech. Example: un re
attr <name> linkname <string>
Name for babble web link, default: babbles
attr <name> hiddenroom <string>
Room name for hidden babble room (containing only the Babble device), default: babbleRoom
attr <name> publicroom <string>
Room name for public babble room (containing sensor/actor devices), default: babble
attr <name> lockstate locked|unlocked
locked means that babble setups may not be changed, unlocked means that babble setups may be changed>

Broadlink

[EN DE]

Broadlink

rmmini

ppm install Crypt-CBC

ppm install Crypt-OpenSSL-AES

sudo apt-get install libcrypt-cbc-perl

sudo apt-get install libcrypt-rijndael-perl

sudo cpan Crypt/OpenSSL/AES.pm

Define

define <name> Broadlink <ip/host> <mac> <type=rmpro or rmmini or sp3 or sp3s>

define broadlinkWZ Broadlink 10.23.11.85 34:EA:34:F4:77:7B rmpro

mac

Set for rmpro

set <name> <commandSend> <command name>

Send a previous recorded command.
set <name> recordNewCommand <command name>

Records a new command. You have to specify a commandname
set <name> remove <command name>

Removes a recored command.
set <name> rename <old command name> <new command name>

Renames a recored command.
set <name> getTemperature

Get the device current enviroment Temperature

Set for rmmini

set <name> <commandSend> <command name>

Send a previous recorded command.
set <name> recordNewCommand <command name>

Records a new command. You have to specify a commandname
set <name> remove <command name>

Removes a recored command.
set <name> rename <old command name> <new command name>

Renames a recored command.

Set for sp3

set <name> on

Set the device on
set <name> off

Set the device off
set <name> toggle

Toggle the device on and off
set <name> getStatus

Get the device on/off status

Set for sp3s

set <name> on

Set the device on
set <name> off

Set the device off
set <name> toggle

Toggle the device on and off
set <name> getStatus

Get the device on/off status
set <name> getEnergy

Get the device current energy consumption

Attributes for all Broadlink Devices

socket_timeout

sets a timeout for the device communication

CALVIEW

[EN DE]

This module creates a device with deadlines based on calendar-devices of the 57_Calendar.pm module. You need to install the perl-modul Date::Parse!

Actually the module supports only the "get <> next" function of the CALENDAR-Modul. Define

define <Name> CALVIEW <calendarname(s) separate with ','> <next> <updateintervall in sec (default 43200)>

define myView CALVIEW Googlecalendar next

define myView CALVIEW Googlecalendar,holiday next 900

- setting the update interval is not needed normally because every calendar update triggers a caview update Set

set <Name> update

set myView update

this will manually update all readings from the given CALENDAR Devices Attribute

datestyle
not set - the default, disables displaying readings bdatetimeiso / edatetimeiso
ISO8601 - enables readings bdatetimeiso / edatetimeiso (start and end time of term ISO8601 formated like 2017-02-27T00:00:00)

disable
0 / not set - internal notify function enabled (default)
1 - disable the internal notify-function of CALVIEW wich is triggered when one of the given CALENDAR devices has updated

filterSummary

filterSummary <filtersouce>:<filtersummary>[,<filtersouce>:<filtersummary>]
not set - displays all terms (default .*:.*)
<filtersouce>:<filtersummary>[,<filtersouce>:<filtersummary>] - CALVIEW will display term where summary matches the <filtersouce>:<filtersummary>, several filters must be separated by comma (,) e.g.: filterSummary Kalender_Abfall:Leichtverpackungen,Kalender_Abfall:Bioabfall filterSummary Kalender_Abfall:Leichtverpackungen,Kalender_Feiertage:.*,Kalender_Christian:.*,Kalender_Geburtstage:.*

fulldaytext [text]
this text will be displayed in _timeshort reading for fullday terms (default ganztägig)

isbirthday
0 / not set - no age calculation (default)
1 - age calculation active. The module calculates the age with year given in description or location (see att yobfield).

maxreadings
defines the number of max term as readings

modes
here the CALENDAR modes can be selected , to be displayed in the view

oldStyledReadings
0 the default style of readings
1 readings look like "2015.06.21-00:00" with value "Start of Summer"

sourcecolor <calendername>:<colorcode>[,<calendername>:<colorcode>]
here you can define the termcolor for terms from your calendars for the calview tabletui widget, several calendar:color pairs must be separated by comma

timeshort
0 time in _timeshort readings formated 00:00:00
1 time in _timeshort readings formated 00:00

yobfield
_description - (default) year of birth will be read from term description
_location - year of birth will be read from term location
_summary - year of birth will be read from summary (uses the first sequence of 4 digits in the string)

weekdayformat
formats the name of the reading weekdayname
- de-long - (default) german, long name like Dienstag
- de-short - german, short name like Di
- en-long - english, long name like Tuesday
- en-short - english, short name like Tue

CM11

[EN DE]

Define

define <name> CM11 <serial-device>

define <name> FHZ <serial-device> strangetty

define x10if CM11 /dev/ttyUSB3

Set

set <name> reopen

Get

get <name> fwrev

error

get <name> time

error

Attributes

do_not_notify
dummy
model (CM11)

CO20

[EN DE]

Device::USB hast to be installed on the FHEM host.
It can be installed with 'cpan install Device::USB'
or on debian with 'sudo apt-get install libdevice-usb-perl''
FHEM has to have permissions to open the device. To configure this with udev rules see here: Install_AirSensor_Linux usb-sensors-linux
Advanced features are only available after setting the attribute advanced.
Almost all the hidden settings from the Windows application are implemented in this mode.
Readout of values gathered in standalone mode is not possible yet.

Define

define <name> CO20 [bus:device]

define CO20 CO20

Readings

voc
CO2 equivalents in ppm
debug
debug value
pwm
pwm value
r_h
resistance of heating element in Ohm (?)
r_s
resistance of sensor element in Ohm (?)

Get

update / air_data
trigger an update
flag_data
get internal flag values
knob_data
get internal knob values
stick_data
get stick information

Set

KNOB_CO2_VOC_level_warn1
sets threshold for yellow led
KNOB_CO2_VOC_level_warn2
sets threshold for red led
KNOB_Reg_Set
internal value, affects voc reading
KNOB_Reg_P
internal pid value
KNOB_Reg_I
internal pid value
KNOB_Reg_D
internal pid value
KNOB_LogInterval
log interval for standalone mode
KNOB_ui16StartupBits
set to 0 for no automatic calibration on startup
FLAG_WARMUP
warmup time left in minutes
FLAG_BURN_IN
burn in time left in minutes
FLAG_RESET_BASELINE
reset voc baseline value
FLAG_CALIBRATE_HEATER
trigger calibration / burn in
FLAG_LOGGING
value count from external logging

Attributes

interval
the interval in seconds used to read updates [10..]. the default ist 300.
retries
number of retries on USB read/write failures [0..20]. the default is 3.
timeout
the USB connection timeout in milliseconds [250..10000]. the default is 1000.
advanced
1 -> enables most of the advanced settings and readings described here
disable
1 -> disconnect and stop polling

CUL

[EN DE]

The CUL/CUN(O) is a family of RF devices sold by busware.de. With the opensource firmware culfw they are capable to receive and send different 433/868 MHz protocols (FS20/FHT/S300/EM/HMS/MAX!). It is even possible to use these devices as range extenders/routers, see the CUL_RFR module for details.

Some protocols (FS20, FHT and KS300) are converted by this module so that the same logical device can be used, irrespective if the radio telegram is received by a CUL or an FHZ device.
Other protocols (S300/EM) need their own modules. E.g. S300 devices are processed by the CUL_WS module if the signals are received by the CUL, similarly EMWZ/EMGZ/EMEM is handled by the CUL_EM module.

It is possible to attach more than one device in order to get better reception, FHEM will filter out duplicate messages.

Note: This module may require the Device::SerialPort or Win32::SerialPort module if you attach the device via USB and the OS sets strange default parameters for serial devices.

Define

define <name> CUL <device> <FHTID>


        modprobe usbserial vendor=0x03eb product=0x204b

Device::SerialPort

<device> specifies the host:port of the device, e.g. 192.168.0.244:2323

Set

reopen
Reopens the connection to the device and reinitializes it.

raw
Issue a CUL firmware command. See the this document for details on CUL commands.

freq / bWidth / rAmpl / sens
SlowRF mode only.
Set the CUL frequency / bandwidth / receiver-amplitude / sensitivity
Use it with care, it may destroy your hardware and it even may be illegal to do so. Note: The parameters used for RFR transmission are not affected.
- freq sets both the reception and transmission frequency. Note: Although the CC1101 can be set to frequencies between 315 and 915 MHz, the antenna interface and the antenna of the CUL is tuned for exactly one frequency. Default is 868.3 MHz (or 433 MHz)
- bWidth can be set to values between 58 kHz and 812 kHz. Large values are susceptible to interference, but make possible to receive inaccurately calibrated transmitters. It affects tranmission too. Default is 325 kHz.
- rAmpl is receiver amplification, with values between 24 and 42 dB. Bigger values allow reception of weak signals. Default is 42.
- sens is the decision boundary between the on and off values, and it is 4, 8, 12 or 16 dB. Smaller values allow reception of less clear signals. Default is 4 dB.

hmPairForSec
HomeMatic mode only.
Set the CUL in Pairing-Mode for the given seconds. Any HM device set into pairing mode in this time will be paired with FHEM.

hmPairSerial
HomeMatic mode only.
Try to pair with the given device. The argument is a 10 character string, usually starting with letters and ending with digits, printed on the backside of the device. It is not necessary to put the given device in learning mode if it is a receiver.

led
Set the CUL led off (00), on (01) or blinking (02).

ITClock
Set the IT clock for Intertechno V1 protocol. Default 250.

Get

version
returns the CUL firmware version

uptime
returns the CUL uptime (time since CUL reset)

raw
Issues a CUL firmware command, and waits for one line of data returned by the CUL. See the CUL firmware README document for details on CUL commands.

fhtbuf
CUL has a message buffer for the FHT. If the buffer is full, then newly issued commands will be dropped, and an "EOB" message is issued to the FHEM log. fhtbuf returns the free memory in this buffer (in hex), an empty buffer in the CUL V2 is 74 bytes, in CUL V3/CUN(O) 200 Bytes. A message occupies 3 + 2x(number of FHT commands) bytes, this is the second reason why sending multiple FHT commands with one set is a good idea. The first reason is, that these FHT commands are sent at once to the FHT.

ccconf
Read some CUL radio-chip (cc1101) registers (frequency, bandwidth, etc.), and display them in human readable form.

cmds
Depending on the firmware installed, CULs have a different set of possible commands. Please refer to the README of the firmware of your CUL to interpret the response of this command. See also the raw command.

credit10ms
One may send for a duration of credit10ms*10 ms before the send limit is reached and a LOVF is generated.

Attributes

addvaltrigger
Create triggers for additional device values. Right now these are RSSI and RAWMSG for the CUL family and RAWMSG for the FHZ.

connectCommand
raw culfw command sent to the CUL after a (re-)connect of the USB device, and sending the usual initialization needed for the configured rfmode.
do_not_notify
dummy
hmId
Set the HomeMatic ID of this device. If this attribute is absent, the ID will be F1<FHTID>. Note 1: After setting or changing this attribute you have to relearn all your HomeMatic devices. Note 2: The value must be a 6 digit hex number, and 000000 is not valid. FHEM won't complain if it is not correct, but the communication won't work.

hmProtocolEvents
Generate events for HomeMatic protocol messages. These are normally used for debugging, by activating "inform timer" in a telnet session, or looking at the Event Monitor window in the FHEMWEB frontend.
Example:

longids
Comma separated list of device-types for CUL that should be handled using long IDs. This additional ID allows it to differentiate some weather sensors, if they are sending on the same channel. Therefore a random generated id is added. If you choose to use longids, then you'll have to define a different device after battery change. Default is not to use long IDs.
Modules which are using this functionality are for e.g. : 14_Hideki, 41_OREGON, 14_CUL_TCM97001, 14_SD_WS07.
Examples:

model (CUL,CUN,etc)
sendpool
If using more than one CUL for covering a large area, sending different events by the different CUL's might disturb each other. This phenomenon is also known as the Palm-Beach-Resort effect. Putting them in a common sendpool will serialize sending the events. E.g. if you have three CUN's, you have to specify following attributes:
attr CUN1 sendpool CUN1,CUN2,CUN3 attr CUN2 sendpool CUN1,CUN2,CUN3 attr CUN3 sendpool CUN1,CUN2,CUN3

rfmode
Configure the RF Transceiver of the CUL (the CC1101). Available arguments are:
- SlowRF
  To communicate with FS20/FHT/HMS/EM1010/S300/Hoermann devices @1 kHz datarate. This is the default.
- HomeMatic
  To communicate with HomeMatic type of devices @10 kHz datarate.
- MAX
  To communicate with MAX! type of devices @10 kHz datarate.
- WMBus_S
- WMBus_T
- WMBus_C
  To communicate with Wireless M-Bus devices like water, gas or electrical meters. Wireless M-Bus uses three different communication modes, S-Mode, T-Mode and C-Mode. While in this mode, no reception of other protocols like SlowRF or HomeMatic is possible. See also the WMBUS FHEM Module.

showtime
readingFnAttributes

CUL_EM

[EN DE]

Define

define <name> CUL_EM <code> [corr1 corr2
                CostPerUnit BasicFeePerMonth]

corr1

corr2

for EMWZ devices you should specify the rotation speed (R/kW) of your watt-meter (e.g. 150) for corr1 and 12 times this value for corr2
for EMEM devices the corr1 value is 0.01, and the corr2 value is 0.001

CostPerUnit

BasicFeePerMonth


    define emwz 1 75 900 0.15 12.50


    CUM_DAY: 6.849 CUM: 60123.4 COST: 1.02

    CUM_MONTH: 212.319 CUM: 60123.4 COST: 44.34

Set

N/A

Get

N/A

Attributes

ignore

do_not_notify

showtime

model (EMEM,EMWZ,EMGZ)

IODev

eventMap

readingFnAttributes

maxPeak <number>
Specifies the maximum possible peak value for the EM meter ("TOP:" value in logfile). Peak values greater than this value are considered as EM read errors and are ignored. For example if it's not possible to consume more than 40kW of power set maxPeak to 40 to make the readings of the power meter more robust.

CounterOffset
Specifies the difference between true (gas) meter value and value reported by the EMGZ.
CounterOffset = true Value - Reading "total"
Example:

CUL_FHTTK

[EN DE]

Define

define <name> CUL_FHTTK <devicecode>

<devicecode>

define TK_TEST CUL_FHTTK 965AB0

Set

set <name> <value>

value

Closed
set window state to Closed

Open
set window state to Open

Pair
start pairing with FHT80B (activate FHT80B sync mode before) - state after pairing is Closed

ReSync
resync virtual sensor with FHT80b after a reset of CUL device. In other words, perform a virtual battery exchange to synchronize the sensor with FHT80b device again. (at the moment, only available with prototype cul fw - see forum 55774)

Special to the "ReSync" of existing FHT80TFs after a CUL firmware reset:

CUL_FHTTK_ReSyncAll()

1 hour

Get

No get implemented yet ...

Attributes

do_not_notify

verbose

model
Possible values are: FHT80TF, FHT80TF-2, virtual (value, which allow to simulate a window sensor)

showtime

IODev

ignore

eventMap

readingFnAttributes

CUL_HM

[EN DE]

available parameter for attribut "param"

HMLAN

Define

define <name> CUL_HM <6-digit-hex-code|8-digit-hex-code>


        define livingRoomSwitch CUL_HM 123456

        define LivingroomMainLight CUL_HM 12345601

        define LivingroomBackLight CUL_HM 12345602

autocreate

hmPairForSec

hmPairSerial

the <6-digit-hex-code>or HMid+ch <8-digit-hex-code>
It is the unique, hardcoded device-address and cannot be changed (no, you cannot choose it arbitrarily like for FS20 devices). You may detect it by inspecting the fhem log.
the subType attribute
which is one of switch dimmer blindActuator remote sensor swi pushButton threeStateSensor motionDetector keyMatic winMatic smokeDetector

Notes

If the interface is a CUL device, the rfmode attribute of the corresponding CUL/CUN device must be set to HomeMatic. Note: this mode is BidCos/Homematic only, you will not receive FS20/HMS/EM/S300 messages via this device. Previously defined FS20/HMS etc devices must be assigned to a different input device (CUL/FHZ/etc).
Currently supported device families: remote, switch, dimmer, blindActuator, motionDetector, smokeDetector, threeStateSensor, THSensor, winmatic. Special devices: KS550, HM-CC-TC and the KFM100.
Device messages can only be interpreted correctly if the device type is known. fhem will extract the device type from a "pairing request" message, even if it won't respond to it (see hmPairSerial and hmPairForSec to enable pairing). As an alternative, set the correct subType and model attributes, for a list of possible subType values see "attr hmdevice ?".

The so called "AES-Encryption" is in reality a signing request: if it is enabled, an actor device will only execute a received command, if a correct answer to a request generated by the actor is received. This means:
- Reaction to commands is noticably slower, as 3 messages are sent instead of one before the action is processed by the actor.
- Every command and its final ack from the device is sent in clear, so an outside observer will know the status of each device.
- The firmware implementation is buggy: the "toggle" event is executed before the answer for the signing request is received, at least by some switches (HM-LC-Sw1-Pl and HM-LC-SW2-PB-FM).
- The HMLAN configurator will answer signing requests by itself, and if it is configured with the 3-byte address of a foreign CCU which is still configurerd with the default password, it is able to answer signing requests correctly.
- AES-Encryption is useable with a HMLAN or a CUL. When using a CUL, the perl-module Crypt::Rijndael needs to be installed. Due to the issues above I do not recommend using Homematic encryption at all.

Set

assignHmKey
Initiates a key-exchange with the device, exchanging the old AES-key of the device with the key with the highest index defined by the attribute hmKey* in the HMLAN or VCCU. The old key is determined by the reading aesKeyNbr, which specifies the index of the old key when the reading is divided by 2.
clear <[rssi|readings|register|msgEvents|attack|all]>
A set of variables can be removed.
getConfig
Will read major configuration items stored in the HM device. Executed on a channel it will read pair Inforamtion, List0, List1 and List3 of the 1st internal peer. Furthermore the peerlist will be retrieved for teh given channel. If executed on a device the command will get the above info or all assotated channels. Not included will be the configuration for additional peers.
The command is a shortcut for a selection of other commands.
getRegRaw [List0|List1|List2|List3|List4|List5|List6]<peerChannel>
Read registerset in raw format. Description of the registers is beyond the scope of this documentation.
Registers are structured in so called lists each containing a set of registers.
List0: device-level settings e.g. CUL-pairing or dimmer thermal limit settings.
List1: per channel settings e.g. time to drive the blind up and down.
List3: per 'link' settings - means per peer-channel. This is a lot of data!. It controlls actions taken upon receive of a trigger from the peer.
List4: settings for channel (button) of a remote

<PeerChannel> paired HMid+ch, i.e. 4 byte (8 digit) value like '12345601'. It is mendatory for List 3 and 4 and can be left out for List 0 and 1.
'all' can be used to get data of each paired link of the channel.
'selfxx' can be used to address data for internal channels (associated with the build-in switches if any). xx is the number of the channel in decimal.
Note1: execution depends on the entity. If List1 is requested on a device rather then a channel the command will retrieve List1 for all channels assotiated. List3 with peerChannel = all will get all link for all channel if executed on a device.
Note2: for 'sender' see remote
Note3: the information retrieval may take a while - especially for devices with a lot of channels and links. It may be necessary to refresh the web interface manually to view the results
Note4: the direct buttons on a HM device are hidden by default. Nevertheless those are implemented as links as well. To get access to the 'internal links' it is necessary to issue
'set <name> regSet intKeyVisib visib'
or
'set <name> regBulk RegL_0. 2:81'
Reset it by replacing '81' with '01'
example:
getSerial
Read serial number from device and write it to attribute serialNr.
inhibit [on|off]
Block / unblock all changes to the actor channel, i.e. actor state is frozen until inhibit is set off again. Inhibit can be executed on any actor channel but obviously not on sensors - would not make any sense.
Practically it can be used to suspend any notifies as well as peered channel action temporarily without the need to delete them.
Examples:
pair
Pair the device with a known serialNumber (e.g. after a device reset) to FHEM Central unit. FHEM Central is usualy represented by CUL/CUNO, HMLAN,... If paired, devices will report status information to FHEM. If not paired, the device won't respond to some requests, and certain status information is also not reported. Paring is on device level. Channels cannot be paired to central separate from the device. See also getPair and unpair.
Don't confuse pair (to a central) with peer (channel to channel) with peerChan.
peerBulk <peerch1,peerch2,...> [set|unset]
peerBulk will add peer channels to the channel. All peers in the list will be added.
with unset option the peers in the list will be subtracted from the device's peerList.
peering sets the configuration of this link to its defaults. As peers are not added in pairs default will be as defined for 'single' by HM for this device.
More suffisticated funktionality is provided by peerChan.
peerBulk will not delete existing peers, just handle the given peerlist. Other already installed peers will not be touched.
peerBulk may be used to remove peers using unset option while default ist set.
Main purpose of this command is to re-store data to a device. It is recommended to restore register configuration utilising regBulk subsequent.
Example:
regBulk <reg List>.<peer> <addr1:data1> <addr2:data2>...
This command will replace the former regRaw. It allows to set register in raw format. Its main purpose is to restore a complete register list to values secured before.
Values may be read by getConfig. The resulting readings can be used directly for this command.
<reg List> is the list data should be written to. Format could be '00', 'RegL_00', '01'...
<peer> is an optional adder in case the list requires a peer. The peer can be given as channel name or the 4 byte (8 chars) HM channel ID.
<addr1:data1> is the list of register to be written in hex format.
Example:
myblind will set the max drive time up for a blind actor to 25,6sec
regSet [prep|exec] <regName> <value> <peerChannel>
For some major register a readable version is implemented supporting register names <regName> and value conversionsing. Only a subset of register can be supproted.
Optional parameter [prep|exec] allowes to pack the messages and therefore greatly improve data transmission. Usage is to send the commands with paramenter "prep". The data will be accumulated for send. The last command must have the parameter "exec" in order to transmitt the information.
<value> is the data in human readable manner that will be written to the register.
<peerChannel> is required if this register is defined on a per 'peerChan' base. It can be set to '0' other wise.See getRegRaw for full description
Supported register for a device can be explored using
Condensed register description will be printed using
reset
Factory reset the device. You need to pair it again to use it with fhem.
sign [on|off]
Activate or deactivate signing (also called AES encryption, see the note above). Warning: if the device is attached via a CUL, you need to install the perl-module Crypt::Rijndael to be able to switch it (or deactivate signing) from fhem.
statusRequest
Update device status. For multichannel devices it should be issued on an per channel base
unpair
"Unpair" the device, i.e. make it available to pair with other master devices. See pair for description.
virtual <number of buttons>
configures a defined curcuit as virtual remote controll. Then number of button being added is 1 to 255. If the command is issued a second time for the same entity additional buttons will be added.
Example for usage:
see also press
deviceRename <newName>
rename the device and all its channels.
fwUpdate [onlyEnterBootLoader] <filename> [<waitTime>]
update Fw of the device. User must provide the appropriate file. waitTime can be given optionally. In case the device needs to be set to FW update mode manually this is the time the system will wait.
"onlyEnterBootLoader" tells the device to enter the boot loader so it can be flashed using the eq3 firmware update tool. Mainly useful for flush-mounted devices in FHEM environments solely using HM-LAN adapters.

subType dependent commands:

switch
- on - set level to 100%
- off - set level to 0%
- on-for-timer <sec> - set the switch on for the given seconds [0-85825945].
  Note: off-for-timer like FS20 is not supported. It may to be programmed thru channel register.
- on-till <time> - set the switch on for the given end time.
  Currently a max of 24h is supported with endtime.
- pressL <peer> [<repCount>] [<repDelay>]
  simulate a press of the local button or direct connected switch of the actor.
  <peer> allows to stimulate button-press of any peer of the actor. i.e. if the actor is peered to any remote, virtual or io (HMLAN/CUL) press can trigger the action defined.
  <repCount> number of automatic repetitions.
  <repDelay> timer between automatic repetitions.
  Example: set actor pressL FB_Btn01 # trigger long peer FB button 01 set actor pressL FB_chn-8 # trigger long peer FB button 08 set actor pressL self01 # trigger short of internal peer 01 set actor pressL fhem02 # trigger short of FHEM channel 2
- pressS <peer>
  simulates a short press similar to long press
- eventL <peer> <condition> [<repCount>] [<repDelay>]
  simulate an event of an peer and stimulates the actor.
  <peer> allows to stimulate button-press of any peer of the actor. i.e. if the actor is peered to any remote, virtual or io (HMLAN/CUL) press can trigger the action defined.
  <codition> the level of the condition
  Example: set actor eventL md 30 # trigger from motion detector with level 30
- eventS <peer> <condition>
  simulates a short event from a peer of the actor. Typically sensor do not send long events.
- toggle - toggle the Actor. It will switch from any current level to off or from off to 100%
dimmer, blindActuator
Dimmer may support virtual channels. Those are autocrated if applicable. Usually there are 2 virtual channels in addition to the primary channel. Virtual dimmer channels are inactive by default but can be used in in parallel to the primay channel to control light.
Virtual channels have default naming SW<channel>_V<no>. e.g. Dimmer_SW1_V1 and Dimmer_SW1_V2.
Dimmer virtual channels are completely different from FHEM virtual buttons and actors but are part of the HM device. Documentation and capabilities for virtual channels is out of scope.
- 0 - 100 [on-time] [ramp-time]
  set the actuator to the given value (in percent) with a resolution of 0.5.
  Optional for dimmer on-time and ramp time can be choosen, both in seconds with 0.1s granularity.
  On-time is analog "on-for-timer".
  Ramp-time default is 2.5s, 0 means instantanous
- on
- off
- press <[short|long]><[on|off]>
- toggle
- toggleDir - toggled drive direction between up/stop/down/stop
- on-for-timer <sec> - Dimmer only!
- on-till <time> - Dimmer only!
- stop - stop motion (blind) or dim ramp
- old - switch back to old value after a change. Dimmer only.
- pct <level> [<ontime>] [<ramptime>] - set actor to a desired absolut level.
  Optional ontime and ramptime could be given for dimmer.
  ontime may be time in seconds. It may also be entered as end-time in format hh:mm:ss
- up [changeValue] [<ontime>] [<ramptime>] dim up one step
- down [changeValue] [<ontime>] [<ramptime>] dim up one step
  changeValue is optional an gives the level to be changed up or down in percent. Granularity is 0.5%, default is 10%.
  ontime is optional an gives the duration of the level to be kept. '0' means forever and is default.
  ramptime is optional an defines the change speed to reach the new level. It is meaningful only for dimmer.
remotes, pushButton
This class of devices does not react on requests unless they are put to learn mode. FHEM obeys this behavior by stacking all requests until learn mode is detected. Manual interaction of the user is necessary to activate learn mode. Whether commands are pending is reported on device level with parameter 'protCmdPend'.

trgEventS [all|<peer>] <condition>
Issue eventS on the peer entity. If all is selected each of the peers will be triggered. See also eventS
<condition>: is the condition being transmitted with the event. E.g. the brightness in case of a motion detector.
trgEventL [all|<peer>] <condition>
Issue eventL on the peer entity. If all is selected each of the peers will be triggered. a normal device will not sent event long. See also eventL
<condition>: is the condition being transmitted with the event. E.g. the brightness in case of a motion detector.
trgPressS [all|<peer>]
Issue pressS on the peer entity. If all is selected each of the peers will be triggered. See also pressS
trgPressL [all|<peer>]
Issue pressL on the peer entity. If all is selected each of the peers will be triggered. See also pressL
peerIODev [IO] <btn_no> [set|unset]
The command is similar to peerChan. While peerChan is executed on a remote and peers any remote to any actor channel peerIODev is executed on an actor channel and peer this to an channel of an FHEM IO device.
An IO device according to eQ3 supports up to 50 virtual buttons. Those will be peered/unpeerd to the actor. press can be used to stimulate the related actions as defined in the actor register.
peerChan <btn_no> <actChan> [single|dual|reverse][set|unset] [both|actor|remote]
peerChan will establish a connection between a sender- channel and an actuator-channel called link in HM nomenclatur. Peering must not be confused with pairing.
Pairing refers to assign a device to the central.
Peering refers to virtally connect two channels.
Peering allowes direkt interaction between sender and aktor without the necessity of a CCU
Peering a sender-channel causes the sender to expect an ack from -each- of its peers after sending a trigger. It will give positive feedback (e.g. LED green) only if all peers acknowledged.
Peering an aktor-channel will setup a parameter set which defines the action to be taken once a trigger from -this- peer arrived. In other words an aktor will
- process trigger from peers only
- define the action to be taken dedicated for each peer's trigger
An actor channel will setup a default action upon peering - which is actor dependant. It may also depend whether one or 2 buttons are peered in one command. A swich may setup oen button for 'on' and the other for 'off' if 2 button are peered. If only one button is peered the funktion will likely be 'toggle'.
The funtion can be modified by programming the register (aktor dependant).
Even though the command is executed on a remote or push-button it will as well take effect on the actuator directly. Both sides' peering is virtually independant and has different impact on sender and receiver side.
Peering of one actuator-channel to multiple sender-channel as well as one sender-channel to multiple Actuator-channel is possible.
<actChan> is the actuator-channel to be peered.
<btn_no> is the sender-channel (button) to be peered. If 'single' is choosen buttons are counted from 1. For 'dual' btn_no is the number of the Button-pair to be used. I.e. '3' in dual is the 3rd button pair correcponding to button 5 and 6 in single mode.
If the command is executed on a channel the btn_no is ignored. It needs to be set, should be 0
[single|dual]: this mode impacts the default behavior of the Actuator upon using this button. E.g. a dimmer can be learned to a single button or to a button pair.
Defaults to dual.
'dual' (default) Button pairs two buttons to one actuator. With a dimmer this means one button for dim-up and one for dim-down.
'reverse' identical to dual - but button order is reverse.
'single' uses only one button of the sender. It is useful for e.g. for simple switch actuator to toggle on/off. Nevertheless also dimmer can be learned to only one button.
[set|unset]: selects either enter a peering or remove it.
Defaults to set.
'set' will setup peering for the channels
'unset' will remove the peering for the channels
[actor|remote|both] limits the execution to only actor or only remote. This gives the user the option to redo the peering on the remote channel while the settings in the actor will not be removed.
Defaults to both.
Example:

virtual
- peerChan see remote
- press [long|short] [<peer>] [<repCount>] [<repDelay>]
  - [long|short] defines whether long or short press shall be simulated. Defaults to short
  - [<peer>] define which peer's trigger shall be simulated.Defaults to self(channelNo).
  - [<repCount>] Valid for long press only. How long shall the button be pressed? Number of repetition of the messages is defined. Defaults to 1
  - [<repDelay>] Valid for long press only. defines wait time between the single messages.
- virtTemp <[off -10..50]> simulates a thermostat. If peered to a device it periodically sends the temperature until "off" is given. See also virtHum
- virtHum <[off -10..50]> simulates the humidity part of a thermostat. If peered to a device it periodically sends the temperature and humidity until both are "off". See also virtTemp
- valvePos <[off 0..100]> stimulates a VD
smokeDetector
Note: All these commands work right now only if you have more then one smoekDetector, and you peered them to form a group. For issuing the commands you have to use the master of this group, and currently you have to guess which of the detectors is the master.
smokeDetector can be setup to teams using peerChan. You need to peer all team-members to the master. Don't forget to also peerChan the master itself to the team - i.e. peer it to itself! doing that you have full controll over the team and don't need to guess.
- teamCall - execute a network test to all team members
- teamCallBat - execute a network test simulate bat low
- alarmOn - initiate an alarm
- alarmOff - switch off the alarm
4Dis (HM-PB-4DIS-WM|HM-RC-Dis-H-x-EU|ROTO_ZEL-STG-RM-DWT-10)
- text <btn_no> [on|off] <text1> <text2>
  Set the text on the display of the device. To this purpose issue this set command first (or a number of them), and then choose from the teach-in menu of the 4Dis the "Central" to transmit the data.
  If used on a channel btn_no and on|off must not be given but only pure text.
  \_ will be replaced by blank character.
  Example:
Climate-Control (HM-CC-TC)
- desired-temp <temp>
  Set different temperatures. <temp> must be between 6 and 30 Celsius, and precision is half a degree.
- tempListSat [prep|exec] HH:MM temp ... 24:00 temp
- tempListSun [prep|exec] HH:MM temp ... 24:00 temp
- tempListMon [prep|exec] HH:MM temp ... 24:00 temp
- tempListTue [prep|exec] HH:MM temp ... 24:00 temp
- tempListThu [prep|exec] HH:MM temp ... 24:00 temp
- tempListWed [prep|exec] HH:MM temp ... 24:00 temp
- tempListFri [prep|exec] HH:MM temp ... 24:00 temp
  Specify a list of temperature intervals. Up to 24 intervals can be specified for each week day, the resolution is 10 Minutes. The last time spec must always be 24:00.
  Example: until 6:00 temperature shall be 19, from then until 23:00 temperature shall be 22.5, thereafter until midnight, 19 degrees celsius is desired.
  set th tempListSat 06:00 19 23:00 22.5 24:00 19
- tempListTmpl =>"[verify|restore] [[ <file> :]templateName] ...
  The tempList for one or more devices can be stored in a file. User can compare the tempList in the file with the data read from the device.
  Restore will write the tempList to the device.
  Default opeartion is verify.
  Default file is tempList.cfg.
  Default templateName is the name of the actor
  Default for file and templateName can be set with attribut tempListTmpl
  Example for templist file. room1 and room2 are the names of the template:
  entities:room1 tempListSat>08:00 16.0 15:00 18.0 21:30 19.0 24:00 14.0 tempListSun>08:00 16.0 15:00 18.0 21:30 19.0 24:00 14.0 tempListMon>07:00 16.0 16:00 18.0 21:00 19.0 24:00 14.0 tempListTue>07:00 16.0 13:00 16.0 16:00 18.0 21:00 19.0 24:00 15.0 tempListWed>07:00 16.0 16:00 18.0 21:00 19.0 24:00 14.0 tempListThu>07:00 16.0 16:00 18.0 21:00 19.0 24:00 14.0 tempListFri>07:00 16.0 13:00 16.0 16:00 18.0 21:00 19.0 24:00 14.0 entities:room2 tempListSat>08:00 14.0 15:00 18.0 21:30 19.0 24:00 14.0 tempListSun>08:00 14.0 15:00 18.0 21:30 19.0 24:00 14.0 tempListMon>07:00 14.0 16:00 18.0 21:00 19.0 24:00 14.0 tempListTue>07:00 14.0 13:00 16.0 16:00 18.0 21:00 19.0 24:00 15.0 tempListWed>07:00 14.0 16:00 18.0 21:00 19.0 24:00 14.0 tempListThu>07:00 14.0 16:00 18.0 21:00 19.0 24:00 14.0 tempListFri>07:00 14.0 13:00 16.0 16:00 18.0 21:00 19.0 24:00 14.0 Specials:
- none: template will be ignored
- defaultWeekplan: as default each day is set to 18.0 degree. useful if peered to a TC controller. Implicitely teh weekplan of TC will be used.
- tempTmplSet =>"[[ <file> :]templateName]
  Set the attribut and apply the change to the device
- templateDel =>" <template>
  Delete templateentry for this entity
- partyMode <HH:MM><durationDays>
  set control mode to party and device ending time. Add the time it ends and the number of days it shall last. If it shall end next day '1' must be entered
- sysTime
  set time in climate channel to system time
Climate-Control (HM-CC-RT-DN|HM-CC-RT-DN-BoM)
- controlMode <auto|boost|day|night>
- controlManu <temp>
- controlParty <temp><startDate><startTime><endDate><endTime>
  set control mode to party, define temp and timeframe.
  example:
  set controlParty 15 03-8-13 20:30 5-8-13 11:30
- sysTime
  set time in climate channel to system time
- desired-temp <temp>
  Set different temperatures. <temp> must be between 6 and 30 Celsius, and precision is half a degree.
- tempListSat [prep|exec] HH:MM temp ... 24:00 temp
- tempListSun [prep|exec] HH:MM temp ... 24:00 temp
- tempListMon [prep|exec] HH:MM temp ... 24:00 temp
- tempListTue [prep|exec] HH:MM temp ... 24:00 temp
- tempListThu [prep|exec] HH:MM temp ... 24:00 temp
- tempListWed [prep|exec] HH:MM temp ... 24:00 temp
- tempListFri [prep|exec] HH:MM temp ... 24:00 temp
  Specify a list of temperature intervals. Up to 24 intervals can be specified for each week day, the resolution is 10 Minutes. The last time spec must always be 24:00.
  Optional parameter [prep|exec] allowes to pack the messages and therefore greatly improve data transmission. This is especially helpful if device is operated in wakeup mode. Usage is to send the commands with paramenter "prep". The data will be accumulated for send. The last command must have the parameter "exec" in order to transmitt the information.
  Example: until 6:00 temperature shall be 19, from then until 23:00 temperature shall be 22.5, thereafter until midnight, 19 degrees celsius is desired.
  set th tempListSat 06:00 19 23:00 22.5 24:00 19
  set th tempListSat prep 06:00 19 23:00 22.5 24:00 19 set th tempListSun prep 06:00 19 23:00 22.5 24:00 19 set th tempListMon prep 06:00 19 23:00 22.5 24:00 19 set th tempListTue exec 06:00 19 23:00 22.5 24:00 19
OutputUnit (HM-OU-LED16)
- led [off|red|green|yellow]
  switches the LED of the channel to the color. If the command is executed on a device it will set all LEDs to the specified color.
  For Expert all LEDs can be set individual by providing a 8-digit hex number to the device.
- ilum <brightness><duration>
  <brightness> [0-15] of backlight.
  <duration> [0-127] in sec. 0 is permanent 'on'.
OutputUnit (HM-OU-CFM-PL)
- led <color>[,<color>..] [<repeat>..]
  Possible colors are [redL|greenL|yellowL|redS|greenS|yellowS|pause]. A sequence of colors can be given separating the color entries by ','. White spaces must not be used in the list. 'S' indicates short and 'L' long ilumination.
  repeat defines how often the sequence shall be executed. Defaults to 1.
- playTone <MP3No>[,<MP3No>..] [<repeat>] [<volume>]
  Play a series of tones. List is to be entered separated by ','. White spaces must not be used in the list.
  replay can be entered to repeat the last sound played once more.
  repeat defines how often the sequence shall be played. Defaults to 1.
  volume is defined between 0 and 10. 0 stops any sound currently playing. Defaults to 10 (100%).
  Example:
HM-RC-19xxx
- alarm <count>
  issue an alarm message to the remote
- service <count>
  issue an service message to the remote
- symbol <symbol> [set|unset]
  activate a symbol as available on the remote.
- beep [off|1|2|3]
  activate tone
- backlight [off|on|slow|fast]
  activate backlight
- display <text> comma unit tone backlight <symbol(s)>
  control display of the remote
  <text> : up to 5 chars
  comma : 'comma' activates the comma, 'no' leaves it off
  [unit] : set the unit symbols. [off|Proz|Watt|x3|C|x5|x6|x7|F|x9|x10|x11|x12|x13|x14|x15]. Currently the x3..x15 display is not tested.
  tone : activate one of the 3 tones [off|1|2|3]
  backlight: activate backlight flash mode [off|on|slow|fast]
  <symbol(s)> activate symbol display. Multople symbols can be acticated at the same time, concatinating them comma separated. Don't use spaces here. Possiblesymbols are [bulb|switch|window|door|blind|scene|phone|bell|clock|arrowUp|arrowDown]
  
  Example:
HM-Dis-WM55
- displayWM help
  displayWM [long|short] <text1> <color1> <icon1> ... <text6> <color6> <icon6>
  displayWM [long|short] <lineX> <text> <color> <icon>
  up to 6 lines can be addressed.
  lineX line number that shall be changed. If this is set the 3 parameter of a line can be adapted.
  textNo is the text to be dispalyed in line No. The text is assotiated with the text defined for the buttons. txt<BtnNo>_<lineNo> references channel 1 to 10 and their lines 1 or 2. Alternaly a free text of up to 12 char can be used
  color is one white, red, orange, yellow, green, blue
  icon is one off, on, open, closed, error, ok, noIcon
  Example:
HM-Dis-EP-WM55
- displayEP help
  displayEP <text1,icon1:text2,icon2:text3,icon3> <sound> <repetition> <pause> <signal>
  up to 3 lines can be addressed.
  If help is given a help on the command is given. Options for all parameter will be given.
  textx 12 char text for the given line. If empty the value as per reading will be transmittet - i.e. typically no change. text0-9 will display predefined text of channels 4 to 8. 0xHH allows to display a single char in hex format.
  iconx Icon for this line. If empty the value as per reading will be transmittet - i.e. typically no change.
  sound sound to be played
  repetition 0..15
  pause 1..160
  signal signal color to be displayed
  
  Note: param reWriteDisplayxx
- upon button press the device will overwrite the 3 middles lines. When set
  attr chan param reWriteDisplayxx
  the 3 lines will be rewritten to the latest value after xx seconds. xx is between 01 and 99
keyMatic
- lock
  The lock bolt moves to the locking position
- unlock [sec]
  The lock bolt moves to the unlocking position.
  [sec]: Sets the delay in seconds after the lock automatically locked again.
  0 - 65535 seconds
- open [sec]
  Unlocked the door so that the door can be opened.
  [sec]: Sets the delay in seconds after the lock automatically locked again.
  0 - 65535 seconds
winMatic
- level <level> <relockDelay> <speed>
  set the level.
  <level>: range is 0 to 100%
  <relockDelay>: range 0 to 65535 sec. 'ignore' can be used to igneore the value alternaly
  <speed>: range is 0 to 100%
- stop
  stop movement
CCU_FHEM
- defIgnUnknown
  define unknown devices which are present in the readings. set attr ignore and remove the readingfrom the list.
HM-Sys-sRP-Pl

setup the repeater's entries. Up to 36entries can be applied.
- setRepeat <entry> <sender> <receiver> <broadcast>
  <entry> [1..36] entry number in repeater table. The repeater can handle up to 36 entries.
  <sender> name or HMID of the sender or source which shall be repeated
  <receiver> name or HMID of the receiver or destination which shall be repeated
  <broadcast> [yes|no] determines whether broadcast from this ID shall be repeated
  
  short application:
  setRepeat setAll 0 0 0 will rewrite the complete list to the deivce. Data will be taken from attribut repPeers.
  attribut repPeers is formated:
  src1:dst1:[y/n],src2:dst2:[y/n],src2:dst2:[y/n],...
  
  Reading repPeer is formated:

raw <data> ...
Only needed for experimentation. send a list of "raw" commands. The first command will be immediately sent, the next one after the previous one is acked by the target. The length will be computed automatically, and the message counter will be incremented if the first two charcters are ++. Example (enable AES):
```
             set hm1 raw ++A001F100001234560105000000001\
                ++A001F10000123456010802010AF10B000C00\
                ++A001F1000012345601080801\
                ++A001F100001234560106
```

Get

configSave <filename>
Saves the configuration of an entity into a file. Data is stored in a format to be executed from fhem command prompt.
The file is located in the fhem home directory aside of fhem.cfg. Data will be stored cumulative - i.e. new data will be appended to the file. It is up to the user to avoid duplicate storage of the same entity.
Target of the data is ONLY the HM-device information which is located IN the HM device. Explicitely this is the peer-list and the register. With the register also the peering is included.
The file is readable and editable by the user. Additionaly timestamps are stored to help user to validate.
Restrictions:
Even though all data of the entity will be secured to the file FHEM stores the data that is avalilable to FHEM at time of save!. It is up to the user to read the data from the HM-hardware prior to execution. See recommended flow below.
This command will not store any FHEM attributes o device definitions. This continues to remain in fhem.cfg.
Furthermore the secured data will not automatically be reloaded to the HM-hardware. It is up to the user to perform a restore.

As with other commands also 'configSave' is best executed on a device rather then on a channel. If executed on a device also the assotiated channel data will be secured.

Recommended work-order for device 'HMdev': set HMdev clear msgEvents # clear old events to better check flow set HMdev getConfig # read device & channel inforamtion # wait until operation is complete # protState should be CMDs_done # there shall be no warnings amongst prot... variables get configSave myActorFile
param <paramName>
returns the content of the relevant parameter for the entity.
Note: if this command is executed on a channel and 'model' is requested the content hosting device's 'model' will be returned.
reg <addr> <list> <peerID>
returns the value of a register. The data is taken from the storage in FHEM and not read directly outof the device. If register content is not present please use getConfig, getReg in advance.
<addr> address in hex of the register. Registername can be used alternaly if decoded by FHEM. "all" will return all decoded register for this entity in one list.
<list> list from which the register is taken. If rgistername is used list is ignored and can be set to 0.
<peerID> identifies the registerbank in case of list3 and list4. It an be set to dummy if not used.
regVal <addr> <list> <peerID>
returns the value of a register. It does the same as reg but strips off units
regList
returns a list of register that are decoded by FHEM for this device.
Note that there could be more register implemented for a device.
saveConfig <file>
stores peers and register to the file.
Stored will be the data as available in fhem. It is necessary to read the information from the device prior to the save.
The command supports device-level action. I.e. if executed on a device also all related channel entities will be stored implicitely.
Storage to the file will be cumulative. If an entity is stored multiple times to the same file data will be appended. User can identify time of storage in the file if necessary.
Content of the file can be used to restore device configuration. It will restore all peers and all register to the entity.
Constrains/Restrictions:
prior to rewrite data to an entity it is necessary to pair the device with FHEM.
restore will not delete any peered channels, it will just add peer channels.
listDevice
- when used with ccu it returns a list of Devices using the ccu service to assign an IO.
- when used with ActionDetector user will get a comma separated list of entities being assigned to the action detector
  get ActionDetector listDevice # returns all assigned entities
  get ActionDetector listDevice notActive# returns entities which habe not status alive
  get ActionDetector listDevice alive # returns entities with status alive
  get ActionDetector listDevice unknown # returns entities with status unknown
  get ActionDetector listDevice dead # returns entities with status dead
info
- provides information about entities using ActionDetector

Attributes

eventMap
do_not_notify
ignore
dummy
showtime
readingFnAttributes
aesCommReq if set IO is forced to request AES signature before sending ACK to the device.
actAutoTry actAutoTry 0_off,1_on
setting this option enables Action Detector to send a statusrequest in case of a device is going to be marked dead. The attribut may be useful in case a device is being checked that does not send messages regularely - e.g. an ordinary switch.
actCycle actCycle <[hhh:mm]|off>
Supports 'alive' or better 'not alive' detection for devices. [hhh:mm] is the maximum silent time for the device. Upon no message received in this period an event will be raised "<device> is dead". If the device sends again another notification is posted "<device> is alive".
This actiondetect will be autocreated for each device with build in cyclic status report.
Controlling entity is a pseudo device "ActionDetector" with HMId "000000".
Due to performance considerations the report latency is set to 600sec (10min). It can be controlled by the attribute "actCycle" of "ActionDetector".
Once entered to the supervision the HM device has 2 attributes:
The overall function can be viewed checking out the "ActionDetector" entity. The status of all entities is present in the READING section.
Note: This function can be enabled for devices with non-cyclic messages as well. It is up to the user to enter a reasonable cycletime.
autoReadReg
'0' autoReadReg will be ignored.
'1' will execute a getConfig for the device automatically after each reboot of FHEM.
'2' like '1' plus execute after power_on.
'3' includes '2' plus updates on writes to the device
'4' includes '3' plus tries to request status if it seems to be missing
'5' checks reglist and peerlist. If reading seems incomplete getConfig will be scheduled
'8_stateOnly' will only update status information but not configuration data like register and peer
Execution will be delayed in order to prevent congestion at startup. Therefore the update of the readings and the display will be delayed depending on the size of the database.
Recommendations and constrains upon usage:
burstAccess
can be set for the device entity if the model allowes conditionalBurst. The attribut will switch off burst operations (0_off) which causes less message load on HMLAN and therefore reduces the chance of HMLAN overload.
Setting it on (1_auto) allowes shorter reaction time of the device. User does not need to wait for the device to wake up.
Note that also the register burstRx needs to be set in the device.
expert
This attribut controls the visibility of the register readings. This attibute controls the presentation of device parameter in the readings.
it is a binary coded number with following presets:
If expert is applied a device it is used for assotiated channels. It can be overruled if expert attibute is also applied to the channel device.
Make sure to check out attribut showInternalValues in the global values as well. extert takes benefit of the implementation. Nevertheless - by definition - showInternalValues overrules expert.
readOnly
restircts commands to read od observ only.
IOgrp
can be given to devices and shall point to a virtual CCU. As a consequence the CCU will take care of the assignment to the best suitable IO. It is necessary that a virtual CCU is defined and all relevant IO devices are assigned to it. Upon sending the CCU will check which IO is operational and has the best RSSI performance for this device.
Optional a prefered IO - perfIO can be given. In case this IO is operational it will be selected regardless of rssi values.
If none is detected in the prefIO list the mechanism is stopped and the IO as of IOdev is assigned
Example:
levelRange
can be used with dimmer only. It defines the dimmable range to be used with this dimmer-channel. It is meant to support e.g. LED light that starts at 10% and reaches maxbrightness at 40%. levelrange will normalize the level to this range. I.e. set to 100% will physically set the dimmer to 40%, 1% will set to 10% physically. 0% still switches physially off.
Impacted are commands on, up, down, toggle and pct. Not effected is the off command which still set physically 0%.
To be considered:
dimmer level set by peers and buttons is not impacted. Those are controlled by device register
Readings level may go to negative or above 100%. This simply results from the calculation and reflects physical level is above or below the given range.
In case of virtual dimmer channels available present the attribut needs to be set for each channel
User should be careful to set min level other then '0'
Example:
model, subType
These attributes are set automatically after a successful pairing. They are not supposed to be set by hand, and are necessary in order to correctly interpret device messages or to be able to send them.
msgRepeat
defines number of repetitions if a device doesn't answer in time.
Devices which donly support config mode no repeat ist allowed.
For devices with wakeup mode the device will wait for next wakeup. Lonng delay might be considered in this case.
Repeat for burst devices will impact HMLAN transmission capacity.
param
param defines model specific behavior or functions. See available parameter for details
rawToReadable
Used to convert raw KFM100 values to readable data, based on measured values. E.g. fill slowly your container, while monitoring the values reported with inform. You'll see:
Apply these values with: "attr KFM100 rawToReadable 10:0 50:20 79:40 270:100". fhem will do a linear interpolation for values between the bounderies.
rssiLog
can be given to devices, denied for channels. If switched '1' each RSSI entry will be written to a reading. User may use this to log and generate a graph of RSSI level.
Due to amount of readings and events it is NOT RECOMMENDED to switch it on by default.
tempListTmpl
Sets the default template for a heating controller. If not given the detault template is taken from file tempList.cfg using the enitity name as template name (e.g. ./tempLict.cfg:RT1_Clima
To avoid template usage set this attribut to '0'.
Format is <file>:<templatename>. lt
unit
set the reported unit by the KFM100 if rawToReadable is active. E.g.
attr KFM100 unit Liter
cyclicMsgOffset
when calculating the timestamp for sending the next cyclic message (e.g. weather or valve data) then the value of this attribute
in milliseconds is added to the result. So adjusting this might fix problems for example when weather messages of virtual devices are not received reliably

HM-Sen-RD-O
offAtPon heat channel only: force heating off after powerOn
onAtRain heat channel only: force heating on while status changes to 'rain' and off when it changes to 'dry'
virtuals
noOnOff virtual entity will not toggle state when trigger is received. If this parameter is not given the entity will toggle its state between On and Off with each trigger
msgReduce:<No> if channel is used for it skips every No message in order to reduce transmit load. Numbers from 0 (no skip) up to 9 can be given. VD will lose connection with more then 5 skips
blind
levelInverse while HM considers 100% as open and 0% as closed this may not be intuitive to all user. Ny default 100% is open and will be dislayed as 'on'. Setting this param the display will be inverted - 0% will be open and 100% is closed.
NOTE: This will apply to readings and set commands. It does not apply to any register.
ponRestoreSmart upon powerup of the device the Blind will drive to expected closest endposition followed by driving to the pre-PON level
ponRestoreForce upon powerup of the device the Blind will drive to level 0, then to level 100 followed by driving to the pre-PON level
sensRain
siren
powerMeter
switch
dimmer
rgb
showTimed if timmed is running -till will be added to state. This results eventually in state on-till which allowes better icon handling.

Generated events:

general
recentStateType:[ack|info] # cannot be used ti trigger notifies
- ack indicates that some statusinfo is derived from an acknowledge
- info indicates an autonomous message from the device
- sabotageAttackId
  Alarming configuration access to the device from a unknown source
- sabotageAttack
  Alarming configuration access to the device that was not issued by our system
- trigDst_<name>: noConfig
  A sensor triggered a Device which is not present in its peerList. Obviously the peerList is not up to date
HM-CC-TC,ROTO_ZEL-STG-RM-FWT
T: $t H: $h
battery:[low|ok]
measured-temp $t
humidity $h
actuator $vp %
desired-temp $dTemp
desired-temp-manu $dTemp #temperature if switchen to manual mode
desired-temp-cent $dTemp #temperature if switchen to central mode
windowopen-temp-%d %.1f (sensor:%s)
tempList$wd hh:mm $t hh:mm $t ...
displayMode temp-[hum|only]
displayTemp [setpoint|actual]
displayTempUnit [fahrenheit|celsius]
controlMode [auto|manual|central|party]
tempValveMode [Auto|Closed|Open|unknown]
param-change offset=$o1, value=$v1
ValveErrorPosition_for_$dname $vep %
ValveOffset_for_$dname : $of %
ValveErrorPosition $vep %
ValveOffset $of %
time-request
trig_<src> <value> #channel was triggered by <src> channel. This event relies on complete reading of channels configuration, otherwise Data can be incomplete or incorrect.
trigLast <channel> #last receiced trigger
HM-CC-RT-DN and HM-CC-RT-DN-BoM
state:T: $actTemp desired: $setTemp valve: $vp %
motorErr: [ok|ValveTight|adjustRangeTooLarge|adjustRangeTooSmall|communicationERR|unknown|lowBat|ValveErrorPosition] measured-temp $actTemp
desired-temp $setTemp
ValvePosition $vp %
mode [auto|manual|party|boost]
battery [low|ok]
batteryLevel $bat V
measured-temp $actTemp
desired-temp $setTemp
actuator $vp %
time-request
trig_<src> <value> #channel was triggered by <src> channel.
HM-CC-VD,ROTO_ZEL-STG-RM-FSA
$vp %
battery:[critical|low|ok]
motorErr:[ok|blocked|loose|adjusting range too small|opening|closing|stop]
ValvePosition:$vp %
ValveErrorPosition:$vep %
ValveOffset:$of %
ValveDesired:$vp % # set by TC
operState:[errorTargetNotMet|onTarget|adjusting|changed] # operational condition
operStateErrCnt:$cnt # number of failed settings
HM-CC-SCD
[normal|added|addedStrong]
battery [low|ok]
HM-SEC-SFA-SM
powerError [on|off]
sabotageError [on|off]
battery: [critical|low|ok]
HM-LC-BL1-PB-FM
motor: [opening|closing]
HM-LC-SW1-BA-PCB
battery: [low|ok]
HM-OU-LED16
color $value # hex - for device only
$value # hex - for device only
color [off|red|green|orange] # for channel
[off|red|green|orange] # for channel
HM-OU-CFM-PL
[on|off|$val]
HM-Sen-Wa-Od
$level%
level $level%
KFM100
$v
$cv,$unit
rawValue:$v
Sequence:$seq
content:$cv,$unit
KS550/HM-WDS100-C6-O
T: $t H: $h W: $w R: $r IR: $ir WD: $wd WDR: $wdr S: $s B: $b
temperature $t
humidity $h
windSpeed $w
windDirection $wd
windDirRange $wdr
rain $r
isRaining $ir
sunshine $s
brightness $b
unknown $p
HM-Sen-RD-O
lastRain: timestamp # no trigger generated. Begin of previous Rain - timestamp of the reading is the end of rain.
THSensor and HM-WDC7000
T: $t H: $h AP: $ap
temperature $t
humidity $h
airpress $ap #HM-WDC7000 only
dimmer
overload [on|off]
overheat [on|off]
reduced [on|off]
dim: [up|down|stop]
motionDetector
brightness:$b
alive
motion on (to $dest)
motionCount $cnt _next:$nextTr"-"[0x0|0x1|0x2|0x3|15|30|60|120|240|0x9|0xa|0xb|0xc|0xd|0xe|0xf]
cover [closed|open] # not for HM-Sec-MDIR
sabotageError [on|off] # only HM-Sec-MDIR
battery [low|ok]
devState_raw.$d1 $d2
remote/pushButton/outputUnit
Btn$x onShort
Btn$x offShort
Btn$x onLong $counter
Btn$x offLong $counter
Btn$x onLongRelease $counter
Btn$x offLongRelease $counter
Btn$x onShort (to $dest)
Btn$x offShort (to $dest)
Btn$x onLong $counter (to $dest)
Btn$x offLong $counter (to $dest)
Btn$x onLongRelease $counter (to $dest)
Btn$x offLongRelease $counter (to $dest)
remote/pushButton
battery [low|ok]
trigger [Long|Short]_$no trigger event from channel
swi
Btn$x Short
Btn$x Short (to $dest)
battery: [low|ok]
switch/dimmer/blindActuator
$val
powerOn [on|off|$val]
[unknown|motor|dim] [up|down|stop]:$val
timedOn [running|off]
# on is temporary - e.g. started with on-for-timer
sensRain
$val
powerOn
level <val≥
timedOn [running|off]
# on is temporary - e.g. started with on-for-timer trigger [Long|Short]_$no trigger event from channel
smokeDetector
[off|smoke-Alarm|alive] # for team leader
[off|smoke-forward|smoke-alarm] # for team members
[normal|added|addedStrong] #HM-CC-SCD
SDteam [add|remove]_$dname
battery [low|ok]
smoke_detect [none|<src>]
teamCall:from $src
threeStateSensor
[open|tilted|closed]
[wet|damp|dry] #HM-SEC-WDS only
cover [open|closed] #HM-SEC-WDS and HM-Sec-RHS
alive yes
battery [low|ok]
contact [open|tilted|closed]
contact [wet|damp|dry] #HM-SEC-WDS only
sabotageError [on|off] #HM-SEC-SC only
winMatic
[locked|$value]
motorErr [ok|TurnError|TiltError]
direction [no|up|down|undefined]
charge [trickleCharge|charge|dischange|unknown]
airing [inactiv|$air]
course [tilt|close]
airing [inactiv|$value]
contact tesed
keyMatic
unknown:40
battery [low|ok]
uncertain [yes|no]
error [unknown|motor aborted|clutch failure|none']
lock [unlocked|locked]
[unlocked|locked|uncertain]

Internals

aesCommToDev
gives information about success or fail of AES communication between IO-device and HM-Device

CUL_HOERMANN

[EN DE]

Note

Define

define <name> CUL_HOERMANN <10-digit-hex-code>

Set

toggle
Send a signal, which, depending on the status of the door, opens it, closes it or stops the current movement. NOTE: needs culfw 1.67+

Get

N/A

Attributes

do_not_notify
showtime
IODev
disable
disabledForIntervals

CUL_IR

[EN DE]

Define

define <name> CUL_IR <IODev>

IODev

    define IR-Dev CUL_IR CUNO1

Set

irLearnForSec
Sets the CUL_IR device in an IR-Code Learning mode for the given seconds. Any received IR-Code will be stored as a Button attribute for this devices. The name of these attributes is dependent on the two attributes learncount and learnprefix.
Attention: Before learning IR-Codes the CUL_IR device needs to be set in IR-Receiving mode by modifying the irReceive attribute.

irSend
Sends out IR-commands via the connected IODev. The IR-command can be specified as buttonname according to Button.* or as IR-Code directly. If a buttonname is specified, the corresponding IR-Code will be sent out.
Example:
```
set IR-Dev irSend ButtonA001 
```
If defining an IR-Code directly the following Code-Syntax needs to be followed:
```
IRCode: <PP><AAAA><CCCC><FF> 
```
with P = Protocol; A = Address; C = Command; F = Flags
With the Flags you can modify IR-Repetition. Flags between 00-0E will produce 0-15 IR-Repetitions. You can type the IR-Code as plain as above, or with a heading "I" as learnt for the buttons.
Example:
set IR-Dev irSend 0A07070F0F02 set IR-Dev irSend I0A07070F0F00

Get

N/A

Attributes

do_not_notify

showtime

loglevel

irReceive
Configure the IR Transceiver of the <IODev> (the CUNO1). Available arguments are:
- OFF
  Switching off the reception of IR signals. This is the default.
- ON
  Switching on the reception of IR signals. This is WITHOUT filtering repetitions. This is not recommended as many remote controls do repeat their signals.
- ON_NR
  Switching on the reception of IR signals with filtering of repetitions. This is the recommended modus operandi.

Button.*
Button.* is the wildcard for all learnt IR-Codes. IR-Codes are learnt as Button-Attributes. The name for a learnt Button - IR-Code is compiled out of three elements:
```
        Button<learnprefix><learncount>
        
```
When the CUL_IR device is set into learning mode it will generate a new button-attribute for each new IR-Code received.This is done according to the following syntax:
```
        <Button-Attribute-Name> <IR-Code>
```
Examples of learnt button-attributes with EMPTY <learnprefix> and <learncount> starting from 1:
```
        Button001   I02029A000000
        Button002   I02029A000001
```
To make sure that something happens when this IR-code is received later on one has to modify the attribute and to add commands as attribute values. Examples:
```
        Button001   I02029A000000   set WZ_Lamp on
        Button002   I02029A000001   set Switch on
```
The syntax for this is:
```
        attr <device-name> <attribute-name> <IR-Code> <command>
        
```
Group.*
Group.* is the wildcard for IR-Code groups. With these attributes one can define IR-Code parts, which may match to several Button-IR-Codes.
This is done by defining group-attributes that contain only parts of the IR-Code. The syntax is:
```
        <Group-Attribute-Name> <IR-Code>
```
Examples of a group-attribute is:
```
        Group001   I02029A
```
With this all IR-Codes starting with I02029A will match the Group001.

learncount
learncount is used to store the next button-code-number that needs to be learned. By manually modifying this attribute new button sequences can be arranged.

learnprefix
learnprefix is a string which will be added to the button-attribute-name.
A button-attribute-name is constructed by:
```
        Button<learnprefix><learncount>    
```
If learnprefix is empty the button-attribute-name only contains the term "Button" and the actual number of learncount.

CUL_MAX

[EN DE]

attr CUL0 rfmode MAX

Define

define <name> CUL_MAX <addr>

Set

pairmode
Sets the CUL_MAX into pairing mode for 60 seconds where it can be paired with other devices (Thermostats, Buttons, etc.). You also have to set the other device into pairing mode manually. (For Thermostats, this is pressing the "Boost" button for 3 seconds, for example).
fakeSC <device> <open>
Sends a fake ShutterContactState message <open> must be 0 or 1 for "window closed" or "window opened". If the <device> has a non-zero groupId, the fake ShutterContactState message affects all devices with that groupId. Make sure you associate the target device(s) with fakeShutterContact beforehand.
fakeWT <device> <desiredTemperature> <measuredTemperature>
Sends a fake WallThermostatControl message (parameters both may have one digit after the decimal point, for desiredTemperature it may only by 0 or 5). If the <device> has a non-zero groupId, the fake WallThermostatControl message affects all devices with that groupId. Make sure you associate the target device with fakeWallThermostat beforehand.

Get

N/A

Attributes

ignore

do_not_notify

showtime

loglevel

readingFnAttributes

Generated events:

N/A

CUL_REDIRECT

[EN DE]

CUL_RFR

[EN DE]

The CUL_RFR module is used to "attach" a second CUL to your base CUL, and use it as a repeater / range extender. RFR is shorthand for RF_ROUTER. Transmission of the data uses the CC1101 packet capabilities with GFSK modulation at 250kBaud after pinging the base CUL at the usual 1kBaud. After configured, the RFR device can be used like another CUL connected directly to FHEM.
In theory every SlowRF protocol should work, as the hook is implemented in the culfw output routine: instead of sending the data to the USB-Interface it is transmitted via radio to the base CUL. There are still some restrictions:

due to the ping both CULs have to be in SlowRF mode, and use the same parameters (freq, bwidth, etc).
the logical module handling the protocol is not allowed to access the routines of the IODev (i.e. CUL) directly.

Tested protocols are FHT, FS20, EM, HMS, S300.
Since there is no ack or a resend mechanism, it should be primarily used to forward "unimportant" data, it was developed for forwading KS300 packets.

Before you can use this feature in fhem, you have to enable/configure RF ROUTING in both CUL's:

First give your base CUL (which remains connected to the PC) an RFR ID by issuing the fhem command "set MyCUL raw ui0100". With this command the base CUL will get the ID 01, and it will not relay messages to other CUL's (as the second number is 00).
Now replace the base CUL with the RFR CUL, and set its id by issuing the fhem command "set MyCUL raw ui0201". Now remove this CUL and attach the original, base CUL again. The RFR CUL got the id 02, and will relay every message to the base CUL with id 01.
Take the RFR CUL, and attach it to an USB power supply, as seen on the image. As the configured base id is not 00, it will activate RF reception on boot, and will start sending messages to the base CUL.
Now you have to define this RFR cul as a fhem device:

Define

define <name> CUL_RFR <own-id> <base-id>

not

set MyCUL raw ui0100

set MyCUL raw ui0201

define MyRFR CUL_RFR 02 01

Set

Get

Attributes

ignore

IODev

OpenData_weather_content.xls

CUL_TCM97001

[EN DE]

Supported models:

ABS700
AURIOL
Eurochron
GT_WT_02
KW9010
NC_WS
TCM21....
TCM97...
PFR-130 (rain)
Prologue
Rubicson
W155 (wind/rain)
W174 (rain)

Define

Generated events:

temperature: The temperature
humidity: The humidity (if available)
battery: The battery state: low or ok (if available)
channel: The Channelnumber (if available)
trend: The temperature trend (if available)

Attributes

IODev Note: by setting this attribute you can define different sets of 8 devices in FHEM, each set belonging to a Device which is capable of receiving the signals. It is important, however, that a device is only received by the defined IO Device, e.g. by using different Frquencies (433MHz vs 868MHz)
do_not_notify
ignore
model (ABS700, AURIOL, GT_WT_02, KW9010, NC_WS, PFR-130, Prologue, Rubicson, TCM21...., TCM97…, Unknown, W174)
max-deviation-temp: (default:1, allowed values: 1,2,3,4,5,6,7,8,9,10,15,20,25,30,35,40,45,50)
showtime
readingFnAttributes

CUL_TX

[EN DE]

Define

define <name> CUL_TX <code> [corr] [minsecs]

Set

N/A

Get

N/A

Attributes

ignore

do_not_notify

showtime

readingFnAttributes

Generated events:

temperature: $temp
humidity: $hum

CUL_WS

[EN DE]

Define

define <name> CUL_WS <code> [corr1...corr4]

Set

N/A

Get

N/A

Attributes

IODev Note: by setting this attribute you can define different sets of 8 devices in FHEM, each set belonging to a CUL. It is important, however, that a device is only received by the CUL defined, e.g. by using different Frquencies (433MHz vs 868MHz)
do_not_notify
eventMap
ignore
model (S300,KS300,ASH2200)
showtime
readingFnAttributes

CULflash

[EN DE]

CULflash [fhem-device|none]; <TYPE>

Note:

CULflash CUL CUL_V3

          CULflash none CUL_V3

Calendar

[EN DE]

Define

define <name> Calendar ical url <URL> [<interval>]

define <name> Calendar ical file <FILENAME> [<interval>]

https://

cpan -i IO::Socket::SSL

https://

http://

https://

https://admin:admin@demo.nextcloud.com/wid0ohgh/remote.php/dav/calendars/admin/personal/?export

The optional parameter interval is the time between subsequent updates in seconds. It defaults to 3600 (1 hour).

Examples:

      define MyCalendar Calendar ical url https://www.google.com/calendar/ical/john.doe%40example.com/private-foo4711/basic.ics
      define YourCalendar Calendar ical url http://www.google.com/calendar/ical/jane.doe%40example.com/private-bar0815/basic.ics 86400
      define SomeCalendar Calendar ical file /home/johndoe/calendar.ics

Set

set <name> update
Forces the retrieval of the calendar from the URL. The next automatic retrieval is scheduled to occur interval seconds later.
set <name> reload
Same as update but all calendar events are removed first.

Get

get <name> update
Same as set <name> update
get <name> reload
Same as set <name> update

get <name> events [format:<formatSpec>] [timeFormat:<timeFormatSpec>] [filter:<filterSpecs>] [series:next[=<max>]] [limit:<limitSpecs>]

The swiss army knife for displaying calendar events. Returns, line by line, information on the calendar events in the calendar <name> according to formatting and filtering rules. You can give none, one or several of the format, timeFormat, filter, series and limit parameters and it makes even sense to give the filter parameter several times.

The format parameter determines the overall formatting of the calendar event. The following format specifications are available:

<formatSpec>	content
`default`	the default format (see below)
`full`	same as `custom="$U $M $A $T1-$T2 $S $CA $L"`
`text`	same as `custom="$T1 $S"`
`custom="<formatString>"`	a custom format (see below)
`custom="{ <perl-code> }"`	a custom format (see below)

Single quotes (') can be used instead of double quotes (") in the custom format.

You can use the following variables in the <formatString> and in the <perl-code>:

variable	meaning
`$t1`	the start time in seconds since the epoch
`$T1`	the start time according to the time format
`$t2`	the end time in seconds since the epoch
`$T2`	the end time according to the time format
`$a`	the alarm time in seconds since the epoch
`$A`	the alarm time according to the time format
`$d`	the duration in seconds
`$D`	the duration in human-readable form
`$S`	the summary
`$L`	the location
`$CA`	the categories
`$CL`	the classification
`$DS`	the description
`$U`	the UID
`$M`	the mode

\, (masked comma) in summary, location and description is replaced by a comma but \n (indicates newline) is untouched.

If the format parameter is omitted, the custom format string from the defaultFormat attribute is used. If this attribute is not set, "$T1 $D $S" is used as default custom format string. The last occurance wins if the format parameter is given several times.

Examples:
get MyCalendar events format:full
get MyCalendar events format:custom="$T1-$T2 $S \@ $L"
get MyCalendar events format:custom={ sprintf("%20s %8s", $S, $D) }

The timeFormat parameter determines the formatting of start, end and alarm times.

You use the POSIX conversion specifications in the <timeFormatSpec>. The web page strftime.net has a nice builder for <timeFormatSpec>.

If the timeFormat parameter is omitted, the time format specification from the defaultTimeFormat attribute is used. If this attribute is not set, "%d.%m.%Y %H:%M" is used as default time format specification. Single quotes (') or double quotes (") can be used to enclose the format specification.

The last occurance wins if the parameter is given several times.

Example:
get MyCalendar events timeFormat:"%e-%b-%Y" format:full

The filter parameter restricts the calendar events displayed to a subset. <filterSpecs> is a comma-separated list of <filterSpec> specifications. All filters must apply for a calendar event to be displayed. The parameter is cumulative: all separate occurances of the parameter add to the list of filters.

`<filterSpec>`	description
`uid=="<uid>"`	UID is `<uid>` same as `field(uid)=="<uid>"`
`uid=~"<regex>"`	UID matches regular expression `<regex>` same as `field(uid)=~"<regex>"`
`mode=="<mode>"`	mode is `<mode>` same as `field(mode)=="<mode>"`
`mode=~"<regex>"`	mode matches regular expression `<regex>` same as `field(mode)=~"<regex>"`
`field(<field>)=="<value>"`	content of the field `<field>` is `<value>` <field> is one of `uid`, `mode`, `summary`, `location`, `description`, `categories`, `classification`
`field(<field>)=~"<regex>"`	content of the field <field> matches <regex> <field> is one of `uid`, `mode`, `summary`, `location`, `description`, `categories`, `classification`

The double quotes (") on the right hand side of a <filterSpec> are not part of the value or regular expression. Single quotes (') can be used instead.

Examples:
get MyCalendar events filter:uid=="432dsafweq64yehdbwqhkd"
get MyCalendar events filter:uid=~"^7"
get MyCalendar events filter:mode=="alarm"
get MyCalendar events filter:mode=~"alarm|upcoming"
get MyCalendar events filter:field(summary)=~"Mama"
get MyCalendar events filter:field(classification)=="PUBLIC"
get MyCalendar events filter:field(summary)=~"Gelber Sack",mode=~"upcoming|start"
get MyCalendar events filter:field(summary)=~"Gelber Sack" filter:mode=~"upcoming|start"

The series parameter determines the display of recurring events. series:next limits the display to the next calendar event out of all calendar events in the series that have not yet ended. series:next=<max> shows at most the <max> next calendar events in the series. This applies per series. To limit the total amount of events displayed see the limit parameter below.

The limit parameter limits the number of events displayed. <limitSpecs> is a comma-separated list of <limitSpec> specifications.

`<limitSpec>`	description
`count=<n>`	shows at most `<n>` events, `<n>` is a positive integer
`from=[+\|-]<timespec>`	shows only events that end after a timespan <timespec> from now; use a minus sign for events in the past; <timespec> is described below in the Attributes section
`to=[+\|-]<timespec>`	shows only events that start before a timespan <timespec> from now; use a minus sign for events in the past; <timespec> is described below in the Attributes section

Examples:
get MyCalendar events limit:count=10
get MyCalendar events limit:from=-2d
get MyCalendar events limit:count=10,from=0,to=+10d

get <name> find <regexp>
Returns, line by line, the UIDs of all calendar events whose summary matches the regular expression <regexp>.
get <name> vcalendar
Returns the calendar in ICal format as retrieved from the source.
get <name> vevents
Returns a list of all VEVENT entries in the calendar with additional information for debugging. Only properties that have been kept during processing of the source are shown. The list of calendar events created from each VEVENT entry is shown as well as the list of calendar events that have been omitted.

Attributes

defaultFormat <formatSpec>
Sets the default format for the get <name> events command. The specification is explained there. You must enclose the <formatSpec> in double quotes (") like input in attr myCalendar defaultFormat "$T1 $D $S".

defaultTimeFormat <timeFormatSpec>
Sets the default time format for the get <name>events command. The specification is explained there. Do not enclose the <timeFormatSpec> in quotes.

update sync|async|none
If this attribute is not set or if it is set to sync, the processing of the calendar is done in the foreground. Large calendars will block FHEM on slow systems. If this attribute is set to async, the processing is done in the background and FHEM will not block during updates. If this attribute is set to none, the calendar will not be updated at all.

removevcalendar 0|1
If this attribute is set to 1, the vCalendar will be discarded after the processing to reduce the memory consumption of the module. A retrieval via get <name> vcalendar is then no longer possible.

hideOlderThan <timespec>
hideLaterThan <timespec>

The time is specified relative to the current time t. If hideOlderThan is set, calendar events that ended before t-hideOlderThan are not shown. If hideLaterThan is set, calendar events that will start after t+hideLaterThan are not shown.

Please note that an action triggered by a change to mode "end" cannot access the calendar event if you set hideOlderThan to 0 because the calendar event will already be hidden at that time. Better set hideOlderThan to 10.

<timespec> must have one of the following formats:

format	description	example
SSS	seconds	3600
SSSs	seconds	3600s
HH:MM	hours:minutes	02:30
HH:MM:SS	hours:minutes:seconds	00:01:30
D:HH:MM:SS	days:hours:minutes:seconds	122:10:00:00
DDDd	days	100d

cutoffOlderThan <timespec>
This attribute cuts off all calendar events that ended a timespan cutoffOlderThan before the last update of the calendar. The purpose of setting this attribute is to save memory. Such calendar events cannot be accessed at all from FHEM. Calendar events are not cut off if they are recurring with no end of series (UNTIL) or if they have no end time (DTEND).

onCreateEvent <perl-code>
This attribute allows to run the Perl code <perl-code> for every calendar event that is created. See section Plug-ins below.

SSLVerify
This attribute sets the verification mode for the peer certificate for connections secured by SSL. Set attribute either to 0 for SSL_VERIFY_NONE (no certificate verification) or to 1 for SSL_VERIFY_PEER (certificate verification). Disabling verification is useful for local calendar installations (e.g. OwnCloud, NextCloud) without valid SSL certificate.

ignoreCancelled
Set to 1 to ignore events with status "CANCELLED". Set this attribute to 1 if calanedar events of a series are returned although they are cancelled.

quirks <values>
Parameters to handle special situations. <values> is a comma-separated list of the following keywords:
- ignoreDtStamp: if present, a modified DTSTAMP attribute of a calendar event does not signify that the calendar event was modified.

readingFnAttributes

Description

A calendar event has a summary (usually the title shown in a visual representation of the source calendar), a start time, an end time, and zero, one or more alarm times. In case of multiple alarm times for a calendar event, only the earliest alarm time is kept.

Recurring calendar events (series) are currently supported to an extent: FREQ INTERVAL UNTIL COUNT are interpreted, BYMONTHDAY BYMONTH WKST are recognized but not interpreted. BYDAY is correctly interpreted for weekly and monthly events. The module will get it most likely wrong if you have recurring calendar events with unrecognized or uninterpreted keywords. Out-of-order events and events excluded from a series (EXDATE) are handled. Calendar events are only created within ±400 days around the time of the last update.

Calendar events are created when FHEM is started or when the respective entry in the source calendar has changed and the calendar is updated or when the calendar is reloaded with get <name> reload. Only calendar events within ±400 days around the event creation time are created. Consider reloading the calendar from time to time to avoid running out of upcoming events. You can use something like define reloadCalendar at +*240:00:00 set MyCalendar reload for that purpose.

Some dumb calendars do not use LAST-MODIFIED. This may result in modifications in the source calendar go unnoticed. Reload the calendar if you experience this issue.

A calendar event is identified by its UID. The UID is taken from the source calendar. All events in a series including out-of-order events habe the same UID. All non-alphanumerical characters are stripped off the original UID to make your life easier.

A calendar event can be in one of the following modes:

upcoming	Neither the alarm time nor the start time of the calendar event is reached.
alarm	The alarm time has passed but the start time of the calendar event is not yet reached.
start	The start time has passed but the end time of the calendar event is not yet reached.
end	The end time of the calendar event has passed.

A calendar device has several readings. Except for calname, each reading is a semicolon-separated list of UIDs of calendar events that satisfy certain conditions:

calname	name of the calendar
modeAlarm	events in alarm mode
modeAlarmOrStart	events in alarm or start mode
modeAlarmed	events that have just transitioned from upcoming to alarm mode
modeChanged	events that have just changed their mode somehow
modeEnd	events in end mode
modeEnded	events that have just transitioned from start to end mode
modeStart	events in start mode
modeStarted	events that have just transitioned to start mode
modeUpcoming	events in upcoming mode

For recurring events, usually several calendar events exists with the same UID. In such a case, the UID is only shown in the mode reading for the most interesting mode. The most interesting mode is the first applicable of start, alarm, upcoming, end.

In particular, you will never see the UID of a series in modeEnd or modeEnded as long as the series has not yet ended - the UID will be in one of the other mode... readings. This means that you better do not trigger FHEM events for series based on mode... readings. See below for a recommendation.

Events

triggered

When you receive this event, you can rely on the calendar's readings being in a consistent and most recent state.

When a calendar event has changed, two FHEM events are created:

changed: UID <mode>
<mode>: UID

<mode> is the current mode of the calendar event after the change. Note: there is a colon followed by a single space in the FHEM event specification.

The recommended way of reacting on mode changes of calendar events is to get notified on the aforementioned FHEM events and do not check for the FHEM events triggered by a change of a mode reading.

Plug-ins

$e

code	description
$e->{start}	the start time of the calendar event, in seconds since the epoch
$e->{end}	the end time of the calendar event, in seconds since the epoch
$e->{alarm}	the alarm time of the calendar event, in seconds since the epoch
$e->{summary}	the summary (caption, title) of the calendar event
$e->{location}	the location of the calendar event

attr MyCalendar onCreateEvent { $e->{alarm}= $e->{start}-86400 if($e->{summary} =~ /Tonne/);; }

Perl specials

attr MyCalendar onCreateEvent { $e->{end}= $e->{start}+86400 unless(defined($e->{end})) }

Usage scenarios

Show all calendar events with details


    get MyCalendar events format:full

    2767324dsfretfvds7dsfn3e4dsa234r234sdfds6bh874googlecom     alarm 31.05.2012 17:00:00 07.06.2012 16:30:00-07.06.2012 18:00:00 Erna for coffee

    992hydf4y44awer5466lhfdsrgl7tin6b6mckf8glmhui4googlecom  upcoming                     08.06.2012 00:00:00-09.06.2012 00:00:00 Vacation

Show calendar events in your photo frame

layout description

text 20 60 { fhem("get MyCalendar events timeFormat:'%d.%m.%Y %H:%M' format:custom='$T1 $S' filter:mode=~'alarm|start') }


    07.06.12 16:30 Erna for coffee

    08.06.12 00:00 Vacation

Switch the light on when Erna comes


    get MyCalendar find .*Erna.*

    2767324dsfretfvds7dsfn3e4dsa234r234sdfds6bh874googlecom


    define ErnaComes notify MyCalendar:start:.2767324dsfretfvds7dsfn3e4dsa234r234sdfds6bh874googlecom set MyLight on


    define LogErna notify MyCalendar:alarm:.2767324dsfretfvds7dsfn3e4dsa234r234sdfds6bh874googlecom { Log3 $NAME, 1, "ALARM name=$NAME event=$EVENT part1=$EVTPART0 part2=$EVTPART1" }

Switch actors on and off


    define SwitchActorOn  notify MyCalendar:start:.* { \

                my $reading="$EVTPART0";; \

                my $uid= "$EVTPART1";; \

                my $actor= fhem('get MyCalendar filter:uid=="'.$uid.'" format:custom="$S"');; \

                if(defined $actor) {
                   fhem("set $actor on")
                } \

    }


    define SwitchActorOff  notify MyCalendar:end:.* { \

                my $reading="$EVTPART0";; \

                my $uid= "$EVTPART1";; \

                my $actor= fhem('get MyCalendar filter:uid=="'.$uid.'" format:custom="$S"');; \

                if(defined $actor) {
                   fhem("set $actor off")
                } \

    }


    define LogActors notify MyCalendar:(start|end):.*
    { my $reading= "$EVTPART0";; my $uid= "$EVTPART1";; \

      my $actor= fhem('get MyCalendar filter:uid=="'.$uid.'" format:custom="$S"');; \

     Log3 $NAME, 1, "Actor: $actor, Reading $reading" }

Inform about garbage collection

GarbageCalendar


    define GarbageCollectionNotifier notify GarbageCalendar:alarm:.* { \

      my $uid= "$EVTPART1";; \

      my $summary= fhem('get MyCalendar events filter:uid=="'.$uid.'" format:custom="$S"');; \

      # e.g. mail $summary to someone \

    }


    attr GarbageCalendar onCreateEvent { $e->{alarm}= $e->{start}-86400 }

{ CalendarEventsAsHtml('GarbageCalendar','format:text filter:mode=~"alarm|start"') }

Embedded HTML

CalendarAsHtml(<name>,<options>)

<name>

<options>

get <name> text ...

define MyCalendarWeblink weblink htmlCode { CalendarAsHtml("MyCalendar","next 3") }

CalendarEventsAsHtml(<name>,<parameters>)

<name>

<parameters>

get <name> events <parameters>

define MyCalendarWeblink weblink htmlCode
  { CalendarEventsAsHtml('F','format:custom="$T1 $D $S" timeFormat="%d.%m" series:next=3') }

ComfoAir

[EN DE]

Prerequisites

This module requires the Device::SerialPort or Win32::SerialPort module.

Define

define <name> ComfoAir <device> <Interval>

define ZL ComfoAir /dev/ttyUSB1@9600 60

Configuration of the module

        Bootloader-Version
        Firmware-Version
        RS232-Modus
        Sensordaten
        KonPlatine-Version
        Verzoegerungen
        Ventilation-Levels
        Temperaturen
        Betriebsstunden
        Status-Bypass
        Status-Vorheizung

        poll-Bootloader-Version
        poll-Firmware-Version
        poll-RS232-Modus
        poll-Sensordaten
        poll-KonPlatine-Version
        poll-Verzoegerungen
        poll-Ventilation-Levels
        poll-Temperaturen
        poll-Betriebsstunden
        poll-Status-Bypass
        poll-Status-Vorheizung

        define ZL ComfoAir /dev/ttyUSB1@9600 60
        attr ZL poll-Status-Bypass 0
        define FileLog_Lueftung FileLog ./log/Lueftung-%Y.log ZL

Set-Commands

        request-Status-Bypass 
        request-Bootloader-Version 
        request-Sensordaten
        request-Temperaturen 
        request-Firmware-Version 
        request-KonPlatine-Version 
        request-Ventilation-Levels 
        request-Verzoegerungen 
        request-Betriebsstunden 
        request-Status-Vorheizung

        Temp_Komfort (target temperature for comfort)
        Stufe (ventilation level)

Get-Commands

showget => 1

Attributes

do_not_notify
readingFnAttributes

poll-Bootloader-Version
poll-Firmware-Version
poll-RS232-Modus
poll-Sensordaten
poll-KonPlatine-Version
poll-Verzoegerungen
poll-Ventilation-Levels
poll-Temperaturen
poll-Betriebsstunden
poll-Status-Bypass
poll-Status-Vorheizung

hide-Bootloader-Version
hide-Firmware-Version
hide-RS232-Modus
hide-Sensordaten
hide-KonPlatine-Version
hide-Verzoegerungen
hide-Ventilation-Levels
hide-Temperaturen
hide-Betriebsstunden
hide-Status-Bypass
hide-Status-Vorheizung

queueDelay

queueMax

timeout

CustomReadings

[EN DE]

Example (definition in fhem.cfg)


define myReadings CustomReadings

attr myReadings room 0-Test

attr myReadings group Readings

attr myReadings interval 2

attr myReadings readingDefinitions hdd_temperature:qx(hddtemp /dev/sda 2>&1),

ac_powersupply_voltage:qx(cat /sys/class/power_supply/ac/voltage_now 2>&1) / 1000000,

ac_powersupply_current:qx(cat /sys/class/power_supply/ac/current_now 2>&1) / 1000000,

perl_version:$],

timezone:qx(cat /etc/timezone 2>&1),

kernel:qx(uname -r 2>&1),

device_name:$hash->{NAME},

bullshit: $hash->{bullshit},

fhem_backup_folder_size:qx(du -ch /opt/fhem/backup | grep total | cut -d 't' -f1 2>&1)





Optionally, to display the readings:

define myReadingsDisplay weblink htmlCode {CustomReadings_GetHTML('myReadings')}

attr myReadingsDisplay group Readings

attr myReadingsDisplay room 0-Test

Resulting readings:

ac_powersupply_current	0.236	2014-08-09 15:40:21
ac_powersupply_voltage	5.028	2014-08-09 15:40:21
bullshit	ERROR	2014-08-09 15:40:21
device_name	myReadings	2014-08-09 15:40:21
fhem_backup_folder_size	20M	2014-08-09 15:40:21
hdd_temperature	/dev/sda: TS128GSSD320: 47°C	2014-08-09 15:40:21
kernel	3.4.103-sun7i+	2014-08-09 15:40:21
perl_version	5.014002	2014-08-09 15:40:21
timezone	Europe/Berlin	2014-08-09 15:40:21

Define

Readings

Attributes

interval
Refresh interval in seconds

readingDefinitions
The definitions are separated by a comma. A definition consists of two parts, separated by a colon.
The first part is the name of the reading and the second part the function.
The function gets evaluated and must return a result.

Example: kernel:qx(uname -r 2>&1)
Defines a reading with the name "kernel" and evaluates the linux function uname -r
Multiline output from commands, systemcall, scripts etc. can be use for more than one reading with
the keyword COMBINED as reading (which wont appear itself) while its command output
will be put line by line in the following readings defined (so they don't need a function defined
after the colon (it would be ignored)).But the lines given must match the number and order of the
following readings.

COMBINED can be used together or lets say after or even in between normal expressions if the
number of lines of the output matches exactly. Example: COMBINED:qx(cat /proc/sys/vm/dirty_background*),dirty_bytes:,dirty_ration:
Defines two readings (dirty_bytes and dirty_ratio) which will get set by the lines of those
two files the cat command will find in the kernel proc directory.
In some cases this can give an noticeable performance boost as the readings are filled up all at once.

DFPlayerMini - FN-M16P Embedded MP3 Audio Module

[EN DE]

This module integrates the DFPlayerMini - FN-M16P Embedded MP3 Audio Module device into fhem. See the datasheet of the module for technical details.
The MP3 player can be connected directly to a serial interface or via ethernet/WiFi by using a hardware with offers a transparent serial bridge over TCP/IP like ESPEasy Ser2Net.

It is also possible to use other fhem transport devices like MYSENSORS.

The module supports all commands of the DFPlayer and offers additional convenience functions like

integration of Text2Speech for easy download of speech mp3 files
easier control of which file to play by
keeping a reference of all files the DFPlayer can play
playing several files in succession (playlist)
creating and playing files for speaking numbers

Define
define <name> DFPlayerMini {none | devicename[\@baudrate] | devicename\@directio | hostname:port}

If directly connected <devicename> specifies the serial port to communicate with the DFPlayer Mini. The name of the serial-device depends on your distribution, under linux the cdc_acm kernel module is responsible, and usually a /dev/ttyACM0 or /dev/ttyUSB0 device will be created. You can also specify a baudrate if the device name contains the @ character, e.g.: /dev/ttyACM0@9600

This is also the default baudrate and normally shouldn't be changed as the DFPlayer uses a fixed baudrate of 9600. If the baudrate is "directio" (e.g.: /dev/ttyACM0@directio), then the perl module Device::SerialPort is not needed, and fhem opens the device with simple file io. This might work if the operating system uses sane defaults for the serial parameters, e.g. some Linux distributions and OSX.
If connected via TCP/IP <hostname:port> specifies the IP address and port of the device that provides the transparent serial bridge to the DFP, e.g. 192.168.2.28:23
for other types of transport none can be specified as the device. In that case the attribute sendCmd should be specified and responses from the DFP should be given to this module with set response.

Attributes

TTSDev
The name of a Text2Speech device. This has to be defined beforehand with none as the <alsadevice> as a server device. It should be used for no other purposes than use by this module.
requestAck
The DFPlayer can send a response to any command sent to it to acknowledge that is has received the command. As this increases the communication overhead it can be switched off if the communication integrity is ensured by other means. If set the next command is only sent if the last one was acknowledged by the DFPlayer. This ensures that no command is lost if the the DFPlayer is busy/sleeping.
sendCmd
A fhem command that is used to send the command data generated by this module to the DFPlayer hardware. If this is set, no other way of communication with the DFP is used. This can be used integrate other transport devices than those supported natively.
E. g. to communicate via a MySensors device named mys_dfp with an appropriate sketch use
attr <dfp> sendCmd set mys_dfp value11 $msg
The module will then send a command to the DFP replacing $msg with the actual payload using the fhem command set mys_dfp value11 <payload>
See set response for a way to get the response of the DFPlayer received via a different device back into this module.
uploadPath
The DFPlayer plays files from an SD card or USB stick connected to it. The mp3/wav files have to be copied to this storage device by the user. The device expects the files with specific names and in specific folders, see the datasheet for details. Copying the files can also be done by this module if the storage device is accessible by the computer fhem is running on. It has to be mounted in a specific path with is specified with this attribute.
See uploadTTS, uploadTTScache and readFiles commands where this is used.
rememberMissingTTS
If set tts commands without a matching file create a special reading. See set tts and set uploadTTScache.
keepAliveInterval
Specifies the interval in seconds for sending a keep alive message to the DFP. Can be used to check if the DFP is still working and to keep connections open.
After three missing answers the status of the devices is set to disconnected.
Set the interval to 0 to disable the keep alive feature. Default is 60 seconds.

Get

All query commands supported by the DFP have a corresponding get command:

get	DFP cmd byte	parameters	comment
storage	0x3F
status	0x42
volume	0x43
equalizer	0x44
noTracksRootUsb	0x47
noTracksRootSd	0x48
currentTrackUsb	0x4B
currentTrackSd	0x4C
noTracksInFolder	0x4E	folder number	1-99
noFolders	0x4F

Set

All commands supported by the DFP have a corresponding set command:

set	DFP cmd byte	parameters	comment
next	0x01	-
prev	0x02	-
trackNum	0x03	number of track in root directory	between 1 and 3000 (uses the order in which the files where created!)
volumeUp	0x04	-
volumeDown	0x05	-
volumeStraight	0x06	volume	0-30
equalizer	0x07	name of the equalizer mode	Normal, Pop, Rock, Jazz, Classic, Bass
repeatSingle	0x08	-
storage	0x09	SD or USB
sleep	0x0A	-	not supported by DFP, DFP needs power cycle to work again
wake	0x0B	-	not supported by DFP, but probably by FN-M22P
reset	0x0C	-
play	0x0D	-	plays the current track
play	0x0F, 0x12, 0x13, 0x14	a space separated list of files to play successively	the correct DFP command is used automatically. Files can be specified with either their reading name, reading value or folder name/track number. See set readFiles
pause	0x0E	-
amplification	0x10	level of amplification	0-31
repeatRoot	0x11	on, off
MP3TrackNum	0x12	tracknumber	1-3000, from folder MP3
intercutAdvert	0x13	tracknumber	1-3000, from folder ADVERT
folderTrackNum	0x0F	foldernumber tracknumber	folder: 1-99, track: 1-255
folderTrackNum3000	0x14	foldernumber tracknumber	folder: 1-15, track: 1-3000
stopAdvert	0x15	-
stop	0x16	-
repeatFolder	0x17	number of folder	1-99
shuffle	0x18	-
repeatCurrentTrack	0x19	on, off
DAC	0x1A	on, off

All other set commands are not sent to the DFP but offer convenience functions:

close
raw
sends a command encoded in hex directly to the DFP without any validation
reopen
readFiles
reads all files from the storage medium mounted at uploadPath. If these files are accessible by the DFP (i.e. they conform to the naming convention) a reading is created for the file. The reading name is File_<folder>/<tracknumber>. Folder can be ., MP3, ADVERT, 00 to 99. The reading value is the filename without the tracknumber and suffix.
Example:
For the file MP3/0003SongTitle.mp3 the reading File_MP3/0003 with value SongTitle is created.
The set <dfp> play command can make use of these readings, i.e. it is possible to use either set <dfp> play File_MP3/0003, set <dfp> play MP3/3 or set <dfp> play SongTitle to play the same track.
uploadTTS <destination path> <Text to translate to speech>
The text specified is converted to a speech mp3 file using the Text2Speech device specified with attr TTSDev. The mp3 file is then copied into the given destination path within uploadPath.
Examples:
set <dfp> 01/0001Test Dies ist ein Test
set <dfp> ADVERT/0099Hinweis Achtung
uploadTTScache
upload all files from the cache directory of the TTSDev to uploadPath. Uploading starts with folder 01. After 3000 files the next folder is used. The MD5 hash is used as the filename. When the upload is finished set readFiles is executed. The command set tts makes use of the readings created by this.
tts <text to translate to speech>
TTSDev is used to calculate the MD5 hash of <text to translate to speech>. It then tries to play the file with this hash value. If no reading for such a file exists and if the attribute rememberMissingTTS is set, a new reading Missing_MD5<md5> with <text to translate to speech> as its value is created.
Prerequisites:
This only works if this text had been translated earlier and the resulting mp3 file was stored in the cache directory of TTSDev. The files in the cache have to be uploaded to the storage card with set uploadTTScache.
uploadNumbers destinationFolder
creates mp3 files for all tokens required to speak arbitrary german numbers.
Example:
set <dfp> uploadNumbers 99
creates the 31 mp3 files required in folder 99.
sayNumber number
translates a number into speech and plays the required tracks. Requires that uploadNumbers command was used to create the speech files.
Example:
sayNumber -34.7
is equivalent to
play minus vier und dreissig komma sieben
response
10 bytes response message from DFP encoded as hex

DLNARenderer

[EN DE]

Note:

SOAP::Lite
LWP::Simple
XML::Simple
XML::Parser::Lite
LWP::UserAgent

Define

define <name> DLNARenderer

define dlnadevices DLNARenderer

Set

set <name> stream <value>

set <name> on

set <name> off

set <name> stop

set <name> volume 0-100

set <name> volume +/-0-100

set <name> channel 1-10

set <name> mute on/off

set <name> pause

set <name> pauseToggle

set <name> play

set <name> next

set <name> previous

set <name> seek <seconds>

set <name> speak "This is a test. 1 2 3."

set <name> playEverywhere

set <name> stopPlayEverywhere

set <name> addUnit <unitName>

set <name> removeUnit <unitName>

set <name> multiRoomVolume 0-100

set <name> multiRoomVolume +/-0-100

set <name> enableBTCaskeid

set <name> disableBTCaskeid

set <name> stereo <left> <right> <pairName>

set <name> standalone

set <name> saveGroupAs <groupName>

set <name> loadGroup <groupName>

Attributes

ignoreUDNs

DOIF

[EN DE]

define <name> DOIF (<condition>) (<commands>) DOELSEIF (<condition>) (<commands>) DOELSEIF ... DOELSE (<commands>)

define <name> DOIF <Blockname> {<Perl with DOIF-Syntax>} <Blockname> {<Perl with DOIF-Syntax>} ...

Features

[<devicename>]

[<devicename>:<readingname>]

[<devicename>:&<internal>]

[HH:MM:SS]

[HH:MM]

[<seconds>]

[[<devicename>]]

[[<devicename>:<readingname>]]

[{<perl-function>}]

[(<time calculation in Perl with time syntax specified above>)]

[<begin>-<end>]

<begin>

<end>

[+<time>]

[+<begin>-+<end>]

[<time>|012345678]

[<begin>-<end>|012345678]

german section

DOIFtools

[EN DE]

create readingsGroup definitions for labeling frontend widgets.
create a debug logfile for some DOIF and quoted devices with optional device listing each state or wait timer update.
optional device listing in debug logfile each state or wait timer update.
navigation between device listings in logfile if opened via DOIFtools.
create userReadings in DOIF devices displaying real dates for weekday restricted timer.
delete user defined readings in DOIF devices with multiple choice.
delete visible readings in other devices with multiple choice, but not state.
record statistics data about events.
limitting recordig duration.
generate a statistics report.
lists every DOIF definition in probably associated with.
access to DOIFtools from any DOIF device via probably associated with
access from DOIFtools to existing DOIFtoolsLog logfiles
show event monitor in device detail view and optionally in DOIFs detail view
convert events to DOIF operands, a selected operand is copied to clipboard and the DEF editor will open
check definitions and offer recommendations for DOIF MODEL FHEM
create shortcuts
optionally create a menu entry
show a list of running wait timer
scale values to color numbers and RGB values for coloration

DUOFERN

[EN DE]

DuoFern USB Stick

Define

define <name> DUOFERN <code>

define myDuoFern DUOFERN 49ABCD

Set

Universal commands (available to most actors):

remotePair
Activates the pairing mode of the actor.
Some actors accept this command in unpaired mode up to two hours afte power up.

remoteUnpair
Activates the unpairing mode of the actor.

getStatus
Sends a status request message to the DuoFern device.

manualMode [on|off]
Activates the manual mode. If manual mode is active all automatic functions will be ignored.

timeAutomatic [on|off]
Activates the timer automatic.

sunAutomatic [on|off]
Activates the sun automatic.

dawnAutomatic [on|off]
Activates the dawn automatic.

duskAutomatic [on|off]
Activates the dusk automatic.

dusk
Move roller shutter downwards or switch on switch/dimming actor if duskAutomatic is activated.

dawn
Move roller shutter upwards or switch off switch/dimming actor if dawnAutomatic is activated.

sunMode [on|off]
Activates the sun mode. If sun automatic is activated, the roller shutter will move to the sunPosition or a switch/dimming actor will shut off.

reset [settings|full]
settings: Clear all settings and endpoints of the actor.
full: Complete reset of the actor including pairs.

Roller shutter actor commands:

up [timer]
Move the roller shutter upwards. If parameter timer is used the command will only be executed if timeAutomatic is activated.

down [timer]
Move the roller shutter downwards. If parameter timer is used the command will only be executed if timeAutomatic is activated.

stop
Stop motion.

position <value> [timer]
Set roller shutter to a desired absolut level. If parameter timer is used the command will only be executed if timeAutomatic is activated.

toggle
Switch the roller shutter through the sequence up/stop/down/stop.

rainAutomatic [on|off]
Activates the rain automatic.

windAutomatic [on|off]
Activates the wind automatic.

sunPosition <value>
Set the sun position.

ventilatingMode [on|off]
Activates the ventilating mode. If activated, the roller shutter will stop on ventilatingPosition when moving down.

ventilatingPosition <value>
Set the ventilating position.

windMode [on|off]
Activates the wind mode. If wind automatic and wind mode is activated, the roller shutter moves in windDirection and ignore any automatic or manual command.
The wind mode ends 15 minutes after last activation automatically.

windDirection [up|down]
Movemet direction for wind mode.

rainMode [on|off]
Activates the rain mode. If rain automatic and rain mode is activated, the roller shutter moves in rainDirection and ignore any automatic command.
The rain mode ends 15 minutes after last activation automatically.

rainDirection [up|down]
Movemet direction for rain mode.

runningTime <sec>
Set the motor running time.

motorDeadTime [off|short|long]
Set the motor dead time.

reversal [on|off]
Reversal of direction of rotation.

Switch/dimming actor commands:

on [timer]
Switch on the actor. If parameter timer is used the command will only be executed if timeAutomatic is activated.

off [timer]
Switch off the actor. If parameter timer is used the command will only be executed if timeAutomatic is activated.

set extensions are supported.

level <value> [timer]
Set actor to a desired absolut level. If parameter timer is used the command will only be executed if timeAutomatic is activated.

modeChange [on|off]
Inverts the on/off state of a switch actor or change then modus of a dimming actor.

stairwellFunction [on|off]
Activates the stairwell function of a switch/dimming actor.

stairwellTime <sec>
Set the stairwell time.

Blind actor commands:

blindsMode [on|off]
Activates the blinds mode.

slatPosition <value>
Set the slat to a desired absolut level.

defaultSlatPos <value>
Set the default slat position.

slatRunTime <msec>
Set the slat running time.

tiltInSunPos [on|off]
Tilt slat after blind moved to sun position.

tiltInVentPos [on|off]
Tilt slat after blind moved to ventilation position.

tiltAfterMoveLevel [on|off]
Tilt slat after blind moved to an absolute position.

tiltAfterStopDown [on|off]
Tilt slat after stopping blind while moving down.

Thermostat commands:

desired-temp <temp> [timer]
Set desired temperature. <temp> must be between -40 and 80 Celsius, and precision is half a degree. If parameter timer is used the command will only be executed if timeAutomatic is activated.

tempUp [timer]
Increases the desired temperature by half a degree. If parameter timer is used the command will only be executed if timeAutomatic is activated.

tempDown [timer]
Decrease the desired temperature by half a degree. If parameter timer is used the command will only be executed if timeAutomatic is activated.

temperatureThreshold[1|2|3|4] <temp>
Set temperature threshold 1 to 4. <temp> must be between -40 and 80 Celsius, and precision is half a degree.

actTempLimit [timer]
Set desired temperature to the selected temperatureThreshold. If parameter timer is used the command will only be executed if timeAutomatic is activated.

Radiator Actuator commands:

desired-temp <temp> [timer]
Set desired temperature. <temp> must be between 4 and 35.5 Celsius, and precision is half a degree. If parameter timer is used the command will only be executed if timeAutomatic is activated.

sendingInterval <minutes>
Sets the transmission interval of the status responds.

SX5 commands:

10minuteAlarm [on|off]
Activates the alarm sound of the SX5 when the door is left open for longer than 10 minutes.

2000cycleAlarm [on|off]
Activates the alarm sounds of the SX5 when the SX5 has run 2000 cycles.

automaticClosing [off|30|60|90|120|150|180|210|240]
Set the automatic closing time of the SX5 (sec).

openSpeed [11|15|19]
Set the open speed of the SX5 (cm/sec).

backJump [on|off]
If activated the SX5 moves briefly in the respective opposite direction after reaching the end point.

getConfig
Sends a config request message to the weather sensor.

Weather sensor commands:

getConfig
Sends a configuration request message.

getTime
Sends a time request message.

getWeather
Sends a weather data request message.

writeConfig
Write the configuration back to the weather sensor.

DCF [on|off]
Switch the DCF receiver on or off.

time
Set the current system time to the weather sensor.

interval <value>
Set the interval time for automatic transmittion of the weather data.
<value>: off or 1 to 100 minutes

latitude <value>
Set the latitude of the weather sensor position
<value>: 0 to 90

longitude <value>
Set the longitude of the weather sensor position
<value>: -90 to 90

timezone <value>
Set the time zone of the weather sensor
<value>: 0 to 23

triggerDawn <value1> ... [<value5>]
Sets up to 5 trigger values for a dawn event.
<value[n]>: off or 1 to 100 lux

triggerDusk <value1> ... [<value5>]
Sets up to 5 trigger values for a dusk event.
<value[n]>: off or 1 to 100 Lux

triggerRain [on|off]
Switch the trigger of the rain event on or off.

triggerSun <value1>:<sun1>:<shadow1>[:<temperature1>] ... [<value5>:<sun5>:<shadow5>[:<temperature5>]]
Sets up to 5 trigger values for a sun event.
<value[n]>: off or 1 to 100 kLux
<sun[n]>: time to detect sun, 1 to 30 minutes
<shadow[n]>: time to detect shadow, 1 to 30 minutes
<temperature[n]>: optional minimum temperature, -5 to 26 °C

triggerSunDirction <startangle1>:<width1> ... [<startangle5>:<width5>]
If enabled, the respective sun event will only be triggered, if sunDirection is in the specified range.
<startangle[n]>: off or 0 to 292.5 degrees (stepsize 22.5°)
<width[n]>: 45 to 180 degrees (stepsize 45°)

triggerSunHeight <startangle1>:<width1> ... [<startangle5>:<width5>]
If enabled, the respective sun event will only be triggered, if sunHeight is in the specified range.
<startangle[n]>: off or 0 to 65 degrees (stepsize 13°)
<width[n]>: 26 or 52 degrees

triggerTemperature <value1> ... [<value5>]
Sets up to 5 trigger values for a temperature event.
<value[n]>: off or -40 to 80 °C

triggerWind <value1> ... [<value5>]
Sets up to 5 trigger values for a wind event.
<value[n]>: off or 1 to 31 m/s

Get

N/A

Attributes

IODev

timeout <sec>
After sending a command to an actor, the actor must respond with its status within this time. If no status message is received, up to two getStatus commands are resend.
Default 60s.

toggleUpDown
If attribute is set, a stop command is send instead of the up or down command if the roller shutter is moving.

positionInverse
If attribute is set, the position value of the roller shutter is inverted.

DUOFERNSTICK

[EN DE]

Define

define <name> DUOFERNSTICK <device> <code>

define myDuoFernStick DUOFERNSTICK COM5@115200 6FEDCB

define myDuoFernStick DUOFERNSTICK /dev/serial/by-id/usb-Rademacher_DuoFern_USB-Stick_WR0455TN-if00-port0@115200 6FEDCB

Set

pair
Set the DuoFern stick in pairing mode for 60 seconds. Any DouFern device set into pairing mode in this time will be paired with the DuoFern stick.

unpair
Set the DuoFern stick in unpairing mode for 60 seconds. Any DouFern device set into unpairing mode in this time will be unpaired from the DuoFern stick.

reopen
Reopens the connection to the device and reinitializes it.

statusBroadcast
Sends a status request message to all DuoFern devices.

remotePair <code>
Activates the pairing mode on the device specified by the code.
Some actors accept this command in unpaired mode up to two hours afte power up.

raw <rawmsg>
Sends a raw message.

Get

N/A

Attributes

N/A

DWD_OpenData

[EN DE]

Open Data Server

weather forecasts: Total lists of local forecasts of WMO, national and interpolated stations, all variables, 3, 9, 15, 21 UTC. More than 70 properties are available for worldwide POIs and the German DWD network. This data typically spans 10 days and is updated by the DWD every 6 hours.

You can request forecasts for different stations in sequence using the command get forecast <station code> or for one station continuously using the attribute forecastStation. To get continuous mode for more than one station you need to create separate DWD_OpenData devices.

In continuous mode the forecast data will be shifted by one day at midnight without requiring new data from the DWD.

weather alerts: Warning status for Germany as union of referenced community/district warnings. This data is updated by the DWD as required.

After updating the alerts cache using the command get updateAlertsCache <mode> you can request alerts for different warncells in sequence using the command get alerts <warncell id>. Setting the attribute alertArea will enable continuous mode. To get continuous mode for more than one station you need to create separate DWD_OpenData devices.

Notes: This function is not suitable to rely on to ensure your safety! It will cause significant download traffic if used in continuous mode (more than 1 GB per day are possible). The device needs to keep all alerts for Germany in memory at all times to comply with the requirements of the common alerting protocol (CAP), even if only one warn cell is monitored. Depending on the weather activity this requires noticeable amounts of memory and CPU.

This module requires the additional Perl module XML::LibXML for weather alerts. It can be installed depending on your OS and your preferences (e.g. sudo apt-get install libxml-libxml-perl or using CPAN).

Data is fetched from the DWD Open Data Server using the FHEM module HttpUtils. If you use a proxy for internet access you need to set the global attribute proxy to a suitable value in the format myProxyHost:myProxyPort.

Verify that your FHEM time is correct by entering {localtime()} into the FHEM command line. If not, check the system time and timezone of your FHEM server and adjust appropriately. It may be necessary to add export TZ=`cat /etc/timezone` or something similar to your FHEM start script /etc/init.d/fhem or your system configuration file /etc/profile. If /etc/timezone does not exists or is undefined execute tzselect to find your timezone and write the result into this file. After making changes restart FHEM and enter {$ENV{TZ}} into the FHEM command line to verify. To fix the timezone temporarily without restarting FHEM enter {$ENV{TZ}='Europe/Berlin'} or something similar into the FHEM command line. Again use tzselect to fine a valid timezone name.

The weekday of the forecast will be in the language of your FHEM system. Enter {$ENV{LANG}} into the FHEM command line to verify. If nothing is displayed or you see an unexpected language setting, add export LANG=de_DE.UTF-8 or something similar to your FHEM start script, restart FHEM and check again. If you get a locale warning when starting FHEM the required language pack might be missing. It can be installed depending on your OS and your preferences (e.g. dpkg-reconfigure locales, apt-get install language-pack-de or something similar).

The digits in a warncell id of a communeunion or a district are mostly identical to an Amtliche Gemeindekennziffer if you strip of the 1st digit from the warncell id. You can lookup an Amtliche Gemeindekennziffer using the name of a communeunion or district e.g. at Statistische Ämter des Bundes und der Länder. Then add 8 for a communeunion or 1 or 9 for a district at the beginning and try to find an exact or near match in the Warncell-IDs for CAP alerts catalogue. This approach is an alternative to guessing the right warncell id by the name of a communeunion or district.

Like some other Perl modules this module temporarily modifies the TZ environment variable for timezone conversions. This may cause unexpected results in multi threaded environments.

The forecast reading names do not contain absolute days or hours to keep them independent of summertime adjustments. Forecast days are counted relative to "today" of the timezone defined by the attribute of the same name or the timezone specified by the Perl TZ environment variable if undefined.

Starting on 17.09.2018 the forecast data is no longer available in CSV format and is based on the KML format instead. While most of the properties of the CSV format are still available in KML format, their names have changed and you will have to adjust your existing installation accordingly.

Define

define <name> DWD_OpenData

Get

get forecast [<station code>]
Fetch forecast for a station from DWD and update readings. The station code is either a 5 digit WMO station code or an alphanumeric DWD station code from the MOSMIX station catalogue. If the attribute forecastStation is set, no station code must be provided.
The operation is performed non-blocking.

get alerts [<warncell id>]
Set alert readings for given warncell id. A warncell id is a 9 digit numeric value from the Warncell-IDs for CAP alerts catalogue. Supported ids start with 8 (communeunion), 1 and 9 (district) or 5 (coast). If the attribute alertArea is set, no warncell id must be provided.
If the alerts cache is empty or older than 15 minutes the cache is updated first and the operation is non-blocking. If the cache is valid the operation is blocking. If a cache update is already in progress the operation fails.
To verify that alerts are provided for the warncell id you selected you should consult another source, wait for an alert situation and compare.

get updateAlertsCache { communeUnions|districts|all }
Fetch alerts to update the alerts cache. Note that 'coast' alerts are part of the 'communeUnion' cache data.
The operation is performed non-blocking because it typically requires several seconds. If a cache update is already in progress the operation fails.
This command can be used before querying several warncells in sequence or to force a higher update frequency than the built-in 15 minutes. Note that all DWD_OpenData devices share a single alerts cache so updating the cache via one of the devices is sufficient.

Attributes

disable {0|1}, default: 0
Disable fetching data.

timezone <tz>, default: OS dependent
IANA TZ string for date and time readings (e.g. "Europe/Berlin"), can be used to assume the perspective of a station that is in a different timezone or if your OS timezone settings do not match your local timezone. Alternatively you may use tzselect on the Linux command line to find a valid timezone string.

forecast

forecastStation <station code>, default: none
Setting forecastStation enables automatic updates every hour. The station code is either a 5 digit WMO station code or an alphanumeric DWD station code from the MOSMIX station catalogue.

forecastDays <n>, default: 6
Limits number of forecast days. Setting 0 will still provide forecast data for today. The maximum value is 9 (for today and 9 future days).

forecastResolution {3|6}, default: 6 h
Time resolution (number of hours between 2 samples).

forecastProperties [<p1>[,<p2>]...] , default: Tx, Tn, Tg, TTT, DD, FX1, Neff, RR6c, RRhc, Rh00, ww
A list of the properties available can be found here. If you remove a property from the list existing readings must be deleted manually in continuous mode.
Note: Not all properties are available for all stations and for all hours.

forecastWW2Text {0|1}, default: 0
Create additional wwd readings containing the weather code as a descriptive text in German language.

alert

alertArea <warncell id>, default: none
Setting alertArea enables automatic updates of the alerts cache every 15 minutes. A warncell id is a 9 digit numeric value from the Warncell-IDs for CAP alerts catalogue. Supported ids start with 8 (communeunion), 1 and 9 (district) or 5 (coast). To verify that alerts are provided for the warncell id you selected you should consult another source, wait for an alert situation and compare.
alertLanguage [DE|EN], default: DE
Language of descriptive alert properties..

Readings

forecast

fc<day>_[<sample>_]<property>

here

day - relative day (0 .. 9) based on the timezone attribute where 0 is today

sample - relative time (0 .. 3 or 7) equivalent to multiples of 6 or 3 hours UTC depending on the forecastHours attribute

day properties (typically for 06:00 station time, see raw data of station for time relation)
- date - date based on the timezone attribute
- weekday - abbreviated weekday based on the timezone attribute in the language of your FHEM system
- Tn [°C] - minimum temperature of previous 24 hours
- Tx [°C] - maximum temperature of previous 24 hours (typically for 18:00 station time)
- Tm [°C] - average temperature of previous 24 hours
- Tg [°C] - minimum temperature 5 cm above ground of previous 24 hours
- PEvap [kg/m2] - evapotranspiration of previous 24 hours
- SunD [s] - total sunshine duration of previous 24 hours

hour properties
- time - hour based the timezone attribute
- TTT [°C] - dry bulb temperature at 2 meter above ground
- Td [°C] - dew point temperature at 2 meter above ground
- DD [°] - average wind direction 10 m above ground
- FF [km/h] - average wind speed 10 m above ground
- FX1 [km/h] - maximum wind speed in the last hour
- RR6c [kg/m2] - precipitation amount in the last 6 hours
- R600 [%] - probability of rain in the last 6 hours
- RRhc [kg/m2] - precipitation amount in the last 12 hours
- Rh00 [%] - probability of rain in the last 12 hours
- RRdc [kg/m2] - precipitation amount in the last 24 hours
- Rd00 [%] - probability of rain in the last 24 hours
- ww - weather code (see WMO 4680/4677, SYNOP)
- wwd - German weather code description
- VV [m] - horizontal visibility
- Neff [%] - effective cloud cover
- Nl [%] - lower level cloud cover below 2000 m
- Nm [%] - medium level cloud cover below 7000 m
- Nh [%] - high level cloud cover obove 7000 m
- PPPP [hPa] - pressure equivalent at sea level

fc_station - forecast station code (WMO or DWD)
fc_description - station description
fc_coordinates - world coordinat and height of station
fc_time - time the forecast updated was downloaded based on the timezone attribute
fc_copyright - legal information, must be displayed with forecast data, see DWD usage conditions

alert

a_<index>_<property>

index - alert index, starting with 0, total a_count, ordered by onset

alert properties
- category - 'Met' or 'Health'
- event - numeric event code, see DWD documentation for details
- eventDesc - short event description in selected language
- eventGroup - event group, see DWD documentation for details
- responseType - 'None' = no instructions, 'Prepare' = instructions, 'AllClear' = alert cleared
- urgency - 'Immediate' = warning or 'Future' = information
- severity - 'Minor', 'Moderate', 'Severe' or 'Extreme'
- areaColor - RGB colour depending on urgency and severity, comma separated decimal triple
- onset - start time of alert based on the timezone attribute
- expires - end time of alert based on the timezone attribute
- headline - headline in selected language, typically a combination of the properties urgency and event
- description - description of the alert in selected language
- instruction - safety instructions in selected language
- area - numeric warncell id
- areaDesc - description of area, e.g. 'Stadt Berlin'
- altitude - min. altitude [m]
- ceiling - max. altitude [m]

a_time - time the last alert update was downloaded based on the timezone attribute
a_count - number of alerts available for selected warncell id
a_copyright - legal information, must be displayed with forecast data, see DWD usage conditions, not available if count is zero

CAP DWS Profile

Dashboard

[EN DE]

Define

define <name> Dashboard

define anyViews Dashboard

Bestpractice beginner configuration


	define anyViews Dashboard

	attr anyViews dashboard_colcount 2

	attr anyviews dashboard_rowcentercolwidth 30,70

	attr anyViews dashboard_tab1groups <Group1>,<Group2>,<Group3>

Set

set <name> lock

set <name> unlock

Get

N/A

Attributes

dashboard_tabcount
Returns the number of displayed tabs. (Does not need to be set any more. It is read automatically from the configured tabs) Default: 1

dashboard_activetab
Specifies which tab is activated. Can be set manually, but is also set by the switch "Set" to the currently active tab. Default: 1

dashboard_tabXname
Title of Tab at position X.

dashboard_tabXsorting
Contains the position of each group in Tab X. Value is written by the "Set" button. It is not recommended to take manual changes.

dashboard_row
To select which rows are displayed. top only; center only; bottom only; top and center; center and bottom; top,center and bottom.
Default: center

dashboard_width
To determine the Dashboardwidth. The value can be specified, or an absolute width value (eg 1200) in pixels in% (eg 80%).
Default: 100%

dashboard_rowcenterheight
Height of the center row in which the groups may be positioned.
Default: 400

dashboard_rowcentercolwidth
About this attribute, the width of each column of the middle Dashboardrow can be set. It can be stored for each column a separate value. The values must be separated by a comma (no spaces). Each value determines the column width in%! The first value specifies the width of the first column, the second value of the width of the second column, etc. Is the sum of the width greater than 100 it is reduced. If more columns defined as widths the missing widths are determined by the difference to 100. However, are less columns are defined as the values of ignores the excess values.
Default: 100

dashboard_rowtopheight
Height of the top row in which the groups may be positioned.
Default: 250

"dashboard_rowbottomheight
Height of the bottom row in which the groups may be positioned.
Default: 250

dashboard_tabXgroups
Comma-separated list of the names of the groups to be displayed in Tab X.
Each group can be given an icon for this purpose the group name, the following must be completed ":<icon>@<color>"
Example: Light:Icon_Fisch@blue,AVIcon_Fisch@red,Single Lights:Icon_Fisch@yellow
Additionally a group can contain a regular expression to show all groups matching a criteria. Example: .*Light.* to show all groups that contain the string "Light"

dashboard_tabXdevices
devspec list of devices that should appear in the tab. The format is:
GROUPNAME:devspec1,devspec2,...,devspecN:ICONNAME
THe icon name is optional. Also the group name is optional. In case of missing group name, the matching devices are not grouped but shown as separate widgets without titles. For further details on the devspec format see:
Dev-Spec

dashboard_tabXicon
Set the icon for a Tab. There must exist an icon with the name ico.(png|svg) in the modpath directory. If the image is referencing an SVG icon, then you can use the @colorname suffix to color the image.

dashboard_colcount
Number of columns in which the groups can be displayed. Nevertheless, it is possible to have multiple groups
to be positioned in a column next to each other. This is depend on the width of columns and groups.
Default: 1

dashboard_tabXcolcount
Number of columns for a specific tab in which the groups can be displayed. Nevertheless, it is possible to have multiple groups
to be positioned in a column next to each other. This depends on the width of columns and groups.
Default:

dashboard_tabXbackgroundimage
Shows a background image for the X tab. The image is not stretched in any way, it should therefore match the tab size or extend it. Standard:

dashboard_flexible
If set to a value > 0, the widgets are not positioned in columns any more but can be moved freely to any position in the tab.
The value for this parameter also defines the grid, in which the position "snaps in". Default: 0

dashboard_showfullsize
Hide FHEMWEB Roomliste (complete left side) and Page Header if Value is 1.
Default: 0

dashboard_showtabs
Displays the Tabs/Buttonbar on top or bottom, or hides them. If the Buttonbar is hidden lockstate is "lock" is used.
Default: tabs-and-buttonbar-at-the-top

dashboard_showtogglebuttons
Displays a Toogle Button on each Group do collapse.
Default: 0

dashboard_backgroundimage
Displays a background image for the complete dashboard. The image is not stretched in any way so the size should match/extend the dashboard height/width. Default:

dashboard_debug
Show Hiddenfields. Only for Maintainer's use.
Default: 0

DbLog

[EN DE]

Prereqisites

DBI

DBD::<dbtype>

cpan -i <module>

DBI	: `sudo apt-get install libdbi-perl`
MySQL	: `sudo apt-get install [mysql-server] mysql-client libdbd-mysql libdbd-mysql-perl` (mysql-server only if you use a local MySQL-server installation)
SQLite	: `sudo apt-get install sqlite3 libdbi-perl libdbd-sqlite3-perl`
PostgreSQL	: `sudo apt-get install libdbd-pg-perl`

Preparations

SVN -> contrib/dblog/db_create_<DBType>.sql

Caution:

current

history

SVN -> contrib/dblog/db_create_<DBType>.sql

current

history

TIMESTAMP	: timestamp of event, e.g. `2007-12-30 21:45:22`
DEVICE	: device name, e.g. `Wetterstation`
TYPE	: device type, e.g. `KS300`
EVENT	: event specification as full string, e.g. `humidity: 71 (%)`
READING	: name of reading extracted from event, e.g. `humidity`
VALUE	: actual reading extracted from event, e.g. `71`
UNIT	: unit extracted from event, e.g. `%`

create index

index "Search_Idx"

MySQL	: CREATE INDEX Search_Idx ON `fhem`.`history` (DEVICE, READING, TIMESTAMP);
SQLite	: CREATE INDEX Search_Idx ON `history` (DEVICE, READING, TIMESTAMP);
PostgreSQL	: `CREATE INDEX "Search_Idx" ON history USING btree (device, reading, "timestamp");`

configuration file

list

configuration file

    ####################################################################################
    # database configuration file     
    # 	
    # NOTE:
    # If you don't use a value for user / password please delete the leading hash mark
    # and write 'user => ""' respectively 'password => ""' instead !	
    #
    #
    ## for MySQL                                                      
    ####################################################################################
    #%dbconfig= (                                                    
    #    connection => "mysql:database=fhem;host=<database host>;port=3306",       
    #    user => "fhemuser",                                          
    #    password => "fhempassword",
    #    # optional enable(1) / disable(0) UTF-8 support (at least V 4.042 is necessary) 	
    #    utf8 => 1   
    #);                                                              
    ####################################################################################
    #                                                                
    ## for PostgreSQL                                                
    ####################################################################################
    #%dbconfig= (                                                   
    #    connection => "Pg:database=fhem;host=<database host>",        
    #    user => "fhemuser",                                     
    #    password => "fhempassword"                              
    #);                                                              
    ####################################################################################
    #                                                                
    ## for SQLite (username and password stay empty for SQLite)      
    ####################################################################################
    #%dbconfig= (                                                   
    #    connection => "SQLite:dbname=/opt/fhem/fhem.db",        
    #    user => "",                                             
    #    password => ""                                          
    #);                                                              
    ####################################################################################

Note about special characters:

Define

define <name> DbLog <configfilename> <regexp>

<configfilename>

configuration file

<regexp>

FileLog

Example:

define myDbLog DbLog /etc/fhem/db.conf .*:.*

configuration check

set <name> configCheck

yes

1

get myDbLog - - 2012-11-10 2012-11-10 KS300:temperature::

transfer FileLog-data to DbLog

here

Forumthread

Reporting and Management of DbLog database content

SVG

DbRep

Troubleshooting

Have the preparatory steps as described in commandref been done ? (install software components, create tables and index)
Was "set <name> configCheck" executed after definition and potential errors fixed or rather the hints implemented ?
If configDB is used ... has the database configuration file been imported into configDB (e.g. by "configDB fileimport ./db.conf") ?
When creating a SVG-plot and no drop-down list with proposed values appear -> set attribute "DbLogType" to "Current/History".

Set

Example:

set <name> addLog <devspec>:<Reading> [Value] [CN=<caller name>] [!useExcludes]

<devspec>:<Reading> - The device can be declared by a device specification (devspec). "Reading" will be evaluated as regular expression. If The reading isn't available and the value "Value" is specified, the reading will be added to database as new one if it isn't a regular expression and the readingname is valid.
Value - Optionally you can enter a "Value" that is used as reading value in the dataset. If the value isn't specified (default), the current value of the specified reading will be inserted into the database.
CN=<caller name> - By the key "CN=" (Caller Name) you can specify an additional string, e.g. the name of a calling device (for example an at- or notify-device). Via the function defined in attribute "valueFn" this key can be analyzed by the variable $CN. Thereby it is possible to control the behavior of the addLog dependend from the calling source.
!useExcludes - The function considers attribute "DbLogExclude" in the source device if it is set. If the optional keyword "!useExcludes" is set, the attribute "DbLogExclude" isn't considered.

Examples:

set <name> clearReadings

This function clears readings which were created by different DbLog-functions.

set <name> commitCache

set <name> configCheck

This command checks some important settings and give recommendations back to you if proposals are identified.

set <name> count

Count records in tables current and history and write results into readings countCurrent and countHistory.

set <name> countNbl

The non-blocking execution of "set <name> count".

set <name> deleteOldDays <n>

Delete records from history older than <n> days. Number of deleted records will be written into reading lastRowsDeleted.

set <name> deleteOldDaysNbl <n>

Note:

set <name> eraseReadings

This function deletes all readings except reading "state".

set <name> exportCache [nopurge | purgecache]

set <name> importCachefile <file>

set <name> listCache

If DbLog is set to asynchronous mode (attribute asyncMode=1), you can use that command to list the events are cached in memory.

set <name> purgeCache

set <name> reduceLog <no>[:<nn>] [average[=day]] [exclude=device1:reading1,device2:reading2,...]

SQL-Wildcards "%" and "_"

Example:

CAUTION:

blocked completely

set <name> reduceLogNbl <no>[:<nn>] [average[=day]] [exclude=device1:reading1,device2:reading2,...]

Note:

set <name> reopen [n]

set <name> rereadcfg

set <name> userCommand <validSqlStatement>

DO NOT USE THIS COMMAND UNLESS YOU REALLY (REALLY!) KNOW WHAT YOU ARE DOING!!!

DbRep

Get

get <name> ReadingsVal <device> <reading> <default>

get <name> ReadingsTimestamp <device> <reading> <default>

get <name> <infile> <outfile> <from>
          <to> <column_spec>

<in>
A dummy parameter for FileLog compatibility. Sessing by defaultto -
- current: reading actual readings from table "current"
- history: reading history readings from table "history"
- -: identical to "history"
<out>
A dummy parameter for FileLog compatibility. Setting by default to - to check the output for plot-computing.
Set it to the special keyword all to get all columns from Database.
- ALL: get all colums from table, including a header
- Array: get the columns as array of hashes
- INT: internally used by generating plots
- -: default
<from> / <to>
Used to select the data. Please use the following timeformat or an initial substring of it:
<column_spec>
For each column_spec return a set of data separated by a comment line on the current connection.
Syntax: <device>:<reading>:<default>:<fn>:<regexp>
- <device>
  The name of the device. Case sensitive. Using a the joker "%" is supported.
- <reading>
  The reading of the given device to select. Case sensitive. Using a the joker "%" is supported.
- <default>
  no implemented yet
- <fn> One of the following:
  - int
    Extract the integer at the beginning of the string. Used e.g. for constructs like 10%
  - int<digit>
    Extract the decimal digits including negative character and decimal point at the beginning og the string. Used e.g. for constructs like 15.7°C
  - delta-h / delta-d
    Return the delta of the values for a given hour or a given day. Used if the column contains a counter, as is the case for the KS300 rain column.
  - delta-ts
    Replaced the original value with a measured value of seconds since the last and the actual logentry.
- <regexp>
  The string is evaluated as a perl expression. The regexp is executed before <fn> parameter.
  Note: The string/perl expression cannot contain spaces, as the part after the space will be considered as the next column_spec.
  Keywords
- $val is the current value returned from the Database.
- $ts is the current timestamp returned from the Database.
- This Logentry will not print out if $val contains th keyword "hide".
- This Logentry will not print out and not used in the following processing if $val contains th keyword "ignore".

get myDbLog - - 2012-11-10 2012-11-20 KS300:temperature
get myDbLog current ALL - - %:temperature

get myDbLog - - 2012-11-10_10 2012-11-10_20 KS300:temperature::int1
like from 10am until 08pm at 10.11.2012
get myDbLog - all 2012-11-10 2012-11-20 KS300:temperature
get myDbLog - - 2012-11-10 2012-11-20 KS300:temperature KS300:rain::delta-h KS300:rain::delta-d
get myDbLog - - 2012-11-10 2012-11-20 MyFS20:data:::$val=~s/(on|off).*/$1eq"on"?1:0/eg
return 1 for all occurance of on* (on|on-for-timer etc) and 0 for all off*
get myDbLog - - 2012-11-10 2012-11-20 Bodenfeuchte:data:::$val=~s/.*B:\s([-\.\d]+).*/$1/eg
Example of OWAD: value like this: "A: 49.527 % B: 66.647 % C: 9.797 % D: 0.097 V"
and output for port B is like this: 2012-11-20_10:23:54 66.647
get DbLog - - 2013-05-26 2013-05-28 Pumpe:data::delta-ts:$val=~s/on/hide/
Setting up a "Counter of Uptime". The function delta-ts gets the seconds between the last and the actual logentry. The keyword "hide" will hide the logentry of "on" because this time is a "counter of Downtime"

Get

get <name> <infile> <outfile> <from>
          <to> <device> <querytype> <xaxis> <yaxis> <savename>

<name>
The name of the defined DbLog, like it is given in fhem.cfg.
<in>
A dummy parameter for FileLog compatibility. Always set to -
<out>
A dummy parameter for FileLog compatibility. Set it to webchart to use the charting related get function.
<from> / <to>
Used to select the data. Please use the following timeformat:
<device>
A string which represents the device to query.
<querytype>
A string which represents the method the query should use. Actually supported values are:
getreadings to retrieve the possible readings for a given device
getdevices to retrieve all available devices
timerange to retrieve charting data, which requires a given xaxis, yaxis, device, to and from
savechart to save a chart configuration in the database. Requires a given xaxis, yaxis, device, to and from, and a 'savename' used to save the chart
deletechart to delete a saved chart. Requires a given id which was set on save of the chart
getcharts to get a list of all saved charts.
getTableData to get jsonformatted data from the database. Uses paging Parameters like start and limit.
hourstats to get statistics for a given value (yaxis) for an hour.
daystats to get statistics for a given value (yaxis) for a day.
weekstats to get statistics for a given value (yaxis) for a week.
monthstats to get statistics for a given value (yaxis) for a month.
yearstats to get statistics for a given value (yaxis) for a year.
<xaxis>
A string which represents the xaxis
<yaxis>
A string which represents the yaxis
<savename>
A string which represents the name a chart will be saved with
<chartconfig>
A jsonstring which represents the chart to save
<pagingstart>
An integer used to determine the start for the sql used for query 'getTableData'
<paginglimit>
An integer used to set the limit for the sql used for query 'getTableData'

get logdb - webchart "" "" "" getcharts
Retrieves all saved charts from the Database
get logdb - webchart "" "" "" getdevices
Retrieves all available devices from the Database
get logdb - webchart "" "" ESA2000_LED_011e getreadings
Retrieves all available Readings for a given device from the Database
get logdb - webchart 2013-02-11_00:00:00 2013-02-12_00:00:00 ESA2000_LED_011e timerange TIMESTAMP day_kwh
Retrieves charting data, which requires a given xaxis, yaxis, device, to and from
Will ouput a JSON like this: [{'TIMESTAMP':'2013-02-11 00:10:10','VALUE':'0.22431388090756'},{'TIMESTAMP'.....}]
get logdb - webchart 2013-02-11_00:00:00 2013-02-12_00:00:00 ESA2000_LED_011e savechart TIMESTAMP day_kwh tageskwh
Will save a chart in the database with the given name and the chart configuration parameters
get logdb - webchart "" "" "" deletechart "" "" 7
Will delete a chart from the database with the given id

Attributes

addStateEvent

attr <device> addStateEvent [0|1]

asyncMode

attr <device> asyncMode [1|0]

commitMode

attr <device> commitMode [basic_ta:on | basic_ta:off | ac:on_ta:on | ac:on_ta:off | ac:off_ta:on]

basic_ta:on - autocommit server basic setting / transaktion on (default)
basic_ta:off - autocommit server basic setting / transaktion off
ac:on_ta:on - autocommit on / transaktion on
ac:on_ta:off - autocommit on / transaktion off
ac:off_ta:on - autocommit off / transaktion on (autocommit "off" set transaktion "on" implicitly)

cacheEvents

attr <device> cacheEvents [2|1|0]

cacheEvents=1: creates events of reading CacheUsage at point of time when a new dataset has been added to the cache.
cacheEvents=2: creates events of reading CacheUsage at point of time when in aychronous mode a new write cycle to the database starts. In that moment CacheUsage contains the number of datasets which will be written to the database.

cacheLimit


	   attr <device> cacheLimit <n>

colEvent


	   attr <device> colEvent <n>

Note:

colReading


	   attr <device> colReading <n>

Note:

colValue


	   attr <device> colValue <n>

Note:

DbLogType


	   attr <device> DbLogType [Current|History|Current/History]

history

Current	Events are only logged into the current-table. The entries of current-table will evaluated with SVG-creation.
History	Events are only logged into the history-table. No dropdown list with proposals will created with the SVG-creation.
Current/History	Events will be logged both the current- and the history-table. The entries of current-table will evaluated with SVG-creation.
SampleFill/History	Events are only logged into the history-table. The entries of current-table will evaluated with SVG-creation and can be filled up with a customizable extract of the history-table by using a DbRep-device command "set <DbRep-name> tableCurrentFillup" (advanced feature).

Note:

DbLogSelectionMode


	  attr <device> DbLogSelectionMode [Exclude|Include|Exclude/Include]

Exclude: DbLog behaves just as usual. This means everything specified in the regex in DEF will be logged by default and anything excluded via the DbLogExclude attribute will not be logged
Include: Nothing will be logged, except the readings specified via regex in the DbLogInclude attribute (in source devices). Neither the Regex set in DEF will be considered nor the device name of the source device itself.
Exclude/Include: Just almost the same as Exclude, but if the reading matches the DbLogExclude attribute, then it will further be checked against the regex in DbLogInclude whicht may possibly re-include the already excluded reading.

DbLogInclude


      attr <device> DbLogInclude regex:MinInterval,[regex:MinInterval] ...

Example

attr MyDevice1 DbLogInclude .*

attr MyDevice2 DbLogInclude state,(floorplantext|MyUserReading):300,battery:3600

DbLogExclude


      attr <device> DbLogExclude regex:MinInterval,[regex:MinInterval] ...

Example

attr MyDevice1 DbLogExclude .*

attr MyDevice2 DbLogExclude state,(floorplantext|MyUserReading):300,battery:3600

excludeDevs


	   attr <device> excludeDevs <devspec1>[#Reading],<devspec2>[#Reading],<devspec...>

device-specification

Examples


	   attr <device> excludeDevs global,Log.*,Cam.*,TYPE=DbLog


	   attr <device> excludeDevs .*#.*Wirkleistung.*


       attr <device> excludeDevs SMA_Energymeter#Bezug_WirkP_Zaehler_Diff

expimpdir


	   attr <device> expimpdir <directory>

"exportCache"

Example


	  attr <device> expimpdir /opt/fhem/cache/

exportCacheAppend


	   attr <device> exportCacheAppend [1|0]

noNotifyDev


	   attr <device> noNotifyDev [1|0]

noSupportPK


	   attr <device> noSupportPK [1|0]

syncEvents

attr <device> syncEvents [1|0]

shutdownWait

attr <device> shutdownWait

showproctime

attr <device> [1|0]

showNotifyTime

attr <device> showNotifyTime [1|0]

syncInterval

attr <device> syncInterval <n>

suppressAddLogV3

attr <device> suppressAddLogV3 [1|0]

suppressUndef


	  attr <device> ignoreUndef

Example

#DbLog eMeter:power:::$val=($val>1500)?undef:$val

timeout


	  attr <device> timeout

useCharfilter


	  attr <device> useCharfilter [0|1]

valueFn


	   attr <device> valueFn {}

Examples


	  attr <device> valueFn {if ($DEVICE eq "living_Clima" && $VALUE eq "off" ){$VALUE=0;} elsif ($DEVICE eq "e-power"){$VALUE= sprintf "%.1f", $VALUE;}}


	  attr <device> valueFn {if ($DEVICE eq "SMA_Energymeter" && $READING eq "state"){$IGNORE=1;}}


	  attr <device> valueFn {if ($DEVICE eq "Dum.Energy" && $READING eq "TotalConsumption"){$UNIT="W";}}

verbose4Devs


	   attr <device> verbose4Devs <device1>,<device2>,<device..>

Example


	  attr <device> verbose4Devs sys.*,.*5000.*,Cam.*,global

DbRep

[EN DE]

Selection of all datasets within adjustable time limits.
Exposure of datasets of a Device/Reading-combination within adjustable time limits.
Selection of datasets by usage of dynamically calclated time limits at execution time.
Highlighting doublets when select and display datasets (fetchrows)
Calculation of quantity of datasets of a Device/Reading-combination within adjustable time limits and several aggregations.
The calculation of summary-, difference-, maximum-, minimum- and averageValues of numeric readings within adjustable time limits and several aggregations.
write back results of summary-, difference-, maximum-, minimum- and average calculation into the database
The deletion of datasets. The containment of deletion can be done by Device and/or Reading as well as fix or dynamically calculated time limits at execution time.
export of datasets to file (CSV-format).
import of datasets from file (CSV-Format).
rename of device/readings in datasets
change of reading values in the database (changeValue)
automatic rename of device names in datasets and other DbRep-definitions after FHEM "rename" command (see DbRep-Agent)
Execution of arbitrary user specific SQL-commands (non-blocking)
Execution of arbitrary user specific SQL-commands (blocking) for usage in user own code (dbValue)
creation of backups of the database in running state non-blocking (MySQL, SQLite)
transfer dumpfiles to a FTP server after backup incl. version control
restore of SQLite- and MySQL-Dumps non-blocking
optimize the connected database (optimizeTables, vacuum)
report of existing database processes (MySQL)
purge content of current-table
fill up the current-table with a (tunable) extract of the history-table
delete consecutive datasets with different timestamp but same values (clearing up consecutive doublets)
Repair of a corrupted SQLite database ("database disk image is malformed")
transmission of datasets from source database into another (Standby) database (syncStandby)

Autorename

DbRep-Agent

UserExit

Modul 93_DbRep - Reporting and Management of database content (DbLog)

DbReadingsVal

DbReadingsVal("<name>","<device:reading>","<timestamp>","<default>")

Examples:

<name>	: name of the DbRep-Device to request
<device:reading>	: device:reading whose value is to deliver
<timestamp>	: timestamp of reading whose value is to deliver (*) in the form "YYYY-MM-DD hh:mm:ss"
<default>	: default value if no reading value can be retrieved

Preparations


  CREATE INDEX Report_Idx ON `history` (TIMESTAMP, READING) USING BTREE;

Definition


    define <name> DbRep <name of DbLog-instance>

Set

averageValue [display | writeToDB] - calculates the average value of database column "VALUE" between period given by timestamp-attributes which are set. The reading to evaluate must be specified by attribute "reading".
By attribute "averageCalcForm" the calculation variant for average determination will be configured. Is no or the option "display" specified, the results are only displayed. Using option "writeToDB" the calculated results are stored in the database with a new reading name.
The new readingname is built of a prefix and the original reading name, in which the original reading name can be replaced by the value of attribute "readingNameMap". The prefix is made up of the creation function and the aggregation.
The timestamp of the new stored readings is deviated from aggregation period, unless no unique point of time of the result can be determined. The field "EVENT" will be filled with "calculated".

cancelDump - stops a running database dump.

changeValue - changes the saved value of readings. If the selection is limited to particular device/reading-combinations by attribute "device" respectively "reading", it is considered as well as possibly defined time limits by time attributes (time.*).
If no limits are set, the whole database is scanned and the specified value will be changed.

Syntax:

<old string> : * a simple string with/without spaces, e.g. "OL 12"
               * a string with usage of SQL-wildcard, e.g. "%OL%"
                 
<new string> : * a simple string with/without spaces, e.g. "12 kWh"
               * Perl code embedded in "{}" with quotes, e.g. "{($VALUE,$UNIT) = split(" ",$VALUE)}". 
                 The perl expression the variables $VALUE and $UNIT are committed to. The variables are changable within
                 the perl code. The returned value of VALUE and UNIT are saved into the database field 
                 VALUE respectively UNIT of the dataset.

Examples:

device	: selection only of datasets which contain <device>
reading	: selection only of datasets which contain <reading>
time.*	: a number of attributes to limit selection by time
executeBeforeProc	: execute a FHEM command (or perl-routine) before start of changeValue
executeAfterProc	: execute a FHEM command (or perl-routine) after changeValue is finished

Note:

countEntries [history|current] - provides the number of table-entries (default: history) between period set by timestamp-attributes if set. If timestamp-attributes are not set, all entries of the table will be count. The attributes "device" and "reading" can be used to limit the evaluation.

delEntries - deletes all database entries or only the database entries specified by attributes Device and/or Reading and the entered time period between "timestamp_begin", "timestamp_end" (if set) or "timeDiffToNow/timeOlderThan".

from

until

between

older

from

allowDeletion	: unlock the delete function
device	: selection only of datasets which contain <device>
reading	: selection only of datasets which contain <reading>
time.*	: a number of attributes to limit selection by time
executeBeforeProc	: execute a FHEM command (or perl-routine) before start of delEntries
executeAfterProc	: execute a FHEM command (or perl-routine) after delEntries is finished

delSeqDoublets [adviceRemain | adviceDelete | delete] - show respectively delete identical sequentially datasets. Therefore Device,Reading and Value of the sequentially datasets are compared. Not deleted are the first und the last dataset of a aggregation period (e.g. hour,day,week and so on) as well as the datasets before or after a value change (database field VALUE).
The attributes to define the scope of aggregation,time period, device and reading are considered. If attribute aggregation is not set or set to "no", it will change to the default aggregation period "day". For datasets containing numerical values it is possible to determine a variance with attribute "seqDoubletsVariance". Up to this value consecutive numerical datasets are handled as identical and should be deleted.

adviceRemain	: simulates the remaining datasets in database after delete-operation (nothing will be deleted !)
adviceDelete	: simulates the datasets to delete in database (nothing will be deleted !)
delete	: deletes the consecutive doublets (see example)

Due to security reasons the attribute attribute "allowDeletion" needs to be set for execute the "delete" option.
The amount of datasets to show by commands "delSeqDoublets adviceDelete", "delSeqDoublets adviceRemain" is initially limited (default: 1000) and can be adjusted by attribute "limit". The adjustment of "limit" has no impact to the "delSeqDoublets delete" function, but affects ONLY the display of the data.
Before and after this "delSeqDoublets" it is possible to execute a FHEM command or Perl-script (please see attributes "executeBeforeProc" and "executeAfterProc").

Example

bold

2017-11-25_00-00-05__eg.az.fridge_Pwr__power 0

2017-11-25_01-08-21__eg.az.fridge_Pwr__power 0

2017-11-25_01-08-59__eg.az.fridge_Pwr__power 60.32

2017-11-25_01-11-21__eg.az.fridge_Pwr__power 56.26

2017-11-25_01-27-54__eg.az.fridge_Pwr__power 6.19

2017-11-25_01-28-51__eg.az.fridge_Pwr__power 0

2017-11-25_02-39-29__eg.az.fridge_Pwr__power 0

2017-11-25_02-41-18__eg.az.fridge_Pwr__power 105.28

2017-11-25_02-41-26__eg.az.fridge_Pwr__power 61.52

2017-11-25_03-00-06__eg.az.fridge_Pwr__power 47.46

2017-11-25_03-00-33__eg.az.fridge_Pwr__power 0

2017-11-25_23-40-10__eg.az.fridge_Pwr__power 0

2017-11-25_23-42-24__eg.az.fridge_Pwr__power 1

2017-11-25_23-45-27__eg.az.fridge_Pwr__power 1

2017-11-25_23-47-07__eg.az.fridge_Pwr__power 0

2017-11-25_23-48-15__eg.az.fridge_Pwr__power 0

2017-11-25_23-50-21__eg.az.fridge_Pwr__power 59.1

2017-11-25_23-55-14__eg.az.fridge_Pwr__power 52.31

2017-11-25_23-58-09__eg.az.fridge_Pwr__power 51.73

deviceRename - renames the device name of a device inside the connected database (Internal DATABASE). The devicename will allways be changed in the entire database. Possibly set time limits or restrictions by attributes device and/or reading will not be considered.
diffValue [display | writeToDB] - calculates the difference of database column "VALUE" between period given by attributes "timestamp_begin", "timestamp_end" or "timeDiffToNow / timeOlderThan". The reading to evaluate must be defined using attribute "reading". This function is mostly reasonable if readingvalues are increasing permanently and don't write value-differences to the database. The difference will be generated from the first available dataset (VALUE-Field) to the last available dataset between the specified time linits/aggregation, in which a balanced difference value of the previous aggregation period will be transfered to the following aggregation period in case this period contains a value.
An possible counter overrun (restart with value "0") will be considered (compare attribute "diffAccept").

If only one dataset will be found within the evalution period, the difference can be calculated only in combination with the balanced difference of the previous aggregation period. In this case a logical inaccuracy according the assignment of the difference to the particular aggregation period can be possible. Hence in warning in "state" will be placed and the reading "less_data_in_period" with a list of periods with only one dataset found in it will be created.
Is no or the option "display" specified, the results are only displayed. Using option "writeToDB" the calculation results are stored in the database with a new reading name.
The new readingname is built of a prefix and the original reading name, in which the original reading name can be replaced by the value of attribute "readingNameMap". The prefix is made up of the creation function and the aggregation.
The timestamp of the new stored readings is deviated from aggregation period, unless no unique point of time of the result can be determined. The field "EVENT" will be filled with "calculated".

dumpMySQL [clientSide | serverSide] - creates a dump of the connected MySQL database.
Depending from selected option the dump will be created on Client- or on Server-Side.
The variants differs each other concerning the executing system, the creating location, the usage of attributes, the function result and the needed hardware ressources.
The option "clientSide" e.g. needs more powerful FHEM-Server hardware, but saves all available tables inclusive possibly created views.
With attribute "dumpCompress" a compression of dump file after creation can be switched on.

Option clientSide

Note:
To avoid FHEM from blocking, you have to operate DbLog in asynchronous mode if the table optimization want to be used !

dumpComment	: User comment in head of dump file
dumpCompress	: compress of dump files after creation
dumpDirLocal	: the local destination directory for dump file creation
dumpMemlimit	: limits memory usage
dumpSpeed	: limits CPU utilization
dumpFilesKeep	: number of dump files to keep
executeBeforeProc	: execution of FHEM command (or perl-routine) before dump
executeAfterProc	: execution of FHEM command (or perl-routine) after dump
optimizeTablesBeforeDump	: table optimization before dump

naming convention of dump files

Option serverSide

CSV-formatted

Note:
To avoid FHEM from blocking, you have to operate DbLog in asynchronous mode if the table optimization want to be used !

dumpDirRemote	: destination directory of dump file on remote server
dumpCompress	: compress of dump files after creation
dumpDirLocal	: the local mounted directory dumpDirRemote
dumpFilesKeep	: number of dump files to keep
executeBeforeProc	: execution of FHEM command (or perl-routine) before dump
executeAfterProc	: execution of FHEM command (or perl-routine) after dump
optimizeTablesBeforeDump	: table optimization before dump

Note:

Example:

naming convention of dump files

FTP-Transfer after Dump

ftpUse	: FTP Transfer after dump will be switched on (without SSL encoding)
ftpUser	: User for FTP-server login, default: anonymous
ftpUseSSL	: FTP Transfer with SSL encoding after dump
ftpDebug	: debugging of FTP communication for diagnostics
ftpDir	: directory on FTP-server in which the file will be send into (default: "/")
ftpDumpFilesKeep	: leave the number of dump files in FTP-destination <ftpDir> (default: 3)
ftpPassive	: set if passive FTP is to be used
ftpPort	: FTP-Port, default: 21
ftpPwd	: password of FTP-User, not set by default
ftpServer	: name or IP-address of FTP-server. absolutely essential !
ftpTimeout	: timeout of FTP-connection in seconds (default: 30).

dumpSQLite - creates a dump of the connected SQLite database.
This function uses the SQLite Online Backup API and allow to create a consistent backup of the database during the normal operation. The dump will be saved in FHEM log-directory by default. The target directory can be defined by attribute "dumpDirLocal" and has to be writable by the FHEM process.
Before executing the dump a table optimization can be processed optionally (see attribute "optimizeTablesBeforeDump").

Note:
To avoid FHEM from blocking, you have to operate DbLog in asynchronous mode if the table optimization want to be used !

Before and after the dump a FHEM-command can be executed (see attribute "executeBeforeProc", "executeAfterProc").

The attributes relevant for function "dumpMySQL serverSide" are:

dumpCompress	: compress of dump files after creation
dumpDirLocal	: the local mounted directory dumpDirRemote
dumpFilesKeep	: number of dump files to keep
executeBeforeProc	: execution of FHEM command (or perl-routine) before dump
executeAfterProc	: execution of FHEM command (or perl-routine) after dump
optimizeTablesBeforeDump	: table optimization before dump

After a successfull finished dump the old dumpfiles are deleted and only the number of attribute "dumpFilesKeep" (default: 3) remain in the target directory "dumpDirLocal". If "dumpFilesKeep = 0" is set, all dumpfiles (also the current created file), are deleted. This setting can be helpful, if FTP transmission is used and the created dumps are only keep remain in the FTP destination directory.

The naming convention of dump files is: <dbname>_<date>_<time>.sqlitebkp[.gzip]

The database can be restored by command "set <name> restoreSQLite <filename>"
The created dump file can be transfered to a FTP-server. Please see explanations about FTP- transfer in topic "dumpMySQL".

eraseReadings - deletes all created readings in the device, except reading "state" and readings, which are contained in exception list defined by attribute "readingPreventFromDel".

exportToFile [<file>] - exports DB-entries to a file in CSV-format of time period specified by time attributes.
Limitation of selections can be done by attributes device and/or reading. The filename can be defined by attribute "expimpfile".
Optionally a file can be specified as a command option (/path/file) and overloads a possibly defined attribute "expimpfile". The filename may contain wildcards as described in attribute section of "expimpfile".
By setting attribute "aggregation" the export of datasets will be splitted into time slices corresponding to the specified aggregation. If, for example, "aggregation = month" is set, the data are selected in monthly packets and written into the exportfile. Thereby the usage of main memory is optimized if very large amount of data is exported and avoid the "died prematurely" error.

The attributes relevant for this function are:

aggregation	: determination of selection time slices
device	: select only datasets which are contain <device>
reading	: select only datasets which are contain <reading>
executeBeforeProc	: execution of FHEM command (or perl-routine) before export
executeAfterProc	: execution of FHEM command (or perl-routine) after export
expimpfile	: the name of exportfile
time.*	: a number of attributes to limit selection by time

fetchrows [history|current] - provides all table entries (default: history) of time period set by time attributes respectively selection conditions by attributes "device" and "reading". An aggregation set will not be considered.
The direction of data selection can be determined by attribute "fetchRoute".

Every reading of result is composed of the dataset timestring , an index, the device name and the reading name. The function has the capability to reconize multiple occuring datasets (doublets). Such doublets are marked by an index > 1.
Doublets can be highlighted in terms of color by setting attribut e"fetchMarkDuplicates".

Note:
Highlighted readings are not displayed again after restart or rereadcfg because of they are not saved in statefile.

This attribute is preallocated with some colors, but can be changed by colorpicker-widget:


                                 attr <DbRep-Device> widgetOverride fetchMarkDuplicates:colorpicker

The readings of result are composed like the following sceme:

Example:

For a better overview the relevant attributes are listed here in a table:

fetchRoute	: direction of selection read in database
limit	: limits the number of datasets to select and display
fetchMarkDuplicates	: Highlighting of found doublets
device	: select only datasets which are contain <device>
reading	: select only datasets which are contain <reading>
time.*	: A number of attributes to limit selection by time
valueFilter	: filter datasets of database field "VALUE" by a regular expression

Note:
Although the module is designed non-blocking, a huge number of selection result (huge number of rows) can overwhelm the browser session respectively FHEMWEB. Due to the sample space can be limited by attribute "limit". Of course ths attribute can be increased if your system capabilities allow a higher workload.

insert - use it to insert data ito table "history" manually. Input values for Date, Time and Value are mandatory. The database fields for Type and Event will be filled in with "manual" automatically and the values of Device, Reading will be get from set attributes.

importFromFile [<file>] - imports data in CSV format from file into database.
The filename can be defined by attribute "expimpfile".
Optionally a file can be specified as a command option (/path/file) and overloads a possibly defined attribute "expimpfile". The filename may contain wildcards as described in attribute section of "expimpfile".

dataset format:

Example for a source dataset:

executeBeforeProc	: execution of FHEM command (or perl-routine) before import
executeAfterProc	: execution of FHEM command (or perl-routine) after import
expimpfile	: the name of exportfile

maxValue [display | writeToDB] - calculates the maximum value of database column "VALUE" between period given by attributes "timestamp_begin", "timestamp_end" or "timeDiffToNow / timeOlderThan". The reading to evaluate must be defined using attribute "reading". The evaluation contains the timestamp of the last appearing of the identified maximum value within the given period.
Is no or the option "display" specified, the results are only displayed. Using option "writeToDB" the calculated results are stored in the database with a new reading name.
The new readingname is built of a prefix and the original reading name, in which the original reading name can be replaced by the value of attribute "readingNameMap". The prefix is made up of the creation function and the aggregation.
The timestamp of the new stored readings is deviated from aggregation period, unless no unique point of time of the result can be determined. The field "EVENT" will be filled with "calculated".

minValue [display | writeToDB] - calculates the minimum value of database column "VALUE" between period given by attributes "timestamp_begin", "timestamp_end" or "timeDiffToNow / timeOlderThan". The reading to evaluate must be defined using attribute "reading". The evaluation contains the timestamp of the first appearing of the identified minimum value within the given period.
Is no or the option "display" specified, the results are only displayed. Using option "writeToDB" the calculated results are stored in the database with a new reading name.
The new readingname is built of a prefix and the original reading name, in which the original reading name can be replaced by the value of attribute "readingNameMap". The prefix is made up of the creation function and the aggregation.
The timestamp of the new stored readings is deviated from aggregation period, unless no unique point of time of the result can be determined. The field "EVENT" will be filled with "calculated".

optimizeTables - optimize tables in the connected database (MySQL).
Before and after an optimization it is possible to execute a FHEM command. (please see attributes "executeBeforeProc", "executeAfterProc")
readingRename - renames the reading name of a device inside the connected database (see Internal DATABASE). The readingname will allways be changed in the entire database. Possibly set time limits or restrictions by attributes device and/or reading will not be considered.
repairSQLite - repairs a corrupted SQLite database.
A corruption is usally existent when the error message "database disk image is malformed" appears in reading "state" of the connected DbLog-device. If the command was started, the connected DbLog-device will firstly disconnected from the database for 10 hours (36000 seconds) automatically (breakup time). After the repair is finished, the DbLog-device will be connected to the (repaired) database immediately.
As an argument the command can be completed by a differing breakup time (in seconds).
The corrupted database is saved as <database>.corrupt in same directory.
restoreMySQL <File> - restore a database from serverSide- or clientSide-Dump.
The function provides a drop-down-list of files which can be used for restore.

Usage of serverSide-Dumps
The content of history-table will be restored from a serverSide-Dump. Therefore the remote directory "dumpDirRemote" of the MySQL-Server has to be mounted on the Client and make it usable to the DbRep-device by setting attribute "dumpDirLocal" to the appropriate value.
All files with extension "csv[.gzip]" and if the filename is beginning with the name of the connected database (see Internal DATABASE) are listed.

Usage of clientSide-Dumps
All tables and views (if present) are restored. The directory which contains the dump files has to be set by attribute "dumpDirLocal" to make it usable by the DbRep device.
All files with extension "sql[.gzip]" and if the filename is beginning with the name of the connected database (see Internal DATABASE) are listed.
The restore speed depends of the server variable "max_allowed_packet". You can change this variable in file my.cnf to adapt the speed. Please consider the need of sufficient ressources (especially RAM).

The database user needs rights for database management, e.g.:
CREATE, ALTER, INDEX, DROP, SHOW VIEW, CREATE VIEW

restoreSQLite <File>.sqlitebkp[.gzip] - restores a backup of SQLite database.
The function provides a drop-down-list of files which can be used for restore. The data stored in the current database are deleted respectively overwritten. All files with extension "sqlitebkp[.gzip]" and if the filename is beginning with the name of the connected database will are listed.

sqlCmd - executes an arbitrary user specific command.
If the command contains a operation to delete data, the attribute "allowDeletion" has to be set for security reason.
The statement doesn't consider limitations by attributes "device", "reading", "time.*" respectively "aggregation".
If the attribute "timestamp_begin" respectively "timestamp_end" is assumed in the statement, it is possible to use placeholder "§timestamp_begin§" respectively "§timestamp_end§" on suitable place.

If you want update a dataset, you have to add "TIMESTAMP=TIMESTAMP" to the update-statement to avoid changing the original timestamp.

Examples of SQL-statements:

set <name> sqlCmd select DEVICE, count(*) from history where TIMESTAMP >= "2017-01-06 00:00:00" group by DEVICE having count(*) > 800
set <name> sqlCmd select DEVICE, count(*) from history where TIMESTAMP >= "2017-05-06 00:00:00" group by DEVICE
set <name> sqlCmd select DEVICE, count(*) from history where TIMESTAMP >= §timestamp_begin§ group by DEVICE
set <name> sqlCmd select * from history where DEVICE like "Te%t" order by `TIMESTAMP` desc
set <name> sqlCmd select * from history where `TIMESTAMP` > "2017-05-09 18:03:00" order by `TIMESTAMP` desc
set <name> sqlCmd select * from current order by `TIMESTAMP` desc
set <name> sqlCmd select sum(VALUE) as 'Einspeisung am 04.05.2017', count(*) as 'Anzahl' FROM history where `READING` = "Einspeisung_WirkP_Zaehler_Diff" and TIMESTAMP between '2017-05-04' AND '2017-05-05'
set <name> sqlCmd delete from current
set <name> sqlCmd delete from history where TIMESTAMP < "2016-05-06 00:00:00"
set <name> sqlCmd update history set TIMESTAMP=TIMESTAMP,VALUE='Val' WHERE VALUE='TestValue'
set <name> sqlCmd select * from history where DEVICE = "Test"
set <name> sqlCmd insert into history (TIMESTAMP, DEVICE, TYPE, EVENT, READING, VALUE, UNIT) VALUES ('2017-05-09 17:00:14','Test','manuell','manuell','Tes§e','TestValue','°C')

Reading

allowDeletion	: activates capabilty to delete datasets
sqlResultFormat	: determines presentation style of command result
sqlResultFieldSep	: choice of a useful field separator for result
sqlCmdHistoryLength	: activates command history and length

Note:

sqlCmdHistory - If history is activated by attribute "sqlCmdHistoryLength", an already successfully executed sqlCmd-command can be repeated from a drop-down list.
By execution of the last list entry, "__purge_historylist__", the list itself can be deleted.
If the statement contains "," this character is displayed as "<c>" in the history list due to technical restrictions.

sqlSpecial - This function provides a drop-down list with a selection of prepared reportings.
The statements result is depicted in reading "SqlResult". The result can be formatted by attribute "sqlResultFormat", a well as the used field separator by attribute "sqlResultFieldSep".

The relevant attributes for this function are:

sqlResultFormat	: determines the formatting of the result
sqlResultFieldSep	: determines the used field separator in statement result

The following predefined reportings are selectable:

50mostFreqLogsLast2days	: reports the 50 most occuring log entries of the last 2 days
allDevCount	: all devices occuring in database and their quantity
allDevReadCount	: all device/reading combinations occuring in database and their quantity

sumValue [display | writeToDB] - calculates the summary of database column "VALUE" between period given by attributes "timestamp_begin", "timestamp_end" or "timeDiffToNow / timeOlderThan". The reading to evaluate must be defined using attribute "reading". Using this function is mostly reasonable if value-differences of readings are written to the database.
Is no or the option "display" specified, the results are only displayed. Using option "writeToDB" the calculation results are stored in the database with a new reading name.
The new readingname is built of a prefix and the original reading name, in which the original reading name can be replaced by the value of attribute "readingNameMap". The prefix is made up of the creation function and the aggregation.
The timestamp of the new stored readings is deviated from aggregation period, unless no unique point of time of the result can be determined. The field "EVENT" will be filled with "calculated".

syncStandby <DbLog-Device Standby> - datasets of the connected database (source) are transmitted into another database (Standby-database).
Here the "<DbLog-Device Standby>" is the DbLog-Device what is connected to the Standby-database.

All the datasets which are determined by timestamp-attributes or respectively the attributes "device", "reading" are transmitted.
The datasets are transmitted in time slices accordingly to the adjusted aggregation. If the attribute "aggregation" has value "no" or "month", the datasets are transmitted automatically in daily time slices into standby-database. Source- and Standby-database can be of different types.

The relevant attributes to control the syncStandby function are:

aggregation	: adjustment of time slices for data transmission (hour,day,week)
device	: transmit only datasets which are contain <device>
reading	: transmit only datasets which are contain <reading>
time.*	: A number of attributes to limit selection by time

tableCurrentFillup - the current-table will be filled u with an extract of the history-table. The attributes for limiting time and device, reading are considered. Thereby the content of the extract can be affected. In the associated DbLog-device the attribute "DbLogType" should be set to "SampleFill/History".

tableCurrentPurge - deletes the content of current-table. There are no limits, e.g. by attributes "timestamp_begin", "timestamp_end", device, reading and so on, considered.

vacuum - optimize tables in the connected database (SQLite, PostgreSQL).
Before and after an optimization it is possible to execute a FHEM command. (please see attributes "executeBeforeProc", "executeAfterProc")

For all evaluation variants (except sqlCmd,deviceRename,readingRename) applies:

Note:

Get