MS CRM Dynamics 2011 Database Field - Excel Export Limit

All replies

• 

  

  2

  Sign in to vote

  The only thing which i could think of when changing the database field is it might considerably affect the CRM performance. There are other ways which you could consider,

  Changing the registry setting - http://blog.customereffective.com/blog/2010/10/microsoft-dynamics-crm-40-how-do-you-export-more-than-10000-records.html?cid=6a00e54fb34b6f883301348883d01b970c

  But the best option (to me) is editing the query  - http://www.crmconsult.info/2010/05/10000-record-limit-on-excel-exports.html - As and when needed

  ---

  Cheers, Francis Edwin

  Follow me on: https://twitter.com/astutecrm

  My Blog: http://astutecrm.wordpress.com/ 

  • Marked as answer by kspicer Thursday, May 19, 2011 12:10 PM

  Tuesday, May 17, 2011 9:42 AM
• 

  

  0

  Sign in to vote

  How about CRM 2011 Online?

  When i try to modify the query in Excel, then i get a script error, and then a grayed dialog with no content. It seems like that exporting more than 10.000 records from CRM Online is impossible??

   

  regards

  Bo Møller

  Monday, September 5, 2011 1:35 PM
• 

  

  1

  Sign in to vote

  SDK supports raising this limit using Organization Class. Check following code that has been used in conjunction with Early bound classes created using SvcUtil.

  Microsoft.Xrm.Client.CrmConnection connection = new Microsoft.Xrm.Client.CrmConnection("Crm");
  XrmServiceContext context = new XrmServiceContext(connection);

  
  var orgs = context.OrganizationSet.Where(objO => objO.IsDisabled == false);
  foreach (Organization org in orgs)
  {
   Organization o = new Organization();
   o.Id = org.Id;
   o.MaxRecordsForExportToExcel = 50000;
   context.Update(o);
    
  }

  
  
  

  
  

  
  

  • Edited by Pranav Shah Friday, May 4, 2012 2:50 PM
  • Marked as answer by Andrii ButenkoMVP, Moderator Friday, October 5, 2012 11:21 AM

  Thursday, April 12, 2012 3:39 PM