Dans Influxdb , comment procéder pour donner le chemin de stockage de base de données (sur un NAS par exemple)
Merci @Neuvidor pour toutes ces infos, mais est ce possible de partager ton json pour le node d’injection dans influxdb?
J’ai un souci mes données ne sont pas enregistrées dans la base et je n’ai pas de message d’erreur.
Mon influxdb out fonctionne car je l’utilise sans pb pour d’autre donnée mais pas pour un sensor
Merci
Salut @Steph_Flo,
Voici un exemple de mon flow
[
{
"id": "d6a54a0cff57ece2",
"type": "tab",
"label": "Exemple_InfluxDB_Flow",
"disabled": false,
"info": ""
},
{
"id": "b66fa19f2cfb6f52",
"type": "inject",
"z": "d6a54a0cff57ece2",
"name": "Trigger",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
},
{
"p": "dateofdata",
"v": "",
"vt": "date"
}
],
"repeat": "60",
"crontab": "",
"once": true,
"onceDelay": "60",
"topic": "",
"payloadType": "date",
"x": 100,
"y": 60,
"wires": [
[
"d9f929819d0fbbf4",
"b3836717d0aaf521",
"7aff04a13c69fae8"
]
]
},
{
"id": "d9f929819d0fbbf4",
"type": "api-current-state",
"z": "d6a54a0cff57ece2",
"name": "",
"server": "d8cde96c5bee6be7",
"version": 2,
"outputs": 1,
"halt_if": "",
"halt_if_type": "str",
"halt_if_compare": "is",
"entity_id": "sensor.temperature_jardin",
"state_type": "num",
"blockInputOverrides": false,
"outputProperties": [
{
"property": "hass",
"propertyType": "msg",
"value": "",
"valueType": "entityState"
},
{
"property": "data",
"propertyType": "msg",
"value": "",
"valueType": "entityState"
}
],
"override_topic": false,
"state_location": "payload",
"override_payload": "msg",
"entity_location": "data",
"override_data": "msg",
"x": 480,
"y": 260,
"wires": [
[
"9b0ad654aa10f226"
]
]
},
{
"id": "9b0ad654aa10f226",
"type": "data-generator",
"z": "d6a54a0cff57ece2",
"name": "temperature - jardin",
"field": "payload",
"fieldType": "msg",
"syntax": "json",
"template": "[\n {\n \"time\": {{dateofdata}},\n \"value\": {{data}}\n \n },\n {\n \"domain\": \"temperature\",\n \"entity_id\": \"jardin\",\n \"instance\": \"prod\",\n \"source\": \"capteur\"\n }\n]",
"x": 1070,
"y": 260,
"wires": [
[
"dea2a25fe96a6607"
]
]
},
{
"id": "dea2a25fe96a6607",
"type": "influxdb out",
"z": "d6a54a0cff57ece2",
"influxdb": "92271fcac6fe5bc8",
"name": "°C - Data injected to InfluxDB v2.0",
"measurement": "°C",
"precision": "",
"retentionPolicy": "",
"database": "database",
"precisionV18FluxV20": "ms",
"retentionPolicyV18Flux": "",
"org": "influxdb",
"bucket": "home1_raw_data",
"x": 1580,
"y": 260,
"wires": []
},
{
"id": "6cb3664bcdcd6325",
"type": "influxdb out",
"z": "d6a54a0cff57ece2",
"influxdb": "92271fcac6fe5bc8",
"name": "kWh - Data injected to InfluxDB v2.0",
"measurement": "kWh",
"precision": "",
"retentionPolicy": "",
"database": "database",
"precisionV18FluxV20": "ms",
"retentionPolicyV18Flux": "",
"org": "influxdb",
"bucket": "home1_raw_data",
"x": 1590,
"y": 140,
"wires": []
},
{
"id": "b3836717d0aaf521",
"type": "api-current-state",
"z": "d6a54a0cff57ece2",
"name": "",
"server": "d8cde96c5bee6be7",
"version": 2,
"outputs": 1,
"halt_if": "",
"halt_if_type": "str",
"halt_if_compare": "is",
"entity_id": "sensor.ecocompteur_inst_data6m3",
"state_type": "num",
"blockInputOverrides": false,
"outputProperties": [
{
"property": "hass",
"propertyType": "msg",
"value": "",
"valueType": "entityState"
},
{
"property": "data",
"propertyType": "msg",
"value": "",
"valueType": "entityState"
}
],
"override_topic": false,
"state_location": "payload",
"override_payload": "msg",
"entity_location": "data",
"override_data": "msg",
"x": 510,
"y": 200,
"wires": [
[
"32d1a18fd854bf70"
]
]
},
{
"id": "32d1a18fd854bf70",
"type": "data-generator",
"z": "d6a54a0cff57ece2",
"name": "energie - eau_adoucie",
"field": "payload",
"fieldType": "msg",
"syntax": "json",
"template": "[\n {\n \"time\": {{dateofdata}},\n \"value\": {{data}}\n \n },\n {\n \"domain\": \"energie\",\n \"entity_id\": \"eau_adoucie\",\n \"instance\": \"prod\",\n \"source\": \"capteur\"\n }\n]",
"x": 1080,
"y": 200,
"wires": [
[
"852819446b066ff5"
]
]
},
{
"id": "852819446b066ff5",
"type": "influxdb out",
"z": "d6a54a0cff57ece2",
"influxdb": "92271fcac6fe5bc8",
"name": "m3 - Data injected to InfluxDB v2.0",
"measurement": "m3",
"precision": "",
"retentionPolicy": "",
"database": "database",
"precisionV18FluxV20": "ms",
"retentionPolicyV18Flux": "",
"org": "influxdb",
"bucket": "home1_raw_data",
"x": 1580,
"y": 200,
"wires": []
},
{
"id": "7aff04a13c69fae8",
"type": "api-current-state",
"z": "d6a54a0cff57ece2",
"name": "",
"server": "d8cde96c5bee6be7",
"version": 2,
"outputs": 1,
"halt_if": "",
"halt_if_type": "str",
"halt_if_compare": "is",
"entity_id": "sensor.ecocompteur_data_conso_base",
"state_type": "num",
"blockInputOverrides": false,
"outputProperties": [
{
"property": "hass",
"propertyType": "msg",
"value": "",
"valueType": "entityState"
},
{
"property": "data",
"propertyType": "msg",
"value": "",
"valueType": "entityState"
}
],
"override_topic": false,
"state_location": "payload",
"override_payload": "msg",
"entity_location": "data",
"override_data": "msg",
"x": 520,
"y": 140,
"wires": [
[
"5f6cc708bde2ad6b"
]
]
},
{
"id": "5f6cc708bde2ad6b",
"type": "data-generator",
"z": "d6a54a0cff57ece2",
"name": "energie - linky_base",
"field": "payload",
"fieldType": "msg",
"syntax": "json",
"template": "[\n {\n \"time\": {{dateofdata}},\n \"value\": {{data}}\n \n },\n {\n \"domain\": \"energie\",\n \"entity_id\": \"linky_base\",\n \"instance\": \"prod\",\n \"source\": \"capteur\"\n }\n]",
"x": 1080,
"y": 140,
"wires": [
[
"6cb3664bcdcd6325"
]
]
},
{
"id": "d8cde96c5bee6be7",
"type": "server",
"name": "HomeAssistant_Server",
"version": 1,
"legacy": false,
"addon": false,
"rejectUnauthorizedCerts": true,
"ha_boolean": "y|yes|true|on|home|open",
"connectionDelay": true,
"cacheJson": true
},
{
"id": "92271fcac6fe5bc8",
"type": "influxdb",
"hostname": "127.0.0.1",
"port": "8086",
"protocol": "http",
"database": "database",
"name": "InfluxDB_server",
"usetls": false,
"tls": "d50d0c9f.31e858",
"influxdbVersion": "2.0",
"url": "http://192.168.1.87:8086",
"rejectUnauthorized": true
},
{
"id": "d50d0c9f.31e858",
"type": "tls-config",
"name": "",
"cert": "",
"key": "",
"ca": "",
"certname": "",
"keyname": "",
"caname": "",
"servername": "",
"verifyservercert": false
}
]
Merci beaucoup, avec ton exemple cela fonctionne. J’ai comparé ton exemple avec celui que j’avais fait et je ne trouve pas de difference donc mystere. En tout cas merci
Steph
Cherche bien, il y en a forcément une 
En tous cas content que cela fonctionne.
bonjour Neuvidor
j’ai les memes tasks que toi, mais elles ne semblent se déclencher qu’à 2h30 du matin. pour les températures ce n’est pas genant, mais pour les kWh c’est embêtant car la nuit je charge ma VE et j’aimerai avoir la conso par jour exactement (donc arret à 00h00 ou pire 00h01.) pour les +2h doit y avoir une histoire de time utc, et pour les 30 min ?
pour la tache par heure, c’est pareil elle s’exécute à 1h30 2h30 … on retrouve les 30 min
une idée ?