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: Problems while importing a CSV file
Topic Summary:
Created On: 3-Sep-2007 17:54
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.
 3-Sep-2007 17:54
User is offline View Users Profile Print this message


Andrea Varriale

Posts: 17
Joined: 22-Mar-2007

I am having some troubles when importing a CSV file.
One of them is the following:
When a string value to be imported contains a raising to a power (e.g. km²) the following comma delimited valued is skipped and the import process fails.
Has anybody experienced that?

Client version: 8.0.0.6
Server version: 8.0.0.0
Report this to a Moderator Report this to a Moderator
 3-Sep-2007 18:03
User is offline View Users Profile Print this message


Andrea Varriale

Posts: 17
Joined: 22-Mar-2007

Just a correction to my previous post.
When a string value to be imported contains a raising to a power (e.g. km²) the following comma delimited valued is sometimes truncated and sometimes skipped. In the second case the import process fails because the CSV value counter and attribute counter are not "aligned" any more (values inserted in wrong attributes).
Report this to a Moderator Report this to a Moderator
 4-Sep-2007 15:33
User is offline View Users Profile Print this message


Kevin Murphy

Posts: 206
Joined: 15-Jul-2005

CSV files are flat text files and they don't support the "to a power" formatting that you are speaking of.

You shoul,d change instances of km2 to km^2 or something and then you can write a DXL script to convert this back in DOORS.

-------------------------
Kevin Murphy
http://www.baselinesinc.com
The Requirements Management Experts
Report this to a Moderator Report this to a Moderator
 4-Sep-2007 18:14
User is offline View Users Profile Print this message


Andrea Varriale

Posts: 17
Joined: 22-Mar-2007

Thanks for explanation Kevin.
So, since the only way (as far as I can understand) to import a MS Excel file is to save it as CSV, I will always have to remove all not supported formatting before starting the import process, right?
Sorry if my question sounds stupid...
Report this to a Moderator Report this to a Moderator
 4-Sep-2007 20:01
User is offline View Users Profile Print this message


Richard Good

Posts: 152
Joined: 22-Mar-2005

Not going to be desperately helpful here I'm afraid, but I share your annoyance at the lack of a powerful import option. If you assume an excel spreadsheet or word table with an even number of columns and rows and with column headers corresponding to attribute names then you should be able to create or update a doors module from it. I use a fairly ugly kludge to turn a rtf table into a rich text encoded csv file and import it to DOORS using a slightly modified copy of the import spreadsheet - not very satisfactory and more than a bit slow (caused by the deciphering rich text).

The right way to do this would be to use a vba macro where you could specify the module location maybe using an URL and then select a "key" column to match a unique identifier such as the "absolute number" in the DOORS module. You would then you use a vba macro to pass DOORS a "runStr" command for each row in the table/spreadsheet, the vba code would be very similar for both Excel and Word. I have had this down as a useful thing to do for years, but never got round to it, It would be interesting to know if someone on this forum has done this - I think its likely that someone has.

Sorry for the lack of constructive help!

-------------------------
Regards,

Richard Good
Report this to a Moderator Report this to a Moderator
 4-Sep-2007 21:11
User is offline View Users Profile Print this message


Kevin Murphy

Posts: 206
Joined: 15-Jul-2005

Well, if someone has done this, please speak up.

Otherwise, it sounds like a project I could take a look at in my spare time....

-------------------------
Kevin Murphy
http://www.baselinesinc.com
The Requirements Management Experts
Report this to a Moderator Report this to a Moderator
 13-Sep-2007 18:18
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Hi Andrea,

It seems to be a problem of incorrect codepage ...
Please see my posting here
for more information.

Hope that helps,

Greetings
Reik

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


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


Kevin Murphy

Posts: 206
Joined: 15-Jul-2005

Reik,

Are you saying that you can have formatting like km² in a CSV file, and it'll transfer to DOORS correctly?

I had always believed that "²" was not in the standard ASCII set, but it seems that it could be based on some copy/paste functions I am doing.

-------------------------
Kevin Murphy
http://www.baselinesinc.com
The Requirements Management Experts
Report this to a Moderator Report this to a Moderator
 14-Sep-2007 07:33
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Hi Kevin,

yes, yes ...

This formating can be in CSV file, but it is not standard ASCII.
ASCII defines only a 7 Bit code so the first 128 characters ....
The codes above that are defined by many different character encodings See Wikipedia

So it depends, if both tools are speaking the same language ;-))

I've tried to import from Excel the "km²" and "m³" and came to different results depending on selected codepage on the machine:
with CP 850 it worked well and both strings where imported correctly,
with cp 437 only the first one "km²" worked and the second one failed ...

Hope that helps you to understand it better

Greetings
Reik

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


Berlin, Germany
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.