Friday, October 05, 2012

Tool that increases limit of record during export to Excel for Dynamics CRM 2011

One of my customers wanted to increase this limit. I made small investigation and discovered that setting that controls limit of records is stored at Organization entity in MaxRecordsforExportToExcel column. The easiest way to change this setting for On Premise of course was to Update directly OrganizationBase table but customer’s CRM is OnLine. So I developed small tool that allows to connect and update this setting using CRM Sdk.
I’m very appreciated to MVP fellow Tanguy Touzard who created Connection Control. This amazing assembly decreased development time down to 1 hour. How it works:
1. Run Application.

2. Connect to CRM.




3. Fill ‘Export to Excel Limit’ field.
4. Click Update.
Once this is done limit will be changed.
You can download tool here:

8 comments:

  1. nice, thanks for sharing

    ReplyDelete
    Replies
    1. Edit one SQL table... That,s all. Why use this tool?

      Delete
    2. 1. It seems that direct SQL Update is not recommended and definitely unsupported approach.
      2. Do you have an access to SQL DB in CRM Online? Not sure. Tool does update using SDK.

      Delete
    3. it's awsome
      thanks for sharing

      Delete
  2. For CRM Online tenant Database tweak is not an option, so this tool might be the way to go. For developers who are not comfortable running this tool on your environment, check this blog that explains how to write your own simple scripts. http://thabscrm.wordpress.com/2012/04/23/crm-2011-increase-export-to-excel-limit-10000/

    ReplyDelete
    Replies
    1. I am very appreciated for your reply but I already know how to do it for OnPremice using SQL.

      Delete