SFTP upload for CSV files

You can upload audience lists, attributes, named user association lists, and Coupons data directly to Airship using SFTP.

Many CRM platforms export data as CSV files. You can take advantage of Airship’s SFTP interface to upload that data to:

All uploaded files are encrypted in transit and at rest.

You will need:

  1. An FTP/SFTP client — Many CRM platforms support SFTP directly, or you can use a client like FileZilla.
  2. SSH keys — Airship’s implementation of SFTP uses public key authentication.
  3. A properly formatted CSV file
 Important

You must define custom attributes or add predefined attributes in the dashboard before associating them with channels and named users. Trying to use a custom or predefined attribute that you haven’t yet set up in the dashboard will result in an error.

 Tip

You can also upload audience lists, attributes, named user association lists, and Coupons data in the dashboard. See:

Format your CSV

Prepare your CSV according to the formatting reference for the data you want to upload:

Generate a secure key for Airship

Airship’s SFTP implementation uses SSH key pairs for authentication. You will create a pair of keys: a private key for your client and a public key for Airship. When you add your public key to Airship, you select the Purpose for the key (audience/static lists or attributes), then we generate a username for your SFTP connection. You can use the same key pair to upload both audience/static lists and attributes, but you must add the public key to Airship twice — once for each purpose.

  1. Generate private and public keys.

    Windows-based clients
    1. Download and run puttygen.exe.
    2. Select RSA in the Parameters section near the bottom of the page and click Generate.
    3. Move the mouse around in the blank area, as instructed, until the key pair is generated and the Key section updates.
    4. Click Save public key and select the directory where you want to save your public key.
    5. Click Save private key and save the private key in the same folder as your public key.
    6. Copy the contents of the Public key for pasting into OpenSSH authorized_keys file field. You’ll paste this key in Airship in the next step. Make sure to copy the entire key, starting with ssh-rsa.
    MacOS- and Linux-based clients
    1. Open your terminal.

    2. At the command line, enter ssh-keygen -t rsa. You can set other options, but the key type must be set to RSA (-t rsa).

    3. Enter the directory and file name (without extension) for your new keys, e.g., /Users/your_username/Documents/rsa_keys/<filename>, and optionally enter a passphrase and confirm.

      This process generates two files based on the file name you provide:

      • <filename> contains your private key.
      • <filename>.pub contains your public key.
    4. Copy the contents of your .pub file. You’ll paste this key in Airship in the next step.

  2. Add your public key to Airship.

    1. Go to Settings » Project Configuration and click Manage for SFTP.
    2. Click Add key and configure:
      • Purpose: Select Static Lists (Uploaded audience lists), Attributes, Named Users, or Coupons.
      • Name: Enter a name to help you identify the key in Airship.
      • Public key:
        • For Window users, paste the contents of the Public key for pasting into OpenSSH authorized_keys file field you copied in the previous step.
        • For MacOS and Linux users, paste the contents of the <filename>.pub you saved in the previous step.
    3. Click Save key.

If you need to remove a key from your project:

  1. Go to Settings » Project Configuration and click Manage for SFTP.
  2. Click   for a key.

Set up your client and transfer CSVs

You can set up any client to use Airship’s SFTP interface, and many CRM platforms natively support SFTP.

  1. Go to Settings » Project Configuration and click Manage for SFTP.
  2. Click   for a key. Use this information to set up your SFTP connection with Airship using SSH or an SFTP client. Authentication also requires your private key.
    • SSH command line: Use the field value.
    • SFTP client: Enter the field values in your client configuration.
      • Username
      • Host: sftp.airship.com (sftp.airship.eu for EU customers)
      • Port: 5222

After your connection is set up, you can transfer CSV lists to Airship.


After file transfer:

  • Audience Lists — Your uploaded lists are in Audience » Lists » Uploaded. See: Uploaded lists.

  • Attributes — Your attributes are listed in Audience » Attributes » Attribute List. See: Targeting your audience using attributes and Managing attributes.

  • Coupons — Your promotional campaigns are in Settings » Coupons. See: Coupons.

  • Named Users — You can view user data in Contact Management.

  • Attributes and Named Users — Your upload history is in Audience » Attributes » Upload History. The latest upload is listed first, with columns for:

    • File name
    • User name: The user who performed the upload in the dashboard
    • Source: Dashboard or SFTP
    • Upload date
    • Status: Processed, Processed with errors, Processing, or Failed

    For status Processed with errors, click   to download the error list.