Import attachments, after project import


Some time ago we completed a project import on a now older version JIRA (was 5.0.4, now 5.2.1). The import went well, except that we did not include attachments at the time as the ZIP file they were in was not unpacking, so we thought we could do this later.

Needless to say we cannot eaily do this. What I am looking for is a way to retrospectively add/import attachments for a single project any months after the initial import. I dont really want to have to go through the sandbox(5.0.4), import, upgrade (5.2.1), export, import into live route if I can avoid it. Not only is the project huge, but it also has many thousands of issues and I suspect this would be easily a 1 full week roujnd trip.

Is there a way to do this directly with a SQL query, as I see it all the attachments are refs in SQL anyway.

3 answers

This widget could not be displayed.

You can also try using JIRA Importers Plugin for that, it will allow you to add attachments to issues that already exist.


How exactly? I dont see an obvious option to add attachments.

Well, I think this is only possible, when you want to import attachments together with new issues. If you already have issues present in your project and want to import attachments to them, there's no option for doing so. Please, correct me, if I'm wrong.

@Lukas, IIRC adding attachments to already existing issues in CSV import should work too. You need to include in each row in CSV file an issue key of already existing issue and map it correctly (Issue Key) in the configuration wizard.

This widget could not be displayed.

The attachment data should have come already in database. Do a query on fileattachment table and check whether it is existing. You need to just copy the project directory from old jira home/attachments to the new location. It should work.


I have looked and there is no attachment data for any of the >60k items. I have tried that already. But thanks.

This widget could not be displayed.

Tony, as I said below your issues will be already having atachment data. The files alone will be missing, you just need to copy that. Can you check one of the issues?

Suggest an answer

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

New 5k User Limit and Other Cloud Updates

Hi all! Lauren here from the Enterprise Cloud marketing team.  I have some exciting Cloud updates from #AtlassianSummit that I wanted to share. We want everyone in your organization to be ab...

90 views 0 3
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you