[Tuto] Consomation d'eau ajout simple dans DomoticZ

[atlantis007]

voici les message d erreur que j ai

[code
sqlite> Error: near line 1: no such table: Meter_Calendar
...> Error: near line 2: no such table: Meter_Calendar
...> Error: near line 3: no such table: Meter_Calendar
...> Error: near line 4: no such table: Meter_Calendar
...> Error: near line 5: no such table: Meter_Calendar
...> Error: near line 6: no such table: Meter_Calendar
...> Error: near line 7: no such table: Meter_Calendar
...> Error: near line 8: no such table: Meter_Calendar
...> Error: near line 9: no such table: Meter_Calendar
...> Error: near line 10: no such table: Meter_Calendar
...> Error: near line 11: no such table: Meter_Calendar
...> Error: near line 12: no such table: Meter_Calendar
...> Error: near line 13: no such table: Meter_Calendar
...> Error: near line 14: no such table: Meter_Calendar
...> Error: near line 15: no such table: Meter_Calendar
...> Error: near line 16: no such table: Meter_Calendar
...> Error: near line 17: no such table: Meter_Calendar
...> Error: near line 18: no such table: Meter_Calendar
...> Error: near line 19: no such table: Meter_Calendar
...> Error: near line 20: no such table: Meter_Calendar
...> Error: near line 21: no such table: Meter_Calendar
...> Error: near line 22: no such table: Meter_Calendar
...> Error: near line 23: no such table: Meter_Calendar
...> Error: near line 24: no such table: Meter_Calendar
...> Error: near line 25: no such table: Meter_Calendar
...> Error: near line 26: no such table: Meter_Calendar
...> Error: near line 27: no such table: Meter_Calendar
...> Error: near line 28: no such table: Meter_Calendar
...> Error: near line 29: no such table: Meter_Calendar
...> Error: near line 30: no such table: Meter_Calendar
...> Error: near line 31: no such table: Meter_Calendar
...>
...> sqlite>
][/code]

[sirus]

OK c'est une erreur de ma part ici , il fallait taper :

- ouvrir la base de données avec sqlite3 :

Code : Tout sélectionner

root> sqlite3 /home/pi/domoticz/domoticz.db

ensuite exécuter le fichier sql manuellement :

Code : Tout sélectionner

sqlite> .read /home/pi/EAU/previous.generated.2015-08.sql

Ca devrai être mieux.
Colle la log ici.

A+

[atlantis007]

voici le log[code
# /home/pi/EAU/updateConsoEau.sh 2015 07

- PART 1 Get the data from website for 2015-07

/home/pi/EAU/2015-07.dat generated

- PART 2 Update .dat file

/home/pi/EAU/2015-07.dat Updated

- PART 3 Generate SQL
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-01'; INSE RT INTO `Meter_Calendar` VALUES ('888', '36.2', '470.497', '2015-07-01' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-02'; INSE RT INTO `Meter_Calendar` VALUES ('888', '34.9', '470.845', '2015-07-02' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-03'; INSE RT INTO `Meter_Calendar` VALUES ('888', '17.9', '471.024', '2015-07-03' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-04'; INSE RT INTO `Meter_Calendar` VALUES ('888', '34.2', '471.366', '2015-07-04' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-05'; INSE RT INTO `Meter_Calendar` VALUES ('888', '29.2', '471.658', '2015-07-05' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-06'; INSE RT INTO `Meter_Calendar` VALUES ('888', '36.1', '472.019', '2015-07-06' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-07'; INSE RT INTO `Meter_Calendar` VALUES ('888', '33.4', '472.353', '2015-07-07' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-08'; INSE RT INTO `Meter_Calendar` VALUES ('888', '47', '472.823', '2015-07-08' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-09'; INSE RT INTO `Meter_Calendar` VALUES ('888', '72', '473.543', '2015-07-09' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-10'; INSE RT INTO `Meter_Calendar` VALUES ('888', '72', '474.264', '2015-07-10' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-11'; INSE RT INTO `Meter_Calendar` VALUES ('888', '31.2', '474.576', '2015-07-11' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-12'; INSE RT INTO `Meter_Calendar` VALUES ('888', '31.9', '474.895', '2015-07-12' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-13'; INSE RT INTO `Meter_Calendar` VALUES ('888', '31.9', '475.215', '2015-07-13' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-14'; INSE RT INTO `Meter_Calendar` VALUES ('888', '31.1', '475.526', '2015-07-14' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-15'; INSE RT INTO `Meter_Calendar` VALUES ('888', '40.7', '475.934', '2015-07-15' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-16'; INSE RT INTO `Meter_Calendar` VALUES ('888', '32', '476.254', '2015-07-16' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-17'; INSE RT INTO `Meter_Calendar` VALUES ('888', '41.6', '476.67', '2015-07-17' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-18'; INSE RT INTO `Meter_Calendar` VALUES ('888', '27.6', '476.946', '2015-07-18' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-19'; INSE RT INTO `Meter_Calendar` VALUES ('888', '30.2', '477.248', '2015-07-19' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-20'; INSE RT INTO `Meter_Calendar` VALUES ('888', '57.5', '477.823', '2015-07-20' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-21'; INSE RT INTO `Meter_Calendar` VALUES ('888', '81.8', '478.642', '2015-07-21' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-22'; INSE RT INTO `Meter_Calendar` VALUES ('888', '25.9', '478.9', '2015-07-22' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-23'; INSE RT INTO `Meter_Calendar` VALUES ('888', '26.3', '479.163', '2015-07-23' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-24'; INSE RT INTO `Meter_Calendar` VALUES ('888', '30.7', '479.47', '2015-07-24' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-25'; INSE RT INTO `Meter_Calendar` VALUES ('888', '21', '479.68', '2015-07-25' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-26'; INSE RT INTO `Meter_Calendar` VALUES ('888', '17.3', '479.853', '2015-07-26' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-27'; INSE RT INTO `Meter_Calendar` VALUES ('888', '28.8', '480.142', '2015-07-27' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-28'; INSE RT INTO `Meter_Calendar` VALUES ('888', '40.8', '480.55', '2015-07-28' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-29'; INSE RT INTO `Meter_Calendar` VALUES ('888', '39.2', '480.942', '2015-07-29' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-30'; INSE RT INTO `Meter_Calendar` VALUES ('888', '34.6', '481.289', '2015-07-30' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-31'; INSE RT INTO `Meter_Calendar` VALUES ('888', '34.6', '481.635]]', '2015-07-31' );
update DeviceStatus set lastupdate = '2015-07-31 12:41:17' where id = 888;

- PART 4 Update the db

File size is NOT zero -> DB update needed
Stoping Domoticz !
Domoticz stopped
Update DB START
Update Values
Update Status
Update DB END
Starting Domoticz !
2015-09-17 12:41:30.088 Domoticz V2.3011 (c)2012-2015 GizMoCuz
2015-09-17 12:41:30.089 Build Hash: 765fe41, Date: 2015-09-13 08:04:58
2015-09-17 12:41:30.091 System: Raspberry Pi
2015-09-17 12:41:30.092 Startup Path: /home/pi/domoticz/
domoticz: Domoticz is starting up....
Domoticz started

### END ###

# sudo /etc/init.d/domoticz.sh stop
# sqlite3 /home/pi/domoticz/domoticz.db
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .read /home/pi/EAU/previous.generated.2015-07.sql

sqlite> .quit
# sudo /etc/init.d/domoticz.sh start
2015-09-17 12:42:49.212 Domoticz V2.3011 (c)2012-2015 GizMoCuz
2015-09-17 12:42:49.214 Build Hash: 765fe41, Date: 2015-09-13 08:04:58
2015-09-17 12:42:49.215 System: Raspberry Pi
2015-09-17 12:42:49.217 Startup Path: /home/pi/domoticz/
domoticz: Domoticz is starting up....
][/code]

[sirus]

Dans le lignes sql il semble y avoir des espaces entre le E et le R dans INSE RT:

DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-24'; INSE RT INTO`Meter_Calendar` VALUES ('888', '30.7', '479.47', '2015-07-24' );


c'est pareil sur le fichier sql ? le probleme vient peu etre de là ?

Tu as des données si tu fait :

Code : Tout sélectionner

root > sqlite3 /home/pi/domoticz/domoticz.db
sqlite> select * from Meter_Calendar where devicerowid=888; 

Sinon ton device est bien configuré ? voir ici : http://domotique.web2diz.net/?p=138

Tu peux poster le contenu de l'url suivante :

http: //<IP>:<PORT>/json.htm?type=devices&rid=888

[atlantis007]

voici mon script comme tu vois j ai recréé un compteur

Code : Tout sélectionner

# sqlite3 /home/pi/domoticz/domoticz.db
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from Meter_Calendar where devicerowid=890;
890|30.6|493.877|2015-09-01
890|26.8|494.145|2015-09-02
890|28.2|494.427|2015-09-03
890|31.7|494.744|2015-09-04
890|36.4|495.108|2015-09-05
890|34.1|495.449|2015-09-06
890|30|495.749|2015-09-07
890|23.9|495.988|2015-09-08
890|26.5|496.253|2015-09-09
890|44.4|496.697|2015-09-10
890|36.2|497.059|2015-09-11
890|14.9|497.208|2015-09-12
890|51.3|497.721|2015-09-13
890|24.6|497.967|2015-09-14
890|35|498.317|2015-09-15
890|29.8|498.615|2015-09-16
890|34.6|481.981|2015-08-01
890|34.6|482.327|2015-08-02
890|31.8|482.645|2015-08-03
890|38.9|483.034|2015-08-04
890|54.3|483.577|2015-08-05
890|69.4|484.271|2015-08-06
890|62.6|484.898|2015-08-07
890|52.9|485.427|2015-08-08
890|32.5|485.752|2015-08-09
890|32.9|486.081|2015-08-10
890|37.6|486.457|2015-08-11
890|48.4|486.941|2015-08-12
890|27.2|487.213|2015-08-13
890|35.1|487.564|2015-08-14
890|22.1|487.785|2015-08-15
890|44.5|488.23|2015-08-16
890|40.5|488.635|2015-08-17
890|37|489.005|2015-08-18
890|49.9|489.504|2015-08-19
890|39.7|489.901|2015-08-20
890|47.4|490.375|2015-08-21
890|36.1|490.736|2015-08-22
890|25.2|490.988|2015-08-23
890|20.2|491.19|2015-08-24
890|35.7|491.546|2015-08-25
890|28.9|491.835|2015-08-26
890|48.2|492.317|2015-08-27
890|26.9|492.586|2015-08-28
890|34.9|492.935|2015-08-29
890|31.4|493.249|2015-08-30
890|32.2|493.571]]|2015-08-31
sqlite>

quand a url elle marche pas

[sirus]

Ok !

je penses que ton problème viens de cette/ces ligne(s) :

890|32.2|493.571]]|2015-08-31

peux tu tester ceci :
tu arrete domoticz

Code : Tout sélectionner

sudo /etc/init.d/domoticz.sh stop
sqlite3 /home/pi/domoticz/domoticz.db
sqlite > detele from Meter_Calendar where Counter like '%]]%' 
sqlite > select * from Meter_Calendar where devicerowid=890;
sudo /etc/init.d/domoticz.sh start

et tu colles le résultat ici .

Une fois domoticz redémarré tu regardes la page des compteurs si il n'y a pas du mieux...

Tu as bien la dernière version du script qui date du 28/10 ?

A+

[atlantis007]

la commande

Code : Tout sélectionner

detele from Meter_Calendar where Counter like '%]]%' 

ne marche pas

voici le contenu de l'url suivante :

http://192.168.0.30:8080/json.htm?type=devices&rid=890

Code : Tout sélectionner

{
   "ActTime" : 1442595573,
   "ServerTime" : "2015-09-18 18:59:33",
   "Sunrise" : "07:50",
   "Sunset" : "20:10",
   "result" : [
      {
         "AddjMulti" : 1.0,
         "AddjMulti2" : 1.0,
         "AddjValue" : 0.0,
         "AddjValue2" : 0.0,
         "BatteryLevel" : 255,
         "Counter" : "0.000 m3",
         "CounterToday" : "0 Liter",
         "CustomImage" : 0,
         "Data" : "0.000 m3",
         "Description" : "",
         "Favorite" : 1,
         "HardwareID" : 6,
         "HardwareName" : "virtuel",
         "HardwareType" : "Dummy (Does nothing, use for virtual switches only)",
         "HardwareTypeVal" : 15,
         "HaveTimeout" : true,
         "ID" : "143C9",
         "LastUpdate" : "2015-08-31 22:54:03",
         "Name" : "Compteur Eau SDEI",
         "Notifications" : "false",
         "PlanID" : "0",
         "Protected" : false,
         "ShowNotifications" : true,
         "SignalLevel" : 10,
         "SubType" : "RFXMeter counter",
         "SwitchTypeVal" : 2,
         "Timers" : "false",
         "Type" : "RFXMeter",
         "TypeImg" : "counter",
         "Unit" : 1,
         "Used" : 1,
         "XOffset" : "0",
         "YOffset" : "0",
         "idx" : "890"
      }
   ],
   "status" : "OK",
   "title" : "Devices"

[sirus]

Pour la comande c'est une faute de frape il faut tapper :
sqlite > delete from Meter_Calendar where Counter like '%]]%'

C'est bizarre on dirait qu'il y a des information supplémentaires sur ton compteur ...
(le tien à gauche)

SNAG-000040.jpg (181.02 Kio) Consulté 7894 fois

j’avoue que la je seche un peu, pourtant ca fonctione chez pas mal de personne...

[jacques68]

Hello!!

J'ai remarqué un truc bizzare depuis l'une des dernieres mises à jour. Dans mes logs mes valeurs s'affichaient avant en metre/cube. Maontenant les valeurs s'affichent en litres?????
Quelqu'un d'autres a t'il ce meme comportement???

metrecube.png (89.95 Kio) Consulté 7861 fois

Avant l'affichage était pourtant correct:

Domo2.png (179.28 Kio) Consulté 7861 fois

J'ai vérifier dans les paramètres mais rien de ce coté

[sirus]

Salut,

et le valeur te sembles correctes par rapport à ta consommation réelle ?

Voici ma page de réglage pour les compteur, je ne vois pas la possibilité (pour moi) de régler l'unité pour la consommation d'eau. C'est peut être le cas pour toi ?

Untitled.jpg (90.99 Kio) Consulté 7858 fois