Importing CSV to elasticsearch using Logstash

(Suryakumar) #1


I am trying to import a CSV file to elasticsearch using Logstash. This is my config file:

input { 
      file {
        path => ["/home/suryakumar/Sample.csv"]
        start_position => "beginning"    

    filter {  
      csv {
          separator => ","
          columns => ["CompanyName","Year1","ETR","Debt_Equity_Ratio","Interest","Profit Before Tax","Deferred Tax Liabilities (Net)"]

    output {  
        elasticsearch {
            action => "index"
            hosts => [ "localhost:9200" ]
            index => "tax"
        stdout { }

while I run Logstash with this config file, I am getting this message.

I don't know whether my data imported because I can't see an index named 'tax' in my elasticsearch or in kibana.

Please help me solve this.

Note : I am using Ubuntu 16.04 LTS platform.


(Guy Boertje) #2

Did you run this config before you added the ES output? If so did you see output in the console?

If so, you need to read up on the since_db feature.

(system) #3

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