I'm trying to develop a script that can be scheduled to run 1x/day to automate the process of logging into a domain and using FTP, select and download the newest access log(s) into a local storage repository.
The reason I mention the above is that I'm open to any reasonable method of implimenting this...eg, command line, etc. I haven't done all that much research specific to see if someone has already written a shareware app or script to do this exact task.
What I have found is Automator. In Automator, its pretty straightforward to invoke my FTP application (Transmit) and by using its 'synchronize' feature, get it to download any new files to the intended local destination. What's kind of nice about this approach is that if the script fails to run for some reason, the next time it runs, it will pick up howerver many new access log files exist.
The problem I'm having is that when the Automator "script" runs, it starts Transmit and selects the correct account for the FTP, but then pauses because it wants the account's password to be entered. Once the password is manually entered, the rest runs OK to completion. Obviously, having this manual entry point of the password entry defeats the basic purpose of having a script that can run unattended.
Question is: what do I need to add/change/etc to have the script be able to enter the Account password for the FTP application to not hang?
My general thoughts are that the password for Transmit might need to go into the Keychain, but I don't see the obvious method with which to do this.