Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Not-so-simple FTP question

Posted on 2006-06-12
12
Medium Priority
?
299 Views
Last Modified: 2013-11-29
Hello everyone, how are you? Hope fine.

So, let's suppose I have FTP access to a server, holding several, continuously changing databases; suppose I want to turn on my computer, and launch a program that will automatically connect to this FTP, save the databases I want, and put them on a designated folder with a timestamp added to the file name.

Now, suppose I want to ask you how to do this. If so, what would be your answer?
0
Comment
Question by:Emanuele_Ciriachi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
12 Comments
 
LVL 10

Accepted Solution

by:
Sorenson earned 1536 total points
ID: 16887948
If the operating system is windows, create a script file and execute it with the ftp command.
for example
---startup.bat--
ftp runftp.scr
----------------

--runftp.scr--
open host.domain.com
user ftpuser
ftppassword
lcd c:\localfolder
bin
get databasename.db
quit
----------------

http://support.microsoft.com/?kbid=96269

0
 
LVL 1

Author Comment

by:Emanuele_Ciriachi
ID: 16887965
Will this work with Filezilla?

How can I add a timestamp to the filename?
0
 
LVL 1

Author Comment

by:Emanuele_Ciriachi
ID: 16887968
Oh and yes, OS is Windows.
0
Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

 
LVL 10

Expert Comment

by:Sorenson
ID: 16887999
The file will be timestamped with the time of the download.  I am not sure I understand the filezilla comment portion.  Is filezilla the server or client?
0
 
LVL 15

Expert Comment

by:nprignano
ID: 16888019
Filezilla is a Mozilla ftp client, and the above script will NOT use an FTP client to download the file - it will do so using ftp protocol only.


nprignano
0
 
LVL 1

Author Comment

by:Emanuele_Ciriachi
ID: 16888036
Filezilla is a freeware FTP client for Windows.

Another side question: "runftp.scr" must be edited as a text file?
0
 
LVL 10

Expert Comment

by:Sorenson
ID: 16888194
With this, you would not need the ftp client for windows.  It would use the command line one that is included with windows xp.

Yes both the batch and script file would be a text file.

0
 
LVL 1

Author Comment

by:Emanuele_Ciriachi
ID: 16888518
If my database is inside a directory, how should I change

get databasename.db

in

get /databasefolder/databasename.db

?
0
 
LVL 10

Expert Comment

by:Sorenson
ID: 16889049
or add line
cd /databasefolder

then do "get databasename.db"
0
 
LVL 10

Expert Comment

by:Sorenson
ID: 16889062
run the commands manually to see what works.
open a command window (dos window) on xp
Type:  ftp
then at the > prompt type each command from the .scr file in and test.
0
 
LVL 1

Author Comment

by:Emanuele_Ciriachi
ID: 16889198
Ok. Thanks for the added informations, that will earn you 50% more points.
0
 
LVL 10

Expert Comment

by:Sorenson
ID: 16893217
thank you
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This article explains the fundamentals of industrial networking which ultimately is the backbone network which is providing communications for process devices like robots and other not so interesting stuff.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question