Integrations and APIs - Database Integration (CSV)


How do I automate file upload to CivicReady SFTP Server?


There are two steps:

  1. Setup the SFTP process, then
  2. 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.

For SFTP, you will need to change the port to 22 (SFTP) from 21 (FTP). CivicReady uses SFTP. 

Client tip: 

"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."

I'd Like to Request an Enhancement

0 out of 0 found this helpful