Manually triggering a CE event

[Jitwad]

I need to know if something is possible....

I am running CE 8.5.0.806 (soon to be running 9).

I have a web report which outputs a PDF to an AIX server. It can be both scheduled and triggered manually.

I have set up an event which will trigger the report to run and send the PDF where I need (all of this is working OK).

What I would like - is to trigger the event from a script on the AIX box -- preferably from a KSH script, but that is looking grim so I may have to code a servlet to handle that. Is this possible? I tried calling the URL generated by the 'Trigger Event' button in CE but was unsuccessful.

... or is there another working alternative to remotely trigger a report to run? Any suggestions appreciated.

 

[TedLiu]

Hi,

I'm not sure about CE8.5, but it definitely can be done with CE10 by creating a file event, probably CE9 can do it too.

In CE10, you have 3 type of events:

1. file-based event, by creating a specified file in anywhere CE can reach to trigger the report to run, which applies to what you want;

2. customized event, you can manually run the event to trigger the report;

3. event wich trigger the report to run can be triggered based on the status of other events.

Maybe you can check CE admin help about the schedule objects with event, that's where I found pretty helpful.

Hope it helps,

Ted

 

[Jitwad]

Yeah - I looked into using a file event and that should work.

I was just wondering if anyone has had success remotely triggering a custom or user event in CE.

I am trying to avoid sending files all over the place as the request for this report will come from COBOL, then KSH, then ?? (where Im thinking ?? = java servlet) to CE, then the output is sent back to the NIX server. I was hoping I could trigger the same URL as the 'Trigger Event' button.

:/

 

[TedLiu]

Hi,

I did sth similar by creating a customized CSP page in CE8.5 which get the information from url querystring sent from outside website of CE and generate the report displayed on the calling application, however, that was for on-demand reporting but scheduling, so I don't know the code to call scheduling report.

The CSP page does sth as below based on my memory:

1. Get querystring values as database CE login and dynamica parameters;

2. Create a Security token for CE;

3. Find the specified report and pass all the informatino it needs (DB login, parameters, output file);

4. Generate report for viewing (you may need to find a comand for scheduling and distribution, event may not be needed).

Hope it helps,

Ted

 

[mdwyer]

See thread782-1037002 for ideas shared recently.

 

[Jitwad]

Thanks for the replies all.

I think I will be able to create a small background web app to run on a Tomcat server that will satisfy my needs.

Crystal support had some nice sample jsp apps that were close enough to my requirements that I should be able to bastardize them up a little and get what I need.

Thanks again.