Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Batch delete
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Batch delete

 Post Reply Post Reply
Author
Maluk View Drop Down
Groupie
Groupie


Joined: 24 March 2013
Status: Offline
Points: 28
Post Options Post Options   Thanks (0) Thanks(0)   Quote Maluk Quote  Post ReplyReply Direct Link To This Post Topic: Batch delete
    Posted: 24 September 2015 at 9:37pm
Is there any plans to add a batch delete feature rather than have to search and delete individually?

About 20% of my subscribers use yahoo, hotmail, their works email etc. and after a while these email addresses seem to be the ones that fall by the wayside, not found on server, mailbox full, expired etc.

I now have about 650 out of 5000ish subscribers with invalid emails and would like to occasionally clean up the database, but not one a a time.

It's pretty easy to have an import for email addresses you want to delete, much the same as the import for adding, comparing the members table with the new table for members you want to delete and clicking a button to delete matching emails and emptying the members delete table after completion.

At the moment I do it by importing the emails into a new table added to newspad database via phpMyAdmin then running a SQL query to compare and delete, of course you really want to delete the relevant records from the memcat table as well. It's all a bit long winded.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9727
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 25 September 2015 at 10:49am
It is on the 'to do' list to look at when their is spare time available, but as newpad is free there is nothing stopping you developing the feature yourself then submitting the changes to us to include in future releases.
Back to Top
Maluk View Drop Down
Groupie
Groupie


Joined: 24 March 2013
Status: Offline
Points: 28
Post Options Post Options   Thanks (0) Thanks(0)   Quote Maluk Quote  Post ReplyReply Direct Link To This Post Posted: 25 September 2015 at 11:33am
Thanks, I might just do that.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.05
Copyright ©2001-2022 Web Wiz Ltd.


Become a Fan on Facebook Follow us on Twitter Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2022 Web Wiz Ltd. All rights reserved.