[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== No joy with FTPSEND (OpenInsight 32-bit Specific) ====
=== At 18 APR 2006 05:06:53PM Nick Stevenson wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
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
</QUOTE>
----

=== At 18 APR 2006 06:41PM ftomeo@srpcs.com's Frank Tomeo wrote:  ===

<QUOTE>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,



ftomeo@srpcs.com
[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]

[img]http://www.srpcs.com/srpicon1.gif[/img]

</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 nick.stevenson@i4partners.co.uk.

</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

</QUOTE>

----

=== At 24 APR 2006 10:15AM dsig _at_ sigafoos.org wrote:  ===

<QUOTE>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

</QUOTE>

----

=== At 24 APR 2006 12:04PM Nick Stevenson wrote:  ===

<QUOTE>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?

</QUOTE>

----

=== At 24 APR 2006 07:49PM dsig _at_ sigafoos.org wrote:  ===

<QUOTE>currently 7.2.1 but before the ftpManager was written in 7.1



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

</QUOTE>

----

=== At 25 APR 2006 03:55AM Nick Stevenson wrote:  ===

<QUOTE>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.

</QUOTE>

----

=== At 25 APR 2006 10:21AM dsig _at_ sigafoos.org wrote:  ===

<QUOTE>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

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=4C753D950A868809852571540073FCF7|View this thread on the  forum...]]