RE: Monarch software -- MAPICS-L

James -

Absolutely! That's why you need a utility like Monarch/ValetMiner!

Sorry to sound like a walking advertisement, but Monarch is the coolest
utility I've ever found. The first demo I saw in about 1991 or 92 blew me
away. You can't "parse" a mult-lined report in Excel, but you (usually) can
with Monarch. And you can set the "field to cell" relationships. And your
output isn't limited to Excel - it also "does" Lotus, dBASE, Paradox,
Access, fixed-length text files, and delimited files. If you can't use one
of these formats...

Lest you think I think Monarch can do no wrong, I can easily write a report
that it cannot parse correctly. The very first report I tried to use it with
went something like this:

     detail line A    fieldA   fieldB    fieldC   fieldD

     detail line B    fieldA   notes        notes
                               fieldB    fieldC   fieldD

     detail line C    fieldA   fieldB    fieldC   etc...

That is, if there were notes for the record, the notes were placed at the
end of the first line and the fields displaced were written on a second line
that was not there if a record had no notes associated. This is not the
Monarch software's fault - some bone-headed programmer or (worse) user who
wanted the report written that way messed up the system. I did find at least
one standard MAPICS report that has a similar problem - can't remember now
which one it was, but I think it comes out of IFM or COM (figures).

Anyhow, check out the Momentum web site www.jacana.com - there's a white
paper about a certain company's use of ValetMiner, which modesty forbids me
to mention. (grin)

Joan McCready, IS Manager      phone:  636-479-4499
MetalTek International         fax:  636-479-3399
The Carondelet Division        www.metaltekint.com
8600 Commercial Blvd
Pevely, MO  63070


-----Original Message-----
From: Leleux@shur-lok.com [mailto:Leleux@shur-lok.com]
Sent: Wednesday, September 05, 2001 1:59 PM
To: mapics-l@midrange.com
Subject: RE: Monarch software



Yes, but doesn't excel butcher the spool file?

Turning each line into a row, no 'field' to cell relationship?

can you comment on that for me?

thanks.....james




                    Connie Webb
                    <cwebb@grahamwhit        To:
"'mapics-l@midrange.com'"
                    e.com>                   <mapics-l@midrange.com>
                    Sent by:                 cc:
                    mapics-l-admin@mi        Subject:     RE: Monarch
software
                    drange.com


                    09/05/2001 10:50
                    AM
                    Please respond to
                    mapics-l






I have used Monarch with old System 36 and MAPICS. If you have Client
Access
and any Office Product, setting up import into EXCEL or Access is very
easy.
Would be happy to go over this with you offline.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.





_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.