nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Import attachments, after project import

Tony Stevenson

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.

Accepted answers

All comments

Renjith Pillai

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.

Pawel Niewiadomski

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

Tony Stevenson

Pawel,

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

Pawel Niewiadomski

Have you found https://confluence.atlassian.com/display/JIRA/Importing+Data+From+CSV#ImportingDatafromCSV-Updatingexistingissues?

And here's a part about importing attachments - https://confluence.atlassian.com/display/JIRA/Importing+Data+From+CSV#ImportingDatafromCSV-Importingattachments

Renjith Pillai

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?

Tony Stevenson

Hi,

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

Lukas Maruniak

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

import

upgrade

attachment