Rob,
Exactly what I needed.
Solution exists in either iSeries Access for Windows or IBM I Access Client Solutions, (will be migrating later this year)
Below is a very simple basic solution for a user to SFTP a file from their PC to a library on the i5.
I will be enhancing this process, replacing the user/password with a hostkey.
SENDCABLES.bat
WinSCP.com /console /script=SENDBRC.scp /log=SENDBRCLOG /ini=nul
rmtcmd "CPYFRMIMPF FROMSTMF('/PAULS/LKBPCS.LKB') TOFILE(PAULS/LKBPCS) MBROPT(*REPLACE) RCDDLM(*LF)
pause
SENDBRC.scp
open s
ftp://user:password@hostname/ -hostkey=*
cd /pauls
put -transfer=ascii c:\lockbox\brc\lkbpcs.lkb
close
exit
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Monday, May 08, 2017 8:07 AM
To: Midrange Systems Technical Discussion
Subject: RE: Replacing FTP PC client scripts to SFTP to put PC file to a i5 library.
Also, if the PC doing the sending has IBM i Access Client Solutions you can run a file transfer instead of sftp
https://www.ibm.com/developerworks/ibmi/library/i-acs-commandline/index.html?lnk=hm
It can also be used to submit commands, etc.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
To: "'midrange-l@xxxxxxxxxxxx'" <midrange-l@xxxxxxxxxxxx>
Date: 05/06/2017 10:52 PM
Subject: RE: Replacing FTP PC client scripts to SFTP to put PC file
to a i5 library.
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
Pete,
That worked.
But the resulting file is savf not a PF.
put -transfer=ascii c:\lockbox\brc\lkbpcs.lkb
/qsys.lib/pauls.lib/lkbpcs.file
I also changed the command from winscp.exe to winscp.com.
This allows the sender to confirm the result.
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Peter Dow
Sent: Saturday, May 06, 2017 10:26 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Replacing FTP PC client scripts to SFTP to put PC file to a
i5 library.
Hi Paul,
The syntax for a library would be
/qsys.lib/pauls.lib
Reminds me of a long discussion about whether libraries and their objects
are in the IFS or not...
--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx> pdow@xxxxxxxxxxxxxx <
mailto:pdow@xxxxxxxxxxxxxx> /
On 5/6/2017 6:16 PM, Steinmetz, Paul wrote:
I need to replace all our FTP PC client scripts to SFTP.
I'm testing with WINSCP.
SFTP script is working, but only to IFS.
1) I'm struggling to find the option so the file will be sent to a
library.
Cd /pauls - result in IFS
Cld - invalid command
2) I would also like to show the SFTP transfer as FTP did.
The person running the script can confirm if the file was sent
successfully.
SENDCABLE.bat
WinSCP.exe /script=SENDBRC.scp /log=SENDBRCLOG /ini=nul pause
SNDBRC.scp
open sftp://user:password@hostname/ -hostkey=* cd /pauls put
-transfer=ascii c:\lockbox\brc\lkbpcs.lkb
Any thoughts from the group.
I will be evaluating other script options.
Thank You
_____
Paul Steinmetz
IBM i Systems Administrator
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home
psteinmetz@xxxxxxxxxx<mailto:psteinmetz@xxxxxxxxxx>
http://www.pencor.com/
--
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.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
http://amzn.to/2dEadiD
midrange.com
