Is it possible to import japanese characters into RTC?

My mistake. I am looking into importing artifacts into RRC.

If yes, what are the things I should be careful of?

Thank you
Eduardo

We do support importing a csv file that contains japanese characters. You need to make sure that the file is in UTF-8 format, though.

And let me offer two tips:

1. If you are starting with data in MS Word or Excel, for example, you need to make sure the text does not include MS Office "special characters". These characters don't convert "nicely".

2. There have been cases in which I have saved a csv file in Excel and then needed to open the file in Notepad and save it in UTF-8 format, since Excel could not do that.

And let me offer two tips:

1. If you are starting with data in MS Word or Excel, for example, you need to make sure the text does not include MS Office "special characters". These characters don't convert "nicely".

2. There have been cases in which I have saved a csv file in Excel and then needed to open the file in Notepad and save it in UTF-8 format, since Excel could not do that.

Thank you for the response. I am actually starting with Excel as there will be around 2000 requirements to import (not all japanese). But when I "save as csv" from Excel, the japanese characters are turned into question marks.

So my understanding is that I'll have to input the japanese text manually into the csv after the file has been saved as csv off of Excel (It's not possible to save csv as UTF from Excel).

Is this assumption correct?

Thank you

can you get it into Word or Notepad some way? Then perhaps you can save it in UTF-8.

I have tested importing the following csv:
Type,Title,Primary Text
System Requirement,,

The Title attribute was imported correctly. However, the primary Text attribute was not. "" was transformed into "ｱｲｳｴｵｶｷｸｹｺｻｼｽｾｿﾀﾁﾂﾃ"

Due to the fact that the Title attribute was imported correctly, I believe that both my machine and the server are prepared to import japanese characters. Would you have any ideas on how to make the Primary Text be imported correctly?

thank you

You might want to look at these and make sure you are on the latest RRC fixpack 3.0.1.2 (but this won't solve your need to wrestle with MS Office):

https://jazz.net/jazz03/resource/itemName/com.ibm.team.workitem.WorkItem/37476

https://jazz.net/jazz03/web/projects/Requirements%20Management#action=com.ibm.team.workitem.viewWorkItem&id=36799

The Primary Text attribute was not imported correctly. They were transformed into numbers and special characters.

However, when I pasted those special characters and numbers here, the forum transformed them into japanese characters.

So there's a problem somewhere (my browser? my server?) that is transforming the japanese characters in numbers and special characters in RRC.

Any ideas?