topic Re: PROPS Conf with CSV File in Splunk Search

PROPS Conf with CSV File

SplunkDash — Mon, 16 Aug 2021 00:17:11 GMT

Hello,

I wrote a PROPS Configuration file for following csv file but getting error message. Any help will be highly appreciated. Thank you so much.

[ csv ]

SHOULD_LINEMERGE=false

CHARSET=UTF-8

INDEXED_EXTRACTIONS=csv

TIME_FORMAT=%Y%m%d %H:%M:%S:%Q

HEADER_FIELD)LINE_NUMBER=1

TIMESTAMP_FIELDS=TIMESTAMP

category=Structured

Re: PROPS Conf with CSV File

venkatasri — Mon, 16 Aug 2021 00:27:20 GMT

@SplunkDash try below you have to deploy them to UF.

[ csv ] SHOULD_LINEMERGE=false CHARSET=UTF-8 INDEXED_EXTRACTIONS=csv TIME_FORMAT=%Y%m%d %H:%M:%S:%3Q HEADER_FIELD_LINE_NUMBER=1 TIMESTAMP_FIELDS=TIMESTAMP category=Structured

Re: PROPS Conf with CSV File

SplunkDash — Mon, 16 Aug 2021 00:39:13 GMT

Thank you so much. But, still getting error message...Failed to parse timestamp!!!

Re: PROPS Conf with CSV File

venkatasri — Mon, 16 Aug 2021 00:45:35 GMT

@SplunkDash Your field name in CSV seems TimeStamp (camel case), what you have set TIMESTAMP_FIELDs = TIMESTAMP (caps) can you correct it to match with CSV header names.

Re: PROPS Conf with CSV File

SplunkDash — Mon, 16 Aug 2021 00:53:56 GMT

oops ...😀 cool working as expected, thank you so much, appreciated!!!