要約

The objective of this KB article is to offer a solution for exporting the complete Atlassian Teams and Members data from your Organization:

While you can currently access this data from the respective Team pages, there is currently no built-in option to export all the Teams within your Organization. A feature request has been submitted ( JRACLOUD-82782 - Getting issue details... STATUS ) to potentially include this capability in the future. Meanwhile, it is advisable to consider alternative methods for exporting this information.

環境

This KB article is specifically designed for Cloud environments and is applicable to a wide range of Atlassian products, such as Jira Software, Jira Work Management, Jira Service Management, and more.

Prerequisites

Before diving into this article, ensure you meet the following requirements:

1. Basic Computer Science and Programming Knowledge: To effectively follow the content presented in this article, it is essential to have a foundational understanding of computer science and programming concepts. Familiarity with basic terms, logic, and syntax will greatly enhance your comprehension.

2. Python Installation and Execution: Make sure you have Python installed on your system and can execute Python scripts. The ability to run Python scripts will be necessary for implementing the concepts discussed in this article.

ソリューション

To address this, we propose an alternative solution utilizing the GraphQL API and the teamSearchV2 query to search for Teams and Members data. Detailed documentation for this approach can be found in the provided links. As indicated on the Visibility of Atlassian teams information page, Atlassian Teams are only visible to individuals with accounts in the same organization and access to the site where the team was created. It is important for users to bear this in mind while employing the provided script. The script will export the identical Teams visible on the UI Teams page, employing a pagination mechanism to export 24 Teams per request until all pages with Teams have been processed, just as it is done in the UI.

Step 1: Download Python and Verify Installation

If you haven't installed Python yet, you can download the latest version from the official Python website. After installation, open a command prompt or terminal and use the following command to verify the installation: python --version

Alternatively, if you're using Python 3, you may need to use the 'python3' command instead of 'python': python3 --version

This should display the installed Python version:

Step 2: Download the Python Script

Download the Python script from this link: teams_export_with_members.py

Step 3: Execute the Python Script

Open a command prompt or terminal, navigate to the script's directory, and run it using the following command: python teams_export_with_members.py

For Python 3 users: python3 teams_export_with_members.py.

The script will sequentially request the following information:

1. Atlassian Account username. This is the email address used to log in.
2. API token. If you do not possess one, you can generate it following the instructions provided here: Create an API token.
3. Organization ID. What it is the Organization ID and where to find it.
4. Site ID. How to find Cloud Site Id.

After entering this data, the script will fetch Teams and Team Members, generating a CSV file in the same folder where the script is executed upon completion.

If you're interested in previewing the structure of the CSV output file, you can download a sample generated here: Teams-2024-02-23_13-59-50.csv