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.
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.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG