Re: Using Windows FTP from a bat file to download physical file

If it is just flat data, it might be easier to just implement it as a
webservice on IBM i. No need for FTP then.

Brian May
Solutions Architect
Profound Logic Software
http://www.profoundlogic.com
937-439-7925 Phone
877-224-7768 Toll Free


The IBM i Modernization Experts
www.profoundlogic.com


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
rick baird
Sent: Thursday, July 28, 2016 9:20 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Using Windows FTP from a bat file to download physical file

thanks Larry,

If it were just me, that would be the solution - but I'm deploying this to
our ibm i customers, many of whom are not very technically minded (trucking
industry, mom and pop shops).




On Thu, Jul 28, 2016 at 10:10 AM, DrFranken <midrange@xxxxxxxxxxxx> wrote:

In my experience this is nearly always something to do with the
Windows firewall. It is so pervasive for me that I no longer even
attempt to use windows FTP to IBM i. It fails exactly where you show,
right when you try to get the data.

My solution has been FileZilla which works every time. I have not
attempted to script transfer with that however.

So it's possible that Windows firewall was enabled but even with it
DISabled windows FTP still fails too often for me.


- Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.


On 7/28/2016 9:53 AM, rick baird wrote:

Hello all,

I've been using a bat file to execute FTP to download a flat physical
file
- it worked just fine for weeks but suddenly it locks up and
disconnects after timing out.

here is the bat file:

ftp -s:acaboth.txt myftp.url.com >>acalog.txt

here is acaboth.txt

userid
password
quote site trim 0
recv P020715P/acarept01.acarept01 c:\ME\acarept.txt (replace recv
P020715P/acamanf01.acamanf01 c:\ME\Manifest_.txt (replace quit

the log file shows it failing to open data connection.

ftp> Connected to ip.address.
220-QTCP at ip.address.
220 Connection will close if idle more than 5 minutes.
---> OPTS UTF8 ON
501 OPTS unsuccessful; specified subcommand not recognized.
User (ip.address:(none)):
---> USER userid
331 Enter password.
---> PASS password
230 userid logged on.
ftp> quote site trim 0
---> site trim 0
250 TRIM trailing blanks when sending database files option set to 0.
ftp> recv P020715P/acarept01.acarept01 c:\ME\acarept.txt (replace
---> PORT 10,60,254,110,194,85
200 PORT subcommand request successful.
---> RETR P020715P/acarept01.acarept01
425 Not able to open data connection.
ftp> recv P020715P/acamanf01.acamanf01 c:\ME\Manifest_.txt (replace
---> PORT 10,60,254,110,194,166
200 PORT subcommand request successful.
---> RETR P020715P/acamanf01.acamanf01
425 Not able to open data connection.
ftp> quit
---> QUIT
221 QUIT subcommand received.

Why would this work just fine 2 weeks ago, but now won't?

--

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.

--
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.
--
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.