Export to csv

[tomrade]

is csv export planned for KIbana 3?

[rashidkpc]

It would be a nice-to-have, but is not on the current roadmap

[zenrockstarr]

I've been working on a panel to handle import/export logs. The biggest
hurdle was browser sandbox limitations. Since Kibana3 is now all client
side, how do I export a file say larger than 32MB? HTML5 has some hooks
into this, but I'm interested if anyone else has tackled this problem.

As a work around I've exposed a php server to serve up the files instead of
javascript.

Kevin

[johntdyer]

Some sort of export seems like a must have... Why is this not on the roadmap?

[dadoonet]

See also #303

[ianneub]

👍 I'd love to see this too at some point.

[artgreen]

I like the progress of Kibana. However, the ability to export the results of a query is key for business users. I'll see if I can somehow modify the code to get an export working, but without it, Kibana is really just pretty.

[willejs]

+1 on a feature request

[sakalajuraj]

+1

[sveinng]

+1

[imanviii]

+1

[ShoeKSU]

This is the only reason I haven't rolled Kibana3 into Production and have stayed with Kibana2 thus far.

+1

[artgreen]

@zenrockstarr I wound up at the same hack you did. I had the idea of scraping the export data from results table but, HTML5, it hates me. I just don't do much with modifying the DOM stuff and stick to frameworks - maybe someone else could figure out how to grab the data in the table and offer it for download.

[artgreen]

Or maybe open a new window and feed the results to be exported into the new window in the specified export format. The user can save the export from the browser or maybe copy and paste.

[rashidkpc]

It might also be possible to write an elasticsearch plugin to make this happen

[ShoeKSU]

For our setup, we have to be able to export the results to provide them to needed parties on request, in either PDF or CSV formatting.

I know I saw a gist: https://gist.github.com/clintongormley/2049562

However, its a perl script that must be configured with your query before each run, which is why I prefer just setting up Kibana2 instead. The same type of setup that Kibana2 uses to create a CSV of the query results is more in line with what I'd be looking for, though I know it can't be directly ported to K3. If an elasticsearch plugin existed to perform this function and that plugin could be called from a Link on a panel, Likely tied to the Table Panel somehow, to export the results of the query, that would be great. Need to get my coding skills back up to date.

[chadyj]

+1

[Adrellias]

+1

[joshlove]

+1

[bobrik]

I made csv export for histogram panel, pull request is here: #585.

[robbydyer]

+1
Kibana3 cannot replace Kibana2 for many people until exporting is possible.

[delfuego]

It'd be SO NICE to see the ability to export a given log view's data....

[N-Mi]

+1

I recently installed for the first time Logstash+Kibana3, and after a network outage today, I just discovered I can't export related log events to my issue tracking :(

Didn't ever thought this kind of feature could be missing. CSV or plain text export would be very appreciable.

[jalogisch]

+1

The ability to export Views and Data is fundamental - without its just a "fancy" tool without real world usage (to include in the Workflow), just view Data and not work with them.

[bmetge]

+1

[gvaysman]

+1
Exporting the All Events table to CSV is badly missing. It is fine to have export size limitations, np.

[robbydyer]

I wrote this for our organization as a stop-gap until exporting is implemented in Kibana3: https://github.com/robbydyer/stash-query

[ruckc]

Wouldn't it make sense to turn this functionality into and ES plugin on the
query API? is that even possible to hijack the query api with a different
result format?

Curtis Ruck
Anytime: 210-857-1126

On Fri, Dec 20, 2013 at 1:33 PM, Robby Dyer notifications@github.comwrote:

I wrote this for our organization as a stop-gap until exporting is
implemented in Kibana3: https://github.com/robbydyer/stash-query

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/205#issuecomment-31030967
.

[bobrik]

@ruckc, I remind you about use-case with querying 1 year (3Tb) of data. What do you think is reasonable?

1. Show results in kibana and make it available for export to csv immediately.
2. Show it in kibana and make another request to make it exportable. Well, probably more than one request, since http proxies are not happy with looooooooooooong requests. I case of multiple requests you will need to do some processing in js anyway.

[w33ble]

For those interested, Kibana 4 allows CSV exporting

[tyrannosaurus-becks]

+1

[simianhacker]

👍

[w33ble]

o((^▽^))o

[spalger]

👍

[pstrutt1]

I'm new to the ELK stack, so I'm happy to eat my words if I'm wrong, but Kibana 4 Beta 1 does not appear to support the export of query results, only the results behind 'visualisations' (histograms etc.), which are of no value to my customer. The export of query results is a feature that people are screaming for (see above), but it does not appear to have made it into this release. Is it due to appear in the next beta update?

[w33ble]

@pstrutt1 I'm not sure I understand what you're asking for. The CSV export is the data in the visualization spy, which are the query results formatted in a coherent way. Is it that you're missing additional fields, or _source data, or possibly something else? You can see the raw JSON response (and now to copy it directly to your clipboard), but I doubt that's what you're looking for...

[pstrutt1]

Hi Joe. My issue is probably due to my lack of experience with Kibana. I
have imported some syslogs so I have data in Elasticsearch. I'm using the
default Kibana search screen with a bar chart 'visualisation' which tells
me how many hits have been returned for my query. Below this are my query
results. Fine so far. I want to export the query results, but there is no
'Export to CSV' under the query results. 'Export to CSV' does appear under
the Visualisation 'spy', but this exports the result counts - how many
documents returned, not the query data. I can see the JSON response, but
you are right, this is not what I want (although it does include the data).
How do I export the query result data formatted in a coherent way?

Cheers.

On 3 November 2014 19:06, Joe Fleming notifications@github.com wrote:

@pstrutt1 https://github.com/pstrutt1 I'm not sure I understand what
you're asking for. The CSV export is the data in the visualization spy,
which are the query results formatted in a coherent way. Is it that you're
missing additional fields, or _source data, or possibly something else? You
can see the raw JSON response (and now to copy it directly to your
clipboard), but I doubt that's what you're looking for...

—
Reply to this email directly or view it on GitHub
#205 (comment)
.

[w33ble]

The CSV export is only what's used to generate the visualization, so if all you're showing is the total count (the default), that's all it will export. If you start adding other aggregations to the visualization (terms agg with memory usage, date histogram with a timestamp, etc), the exported CSV data will contain all those breakdowns (and the visualization will also be more useful). Does that help?

[pstrutt1]

Hi Joe, I can see the raw JSON response contains the query results; it's
the 'formatted in a coherent way' bit that I'm struggling with. How would I
do this in a way that would enable me to then export them to CSV?

Cheers.

On 4 November 2014 15:58, Joe Fleming notifications@github.com wrote:

The CSV export is only what's used to generate the visualization, so if
all you're showing is the total count (the default), that's all it will
export. If you start adding other aggregations to the visualization (terms
agg with memory usage, date histogram with a timestamp, etc), the exported
CSV data will contain all those breakdowns (and the visualization will also
be more useful). Does that help?

—
Reply to this email directly or view it on GitHub
#205 (comment)
.

[w33ble]

It really depends what you're trying to export. Again, whatever aggregation data (from the sidebar) you add to the visualization you'll see in the CSV. If you add nothing, you just get a count. If you add other parameters, you'll see those in the CSV too.

[penguincp]

In my fork https://github.com/penguincp/kibana/wiki/aggregation-histogram;-chart-and-raw-data-csv-export;-hierachical-indices (which is based on kibana3), I implemented aggregation histogram and supported "export to CSV". There are two modes of export: export the data that makes up the chart and export the raw data -- raw data is retrieved from ElasticSearch with a query that is without the aggregation part. I find it useful when I need to do detailed analysis of logs.

[moonlitdelight]

I've been experimenting on Kibana 4 Beta 3 and it seems like the "export CSV" function per panel is not what I need. I've found this though, https://github.com/jprante/elasticsearch-csv
I'm just going to create a HTML button on my Dashboard that will trigger an ajax call to {mynode/index/type/}_search_csv/{queries}, where queries are the filters applied on the dashboard.

[lauramoraes]

@moonlitdelight: did you manage to create a button on your dashboard? how would it work? can you share it with us?

[penguincp]

Sure. Please check http://perfspy.blogspot.com/2014/11/custom-kibana.html,
the source code is https://github.com/penguincp/kibana, branch 3.0agg.
please note, the TODO paragraph mentioned in the blog:

TODO
Right now, the raw data is first retrieved from ElasticSearch and then
saved to a CSV file. When there is a lot of data, export will fail.
Retrieving and saving data should be done in a streaming fashion.

Thanks.

2015-06-01 22:43 GMT+08:00 Laura Moraes notifications@github.com:

@moonlitdelight https://github.com/moonlitdelight: did you manage to
create a button on your dashboard? how would it work? can you share it with
us?

—
Reply to this email directly or view it on GitHub
#205 (comment).

[nave91]

👍

[w33ble]

FYI, those interested in exporting entire documents from Kibana, and not just the aggregation results, should keep an eye on #1992 - this issue is closed and giving it a +1 isn't going to accomplish much ;)

[e11137]

+1

[Tak-MK]

+1 to export to csv / txt / anything

[nicoschwartz]

+1 to export to csv !

[hectorj2f]

+1

[keithballdotnet]

+1

[akras14]

+1

[janakg]

Hi all, We have written a chrome plugin, it injects the CSV export functionality in Kibana Discover tab. We know Kibana team is trying to solve this problem in a holistic way, so we thought this quick hack might help users like us. Let us know, what you think?

http://minewhat.com/blog/elasticsearch-csv-exporter-for-kibana-discover/

[janakg]

We have updated the CSV export plugin (v0.2) to work with Kibana 4.1.x
http://minewhat.com/blog/elasticsearch-csv-exporter-for-kibana-discover/

[ghost]

the plugin is not working with kibana 5.x :( :(