SAP Power Designer

[Former Member]

How to export whole BPMN to Excel in SAP Power Designer ?

[Former Member · Accepted solution]

Thanks for reply Hans Tuin.

Yes of course we have icon for exporting to excel but the thing is it will help to export only individual symbols i.e. process/lane/pool/task/model ...

can't we export whole BPM which includes

- model

- pool

- lane

- process

- sub task

at a time ?

and second question is how to import process,pools,packages,tasks,lanes etc. into BPMN using Excel

[Former Member · Accepted solution]

For importing from excel there is a wizard: File->Import->Excel

With Report->List reports you can create .csv files for an object type, say i.e. Processes

With an example .vbs file called: List processes.vbs in the vb scripts directory.

This way you can write a VB program to create .csv files for many object types.

[Former Member · Accepted solution]

Thanks for information  Hans Tuin.

Yes we have wizard: File->Import->Excel for importing, but how can we mention the details of BPM in Excel to get all objects with sequence flows in Power designer ?

Can you please explain in detail about .vbs  in Power Designer to get all object types ?

[GeorgeMcGeachie · Accepted solution]

Hello Bindu

One simple option is to create a series of List Reports, and then use a simple VB Script to generate them all to CSV files, which can then be merged into a single Excel file.

This script creates a Result Set for each List Report in the active model, and generates each one into a file with the same name as the list report. The result set will contain the same content as the csv file.

dim listRep, repPath, repName

repPath = "C:\Temp\PD Reports\"

for each listRep in ActiveModel.ListReports

    repName = repPath & listRep.Name & ".csv"

    output repName

    listRep.CreateResultSet()

    listRep.GenerateFile repName,"CSV"

Next

Save the script in a file, and run it via 'Execute Commands' on the Tools menu.

[GeorgeMcGeachie · Accepted solution]

List Reports are better than using simple lists from the model menu:

• they're permanent
• you can save result sets
• they can contain properties from containing objects
  • e.g. a list report of attributes can contain entity descriptions

[Former Member · Accepted solution]

Hi....

I have executed VB Script to get all list reports to one report.

After execution it is showing " VB Script terminated "

where we can can get the resultant set report ?

And while exporting BPM to Excel data is coming twice. why and how resolve it ?

[GeorgeMcGeachie · Accepted solution]

The result sets are stored 'inside' the List Reports - you'll see them in the Browser or the 'Result Sets' tab on the List Report.

There's nothing in the script that would cause content to be output more than once. It's possible for there to be duplicate information in multiple rows in a List Report, such as one that exports:

Parent Process Name, Process Name

A,B

A,C

A,D

[Former Member · Accepted solution]

I have exported BPM list report to Excel of each object.The list reports like

After exporting these reports to excel is showing even duplicate rows. How to restrict these duplicate rows ?

Then i have executed VB Script to combine all these excels reports to one report as i require all reports information in one report.

The script is ::

dim listRep, repPath, repName

repPath = "C:\Users\Bindu\Desktop\list excels"

for each listRep in ActiveModel.ListReports

    repName = repPath & listRep.Name & ".csv"

    output repName

    listRep.CreateResultSet()

    listRep.GenerateFile repName,"CSV"

Next

Is there any mistake in this script to combine all those reports information in one report ?

After executing this script some resultant set is generated. but I didn't see any difference. For instance lane 's report  and its resultant report after executing the script is like this ::

As I want all those reports data in one report and the final report should be exported to Excel,

How can I do that,whether script should be changed or any other way to do or any modification  in this way ?

[Former Member]

Hi Bindu,

On every list there is a icon for export to excel.