When we have a job that creates a spoolfile, we also create a flat file that
contains the detailed data in the report.  The flat file is created using
Suprtool's EXPORT program, which creates a comma delimited file that can
easily be imported into Excel or Access.  The job contains some FTP commands
which create a subdirectory on an NT file server based on the users HP3000
logon (if it doesn't already exist) and deposits the file (named by the HP
3000 job number) into the subdirectory.

!JOB ....
...
!SUPRTOOL
...
OUT      EDGE000A,LINK,TEMP
XEQ
EXPORT IN EDGE000A
EXPORT HEADING FIELDNAMES
EXPORT OUT EDGE001B,TEMP
EXPORT EXIT
EXIT
...
!MPEX
%SETVAR STREAMER     TOKEN("!HPSTREAMEDBY",",")
%SHOWVAR STREAMER
%SETVAR START2      POS(",","!HPSTREAMEDBY",1)
%SETVAR END2        POS(".","!HPSTREAMEDBY",1)
%SETVAR LENGTH2     (END2 - START2) - 1
%SETVAR STREAMEDBYUSER     "!HPSTREAMEDBY"[START2:LENGTH2]
%SHOWVAR STREAMEDBYUSER
%SETVAR JOB "!HPJOBTYPE!HPJOBNUM"
%SETVAR LOGGEDFILE "!JOB.!HPGROUP.!HPACCOUNT"
...
%RUN FTP.ARPA.SYS;INPUT='OPEN 123.456.78';&
INPUT='USER EDGEMGR password';&
INPUT='MKDIR !STREAMEDBYUSER';INPUT='CD !STREAMEDBYUSER';&
INPUT='DELETE !JOB.PRN';&
INPUT='EXITONERROR';&
INPUT='PUT !LOGGEDFILE !JOB.PRN';&
INPUT='DIR';&
INPUT='QUIT'
...

This is kind of a low-tech way of getting data files to users, but it has
been fairly effective.

> ----------
> From:         Cary A Marshall[SMTP:[log in to unmask]]
> Sent:         Thursday, December 17, 1998 4:00PM
> To:   [log in to unmask]
> Subject:      Transfer Spool File to Network Directory
>
> Hello All,
>
> We'd like to have users create spool files on our HP3000 (5.5 pp 6) which
> can automatically be sent to a directory on our NT network.  Each user has
> been assigned a directory on the network, and we need to be able to send
> the
> users' spool file to his/her network directory. That is, we need a way to
> identify the spool file as belonging to a user, then send the file to the
> proper directory on the network.  We'd also like to incorporate the spool
> file and report name into the file that's created on the network. The
> users
> will then download the data into Excel.
>
> Right now, we are retrieving the spool file through a DTC port, using a
> script to identify the spool file and writing the file to a network
> directory.  Then Monarch is used to strip out extraneous info (headings,
> page numbers..) so that the data can be used as needed.  This method is
> slow
> and unreliable, so we're looking for alternatives.
>
> Thanks for your consideration.
>
> Cary Marshall
>