× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. October 2003

Re: Automating Client Access Express using Windows Scripts?

Use SBMRMTCMD (Client Access) or RUNRMTCMD (RPC) to invoke a program on
the PC, then use FTP to get your file up ti the iSeries.

On Mon, 13 Oct 2003 07:44:31 -0400, "End of the Trail"
<endofthetrail@xxxxxxxxxxx> said:
> This stuff is cool.   BUT can I go the other way??
> 
> I want to CALL, from the AS400, a PC job (batch) and return a file to a
> AS400 folder which will merge with my print routine.
> 
> Eurrat Saylor, Jr.    www.skyenet.net/~endofthetrail/elsresum.htm
> 9562 East 750 North
> Walkerton, IN  46574
> 
> tel. (574) 586-7970
> fax (574) 586-2677
> cel (574) 532-2898 (Eurrat)   Nextel 2-way 111*42*729
> 
> 
> 
> ---- Original Message -----
> From: Bill Meecham <bmeecham@xxxxxxxxxxxxxxxxxxxx>
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Sent: Friday, October 10, 2003 4:06 PM
> Subject: Re: Automating Client Access Express using Windows Scripts?
> 
> 
> > You could build the pc ftp.txt file using input from the user by putting
> the ftp -n -i -s:etx... into a .bat file.  With the example below you can
> put a bat file on a user's desktop and have it call the shared bat file.
> The user can then then just click the icon and run the job.
> >
> > @echo off
> > rem - this command builds an ftp script file and then runs it.
> > rem - the ftp script file updates the exchange, email file on the as400
> > rem - and then runs an update command
> > rem - Bill Meecham 8/10/2001 - THIS IS PRODUCTION CODE
> > rem _____________________________________________________________
> > rem - Required Parameters:  USERPROFILE PASSWORD FILENAME
> > rem _____________________________________________________________
> > rem - clear the screen to remove the user name and password as soon as
> possible & handle errors
> > rem _____________________________________________________________
> > cls
> > if "%1" == ""  goto cmdHelp
> > if "%1" == "-"  goto cmdHelp
> > if "%1" == "?"  goto cmdHelp
> > if "%2" == ""  goto cmdHelp
> > if "%3" == ""  goto cmdHelp
> > rem - start building the ftp script file
> > rem _____________________________________________________________
> > @echo prompt >> ftpexchange.ftp
> > @echo verbose >> ftpexchange.ftp
> > @echo open 10.1.254.25 >> ftpexchange.ftp
> > @echo user %1  >> ftpexchange.ftp
> > @echo %2 >> ftpexchange.ftp
> > @echo put  %3  /qsys.lib/qgpl.lib/exchange.file/exchange.mbr >>
> ftpexchange.ftp
> > @echo quote rcmd "SBMJOB CMD(EXCHANGE COPY(YES) TO(FILE) FIND(YES)
> DO(YES)) JOB(EXCH_EMAIL)" >> ftpexchange.ftp
> > @echo quote rcmd "SNDMSG MSG('Exchange email update was submitted!')
> TOUSR(PROGRAMMER)" >> ftpexchange.ftp
> > @echo quit >> ftpexchange.ftp
> > rem _____________________________________________________________
> > rem - run the ftp script file
> > ftp -n -s:ftpexchange.ftp
> > rem _____________________________________________________________
> > rem - remove the script file!
> > del ftpexchange.ftp
> > goto exit
> > rem _____________________________________________________________
> > :cmdHelp
> > echo --------------------------------------------------------------
> > echo ftpExchange command:
> > echo  This command is used to transfer the exchange email
> > echo  data from the PC to the AS400.  It will also submit a
> > echo  procedure on the AS400 to update the associate email
> > echo  addresses based on the file information that is sent to it
> > echo  in the first step of this command.
> > echo --------------------------------------------------------------
> > echo Command syntax:
> > echo  ftpExchange USERNAME PASSWORD FILENAME
> > echo --------------------------------------------------------------
> > echo   USERNAME  - The AS400 user name.
> > echo   PASSWORD  - The AS400 password for the user name.
> > echo   FILENAME  - The name of the CSV file that you have
> > echo               created on the PC.  Enter the full file name
> > echo               including the extension.
> > echo               Ex.  c:\myDirectory\assoc.csv
> > echo   Additional help - Contact MIS department.
> > echo                                                   Bill Meecham
> > echo --------------------------------------------------------------
> > rem _____________________________________________________________
> > :exit
> >
> >
> >
> > ----- Original Message -----
> > From: "Pete Helgren" <pete@xxxxxxxxxx>
> > To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> > Sent: Friday, October 10, 2003 3:39 PM
> > Subject: RE: Automating Client Access Express using Windows Scripts?
> >
> >
> > > And, just to elucidate:
> > >
> > > Build a pc cmd file with something like this in it:
> > >
> > > ftp -n -i -s:ftpcmds.txt
> > >
> > > Then in the ftpcmds.txt file put something like:
> > >
> > > open myAS400
> > > user myuserid
> > > mypassword
> > > quote rcmd mylib/myrptcmd (pass whatever parameters here...)
> > > quit
> > >
> > >
> > > It tends to work pretty slick although the password ends up being "in
> the
> > > clear".
> > >
> > > Pete Helgren
> > > Timp Tech/Ed Tech Labs
> > > 801-269-0220 x202
> > >
> > >
> > >
> > >
> > > > -----Original Message-----
> > > > From: midrange-l-bounces@xxxxxxxxxxxx
> > > > [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
> pnelson@xxxxxxxxxx
> > > > Sent: Friday, October 10, 2003 1:29 PM
> > > > To: Midrange Systems Technical Discussion
> > > > Subject: RE: Automating Client Access Express using Windows Scripts?
> > > >
> > > >
> > > > Agreed. This is a lot simpler.
> > > >
> > > >
> > > > Paul Nelson
> > > > Arbor Solutions, Inc.
> > > > 708-670-6978  Cell
> > > > pnelson@xxxxxxxxxx
> > > >
> > > > "Always do right. This will gratify some people and astonish the
> rest."
> > > > Samuel L. Clemens  (Mark Twain)
> > > >
> > > >
> > > >
> > > >
> > > > "Pete Helgren" <pete@xxxxxxxxxx>
> > > > Sent by: midrange-l-bounces@xxxxxxxxxxxx
> > > > 10/10/2003 02:16 PM
> > > > Please respond to Midrange Systems Technical Discussion
> > > >
> > > >
> > > >         To:     "Midrange Systems Technical Discussion"
> > > > <midrange-l@xxxxxxxxxxxx>
> > > >         cc:
> > > >         Subject:        RE: Automating Client Access Express
> > > > using Windows Scripts?
> > > >
> > > >
> > > > Probably easier to run FTP RUNRMTCMD and be done with it.
> > > >
> > > > Pete Helgren
> > > > Timp Tech/Ed Tech Labs
> > > > 801-269-0220 x202
> > > >
> > > >
> > > >
> > > > > -----Original Message-----
> > > > > From: midrange-l-bounces@xxxxxxxxxxxx
> > > > > [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of David Wright
> > > > > Sent: Friday, October 10, 2003 12:54 PM
> > > > > To: midrange-l@xxxxxxxxxxxx
> > > > > Subject: Automating Client Access Express using Windows Scripts?
> > > > >
> > > > >
> > > > > Hi All,
> > > > >
> > > > > Has anyone had any luck using Windows Scripting to control Client
> > > > > Access sessions?
> > > > >
> > > > > I would like to get a script to open CA, login, run a report, and
> > > > > signoff...
> > > > >
> > > > > I have done some scripting with MS Apps, but cannot seem to make
> > > > > any progress with CA.
> > > > >
> > > > > Any help, direction, or samples would be appreciated,
> > > > > Thanks,
> > > > > David
> > > > > _______________________________________________
> > > > > This is the Midrange Systems Technical Discussion (MIDRANGE-L)
> > > > > mailing list
> > > > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > > > To subscribe, unsubscribe, or change list options,
> > > > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > > > Before posting, please take a moment to review the archives
> > > > > at http://archive.midrange.com/midrange-l.
> > > > >
> > > > _______________________________________________
> > > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > > > list
> > > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > > To subscribe, unsubscribe, or change list options,
> > > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > > Before posting, please take a moment to review the archives
> > > > at http://archive.midrange.com/midrange-l.
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > This is the Midrange Systems Technical Discussion (MIDRANGE-L)
> > > > mailing list
> > > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > > To subscribe, unsubscribe, or change list options,
> > > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > > Before posting, please take a moment to review the archives
> > > > at http://archive.midrange.com/midrange-l.
> > > >
> > >
> > > _______________________________________________
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/midrange-l.
> >
> >
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
-- 
  
  michaelr_41@xxxxxxxxxxxxxx

-- 
http://www.fastmail.fm - Faster than the air-speed velocity of an
                          unladen european swallow

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.