Import attachments via CSV file

Barbara Nie July 17, 2020

I am the project admin and I am attempting to import an attachment via CSV file using Jira v8.4.1.

I have the attachment (Flamingo3.png) stored at C:\Temp.

I have the CSV import file stored at C:\Temp. And reads as follows:

Key,Summary,Attachment
OERRSAND-513,Importing the file named test_story_w_attachment_import.csv,Flamingo3.png;https://vajira.max.gov/secure/attachment/Flamingo3.png

Using the External System Import which opens the Jira Import Wizard which displays the message "You are using version 9.1.2". I browse to the CSV file, then click Next. I select the correct Project Name, then click Next. I set up the following mapping:

  • Attachment -> Issue Fields Attachment
  • Key -> Issue Fields Issue Key
  • Summary -> Issue Fields Summary

I do not click any of the checkboxes to Map Field Value. Then click Next.

The Values message displays and I click Begin Import.

The detailed log displays:

2020-07-17 15:30:58,093 INFO - Import started by a434495 using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean
2020-07-17 15:30:58,094 INFO - ------------------------------
2020-07-17 15:30:58,094 INFO - Importing: Users
2020-07-17 15:30:58,094 INFO - ------------------------------
2020-07-17 15:30:58,094 INFO - Only new items will be imported
2020-07-17 15:30:58,094 INFO - 0 users associated with import. All of them imported as inactive, this can be changed after import in User Access step.
2020-07-17 15:30:58,094 INFO - ------------------------------
2020-07-17 15:30:58,094 INFO - Finished Importing : Users
2020-07-17 15:30:58,094 INFO - ------------------------------
2020-07-17 15:30:58,094 INFO - 0 users successfully created.
2020-07-17 15:30:58,094 INFO - Retrieving projects...
2020-07-17 15:30:58,094 INFO - Project ExternalProject{id='null', key='OERRSAND', externalName='null', name='VistA-OERR-Sandbox'} exists and found correctly.
2020-07-17 15:30:58,095 INFO - ------------------------------
2020-07-17 15:30:58,095 INFO - Importing: Versions
2020-07-17 15:30:58,095 INFO - ------------------------------
2020-07-17 15:30:58,095 INFO - Only new items will be imported
2020-07-17 15:30:58,095 INFO - ------------------------------
2020-07-17 15:30:58,095 INFO - Finished Importing : Versions
2020-07-17 15:30:58,095 INFO - ------------------------------
2020-07-17 15:30:58,095 INFO - ------------------------------
2020-07-17 15:30:58,095 INFO - Importing: Components
2020-07-17 15:30:58,095 INFO - ------------------------------
2020-07-17 15:30:58,095 INFO - Only new items will be imported
2020-07-17 15:30:58,095 INFO - ------------------------------
2020-07-17 15:30:58,095 INFO - Finished Importing : Components
2020-07-17 15:30:58,095 INFO - ------------------------------
2020-07-17 15:30:58,095 INFO - Retrieving custom fields...
2020-07-17 15:30:58,095 INFO - ------------------------------
2020-07-17 15:30:58,095 INFO - Importing: Issues
2020-07-17 15:30:58,095 INFO - ------------------------------
2020-07-17 15:30:58,095 INFO - Only new items will be imported
2020-07-17 15:30:58,095 WARN - Found 45 'External issue ID' custom fields. Some issues may be imported twice. Found custom fields: [External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID]
2020-07-17 15:30:58,097 INFO - Importing issue: [externalId='autoid-5029401599775143650', summary='Importing the file named test_story_w_attachment_import.csv']
2020-07-17 15:30:58,173 INFO - Reindexing last 1 issues imported ...
2020-07-17 15:30:58,210 INFO - Reindexing took 36 ms.
2020-07-17 15:30:58,210 INFO - 1 issues successfully created
2020-07-17 15:30:58,210 INFO - ------------------------------
2020-07-17 15:30:58,210 INFO - Finished Importing : Issues
2020-07-17 15:30:58,210 INFO - ------------------------------
2020-07-17 15:30:58,210 WARN - Found 45 'External issue ID' custom fields. Some issues may be imported twice. Found custom fields: [External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID, External issue ID]
2020-07-17 15:30:58,330 INFO - ------------------------------
2020-07-17 15:30:58,330 INFO - Importing: Issue Links & Subtasks
2020-07-17 15:30:58,330 INFO - ------------------------------
2020-07-17 15:30:58,330 INFO - Only new items will be imported
2020-07-17 15:30:58,330 INFO - ------------------------------
2020-07-17 15:30:58,330 INFO - Finished Importing : Issue Links & Subtasks
2020-07-17 15:30:58,330 INFO - ------------------------------
2020-07-17 15:30:58,330 INFO - No issues need to be reindexed.

Something is attached and named Flamingo3.png, but it doesn't open.

bad_Flamingo3_attachment.jpg

Flamingo3_cant_be_viewed.jpg

Any ideas on what may be happening?

Also, if I wanted to put sub-directories named by the issue key (i.e., C:\Temp\OERRSAND-513, C:\Temp\OERRSAND-514) to upload multiple attachments at the same time, how would I specify the path? Could Jira name the attachment the same name as the files stored in the subdirectories automatically?

I'm new to Jira, and this is my first time reaching out to the community with a question, so please forgive me if I went overboard on the details. I appreciate any suggestions offered.

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events