6/29/2010 is the date
________________________________ From: Steve Vellella <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, January 20, 2011 7:19:44 PM Subject: [RBASE-L] - RE: RFTPClient 90 Tom, There was an issue that I encountered last year with the RFTPCLIENT 9.0 and file downloads that RBTI took care of. What is the date on your RBM file? 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 5:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: RFTPClient 90 I had missed it on the copy but put it in and still does not work. If you look at the log it says ftp_download okcinventory.asc and that is the file I am looking for. I uploaded it and now I am trying to download it. Tom Hart ________________________________ From:Steve Vellella <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, January 20, 2011 6:45:38 PM Subject: [RBASE-L] - RE: RFTPClient 90 Tom, I am not sure, but it might be that it is executing the download command, but not finding the correct file name. I compared your code to the syntax I use and I definitely have a quote at the end of my file name. 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 4:56 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: RFTPClient 90 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
