Import attachments, after project import

Folks,

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

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

Pawel,

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.

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.

Hi,

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

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Posted 14 hours ago in Jira

We want to know what Jira Service Desk apps you're using!

Hi Community! My name is Amir and I’m on the Jira Service Desk product marketing team at Atlassian. Our team would love to understand how you’re leveraging our ecosystem for Jira Service Desk. Wha...

38 views 0 5
Join discussion

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