topic Re: CSV imports, headers as fields? in Getting Data In

CSV imports, headers as fields?

mcrawford44 — Fri, 13 Dec 2013 14:42:02 GMT

All,

I have been following this documentation;
http://docs.splunk.com/Documentation/Splunk/6.0/Data/Extractfieldsfromfileheadersatindextime

No combination of props.conf settings appears to be working. Here is the data template of the file I am attempting to bring in;

Header1|Header2|Header3|Header4    
DataA|DataB|DataC|DataD

My assumed props.conf;

[SourceTypeName]
FIELD_DELIMITER=|
NO_BINARY_CHECK=1
SHOULD_LINEMERGE=false

Any ideas? I can edit the props.conf during the data add "wizard" and it updates the local conf file appropriately, however each event is still shown as a single line without field information;

Can't post images so replace the 'xx' with 'tt'; hxxp://i.imgur.com/vAKOJFY.png

Re: CSV imports, headers as fields?

lukejadamec — Fri, 13 Dec 2013 15:03:05 GMT

Have you tried quotes around the pipe? "|"

Re: CSV imports, headers as fields?

ShaneNewman — Sun, 15 Dec 2013 16:14:52 GMT

[SourceTypeName]
FIELD_DELIMITER = "|"
CHECK_FOR_HEADER = true
HEADER_MODE = firstline

Re: CSV imports, headers as fields?

mcrawford44 — Mon, 16 Dec 2013 15:42:23 GMT

The quotes worked. -_-
Thanks!

Re: CSV imports, headers as fields?

mcrawford44 — Mon, 16 Dec 2013 15:42:26 GMT

The quotes worked. -_-
Thanks!

Re: CSV imports, headers as fields?

ogdin — Thu, 13 Feb 2014 15:56:04 GMT

You don't want to use CHECK_FOR_HEADER in combination with indexed extractions. CHECK_FOR_HEADER is a deprecated technique we used for search-time field extractions.

In props.conf, use:

FIELD_DELIMITER=| HEADER_FIELD_DELIMITER=| INDEXED_EXTRACTIONS=psv