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: Real trouble importing word doc to DOORS
Topic Summary:
Created On: 25-Oct-2007 12:11
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.
 25-Oct-2007 12:11
User is offline View Users Profile Print this message


Jo Chandler

Posts: 20
Joined: 25-Oct-2007

Hi,
I have an SRD document which basically contains tables with the requirements points in. I want to import this document into doors but I don't want it to go in as a table. I want each heading in the table as an attribute.
I tried copying the table into Excel an importing it as a .csv file, but I lose all my word formatting. I.e. my headings.
Please, does anyone have any ideas as I've been banging my head on the wall for 2 days trying to work this out. It seems that you have to have your document in some "DOORS compatable" format before you can import it sensibly. I could have typed it all in manually by now!
Thanks in advance.
Report this to a Moderator Report this to a Moderator
 25-Oct-2007 12:57
User is offline View Users Profile Print this message


ron lewis

Posts: 650
Joined: 20-Sep-2004

Jo, Probably easiest way for you to proced is:
Inport your document by word, then export the, Absolute Number and Object Heading to spreadsheet.

Change the Object Heading Column to desired attribute name -- then auto fill the blank cells as desired, then re-import to doors. Then put on finishing touches as you desire.

If you plan on deleteing the object heading objects you may want to flatten your file using a script than is available -- references can be found in this forum to the flatten file script.

Edited: 25-Oct-2007 at 12:58 by ron lewis
Report this to a Moderator Report this to a Moderator
 25-Oct-2007 13:39
User is offline View Users Profile Print this message


Jo Chandler

Posts: 20
Joined: 25-Oct-2007

Hi Ron, thanks for the info.
I'm very new to DOORS so sorry for any stupid questions...
How do I export only the absolute number and object heading to a spreadsheet?

This is the most stressful tool I've ever used!
Report this to a Moderator Report this to a Moderator
 25-Oct-2007 14:02
User is offline View Users Profile Print this message


ron lewis

Posts: 650
Joined: 20-Sep-2004

Build a view with the two attributes then export to spreadsheet.

Edited: 29-Oct-2007 at 13:05 by ron lewis
Report this to a Moderator Report this to a Moderator
 25-Oct-2007 16:04
User is offline View Users Profile Print this message


Peter Albert

Posts: 232
Joined: 30-Dec-2005

The kitchen library has a script which converts table rows in objects with attributes created from the table headings. This seems to be exactly what you need.

Regards,

Peter
Report this to a Moderator Report this to a Moderator
 25-Oct-2007 17:06
User is offline View Users Profile Print this message


Jo Chandler

Posts: 20
Joined: 25-Oct-2007

Peter that sounds exactly what I want.
What's the kitchen library though? Where do I find it?
Thank you!!
Report this to a Moderator Report this to a Moderator
 25-Oct-2007 19:31
User is offline View Users Profile Print this message


Richard Good

Posts: 152
Joined: 22-Mar-2005

If you don''t know a lot about DOORS I would be tempted to keep it simple - simply convert the table to text then make sure the paragraphs you want to appear as headings are in the headings style and those you want as text are not. Then use the DOORS import tool which manifests itself as an icon in word. If you have any word tables that you want to keep as word tables then use this Word macro such that they will be imported as OLE's and not as DOORS tables which most people hate

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

Richard Good
Report this to a Moderator Report this to a Moderator
 26-Oct-2007 06:31
User is offline View Users Profile Print this message


Pekka Mäkinen

Posts: 276
Joined: 18-Mar-2004

This script is also available in the DOORS DXL Library, just select Tools / DXL Library and browse to "Some example programs which illustrate..." / "Convert DOORS table into objects....".

The description for this is:

Converts a DOORS table into objects, one per row with columns becoming attributes, and creates a view that mimics the original table.
Row one is supposed to contain column titles. Attribute names can be assigned to each column, the values in that column will be saved in that attribute.
The dialogue box using column headers to mimic the view of the table that will be created.


You might have to play around with the settingsa in the dialog box, but it will produce what you want. Of course the end result might not be usable if you have many different columns in your tables, but if they are just copies of each other, then this works.

-------------------------
Pekka.Makinen@softqa.fi
SoftQA Oy -http://www.softqa.fi/
Report this to a Moderator Report this to a Moderator
 26-Oct-2007 08:43
User is offline View Users Profile Print this message


Peter Albert

Posts: 232
Joined: 30-Dec-2005

Here is a link to a thread where the kitchen library is posted as zip file.

Regards,

Peter
Report this to a Moderator Report this to a Moderator
 26-Oct-2007 09:46
User is offline View Users Profile Print this message


Jo Chandler

Posts: 20
Joined: 25-Oct-2007

Thank you so much Peter and Pekka. That was exactly what I wanted!
Report this to a Moderator Report this to a Moderator
 11-Aug-2008 22:11
User is offline View Users Profile Print this message


Todd Picton

Posts: 5
Joined: 10-Jul-2007

"If you have any word tables that you want to keep as word tables then use this Word macro such that they will be imported as OLE's and not as DOORS tables which most people hate"

This is exactly what I'm looking for. Unfortunately, the "this" link in the post takes me to a generic Telelogic support page. Any Ideas how I find the actual macro.

Thanks
Report this to a Moderator Report this to a Moderator
 12-Aug-2008 16:24
User is offline View Users Profile Print this message


Richard Good

Posts: 152
Joined: 22-Mar-2005

I hate it when they move things around - this probably means that all links older than a certain date lead no where, this is not exactly helpful to the forum users - anyway here is the macro.

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

Richard Good
Report this to a Moderator Report this to a Moderator
 13-Aug-2008 00:13
User is offline View Users Profile Print this message


Chris Jones

Posts: 177
Joined: 1-Jul-2005

Yes, it's annoying that old forum links don't work.

However, you can still "get there from here": Copy the address of this page into a new browser window/tab, and change the "catid=" and "threadid=" to whatever the old link points to. The base URL is different, but at least they didn't change the category and thread IDs!

Chris
Report this to a Moderator Report this to a Moderator
 13-Aug-2008 19:37
User is offline View Users Profile Print this message


Todd Picton

Posts: 5
Joined: 10-Jul-2007

Thanks Richard !

That saves a lot of manual rework. It is interesting that it leaves a mess of OLE object outlines in a pile on the converted doc - but if you have faith and export it to DOORS everything comes out great.
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.