Getting Data In

csv file could not be read.

pallavibalasa
Explorer

I created a csv file and placed in splunk/var/run/splunk/csv/ folder and using the command |inputcsv filename.csv

I am unable to get the results. It says file could not be read. I have not applied any restrictions to the file. Please provide me with detailed steps on what to check .
I guess I am missing something here.

Regards,
Pallavi

0 Karma
1 Solution

pallavibalasa
Explorer

This issue is solved. I changed the permissions of the folder in which the file resides. Now i can read and write to the file.

Thanks for all responses.

View solution in original post

0 Karma

pallavibalasa
Explorer

This issue is solved. I changed the permissions of the folder in which the file resides. Now i can read and write to the file.

Thanks for all responses.

0 Karma

vasanthmss
Motivator

Place it in $splunk_home/etc/apps/search/lookup/

Run csv folder is for outputcsv

web ui to import and check where the files are imported. Why do you want to place the field in run - csv??

For further details check the below URL,
http://docs.splunk.com/Documentation/Splunk/6.4.2/Knowledge/ConfigureCSVlookups

V
0 Karma

renjith_nair
Legend

Check the permission of the file. Make sure that the file exists and is readable by the splunk user

---
What goes around comes around. If it helps, hit it with Karma 🙂
0 Karma

vivek_manoj
Explorer

In this you have to map the field name in the csv file with the field name you want to .
For ex. use
sourcetype=abc|lookup filename.csv field1=FIELD1 field2=FIELD2....

It is created before using lookups command.

0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

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

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...