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!
That won't work then. You can download them locally and update your attachment links as so. Either in the current directory
or a path
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:
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..
@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
or a path
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:
What am I doing wrong?
Thank you so much in advance!
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:
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!!
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
It's looking for
So you'll first import the attachments and then reference them in the import.
@edwin - I did try placing the file under the location
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.
@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.
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.
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.
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.
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.
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 ...
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