Hallo, ich bin neu hier.
Auf das Forum bin ich durch den YT- Kanal von Simon gekommen.
Jetzt auch gleich zu meiner Frage:
Ich habe einen Growatt-1000tl-x in Homeassistant mit einem ESP und einem RS485 to TTL eingebunden. Das funktioniert seit einigen Monaten auch perfekt (fast perfekt)
Ich möchte die Daten (nur die Daten dieser Integration) aus der SQLite DB auslesen und in eine andere DB importieren. Mit SQLite kenne ich mich einigermaßen aus, aber welche Daten muss ich da anfassen?
Die SQLite von meinem HA ist über 200 MB und ich habe keine Ahnung, was da wohin gehört. Die Namen von den relevanten Entitäten finde ich schon, aber wer da mit wem in Relation verknüpft ist…?
Hier ist ein Link ins HA- Forum, evtl. interessiert das Projekt ja jemanden.
Hier der ESPHome- Code
substitutions:
device_name: "growatt-1000tl-x"
device_description: "Growatt Solar Inverter Monitoring"
friendly_name: "Growatt 1000TL X"
esphome:
name: '${device_name}'
comment: '${device_description}'
# Wifi
wifi:
ssid: !secret wifi_ssid
password: !secret wifi_password
fast_connect: true
manual_ip:
static_ip: 192.168.178.28
gateway: 192.168.178.1
subnet: 255.255.255.0
dns1: 192.168.178.1
# Enable fallback hotspot (captive portal) in case wifi connection fails
ap:
ssid: !secret ap_ssid
password: !secret ap_pw
esp8266:
board: d1_mini
# Enable logging
logger:
baud_rate: 0
# Enable Home Assistant API
api:
ota:
safe_mode: true
reboot_timeout: 10min
num_attempts: 5
web_server:
port: 80
auth:
username: !secret esphome_web_username
password: !secret esphome_web_password
captive_portal:
time:
- platform: homeassistant
id: homeassistant_time
uart:
id: mod_bus
tx_pin: 1
rx_pin: 3
#baud_rate: 9600
baud_rate: 115200
#baud_rate: 56000
modbus:
id: modbus1
uart_id: mod_bus
modbus_controller:
- id: growatt
# the Modbus device addr
address: 0x1
modbus_id: modbus1
setup_priority: -10
sensor:
- platform: modbus_controller
name: "${device_name} DcWatt"
address: 5
register_type: "read"
unit_of_measurement: W
device_class: power
icon: mdi:flash
value_type: U_DWORD
accuracy_decimals: 1
filters:
- multiply: 0.1
- platform: modbus_controller
name: "${device_name} DcVolt"
address: 3
register_type: "read"
unit_of_measurement: V
device_class: voltage
icon: mdi:flash
value_type: U_WORD
accuracy_decimals: 1
filters:
- multiply: 0.1
- platform: modbus_controller
name: "${device_name} DcAmpere"
address: 4
register_type: "read"
unit_of_measurement: A
device_class: current
icon: mdi:flash
value_type: U_WORD
accuracy_decimals: 1
filters:
- multiply: 0.1
- platform: modbus_controller
name: "${device_name} AcFrequenz"
address: 37
register_type: "read"
unit_of_measurement: Hz
icon: mdi:flash
value_type: U_WORD
accuracy_decimals: 1
filters:
- multiply: 0.01
- platform: modbus_controller
name: "${device_name} AcVolt"
address: 38
register_type: "read"
unit_of_measurement: V
device_class: voltage
icon: mdi:flash
value_type: U_WORD
accuracy_decimals: 1
filters:
- multiply: 0.1
- platform: modbus_controller
name: "${device_name} AcAmpere"
address: 39
register_type: "read"
unit_of_measurement: A
device_class: current
icon: mdi:flash
value_type: U_WORD
accuracy_decimals: 1
filters:
- multiply: 0.1
- platform: modbus_controller
name: "${device_name} AcWatt"
address: 40
register_type: "read"
unit_of_measurement: W
device_class: power
icon: mdi:flash
value_type: U_DWORD
accuracy_decimals: 1
filters:
- multiply: 0.1
- platform: modbus_controller
name: "${device_name} EnergieHeute"
address: 53
register_type: "read"
unit_of_measurement: kWh
device_class: energy
icon: mdi:flash
value_type: U_DWORD
accuracy_decimals: 1
filters:
- multiply: 0.1
- platform: modbus_controller
name: "${device_name} EnergieTotal"
address: 55
register_type: "read"
unit_of_measurement: kWh
state_class: total_increasing
device_class: energy
icon: mdi:flash
value_type: U_DWORD
accuracy_decimals: 1
filters:
- multiply: 0.1
- platform: modbus_controller
name: "${device_name} Temperatur"
address: 3093
register_type: "read"
unit_of_measurement: C
device_class: temperature
icon: mdi:thermometer
value_type: U_WORD
accuracy_decimals: 1
filters:
- multiply: 0.1