要約

In Jira Cloud, exporting up to 10,000 work items using the asynchronous Export CSV feature from the Issue Navigator is supported. 

If you see an export progress bar in the bottom left corner while exporting like the snapshot below, it indicates that you are using asynchronous CSV exports.

For all other export types, such as XML, HTML, WORD, and synchronous CSV exports, exporting up to 1,000 issues at a time is supported.

Keep in mind that exporting up to 10,000 work items can take time, and it may be slower when dealing with many fields. Here are some best practice tips:

• Optimize your JQL query. Refine your JQL query to only include relevant work items. This helps keep the number of work items within the limit and avoids unnecessary data processing.

• Select specific fields. In the issue navigator, you can choose to export the current fields or filter specific fields. To speed up the export and make your CSV file easier to manage, only choose the fields you need.

• Avoid exporting all fields. Using the export options Export CSV (all fields) and Export Excel CSV (all fields) can significantly slow down the process and result in large files that are difficult to manage.

If you need to export more the maximum number of work items, below you can find two workarounds to accomplish this.

Workaround 1 - Export work items by using Google Sheets or Microsoft Excel

From the Issue Navigator (Filters > View all work items), after filtering the work items you want to export, you can click on Apps and select the desired option.

All the detailed steps can be found in the following article:

• How to export more than 1000 issues using Google Sheets

Workaround 2 - Export work items by adjusting URL parameters

Use the pager/start URL parameter to work around this issue by adjusting the index value to export issues from 1001 onwards. You will need to merge the results manually.

It is crucial that you do NOT combine the export of work items through the UI with batch exports using this workaround. Mixing these methods can lead to duplicate or missing work items in the export results. You should conduct all exports using this workaround exclusively. Each batch export has a maximum limit of 1,000 work items.

1. Once you land on the issue navigator page, right-click on the page and select 'Inspect'. This will open the developer tools.

2. Input the desired JQL and run a search to populate the links including the correct JQL in the Export dropdown menu.

3. Click the Export dropdown menu. In the developer tools,

   1. Go to the 'Network' tab, select 'Fetch/XHR'

   2. Enter views in the filter.

   3. Next, refresh the page and select the Export dropdown menu.

   4. Copy the URL from the link field of the corresponding export option in the ‘Preview' tab. Here’s an example:

      https://<instance name>/sr/jira.issueviews:searchrequest-csv-current-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000
      or
      https://<instance-name>//sr/jira.issueviews:searchrequest-csv-current-fields/<filterId>/SearchRequest-<filterId>.csv

4. Export the first thousand work items by visiting this URL in your browser and saving the file when prompted.

5. Now, to export the next thousand work items, append &pager/start=1000 to the end of the URL string to instruct JIRA to export from index 1001 and above. Example:

   https://<instance name>/sr/jira.issueviews:searchrequest-csv-current-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000&pager/start=1000

   ブラウザでこの URL にアクセスし、プロンプトが表示されたらファイルを保存します。次の 1000 件の課題についてもインデックス値を同様に調整します。例: &pager/start=2000

6. エクスポートされた CSV ファイルを開き、必要に応じて手動で統合します。