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: Tab separated value(TVS), Interchange xls datei
Topic Summary: When I import TVS-datei in Doors ...
Created On: 22-Sep-2006 17:15
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 Tony Goodman, on Tuesday, September 26, 2006 5:01 PM

Answer:
Procedure for Exporting a Module to a TSV file and then Importing updates from a TSV file.

Here is what you need to do.

Create a view with a column for each of the following attributes.
Object Identifier
Object Heading
Object Text
Absolute Number
Object Number
Object Level

Plus columns for any other attributes you want exported.

Ensure that the view does NOT contain the Main column or the "ID" column.
Save the View as "Export View"

Make sure the Export View is loaded and select Export > Spreadsheet.
Select "Tab"
Click Export.

When you get the modified TSV file back:
Select Import > Spreadsheet
Select "Tab"
Browse to the file
Click Import

You will be prompted to select the attribute that uniquely identifies each object.
Select "Absolute Number".
Your module wil be automatically updated.
 22-Sep-2006 17:15
User is offline View Users Profile Print this message


Christian Montero

Posts: 16
Joined: 20-Jul-2006

Hi Dorsians,
I need your help, please. We want interchange und update tsv-files with a customer . The problem is, the customer don't have Doors but a MKS-Tool. Our one alternative is a interchange our Excel-files with tvs-format (Spreedsheet).
My problem: I imported a TVS-file from excel-sheet in Doors 8.1.  How can I obtain a hierarchy in Doors from my TVS-file? Do I need a DXL-Script?
For example... I see my TVS-import in the Doors-Module Explorer so:
-Functions
--1.Overwiew (Object Heading in Excel)
--2.Introduction
--During function etc, etc (Object Text in Excel)
--Additionally the following
--Features
--3.Realization
--Tools 1
--Tools 2
--4.Others

"Typically" we have in Doors the following hierarchy (Threading):
--Functions
--1.Overwiew
--2.Introduction
----During function etc, etc.
----Additionally the following
-------Features
--3.Realization
-----Tool 1
-----Tool 2
--4.Others

Of course, I can change all this manually with the option move->below/after, but it's to long.
Do you know maybe any dxl-script? Maybe can't detect Doors a hierarchy from a TVS-Format?
or... I don't import rightfully my tvs-file (!?). Can you me help? Have a nice weekend and thanks
 for your answer :-)
Christian

Report this to a Moderator Report this to a Moderator
 24-Sep-2006 11:55
User is offline View Users Profile Print this message


ron lewis

Posts: 650
Joined: 20-Sep-2004

A script to solve your problem can be found here: at
http://www.galactic-solutions.com
Report this to a Moderator Report this to a Moderator
 25-Sep-2006 09:55
User is offline View Users Profile Print this message


Christian Montero

Posts: 16
Joined: 20-Jul-2006

Hello Ron! :-)
Thanks to much for your information. I tested a dxl script (Build Hierarchy) from Galatic Solutions,
but this couldn't solve my problem. I can see the differents attributes from my modul in the dxl-window, but the "object text"  doesn't appear. For me is important, that the "object text" one level below by import appears, please see my example. For a possible solutions, thanks in advance.
Christian
Report this to a Moderator Report this to a Moderator
 25-Sep-2006 17:13
User is offline View Users Profile Print this message


Michael Sutherland

Posts: 248
Joined: 13-Sep-2002

Christian,

The "Build Hierarchy" script assumes the hierarchy numbering is in a separate attribute, and not mixed with the "Object Text". This is why the script does not work for your situation.

-------------------------
Michael Sutherland
michael@galactic-solutions.com
http://galactic-solutions.com
Report this to a Moderator Report this to a Moderator
 25-Sep-2006 17:28
User is offline View Users Profile Print this message


Christian Montero

Posts: 16
Joined: 20-Jul-2006

Hi Michael,
thanks for your answer...I had thought, I did that wrongly.
Michael, can you give me any tips for that, please?  Thanks.
Report this to a Moderator Report this to a Moderator
 26-Sep-2006 09:49
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Michael's script relies on the heading level attribute being correctly set in a separate column in the spreadsheet. Without this, any script you apply can only guess at what the hierarchy should be.

Some questions:
1. Did the TSV files originate from DOORS in the first place?
2. Are Object Text and Object Heading in separate columns in the spreadsheet?
3. Does the spreadsheet contain heading numbers in a separate column?

If you can answer these there may be a solution.
Once you have built the hierarchy the first time, you can then use the heading level attribute in all subsequent export/import cycles.

-------------------------
Tony Goodman
http://www.smartdxl.com
Report this to a Moderator Report this to a Moderator
 26-Sep-2006 11:51
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Answer Answer
Procedure for Exporting a Module to a TSV file and then Importing updates from a TSV file.

Here is what you need to do.

Create a view with a column for each of the following attributes.
Object Identifier
Object Heading
Object Text
Absolute Number
Object Number
Object Level

Plus columns for any other attributes you want exported.

Ensure that the view does NOT contain the Main column or the "ID" column.
Save the View as "Export View"

Make sure the Export View is loaded and select Export > Spreadsheet.
Select "Tab"
Click Export.

When you get the modified TSV file back:
Select Import > Spreadsheet
Select "Tab"
Browse to the file
Click Import

You will be prompted to select the attribute that uniquely identifies each object.
Select "Absolute Number".
Your module wil be automatically updated.

-------------------------
Tony Goodman
http://www.smartdxl.com
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.