Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Get excel from crm 2015
Microsoft Dynamics CRM (Archived)

Get excel from crm 2015

(0) ShareShare
ReportReport
Posted on by altun8tr 260

Hi ,

I have a view in a crm page. This view has 649301 records. I want to export them to excel in one bbutton click in crm 2015. I cahnged the OrganizationBase table MaxRecordsForExportToExcel column value  to '90000000' and i reset the iis. I also rearange the mscrm config by using this code:

USE MSCRM_CONFIG
GO
Update DeploymentProperties
Set IntColumn=90000000
Where ColumnName='TotalRecordCountLimit'

Now the problem is : when i bress the button nothing come to me. By usinf F12 i can see that error:

VM1491 global.ashx?ver=-474550770:8 POST crm15.boydak.com/.../print_data.aspx 502 (Bad Gateway)

So nothin happens than . I can not get the excel list of all records in one click. 

The image of this page is in attachment. Can anyone help me plaese.

0815.excel.png. 

*This post is locked for comments

  • Suggested answer
    Andreas Cieslik Profile Picture
    Andreas Cieslik 9,265 on at
    RE: Get excel from crm 2015

    Maybe this can help you:

    dreamingincrm.com/.../new-xrmtoolbox-plugin-export-to-excel

  • altun8tr Profile Picture
    altun8tr 260 on at
    RE: Get excel from crm 2015

    Thanks Adreas. Can you give me an exampla about this client tool. For example what...

  • Suggested answer
    Andreas Cieslik Profile Picture
    Andreas Cieslik 9,265 on at
    RE: Get excel from crm 2015

    As I described before the hard limit is 100.000.

    For Excel exports you need to work with filters to get chunks of 100.000.

    Alternatively you need to implement a client tool that can do that for you.

  • altun8tr Profile Picture
    altun8tr 260 on at
    RE: Get excel from crm 2015

    My problem continues. Please anyone help me.

  • altun8tr Profile Picture
    altun8tr 260 on at
    RE: Get excel from crm 2015

    Thanks Andreas . I did the changes. However, this did not help me. I changed MxRecordsForExportToExcel field to 900000.

    when i want to get the excel of the list. The process cut the operation. I can not get the the excel file. It id too long i think. What can i do now?

    7357.d.png

  • Suggested answer
    Andreas Cieslik Profile Picture
    Andreas Cieslik 9,265 on at
    RE: Get excel from crm 2015

    I think even that you can set the IntColumn to any number the internal built-in CRM limit seems to be around 100.000 records.

    A supported tools to modify this value is here:

    blog.sonomapartners.com/.../need-to-export-more-records-to-excel-weve-got-you-covered-with-the-orgdborgsettings-editor.html

  • Suggested answer
    Wayne Walton Profile Picture
    Wayne Walton 13,726 on at
    RE: Get excel from crm 2015

    You almost certainly are going to run into a SQL timeout trying to do that, and Excel itself isn't going to be happy with a file of that many records (It should technically be supported in any current version of Excel, but it will still be slow to open).  Plus, even if you do get it to work, it will take a LOOOOOOOONG time to actually export.

    Considering this is clearly not something that should be done very often, maybe it would be better to pull an excel file directly from the database instead?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,253 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans