Re: Reports / Data to Excel - DRV Tech vs. CoolSpools..

[Bradley Stone <bvstone@xxxxxxxxx>]

Charles,

If your headers/footers are on the same lines on each page then SPLTOOL may
work for you... it allows you to mark lines to omit from the conversion.
The only issue is, when you import it you need to use spaces as the
delimiter.  Not always the best.

For output queue monitoring we have Output Queue Trigger (OUTQTRG
http://www.bvstools.com/outqtrg.html).  It will allow you to run any
command or program when a spooled file enters an output queue that it set
up and matches selecting criteria (file name, job, user, outq, etc).

Is there not a way you can create a PF with the data you want instead of a
spooled file?  Much easier to convert to CSV.  I've always thought of
spooled files as  "pictures" of data.  I know there are products that can
do it, but wouldn't it be easier and more reliable to instead of outputting
a spooled file, output a PF and convert that to CSV?  Just what I offer to
customers asking for this ability...

As far as email, I had yet another customer call me today saying they
switched to Office 365 (or another cloud company).  I can offer them ways
to use Office 365 without any proxys or hacks with MAILTOOL, but I'm
finding most customers also have other software packages that just use the
email APIs which can't really talk with cloud severs.  Just something to
look out for when folks go the the cloud for email.

Brad
www.bvstools.com

On Thu, Sep 8, 2016 at 3:27 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

> I've got a couple existing tools used for converting spool files to PDF,
> namely Gumbo's Spool-A-Matic and Brad Stone's Spool Tool and Mail Tool.
>
> We've also made use of SQL2JXL to generate some excel spreadsheets
> directly.
>
> Thinking a complete third-party package may be beneficial.  Key
> requirements:
>
> - Convert spool file to Excel (removing page headers/footers ect)
> - SQL Extracts to Excel
> - OUTQ monitoring and electronic distribution
>
> I've found DRV Tech's SpoolFlex products along with Ariadne's CoolSpool
> products.
>
> Looking for feedback for either of those products along with
> recommendations for other products to look at.
>
> Thanks!
> Charles Wilt
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.