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: Removing embedded OLE from history records
Topic Summary:
Created On: 30-Jan-2004 16:12
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.
 30-Jan-2004 16:12
User is offline View Users Profile Print this message


Robert Padilla

Posts: 13
Joined: 5-Jan-2004

Greetings!

A process we have of reporting changes involves exporting changes identified in object history records to an Excel spreadsheet identifying a number of the history record attributes. One problem that results in a 'Failed OLE Operation', when exporting content to Excel is when the history record has an embbeded OLE object; Excel just doesn't handle this. Thus, the embedded OLE object has to be removed to prevent this dialog from being presented. Not that it's problem of responding to the inquiry, but it's not possible when the process is automated and runs as a scheduled task at 01:00 and hangs up the rest of the process.

Has anyone encoutered this problem?

I've not seen any DOORS function that will separate string, richText and/or OLE content from history records.

Using -> string s= hr.newValue

returns the entire history content string, richText and embedded OLE into 's'.

I've tried a number of variations/functions on the above statement without success. Any ideas?

Bob Padilla
Report this to a Moderator Report this to a Moderator
 30-Jan-2004 17:02
User is offline View Users Profile Print this message


Frank Lipski

Posts: 42
Joined: 6-Nov-2002

I encountered similar problems. I believe the solutions you are looking for are in replies to my post: History in Version 7. http://support.telelogic.com/en/doors/forums/messageview.cfm?catid=17&threadid=1174 (hopefully this link will work correctly)!

Frank
Report this to a Moderator Report this to a Moderator
 30-Jan-2004 17:19
User is offline View Users Profile Print this message


Robert Padilla

Posts: 13
Joined: 5-Jan-2004

Link didn't work from within the forum, but I found it. Helps! Thanks!
Report this to a Moderator Report this to a Moderator
 30-Jan-2004 18:40
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

Attached find function fStripRT that will strip away all RichText formatting (including OLE diagrams) and leave only the raw text. It doesn't work in DOORS v5 since the RichTextParagraph type is new to v6. I have a different version of this function that DOES work in v5, but it doesn't work in v6 since the rt.newline command behaves differently between the versions (incorrectly in v6).

So you probably want to issue:
string s= fStripRT(hr.newValue)

The unpleasant alternative is to assign the value to an attribute, then extract only the raw text:
sFull = hr.newValue
m."TempText" = sFull
sRaw = m."TempText" // don't use "richTextWithOle(m."TempText")

- Louie
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.