# Csv file no reading?

**URL:** <https://discuss.elastic.co/t/csv-file-no-reading/61064>\
**Category:** Logstash\
**Created:** [September 21, 2016, 12:53am UTC](https://discuss.elastic.co/t/csv-file-no-reading/61064 "2016-09-21T00:53:45Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Allie\_Yang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/allie_yang/32/16538_2.png) [@Allie\_Yang](https://discuss.elastic.co/u/Allie_Yang)\
**Post date:** [September 21, 2016, 12:53am UTC](https://discuss.elastic.co/t/csv-file-no-reading/61064/1 "2016-09-21T00:53:45Z")

</div>

i am trying to read cvs file. i see similar post but see no definite answer. is it the pointer issue that cvs file does not have pointer?

**If so, logstash doesn't work for static cvs file?**

my config below:  
input {  
file {  
path =\> "/Desktop/sample.csv"  
start\_position =\> "beginning"  
ignore\_older =\> 0  
sincedb\_path =\> "/dev/null"  
}  
}

filter {  
csv {  
columns =\> ["ets\_ccsdk\_events","archivedb","archivepk","authsrc","blob","blobcompression","brioaccountid","brioaccountname","briomeetingname","briomeetingsessionid","briousersessionid","code","collectiondts","collectionenv","collectionhost","documentid","documentlength"]  
}  
}

output {  
stdout { codec =\> rubydebug }  
}

~  
~

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [September 21, 2016, 5:35am UTC](https://discuss.elastic.co/t/csv-file-no-reading/61064/2 "2016-09-21T05:35:32Z")

</div>

With your settings of `start_position`, `ignore_older`, and `sincedb_path` Logstash should indeed read the file. Please show the output of these commands:

```auto
ls -l /Desktop/sample.csv
ls -ld /Desktop

```

---

<div class="post-metadata">

**Author:** ![Allie\_Yang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/allie_yang/32/16538_2.png) [@Allie\_Yang](https://discuss.elastic.co/u/Allie_Yang)\
**Post date:** [September 22, 2016, 10:19pm UTC](https://discuss.elastic.co/t/csv-file-no-reading/61064/3 "2016-09-22T22:19:56Z")

</div>

Hi Below is the output. Is anything wrong with it?

yangyan-osx:~ yangyan$ ls -l Desktop/sample.csv  
-rw-r--r--@ 1 yangyan staff 4161113 Sep 20 17:48 Desktop/sample.csv  
yangyan-osx:~ yangyan$ ls -ld Desktop  
drwx------+ 18 yangyan staff 612 Sep 22 15:00 Desktop

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [September 23, 2016, 6:12am UTC](https://discuss.elastic.co/t/csv-file-no-reading/61064/4 "2016-09-23T06:12:13Z")

</div>

Those are not the commands I asked you to run. Please run **exactly** what I asked for.

---

<div class="post-metadata">

**Author:** ![Allie\_Yang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/allie_yang/32/16538_2.png) [@Allie\_Yang](https://discuss.elastic.co/u/Allie_Yang)\
**Post date:** [September 23, 2016, 5:45pm UTC](https://discuss.elastic.co/t/csv-file-no-reading/61064/5 "2016-09-23T17:45:07Z")

</div>

Sorry, pls see below. What does it mean..?

yangyan-osx:~ yangyan$ ls -l /Desktop/sample.csv  
ls: /Desktop/sample.csv: No such file or directory  
yangyan-osx:~ yangyan$ ls -ld /Desktop  
ls: /Desktop: No such file or directory

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [September 25, 2016, 7:17pm UTC](https://discuss.elastic.co/t/csv-file-no-reading/61064/6 "2016-09-25T19:17:45Z")

</div>

You have configured Logstash to read /Desktop/sample.csv but there is no such file (as the command above proves). The actual filename seems to be /Users/yangyan/Desktop/sample.csv or similar, so that's what your Logstash configuration should point to.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 4:36am UTC](https://discuss.elastic.co/t/csv-file-no-reading/61064/8 "2017-07-06T04:36:50Z")

</div>

Closed on July 6, 2017, 4:36am UTC