Deleting All Leads - Is It Possible?

[hrawling]

Hello:
I'm currently using the 30-day trial version. I imported about 3,700 records into "Leads". But for the life of me I can't figure out how to delete ALL of the records despite trying for the last 2 hours. When I click on the square box next to "Name" it selects only the first 20 records. How do I delete all of the leads? There must be some easy way to do this. The Knowledge Base was of no help unless I was looking for the wrong thing.

Thank you in advance for the solution.

Cheers,
hrawling

[kuske]

If you want to delete all leads so as Sugar does, then you can enter in mySQL queryBrowser:

update leads set deleted = 1;

Or you can delete all leads 'physically' by entering:

delete from leads;
delete from leads_cstm; -- if you have custom fields defined
delete from leads_audit; - if there were audit fields

DO NOT use the second method if you transformed leads to opportunities or referenced them anywhere else.


If you do not have mySQL access goto panel "admin" - "system settings" and increment "Listview items per page" to 500 or 1000 or anything else, take care of your timeouts.
Then you can delete them in greaer packages.

hk

[hrawling]

Thank you. I used the "Admin" panel option.

Cheers,