Hi, I'm guessing someone may have found a way to do this so I thought this would be the place to ask.
At SFO we're finding the migration reports to be a big help with our V11 upgrade. However, we were wondering if there might be a way to easily cross reference the Tessiture V11 Customizations Review (Which lists LP Stored Procedures that may need v11 attention) with the Custom Report Run Frequency report (Which lists custom report run frequency).
What would be helpfull would be a way to view the actual stored procedures that the custom reports are using (as listed in the T11 Customizations review). The report does show the Report Name and Datawindow objecet, but going into each infomaker report to find the stored procedure name can be pretty labor intensive.
Has anyone found an easy way to do this? It would help us a lot to know the SP names of our most commonly used custom reports (we have quite a few).
Thanks in advance!
Porter Venn (San Francisco Opera)
Hi Porter
For Infomaker reports, there is a tool called PBDoc, which you can run against your PBL files, which will produce a set of linked and indexed html pages that document the objects inside the pbls, and what they refer to - pointers to subreports, stored procs or other SQL sources, columns referred to, data definitions etc. The cross-linking data is stored as xml, so you could, at least in theory, import it into a table and do a cross-link from there.
You can download it and run it unregistered (ie like shareware), although it's a commercial product. It's really intended for Powerbuilder developer documentation, and it was a bit of a struggle to understand how to get it to produce the output, but the result is very useful. I posted a sample output here.
Ken
Unknown said: Has anyone found an easy way to do this? It would help us a lot to know the SP names of our most commonly used custom reports (we have quite a few).
I wanted an easier way to do this, and came up with the following: I copied some code from MP_REPORT_FREQUENCY, and sent that output to a temp table. I then made another temp table matching the column output of MP_review_customizations, and ran its output into that second table. I then query the first table, referencing the second.I then wind up with the most frequently executed reports, plus the report_id, report_name, datawindow, etc.
The code is pretty quick-and-dirty, but has been helpful to me. Happy to share if anyone is interested.
Yes please share.
[inadvertent reply to thread truncated]
Hi Chris, I would love to see that code. Could you email me the script to: pvenn@sfopera.com?
Thanks!
Porter Venn
Hi Chris,
I have just started down the road of customization and v.11 and would be extremely grateful for the code you mention here. Could you email to npurkiss@publictheater.org ?