Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / ADXStudio Export Entit...
Microsoft Dynamics CRM (Archived)

ADXStudio Export Entity List Data to Excel

(0) ShareShare
ReportReport
Posted on by dkimbo

Hello,

I want to export data from an Entity List on my ADXStudio Portal site to an Excel sheet. Is this a feature that's available with ADXStudio? I've seen a few posts suggest using OData to export data into Excel, but is there an alternative to this solution rather than using the OData web service?

Thanks 

*This post is locked for comments

  • RP CRM Profile Picture
    RP CRM 20 on at
    RE: ADXStudio Export Entity List Data to Excel

    thanks Arpit - any trick for making the same change in CRM portals v8.3?

  • Arpit Shrivastava Profile Picture
    Arpit Shrivastava 7,518 User Group Leader on at
    RE: ADXStudio Export Entity List Data to Excel

    If you are using Adxstudio then add below lines in port web config file. It may help :

    <configuration>

     <appSettings>

       <add key="aspnet:MaxJsonDeserializerMembers" value="10000" />

     </appSettings>

    </configuration>

    Cheers

  • RP CRM Profile Picture
    RP CRM 20 on at
    RE: ADXStudio Export Entity List Data to Excel

    Does anyone know how to get around the 5,000 row limit when downloading a portal entity list to Excel?

  • dkimbo Profile Picture
    dkimbo on at
    RE: ADXStudio Export Entity List Data to Excel

    The issue got solved. It was a problem with my Grid Settings missing data in the Custom Parameters and using the wrong Dependencies. Thank you all for helping me!

  • Colin V Profile Picture
    Colin V on at
    RE: ADXStudio Export Entity List Data to Excel

    Sorry if you create a new entity list in IE do you have the same issue.  I mistook you were configuring a sub grid on an entity form.

  • dkimbo Profile Picture
    dkimbo on at
    RE: ADXStudio Export Entity List Data to Excel

    Sorry, but is that a setting in the Entity List form?

  • Colin V Profile Picture
    Colin V on at
    RE: ADXStudio Export Entity List Data to Excel

    If you create a new metadata for the subgrid in IE do you have the same issue?

  • dkimbo Profile Picture
    dkimbo on at
    RE: ADXStudio Export Entity List Data to Excel

    I got in contact with Microsoft Support about the issue and they also said to use a different browser. However, that was not the issue in my case. I still have a red error bar where my Grid Configuration panel should be, but the error text is now blank.

  • Verified answer
    Colin V Profile Picture
    Colin V on at
    RE: ADXStudio Export Entity List Data to Excel

    Hi Daniel, the this.jsoneditor.expandSchema error is related to the most recent version of Chrome and if you use IE you should be able to get around this issue.  The feature you mentioned, download action, is exactly what you're looking for.

  • Nick.Doelman Profile Picture
    Nick.Doelman 1,947 Most Valuable Professional on at
    RE: ADXStudio Export Entity List Data to Excel

    Cool!  I need to check that out.  Didn't know that was a feature.  Thanks for finding that!

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans