Parses XLSX files into ElasticSearch using column titles from specified row combined with data in columns on each row. For use with Kibana or other visualization applications, example result using a transaction log in excel format image. The application comes with a web interface to simplify uploading.
The application requires ElasticSearch as its output.
ElasticSearch and Kibana (version 5.2.4) should not require any additional configuration or installation, just download and run from Elastic.
Running the application, filename and index is optional to import using terminal mode.
java -jar excelastic-1.2.0.jar <filename> <index>
When the application successfully connects to the ElasticSearch server, the browser will automatically open a new tab.
If any connection errors occur check that the ElasticSearch listen port matches with the elastic_port in the configuration file. Make sure that ElasticSearch is running by directing your browser at localhost:9200.
Compiling a new fatjar,
mvn clean package
├── configuration.json
web_port (8080) port that the webserver will listen on.
elastic_port (9200) port that ElasticSearch listens to, host is set to localhost.
elastic_host (localhost) address of the ElasticSearch server.
If no configuration file is present a new configuration file will be created using the default values listed here.