[RBASE-L] - RE: RFTPClient 90

[Steve Vellella]

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: rbase-l@rbase.com [mailto:rbase-l@rbase.com] 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,FTPD
ownFile,FTPUpFile +
INTO
zFTPUserName,zFTPPassword,zFTPHostName,zFTPPort,zFTPHostFolder,zFTPWorkFolde
r,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