Exporting large amounts of data from NAV 2015 - easy way?

nav13
nav13 Member Posts: 39
in NAV Three Tier
I need to export the routing line data out of nav 2015 either using packages (which takes forever) or excel - apprx. 500,000+ records. Is there an easy way to complete this without spending days?

Thanks,
NAV13

Answers

  • Wisa123
    Wisa123 Member Posts: 309
    If you need to do that export multiple times -> create a simple XMLPort.
    If its a one-time thing ->just export as csv from SQL Management Studio.

    At least that's what i would try/do.
    Austrian NAV/BC Dev
  • RockWithNAV
    RockWithNAV Member Posts: 1,184
    Exporting Data from SQL is much easier and fast as compared to Rapidshare or XMLPort, I will suggest export from SQL.

    Even if you dont want to export via opening Management Studio you can directly do this via Excel -

    1. Open Excel.
    2. Navigate to Data Tab.
    3. Press from Other Sources --> First Option.
    4. Enter the Credential Information and follow the Process.
    5. You are done with good Output.

    Enjoy.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • kriki
    kriki Member, Moderator Posts: 9,124
    Depends also what you need to do with it.

    If something that can read Odata needs it, you can create a page and publish that as a Odata page.

    You can also use bcp.exe from SQL server. It is for bulk import/export and because of that very fast.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • EvR
    EvR Member Posts: 178
    The easiest way:
    https://msdn.microsoft.com/en-us/library/dn495318(v=nav.90).aspx

Categories