Answered by:
MS CRM Dynamics 2011 Database Field - Excel Export Limit

Question
-
Microsoft Dynamics 2011 has recently been deployed for a part of our organization. We have a need to increase the 10,000 entity limit in exporting to Excel and have found information about changing a database field to accomodate this change. My question is this: are there any other known impacts of changing this database field to 100,000 records for exporting to Excel??Monday, May 16, 2011 6:56 PM
Answers
-
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 -
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
All replies
-
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 -
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 -
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