You could also just query the create date. These are regular tables after all. I often delete data based on create date and created by.
Open one of the tables you imported into, select advanced query, and say '3' >= "date_in_the_locale_you're_on" and '2' = "My_Login" then delete them. Knowing which tables to delete may be tricky as when you import you may have fired merge filters and further the user tool for some releases now never displays the real table name. Agreed, a restore of a database backed up before you imported is absolute. Field id 3 is always create date no matter what the field name. 2 is always submitter. Note that you cannot inhibit workflow on deletes except through SQL. Cheers Ben Chernys www.softwaretoolhouse.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Raj Sent: August 20, 2009 1:31 PM To: [email protected] Subject: Re: Apt. way to delete foundation data Thank you Charles for your reply. I will see if i have the database backup , may be as you mentioned , I could just restore the old one. Thanks, Raj On Aug 20, 11:54 am, Charles Baldi <[email protected]> wrote: > Raj, > You can do this a couple different ways, depending on which data > objects you want to reload. You CAN delete foundation data by hand > but you need to watch out for dependent forms that get populated by > workflow but don't cascade delete. I don't have my notes nearby from > when I did this before but you want to look at the "alias" forms for > company, site, etc. and people permission groups. Looking at the > various tabs in the DL spreadsheets can help you spot some of these too. > > The DMT does have a facility to change/delete some foundation objects > such as Companies. I have not used it to remove a lot of info but > this may be useful depending on how much you have to reload. > > Of course, a "safe" way would be to restore from database backup. You > have that, right? :-) > > How much data are you talking about? > > Chuck Baldi > > > > > > On Thu, Aug 20, 2009 at 1:21 PM, Raj <[email protected]> wrote: > > Hello all, > > Last month, I did foundation data uploads using ARImport tool. > > Leter I realized that using DMT for this is the best method. > > > So I want to clean up the data which i did imports through Import > > tool. > > > which is the best way to delete foundation data, is there any > > utility/ tool or should I just go to each forms and do the clean up? > > Is there any faster way ? > > > please advise, > > Raj > > > ____________________________________________________________________ > > ___________ UNSUBSCRIBE or access ARSlist Archives > > atwww.arslist.org Platinum > > Sponsor:[email protected]<sponsor%[email protected]>ARSlist: "Where the Answers Are" > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers > Are"- Hide quoted text - > > - Show quoted text - ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
