Mittwoch, 1. Februar 2012

Summary: How to change the maximum number of records that you can export from Microsoft Dynamics CRM 2011/4.0/3.0 to a Microsoft Office Excel worksheet

Change Excel Export Limit for Microsoft Dynamics CRM 2011

In Microsoft Dynamics CRM 2011 ist die Anzahl der Datensätze, die man nach Excel exportieren kann, auf 10.000 begrenzt. Es gibt keine Möglichkeit diese Grenze zu erhöhen – kein supportete Möglichkeit. Unsupportet sieht das ganze schon anders aus. Mit folgendem SQL-Statement kann man die Grenze auf z.B. 2 Millionen erhöhen: UPDATE [OrganizationDatabaseName].[dbo].[OrganizationBase] SET [MaxRecordsForExportToExcel] = 2000000 Folgende Parameter muß man ersetzen: - OrganizationDatabaseName: Name der Datenbank der Organisation - 2000000: Neue Grenze der maximal zu exportierenden Datensätze
Natürlich sollte man immer damit rechnen, dass das Ganze in einem Timeout endet, wenn man es übertreibt. =================================================================== See the same change for Microsoft Dynamics CRM 3.0 and Microsoft Dynamics CRM 4.0 Increase the Maximum Records exported to Excel When exporting a large amount of records from CRM to Excel you will find that the maximum number of records that can be exported are limited to 10,000. By default, you can export a maximum of 10,000 records from Microsoft Dynamics CRM to an Excel worksheet by using the “Static worksheet with records from all pages in the current view” feature. If you export more than 10,000 records, only the first 10,000 records are exported. You do not receive a warning message that lets you know that only the first 10,000 records were exported. In Microsoft Dynamics CRM 3.0, the change is to edit a registry key, which is noted in the following KB article. How to change the maximum number of records that you can export from Microsoft Dynamics CRM to a Microsoft Office Excel worksheet http://support.microsoft.com/kb/911395/ In Microsoft Dynamics CRM 4.0, you can change the maximum number of records by changing a database value. Follow the steps below to make the change at the database level in CRM 4.0
  1. Open SQL Mangement Studio
  2. Use the <organization>_MSCRM database
  3. Open the OrganizationBase table
  4. Locate the column – MaxRecordsForExportToExcel
  5. Change the value to the new value

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Free Samples By Mail