We are trying to use FTPSEND() to send a file to an internet site, but without success. The error message tells us that there was an error creating the file. Has anyone got a working code snippet to share? OI7.1.1

Nick,

I've had good success with the FTPsend, but you have to make sure the rights are correct for the user, and the path at the FTP location actually exists. Here is a sample:

FTPdomain=www.myftpsite.com'

FTPuser =me_the_user'

FTPpswd =my_pswd'

FTPfile =subfolder/myfile.xml'

OSread FTPcontents from "c:\My Documents\myfile.xml" else null

rv=FTPSend(FTPdomain, FTPuser, FTPpswd, , FTPcontents, FTPfile, Error) Hope this helps, [email protected] SRP Computer Solutions, Inc. </QUOTE> —- === At 19 APR 2006 02:19PM dsig _at_ sigafoos.org wrote: === <QUOTE>Nick .. if you would like i could send off FTPManager .. it is a wrapper around the ftp processes .. similar to wsftp. Then you can steal all the good bits </QUOTE> —- === At 20 APR 2006 05:48AM Nick Stevenson wrote: === <QUOTE>Hi Mr Sig What I'm trying to do is copy an access.mdb file from our local server to our web site. An OI process updates the .mdb with latest info, then it has to be copied to the web site, where an admin process then inserts/updates that data to the main web site database. I am trying to make this whole process as easy as possible, hence the need for FTPSEND. If there is code in your wrapper that may help, I would forever be in your debt. If you could email it to me at [email protected]. </QUOTE> —- === At 20 APR 2006 09:29AM Warren Auyong wrote: === <QUOTE>Make sure your virus scanner and/or firewall is allowing OINSIGHT.EXE access to/through the FTP port (default=21). </QUOTE> —- === At 20 APR 2006 11:09AM dsig _at_ sigafoos.org wrote: === <QUOTE>i think i have it with me and will dig it out tonight .. if not it will wait until sunday .. what error do you get when you do the send? error and text does it work if you ftp it manually from the client to the server? </QUOTE> —- === At 20 APR 2006 11:09AM dsig _at_ sigafoos.org wrote: === <QUOTE>and that your ftp user has access </QUOTE> —- === At 24 APR 2006 04:40AM Nick Stevenson wrote: === <QUOTE>Doing it manually is fine, ie log to site via IE then cut and paste. In OI, the FTPSEND command creates the file (at 0 bytes), but then OpenEngine just dies - Task Manager says it is Not Responding, and I have to kill the processes. I thought it may be the access.mdb file contents causing the problem, but exactly the same thing happens if I try just a simple text file. The code I am using is: FTPdomain=www.mywebsite.co.uk' FTPuser=get_property(@window:'.FTP_USERID','TEXT') FTPpswd=get_property(@window:'.FTP_PASSWORD','TEXT') FTPfile=www/fpdb/fpdb1_update.mdb' msFile=g:\it\website\fpdb\fpdb1_update.mdb" OSread FTPcontents from msFile else call obj_msg('Unable to access database at ':msFile) return end rv=FTPSend(FTPdomain, FTPuser, FTPpswd, , FTPcontents, FTPfile, Error)

if len(Error) then

call obj_msg(Error)

end else

call obj_msg('Database transferred successfully')

end

I took your code and modified as shown below .. and al works quite well

subroutine dsig_testftp(void)

declare function ftpsend

FTPdomain=192.168.0.109'

*FTPuser=get_property(@window:'.FTP_USERID','TEXT')

*FTPpswd=get_property(@window:'.FTP_PASSWORD','TEXT')

*FTPfile=www/fpdb/fpdb1_update.mdb'

ftpuser=dsig'

ftppswd=secret'

ftpfile=emachinecyc.tb1'

msFile=c:\":ftpfile

OSread FTPcontents from msFile else

• call obj_msg('Unable to access database at ':msFile)

debug

return

end

rv=FTPSend(FTPdomain, FTPuser, FTPpswd, '', FTPcontents, FTPfile, Error)

if len(Error) then

• call obj_msg(Error)

debug

end else

• call obj_msg('Database transferred successfully')

end

return

This is weird - your code is essentially identical to mine. I have had to install a workaround whereby I execute a freeware FTP utility, and this works fine excepting the user has to select files etc.

Are you using OI 7.1.1?

currently 7.2.1 but before the ftpManager was written in 7.1

What is the rtn value .. and the error value?

No return value - OpenEngine dies during the FTPSEND process! However, if I enter an incorrect site password, for example, I get the correct security response in the return value.

hmm .. curious ..

if you would be interested .. i can give you a ftp address to send your file and i will try it .. see if it is the file or ..

let me know off line

DSig

View this thread on the forum...