on 01-08-2021 9:10 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.