We use Filezilla with it's command line options.
To download:
vfilezilla = 'ZIP D:\FileZilla\filezilla.exe -d' & +
'sftp://username:[EMAIL PROTECTED]' + +
'/remote/path/' + .infile & 'local/path'
To Send:
vfilezilla = 'ZIP D:\FileZilla\filezilla.exe -u' & +
'sftp://username:[EMAIL PROTECTED]' + +
'local/path' & '/remote/path/' + .outfile
http://filezilla.sourceforge.com
Betaserver wrote:
I have a very large customer who has us sending them ASCII delimited data files for them
to upload into their SQL server. Easy enough, and I have an automated code that emails
them the files, no user interaction. Now they want to "automate" the process
more on their end. They want us to FTP the files to their system. Well I can do this
using one of the FTP clients I have, but this is manual on our end and I would like to
automate the FTP so that our users can just click a button on RBase and it goes
automatically. I have been looking at some FTP clients that use VB scripts or ASP that
with some editing could probably do this. But I wanted to throw it out here to see if
anyone else has done this before with RBase and what FTP client they recommend, and maybe
even what their code/script looks like for making this automated and require no user
interaction.
This would be RBase 7.1 on Windows 2003 server.
-- Frank Taylor, Systems Network Administrator
-- F.J. O'Hara Corp, Boston, MA
-- [EMAIL PROTECTED] - 617-790-3093
