No thats not it, here is a copy of the log

[1/20/2011 5:49:10 PM] AUTOREPLACE true
[1/20/2011 5:49:10 PM] ftp_download okcinventory.asc
[1/20/2011 5:49:10 PM] ->>  TYPE A
[1/20/2011 5:49:10 PM] <<-  200 Type set to A.
[1/20/2011 5:49:10 PM] ->>  PORT 192,168,0,5,207,236
[1/20/2011 5:49:10 PM] <<-  200 PORT command successful.
[1/20/2011 5:49:10 PM] ->>  LIST
[1/20/2011 5:49:10 PM] <<-  150 Opening ASCII mode data connection for /bin/ls.
[1/20/2011 5:49:10 PM] <<-  226 Transfer complete.
[1/20/2011 5:49:10 PM] ->>  TYPE I
[1/20/2011 5:49:10 PM] <<-  200 Type set to I.
[1/20/2011 5:49:10 PM] WAIT 2000
[1/20/2011 5:49:12 PM] AUTOREPLACE TRUE
[1/20/2011 5:49:12 PM] FTP_DISCONNECT
[1/20/2011 5:49:12 PM] ->>  QUIT
[1/20/2011 5:49:12 PM] HIDE PROGRESS
[1/20/2011 5:49:13 PM] SAVE_LOG true




________________________________
From: Steve Vellella <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Thu, January 20, 2011 5:08:11 PM
Subject: [RBASE-L] - RE: RFTPClient 90


Tom,
 
It looks like you are missing the quote at the end of your FTP_DOWNLOAD line.
 
Steve
 
Steve Vellella
Office: 520-498-2256
Cell: 520-250-6498
From:[email protected] [mailto:[email protected]] On Behalf Of TOM HART
Sent: Thursday, January 20, 2011 3:43 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RFTPClient 90
 
I am just starting to use this and cannot seem to get a file to download, I can 
upload a file fine.  I get no error messages and the progress screen comes up 
then nothing.  The following is my code and it traces fine.  I get logged on 
fine.

--to download a file
SELECT 
FTPUserName,FTPPassword,FTPHostName,FTPPort,FTPHostFolder,FTPWorkFolder,FTPDownFile,FTPUpFile
 +
INTO 
zFTPUserName,zFTPPassword,zFTPHostName,zFTPPort,zFTPHostFolder,zFTPWorkFolder,zFTPDownFile,zFTPUpFile
 +
from FTPTable where FTPID = 'OKC'
set var zFileName = (.zFTPWorkFolder+'\'+.zFTPUpFile)
SET VAR vQuote TEXT = (CVAL('QUOTES'))
    set var vUserName text = (.vQuote+'v1|FTP_USERNAME'&.zFTPUserName)
    set var vPassWord text = (.vQuote+'v1|FTP_PASSWORD'&.zFTPPassword)
    set var vHostName text = (.vQuote+'v1|FTP_HOST'&.zFTPHostName)
    set var vPort text = (.vQuote+'v1|FTP_PORT'&(ctxt(.zFTPPort)))
    set var vHostFolder text = (.vQuote+'v1|FTP_CHDIR'&.zFTPHostFolder)
    set var vFileName text = (.vQuote+'v1|FTP_DOWNLOAD'&.zFTPDownFile)
    set var vFolderName text = (.vQuote+'v1|CHDIR'&.zFTPWorkFolder)
PLUGIN RFTPClient 'v1|LOG_FILE_NAME c:\rbase90emailwork\RFTP.log'
PLUGIN RFTPClient 'v1|SAVE_LOG TRUE'
PLUGIN RFTPClient 'v1|SHOW PROGRESS'
PLUGIN RFTPClient &vUserName
PLUGIN RFTPClient &vPassWord
PLUGIN RFTPClient &vHostName
PLUGIN RFTPClient &vPort
PLUGIN RFTPClient 'v1|FTP_CONNECT'
PLUGIN RFTPClient 'v1|WAIT 2000'
PLUGIN RFTPClient 'v1|ftp_chdir \toomas83\daisyinventory'
PLUGIN RFTPClient 'v1|AUTOREPLACE true'
PLUGIN RFTPClient 'v1|ftp_download okcinventory.asc
PLUGIN RFTPClient 'v1|WAIT 2000'
--PLUGIN RFTPClient &vFolderName
PLUGIN RFTPClient 'v1|AUTOREPLACE TRUE'
PLUGIN RFTPClient 'v1|FTP_DISCONNECT'
PLUGIN RFTPClient 'v1|HIDE PROGRESS'
PLUGIN RFTPClient 'v1|SAVE_LOG true'
return

Reply via email to