CRM – Maximum number of records exported


Today, I encountered a limit when exporting records from CRM (versjon 4) to Excel. I only got the first 10,000 record in the Excel file and the customer wondered why. After some googling and help from collegues, I found a work-around. This approach worsk, but isn’t reccomended to do without contacting Microsoft through a support request. If the MaxRecordsForExportToExcel is changed without their approval (given in support request in most cases), you might loose support privileges in the future.

So, if you can wait for the processing of your support request, do that. If you can’t wait and absolutly need to export more than 10k records, this is the approach in CRM 4:

1. Login to the SQL Server where the <Organization_Name>_MSCRM database is stored
2. Open the OrganizationBase table
3. Find the Column:  MaxRecordsForExportToExcel
4. Change the value from 10,000 to the desired value
5. Committ the change to the database

Script:

Use <Organization_Name>_MSCRM ;
UPDATE OrganizationBase
SET MaxRecordsForExportToExcel = <new numer>
WHERE Name = <Organisation> ;

If you have just 1 row in table OrganizationBase, you don’t need the WHERE clause in the script above. In my case, I used 50000 as the new number, that allows me to export 50k record at the time to Excel.

UPDATED: I had to restart the SQL server and the CRM servers to get this working correctly.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s