Hi Frank,
I am in the process of doing this (with assistance from Richard Kahl and
others).
I launch a .bat file with the ftp instrucions that refer to a command file.
I am transfering data from a Steel Manufacturer to an independent warehouse,
processing the data and sending back to the manufacturer when the steel
coils are shipped.
Initially, I get the data for incoming shipments:
ftp -s:getfile.txt -d -i 65.240.12.345 >getit.txt
where getfile is the command file below, getit.txt will contain the results
of the ftp
duns12986 *(My ID )
Yticapac0 *( my pwd -- changed to protect the innocent)
cd outbound/send *( where my data resides )
mget duns12986.cmp.* *( get all files available)
Then I do similar to delete the files I just retireved
And similar to return data to them.
If you need more examples, I will be happy to help
Bernie Lis
----- Original Message -----
From: "Betaserver" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Wednesday, October 12, 2005 11:27 AM
Subject: [RBG7-L] - Automate FTP Uploads with RBase ?
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
