Re: Apt. way to delete foundation data
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:arsl...@arslist.org] On Behalf Of Raj Sent: August 20, 2009 1:31 PM To: arslist@ARSLIST.ORG 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 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 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:rmisoluti...@verizon.netARSlist: "Where the Answers Are" > > __ > _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"- Hide quoted text - > > - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Apt. way to delete foundation data
Hi Joe, When I have done this it was not too painful. There were not too many dependencies on delete, except for maybe Company. And loading the same info back in tends to highlight things that were not cleaned up. This was useful for us when validating the data load templates we were using. Plus we didn't need to be DBAs to do it :-) Chuck On Thu, Aug 20, 2009 at 4:01 PM, Joe DeSouza wrote: > ** > Develop a script to truncate table ; for all foundation data T, > H and B tables and reset ther corresponding nextid values to 1. That > would be the fastest way. > > Going to each form and deleting would amount to requesting delete action > through the AR System API layer and would not be the fastest way. > > Joe > > -- > *From:* Raj > *To:* arslist@ARSLIST.ORG > *Sent:* Thursday, August 20, 2009 1:21:01 PM > *Subject:* Apt. way to delete foundation data > > 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 > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Apt. way to delete foundation data
Develop a script to truncate table ; for all foundation data T, H and B tables and reset ther corresponding nextid values to 1. That would be the fastest way. Going to each form and deleting would amount to requesting delete action through the AR System API layer and would not be the fastest way. Joe From: Raj To: arslist@ARSLIST.ORG Sent: Thursday, August 20, 2009 1:21:01 PM Subject: Apt. way to delete foundation data 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 __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
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 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 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:rmisoluti...@verizon.netARSlist: > > "Where the Answers Are" > > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"- > Hide quoted text - > > - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Apt. way to delete foundation data
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 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 at www.arslist.org > Platinum > Sponsor:rmisoluti...@verizon.netARSlist: > "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Apt. way to delete foundation data
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 at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"