web 2.0

Tuesday, June 17, 2008

Exporting more than 10000 records in CRM 3.0

If you are performing a CRM implementation where the number of contacts is large, you will notice when trying to export all the contacts from a view to excel, that only 10000 records are exported. This won't have an impact if the number of contacts is less than 10000 but it would make a big difference when dealing with a larger number of records.

In order to get all the records in the view, you have to do perform some registry editing.
Here are the steps :

1. Log on to the Microsoft Dynamics CRM 3.0 server as a user who has Write permissions for the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM

2. Click Start, click Run, type regedit, and then click OK.

3. In Registry Editor, locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM

4. On the Edit menu, point to New, click DWORD Value, type maxrecordsforexporttoexcel, and then press ENTER.

5. Double-click maxrecordsforexporttoexcel, click Decimal, type the maximum number of records that you want to export to an Excel worksheet, and then click OK.

6.Close Registry Editor.

Cheers,

1 comment:

Christian said...

Nice one! Do you know if it's the same solution for CRM 4? I'll test it out regardless.

Thanks,
-Christian
www.crmdynamo.com

Post a Comment