Getting Data In

Is there a way to use a date in a CSV file name as the timestamp without editing datetime.xml or props.conf?

srichansen
Path Finder

Hi All,

I am trying to import a CSV file that has a date in the filename and I am wondering if it's possible to use that date as the timestamp without having to edit the datetime.xml and the props.conf files?

my file format is the following:
meetboek_2017-02-01.csv
meetboek_2017-02-02.csv

Ideally I would like all the events in the file to have a timestamp with 2017/02/01... etc.
All the various settings I have tried under advances in sourcetype have not worked and I can only get it to show the modtime.

Any tips or help in this would be appreciated.
Thanks in advance!
Simon

0 Karma
1 Solution

cpetterborg
SplunkTrust
SplunkTrust

This comes up fairly often, and the answer the last time I looked was, no, you cannot use the timestamp in the filename for the timestamp of the events.:

https://answers.splunk.com/answers/320978/how-to-extract-the-timestamp-from-a-filename-at-in.html

View solution in original post

0 Karma

cpetterborg
SplunkTrust
SplunkTrust

This comes up fairly often, and the answer the last time I looked was, no, you cannot use the timestamp in the filename for the timestamp of the events.:

https://answers.splunk.com/answers/320978/how-to-extract-the-timestamp-from-a-filename-at-in.html

0 Karma

srichansen
Path Finder

Yes, I had see the answers, but was hoping that it had since been solved.
Thanks for the assistance!

0 Karma
Get Updates on the Splunk Community!

Observability Highlights | November 2022 Newsletter

 November 2022Observability CloudEnd Of Support Extension for SignalFx Smart AgentSplunk is extending the End ...

Avoid Certificate Expiry Issues in Splunk Enterprise with Certificate Assist

This blog post is part 2 of 4 of a series on Splunk Assist. Click the links below to see the other ...

Using Machine Learning for Hunting Security Threats

REGISTER NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more ...