RE: Automated dialing to PCs w/data transfer

We have a product called ZMOD400 that will do just what you do right now
except the comms will run directly on your AS/400. There's all sorts of
logging and control features. You shouldn't have to modify your remote
PC setup at all. You can download a copy to try out from
http://www.softwarejungle.com. 

> -----Original Message-----
> From: Jim Suiter [SMTP:jsuiter@mindspring.com]
> Sent: Friday, November 27, 1998 3:24 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      Automated dialing to PCs w/data transfer
> 
> We would like to be able to write an application for the AS400 to do
> the
> following:
> - dial into a PC at a remote site
> - download database files to the PC
> - run an Access application on the PC
> - upload database files to the AS400
> - report any part of the process that was unsuccessful
> - repeat the above steps for multiple sites
> 
> Some background:  The PC application that is using the data was
> created with
> Microsoft Access, therefore the data is stored in Access tables.  I'm
> imagining that the data may need to be exported to text files on the
> PC for
> uploading to the AS400.  The uploaded data will need to be appended to
> an
> AS400 database file for processing.
>  
> We have a process in place now to do the above but it is a very
> unautomated:
> We're using a PC using PC Anywhere to dial into the remote site's PC.
> The
> host PC has an Access database to accumulate uploaded data, which is
> then
> appended to AS400 files via ODBC.
> 
> We would like to eliminate the intermediate PC used to dial into the
> remote
> site and have the AS400 manage the whole process.
> 
> I'm looking for ideas, internet sites, books, or anything that will
> bring me
> closer to implementing the above.
>  
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---