Kibana plugin for import XLSX/CSV file to ElasticSearch
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
assets update readme ressources Apr 20, 2018
public Fix icon library, 6.4.1 Oct 25, 2018
server handle errors on advanced JSON typo May 2, 2018
.eslintrc Initial commit Nov 24, 2017
.gitignore fix Jan 19, 2018
LICENSE Create LICENSE Mar 16, 2018
README.md Update README.md Oct 1, 2018
TRANSLATION.md Initial commit Nov 24, 2017
gather-info.js Initial commit Nov 24, 2017
index.js fix 6.3.1 and placeholder for mapping Jul 12, 2018
package.json 6.5.1 Dec 6, 2018

README.md

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.