Thanks for the help I finally managed to export in an editable format which is really good.
Here is the command used:
runNum = fieldTag
temperature 1 = fieldKey
temperature 2 = fieldKey
temperature 3 = fieldKey
sudo /usr/bin/influx -database '<influx_db_Database>' -host 'localhost' -username '<UserDatabase>' -password '<Password>' -execute 'select * from temperature' -format 'csv' > /home/<user>/temperature-export.csv
csv result (extracted from 4 lines out of 36977):
name,time,runNum,temperature 1,temperature 2,temperature 3
temperature,1604331871100706000,RUN,21.4,15.2,
temperature,1604403256478881000,RUN,19.3,12.3,
temperature,1604403756958970000,RUN,19.3,12.4,19.6
temperature,1604403879758941000,RUN,19.3,12.4,19.6
I then tested with the following order to re-import
curl -i -XPOST "http://localhost:8086/write?db=test" --data-binary @txtfilewithlineprotocol.csv
unfortunately i have errors every line (about 36977 lines)
‘temperature,1604331871100706000,RUN,21.4,15.2,’: missing tag value\nunable to parse
‘temperature,1604403256478881000,RUN,19.3,12.3,’: missing tag value\nunable to parse
‘temperature,1604403756958970000,RUN,19.3,12.4,19.6’: missing tag value\nunable to parse
‘temperature,1604403879758941000,RUN,19.3,12.4,19.6’: missing tag value\nunable to parse
I looked everywhere for a native solution or script but found nothing for import csv to influxdb
