issue history import csv

julian bankston September 3, 2012

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

3 answers

1 accepted

1 vote
Answer accepted
Pawel Niewiadomski
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 4, 2012

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 September 4, 2012

Pawel,

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

Thanks,

Julian

Pawel Niewiadomski
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 4, 2012

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

julian bankston September 5, 2012

Pawel,

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

Pawel Niewiadomski
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 5, 2012

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 September 5, 2012

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

Pawel Niewiadomski
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 5, 2012

Yes, you can.

0 votes
Krzysztof Skoropada [Deviniti]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 4, 2012
julian bankston September 4, 2012

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.

0 votes
Krzysztof Skoropada [Deviniti]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 4, 2012

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 September 4, 2012

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.

Suggest an answer

Log in or Sign up to answer