How to import data from clearquest to jira with attachements

Hello i have gone through other question about the migration from CQ to jira but did not find the steps on how to bring attachments from CQ to Jira is there any option available ? I dont know about jelly or soap or groovy script as mentioned in another questions.

Also when i tried to use the importer for importing the csv file i get an error for the description field

Failed to read CSV file, you may decide to ignore the error: java.io.IOException: Malformed CSV stream. Missing [ ] near offset 321 after field 11 on line 1657

if i open the file in exel i dont have line 1657 max line is 1457


-Mehul

5 answers

1 accepted

This widget could not be displayed.

What we did for a large ClearQuest -> JIRA migration that included all issue history and attachments as well as migrating the issues into a new process workflow was to, as far as the attachments were concerned, write a standalone java utility that pulled the blob attachment data out of the database and stored it in files using a naming convention where the file name matched the attachment id from the clearQuest database.

We then combined these extracted files with another standalone java process that took the location of the extracted files along with the location of the migrated issues (i.e. the jira instance) and the table name containing attachment information. The utility then walked over the migrated issues, took the clearquest id from the issue and looked to see if it had attachments. If there were attachments it pulled the attachment id's from the database and found the files and attached them to the jira issue using the available meta data to indicate the correct file name.

It was a little ugly, and if I had to do it over again I'd probably just write something that streamed the blob data straight from the database instead of extracting it first - but in the end it worked, and quite rapidly, correctly attaching 10 years of attachments to roughly 200K issues in about an hour.

-wc

This widget could not be displayed.

feel free to email me direct to discuss further

-wc

just search for 'william crighton'

This widget could not be displayed.

William did you have to parse the CSV file when you imported into Jira from clearquest? How did you import 200K issues? I believe you might have to edit the CSV file for newline, dropdownlist etc data correct?

DId you guys map the CQ data 1-2-1 or did you have to add any custom mapping? Any alternative for attaching the files?

This widget could not be displayed.
Yilin Mo Atlassian Team Mar 07, 2013

I would like to advise you to review the page about : https://confluence.atlassian.com/display/JIRA/How+to+import+attachment+using+CSV

The error message could probably related to some invisible characters or empty line, you should open it in a text editor to double check.

So all the attachment files from CQ needs to be downloaded first and save at this location ? i have 10000+ records already in CQ and many of the records have more than 1 attachments and if this needs to be done manually than its going to be very tough first to download the attachments for each record and move to the jira folder and than update the csv file for each record

is my assumption correct ? or am i missing something ?

This widget could not be displayed.

Have a look at this document: Data Migration from ClearQuest. It is not very specific but it can give you an idea fo how to aproach the migration.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

576 views 25 15
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