Splunk Search

PROPS Configuration for CSV Source Files without headers

SplunkDash
Motivator

Hello,

I have csv source files without headers; sample events from that file and what PROPS Conf.  I wrote are given below. Values in the first column can be used as time stamps. How would I write PROPS configuration file  for that csv source file, since I am getting some error messages in timestamps and some extra  columns at the beginning of events.  Any help will be highly appreciated. Thank you so much,

Here is what I wrote:

[ csv ]

SHOULD_LINEMERGE=false

NO_BINARY_CHECK=true

INDEXED_EXTRACTIONS=csv

TIME_PREFIX=^

TIME_FORMAT=%Y-%m-%d %H:%M:%S.%6Q

FIELD_NAMES=f1,f2,f3,f4,f5,f6,f7,f8

 

5 Sample Events:

malekmo_0-1635976937064.png

 

 

Labels (1)
Tags (1)
0 Karma
1 Solution

isoutamo
SplunkTrust
SplunkTrust

Hi

this seems to be quite correct if you have "," as a field separator.

Only thing which I modify is

TIME_FORMAT=%Y-%m-%d %H:%M:%S.%6Q %Z

As you gave also TZ information on your events.

r. Ismo 

View solution in original post

isoutamo
SplunkTrust
SplunkTrust

Hi

this seems to be quite correct if you have "," as a field separator.

Only thing which I modify is

TIME_FORMAT=%Y-%m-%d %H:%M:%S.%6Q %Z

As you gave also TZ information on your events.

r. Ismo 

Get Updates on the Splunk Community!

Application management with Targeted Application Install for Victoria Experience

  Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...

Index This | What goes up and never comes down?

January 2026 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Splunkers, Pack Your Bags: Why Cisco Live EMEA is Your Next Big Destination

The Power of Two: Splunk + Cisco at "Ludicrous Scale"   You know Splunk. You know Cisco. But have you seen ...