Portal Engine
Version 3.x > Portal Engine > Bulk Data Deletes View modes: 
User avatar
Member
Member
chris-ricochetpartners - 1/16/2009 7:04:26 PM
   
Bulk Data Deletes
Hi,

I am wondering what the Best Practice for bulk data deletes would be. I have a whole bunch of custom data items that I imported that I now need to delete from the system. Is it sufficient to delete all the records from the custom data table or will this cause problems in the tree since node relation data will still exist somewhere?

Thanks for the help

User avatar
Member
Member
chris-ricochetpartners - 1/19/2009 1:49:53 PM
   
RE:Bulk Data Deletes
As I suspected, deleting data out of a custom table does cause issues with the tree. Are there any administrative scripts available to cleanup the tree when the documents are missing?

User avatar
Kentico Consulting
Kentico Consulting
kentico_mirekr - 1/20/2009 7:13:52 AM
   
RE:Bulk Data Deletes
Hi,

Unfortunately, there are no administrative scripts for database cleaning. However, we strongly recommend you to use our API to manage documents in code:

http://devnet.kentico.com/docs/devguide/content_management_internals.htm

Best Regards,
Miroslav Remias