issue history import csv

Is there a way to import issue history from Redmine using the CSV import? Thanks.

3 answers

1 accepted

You can achieve this only using experimental JSON (beta) importer, here's a sample snippet with history changes:

	"users": [
			"name": "pniewiadomski",
			"fullname": "Pawel Niewiadomski"
			"name": "wseliga",
			"fullname": "Wojtek Seliga"
	"projects": [
			"name": "Sample data",
			"key": "SAM",
			"description": "This is a sample data",
			"versions": [ "1.0", "1.1"],
			"components": [ "Core", "HTTP", "UI"],
			"issues": [
					"priority" : "Major",
					"description" : "Some nice description here\nMaybe _italics_ or *bold*?",
					"status" : "Closed",
					"reporter" : "pniewiadomski",
					"labels" : [ "impossible", "test" ],
					"watchers" : [ "wseliga" ],
					"issueType" : "Bug",
					"resolution" : "Resolved",
					"created" : "P-3D",
					"updated" : "P-1D",
					"affectedVersions" : [ "1.9" ],
					"summary" : "My chore",
					"assignee" : "wseliga",
					"fixedVersions" : [ "1.0" ],

					"history" : [
						{ "author" : "wseliga", "created": "P-1D", "items": [
								"fieldType" : "jira",
								"field" : "status",
								"from" : "1",
								"fromString" : "Open",
								"to" : "5",
								"toString" : "Resolved"


Thank you so much. Will this capture the comment field as well?



You can set comment dates with both CSV or JSON (beta).


Can I just add the user, date, comment columns to the csv issue import? thanks.

Format your comment colument like this:

2012-03-02 13:34:34;the author;the comment

Remember that the date format must match what you input during the wizard.

And I can add these fields to the same csv import file my projects are in? thanks.


What do you mean by import issue history ? Import to existing issues in JIRA or creating new one ?

For the second option you can look at this:

In Redmine under an issue there is a history. Jira has the same field listed under activity. For example the history would be:

updated by guesswho almost 3 years ago
Project changed from Backlog to etl 

updated by mfocus almost 2 weeks ago 
status changed from new to feedback. 


Its almost like a timeline of modifications to the issue.

Yes I looked at both of those posts. I actually modified the SQL query from Github to extract our data out of Redmine. thanks for the reply.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,091 views 4 9
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