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: Retrieve deleted attribute data
Topic Summary:
Created On: 8-Aug-2006 19:56
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 Louie Landale, on Thursday, August 10, 2006 8:35 PM

Answer:
[1] You can create a second database via the "doorsd.exe minstall" option in the install manual. Point to some file location. It should start empty. Copy the latest backup to that location. Create a new DOORS icon on the server, using the icon's "target" to point to the backup database, perhaps "... doors.exe -d 37777@MyServer". Open the module, create a view featuring only the Object ID and the attribute in question. Export to Excel. Close this database. Open the live database, edit the module, create the attribute, then import the spread sheet.

[2] Know that the History of the attribute still exists. If the attribute recorded History (which is likely) you can also do this: Edit the module, create the attribute. Write a DXL that looks something like the attached. If you've renamed the attribute then its gets a tiny bit stickier.

- Louie
 8-Aug-2006 19:56
User is offline View Users Profile Print this message


Marlin Wegner

Posts: 20
Joined: 2-Jun-2006

Someone has mistakenly deleted an attribute from a module.   Unfortunately there were no baselines for tis particular module and on this particular day, no backups were made.    Does anyone know or can point me in a direction to attempt to retrieve the data for the objects in the module that the particular attribute contained?  

Thanks!
Report this to a Moderator Report this to a Moderator
 9-Aug-2006 00:30
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

Answer Answer
[1] You can create a second database via the "doorsd.exe minstall" option in the install manual. Point to some file location. It should start empty. Copy the latest backup to that location. Create a new DOORS icon on the server, using the icon's "target" to point to the backup database, perhaps "... doors.exe -d 37777@MyServer". Open the module, create a view featuring only the Object ID and the attribute in question. Export to Excel. Close this database. Open the live database, edit the module, create the attribute, then import the spread sheet.

[2] Know that the History of the attribute still exists. If the attribute recorded History (which is likely) you can also do this: Edit the module, create the attribute. Write a DXL that looks something like the attached. If you've renamed the attribute then its gets a tiny bit stickier.

- Louie
Report this to a Moderator Report this to a Moderator
 10-Aug-2006 20:37
User is offline View Users Profile Print this message


Marlin Wegner

Posts: 20
Joined: 2-Jun-2006

# 2 was the fix in this case, though I had to make a few modifications as the attribute type was of Date type.


Once Again,
Thanks for all your help!
Report this to a Moderator Report this to a Moderator
 1-Sep-2006 00:18
User is offline View Users Profile Print this message


Krishna Kandala

Posts: 170
Joined: 8-Jul-2006

I tried using this code on a test module by deleting an attribute which has text values. I created the deleted attribute again with the same name. By running the code, the text values are restored but in the rich text format with all tags and other info. I am not able to get rid of the tags etc and get the normal text format. May be I have to construct a function like 'dumpAllInfo'. Will someone please give me a lead how I can do it?
Thanks in advance
- Krishna

Report this to a Moderator Report this to a Moderator
 1-Sep-2006 16:06
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

I don't recall who found this, possibly Tusky, but you can retrieve raw text from History as follows:
string oldV = hs.plainOldValue // instead of hr.oldValue
string newV = hs.plainNewValue // instead of he.newValue

- Louie
Report this to a Moderator Report this to a Moderator
 2-Sep-2006 03:00
User is offline View Users Profile Print this message


Krishna Kandala

Posts: 170
Joined: 8-Jul-2006

Thanks, that worked. I am wondering where all such properties for History are listed. I do not find them in the DXL manual.

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