Export more than 5000 records to excel from RTC

Dear Experts,

Please guide me on how to export more than 5000 records to excel from RTC. Is this possible or Is this a limitation?

  • Ishwar

    I have found the same issue in Nav 2009 and Nav 2013 but are you saying you get the same issue on Nav 2016?

    Our work around is Copy and Paste rather than Send To.

    Neil

  • In reply to Neil Fraser:

    Hi Ishwar

     

    Please increase the length from 5000 to what to want. Below is the Screenshot. Navigate to Tools - Option

     

    Apart from this one more thing i want to say if you just want to export Data from NAV for any purpose then Use SQL to Export instead of NAV, Its much faster.

     

    Thanks

    Blog - https://rockwithnav.wordpress.com/

     

  • In reply to RockWithNAV:

    the solution of rockwithnav could work.

    you also could create a xmlport to export the lines or use the universal excel import/export tool, http://dynamicsuser.net/media/p/474170.aspx.

  • In reply to archer, MVP:

    Hi,

    The solution in the classic client will not work! 

    Go to the file:

    "C:\Users\YourUser\AppData\Local\Microsoft\Microsoft Dynamics NAV\ClientUserSettings.config"

    change the value of

      <add key="MaxNoOfXMLRecordsToSend" value="5000" /> 

    to

      <add key="MaxNoOfXMLRecordsToSend" value="1000000" />

     

    This solves your problem in the RTC, but you have to do it on every client.

     

    best regards

    Robert

     

  • Thanks Neil, RockwithNAV, Jonathan and Robert for your replies. I tried Robert's suggestion and it works for me. Thank you everyone!

  • In reply to Ishwar Sharma:

    hi,
    i have the same issue...which Nav Version do you have? i have Nav 2016 but i don t know why i can not see this File "ClientUserSettings.config", any idea?
    thank you.
  • In reply to Amaytors:

    Hello,

    you have to C:\Users\Current User\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\

    In the next folder with the NAV version number you can find the ClientUserSettings.config

     

    best regards,

Related