I'm using te follwoing command:
./csv-to-influxdb.py --input write_values6.csv --dbname nodered --metricname stromzaehler_neu -tc time -d ';' --fieldcolumns Aktuelle_Leistung,Total_Verbrauch
and I get the following error message
Inserting 671 datapoints...
Problem inserting points for current batch
Traceback (most recent call last):
File "./csv-to-influxdb.py", line 207, in
args.timezone, args.ssl, args.force)
File "./csv-to-influxdb.py", line 144, in loadCsv
raise e
influxdb.exceptions.InfluxDBClientError: 400: {"error":"partial write: field type conflict: input field "Total_Verbrauch" on measurement "stromzaehler_neu" is type string, already exists as type float dropped=1"}
However the csv file looks fine
stromzaehler_neu;Aktuelle_Leistung;Total_Verbrauch;time
stromzaehler_neu;500.51;5122.7096;2022-08-27 05:00:00
stromzaehler_neu;500.51;5123.2192;2022-08-27 06:00:00
stromzaehler_neu;500.51;5123.7288;2022-08-27 07:00:00
Any idea about this ?
I'm using te follwoing command:
./csv-to-influxdb.py --input write_values6.csv --dbname nodered --metricname stromzaehler_neu -tc time -d ';' --fieldcolumns Aktuelle_Leistung,Total_Verbrauchand I get the following error message
Inserting 671 datapoints...
Problem inserting points for current batch
Traceback (most recent call last):
File "./csv-to-influxdb.py", line 207, in
args.timezone, args.ssl, args.force)
File "./csv-to-influxdb.py", line 144, in loadCsv
raise e
influxdb.exceptions.InfluxDBClientError: 400: {"error":"partial write: field type conflict: input field "Total_Verbrauch" on measurement "stromzaehler_neu" is type string, already exists as type float dropped=1"}
However the csv file looks fine
stromzaehler_neu;Aktuelle_Leistung;Total_Verbrauch;time
stromzaehler_neu;500.51;5122.7096;2022-08-27 05:00:00
stromzaehler_neu;500.51;5123.2192;2022-08-27 06:00:00
stromzaehler_neu;500.51;5123.7288;2022-08-27 07:00:00
Any idea about this ?