0

Attempting to automate moving a report from Marketing Cloud's Import Folder to the Export folder, or from the Reports folder to the Export folder, and encrypt it. However, I don't show that the file transfer offers this capability, only to export from Marketing Cloud's Safehouse location. Unfortunately, as far as I can tell, you can't create a report definition and send it to the Marketing Cloud Safehouse. Is there a way to automate a file transfer from one Marketing Cloud SFTP folder to another?

  • What's the specific use case? – Stephan de Paly Feb 18 at 21:57
  • Sorry, I misclicked and can't remove the downvote myself :( – Stephan de Paly Feb 18 at 21:59
  • No worries. Use case is this: We need a report input to our export folder on the Marketing Cloud SFTP. My workflow would be to go Report Definition --> Reports or Import Folder --> Export Folder via Data Extract (we've provisioned that capability). However, the import has to be encrypted, and from what I can tell there's no way to encrypt a report definition or send it to the Marketing Cloud Safehouse. If I could send to the safehouse, I could then encrypt via File Transfer, but it doesn't look like that's a possibility. – chorlesbarkley7 Feb 18 at 22:30
4

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 to move files across folders on Enhanced FTP.

| improve this answer | |
  • Yes, you remember correctly. ;) we have extract types to move and delete enabled in a customer account. – Stephan de Paly Feb 18 at 22:00
  • We have that provisioned, but unfortunately we have to encrypt the file. So the only way would be to have it sent to the Safehouse, encrypt it, and then drop it. But I don't believe Marketing cloud allows you to send Reports to the Safehouse nor encrypt them. – chorlesbarkley7 Feb 18 at 22:49
0

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.

| improve this answer | |
0

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 other. I would love to add link to documentation, but when I asked why this is not documented I was told it was because this is not an officially supported feature sigh

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.