Import from QC - ASCII convertion

Hi!

I am planning to use the csv importer to convert from HP QC to JIRA and have started to test convert. But there are issues with the Norwegian letters, how do I spesify the correct setup?

The Norwegian letters are OK when I create new issues, only a problem when I import.

Any tips?

Thanks,
Elin Vaage

2 answers

1 accepted

Hello Elin

We did a migration form QC and used the External System Import option (administration options).

We had to use file encondig ISO-8859-1 for the special characters to be imported correctly into JIRA (in our case they were only Spanish characters like áéíóúñ).

You have to click on the Advance option to see the File encoding field.

You could use this the JaM plugin which linked HPQC to Jira. It will preserve much more of the history of the defect and match it to the Jira data model.

http://www.go2group.com/en/products/go2group-jam-plugin/

With your CSV data, is the data in the CSV formatted in UTF-8 correctly? If you open the CSV in a text editor, does it look ok? Does it import into Excel correctly?

Also, does the data look correct when you do the "Setup Field Mappings' as part of the import process? What is generating your CSV file?

Answers:

It looks OK when i open it in a text editor or in excel.

It does not look OK in the setup field mapping in the import process.

I create the file in excel and capsulate the text fields with "".

I will also check out the plugin. That might be better, even if its a one time convertion.

Since Jira importer should support UTF-8, I'm wondering if the problem is in the exact encoding of the CSV file that Excel produces (even if it appears to look ok to your text editor)

A qucik search shows some possible workarounds:

http://www.surveygizmo.com/survey-software-support/tutorials/getting-started/how-to-encode-an-excel-file-to-utf-8-or-utf-16/

http://stackoverflow.com/questions/4221176/excel-to-csv-with-utf8-encoding

They centre around either uploading the XLS file to Google docs and exporting it out as a CSV, or changing the export options. You can also use iconv / libiconv to convert the CSV file.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Amir Kazemi
Posted 5 hours ago in Jira

We want to know what Jira Service Desk apps you're using!

Hi Community! My name is Amir and I’m on the Jira Service Desk product marketing team at Atlassian. Our team would love to understand how you’re leveraging our ecosystem for Jira Service Desk. Wha...

21 views 0 4
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