How do we re-insert data into Influx?

[aschaible]

Hello,

Great utility and thanks for the contribution!

Can you provide steps to re-import the data back to Influx?

Also, my use case is to convert a tag to a field - it looks like a fairly straight-forward modification to the script. Would you agree?

Thanks in advance!

[mvadu]

I usually use shameless plug Influxer which allows your use case, in the Influxer, please run with -timeformat -input <file name> /export /autolayout and redirect to a json file, and modify the file to suite your field and tag setup. Please give it a shot.

[aschaible]

Wow you rock man, thanks. I will give it a shot!

[anethema]

I'm a little unsure of how you are using that app.

C:\Users\jdero\Desktop\influxer>Influxer.exe -timeformat -input c:\users\jdero\InfluxDump.csv /export /autolayout
Error processing arguments FormatException: Couldn't parse 2020-04-22-07.04.53.000000 using format true, check -timeformat argument

How do you specify the timeformat? They don't seem to have documentation on it.

Then I can't even tell, will that utility actually upload it back into your database?

Like what specific command would you actually run on one of your generated CSV files?

EDIT: I'm actually talking about getting data from your ExtractTransformInflux.ps1 back into my database. I'm just trying to change every instance of a certain tag to another tag.

[mvadu]

I updated the readme to show the exact commands. influxer.exe -format Generic -input InfluxDump.csv -TimeFormat "yyyy-MM-dd-hh.mm.ss.ffffff" -Precision Microseconds -splitter "," /export /autolayout > influxer.config

Also look at the Influxer's read me, it has ton of command line parameters to allow you to control the DB, retention policy and measurement where the data should be inserted back.