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