Object Exporter

Administrator

Object Exporter
This simple utility allows those of us without a Solution Center Developer's License to easily select and export to text those objects we are licensed to use.

"Object Exporter" loads all of the objects in your database into a form designed to look like the Object Designer. Use "View--> Marked Only" to filter out the objects that would normally blow up your export with a "You do not have permission..." error. Other filters can be applied as well.

When you click "Export", selected objects will be exported in Text or XML to a path/file of your choosing.

Note: This function uses the new NAV 2009 function EXPORTOBJECTS. It will not work with earlier versions of Dynamics NAV.

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

Discuss this download here.

rocatis

Unfortunately, the EXPORTOBJECTS function shares its permissions with the "manual" export function, meaning that you can only use the function if you're running on a developer license...

I guess you never tested the utility with a non-developer license #-o

JamieHurst

rocatis wrote:

...the EXPORTOBJECTS function shares its permissions with the "manual" export function, meaning that you can only use the function if you're running on a developer license...

Thanks for the feedback, Brian.

Yes, of course you're only going to be able to export to text if your license allows it. I wasn't trying to do anything shady here. I appreciate you clarifying this point, it didn't occur to me that people might think otherwise.

I was actually addressing a different problem: bulk-exporting objects to text is a big pain in the keister if you're not licensed for every single NAV granule. For me, the process went something like this:

Open the object designer;
Mark all objects;
REPEAT
  Select all marked objects;
  Begin the export;
  Encounter permissions error on some obscure object that belongs to a granule we're not licensed for;
  Unmark the offending object;
UNTIL the export works

It only took about 5 loops before I gave up and started looking for another way (mostly on Mibuso). Now, with this utility, I can bulk export -- and I can do it all in one pass.

If it saves a couple of you from similar frustrations, I'll be able to feel like I've made a small down payment for all the help I've gotten here.

teojurado

Not work with granule "7200 Application Builder".

JamieHurst

teojurado wrote:

Not work with granule "7200 Application Builder".

Thanks for the note. I'm exactly sure what Application Builder gives you... Are you able to export individual objects to text from the standard Object Designer? If so, Object Exporter should work. Just make sure you click "View--> Marked Only" before selecting & exporting.

teojurado

JamieHurst wrote:

teojurado wrote:

Not work with granule "7200 Application Builder".

Thanks for the note. I'm exactly sure what Application Builder gives you... Are you able to export individual objects to text from the standard Object Designer? If so, Object Exporter should work. Just make sure you click "View--> Marked Only" before selecting & exporting.

Sorry... My mistake......

I've the "Advanced Management" License, including:

7110 Report & Dataport Designer 1
7120 Form and Page Designer (includes 100 Pages & Forms) 1
7130 Table Designer 1
7140 XML Designer 1
7200 Application Builder 1
8200 Tables (10) 20
8600 Codeunits (100) 100

The mistake are the numbers of then forms that I use.... changed from 50100 to 5098 and from 50101 to 5099 work correctly....

Thanks.

JamieHurst

FYI, Per Mogensen wrote a better version of this tool while helping me implement Easy Security. He plans to include it in his next Merge Tool release.

Per's "Object Exporter" uses a table with flow fields, so it's much faster and gives you more filtering possibilities. Development time was maybe a half hour. :roll:

teojurado

JamieHurst wrote:

FYI, Per Mogensen wrote a better version of this tool while helping me implement Easy Security. He plans to include it in his next Merge Tool release.

Per's "Object Exporter" uses a table with flow fields, so it's much faster and gives you more filtering possibilities. Development time was maybe a half hour. :roll:

As a part of 'Mergetool' or independent tool?... Sounds good, but as independent tool, sound better... :-)

Thanks for the note...

Per

Thanks for the nice words Jamie.

Currently it is part of the new Mergetool (version MGT1.20.01 or later). But it is really only a few objects.
Table 14120033 MGT Object Information
Table 14120034 MGT Object Comment
Form 14120049 MGT Object Explorer
Form 14120050 MGT Table Information
Form 14120051MGT Object Comments
A few flowfields would need to be changed to Normal to avoid compilation errors, but else should it be OK.

The new Mergetool is in the 14,120,xxx range with unique names and a lot of updates. It can be used by any Partner developer license after being updated from PartnerSource.
http://mergetool.com/products/mergetoolhistory.html

teojurado

Thanks for the info Per... amazing tool....