issue history import csv

[julian bankston]

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

[Pawel Niewiadomski · Accepted solution]

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"
							}
						  ]}
					]
				}
			]
		}
	]
}

[julian bankston]

Pawel,

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

Thanks,

Julian

[Pawel Niewiadomski]

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

[julian bankston]

Pawel,

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

[Pawel Niewiadomski]

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.

[julian bankston]

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

[Pawel Niewiadomski]

Yes, you can.

[Krzysztof Skoropada [Deviniti]]

Have you taken a look at https://confluence.atlassian.com/display/JIRAKB/Importing+data+from+Redmine and https://answers.atlassian.com/questions/19484/migrating-to-jira-from-redmine ?

[julian bankston]

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.

[Krzysztof Skoropada [Deviniti]]

Hi,

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: https://confluence.atlassian.com/display/JIRA/Importing+Data+from+CSV

[julian bankston]

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. 

etc....

Its almost like a timeline of modifications to the issue.