Loading a 3 column xlsx file,
column 1 : "date" (date)
column 2 : "downloads" (integer)
column 3 : 'daily downloads' (integer)

I chose date for c1 mapping, double (or float in an other test) for c2 et c3.
Data is loaded:

  {
    "_index": "myindex",
    "_type": "doc",
    "_id": "0eg3K2MBlI2vUD8Ex95q",
    "_score": 1,
    "_source": {
      "date": "2015-01-11",
      "downloads": "503",
      "daily downloads": "53"
    }
  },

But when I create the kibana index I get the following fields:

daily downloads | string
daily downloads.keyword | string
daily_downloads | number

Then in the vizualusations, I can only use "daily_downloads" as numerical field but this field is null...
By removing the " " in the column header, everything is fine.

I don't know for elastisearch but for Kibana, "number" is enough when you customize the mapping.

Or select by default the first sheet of the input file

Hi,

First of all thanks for this plugin.
Now I was able to install the nice plugin on my Kibana 5.6.2 using the 5.6.5 build by changing the package.json. Installation was successful and restarted the Kibana with the XLSX plugin on my menu.
However i am not able to load any CSV/xlsx files and getting an error.
Uncaught ReferenceError:XLSX is not defined(../bundles/xlsx-import.bundle.js?v=15543:27)

I suspect this is cause of the version mismatch, Is there anyway i could run this for the v5.6.2?

Appreciate a needful response.

Hello,
I have 2 problem ;

Firstly, I tried to import 1.800.000 document with 30 field then I got this error: "Page not responding" (I think It s a kind of timeout issue)

Secondly, I got a mapping error like that: "Something wrong happened, check your advanced JSON", but I did not do any change in advanced JSON part.(just click next and import) My data is:

Thank you.

Is there a fault date format,which the program will detect automatically the fields ,because by default it is considered as text . on setting custom mappings , as date , it throws the following error.
failed to parse [ts] Invalid format: "2015-Jan-01 01:00:00" is malformed at "-Jan-01 01:00:00".
Advanced JSON also failed .Could anyone suggest the correct format of Advanced JSON.

Thanks for the effort team.This can turn out really valuable

with respect to GDPR :-)

Hi,

In the mapping tab, when i choose a text-typed field, i'd like have options (like checkbox or radio button) to specify if the field :

• must be aggregatable (fielddata: true)
• must have a keyword multi-field ({fields: {"keyword": {"type": "keyword"}}})

This doesnot work with latest version, have tried it on both 6.2.4 and 6.3.1 no luck. Think so version upgrade is required..

as required by elasticsearch (elastic/elasticsearch#6736)

Hi
I tried to load UTF8 files, and I got some issues with French accents.

P.

Is there any way to import a field containing nested object, for example a cell containing {"field1":"value1","field2":"value2"} imported to a nested object type???

remplace most of the angularJS code by EUI react components.

License file seems missing from the repo, see https://help.github.com/articles/licensing-a-repository/

I was checking if this repo is compatible with kibana 6.6.0. So, i forked it, made few adjustments (wzulfikar@1f726bd), tried to upload csv, and everything works.

The thing is, to make it works, I had to install react-dom. Without installing react-dom, kibana-plugin install will fail:

Module not found: Error: Can't resolve 'react-dom/server'...

The error was triggered because below ReactDOMServer isn't resolvable:

Upon checking package.json, I realized that react-dom is not installed. I went further to see if react-dom was installed transitively and it turns out that it's listed in elastic/eui, but as devDependencies (elastic/eui#L145).

My question is, is this error expected (due to lack of react-dom in package.json), or kibana-plugin is supposed to install devDependencies (so that react-dom is available via elastic/eui)?

Thanks for the awesome plugin, btw :)

• edit 1 (Feb 27, 2019): add screenshot

Here's additional info to add more context.

• my 6.6.0 branch: https://github.com/wzulfikar/kibana-xlsx-import/tree/6.6.x
• zip file: https://github.com/wzulfikar/kibana-xlsx-import/releases/download/6.6.0/kibana-xlsx-import-6.6.0-1.zip

And here's images on how it looks like in kibana 6.6.0.

importing csv:

csv imported:

Hi,

Just wanted to know whether the plugin version 6.4.2 work with 6.4.3 Kibana/ES setup by making changes in package.json?

Just to save 2 minutes :)
Should be an option (because of possible multiple date fields in an index)

Just to avoid to upload useless data...

Hi,

Are there any plans to move to the support of 7.8.x or 7.9.x Kibana releases ?

How to use {} for dummies like me :)

Hello,

I'm not able to install the current version with version 6.2.4. Is there a new version soon ?

Best regards

PLugin title (XLSX Import) is not really a title and not aligned with any Kibana title (lot of different titles in Kibana btw)
In French replace "convertir" by sthg more accurate
(?) following "ID dans elasticsearch" is too big compare to space left between lines
Put some space betwwen what you can change eg mapping and mandatory fields