Ben, Mike, Bernie, Thanks, this was just what I was looking for.. Let me play around with each of your suggestions and see what I come up with for a best solution for us, and if I have more questions I will post them.
-- Frank -- Frank Taylor, Systems Network Administrator -- F.J. O'Hara Corp, Boston, MA -- [EMAIL PROTECTED] - 617-790-3093 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Bernard Lis Sent: Wednesday, October 12, 2005 11:47 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Automate FTP Uploads with RBase ? 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
