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.