Anyone with successful Clearquest to jira data migration ?

Hello,

Did anyone was able to successfully migrate data from clearquest to JIRA ? are there any tools/addon available ? JIRA cookbook refers to third party  or csv importer but  i believe csv importer wont bring the attachments ? is there an easy way to import  field values along with attachments ? can someone with good insight share on how to go about the migration ?

-Thanks

2 answers

I was able to migrate data using external perl script using clearquest api, JIRA Rest Client. I dont know that there are plugins available for that.

 

Otherwise you can export the data out from clearquest as a .csv file and import it into JIRA after a proper mapping

so i believe  export  in CQ is via Cq eclipse client ? can u elobarate in detail about import ? how do you attach the attachment using CQ filed ? will it import attachments to attachment field in JIRA one to one mapping ? how about if CQ id has more than one attachment will it import that too ?

when you export from clear quest, it creates a folder with the CQ ID right which contains all the attachments.

 

When you import that data in JIRA , create a custom field called ClearQuest ID and map it to the clearquest id.

 

Once the import is complete in Jira, you can use that QID and find the corresponding folder and add all the files as an attachment to JIRA

 

 

So the attachment has to be done manually ? i have more than 6k tickets

no you can script it using JIRA REST Client

you mean from REST api browser ? do you have sample script that you can share so i have an idea ? which api will PUT the attachments in the isues ?

when doing the export i see the attachment file also gets created. i will check if i can merge the export file(attachment field empty) and attachment export file(which has attachment location) and use the csv importer

here you a sample - after i create the new issue in JIRA

I convert all the attachments path into a file once i create issue in jira, i use the code below to attach them. It worked.

 

f($atcount>0) {
              
			  my $input_file= "C:\\att\\att.txt";
			  print " The input file is - $input_file";
			  open (FILE1,"$input_file") || die "Can't open $input_file: $!\n";
            while (<FILE1>) {
	  			print " The line is - $_";
				chomp $_;
	  			$jira->attach_files_to_issue($newissue,"$_");
	  			
	  	  	}
		     close FILE1;
	  	  		
	  	  	}
	  my $delcmd ="del c:\\att\\*.* /Q";

ok so you are usingJIRA::Client perl module ?

#!/usr/local/bin/perl

use strict;

use warnings;

use JIRA::Client;

use Data::Dumper;

my $jira = JIRA::Client->new("https://******.com/", "user", "password");

so which perl module you are using there are quite few available i see one JIRA::REST and  JIRA::Client::Automated module too can u share the first 5/6 line of your script

here you go

use strict;
use Win32::OLE;
use Win32::OLE qw(in with);
use Win32::OLE::Const 'Microsoft Outlook';
use Win32::OLE::Variant;
use Getopt::Long;
use SOAP::Lite;
use Data::Dumper;
use JIRA::Client;
use Time::localtime;

some may not be needed

Looks like jira::client module is deprecated and no longer supported for JIRA latest version😩

is it ?  I am still running it we are with 6.3.15. .. try to change it to JIRA REST then it should have the same methods 

I will have to go thru rest api and see how to install and than what methods are available i see 2 apis  jira::rest and jira::client::automated.

 I see in your script u create new issue and attach all files which r in path folder

do you have the script which you used for importing attachments with cqdbid? 

 

 

 

 

 

I will try out with CSV importer first

it worked with csv importer. But needs to do some manual stuff

  1. it does not attach files which has spaces so need to remove the spaces from file name
  2. it does not attach files to issues if the issues has more than 1 file for attachment. need to put each attachment path in different column in csv file

https://confluence.atlassian.com/jira061/jira-administrators-faq/usage-faq/how-to-import-attachment-using-csv

later on will check on with REST api

How did you import attachments?

clearquest - while exports it exports the attachments with CQ ID. while importing the clearquest data into JIRA create a seperate field to store the CQ ID and then add the attachments using that CQ ID field

 can u elobarate in detail about import ? how do you attach the attachment using CQ filed ? will it import attachments to attachment field in JIRA one to one mapping ? how about if CQ id has more than one attachment will it import that too ?

Also when i did CQ export via CQ eclipse client the attachments were created separate folder and when i open the csv file the attachment field is empty so how do the importer work ? the document mentions that in the attachments field specify the URL of your attachment in an 'Attachments' column within your CSV file how do you do that ?

Hello Mehul,

I am trying to migrate the ClearQuest to JIRA, Can you please tell me the process to migrate successfully.

If possible can you provide me the links to do this task.

Thanks

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 Thursday in Marketplace Apps

Tips on how to choose the best estimation method for your planning

Planning and grooming sessions all come with their own sets of rules. Team members meet to estimate stories or other work items, all according to an agreed-upon process. And with every session comes ...

78 views 0 11
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