Automatic exports with reports in PowerDesigner

[champalier]

hello,

I use PowerDesigner 16.6 and i'd liked to know if it's possible to schedule automatic exports with the tabular reports or standard reports from PowerDesigner models ?

I'd liked to export in csv or xlsx formats with the tabular reports.

Regards

[GeorgeMcGeachie]

You can use VBScript or another language to write a script that can be scheduled. When you access a List report you can use the following method to generate the output to a file:

GenerateFile(ByVal File As String, 
ByVal Format As String)  Generates a file having a given format containing 
the result of the execution of the list report.The format can be any of 
these strings: "XML", "CSV", "RTF", "TAB" or "HTML"."CSV" format presents 
the information using a Comma Separator Value format. The separator used is the 
list separator specified in the regional settings of your computer."TAB" 
uses a tabulation as separator.

If you want it to be run on request, write a generic script to generate all (or some form of selection) the List Reports to files - add it to the Execute Commands menu option. Look for Adding Commands to the Tools Menu in the documentation.

[former_member200945]

If you can manually export, in principal you can write application to automate the process.

In your Powerdesigner folder, there is Ole automation folder.

You can study the examples as start point.