1. Select a name for the icon (in this example MyIcon)
2. Create three png icons with transparent backgrounds:
   • A 48x48 pixel ON image named "MyIcon48_ON.png"
   • A 48x48 pixel OFF image named "MyIcon48_OFF.png"
   • A 16x16 pixel ON image named "MyIcon.png"
   The 16x16 image is used on floor plans, the 48x48 images are used on device panels in the Web interface.
3. Upload the three files to ~/domoticz/www/images on the Domoticz server.
4. Add a line at the end of the ~domoticz/www/switch_icons.txt file. It should contain three fields separated by a semi-colon ";"
     MyIcon;My icon;This is my icon
   The first field is the name of the icon (step 1).
   The second field is the bold caption shown in the list of icons
   The third field is the additional grey text shown in the list

1. For each switch select a name for the icon (in this example MyIcon)
2. For each switch create three png icons with transparent backgrounds:
   • A 48x48 pixel ON image named "MyIcon48_ON.png"
   • A 48x48 pixel OFF image named "MyIcon48_OFF.png"
   • A 16x16 pixel ON image named "MyIcon.png"
   The 16x16 image is used on floor plans, the 48x48 images are used on device panels.
3. Create the icons.txt file
4. For each switch add a line in the icon.txt file. Each line must contain three fields separated by a semi-colon ";"
     MyIcon;My icon;This is my icon
   The first field is the name of the icon (step 1).
   The second field is the bold caption shown in the list of icons
   The third field is the additional grey text shown in the list
5. Add all files (3 x number of switches image files + 1 text file) to an archive

1. Setup tab
2. More Options
3. Custom Icons
4. Browse to the icon archive
5. Click Upload button

1. pi@raspberrrypi:~ $ wget https://github.com/flatsiedatsie/domoticz-aurora-theme/archive/master.zip
2. pi@raspberrrypi:~ $ unzip master.zip
3. pi@raspberrrypi:~ $ mkdir domoticz/www/styles/aurora
4. pi@raspberrrypi:~ $ cp -r domoticz-aurora-theme-master/* domoticz/www/styles/aurora
5. pi@raspberrrypi:~ $ rm -r domoticz-aurora-theme-master/
6. pi@raspberrrypi:~ $ mv master.zip downloads/domoticz-aurora-theme.zip
7. In domoticz: Setup/Settings/System/Theme: aurora
8. In domoticz: Apply Settings

1. Get idx of sensor: {sensor_idx}
2. Get host name or IP address of Domoticz server: {hostname_or_ip}
3. Get Domoticz TCP port: {port}
4. Send http request = http://{host_name_or_ip}:{port}/json.htm?type=setused&idx={sensor_idx}&name={new_label}&used=true

http://192.168.1.22:8080/json.htm?type=setused&idx=93&name=Today+is+Monday&used=true
http://192.168.1.22:8080/json.htm?type=setused&idx=93&name=Date:<span+style="float:+right;+font-weight:+bold">2019-10-31</span>&used=true

1. Install sqlite3 on desktop machine:

   $ sudo apt install sqlite3

2. Make a backup copy of the Domoticz database on the desktop computer. Do this from the Domoticz Web interface: SetupSettingsBackup/RestoreBackup Database. Keep track of where Domoticz.db was saved. Assume from now on that it was in /home/michel/temp alias ~/temp.
3. Make a backup of the backup just in case:

   $ cp temp/Domoticz.db temp/Domoticz.bak

4. Open the database in sqlite3

   $ sqlite3 temp/Domoticz.db
   SQLite version 3.22.0 2018-01-22 18:45:57
   Enter ".help" for usage hints.

5. Issue a few commands that will make the display clearer.

   sqlite> .header on
   sqlite> .mode column
   

6. Use the SELECT command to find the custom sensor data. This assumes that the custom sensor index number is 165.

   sqlite> SELECT * FROM Percentage WHERE [DeviceRowID] = 165;
   DeviceRowID  Percentage  Date
   -----------  ----------  -------------------
   165          5.0         2019-11-17 13:00:00
   165          5.0         2019-11-17 13:05:00
   ...

7. Delete all entries for the device from the Percentage table.

   sqlite> DELETE FROM Percentage WHERE [DeviceRowID] = 165;
   

8. Delete all entries for the decive from the Percentage_Calendar table.

   sqlite> DELETE FROM Percentage_Calendar WHERE [DeviceRowID] = 165;
   

9. Check that the entries were deleted.

   sqlite> SELECT * FROM Percentage WHERE [DeviceRowID] = 165;
   sqlite> SELECT * FROM Percentage_Calendar WHERE [DeviceRowID] = 165;
   

10. Quit sqlite3.

    sqlite> .quit
    

11. Restore the modified database from the Domoticz Web interface: SetupSettingsBackup/RestoreRestore Database.
12. If something is wrong, restore the backup database Domoticz.bak

http://192.168.1.22:8080/json.htm?type=command&param=clearscenelog&idx=8

http://<DOMOTICZ_IP>:<DOMOTICZ_PORT>/json.htm?type=command&param=clearlightlog&idx=<SWITCH_IDX>

http://192.168.1.22:8080/json.htm?type=command&param=clearlightlog&idx=12

http://<DOMOTICZ_IP>:<DOMOTICZ_PORT>/json.htm?type=command&param=clearlightlog&idx=<TEXT_IDX>

1. Open up Domoticz in your preferred web browser
2. Open up the device log screen for the device in question (in my case a Utility device)
3. With your mouse hover over the bad reading
4. Hold down SHIFT on your keyboard and left click the bad reading
5. A confirmation screen will appear, check the date/time and value is the bad value and hit OK

1. Make sure that the Domoticz user (usually pi) is a member of the sudo group.
   pi@raspberrypi:~ $ groups pi adm dialout cdrom sudo audio video plugdev games users input netdev gpio i2c spi
2. Add the following line after the similar line beginning with %sudo in /etc/sudoers
   pi ALL=(ALL:ALL) NOPASSWD: ALL
   with the visudo utility:
   pi@raspberrypi:~ $ visudo
3. Alternatively create the file
   pi@raspberrypi:~ $ visudo -f /etc/sudoers.d/pi-no-passwd
   containing that single line.

• the user is a member of the sudo group and if
• a password is not required for the user.

For example, the script script_time_domoticzAlive.lua with the following command

1. Click on the image with the right mouse button. Choose to save the image file in the context menu. The exact label of the menu choice will depend on the browser used.
2. wget "https://raw.githubusercontent.com/domoticz/domoticz/development/msbuild/domoticz.ico"
3. curl "https://raw.githubusercontent.com/domoticz/domoticz/development/msbuild/domoticz.ico" -o domoticz.ico

• An even bigger 400×400 pixels png image is available here.
• The ico file contains five images in the "usual" dimensions: 256×256, 128×128, 64×64, 32×32, and 16×16 pixels.
• If the domoticz.ico file is opened in GIMP all five images will be seen as superimposed. This is because each image is placed on a separate layer, but they are all visible. Each image can be exported as a .png, .jpeg or other format image file, by making its layer the only visible one and the use the File / Export As... (shortcut: ShiftCtrlS).
• One could also download the favicon.ico image from the running instance of Domoticz.

  wget http://<DOMOTICZ_IP>:<DOMOTICZ_PORT>/favicon.ico
  

  However that file contains only the 32×32 and 16×16 pixels images.

1. The repository can be cloned if git is installed on the computer. Use the address https://github.com/domoticz/domoticz.git
2. Click on the Download ZIP link in the pop-up window displayed when the <> Code v button is pressed.
3. Go to the latest release and download the Source code as a zip or tar.gz archive.

1. Click on the Setup tab
2. Click on More Options
3. Click on Plans
4. Click on TimerPlan (if nothing visible press F5)

1. Click on the Setup tab
2. Click on Settings
3. Click on Other
4. Select the desired plan in the Timer Plan: combo box.
5. Click on Apply Settings

1. Install sqlite3 on desktop machine:

   $ sudo apt install sqlite3

2. Make a backup copy of the Domoticz database on the desktop computer. Do this from the Domoticz Web interface: SetupSettingsBackup/RestoreBackup Database. Keep track of where Domoticz.db was saved. Assume from now on that it was in /home/michel/temp alias ~/temp.
3. Make a backup of the backup just in case:

   $ cp temp/Domoticz.db temp/Domoticz.bak

4. Open the database in sqlite3

   $ sqlite3 temp/Domoticz.db
      SQLite version 3.22.0 2018-01-22 18:45:57
      Enter ".help" for usage hints.

5. A list of errors can be displayed.

   sqlite> pragma integrity_check;
      *** in database main ***
      On tree page 116 cell 69: Rowid 13668 out of order
      On tree page 409 cell 26: 2nd reference to page 483
      ...
      row 50 missing from index ll_id_date_idx
      row 51 missing from index ll_id_date_idx

6. Dump the database.

   sqlite>  .output dump.sql
      sqlite>  .dump
      sqlite>  .exit

7. Using a text editor change the last line in ~/temp/dump.sql from
   ROLLBACK; -- due to errors
   to
   COMMIT;
8. Re-create the database.

   $ sqlite3 temp/fixed.db < temp/dump.sql

9. Test that the fixed database is ok.

$ sqlite3 temp/fixed.db
   sqlite> pragma integrity_check;
   ok

10. Quit sqlite3.

    sqlite> .quit

11. Restore the fixed database (~/temp/fixed.db) using the Domoticz Web interface: SetupSettingsBackup/RestoreRestore Database.
12. If something is wrong, restore the backup database Domoticz.bak

http://192.168.1.22:8080/json.htm?type=scenelog&idx=8

1. Create the unit file /etc/systemd/system/domoticz.service.
[Unit] Description=domoticz_service After=time-sync.target [Service] User=pi Group=users ExecStart=/home/pi/domoticz/domoticz -www 8080 -sslwww 443 WorkingDirectory=/home/pi/domoticz AmbientCapabilities=CAP_NET_BIND_SERVICE Restart=on-failure RestartSec=1m [Install] WantedBy=multi-user.target
2. Stop the Domoticz service
3. Delete the old init script /etc/init.d/domoticz.sh
4. Reload daemons
5. Start the Domoticz service
6. Enable the service for auto starting at boot.