Page 1 of 1
experting to excel
Posted: Mon Nov 02, 2015 2:24 pm
by juanie
Hi
Not really sure we can do this but I need to be able to export a search to excel. I didn't see anything about this in documents or even here
Thanks,
Re: experting to excel
Posted: Mon Nov 02, 2015 2:49 pm
by hsmith
Exporting to Excel is not supported at this time, but there are plans to support this in the future. I am unable to provide an ETA for this, however.
Re: experting to excel
Posted: Mon Nov 02, 2015 3:06 pm
by juanie
OK, What can it export to?
Re: experting to excel
Posted: Mon Nov 02, 2015 3:45 pm
by hsmith
Right now, since stuff is in the 'works' for reporting the best solution that we can offer is querying the server for raw data, and then doing what you please with it.
The method for this would be something like this:
On your NLS GUI, do a query as you normally would.
Once results are returned for that query, you can hit the "i" button at the top of the results to get your query in a form that you can put into a bash script.
Once you put this in a script, you can run that script to get raw data to do whatever you would like with.
I suggest you write a script that would get whatever information you found useful from the output, and export it to whatever kind of file you would like.
I know this is a clunky solution, but it's what we are able to provide for now as the reporting is still in the works.