Working with spool files

[Robert Hill]

We have used a product to download AS400 spool files (print files) to our
PC's into Word and Excel, has anyone else had experience with other methods
of transferring spool files to the PC they would share?.

[Troy Paulson]

My company has an application that will allow you to view your spool files
from the web, then you have the option to save the file to text, html, or
csv files. For more information:
http://www.nsc-inc.com
sa...@nsc-inc.com
1-800-624-5720

"Robert Hill" <bh...@co.stanly.nc.us> wrote in message
news:gYSM6.1391$dl4....@ralph.vnet.net...

[Martin Rowe]

In article <gYSM6.1391$dl4....@ralph.vnet.net>, "Robert Hill"
<bh...@co.stanly.nc.us> wrote:

Hi Robert

There are plenty of tools that will do this, from commercial through
shareware to free. I see two stages in the process - 1) conversion to PC
text file on the AS/400 (IFS) and 2) transfer to the PC.

Stage 1 can be as simple as a CPYSPLF followed by a CPYTOSTMF, which will
give you text data ready for import into Excel (via the text import
wizard).

I find RUNRMTCMD very useful for the second stage, as that works nicely on
both our Windows boxes running Client Access' Incoming Remote command and
my Linux box running a rexecd daemon. An alternative is to use the QNTC
filesystem to map your PC drives onto the AS/400.

I have a free WRKSPLF/WRKOUTQ hybrid tool[1] that combines both stages -
fairly basic but it gets the job done, but you might want to look at some
of the many spool to .csv tools around. I've only got personal experience
of CoolSpools400[2] as we've recently bought that at work (though mainly
for its .pdf conversion) which will do stage one for you, but there are
plenty of others[3] :)

Regards, Martin

[1]WRKUSROUTQ on my dbg400 site (see .sig below) - Look at the extras
section.
[2]http://www.ariadnesoftware.co.uk
[3]http://www.google.com/search?q=spool+as400+.csv turned up quite a few
for me - including my own ;-)
--
mar...@dbg400.net / jam...@firstlinux.net
http://www.dbg400.net DBG/400 - DataBase Generation utilities
Open Source test environment tools for the AS/400 / iSeries and
miscellaneous database & spooled file management commands.

[ScLind]

The shareware product SPLTOOL by Brad Stone has a variety of ways to get a
spool file to a PC. One I especially like is emailing the spool file to
myself, then I simply detach the spool file attachment onto my hard drive.

See www.bvstools.com.

Scott Lindstrom

[Robert Hill]

Just wanted to say thanks these suggestions were a huge help.

[James Durr]

Hello,

My company sells an AS/400 command that creates Excel(.XLS), not CSV,
from AS/400 spooled files. The Convert Spooled File (CVTSPLF) command
creates binary compabitible Excel spreadsheets with accurate column
widths, with one set of fixed headings and the ability to select detail
lines of a report.

For a free trial version visit us at http://www.kemetech.com

James Durr
Technical Consultant
KemeTECH Systems Inc.
103 Vassar Avenue, Newark, NJ 07112-2249
Phone( 973) 923-2328 e-fax (978-231-5825)
jd...@kemetech.com

--