Inflectra Customer Forums: Restoring Deleted Test Cases (Thread) In the last week, we have done some rather major reconfiguring of data in projects in test sets and test case moves. At some point, we lost a major set of test sets GÇô an entire suite. So, is there a way to restore that test set suite? I have backup of data from before the reconfigurations. I would do a simple restore, however the other work done since the data loss cannot be lost. en-US(C) Copyright 2006-2024 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spiratest/issues-questions/9.aspxthreadId=9Steve M (support4@inflectra.com)Restoring Deleted Test Cases In the last week, we have done some rather major reconfiguring of data in projects in test sets and test case moves. At some point, we lost a major set of test sets GÇô an entire suite. So, is there a way to restore that test set suite? I have backup of data from before the reconfigurations. I would do a simple restore, however the other work done since the data loss cannot be lost. Mon, 07 Feb 2011 20:08:57 -05002017-05-22T15:41:20-04:00/Support/Forum/spiratest/issues-questions/9.aspxmessageId=9Steve M (support4@inflectra.com)If you don't want to lose the other data entered since that point, then the best solution would be tIf you don't want to lose the other data entered since that point, then the best solution would be to: 1) Install a test instance of SpiraTest onto another computer (you can use the same license key) 2) Do a restore back into this test instance 3) Now use the Excel Add-In to import all the test cases from this test installation 4) Delete all the test cases / steps from the Excel sheet apart from the ones that you need to restore 5) Remove all the Test Case IDs and Test Step IDs from the Test Case # and Test Step # columns (this will make the Excel Add-In add them to the production server rather than trying to do an update) 6) Now point the Excel Add-In to your production server 7) Now choose the Export option to load the missing test cases / steps into your production instance. Mon, 07 Feb 2011 20:09:16 -05002011-02-07T20:09:16-05:00/Support/Forum/spiratest/issues-questions/9.aspx#reply9messageId=237John L Bevan (johnbevan@clearchannel.com) FYI: we recently had a similar situation with test cases being deleted. For those, we were able to FYI: we recently had a similar situation with test cases being deleted. For those, we were able to easily restore them by updating the flag on the database using the SQL below: Update spiratest.dbo.tst_test_case Set is_deleted = 0 Where is_deleted = 1 And last_update_date > '2011-08-01 12:00' --or whenever you want to undelete from Hope that helps some of you. Cheers, JB Mon, 01 Aug 2011 14:15:44 -04002011-08-01T14:15:44-04:00/Support/Forum/spiratest/issues-questions/9.aspx#reply237messageId=240David J (support1@inflectra.com) John We assumed from the email you had sent that you were on an older version of the system (v3. John We assumed from the email you had sent that you were on an older version of the system (v3.0 or older) that didn't support un-deletes. With v3.1 (or later) you can just go to Administration > Project History Changes and Restore the items marked as Deleted. This was not possible in previous versions. Tue, 02 Aug 2011 15:45:04 -04002011-08-02T15:45:04-04:00/Support/Forum/spiratest/issues-questions/9.aspx#reply240messageId=307John L Bevan (johnbevan@clearchannel.com) That's great - thank you. I think that at the time I spoke to you we were on the old version - we That's great - thank you. I think that at the time I spoke to you we were on the old version - we only upgraded fairly recently. Thanks also for adding that feature - I was just about to write to request it :). Kind regards, JB Fri, 16 Sep 2011 12:03:09 -04002011-09-16T12:03:09-04:00/Support/Forum/spiratest/issues-questions/9.aspx#reply307messageId=311David J (support1@inflectra.com)You are very welcome - it has been quite popular!You are very welcome - it has been quite popular!Mon, 26 Sep 2011 14:13:02 -04002011-09-26T14:13:02-04:00/Support/Forum/spiratest/issues-questions/9.aspx#reply311messageId=409mbangu m manika (manikam@bankservafrica.com) Inflectra Support You are very welcome - it has been quite popular! We deleted some test case Inflectra Support You are very welcome - it has been quite popular! We deleted some test case by mistake and we went on to recycle bin to restore one of the deleted Spira Team folders we found in there. After restoring the folder we can't load Spira-Team at all, we getan error message . Would you please assist us get our setting correct and recover test cases we deleted by mistake. Your assistance will be highly appreciated. Mon, 12 Dec 2011 11:20:32 -05002011-12-12T11:20:32-05:00/Support/Forum/spiratest/issues-questions/9.aspx#reply409messageId=417David J (support1@inflectra.com) The Windows recycle bin on the SpiraTest server itself is not related to the Undelete functionality The Windows recycle bin on the SpiraTest server itself is not related to the Undelete functionality inside the application. It sounds like you may have corrupted some of the SpiraTest program files by doing this. You probably need to backup your SpiraTest database, uninstall SpiraTest and then reinstall, then restore the backed-up database. Wed, 14 Dec 2011 15:00:44 -05002011-12-14T15:00:44-05:00/Support/Forum/spiratest/issues-questions/9.aspx#reply417messageId=680Jennifer Lalor (jennifer.lalor@baesystemsdetica.com) We deleted a number of test cases by mistake but when we went to Undelete them we could not see th We deleted a number of test cases by mistake but when we went to Undelete them we could not see them there to undelete. I believe what happened was that a folder was selected and then was delete hit by mistake so everything in the folder got deleted? Any ideas why these would not have appeared for us to Undelete? In the end we used the script provided above but that caused other issues so would love to find out about using Undelete in this instance. Thu, 23 Aug 2012 11:58:02 -04002012-08-23T11:58:02-04:00/Support/Forum/spiratest/issues-questions/9.aspx#reply680