![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
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 |
![]() |
![]()
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
Link didn't work from within the forum, but I found it. Helps! Thanks!
|
|
![]() |
|
![]() |
|
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 |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Removing embedded OLE from history records
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.