Encrypting and importing feed files

Important: Test these steps in a sandbox environment first to make sure you configured the steps correctly and the data remains consistent across the platform.

Follow the steps below to import the file comments_import.csv, which contains comments from users so that each row is a feedback record in Medallia Experience Cloud.

id,lastname,firstname,comment
"4b86d212-7ec7-44ee-b7aa-009c12ccd133","Kreiger","Tobin","I love this product!"
"6ddd499b-616d-4d5c-be1c-9c3f82e97545","Effertz","Jaleel","Thank you"
"502aa3b6-f730-4240-8c31-a033e5cb2f10","Will","Victoria","Nice"

Encrypting the file

To encrypt the file:

Install gnupg. On macOS:
```
$ brew install gnupg
```
Download the QA public key from Medallia public PGP keys and import it:
```
$ gpg --import qa-public-key.asc
```
Generate our key pair:
```
$ gpg --full-generate-key
```

Check created keys:

gpg --list-public-keys

$ gpg --list-secret-keys

Export the public key to a file using the id from the command in the previous step:
```
$ gpg --export -o mypublickey.key <ID OR EMAIL FROM OUR KEY>
```

Encrypt the file:

$ gpg --encrypt --sign --recipient <ID OR EMAIL FROM MEDALLIA'S KEY> comments_import.csv

You have generated file comments_import.csv.pgp.

Importing the file

Restriction: Web feeds do not support importing encrypted files. However, use SFTP-based importers (Feed Pulls and SFTP Feeds) to import encrypted files.

To import the encrypted file:

Go to Integrations>Importers >Auto Importer Processors and create a processor with the following definition that matches the contents of the CSV file:

<import-spec inputType="CSV" columnsCheck="ALLOW_EXTRA_OR_MISSING_COLUMNS" name="Comments Import">
    <input-column heading="id" />
    <input-column heading="firstname" />
    <input-column heading="lastname" />
    <input-column heading="comment" />
    <output-column-group pluginName="Survey" recordUpdateMode="CREATE">
        <output-column>
            <input-column heading="id" />
            <target-field fieldId="e_bp_uniquerecordid_txt" fieldName="Unique Record Id" requiredness="REQUIRED_USED_FOR_DUPLICATE_CHECK" type="STRING" />
        </output-column>
        <output-column>
            <input-column heading="firstname" />
            <target-field fieldId="e_firstname" fieldName="First name" requiredness="REQUIRED" type="STRING" />
        </output-column>
        <output-column>
            <input-column heading="lastname" />
            <target-field fieldId="e_lastname" fieldName="Last name" requiredness="REQUIRED" type="STRING" />
        </output-column>
        <output-column>
            <input-column heading="comment" />
            <target-field fieldId="q_leave_comment" fieldName="Leave a comment" requiredness="REQUIRED" type="STRING" />
        </output-column>
        <survey-processor-options />
    </output-column-group>
</import-spec>

Go to Integrations >Importers >Feed Pull and create a new Feed Pull with the following options:
- Name — Comments Feed Pull
- Processing mode — Active
- Lifeftime of feed files — Company Setting
- Schedule — None
- Pull method — SFTP (password authentication)
- Hostname — Enter appropriate hostname for your instance.
- Login — connector
- Directory — encrypted-feedpull
- File regex — .*gpg
- Directory depth — 0
- Auto Importer processor — Comments Import
  Tip: You need a working SFTP server and credentials to upload the files and have Experience Cloud pull from it.
  Note: There is no option to indicate you are going to import encrypted files, the same importer can be used to import plain files. Experience Cloud attempts to decrypt the file based on the extensions PGP, GPG, or — when it detects that the file is encrypted — based on the contents.
Upload the GPG file to the SFTP in the directory specified in the Feed Pull.
On the Feed Pull screen, click Pull Feed now.
Go to Importers >Imported files, find the file and view the processing reports.

Reprocessing files

The Feed Pull does not download a file that was already processed from the SFTP server. To reprocess a file, go to the Imported files screen and click Reprocess feed file, or upload it to the SFTP server with a different name.