Re: Getting Data from iSeries to PC

[Loyd Goodbar <loyd@xxxxxxxxxxxxxx>]

Thanks for the information Infoprint Server. I hope to upgrade to V5R2 while
it's still in wide use. (I'm on a 720 that will need quite a bit of
replacement parts to support V5R2.)

I can create PDFs today (via Brad's tools) and the OpsNav drag'n'drop is
really cool. PDFs are useful when sending reports outside the company, but not
really as useful inside. More often than not, a "report" usually translates
into a "data file" request.

The problem is "data availability" options where our ERP software only
generates spooled output, with no options for output files, CSV, etc. Some of
my users are very adept at downloading the data directly and deriving the
results they need. One of our accountants has quite a few TTOs in his network
directory...

I've been asked to "give me an Excel version of this report" which is a
de-normalized version of the data. Even worse, our ERP package uses Synon (and
we don't have the models), so it's extremely difficult to determine what the
report programs are doing based on the generated RPG code.

I looked at Monarch quite a few years ago, but i don't think the version I saw
could handle some of the package's more complex reports. I'll have to look
into RJS software. Reinventing a wheel can be fun but the business need is
more important and should pay for the software quickly.

Loyd

On Fri, 24 Oct 2003 18:35:34 -0500, Vern Hamberg
<vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>RJS Software already has products that build the template kind of thing you 
>mention. Of course, it cosets, but it is very good. Monarch, which you 
>mention, is similar, I believe.
>
>In newer releases, Infoprint Server can be used to send a PDF version of a 
>spooled file to an email address. You'd need to specify an exit program 
>which could prompt a user for email addresses, but that is not terribly 
>hard, just detailed.
>
>Actually, this is available from OpsNav, too, IIRC. I just did this from a 
>V5R2 machine - right-click in the printed output window and take the 
>convert to PDF option.
>
>Vern

--  
Mediocrity: It takes a lot less time and most people won't notice
the difference until it's too late. <http://www.despair.com/>
loyd@xxxxxxxxxxxxxx  ICQ#504581  http://www.blackrobes.net/