Topic "Automatically download data from a list of ip's and rename"

Author Message
X82
[View user's profile]

Joined: 2012-09-24
Posts: 6
Location: UK
I have a list of ip addresses, each has the same username and password. These ip's are for the powerbars here at my workplace.
Each bar's ftp contains a file, data.txt which I need downloading. So my question is 2 fold. Is there a way to automatically download the data.txt from all ip's with a simple double click on an icon on the desktop (need to make it idiot proof). And most importantly, I need these files to be renamed, since they would all be called data.txt. I originally did this in excel. With a column for the ip and a column which told excel to rename it to. For example, Server AMBA1, Server AMBE2 etc. I have about 400.

Can this be done?
All help in this matter is greatly appreciated!
X82
[View user's profile]

Joined: 2012-09-24
Posts: 6
Location: UK
Any ideas? Or am I asking the impossible? Embarassed
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24530
Location: Prague, Czechia
You can write a simple script for that, even plain Windows .bat would do.
Or VB code, if you are familiar with that, what I expect from you Excel experience.

The script would iterate over the IPs, executing parameterized WinSCP script for each.
See
http://winscp.net/eng/docs/guide_automation#parameterised
_________________
Martin Prikryl
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License