fail with error: Unexpected time with format & Warning: Failed to force "xxx" to float, skip...

[Lxeon]

hello sir, i get Error when running cammand.

cammand: export_csv_to_influx --csv /mnt/ssd/docker/influxdb/data/data/apcupsd.csv --dbname Ubuntu --measurement apcupsd -u admin -p admin --force_float_columns battery_charge_percent,battery_voltage,input_frequency,input_voltage,internal_temp,load_percent,nominal_battery_voltage,nominal_input_voltage,output_voltage --force_int_columns nominal_power,status_flags,time_left_ns,time_on_battery_ns --force_string_columns battery_date,firmware -fc battery_charge_percent,battery_date,battery_voltage,firmware,input_frequency,input_voltage,internal_temp,load_percent,nominal_battery_voltage,nominal_input_voltage,nominal_power,output_voltage,status_flags,time_left_ns,time_on_battery_ns -tc host,model,serial,status,ups_name -t time

i had to force all field because if not , it will get the same name columns but different type..

fieldKey:

tagKey:

csv:

error msg:

did i miss something?

[7yl4r]

Can you verify that all the values in the column(s) are valid (float|int)?

[Lxeon]

Can you verify that all the values in the column(s) are valid (float|int)?

i create new database and run the command, but error after 3400 line? this csv i never change after export.

this is my export command: influx -database WindowsServer2022 -username 'admin' -password 'admin' -execute 'select * from apcupsd' -format csv >> apcupsd.csv