# How to shutdown logstash after import csv

**URL:** <https://discuss.elastic.co/t/how-to-shutdown-logstash-after-import-csv/100973>\
**Category:** Logstash\
**Created:** [September 19, 2017, 7:19am UTC](https://discuss.elastic.co/t/how-to-shutdown-logstash-after-import-csv/100973 "2017-09-19T07:19:10Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Neal\_Shan](https://avatars.discourse-cdn.com/v4/letter/n/b5a626/32.png) [@Neal\_Shan](https://discuss.elastic.co/u/Neal_Shan)\
**Post date:** [September 19, 2017, 7:19am UTC](https://discuss.elastic.co/t/how-to-shutdown-logstash-after-import-csv/100973/1 "2017-09-19T07:19:10Z")

</div>

I keep seeing this on topics, replied by @magnusbaeck

> Use the stdin input instead. Logstash will shut down by itself when stdin has been closed and all inputs has been processed. On the flip side, it Logstash dies for whatever reason you don't know how much it has processed

**Silly me, But how to use a stdin with file? Can anyone post a sample**

input {  
file {  
path =\> "I:\dev\softpack\logstash-2.0.0\_csv\bin\csv1\STP20160420.csv"  
type =\> "csv"  
start\_position =\> "beginning"  
}  
}  
filter {  
csv {  
columns =\> ["trait", "trait\_department", "trait\_category", "trait\_name", "store", "store\_type"]  
separator =\> ","  
}

}  
output {  
elasticsearch {  
action =\> "index"  
index =\> "logstash-test-stp"  
hosts =\> "localhost:9200"  
workers =\> 1  
}  
}

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [September 19, 2017, 7:33am UTC](https://discuss.elastic.co/t/how-to-shutdown-logstash-after-import-csv/100973/2 "2017-09-19T07:33:39Z")

</div>

Replace all the file parts with a simple `stdin {}`.

---

<div class="post-metadata">

**Author:** ![Neal\_Shan](https://avatars.discourse-cdn.com/v4/letter/n/b5a626/32.png) [@Neal\_Shan](https://discuss.elastic.co/u/Neal_Shan)\
**Post date:** [September 20, 2017, 4:05am UTC](https://discuss.elastic.co/t/how-to-shutdown-logstash-after-import-csv/100973/3 "2017-09-20T04:05:20Z")

</div>

I replaced it, how could stdin know where then csv is?😂

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [September 20, 2017, 4:15am UTC](https://discuss.elastic.co/t/how-to-shutdown-logstash-after-import-csv/100973/4 "2017-09-20T04:15:59Z")

</div>

You need to pipe it into Logstash, that'll depend on what OS you are on.

It looks like you are on Windows, so use `type I:\dev\softpack\logstash-2.0.0_csv\bin\csv1\STP20160420.csv | logstash -f configfile.conf`.

---

<div class="post-metadata">

**Author:** ![Neal\_Shan](https://avatars.discourse-cdn.com/v4/letter/n/b5a626/32.png) [@Neal\_Shan](https://discuss.elastic.co/u/Neal_Shan)\
**Post date:** [September 21, 2017, 2:11am UTC](https://discuss.elastic.co/t/how-to-shutdown-logstash-after-import-csv/100973/5 "2017-09-21T02:11:17Z")

</div>

Thank your very much, @warkolm . From head to toe!😍

Here is my success command on windows:  
logstash -f csv1\csv2es.conf \< I:\dev\softpack\noosh\_elasticsearch\logstash-2.0.0\_csv\bin\csv1\STP20160425.csv

input {  
stdin {  
#type =\> "stdin-type"  
}  
}  
filter {  
csv {  
columns =\> ["trait", "trait\_department", "trait\_category", "trait\_name", "store", "store\_type"]  
separator =\> ","  
}

}  
output {  
elasticsearch {  
action =\> "index"  
index =\> "logstash-test5-stp"  
hosts =\> "localhost:9200"  
workers =\> 1  
}  
stdout{}  
}

explain link for windows pipe:  
[http://www.lagmonster.org/docs/DOS7/pipes.html#pipe](http://www.lagmonster.org/docs/DOS7/pipes.html#pipe)

---

<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:** [October 19, 2017, 2:11am UTC](https://discuss.elastic.co/t/how-to-shutdown-logstash-after-import-csv/100973/6 "2017-10-19T02:11:38Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.