How do I delete an ACCOUNT associated to an imported Lead?

[FrischInBigD]

I have imported a Lead list for email campaigns, and most of those Leads have corresponding Accounts that were also created during the import process.

I have decided to delete all the Leads from the system and start over (because the imported list should have been scrubbed better). I can easily delete all the imported Leads, BUT the Accounts that were created from the imports still remain in the system.

How do I now delete those Accounts without removing other legitimate Accounts that have contacts?

Thanks!

[robertbmirth]

Depending on your situation, there are a few ways to do this:
-The most exact way would be to go to the manually delete all the accounts that occurred during the import. Not gonna lie, depending on how many accounts you have, could take a while.
-Another way would be to do a search for all accounts created by you on whatever day you did your import. If you created other accounts on that day this could be an issue.
-If you know a little sql, you can go into your database and update all the accounts created within a certain timeframe of the import. The sql would look something like this: update accounts set deleted = 1 where date_entered > some_time and date_entered < some_time_plus_an_hour and created_by = your_user_id

Note that, again, if you do know some sql and you screw up, Sugar doesn't delete records until it prunes its database (usually on the 1st of the month if you have it set up) so if you do screw up you can pop into your database and undelete the records. note again, however, that if you do this, you need to make sure you undelete all the relationships as well.

[rafael.q.g@hotmail.com]

I think the faster way for non developer user, is to search accounts by creation date (so the created date has to be available on search panel), and select the importation date.

Then select all accounts, and mass delete them.

To avoid delete other accounts created at the same date, you could config your page to display entries enough to list all your accounts, and display in this list some column as created by, then you can check and delete just the accounts created by you (or you could filter by created by field also).