Get data from excel file into elasticsearch

hello.
I'm try get data from excel file into elasticsearch.
Message:
Error: wrong number of arguments (given 0, expected 3)
Exception: ArgumentError
Stack: /Users/nguyenzuanbka/logstash-7.10.0/vendor/bundle/jruby/2.5.0/gems/filewatch-ext-excel-0.2.0/lib/filewatch/ext/tailbase.rb:33:in initialize' /Users/nguyenzuanbka/logstash-7.10.0/vendor/bundle/jruby/2.5.0/gems/filewatch-ext-excel-0.2.0/lib/filewatch/ext/xlsxtail.rb:10:in initialize'
/Users/nguyenzuanbka/logstash-7.10.0/vendor/bundle/jruby/2.5.0/gems/logstash-input-xlsx-2.1.0/lib/logstash/inputs/xlsx.rb:134:in run' /Users/nguyenzuanbka/logstash-7.10.0/logstash-core/lib/logstash/java_pipeline.rb:405:in inputworker'
/Users/nguyenzuanbka/logstash-7.10.0/logstash-core/lib/logstash/java_pipeline.rb:396:in `block in start_input'
[2020-11-19T13:59:55,875][ERROR][logstash.javapipeline ][main][d01b121d30d447d892f576f323f815b3a8fd97aea112c54320caeaff178dd96d] A plugin had an unrecoverable error. Will restart this plugin.
Pipeline_id:main
Plugin: <LogStash::Inputs::Xlsx start_position=>"beginning", path=>["/Users/nguyenzuanbka/Documents/duan.xlsx"], id=>"d01b121d30d447d892f576f323f815b3a8fd97aea112c54320caeaff178dd96d", type=>"xlsx", enable_metric=>true, codec=><LogStash::Codecs::Excel id=>"excel_9b1313d2-38bd-4907-af99-c0eed3f0bc8c", enable_metric=>true, charset=>"UTF-8">, stat_interval=>1, discover_interval=>15, sincedb_write_interval=>15, progressdb=>false, progressdb_del=>false>

my conf is as below:
input {
xlsx {
path => [ "/Users/nguyenzuanbka/Documents/duan.xlsx"]
start_position => "beginning"
type => "xlsx"
}
}
filter {
csv {
columns => ["date","user_id","transfer","source","destination","price"]
separator => ";"
}
date {
match => [ "date", "YYYYMMdd" ]
}
mutate {
convert => { "price" => "integer"}
}
}
output {
elasticsearch {
hosts => ["localhost:9200"]
index => "excel"
}
}
Any suggestion is deeply appreciated.

Welcome to our community! :smiley:

The xlsx input isn't one that we directly support unfortunately. You might find someone that has used it that can help, otherwise you may need to speak to the developer directly.

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