Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: Importing Excel Sheet with English + Japanese characters to DOORS
Topic Summary:
Created On: 7-Dec-2005 02:05
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 7-Dec-2005 02:05
User is offline View Users Profile Print this message


Jalil Akbar

Posts: 2
Joined: 15-Nov-2005

Hi,

I am new to DOORS and currently looking for a way to import the excel file that contains both English and Japanese characters.

Our problem is that the original excel file when converted to .csv for import to DOORS shows all Japanese characters as ?? and subsequently what get imported inside DOORS is a garbage.

I have tried using regional settings (control panel) as well as microsoft language settings option (ms office) to turn on the Japanese characters. My all attempts have failed.

Can someone give me pointers what possibly I have been missing in the entire process?

Thanks in advance.

Regards,
Jalil Akbar
Report this to a Moderator Report this to a Moderator
 17-Sep-2007 18:26
User is offline View Users Profile Print this message


Walter Kosebutzki

Posts: 7
Joined: 10-Aug-2006

Hi.  I'm having the exact same problem now.  Has anyone ever found a solution?

Thanks

Walter
Report this to a Moderator Report this to a Moderator
 18-Sep-2007 19:29
User is offline View Users Profile Print this message


Walter Kosebutzki

Posts: 7
Joined: 10-Aug-2006

So I have a *.CSV file with Japanese Characters. I am able to manually Copy and Paste them into my DOORS Module. However, when I do an import, the characters import all garbeled. I have all of the Windows Regional and Language Settings set to 'Japanese' as well. Any advice? Should I try to format the data and import a Word Document? Thanks Walter
Report this to a Moderator Report this to a Moderator
 18-Sep-2007 21:10
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Hi Jalil, Hi Walter,

I tried a little bit with an Excel file, where I've copied some Japanese chars into (from a web site).

Then I saved the file as "Unicode Text (*.txt)"
Then I used the "File -> Import -> Spreadsheet..."
with following options:

Import Attributes : From list
Import options : Create New Objects
Attributes to Import : "Object Text"
Data Separator : Tab
Input File : <The saved file from Excel>
[Advanced]
Encoding : 1200 (UTF-16)

The chars where displayed correctly in small text area in bottom of import dialog.
So I imported the data - and it was correctly imported!

Hope you can reproduce my tests ....

Greetings
Reik

-------------------------
Evosoft GmbH
for Siemens Industry Sector


Berlin, Germany
Report this to a Moderator Report this to a Moderator
 21-Sep-2007 16:33
User is offline View Users Profile Print this message


Walter Kosebutzki

Posts: 7
Joined: 10-Aug-2006

Hi.  I got it working another way.  I did all my work as an *.xls and then saved as a *.csv.  The key is to not save this *.csv again as it will change the japanese characters over to '???'s.

I also used '10001 MAC - Japanese' as 'Advanced' as my import type.

Thanks

Walter
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.