Hi,
I need to export some 20k+ issues into xls or csv .
i tried groovy script of script plugin, it goes into timeout aftr 4k issues, then i tried putting java code itself into JIRA, i was able to get around 8k and then timeout.
Is it related to 'jira.index.lock.waittime' or is there anything else which i am missing.
getIssueList from JIRA Command Line Interface (CLI) produces a CSV file based on your JQL query. It is not limited as it uses a paged interface.
I really should have said that - the paging in the CLI handles the "split it up into small chunks" for you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SQL for JIRA can do the job. You can use just the same JQL query embedded in SQL to filter the issues. It also supports exporting to CSV on the JIRA Server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You should perform a batch call similar to: call CSVWRITE ( 'C:/MyFolder/MyCSV.txt', 'select * from ISSUES where <your filter>' ); logged in as administrator in the built-in web database console.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Better Excel Plugin exposes an easy to use Excel API to render real Excel files from JIRA issues:
public interface XlsApi { /** * This is a convenience method to render Excel spreadsheets from single issues. * @see #getXls(String, String, List, Map) For parameters, see the API call that supports multiple issues. */ RenderingResult getXls(String templateName, String title, Issue issue, Map additionalModel); /** * Renders Excel spreadsheets from the passed issues using the specified template. * @param templateName identifies the template to use. Example: issue-navigator.xlsx * @param title the title for the resulted Excel spreadsheet. * @param issues the issues to be exported in the Excel spreadsheet. * @param additionalModel additional model objects that are passed to the Excel spreadsheet renderer. They can be used in the template code as regular Velocity variables. (This is purely optional and may be just an empty map.) * @return the result object containing the Excel spreadsheet filename and its actual bytes. */ RenderingResult getXls(String templateName, String title, List issues, Map additionalModel); }
It does not limit the size of the issues argument, so you can pass in any number. Just write some Groovy scripts based on this tutorial, and experiment.
Beware though that if you use a complicated Excel template, it may be resource intensive to render the result.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
JIRA imposes a limit of 1,000 issues by default for a good reason - the process chews up resources for each issue and it quite simply overloads your system if you try to do too many.
There are ways to increase the limit, but you are always going to run out of resources at some point.
Your only options are
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.