Skip to main content
5 votes
Accepted

Specify a fie path for External SFTP Marketing Cloud

When you choose "External SFTP" as the location type, your Url field should have the absolute path to the ftp folder you need to access. Example: sftp://ftp.domain.com/folderForSFMC/ You can find ...
jake314159's user avatar
5 votes
Accepted

Can we authenticate external SFTP locations with SSH Key?

Yes you can. You would first create the key (the one for SFMC to use, not the actual SSH key) under 'Key Management' in admin selecting the SSH option (talk to your AE if you do not have this option ...
Gortonington's user avatar
  • 30.6k
4 votes
Accepted

Import a file from Reports folder in the SFTP

You can create data extract activity using 'Enhanced FTP File Move and Copy' extract type, it will help you to move/copy the file from one folder to another. Then you can create import activity to ...
salesforce-user's user avatar
4 votes

Automating File Move from Marketing Cloud SFTP Import to Export Folder

Salesforce Support are able to provision few custom Data Extracts having different functionalities, e.g. for deleting files. I seem to remember there is also an option of one specific type being able ...
Lukas Lunow's user avatar
  • 21.5k
3 votes
Accepted

Marketing Cloud FTP Whitelist

UPDATED: This is now self service through the setup FTP users. This can be achieved through a support case. This will need the IP range and the username you want to restrict access to.
EazyE's user avatar
  • 8,527
3 votes

How to push files into Enhanced FTP instead of Safehouse using Automation Studio

Safehouse is indeed the only way you can extract data from SFMC, before it hits the destination file location with File Transfer activity. It is a Salesforce Marketing Cloud secure file transfer ...
Lukas Lunow's user avatar
  • 21.5k
3 votes

How to create interpersonal documents (PDF Files) and how to attach them into email using a SFTP server?

PDF creation is not available inside SFMC, you would have to use a 3rd party platform to create those. Outside creating a complex custom script in a cloud page or script activity (high level of effort)...
Gortonington's user avatar
  • 30.6k
3 votes
Accepted

Data extract to SFTP subfolder

welcome to SFSE! I am afraid you are overthinking it. To set it to a subfolder, you need to create a file location specific to it. Here are the steps: Go to File Locations in Admin tab Click on ...
Gortonington's user avatar
  • 30.6k
3 votes

Create extra user Marketing Cloud FTP

Essential update - March 2020 It is now possible to create additional (up to 3 per BU) users in the user interface. Follow these steps: Hover over your name in the app switcher and click Setup. Click ...
Lukas Lunow's user avatar
  • 21.5k
3 votes

Create extra user Marketing Cloud FTP

Not by any standard means, as even the documentation on SFTP states the following: Marketing Cloud allows one FTP user per MID. Just in case you can check in with your SFMC Account Executive about ...
Rain's user avatar
  • 5,765
2 votes
Accepted

What's wrong with my code for SFTP connection?

Typically my first response would be: Did you white list the SFTP server via SFCC support? But, upon further inspection it appears you are trying to use SFTP to connect to the same instance the code ...
sholsinger's user avatar
2 votes
Accepted

what is marketingcloudops.com?

The new tenant specific URLs, both for FTP and API integrations, are introduced for performance reasons: Because subdomains are unique and assigned to each tenant, we can better optimize our ...
Lukas Lunow's user avatar
  • 21.5k
2 votes
Accepted

Marketing Cloud File Transfer Activity Changes

Edit A teammate of mine received the following response from SFMC about this issue: ...the configuration team... confirmed that the combination of both a strong password and cipher will be ...
Gortonington's user avatar
  • 30.6k
2 votes

Enable user access to a specific folder within Marketing Cloud FTP

It is not possible to have folder specific access in Enhanced FTP. All the users which are created in a specific Business Unit, all share access to same folder structure. If having multiple users with ...
Lukas Lunow's user avatar
  • 21.5k
2 votes
Accepted

Transforming .csv Discovery Report into pipe delimited Marketing Cloud

When you export a Discover report as a csv file, Discover uses double-quote as the text qualifier. In order to successfully import a file like this to a Data Extension, ensure you check the "...
Macca's user avatar
  • 8,216
2 votes
Accepted

Filedrop activity with .writing extension

Yes, usually it happens with big files that are not yet fully transferred, so they appear with a temporary file extension like .writing and once the process gets completed, the file is renamed to the ...
Niko's user avatar
  • 2,676
1 vote

Unable to decrypt a file securely from external file location and move it to a Safehouse in Marketing Cloud

You can ask SF Support to enable your account the "Delete file from ET FTP or Safehouse" Extract Type in the Data Extract Activity. Once done you would be able to place Data Extract Activity ...
Niko's user avatar
  • 2,676
1 vote

Automation Studio - I need Data Extract file UTF8 Without BOM

You can ask Salesforce support to provision an additional Data Extract to your account. There are multiple ones available, which are not implicitly shown in Automation Studio, and there for sure is ...
Lukas Lunow's user avatar
  • 21.5k
1 vote
Accepted

Marketing Cloud - Does Corporate License include FTP and SFTP?

Yes, each Marketing Cloud BU comes with an "enhanced" (s)FTP connected to it. Most of my client have corporate editions, we use sFTP for all of them - without that, SFMC would have a rather ...
Jonas Lamberty's user avatar
1 vote
Accepted

Error on SFMC account for sFTP integration

You can create a separate subfolder in the SFTP for each File Drop type and then utilize the folder with a more simple file naming pattern or choose even "No Filename Pattern" option since ...
Niko's user avatar
  • 2,676
1 vote
Accepted

"Exclude FTP Users From Password Expiration" : Yes Does this setting changes occur for that Business Unit or it is a global level?

This is a BU specific setting. Meaning you can set it to YES for MID 1, while same setting in MID 2 remains NO.
Lukas Lunow's user avatar
  • 21.5k
1 vote
Accepted

Salesforce Marketing Cloud Sending Data Extracts to Another (non-SFMC) SFMC Site

Yes, it's possible to setup external SFTP locations. Just go to: Email Studio > Admin > Data Management > File Locations Here's the official documentation on the subject and a screen how it ...
Rafał Wolsztyniak's user avatar
1 vote
Accepted

Is there any existing way to move a CSV file from SFTP to a media folder for recipient to download?

As Johannes correctly states, you will need to purchase file attachments, to be able to work with CSV files in emails. Also, I will not recommend attaching such files to emails, as they might grow ...
Lukas Lunow's user avatar
  • 21.5k
1 vote

File Permission in SFTP in marketing cloud

You can't do that with Marketing Cloud's SFTP - you cannot set permissions on a file level. The only permission control that is possible in Marketing Cloud's FTP is to restrict access for a user: You ...
zuzannamj's user avatar
  • 14.4k
1 vote
Accepted

File Permission in SFTP in marketing cloud

You cannot do this on a file level. Marketing Cloud however since one of the latest releases has been giving the option of three accounts per Business Units, for which you can set those permissions. ...
Jonas Lamberty's user avatar
1 vote

Marketing Cloud File Transfer Activity Changes

Am not sure on the point - "salesforce support say we need to use SSH keys to connect to Marketing cloud FTP now." Please double check with them again. I believe they are still supporting with ...
Naveen VM's user avatar
  • 1,681
1 vote

Automating File Move from Marketing Cloud SFTP Import to Export Folder

You can request Salesforce Support to provision the Data Extract Activity "Enhanced FTP File Move and Copy" to your account which gives you the option to move or copy from one folder to the ...
Doug's user avatar
  • 783
1 vote
Accepted

Automating File Move from Marketing Cloud SFTP Import to Export Folder

So this is how I resolved my quandary: Automation = Report Definition> Import File into a Data Extension > Data Extract (Data Extension) > File Transfer and encrypt, dropping to export folder.
chorlesbarkley7's user avatar
1 vote
Accepted

Unzip file activity doesn't create any files but no errors found

Turns out after speaking with Salesforce Support this was a provisioning (business rules) issue, they have altered the rules and it is now working as expected.
Deployment Failure's user avatar
1 vote

Unzip file activity doesn't create any files but no errors found

I've also had this problem and solved it by running each activity manually to the base "Import" folder to confirm the files were being extracted and moved correctly. The 3 activities needed to run a ...
Cameron Robert's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible