Generally we use phpMyAdmin which is installed by default on Vicibox servers. If there are very few leads, it is easy to check the delete box on all your dupes and select delete to remove them. If, however, there are thousands, it may be necessary to write a query to delete them. For instance, if the newly added leads start with lead_id 10001 and end with lead_id 20001, the query would be:
delete from vicidial_list where lead_id > '10001' and lead_id < '20001';
This same query also works from mysql directly if you do not have phpMyAdmin.
Which brings up a valid point: You are obviously a newbie and have not posted your configuration information. So here are your newbie suggestions:
when you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.
this IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)
You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system. If your installation is "Hosted" list the site name of the host.
If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.
Similar to This:
Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600
Happy Hunting!
![Cool 8-)](./images/smilies/icon_cool.gif)
(And Welcome to the Party!)