I have an installation with a lot of members that I want to cull.
There are too many to do it in the admin, so I want to use a sql query to delete members according to particular criteria.
I thought I should ask tho, will I need to do anything else in umbraco in order for these deletes to take effect. I ask as once I ran some sql to amend some doctype data, and I had to republish each item of the doctype by hand before the changes filtered through.
Members don't require a publish anyway, so that won't be a problem.
However, I'd still write a simple usercontrol that calls the Umbraco API to delete members, that way you can ensure your data's integrity. Once you delete through the API, you know that all of the properties (and maybe other related data) also get deleted.
HI I wouldn't delete Members using sql. A member has many relations with the UmbracoNode Table etc. Best to loop through the members and delete them if they match your criteria.
Deleting members via SQL
Hi All
I have an installation with a lot of members that I want to cull.
There are too many to do it in the admin, so I want to use a sql query to delete members according to particular criteria.
I thought I should ask tho, will I need to do anything else in umbraco in order for these deletes to take effect. I ask as once I ran some sql to amend some doctype data, and I had to republish each item of the doctype by hand before the changes filtered through.
Many thanks
Shaun
http://our.umbraco.org/projects/falm-housekeeping :)
Members don't require a publish anyway, so that won't be a problem.
However, I'd still write a simple usercontrol that calls the Umbraco API to delete members, that way you can ensure your data's integrity. Once you delete through the API, you know that all of the properties (and maybe other related data) also get deleted.
HI I wouldn't delete Members using sql. A member has many relations with the UmbracoNode Table etc. Best to loop through the members and delete them if they match your criteria.
Cheers,
Richard
Thanks all. I'll write something using the api to do it then.
Shaun: The FALM Housekeeping module looks like it would do the job though!
hmm, from the screenshots and text it looks like it's more for users rather than members, is that right? Its members I want to zap unfortunately.
You're right Shaun, I misread your post.
Best of luck, Rich
is working on a reply...