[SalesForce] Rename/move file on FTP server after import activity is done

I'm not sure which PGP public key you are using. You can use a public key to encrypt a PGP file, but you can't use a public key alone to decrypt a PGP file as this will require the corresponding private key (unless you are using the ExactTarget public key).

I believe it is possible to use your own PGP public/private key combination with Safehouse, but you will need to open a support case to have this configured. I've never done this though. My advice would be to encrypt the PGP file using the ExactTarget PGP public key (if you are not doing so already) which you can download here.

Here are the two steps that should appear in your Automation.

1. File Transfer Activity

• Set Transfer Type as 'Download'
• Set the File location to where the file is transferred to
• Set File naming pattern to %%FILENAME_FROM_TRIGGER%%
• Enable 'File is encrypted' in Transfer Settings
• Configure other settings as you normally would

2. Import Activity

• Set file location to 'Safehouse'
• Set filenaming pattern to %%BASEFILENAME_FROM_TRIGGER%%.csv (change 'csv' to match the file extension of the decrypted file)
• Configure other settings as you normally would

Safehouse

The Safehouse file location is not created by default. If you do not have this in Email app > Admin > Data Management > File Locations, create one named 'Safehouse' and set the Location Type to 'Safehouse'.

Note that I've configured a couple of different accounts recently where importing decrypted PGP files fail. If the automation fails on the import activity as it can't find the decrypted file in Safehouse, then you will need to open a support case to have this configured.

File Imports are the most tried and true method of getting large amounts of data into SMFC. As for limitations -- most of the issues I've seen with imports haven't been with size or row counts -- it's been with bad data, like extra CR/LFs, bad delimiters or improper text qualification. Importing structured data like XML is possible, but not recommended. The functionality is too limited.

As for file size, I've worked in some accounts that import 3 gigabyte files every day.

If you're having issues with File Imports and you have an older account (more than 3 years old), check with SFMC Support to see if you have the latest version of the importer.

There are also several business rules that modify file import behavior -- like importing empty files without error, etc.

There are also several options for handling encrypted files, the Safehouse, and file-drop triggered automations.