CSV import — SFTP integration

Use the secure FTP channel integration to share files between your system and Medallia Concierge.

FTP, or "File Transfer Protocol" is a popular method of transferring files between two remote systems such as your contact management system and Medallia Concierge. SFTP stands for "Secure File Transfer Protocol" and works in a similar way but over a secure connection. The advantage is the ability to leverage a secure connection to transfer files and traverse the filesystem on both the local and remote system.

To use Medallia Concierge's SFTP with your contact management system, take the following steps:

1. Browse to Admin Settings > Integrations > CSV Import SFTP

example of a CSV import

integrations link in the sidebar menu

CSV import SFTP button

2. Select Create SFTP credentials.

example of a CSV import

3. Select Show next to the password to display the password to be copied.​

example of a CSV import

4. Go to your contact management system or ftp client. Copy the credentials displayed in Medallia Concierge, paste them into the appropriate areas and connect. ​

image of SFTP configuration

5. Export a CSV file in its default format from your system, have it ready in a designated location on your computer. Navigate to your contact management system or FTP desktop client. Use Medallia Concierge's SFTP as the destination for your exported CSV or manually drop the CSV into the /files folder as shown below.

example of connecting to an SFTP server

6. Wait several minutes before returning to Medallia Concierge. Select the Map Fields button once it's illuminated in blue.

image of the map fields button

7. Choose the contact field to which each column will export to. Once finished, select Save Mapping.

image of column mapping

Going forward each new CSV saved to the SFTP will be automatically imported into Medallia Concierge.

Learn more about Medallia Concierge's automated CSV import via email as an alternative to the SFTP method here.