There are two steps:
- Setup the SFTP process, then
- Automate the SFTP process.
If you're a Unix client, you can use the SCP command. If you're using SQL server, here is a useful topic on the subject: http://haacked.com/archive/2006/04/21/sqlstoredproceduretoftpfilesfromsqlserver.aspx .
For SFTP, you will need to change the port to 22 (SFTP) from 21 (FTP). CivicReady uses SFTP.
"We created a separate file and web entry form to collect/update the data. We extract data every night, ship it to a Linux box for a bit of error checking and post processing, and then shove it to the external/ENS server using the Unix program \"curl.\"
We also have a perl program or two that lets us select records with incomplete or erroneous information (illegal phone number format) which we can optionally e-mail to the \"offending\" parties."