Importing CSV to elasticsearch using Logstash


(Suryakumar) #1

Hi,

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.

Thanks,
Suryakumar


(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.