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

Pawel,

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

Thanks,

Julian

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

Pawel,

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.

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

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.

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira

Mission-critical battery manufacturer fulfills FAA software requirements with Commit Policy Plugin

EaglePicher Technologies is a leading manufacturer of battery systems for diverse industries like defense, aviation, space or medical. As they operate in highly regulated industries, keeping a clear ...

165 views 0 2
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