Anyone with successful Clearquest to jira data migration ?

[mnpiad]

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

[mnpiad]

How did you import attachments?

[saravanan subramanian]

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

[mnpiad]

 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 ?

[mnpiad]

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 ?

[Satish Chodipalli]

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

[saravanan subramanian]

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

[mnpiad]

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 ?

[saravanan subramanian]

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

[mnpiad]

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

[saravanan subramanian]

no you can script it using JIRA REST Client

[mnpiad]

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 ?

[mnpiad]

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

[saravanan subramanian]

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";

[mnpiad]

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");

[mnpiad]

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

[saravanan subramanian]

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

[mnpiad]

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

[saravanan subramanian]

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 

[mnpiad]

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? 

[mnpiad]

I will try out with CSV importer first

[mnpiad]

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