On Thu, 20 Aug 1998 10:07:03 +0100, "Jamie Dickson"
<[log in to unmask]> wrote:

>You could have a "listener" program on the PC (easily written in VB)
>that monitors the contents of a nominated PC directory.
>
>When it detects that a file is present, import the data to the Access
>DB and write a notification file to another nominated PC directory.
>
>Periodically on the HP3000 you can FTP and check to see if the PC
>import was successful (by seeing if the output file exists) and
>perform other automated tasks.
>
>
>Regards,
>
>Jamie.
>
>
>FONTAIC wrote in message
><[log in to unmask]>...
>>Is it possible to have a job on an HP3000 ftp a data file (comma
>>delimited)
>to
>>an NT file server (I know that's possible), and then have the FTP
>>"session" execute a program or script on the file server that will
>>import the data
>file
>>into Microsoft Access (all without human intervention)?
>>
>>
>>
Faced with a similar problem recently, I found a shareware FTP
server to run on a Win 9x/NT box, which has a trigger mechanism; it
listens for the arrival of a specified file, then runs a command,
which can be a .BAT file. In my case, a scheduled job on the HP3000
produces a file, FTPs it to a NT workstation where a batch file
creates a Powerplay cube, copies that to another server, then emails
a user to say that a new version is available.

On the other hand, W.Wolters remote shell sounds like a good idea;
I'll give it a go when I get a few minutes.


David Martin                             email: [log in to unmask]
Deputy Director
IS - DCIS
Trent Building                          Tel: 0115 951 5895
The University of Nottingham
University Park                         Fax: 0115 951 5686
Nottingham NG7 2RD