Checksum verification at csv import using Directory_Monitoring plugin

[dk9uv]

Please direct all support questsions to slack or the forums. Thank you.

I have measurement data in csv files from a datalogger. File structure is as follows:

First line: data like station number, received strength signal indicator, battery voltage

Second line: column headers

Then many measurement lines with timestamp and measurement data

Last line: Checksum=number, the number is calculated by simply adding up all ASCII values from the beginning from the first line
not including the last line if course.

Example csv is:

1234,22,5.75
Timestamp,Temperature
29.12.2024 14:00:00,12.34
29.12.2024 14:10:00,13.56
29.12.2024 14:20:00,14.78
Checksum=6581

I wonder if there is a recommendation how the deal with this type of data. I prefer a pure telegraf solution. Using a "file prechecker/preprocessor" with some extra programm would be possible of course. If Checksum is wrong then the file shall be discarded. The files come from an FTP transfer. Some FTP transfer results in not complete files when connection is broken during transfer. Therefore the Checksum is used so that only complete files shall be processed.

Cheers

Chris

[telegraf-tiger]

Hello! I recommend posting this question in our Community Slack or Community Forums, we have a lot of talented community members there who could help answer your question more quickly. You can also learn more about Telegraf by enrolling at InfluxDB University for free!

Heads up, this issue will be automatically closed after 7 days of inactivity. Thank you!