Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
CRM 2011: How do i change max records for export to Excel

Proposed CRM 2011: How do i change max records for export to Excel

  • Monday, August 15, 2011 5:37 AM
     
     
    Sign In to Vote
    0

    Hi there,

    I found this on the web. Is this a supported way to do it?

    update

    [CRM_MSCRM].[dbo].[OrganizationBase] SET [MaxRecordsForExportToExcel] = 300000 where NAME =

    'CRM'

     

All Replies

  • Monday, August 15, 2011 6:08 AM
     
     Proposed
    Sign In to Vote
    0

    Hi,

    Making direct change sintot he CRM database is not supported and dfinately an unsupported way and on installing updates your change may override. There is no supported way available to change the export to excel record limmit.

    As an alterate way if you like to export records over 30,000 then you may use a CRM Export Data Tool available at codeplex that will allow you to export data in a shot (csv format, you can open in excel file), the tool was developed for CRM 4.0 but with few minor changes into the configuraiton file it works fine with the CRM 2011

    For further iformation you may reffer: http://nishantrana.wordpress.com/2011/05/09/using-bulk-data-export-tool-of-crm-4-0-with-crm-2011/

    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
     
  • Monday, August 15, 2011 1:10 PM
    Moderator
     
     Proposed Has Code
    Sign In to Vote
    0

    Updating the MaxRecordsForExportToExcel is a supported change; however, it is not supported to update it directly in the database.

    You should be able to update it using the web services:

    Organization organization = new Organization();
      organization.Id = orgId;
      organization.MaxRecordsForExportToExcel = 300000;
      service.Update(organization);

    Gonzalo | gonzaloruizcrm.blogspot.com

     
  • Friday, October 28, 2011 7:55 PM
     
     
    Sign In to Vote
    0

    You can also create a New report off of the advanced find you have saved.  Run the Report and export the report to excel.  This works in CRM 2011 online as well.