Bulk deletion of lists

[spacejanitor]

Hi all,

Wondering if there is some way to quickly delete a whole bunch of lists from ViciDial. We regularly add a list or two a day, so after a few months you can imagine what the database looks like.
I could just delete them manually through mySQL, but I'm thinking there would be some references or pointers from other tables that would be broken.

[williamconley]

deleting the lists in sql does not delete the leads.

deleting the leads and the lists will eradicate them from the system completely ... but if you just want to "clean up the list display" but not lose the leads, you can delete them in sql and recreate them if you ever need them again. The leads will still appear in queries and searches, but will not be dialable (as there will not be a "lead" in the a "list" in a "campaign" ... the list link is missing).

Deleting them in Vicidial deletes the list and all leads in it. Deleting the list from SQL deletes the list but leaves the leads.

[spacejanitor]

Ahh understood. In this case i would like to delete both thr lists and leads. Is there a quick way to do that?

[williamconley]

delete from vicidial_list where list_id IN ('xxxx','xxx','xxxx')

delete from vicidial_lists where list_id IN ('xxxx','xxx','xxxx')

beware: no "undo".

backup first!

[spacejanitor]

Thanks. Is this a verifiably safe way to delete them? ie, are those the SQL queries that are run when deleting through the GUI?

[williamconley]

there is no "safe way to delete". If you run the command properly it's always safe, but the word delete, if you make a mistake, can be deadly. Backup Before Beginning. LOL

You can also add "limit 1" to the end of each of those statements and "observe" the results (ie: is one of them missing?). At least the damage is contained ... but mostly it's about understanding mysql and the "where" clause which will limit the records affected.

[Acidshock]

Dont forget custom fields!