Mass Delete

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   At one point I imported my entire parts inventory (about 17,000 products).  I now regret that becasue I will only be using a small fraction of those products.  I fear that these unused products will slow down queries to my access database.  Any suggestions on how to delete a massive amount of products at one time would be helpful.  The Global Change doesn't seem to have this option.
Thanks

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
bigrasta4life Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21-June-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote bigrasta4life Report Post Thanks(0) Quote Reply Topic: Mass Delete Posted: 20-September-2007 at 10:12am
	At one point I imported my entire parts inventory (about 17,000 products). I now regret that becasue I will only be using a small fraction of those products. I fear that these unused products will slow down queries to my access database. Any suggestions on how to delete a massive amount of products at one time would be helpful. The Global Change doesn't seem to have this option. Thanks
	K.K.

Stuck Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 09-March-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote Stuck Report Post Thanks(0) Quote Reply Posted: 20-September-2007 at 1:59pm
	This FAQ should be helpful to you: http://www.earlyimpact.com/faqs/afmviewfaq.asp?faqid=379

fidjiti Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 30-November-2006 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote fidjiti Report Post Thanks(0) Quote Reply Posted: 20-September-2007 at 2:30pm
	does the purge products allow you to select which products to purge or is it all of them? Also if purging the products does the system then go back to product ID #1 after purging all of them?
	Linda - I wish I knew ASP. To view my ever evolving site click the "www" button below. :)

bigrasta4life Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21-June-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote bigrasta4life Report Post Thanks(0) Quote Reply Posted: 20-September-2007 at 2:45pm
	that wont work for me. You must purge each product individually
	K.K.

Stuck Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 09-March-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote Stuck Report Post Thanks(0) Quote Reply Posted: 20-September-2007 at 3:53pm
	Bigrasta4life, Not sure if this would help or save you time, however, you could remove ALL of your currently existing products by running this "purgeallproducts.asp" Then re-import the smaller portion of the products you actually intended to use. Hope this helps!

bigrasta4life Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21-June-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote bigrasta4life Report Post Thanks(0) Quote Reply Posted: 20-September-2007 at 3:59pm
	i dont think so, how i interpreted purgeallproducts.asp is that it only purges products that have already been deleted from the control panel. so were back to stage one. I need a way to delete many products at once from the control panel and then purgeallproducts.
	K.K.

Stuck Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 09-March-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote Stuck Report Post Thanks(0) Quote Reply Posted: 20-September-2007 at 3:59pm
	Fidjiti, If you run this version "purgeproducts.asp", then you can individually select each product you want to delete from your Database. Hope this helps!

Stuck Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 09-March-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote Stuck Report Post Thanks(0) Quote Reply Posted: 20-September-2007 at 4:10pm
	Fidjiti, Yes, to delete individual products, then you would 1st delete them individually from your control panel, then to completely remove "all traces" of these products, you would run "purgeproducts.asp". In your case bigrasta is correct in that you would 1st delete the products from the control panel (unless you have already done so).

bigrasta4life Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21-June-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote bigrasta4life Report Post Thanks(0) Quote Reply Posted: 20-September-2007 at 4:18pm
	Stuck, That is what i've been saying. My original question was how do i delete a massive amount of products from the control panel without doing it individually. Is there any way to do this? THANKS
	K.K.

Stuck Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 09-March-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote Stuck Report Post Thanks(0) Quote Reply Posted: 20-September-2007 at 4:34pm
	Big, Only if you delete ALL of them with "purgeallproducts.asp" and then re-import the smaller number of products you actually want to use. I was only trying to explain that this may be faster with your particular situation in that you have so many products to be removed. However, in Fidjitis case, I am assuming she/he only has a small number of products to remove, so Fidjiti would 1st individually delete these products from the control panel & then run "purgeproducts.asp" (NOT "purgeallproducts.asp") Edited by Stuck - 20-September-2007 at 4:40pm