I did a migration of my Goldmine 6.7 contacts to MSCRM a month or two ago,
just to try out MSCRM for functionality. Now I'm happy to go ahead with the
real migration, and move all data over. I thought I could just select all
contacts and delete them, and start fresh. I can't seem to find an answer to
this, and I don't really want to uninstall and reinstall the program. Any
ideas?

How many do you have? You can set the option in the web UI to view 100
records at a time, do an Advanced Find, and delete them 100 at a time.
(Actions > Delete after clicking the checkbox to select them all).
--
Matt Wittemann
http://icu-mscrm.blogspot.com


"claytonvac" wrote:

If you have done the migration some time ago already, you might have found
some fields which you do not want to have in crm anymore. This is a good
change to reinstall the whole product and start from a clean point again.

If you want to continue working with this installation, and there are way to
many contacts to use matt's solution, then you might want to change the
deletestatecode in the database for every contact to 2. This will tell the
deletion service to delete all the contacts including their references.

Hope this helps,

Ronald Lemmen
Avanade Netherlands

"MattNC" wrote:

How do I enter into the database to change the code to 2?

"Ronald Lemmen" wrote:

First I'd like to warn you that you should not do database modifications if
you do not know exactly what you are doing. I would advice to use matt's
solution and delete them the way you should. At all times first make a backup
of your database before doing any modifications.

Modifying the database you can do with the tool "query analyzer". Connect
this tool to the table ContactBase and there run the query:
UPDATE ContactBase SET DeletionStateCode='2'

Hope this helps,

Ronald Lemmen
Avanade Netherlands
"Chapman" wrote:

The only question I would have is, are there other records you have added since
then? If so, even the update to the deletionstate won't work s the dependant
recs won't be flagged.

Uninstall/reinstall shouldn't take that long. If you are not savy with doing
SQL queries, then I would recommend that approach. It won't take nearly as long
s the intial install did (assuming you use the same service accounts) and it is
a lot safer.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Thu, 25 Aug 2005 00:55:04 -0700, "Ronald Lemmen"
<RonaldL@-REMOVETHIS-avanade.com> wrote:

First I'd like to warn you that you should not do database modifications if
you do not know exactly what you are doing. I would advice to use matt's
solution and delete them the way you should. At all times first make a backup
of your database before doing any modifications.

Modifying the database you can do with the tool "query analyzer". Connect
this tool to the table ContactBase and there run the query:
UPDATE ContactBase SET DeletionStateCode='2'

Hope this helps,

Ronald Lemmen
Avanade Netherlands
"Chapman" wrote:

Can I assume that I can do the same thing with leads?

Would the statement be:?
"UPDATE LeadBase SET DeletionStateCode='2'"

"Ronald Lemmen" wrote:

To answer my own question. It can be done. It looks like it worked, but I am
no DBA. No real problems....yet.

Adam

"Adam Steinhoff" wrote: