POWEROBJECTS

718 Washington Ave. N. Suite #101
Minneapolis, MN 55401
View map and all Locations

Send us a message

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.

crm2011

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.

  1. Extract Files to your local machine.
  2. Double click the ModifyMaxExport.exe
  3. In the Command Window type ‘Y’ and hit Enter.

CRM 2011 Online ModifyMaxExportTool

If changing the Maximum Export Records on a CRM Online Org, hit Enter again at the “Enter a CRM Server name and port” prompt.

 ModifyMaxExportTool

5. You will be presented with the following options

ModifyMaxExportTool for CRM Online

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

CRM 2011 Online Tools

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.

CRM 2011 Online ModifyMaxExportTool

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.

CRM 2011 Online ModifyMaxExportTool

9. Enter the new value you which to have for MaxRecordsForExportToExcel value and hit Enter.

CRM 2011 Online ModifyMaxExportTool

Once complete you’ll see “Update Complete”, and then hit Enter to Exit.

CRM 2011 Online ModifyMaxExportTool

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:
  1. 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

To receive a copy of CRM 2011 Online ModifyMaxExportTool you can open a case with Microsoft and request the tool or contact PowerObjects!

Happy CRMing!!

Avatar for JoeCRM

JoeCRM

Joe CRM is a CRM superhero who runs on pure Microsoft Dynamics CRM adrenaline. As the face of PowerObjects, Joe CRM’s mission is to reveal innovative ways to use Dynamics CRM and bring the application to more businesses and organizations around the world.