It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

CSV Import - Attachment URL Not Importing Edited

I have run several CSV imports with success. I added an attachment column and mapped it using an https:// link to an item in our Google Drive account. It imported but came across as "Open" or edit with no attachment. Any ideas?

 

Thanks so much!

 

3 answers

1 accepted

0 votes
Answer accepted
edwin Community Leader Dec 20, 2017

Hi Sarah,

The attachments might be password protected, hence JIRA can't access them. Are you using Server or Cloud?

Cloud. 

I assumed that since I created the test ticket for myself and didn't log out, I should be able to click on an attachment link I created since I don't need to "log in" to be directed to the url. 

edwin Community Leader Dec 20, 2017

I meant on the Google Drive side.

Can you see the attachments on your browser using the URL and not logging in?

I see. So if I open a new browser, not logged in to Google, then no I cannot see it. It takes me to the google log in screen.

That won't work then. You can download them locally and update your attachment links as so. Either in the current directory

file://file.jpeg

or a path

file:///folder/file.jpeg


https://confluence.atlassian.com/cloudkb/importing-attachments-into-jira-cloud-using-csv-691011888.html

 

Bummer! Ok thanks so much for your help!

@edwin

I am facing the same issue, Could you please help me how could I update the file/ attachment Link to the path: file://file.jpeg?? 

I am not clear to what can be done so I could have a successful Imports with Attachments. Please Advice!!

I am facing the same issue, Could you please help me how could I update the file/ attachment Link to the path: file://file.jpeg??

Tried by uploading the files through Google Drive and by the below process.. Both are throwing the same error:

  1. Attached all the Attachments into a test issue in Jira
  2. Copied the URL's of attachments
  3. Pasted the URLS in the Attachment Column in my CSV File 
  4. Imported them through CSV importer

 

 

edwin Community Leader Jan 26, 2018

Hi Sravan,

This process is not possible when importing from Google Drive. You'll have to get the files to your local computer and then you can use the file://file.jpeg.

Like Julie Prolhac likes this

Edwin,

This has worked: Thank you! we are migrating huge data.. about 10,000 issues with more than 2000 attachments in it.. Is there a way to bulk import the attachments? saving each and every attachment locally for 2000 attachments will take it for ever.. I was looking if there is any workaround for this..

 

Please Advice.

Thank You!! 

@Sravan Kumar @edwin : could you please help me as well? I am trying to upload several JIRA tickets using Service Desk cloud in csv format with attachments from local computer. Edwin you presented the solution for files located in current directory
file://file.jpeg
or a path
file:///folder/file.jpeg

But I don't manage to do it. In the csv file I am using following link format to a file located on my computer. For example:
file:///C:/Users/Julie/Documents/81_JIRA/image.jpg

What am I doing wrong?

Thank you so much in advance!
Julie

edwin Community Leader Jul 05, 2019

Hi @Julie Prolhac ,

The URI looks correct for a Windows environment. I'll have to test an actual import on Windows to confirm.

Have you tried from the same directory?

Hi @edwin ,

Yes i tried from the same directory where the ticket upload csv file was. It is located in C:/temp and the file iiself is user.png. I tried both entries:
file:///C:/temp/user.png
file://user.png

but both returned following log:
Attachment file not found or not readable, skipping: /data/jirastudio/jira/home/import/attachments/C:/temp/user.png

Would you know what i am doing wrong? any way to change the first part of the path that is added automatically? /data/jirastudio/jira/home/import/attachments/

Thank you for your time!!

Julie

edwin Community Leader Jul 09, 2019

@Julie Prolhac ,

It's not possible to remove the first part of the path. This is the path where Jira is looking for attachments. Not where the CSV file is located.

When you specify

file://user.png

It's looking for

/data/jirastudio/jira/home/import/attachments/user.png

So you'll first import the attachments and then reference them in the import. 

Understood now! thank you @edwin !

Like edwin likes this

@edwin - I did try placing the file under the location 

"/data/jirastudio/jira/home/import/attachments/"

but still i am getting the Exception as File not found Exception. My Jira is in cloud hosted.

Does that mean i have to load all my attachments to the cloud server where Jira is installed? 

I need all attachments to be uploaded as part of CSV import, from my local system and not from cloud. Any options would help.

Thanks,

Manjunath

@Manju A if using jira cloud atlassian hosts your instance and you cant access the server.  

I got this working by hosting all the file on a public site that reachable with no authentication.  Once imported, make sure to delete the files from this site

And when i say public site, i literally mean anyone in the world can see the attachments if they have the URL. 

Store the attachments locally did not work for me since we are on a work domain and Jira cant authenticate to it so they could never access the file locally on my machine. 

Manju A I'm New Here Sep 20, 2019

Thanks Julian for the quick response. Publicly available site is Scary and cant go with it since Org. policy doesnt allow it.

I was thinking another option "using Jira API" to upload files. Would that work? Before I can invest time on this API approach would like your blessings :-)

Appreciate your response.

Manjunath

I have never used the API to do this.  We have sharepoint here in our org and we created and external document library that allowed anonymous access which worked for our needs.  Sorry i cant help more on the API side. 

Hi Edwin,

Here we are migrated jira issues from one cloud instance to other,we've mapped the attachments column also,import done ,attachments are attached to the issues but i'm unable to view the attachments, Here i'm attaching the screenshot for your reference,Please provide any solution to migrate the attachments or to view the imported attachments.image.png

edwin Community Leader Mar 03, 2018

Hello,

You'll have to download the attachment files separately and then do a import. They won't be brought in with the CSV import. Let me know if that helps.

Screen Shot 2018-03-03 at 19.52.00.pngScreen Shot 2018-03-03 at 19.52.17.png

Please add "Anyone" group to Browse Project permission in Permission schema and import the  CSV format. So while importing it will not check any authentication and download the attachment from Source and upload into Target server. I have done it and it is working fine.

 

Regards

Ravi

This did not work for us.  The attachments are uploaded but they are not viewable.

Not sure if this solution works for everyone, but we used an Extranet SharePoint site. This site had general public access so everyone could view the site.  Once we mapped out attachment URL to that public site, and before importing i checked with a personal account i could see the attachments without logging into the Sharepoint site, we imported and it worked just fine.    They key is even if its a public site, we found that the site needs no authentication at all for the attachments to import as expected.  If you have to log into a site to access the attachments or download them, then it may not work.  If you can download them without logging in, then it should work. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

872 views 6 24
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you