Answered by:
excel export limit

Question
-
Hi All,
I realized that the export to excel limits the records to 10K only.
I encountered this blog when I do some searching http://blog.customereffective.com/blog/2010/10/microsoft-dynamics-crm-40-how-do-you-export-more-than-10000-records.html
Do you know if this is supported by Microsoft ?
Thanks,
Minnardi
Thursday, May 9, 2013 3:42 PM
Answers
-
Hi,
A supported solution to increase this limit is to use the Organization Class of the SDK. Have a look at this code:
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); }
Remember to early bound before using this code (using the SvcUtil).
- Proposed as answer by Payman BiukaghazadehEditor Thursday, May 9, 2013 4:23 PM
- Marked as answer by Payman BiukaghazadehEditor Friday, May 10, 2013 5:58 AM
- Unmarked as answer by Minnardi Hendra Monday, May 13, 2013 5:12 PM
- Marked as answer by Payman BiukaghazadehEditor Tuesday, October 15, 2013 6:11 PM
Thursday, May 9, 2013 4:23 PMModerator
All replies
-
Hi,
A supported solution to increase this limit is to use the Organization Class of the SDK. Have a look at this code:
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); }
Remember to early bound before using this code (using the SvcUtil).
- Proposed as answer by Payman BiukaghazadehEditor Thursday, May 9, 2013 4:23 PM
- Marked as answer by Payman BiukaghazadehEditor Friday, May 10, 2013 5:58 AM
- Unmarked as answer by Minnardi Hendra Monday, May 13, 2013 5:12 PM
- Marked as answer by Payman BiukaghazadehEditor Tuesday, October 15, 2013 6:11 PM
Thursday, May 9, 2013 4:23 PMModerator -
Hi Payman, I forgot to mentioned that this is for CRM 4.0 not CRM 2011. Thanks, MinnardiMonday, May 13, 2013 5:12 PM