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
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

23,675 views 2 7
Join discussion

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