XLSX import

Kibana plugin for import XLSX/CSV file to ElasticSearch

---

Installation

Use this example or manually pick a release

/opt/kibana/bin/kibana-plugin install https://github.com/Orange-OpenSource/kibana-xlsx-import/releases/download/6.3.2/xlsx-import-6.3.2-latest.zip

---

How to use

1 - Select your file and sheet

2 - Configure

- If you want to define your own mapping, you have to use an index name which doesn't already exist.
- Index name must be all lower case.

Use your own mapping

For every field you can choose the type and apply more options with the advanced JSON.
The list of parameters can be found here, https://www.elastic.co/guide/en/elasticsearch/reference/6.2/mapping-params.html

Use a custom Kibana ID

To create a custom Kibana ID with your field values you can use a template with placeholder {fieldname}.
In our example, if I use the following template {ID}-{Nom} this will lead us to the following ID for the first document :

• 1-Toto

You're done !

Advanced settings

In the kibana advanced setting you can find those parameters
Warning : All those options might cause crash or slowing the plugin.

• xlsx-import:bulk_package_size
  Allow you to define the number of json item you want to send per bulk package

• xlsx-import:displayed_rows
  Define the number of rows which will be displayed in the preview

---

development

See the kibana contributing guide for instructions setting up your development environment. Once you have completed that, use the following npm tasks.

• npm start

  Start kibana and have it include this plugin

• npm start -- --config kibana.yml

  You can pass any argument that you would normally send to bin/kibana by putting them after -- when running npm start

• npm run build

  Build a distributable archive

• npm run test:browser

  Run the browser tests in a real web browser

• npm run test:server

  Run the server tests using mocha

For more information about any of these commands run npm run ${task} -- --help.