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 <joe_rem...@yahoo.com> wrote: > ** > Develop a script to truncate table <table name>; 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 <ravi6...@gmail.com> > *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"
