Skip to Content

A client wants to search for certain objects in a large repository and save the result into Excel.

FindObjecs.PNG

Unfortunately Powerdesigner client doesn’t provide functionality to save the output.

Powerdesigner Portal 16.6 does have the feature. But the performance and output format is not very satisfactory .

I build a tiny tool in C# to fill the gap.

Attached is the exe file. ( Remove .txt after unzip)

This is the step to set up the tool.

1)  Open Powerdesigner. Go to Tools->Execute Commands->Customize Commands.

2)  Click Add a Row icon.

    Give a name to the command. For example, Save2Excel

    In Submenu field, select Import

    In Type field, select Executable

    In Command Line field, click the field, then browser to the place where the executable located.

    Click OK

3)  Close and restart Powerdesigner.

4)  Connect to repository and run Find Objects.

5)  Go to Tools->Execute Commands->Import. Click Save2Excel.

This tool also works for local Workspace.

Enjoy!

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. George McGeachie

    A worthwhile demonstration of the extension capabilities of PD – provides a simple way of getting a list of everything in a model, folders, workspace, etc., even the whole repository if you’re not careful!

    (0) 

Leave a Reply