«

»

Print this Post

NAV 2013 R2: Export objects with PowerShell

NAV 2013 R2: Export objects with PowerShell
1 vote, 4.00 avg. rating (87% score)

A while ago, I create a blog about a way to import objects in NAV with PowerShell. Well, it’s time to do the opposite, and export objects. This is the function I came up with (pardon the formatting – copy/pasting really made it difficult for me…):

 

I agree .. things can be improved. But I think it’s more than enough to get you going. I think it’s very usable in some kind of automated script where you want to export stuff to for example TFS and back.

The function is going to create one file each time you call it. For example:

 

 

This is going to create one file which contains the query-objects in the 700-range.

A way to create single files, is to play with the integers yourself, like this:

 

 

It is slow, but then again, it does its job, and there are ways to do it multithreaded in PowerShell as well ;-).

Permanent link to this article: http://www.waldo.be/2014/06/04/nav-2013-r2-export-objects-with-powershell-3/

2 comments

2 pings

  1. Kai Kowalewski

    Works nicely, but a ” seems to be missing in front of C:\Program Files in Line 18.
    I modified the function to include the servername as a fifth parameter and kept getting an error that the path C:\Progam does not exist (Win 7 OS) . After I inserted the ” it worked as planned.

    1. waldo

      It works on my end – but problems could arise when working with different versions of PowerShell. That might be what’s causing it .. .

      Thanks for the comment!

Leave a Reply

%d bloggers like this: