Skip to main content
Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

Boekkamp

9 Posts

1513

March 23rd, 2011 01:00

Realtime reports using DPA API and built-in webserver (apache)

Hi All,

Currently we are creating static reports using the scheduled reports option and placing the resulting html documents in the reports folder.

Does anyone know how to use the DPA API to create dynamic reports using a webserver so we can request reports using

The report would be requested using an url like:

http://dpaserver:9002/reports/dpa_api.cgi?request=report&?reportname=reportcard

dpa_api.cgi should be a custom script where we can do the talking to dpa_apitool and using the variable values and predefined information

such as the authfile.

The result of the request should be an xml which is sent back to the browser so it can be formatted using an xlt

My questions are:

  • what would be needed to run the reports like this
  • how to set this up using the built in http server for DPA
  • how would the script look like
  • what would be the easiest way to format an xlt which makes the xml data readable

Kind regards,

Jeroen

doster1

31 Posts

March 30th, 2011 06:00

Hi Boekkamp,

  • what would be needed to run the reports like this
    • Easiest solution is probably to have a custom script that runs reports from the command line. Refer to DPA Administration guide section ‘Running reports from the Publisher’. Alternative is to refer to the DPA API guide, where XML can be sent to the Reporter (and received).
  • how to set this up using the built in http server for DPA
    • Don't have quick answer
  • how would the script look like
    • Don't have quick answer
  • what would be the easiest way to format an xlt which makes the xml data readable
    • Don't have quick answer but in my opinion this would be difficult if not impossible to do. The XML really isn't meant to be ‘read’. It is meant to be parsed and then presented in a readable format.

Support does not have the capacity to write scripts so it would be best to discuss with your sales person if Professional Services would be able to perform such.

Hope that helps

Dan

proxy3

4 Posts

June 1st, 2011 06:00

Hi Boekkamp,

I did something very similar some time ago. I wrote a perl script to convert the xml output into html or csv. We can now run a DPA report by running the script  from the command line or by calling a URL. Instead of using the DPA http server (it's not apache) we installed a separate apache webserver on the DPA server. You can contact me for more info if you want.

Joachim

View More

View All

No Events found!

Top