Project

General

Profile

Mass delete leads from a list

Added by Sandro Vespucci about 1 month ago

how can I delete some 100 contacts from a list of 1000 contacts massively


Replies (3)

RE: Mass delete leads from a list - Added by Demian Lizandro Biscocho about 1 month ago

Download your list and delete the 100 contacts and then re-upload it. Or you can do it via SQL commandline.

RE: Mass delete leads from a list - Added by Leopoldo Martinez about 1 month ago

Hello, I am trying to massively delete records from my GAD v4, specifically from the "vicidial_list" list, but I want to delete only the records that in the "status" column say A, AA, B, AB, NP, among others. I use navicat to manage the database, and to delete the records that are no longer functional, I must do it manually. My question is if anyone can help me with any SQL command that works for this purpose. The command I have been trying to use is "DELETE FROM 'asterisk'. 'Vicidial_list' WHERE 'status' = A;" but this doesn't work for me, it tells me that I have a syntax error. Any ideas or help?

RE: Mass delete leads from a list - Added by Demian Lizandro Biscocho about 1 month ago

You can try using phpmyadmin (https://www.phpmyadmin.net) on your server. This will provide you with a web based GUI for MySQL/MariaDB for easier database navigation.

If you need to do it via SQL CLI, try the following:

mysql asterisk -uroot -p -A
MariaDB [asterisk]> delete from vicidial_list where status="A";
    (1-3/3)
    Go to top