topic Re: No option to Export CSV results from dashboard UI app view???????? in Dashboards & Visualizations

No option to Export CSV results from dashboard UI app view????????

r999 — Wed, 05 Sep 2012 15:59:47 GMT

I have created a simple UI dashboard app, which has a simple form based search and is locked down so the user cannot drill down to results and therefore get open access to the search bar.

However i would like them to be able to export the table of results to a CSV.

Unfortunately the Actions menu only has Print and a greyed out PDF option as the PDF server is not configured. some answers post seem to suggest this is not pssible? can someone confirm?

I am using Advanced XML, cann i not add in a exportCSV module somehow?

Thanks

Re: No option to Export CSV results from dashboard UI app view????????

sideview — Wed, 05 Sep 2012 16:08:13 GMT

1) There's an app called Splunk for Excel Export that gives you a module called ExcelExport.

It overdelivers in this case, because it sends headers that office recognizes such that excel will itself open directly, and the data will stream down into Microsoft Excel directly (oooh).

2) If you're just after a simpler CSV export, I think in Core splunk you have to use the TitleBar module, and you have to make sure to place that TitleBar module into a place in the hierarchy where it has access to the given dispatched search. ie place it as a sibling of your JobProgressIndicator or FlashChart. At any rate no higher than the deepest module "that needs a search to be running". And it'll bring along with it the pagetitle and the actions menu and all of the options in the actions menu, less whatever you can whack away or grey out by setting some params to false.

3) Or you can use Sideview Utils, which has a module called SearchControls. You have to be just as mindful of placement in the XML hierarchy as with TitleBar. However with SearchControls you (the view creator) can choose from lots of buttons and menus. Basically it's the stuff that the JobStatus module can do, plus export. And you can control exactly what buttons and menus SearchControls has, and in what order.

So if you just want it to put an export button on the page you would do

<module name="SearchControls">
  <param name="sections">export</param>
</module>

If you go with #3, make sure to get Sideview Utils from the sideview site and not from Splunkbase. The version on Splunkbase is really old and among many other differences, it doesn't have the SearchControls module.

http://sideviewapps.com/apps/sideview-utils/

UPDATE -- as jonuwz pointed out, there is a module called Export in the core Splunk UI and you can use that to give you a simple export button that will bring up the little export controls when clicked.

Re: No option to Export CSV results from dashboard UI app view????????

jonuwz — Thu, 06 Sep 2012 21:35:59 GMT

Just stick the export module within the search with your simpleresults table.

<module name="HiddenSearch" layoutPanel="panel_row1_col1" autoRun="True">
  <param name="search">* | head 10 | table sourcetype source _time</param>
  <module name="Export">
    <param name="exportType">result</param>
  </module>
  <module name="SimpleResultsTable"/>
</module>

Edited to make SRT + Export siblings as suggested by Sideview

Re: No option to Export CSV results from dashboard UI app view????????

sideview — Thu, 06 Sep 2012 21:49:39 GMT

I forgot they added an Export module. I'll update my answer too. Btw there's no need to have the SimpleResultsTable nested inside like that. Just have the Export and SimpleResultsTable be siblings at the same level.

Re: No option to Export CSV results from dashboard UI app view????????

koshyk — Mon, 17 Mar 2014 17:00:50 GMT

You could save the search as a "Report" rather than a "Dashboard".
Report gives option for Export as CSV,XML, PDF etc..

Re: No option to Export CSV results from dashboard UI app view????????

mark_chuman — Fri, 29 Jan 2016 15:07:14 GMT

what do you mean by stick the export module within the search? Just paste it in after your search after a pipe?

Re: No option to Export CSV results from dashboard UI app view????????

kranthimutyala — Thu, 14 Nov 2019 01:19:25 GMT

where i need to add this module exactly in the xml, because i getting warnings

Re: No option to Export CSV results from dashboard UI app view????????

niketn — Thu, 14 Nov 2019 01:24:26 GMT

@kranthimutyala you are referring to a post from 7 years ago. Advanced XML stands deprecated from several releases 6.4 or even prior. Please create a new question with your issue for the community to assist you better.