Hello,
We have a requirement to export data for an audit.
The auditors have specified a list of data columns that must be in the report.
We've built the filter for the report, but for whatever reason the export to CVS and Excel will not export exactly what is in the filter output.
Also, the number of records exceed 1000.
In JIRA server version the filter will tell you exactly how many records are pulled. To export records above 1,000 I just added this to export URL:
?jqlQuery=&tempMax=1000 (for first 1,000)
?jqlQuery=&tempMax=1000&pager/start=1000 (for 1,001-2,000)
?jqlQuery=&tempMax=1000&pager/start=2000
?jqlQuery=&tempMax=1000&pager/start=3000
For whatever reason the cloud version won't give me the total, won't export the columns I specified in the filter, and the old method of pulling records above 1,000 doesn't seem to work.
Hi @Jerry Yen
First, a disclaimer that I do not work for Atlassian or any marketplace vendor. I am just another Jira user. With that out of the way...
I do not believe exporting that many issues is possible with Jira Cloud's built-in features.
For some workarounds please consider:
Kind regards,
Bill
So it looks like there's the option of exporting to Excel (app) and Google Sheet, and you can specify exporting 1,000 at a time:
Export over 1000 results in Jira Cloud | Jira | Atlassian Documentation
I need to figure out the right URL to use.
But there's still the issue of export to CSV/Excel (not app) is not exporting the columns in my filter. I don't understand why this is a problem. Common sense dictates that if you built a filter with specific data columns, you expect the export to contain those exact data columns.
The very idea that customers have to pay for 3rd party plugin to export data seems ridiculous to me. If the feature is not avail natively then Atlassian should buy the plugin and make it a standard feature.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Regarding the filter and columns, are you selecting to export the filter fields or something else?
Also, I recall a problem where a filter can be updated and not detect the current column configuration when the last thing to change is the columns. The way to fix that is:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This worked! Thank you!
Interestingly, the export to Excel (app) and export to CSV (in 1,000 record chunks) both had issues, but between the two I was able to obtain the data needed.
Had to export the data to CSV in 7 chunks, manually merge then copy/paste the missing data from one report to another, but I got it working.
Moving forward, I think this task might be easier done from looker. Just need to make sure Looker is importing the right data.
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.