How To delete Targets

[aviwebtouch]

Hi I am trying to run a campaign with 100,000 email addresses.Im in teh porcess of importing the CSv list and am stuck witha problem , how do i delete all teh targets in one go without reinstalling Sugar CRM over and over agin.. Please help

[czei]

I've got exactly the same problem. I'm trying to import tens of thousands of targets, and somehow the process hung and only about half got in. I'd like to delete everything and start over, but how can I delete 20,000 targets at one go? The idea that I'm going to delete them 25 or 50 at a time is ridiculous!

[kpit]

increase the max memory (512M) and max execuition time (1000) in php.ini.

[khinester]

You should also change the

Listview items per page:

In the Admin -> System Settings -> User Interface page to the number of items you wish to view per page.

HTH

[khinester]

Hi I am trying to run a campaign with 100,000 email addresses.Im in teh porcess of importing the CSv list and am stuck witha problem , how do i delete all teh targets in one go without reinstalling Sugar CRM over and over agin.. Please help

Perhaps you can delete these directly from MySQL

mysql> select * from prospects;

This will list your prospects. So I guess something like:

mysql> delete * from prospects where date_entered = 'xx/xx/xxxx';

Not tested and maybe this will break other DB relationships.

HTH