Help Deleting all Accounts from CRM 4

[neemi]

We have just installed CRM 4.0 and are having a play with trying to import data into it from anoher aplication. However about 7000 accounts were loaded to CRM using the Tools > import data option on the menu, but I have since started having a play with CRM Data Migration Manager to try and load data more easily.

But before I load any data I want to delete all of the 7000 accounts already on CRM. Does anyone know of the best way to do this?

As if I select the tickbox on the accounts screen to select the accounts and then press delete it only deletes 50 at a time as that is all that appears to be selected. To do it this way wud take me forever.

I noticed that there is a bulk deletion facility but from What I can see this can only be used to delete details imported via DMM? unless I am wrong.

I am new to CRM and wud appreciate some direction and help with this please.

Help appreciated.

Neemi

 

[CRMBrad]

Something could be written to delete the leads programatticaly:

QueryExpression qe=new QueryExpression();
qe.EntityName=EntityName.account.ToString();
qe.ColumnSet=new AllColumns();

BusinessEntity [] entities=crmService.RetrieveMultiple(qe).BusinessEntities;
foreach(account a in entities) {
crmService.Delete(a.accountid.Value);
}

CRMBrad

http://www.streamsol.com

 

[jymm]

remember - I am a programmer - and this is probably not how MS would have anyone to it

if what you just did a sql delete?

delete AccountBase

this will get rid of just those records - problem of course is that it will leave all of the other records (like anything in the extensionbase, or contacts - orphaned - you could do same there.

seems that my friends who work for Inetium had a script to clear everything (except users and similar) for 3.0 when we installed - I will ask.

 

[jodonnell]

You can go into your user options and change then number of records to 250 per page. This would let you quickly delete 7000 records.

John O'Donnell
Microsoft Dynamics ISV Architect Evangelist
Microsoft Corporation

http://blogs.msdn.com/jodonnell

http://blogs.msdn.com/usisvde