We often see a request to increase the amount of records that can be exported from CRM at one time. The default value is set to 10,000, so the maximum records you can export to Excel at one time is 10,000. Microsoft has now created a tool that can access this field in a¬ CRM Online organization database and allow you to increase this value. Say Hello’ to¬†CRM 2011 Online ModifyMaxExportTool.
This tool can also be used with OnPremise version of CRM and there is a read me file included in the tool that contains the steps.
Here are the instructions copied from the Read Me included in the tool from Microsoft.
- Extract Files to your local machine.
- Double click the ModifyMaxExport.exe
- In the Command Window type ‘Y’ and hit Enter.
5. You will be presented with the following options
Choose the appropriate number for your CRM Online deployment region and hit enter
6. Now enter your WLID and hit Enter.
Next enter your WLID Password for a CRM Administrator and hit Enter
7. Next you’ll be presented with a numbered list of organizations which your WLID is a member. Type in the number of the Org which you which to update the maximum number of records you can export and hit Enter.
8. After you specify the Org you will be shown what the current MaxRecordsForExportToExcel value is set to, and then type in ‘Y’ and hit Enter to change the value.
9. Enter the new value you which to have for MaxRecordsForExportToExcel value and hit Enter.
Once complete you’ll see “Update Complete”, and then hit Enter to Exit.
If you increase the value and you receive a time-out error while exporting the records configure the steps below.
- Increase the Maximum Connections of Internet Explorer:
- Outlook inherently uses Internet Explorer to help render web content. Although the 2011 version of the client relies heavily on mapi integration to display data, increasing the maximum number of connections for Internet Explorer can help mitigate performance issues. The KB article listed below contains a “Fix It” to increase the maximum number of connections for Internet Explorer:http://support.microsoft.com/kb/282402
- Change timeout on connection:
- Locate the TcpTimedWaitDelay key in the registry:
- HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTcpipParameters (select Parameters)
- Check if the TcpTimedWaitDelay registry exists or not. If yes set the Decimal value to 300. If no follow the below steps:
- On the Edit menu, point to New, click DWORD Value and then add the following registry value:
- Value Name: TcpTimedWaitDelay
- Value: 300