Re: Monarch

[PaulMmn <PaulMmn@xxxxxxxxxxxxx>]

Jeffrey M Carey wrote:

>Does anyone have experience with Monarch?  We are trying to use it to
>read AS/400 spool files into comma delimited or spreadsheet files.  So
>far, we haven't had much luck.  Any insight would be great!


We've used Monarch, although not much these days (now that file transfer
works reasonably well).

It parses a spool file: you tell it what's a header, what's footer, how to
identify a data record, where the fields are, etc. etc.  and it translates
your spool file into a spreadsheet.

It works, but takes a lot of work set up each spool file.  However, if you
can't get a disk version of your report, this is the next best thing.
Saves a LOT of re-keying!

We currently have one user who's using Monarch.  We get the data to him as
follows:  We do a CPYSPLF to a data base file.  Then, CPYTOPCD, copying the
file to his personal Office/400 folder.  This folder is visible as an I:
drive from his PC.  The user then does a copy on his PC to move the file to
his hard drive.  And then he can run Monarch.

If we had a few extra minutes, it wouldn't take all that long to create a
data base file in addition to the spool file, so we could download exactly
what he needs, and bypass Monarch entirely.  *sigh*

--Paul E Musselman
PaulMmn@ix.netcom.com


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---