Re: [sqr-users] distributing SQR output using portal API

[Ray Ontko <rayo@ontko.com>]

Andrew,

If you're looking for a technical discussion forum related to
BrioPortal, see:

  http://www.sqrug.org/rm-users/

There's not nearly as much traffic on rm-users as sqr-users, but
it's a good group. (BrioPortal used to be called ReportMart, hence
the "rm" in rm-users).

The API for BrioPortal 7.x is the installation component called
"ONE/Integrator".  You should find this on the installation CD.
If you installed it, it would probably be in a directory called 
ONEIntegrator in the same directory where you installed BrioPortal.
It includes a bunch of Java jar files, and some Jython (formerly
JPython) stuff.

Another approach you might consider is using SQR to generate a
"SPECT" script.  SPECT is a BrioPortal publishing and configuration 
tool that reads a text file (a .spect script) and executes the 
commands contained there.  You can create users, groups, categories,
and SQR jobs, for example.  SPECT is a free java program that uses
the API to do the work.

  http://www.ontko.com/portal/spect/

Hope this helps.

Ray

On Fri, May 23, 2003 at 08:48:26AM -0400, Paul Hoyte wrote:
> Andrew:
> 
> The SQR would have to dynamically create the API code that can be
> dynamically executed from within the SQR (assuming your have the correct
> privileges to do this) - Sample logic is provided in the Portal
> directories under the integrator directory. Good luck with this one...
> 
> Paul Hoyte
> (248) 752-6970 Cell
> (248) 559-6868 Office
> (248) 559-6875 Fax
> paul.hoyte@sharidionne.com (Email)
> www.sharidionne.com (Web Site)
> 
> 
> -----Original Message-----
> From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On
> Behalf Of geek.unlimited@mindspring.com
> Sent: Thursday, May 22, 2003 9:07 PM
> To: sqr-users@sqrug.org
> Subject: [sqr-users] distributing SQR output using portal API
> 
> 
> SQR 6.2.1
> Windows 2000
> Portal 7.0.2
> 
> I am writing an SQR that will distribute reports to a hierarchy of
> categories on the portal.  If possible, I would like to generate new
> categories on the fly, as they are found in the data, but this is not
> essential.  I am told that, to do this, I need to write portal API code
> to distribute the reports after the job factory finishes.  I don't even
> know where to look to find a sample piece of this code or to get
> information on how it is done.  Anyone?  Since this is a bit outside the
> strictly SQR realm, please reply to me, rather than the list.
> 
> Andrew :)
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users