Subscriptions for deleted users - Bring2mind

Site
Web

Bring2mind Forums

Forums
Search Forum
Advanced SearchTopicsPosts

Prev Go to previous topic

Go to next topic

Forums Document Exchange Lite UI

Last Post 02/08/2007 2:51 PM by Mike Willard

Subscriptions for deleted users

4 Replies

Sort:


You are not authorized to post a reply.

Author

Messages

Mike Willard

New Member
Posts:44

02/06/2007 12:59 AM
We've now been using DNN w/AD authentication for about 1 year and have realized that something needs to be done to "clean up" users who no longer exist in AD, but have DNN user accounts. I'm considering writing a script to compare DNN users to AD and delete those records from the database where no AD account exists. The question is, what happens when a user is subscribed to a collection in DMX and the user has been deleted? Will there be a flood of undeliverable emails? Thanks in advance... Mike

Peter Donker

Veteran Member
Posts:4536

02/06/2007 11:26 PM
Mike, If anything DMX won't be able to find the email. But under normal circumstances the subscription are 'cascade deleted' after a user is removed. Peter

Mike Willard

New Member
Posts:44

02/07/2007 9:33 PM
Peter, Just to be clear, I'm talking about a query to go in and directly delete user records from the DNN user table, not removing them via the DNN admin interface. I know this is beyond the scope of DMX support, but I'm just wondering what the implications are? I have a SQL user table that is updated nightly with up to date information from AD and I would like to do a simple comparison to remove those users in DNN that no longer exist in AD. I'm not following how the subscription information in DMX would also be removed in this scenario. Thanks Mike

Peter Donker

Veteran Member
Posts:4536

02/08/2007 12:03 AM
Mike, As a module developer I only have the DB to go on. So it doesn't matter if you do it by hand or through the DNN interface: my modules just look at the data in your DNN database. There should be a cascade delete on the DMX_Subscriptions and DMX_Log. There is one other reference to users in DMX_Entries, but that should not affect program running. In any case: if you see anything weird it is easy to repair: you just set the UserId field to the admin's ID for all those that are left hanging in mid-air. Peter

Mike Willard

New Member
Posts:44

02/08/2007 2:51 PM
Excellent suggestion! Thanks!

You are not authorized to post a reply.

Forums Document Exchange Lite UI

About Bring2mind

Bring2mind is the company of Peter Donker, a DotNetNuke enthusiast who has been involved with the platform from the very beginning. At the same time as the market for modules emerged, he realized there was no good document management solution for the platform yet and he set about creating this. In part he based the module on his experience with other document management systems he used while working as a researcher. His module, Document Exchange, was an instant success and has since become the premier document management solution for DotNetNuke. In 2004 he created Bring2mind as a vehicle for the module and is one of the few successful businesses solely based on a DotNetNuke product.

Contact Info

Please note we are located in Europe. Business hours are weekdays between 9 AM and 6 PM local time (Central European Time) which corresponds to 3 AM and noon EST.