# I try to input csv file into elasticsearch. but always debuging

**URL:** <https://discuss.elastic.co/t/i-try-to-input-csv-file-into-elasticsearch-but-always-debuging/154641>\
**Category:** Logstash\
**Created:** [October 30, 2018, 11:53am UTC](https://discuss.elastic.co/t/i-try-to-input-csv-file-into-elasticsearch-but-always-debuging/154641 "2018-10-30T11:53:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![levi\_munthe](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/levi_munthe/32/42202_2.png) [@levi\_munthe](https://discuss.elastic.co/u/levi_munthe)\
**Post date:** [October 30, 2018, 11:53am UTC](https://discuss.elastic.co/t/i-try-to-input-csv-file-into-elasticsearch-but-always-debuging/154641/1 "2018-10-30T11:53:18Z")

</div>

i try input csv file using logstash to elaticsearch. i am using centos.

input {  
file {  
path =\> "/etc/logstash/sql/geotester.csv"  
start\_position =\> "beginning"

}  
}  
filter {  
csv{  
separator =\> ","  
columns =\> ["id","memberid","firstname","lastname","email","phone","gender","code","receiptcode","channel","districtname","regionname","cityname","registerby","elinacode","elinaname","transactiondate","transactiontime","month","monthly","weekly","daily","hourly","campaigncode","store","account","channelshoping","retaileraddress","status","statusstring","rejectreason","requestdate","createddate","updateddate","updatedby","collectid","quantity","remarks","quantityapproved","itemprice","totalpoints","actionname","productname","gram","totalgram","updatedbynew","updatedbyid"]  
}  
mutate{convert =\> ["itemprice","integer"]}  
mutate{convert =\> ["totalpoints","integer"]}  
mutate{convert =\> ["gram","integer"]}  
mutate{convert =\> ["totalgram","integer"]}  
}

output {  
elasticsearch {  
user =\> "admin"  
password =\> "admin"  
hosts =\> ["[https://localhost:9200](https://localhost:9200)"]  
index =\> "kibanareceiptbebe"  
document\_type =\> "receipt"  
document\_id =\> "%{collectid}"  
manage\_template =\> false  
ssl =\> true  
ssl\_certificate\_verification =\> false

}  
}

the tail log.  
[2018-10-30T18:48:03,337][DEBUG][logstash.pipeline] Pushing flush onto pipeline {:pipeline\_id=\>"kibanageotester", :thread=\>"#\<Thread:0x5733a494 sleep\>"}  
[2018-10-30T18:48:07,868][DEBUG][logstash.inputs.file] \_globbed\_files: /etc/logstash/sql/geotester.csv: glob is: ["/etc/logstash/sql/geotester.csv"]  
[2018-10-30T18:48:08,246][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=\>"ParNew"}  
[2018-10-30T18:48:08,246][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=\>"ConcurrentMarkSweep"}

---

<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:** [November 27, 2018, 11:53am UTC](https://discuss.elastic.co/t/i-try-to-input-csv-file-into-elasticsearch-but-always-debuging/154641/2 "2018-11-27T11:53:23Z")

</div>

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