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: Import Problems
Topic Summary:
Created On: 11-Sep-2007 22:09
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.
Answer This question was answered by Reik Schroeder, on Wednesday, September 12, 2007 4:13 PM

Answer:
Hi Walter,

how do you import the date back to Doors?

If you are using Excel and csv, you should know, that there are different "implemntations" of csv.
I would suggest to export from Excel into "Text (MS-DOS)(*.txt)"
That would be the most suitable formato be reimported into Doors via "File -> Import -> Spreadsheet"
In dialog you have to select Data Separartor Tab
You should also press advanced button after you have specified the file to import from.
In advanced section you should select the code page which is set as default on your system
(you may find it by using: "mode con" on windows command line)


Hope, that helps you to import the data properly.

Greetings
Reik
 11-Sep-2007 22:09
User is offline View Users Profile Print this message


Walter Kosebutzki

Posts: 7
Joined: 10-Aug-2006

Hi.  I'm working with DOORS 8.0.0.6.  I am trying to get people in my team to start to export data out of a certain DOORS and into a spreadsheet.  Then, after they have made modifications, I will import the data back into this DOORS module.  I'm testing this out on a test module.

So for the most part, the import, using 'Update Existing Objects' works as expected.  However, I have come across two problems that I can't explain.

Problem 1:

There are 4 Attributes that I'm trying to import
Column 1 - Object ID
Column 2 - Object Text
Column 3 - Variant
Column 4 - Notes

When I have double quotes in the Object Text, DOORS considers the Variant as a part of the Object Text and the Notes as a part of the Variant.  When I take out double quotes, everything imports correctly.  For example:

Incorrectly Imports '70' as the 'Variant' - Tpr6,Describe how this test procedure satisfies (in part or whole) the test deliverable listed in section 8 of the "System/Software Validation Plan".,SJA,70

Correctly Imports '70' as 'Notes' - Tpr6,Describe how this test procedure satisfies (in part or whole) the test deliverable listed in section 8 of the System/Software Validation Plan.,SJA,70

Problem 2:
Again, I'm trying to import the same 4 Attributes.

I'm trying to import - Tpr6,Describe "rrr".,SJA,70

However, two of the r's have been taken away when I check in DOORS

Imports As - Tpr6,Describe r.,SJA,70

Thanks

Walter

Report this to a Moderator Report this to a Moderator
 12-Sep-2007 08:27
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Answer Answer
Hi Walter,

how do you import the date back to Doors?

If you are using Excel and csv, you should know, that there are different "implemntations" of csv.
I would suggest to export from Excel into "Text (MS-DOS)(*.txt)"
That would be the most suitable formato be reimported into Doors via "File -> Import -> Spreadsheet"
In dialog you have to select Data Separartor Tab
You should also press advanced button after you have specified the file to import from.
In advanced section you should select the code page which is set as default on your system
(you may find it by using: "mode con" on windows command line)


Hope, that helps you to import the data properly.

Greetings
Reik

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


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


Kevin Murphy

Posts: 206
Joined: 15-Jul-2005

Walter,

You can also try downloading OpenOffice.org and using its spreadsheet (Calc, I think it's called) to save CSV files. It handles double-quotes much better than Excel does, and you don't get all of those pesky Excel "Are you sure you want to save this file as CSV? No, really, are you sure? I know you just said yes twice, but c'mon, you really don't want to save this as CSV, do you?" dialogs.

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


Walter Kosebutzki

Posts: 7
Joined: 10-Aug-2006

Hi. Thanks for all the help. I will also be importing date back into DOORS, I just haven't tried out that field yet. I switched the 'Code Page' in the Advanced Options to 437. That seems to work with all the different imports that I do now. I would switch to open office, but all of our contractors are using Microsoft Excel. Best case scenario would be for the contractors to send me the CSVs and then I can directly import them in. I'll try to save the files as *.csv's in Open Office if that doesn't work. Thanks! The DOORS Forum saves me again! Walter
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 0 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 0 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.