Bugazelle/export-csv-to-influx

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

Opened this issue · 2 comments

Lxeon commented

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 commented

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

Lxeon commented

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