BW

In SR 9 we were given the ability to schedule reports.  By default were is the output of these reports saved?

by Torsten Haase
Posted on Tue, 01/04/2011 - 11:02

The result is stored internally and can only be accessed by the Business Architect client or by using the report:

var zippedByteContent = Context.getComponent("ReportScheduler").getDecryptedScheduleResult(String sScheduleGUID, String sUser, String sPassword, false)

var aResultFiles = Context.getComponent("ReportScheduler").getZipEntries(zippedByteContent)

(see ARIS Script help)

 

 

0
by Troels Ravn
Posted on Thu, 01/27/2011 - 18:59

Hello Torsten,

How can I access the result through ABA? When I navigate in Explorer to the "Scheduled reports" tab, select a report which has run and click "Display result", a dialog opens for me to select a file. However the file is not available on the file system, as I understand your reply? So how do I access the result?

Thanks in advance.

0
by Torsten Haase
Posted on Fri, 01/28/2011 - 09:36

Hello Troels,

when you select a file location to save the result to, the result is copied to the selected location. Afterwards it can be accessed at the place where you have saved it.

BR,

Torsten

0
by Troels Ravn
Posted on Fri, 01/28/2011 - 17:28

Hi Torsten,

When I log on to the server where ARIS is installed and run the report interactively, it saves to the default ARIS 7.1 folder under My Documents. However when run as a scheduled report, it does not save to this location. Or any other location on the disk drive, as far as I can tell (except for an encrypted file sitting in the install directory under "templates\scriptservice\scheduler"). As far as I can see, there also is no option to specify file location when configuring the report schedule. Do I need to specify the exact folder where the report is to be saved inside the report script for it to work with the scheduler? Or am I missing a UI configuration option somewhere?

Thanks and have a nice weekend!

0
by Torsten Haase
Posted on Fri, 01/28/2011 - 18:35

Hi Troels!

If you run a report interactively, you specify the location, where the report is stored on your client, in the assistant when starting the report.

Scheduled reports keep their results internally (you are right, the location in the current release is templates/scriptservice/scheduler), so no-one who is not allowed to see database content can access it. Only the user who has created the schedluling is allowed to read the result, so only this user can access and save the result on the client.

If you want to write a report, which stores its results somewhere on the server, allowing everyone to read it, you are free to do so in the report implementation, but this is not the default way a report provides its results.

BR,

Torsten

0
by Troels Ravn
Posted on Sat, 01/29/2011 - 17:18

Hi Torsten,

Thanks for your reply. However, I am still at a loss in how to display the result of the scheduled report. I have logged on to the database with the the admin account which was used to create the report schedule. In Explorer, I go to the Scheduled Reports for the relevant database and select the scheduled report. Then I click "Display result". Now a dialog box opens for me to browse to and select the file I want to display. I am only allowed to select .XLS files (which is the format output by the report, when run interactively), so I cannot select the encrypted file stored under "templates/scriptservice/scheduler". 

You mention that "Only the user who has created the schedluling is allowed to read the result, so only this user can access and save the result on the client."

How do I do that???

Thanks and regards,

Troels

0
by Torsten Haase
Posted on Mon, 01/31/2011 - 09:46

Hi Troels,

you cannot access "the encrypted file", because this is internal data only. The result of the report is an XLS file so you are prompted where to store this result locally.

If you need scriptable access to the scheduler results, there is a report API extension, which can be used to access scheduler results:

var reportScheduler = Context.getComponent("ReportScheduler")

provides the following methods:

var aByteArrayResult = reportScheduler.getDecryptedScheduleResult ( String sScheduleGUID, String sUser, String sPassword, boolean bIsPwdEncrypted )
var aSelectedFile = reportScheduler.getZipEntries ( aByteArrayResult )

BR,

Torsten

0
by Diego Labrador
Posted on Mon, 01/25/2016 - 16:33

In reply to by thaase

Hi Torsten

I have a question, a little late, I have the result of the report, like you do in the example. Now I want to save the report result in a folder in the server, can this be done?

I have another question regarding the scriptrunner. II have the 9.8 ver of Aris, and there is no scriptrunner inside the instalation server. If I want to use it, I need to create one? This is not very clear to me

Hope you can help me

Regards

0
by Torsten Haase
Posted on Mon, 01/25/2016 - 17:46

In reply to by DiegoA

Hi Diego,

you can save the result in a folder on the server using the standard java classes (e.g. FileOutputStream) for file operations (of course this is not possible / bocked in a public cloud scenario).

The script runner in fact is a client so it comes with the client installation. A server-side scriptrunner would not make much sense in ARIS 9 any more because "normal users" normally do not have access to the server's file system.

BR, Torsten

 

0
by Diego Labrador
Posted on Tue, 01/26/2016 - 20:27

In reply to by thaase

Hi Torsen

Thanks for the answer. I'm testing, but seems fine. Let's wait, jajaja

If this work, I'll post my entire solution to put together all the info I collect

Thanks again

0
by Troels Ravn
Posted on Mon, 01/31/2011 - 12:12

Oh, I finally got it now. The dialogue prompts me to save the report, not to open it, somehow I completely missed that...! Apologies for the silly questions and thanks for your replies :).

Kind regards,

Troels

0
by Ciska de Jager
Posted on Thu, 06/21/2012 - 13:14

Hi Torsten,

How do I get the SheduleGUID, username, password and password encrypted values from a report schedule, in otherwords, I want to programatically loop through the scheduled reports and save the output to a folder. In order to need that I need to obtain these values from the sheduled reports.

Ciska

0
by Diego Labrador
Posted on Thu, 01/21/2016 - 21:10

In reply to by Ciskadj

Hi Ciska

Are you able to this? I mean, get the result of the report and save the output in a folder? I can get the report result, but I can't save the output in a folder, I can even create the file.

Let me know if you can get any clues to do this

Regards

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock