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