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 ...
- 963
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 ...
- 29.9k
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 ...
- 19.5k
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 ...
- 144
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.
- 7,791
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)...
- 29.9k
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 ...
- 29.9k
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 ...
- 19.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 ...
- 5,600
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 ...
- 599
2
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 ...
- 19.5k
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 ...
- 19.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 ...
- 29.9k
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 ...
- 19.5k
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 ...
- 2,520
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 "...
- 8,041
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 ...
- 19.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 ...
- 8,820
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 ...
- 2,520
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.
- 19.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 ...
- 3,046
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 ...
- 19.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 ...
- 14k
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.
...
- 8,820
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 ...
- 1,635
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 ...
- 778
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.
- 134
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.
- 4,824
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 ...
- 2,308
1
vote
Accepted
Is Data Extract necessary if there is already a File Transfer?
If you had your file in MC SFTP already, you can use "File Transfer" activity (you have to configure it property though) followed by an import one for instance (this could be automated by leveraging ...
- 768
Only top scored, non community-wiki answers of a minimum length are eligible