Export selection of objects as separate textfiles

Administrator · 2015-03-03

Export selection of objects as separate textfiles
While doing an upgrade from NAV2009R2 to NAV2015 I found that the powershell cmdlet Split-NAVApplicationObjectFile was very slow. (took more than 12 hours to run)
Maybe because of the setup of the virtual machine I was working on, but that's why I decided to make this small Powershell script that will export all selected objects as separated txt files, using the same naming convention as the Split-NAVApplicationObjectFile function.

It first queries the object table with a given filter and it uses the result set to show to the user.
The user then selects the objects he wants to export. All selected objects will be exported using a call to finsql.exe -exportobjects for each found record.

So it is actually quite simple.

http://www.mibuso.com/dlinfo.asp?FileID=1646

Discuss this download here.

kine · 2015-03-03

There must be something with the VPC, really. Split of 7000 objects takes just few seconds on my PC.

Remco_Reinking · 2015-03-04

Hi Kamil,
I suppose so, I had almost 6000 objects, the first 5900 went through very fast, but it took ages for the last part to be processed.
Anyway, it was a nice way to learn some more about Powershell.
greetings, Remco

Kowa · 2015-03-06

Were you using the latest version?
The initial version of the Split Cmdlet had severe performance issues in some environments (mine too

), but that has been fixed. There were also some other cmdlets with bugs. The new versions were released with NAV 2015 Cumulative Update 2.
http://blogs.msdn.com/b/nav/archive/2014/10/03/merging-application-objects-using-windows-powershell-in-microsoft-dynamics-nav-2015.aspx?PageIndex=2#comments

Export selection of objects as separate textfiles

Comments

Categories