Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Need more than 10,000 exporttoexcel RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Good afternoon,

    I need to change the exporttoexcel to 200,000, I am on MSCRM 4.0, I researched and found how to go into SQL and change the number, but it has not changed anything.  What do i need to do to "sync" the changes on SQL to my computer? Is there another way to change this?

    Thanks!

    Tuesday, July 13, 2010 8:24 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Have you tried these steps and an IISRESET?

    http://blogs.inetium.com/blogs/microsoftcrm/archive/2008/06/18/exporting-more-than-10-000-records-to-excel-in-crm-3-0-4-0.aspx

    Phil Edry - http://www.altriva.com/AltrivaBlog.aspx

    Phil Edry – Altriva Solutions – Solution Developer
    Tuesday, July 13, 2010 9:23 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    If it is for a once-off dynamic export, you can always edit Excel's underlying query by right-clicking on cell A2 and selecting edit query...

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog

    http://leontribe.blogspot.com/ 
    or hear me tweet @leontribe

    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    • Proposed as answer by Leon TribeMVP Tuesday, July 13, 2010 9:36 PM
    Tuesday, July 13, 2010 9:36 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Unless you're over IFD, in which case it'll be a fetchxml query that you can't update, I believe.
    Phil Edry – Altriva Solutions – Solution Developer
    Tuesday, July 13, 2010 10:06 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You can try update the organization by the CrmService:

                    organization organization = new organization();
                    organization.organizationid = new Key();
                    organization.organizationid.Value = organizationGuid;
                    organization.maxrecordsforexporttoexcel = new CrmNumber();
                    organization.maxrecordsforexporttoexcel.Value = 200000;
                    service.Update(organization);

    Batistuta Cai | MSCRM MVP | www.techsun.com
    Wednesday, July 14, 2010 3:07 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    what finally did it for me was the explanation on another thread

    http://social.microsoft.com/Forums/en-US/crm/thread/c90867c1-88e9-45e0-8385-04454c882951 

    Vote As Helpful

    Okay , Just run following query with out condition

               Update OrganizationBase

              Set MaxRecordsForExportToExcel = 50000

     

    • Marked as answer by TSPB Wednesday, July 14, 2010 1:12 PM
    Wednesday, July 14, 2010 1:11 PM