Index CSV Timestamp

[gabrile_jaime_gomez (gabrile jaime gomez rodriguez)]

hello
I want to index some csv files. I want to be indexed with the modification date, not with the date entered in Elastic.
Example
My file has a modification date of 01/23/2022, that is the date that I would like to see in Kibana. not today's date

[Rios]

Do you have a column with date modification?

[gabrile_jaime_gomez (gabrile jaime gomez rodriguez)]

The file itself doesn't have a date column, I want to index with the system date

[Rios]

filter {

  ruby { 
    code => "	event.set('[@metadata][filedate]', File.mtime(event.get('[log][file][path]') ) ) "
  }
  
  mutate {copy => { "[@metadata][filedate]" => "@timestamp"}} 

}

[gabrile_jaime_gomez (gabrile jaime gomez rodriguez)]

this is my configuration file

[gabrile_jaime_gomez (gabrile jaime gomez rodriguez)]

Thank you very much, what you sent me worked for me.

you are a guru

[Rios]

I have noticed, you are on Windows, change in input/file:
sincedb_path => "NUL"

If something is not possible to achive in LS, there is Ruby always.

Guru? You should see Badger, he is the Jedi, collecting data from galaxies, shifting time, control space and much much more.