activity log

I need to write to the document activity log that is in the database. Basically, I need to record when a document is accessed for printing.

Is there any documentation on the procedure to write a log to the P_CON_DOCUMENT_ACTIVITY_LOG? I mean I could directly access the database using JDBC, but shouldn't there be a mechanism already in place that is accessible to the developer?

Peter Choe

Find more posts tagged with

Comments

dbguy

First of all, a note of caution: no one outside IWOV R&D and support should try accessing the DB directly. The DB schema is NOT guaranteed to remain the same across versions. Whatever you do that accesses the DB directly may not work in future releases. Writing anything directly to the DB is not supported. Given its complexity, it is really easy to mess it up.

Now back to your question. If you are printing something, you are probably downloading it using Version.getCopy(). In 4.1 (maybe earlier versions too), there are variations that take a DocumentAuditEntry argument. This is an override for the default logging mechanism. You can use it to log your printing activity.

You will need to add a new entry to the audit entries in Library Manager.

I am on the road. When I go back to my office (later this week), I will try to find some sample code.

JTNeville

Since the schema is not released (something that makes me sad more often than not) why not write your captured print actions to a new table/db and reference them with an applet if you need to report them back within MP to the client? This leaves your MP in a "supported" condition but gets you your audit.

Right now I dump a lot of MP data to a sister DB via the WOM and some experimental custom schema SQL calls, read it all aggregated together with CR and then use another worklet to make those CR dashboards or just the simple xml data available seemlessly in MP and refreshed on each page draw. I'm doing this in 4.1, most of my applets/connectors broke with SP1 so I have held off deploying it.

new_report.pdf

Migrateduser

Curious how you managed to get CR as a worklet? I tried and failed. Anything you can share?

JTNeville

I embedded the RAS engine from 9.21, and extended the SDK examples to call CR reports I prebuilt (then saved without the data in them). Then clients can log into MP and pick from a drop down list any of a series of reports and run them real time. A limitation using the RAS engine in 9 or the embedded engine in 10 (same product new name) is that it will only process 5 reports at once and queue the rest. I've toyed with 10 but I don't like it as much so I'm still using the 9 RAS engine even though I'm writing the reports in the 10 CR client now. Haven't even looked at 11.

9 was never officially supported on Tomcat but CR released an SDK for it including Enterprise and Pro jars, example jsp files and the java docs. The support it in 10 for pro and enterprise.

I've been experimenting using the WOM to write the finished CR reports to a MP document folder but while good for archiving them within the system, it doesn't get the client the real time feel of the page drawing in the iframe or worklet and showing the recently run report. So I still have the 5 license RAS server as my main solution.

The SDK files can be found here (click the resources menu link for the jar and sdk downloads):

http://www.businessobjects.com/products/dev_zone/java/default.asp?ref=devzone_main

And here's the FAQ for 10 and Tomcat (supported now):

http://support.businessobjects.com/library/kbase/articles/c2014991.asp

Don't forget the java viewer SDK, and the RAS interactive viewers, they were quite helpful as examples.

Edited by JTNeville on 04/13/05 09:06 AM (server time).