Skip to content

Import of data failed #28

@schornhe

Description

@schornhe

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 ?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions