Skip to content

Vert.x web and commandline application to import CSV/XLS/XLSX files into ElasticSearch.

License

Notifications You must be signed in to change notification settings

codingchili/excelastic

Repository files navigation

parser-excel-elasticsearch Build Status

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.

Prerequisites

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

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

├── 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.