Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Import clear quest defect history field to Jira comments field..

Deleted user
October 28, 2019

Hi,

I am new to JIRA Migration. Planning to import content from clear quest to JIRA Cloud.

Started the same with CSV Import method . Tried importing most of the fields except "History".  Can any one pls let me know how to import history field to Jira cloud?

Thanks

Vishnu

1 answer

0 votes
Mikael Sandberg
Community Champion
October 28, 2019

You cannot import issue history, the only history you can import are dates. I would suggest to add the historical data as a comment to each issue that is imported.

Deleted user
October 28, 2019

Thanks for your response.

I have many more projects and issues to import into Jira. What exactly does it mean - "add the historical data as a comment to each issue" - You want me add it manually to issues before doing CSV Import? 

Mikael Sandberg
Community Champion
October 28, 2019

You need to modify your csv file to also include a column for the history of the issue, and then when you do the mapping for the import set the history column to be imported as a comment.

Since ClearQuest exports the history in a separate file you would have to combine that with the file that has your issues.

Deleted user
October 28, 2019

Yes. ClearQuest exports history in a file but the issue is we can have multiple history  records for one issue. I am just thinking how to combine these history records in the file that has issues.  Is there any script to combine multiple records in one cell for one defect?

Pls confirm..

Mikael Sandberg
Community Champion
October 28, 2019

You would have to create that script. I used a Perl script to do it when I migrated from ClearQuest to Jira years ago, but we did not bring over the history since it was decided to keep one license for ClearQuest so we could have read only access to the history if needed.

Deleted user
October 28, 2019

Ok fine.. Can you pls provide the script if you have it? I am not aware of Perl scripting.

Planning to create the script in power shell.

Mikael Sandberg
Community Champion
October 28, 2019

Unfortunately I cannot give you the file, but the basics of the script would be to read the ClearQuest data including the history, combine them and then generate a new csv file that has all the data you want to import, including the history.

Deleted user
October 28, 2019

Ok fine.. No problem . Thanks for your suggestions..

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events