NTS Forums

Please login or register.

Login with username, password and session length
 

News:

Welcome to the Newtek Technology Services Forum!


Author Topic: FTP client that supports wildcard and scheduling?  (Read 2025 times)

Offline MorningZ

  • Hero Member
  • *****
  • Posts: 5,366
  • Karma: +124/-25
    • My Neglicted Personal Website
FTP client that supports wildcard and scheduling?
« on: December 16, 2009, 06:55:17 PM »
I've got a program creating zipped DB backups on a remote server and i would like to have my Home Server here automatically go FTP them from there to here at the house

the backup program creates the files like

<database name>YYYYMMDDHHMMSS.zip

and is not adjustable  :-(

So i need an FTP client that i can:
- Run as a service
- Go get a file based on a pattern
- Run on a schedule...

Although I assume that the third point isn't as important as i could run the FTP program from Scheduled Tasks

any suggestions?
"When I get fired, i want people to say: Wow! did that guy get canned!!!!" - George Castanza

"if you have one bucket that holds two gallons and another bucket that holds five gallons... how many buckets do you have?" - Mike Judge's Idiocracy

Offline jbcampos [CT]

  • CrystalTech
  • Jr. Member
  • *****
  • Posts: 150
  • Karma: +13/-0
    • CrystalTech Web Hosting, Inc.
Re: FTP client that supports wildcard and scheduling?
« Reply #1 on: March 30, 2010, 05:17:59 PM »
I realize this was months ago, sorry for just seeing this. You might have an easier time just scripting this out using vbscript and using a wshell object to interface with the windows FTP client then just add it to scheduled tasks. You can actually pass the windows FTP client scripts. Just build a txt file or something using vbscript then pass it to the ftp client as such:

Set objShell = CreateObject("WScript.Shell")
objShell.Run "c:\windows\system32\ftp.exe -s:getmystuff.txt", , True

The text file you build would just contain the commands. For instance you would use vbscript to write a text file that would generate:

open ftp.server.com
ftpusername
ftppass
cd /placewherestuffis/
get <database name>YYYYMMDDHHMMSS.zip
quit

Something like that. Advantage of being able to use scripting to create the text file is that you can now use logic statements to tell the ftp client what to download by passing it a text file written by the script.

Path might be different on your local workstation but you get the idea. Hope this helps. You could probably do the same thing with a bat script or even perl if your more familiar with it. I do a lot of administrative scripting in each, they are all pretty easy to get up and going with.
Joseph Campos
Server Operations
Toll Free: 1-877-323-4678
Phone: 602-263-0300 Opt. #4

Offline MorningZ

  • Hero Member
  • *****
  • Posts: 5,366
  • Karma: +124/-25
    • My Neglicted Personal Website
Re: FTP client that supports wildcard and scheduling?
« Reply #2 on: March 30, 2010, 05:40:00 PM »
Actually... i found this incredible program, and it's free

http://sqlbackupandftp.com/
"When I get fired, i want people to say: Wow! did that guy get canned!!!!" - George Castanza

"if you have one bucket that holds two gallons and another bucket that holds five gallons... how many buckets do you have?" - Mike Judge's Idiocracy

Offline jbcampos [CT]

  • CrystalTech
  • Jr. Member
  • *****
  • Posts: 150
  • Karma: +13/-0
    • CrystalTech Web Hosting, Inc.
Re: FTP client that supports wildcard and scheduling?
« Reply #3 on: March 30, 2010, 06:30:08 PM »
Actually... i found this incredible program, and it's free

http://sqlbackupandftp.com/


Taking the easy way out. I see. I see. :) Glad you got it figured out. Sorry for responding so late.
Joseph Campos
Server Operations
Toll Free: 1-877-323-4678
Phone: 602-263-0300 Opt. #4

Offline jamesedmunds

  • Full Member
  • ***
  • Posts: 584
  • Karma: +18/-0
    • http://jamesedmunds.com/poorclio
Re: FTP client that supports wildcard and scheduling?
« Reply #4 on: March 31, 2010, 06:42:43 AM »
Wow, fabulous looking program. Does anyone know of something likewise for MySQL?

-James
James Edmunds
New Iberia, LA