Send-FTP Script with Error Checking?

Hi -

I'm new to PowerShell scripting and I'm trying to create a script (I'm not
sure if it is supposed to be typed withing the PowerShell window) that will
automatically FTP the contents of a directory (all SQL .BAK files) on a
server in one location to a FTP server in another location. I would also
like the script to ZIP the contents of the original directory before FTPing
them to the remote server.

The script also needs to be doing some sort of error checking so that if a
problem occurs, it can report it to me in some sort of text file...

Is this even possible? I created a .PS1 file with the following code (which
is insanely simple) to move a basic txt file from one location to another and
it worked fine minus all of the other things I want to do. Am I heading in
the right direction or not???

send-ftp -server ftp.filetransfercentral.com -user xxxxx -password xxxxx
-localfile c:\test.txt -remotefile test3.txt


Thanks in advance for the help!

Michael
mike.trantas@xxxxxx

Michael Trantas wrote: send-ftp from NetCmdlets right?

I see they support erroraction and errorvariable:
http://blogs.msdn.com/powershell/arc...rvariable.aspx

What you're asking for is all possible. I just can't do it for you
right now.

Someone else migth step up or I might be able to provide you all the
code in the next 24 hours.

If the script fails, you want an email report perhaps?

Marco


--
Microsoft MVP - Windows PowerShell
http://www.microsoft.com/mvp

PowerGadgets MVP
http://www.powergadgets.com/mvp

Blog:
http://marcoshaw.blogspot.com

Yes, that's exactly what I'm talking about - the process should be as follows:

ZIP the files in a directory --> FTP the ZIP file to a server in a remote
location and place in a specific directory --> report (or error check) the
transfer by sending a TXT file to my e-mail address when the transfer is
complete.

Yes, I am using NetCmdlets too.

Thank you for your help - I'm in no rush so anything you can do would be
appreciated. I just have no clue about scripting or writing code so anything
you can do would need a detailed explaination for me to understand...

Thanks again!

Michael

"Marco Shaw [MVP]" wrote:

The other variable I forgot to include in this is that while it is being
zipped, it needs to be encrypted. The SQL data included in these BAK files
contains social security numbers so it needs to be highly secure.

I know that this throws a wrench into the whole process so I'll apologize
now before it gets too hairy.

"Michael Trantas" wrote:

Michael Trantas wrote: OK, so the data needs to be encrypted or the FTP transfer or *both*?

I'm not so sure about things now, but its a good challenge.


--
Microsoft MVP - Windows PowerShell
http://www.microsoft.com/mvp

PowerGadgets MVP
http://www.powergadgets.com/mvp

Blog:
http://marcoshaw.blogspot.com

Marco -

Initially, the ZIP file needs to be encrypted (DES or the like). I know
that the FTP transfer process is not encrypted but if you know a way to make
it encrypted, that would be great - we really don't any type of secured FTP
transmission methods right now...

Thanks again - I'm really looking forward to seeing what you come up with
and learning how you did it!

Michael

"Marco Shaw [MVP]" wrote:

Michael Trantas wrote: Didn't have the chance to work on this yet.

I just noticed that NetCmdlets' write-zip can do AES encryption. Does
that work for you? Unencryption is done via a password though. Maybe
you needed something else like a cert or something?

Feel free to email me at marco DOT shaw AT gmail DOT com

Also, for the SSL/SSH FTP transfer, your server must also support it.
You have a system/network administrator you can ask about that?

Marco