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

Importing attachments from CSV

I am trying to import attachements from a csv file exported from Redmine. I used concat in my sql query to insert the correct url of the attachments. When I use the CSV importer it gives me a 404 error saying it cannot download the attachments.

#CONCAT('http://redmine.localdomain/', attachment_files.disk_filename)  AS attachments,

I am also trying to import all documents from Redmine into Jira. Can someone provide some insight into that process as well? Thanks.

1 answer

1 accepted

Well, if you get HTTP/404 during import I guess the URL-s you produced are wrong.

Looking at the concat you used I guess attachment_files.disk_filename is relative to the installation directory of Redmine which may be totally different than the URL Redmine is available at.

What you need to produce is a correct URL that you can use in your browser to reach the file.

Ok. I have over 1800 attachments and they have subfolders as well. For example redmine.localdomain/200, redmine.localdomain/50, redmine.localdomain/700 etc. Would it be more efficient to just create a SQL script which imports all required fields into the fileattachment table in the Jira database? I can then set the file location and move the attachments over. Thanks.

Don't do it with SQL, there's all sorts of hassle and risks around doing it that way. I'd highly recommend either correcting your paths as Pawel suggests, or using the CLI as Bob said.

Thanks guys. I appreciate the quick responses.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published Apr 09, 2019 in Portfolio for Jira

Portfolio for Jira 3.0 is here!

The wait is over... Portfolio for Jira Server and Data Center 3.0 is now officially here! Platform releases offer Atlassian an opportunity to shift our strategy, make bold predictions about t...

1,381 views 14 26
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