Importing attachments stored in Google Drive into Jira Cloud using CSV External System Importer
プラットフォームについて: Cloud のみ - この記事は クラウド プラットフォームのアトラシアン製品に適用されます。
要約
To import attachments into Jira Cloud, the attachments can be located anywhere that your Jira Cloud site can access.
ソリューション
In order to make this work, the files need to be publicly accessible just before beginning import. Once the import is finished, remove public access to the files.
The Attachment column in the CSV file should follow this syntax :
| Attachment https://drive.google.com/uc?export=download&id=<file ID between the /d/ and /view from the original share link> |
|---|
How to get this download Link of the attachment?
In Google Drive, Click on the file you want to attach to an issue in Jira Cloud, then click on "Open in a new window". The URL of the file will be something like this:
| https://drive.google.com/file/d/1s1XQcrI8HdF51CeUxR3AiEAv6xyj779j/view |
|---|
The CSV file to import an issue and attach test.png to the issue from Google Drive will be as follows:
Summary,Attachment
"Test issue",23/Feb/23 6:18 PM;test.png;https://drive.google.com/uc?export=download&id=1s1XQcrI8HdF51CeUxR3AiEAv6xyj779j
How to import multiple attachments from Google Drive into issues?
Summary,Attachment, Attachment 2
"Importing files stored on google drive using CSV import","file1.txt;https://drive.google.com/uc?export=download&id=1QU3PD6ywNuTtOIrjR_3-8YO3R48AV","file2.csv;https://drive.google.com/uc?export=download&id=1AW1r1Pt1erSd-QnGxpPL1bhf2xNS1x0P"関連ドキュメント
Importing your CSV file
Importing attachments into Jira Cloud using CSV External System Importer