Monday, December 13, 2010

Microsoft Dynamics CRM limits export to 10000 rows to Excel

Our customer is making lists of contacts to send then in third parties for process. The number of contacts in those list can be larger than 50000. When we made an export to excel we saw that only 10000 contacts where exported. It turned out that there was a limitation in the organization database for exporting only 10000 rows from excel. The solution was easy. We changed the limit value from sql server (table OrganizationBase field MaxRecordsForExportToExcel). The query was:

update OrganizationBase set
      MaxRecordsForExportToExcel = 65500

After the query we made a restart of iis and everything worked.

No comments:

Post a Comment