Skip to main content
8 votes
Accepted

SSJS to delete files on enhanced FTP

You can open a support request to enable the 'Delete file from ET FTP or Safehouse' Extract Type in the Data Extract Activity, which will delete the file that matches the filename that you defined in ...
Eliot Harper's user avatar
  • 16.6k
6 votes
Accepted

file trigger automation filepart error

My best guess here is the file is being renamed between triggering the automation and reaching the import activity. And I am not talking about something.csv to whatever.csv, but more on the filename ...
Lukas Lunow's user avatar
  • 21.7k
5 votes
Accepted

Limitations for Import from Enhanced FTP in SFMC

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'...
Adam Spriggs's user avatar
  • 30.8k
5 votes

File Transfer Activity Encrypt and Decrypt with PGP

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 ...
Eliot Harper's user avatar
  • 16.6k
4 votes

Deletion of Files from FTP after reading

We're looking at deletion as part of controlling sensitive data on the SFTP. Do you have access to a safehouse as a file transfer solution? If not, you may need to create one (thanks Eliot Harper for ...
SenatorWaffles's user avatar
4 votes

SSJS to delete files on enhanced FTP

As far as I know, it's not possible to delete files from the FTP with platform scripting. Files in the Export and Import directories are purged after 21-30 days, if that matters.
Adam Spriggs's user avatar
  • 30.8k
4 votes
Accepted

Export Data Extension data to Email, not FTP?

Short Answer: No Explanation: The two methods of exporting data from a data extension are : If the file is less than 20 MB it can be downloaded to your pc. Files larger than this will have to be ...
0xsegfault's user avatar
  • 6,603
4 votes

Salesforce Marketing Cloud ability to drop files to different child BU's FTP

You would want to add the SFTP information for your child unit into your Parent BU as a 'File Location'. This can be found in the admin section under Data Management. This would require you to choose ...
Gortonington's user avatar
  • 30.7k
4 votes
Accepted

FTP and File location

SFMC documentation is a bit confusing on these topics.. There is a separate FTP space provided for each BU, the login name is always the BU MID. So if you have primary BU and 10 child-BU's, you'll ...
Rain's user avatar
  • 5,785
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
Accepted

Export file from FTP with API

Depending on the system you like to fetch files from, there is no need to do so via an API as the (S)FTP protocol is capable of doing so and almost any programming language supports this protocol or ...
Markus Dang - formerly Slabina'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.7k
4 votes

Data View Counts not Matching FTP upload counts

Without knowing exactly how your external processes work it will be tough to say for certain. Something to potentially look in to would be the Unique factor of these results. You are extracting Opens ...
didntStormArea51's user avatar
4 votes
Accepted

Retreive file present in ftp from cloud page

This is not possible, unfortunately. SSJS and Ampscript are quite limited when it comes to utilising e.g. FTP protocol, and the Enhanced FTP folder is not able to expose its files over HTTP(S) (which ...
Lukas Lunow's user avatar
  • 21.7k
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.7k
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.7k
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,785
3 votes
Accepted

Import Automation for Mobile Studio [Solved]

If you want to import data from a CSV via an automation. You need to create an import activity inside Contact Builder. Then you decide to push the data SMS all contact or a specific list. In ...
Jeremy Garcia's user avatar
3 votes
Accepted

Can we configure an external FTP Location in Marketing Cloud?

Yes, we can configure an FTP Location which is outside Marketing Cloud FTP y following below steps. Go to Administration Navigate to Data Admnistration > File Location Click Create Select Location ...
Unais Komath's user avatar
3 votes

Exact Target SFTP public key authentication

Typically, the only thing required to access the Enhanced FTP as an sFTP is to change your port on your client (Filezilla, etc.) to port 22. (from port 21). That's pretty much it. Same user and ...
Aaron Beatty's user avatar
3 votes

Create records in Salesforce from CSV file stored at server location

You can hit the URL using Rest webservice and parse the data and create records. You can use Batch or Future to achieve this. http://developer.financialforce.com/customizations/importing-large-csv-...
Pranay Jaiswal's user avatar
3 votes

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

You can use the move file functionality. Please see below https://help.salesforce.com/articleView?id=000230276&type=1 Thanks
Chandan's user avatar
  • 673
3 votes

File not triggering automation, but then exact same file when manually dropped does trigger automation? (Automation Studio, Marketing Cloud)

Here is my theory. I assume you are utilising a filename suffix in your trigger filename pattern: New_Customer_Data_Report%%Day%%%%Month%%%%Year%%.csv Some FTP integrations, especially when dealing ...
Lukas Lunow's user avatar
  • 21.7k
2 votes

Importing Data in salesforce from external system using .csv file with FTP server

You can also use Dataloader CLI to automate the process of importing the records into salesforce from csv file. Since you are using a FTP server , you can schedule a windows batch job that can pick ...
SfdcBat's user avatar
  • 4,821
2 votes

External FTP File Transfer Activity Error in Automation Studio

Marketing Cloud Tier 2 told me that the exception at backend is "FTPOutputProtocol: ReadFrom failure (attempt #1) - No such host is known ". This was related to my File Location configuration. In ...
Unais Komath's user avatar
2 votes
Accepted

Combine FTP and Sales Cloud data through Data Filter?

You could set up an Automation with a SQL query activity that joins the two data extensions and writes the result into another data extension which is then used for your email send. The query can also ...
Markus Dang - formerly Slabina's user avatar
2 votes
Accepted

Download Marketing Cloud's Report data

It's possible to use Automation Studio's Report Activity to automatically have a report exported to the FTP as CSV. Once it's on the FTP, you could use an Import Activity to import it into a Data ...
Christopher Carswell's user avatar
2 votes
Accepted

Create an automation to fetch data from FTP and create a DE that updates every day

This is a message you get when you're trying to use files from a folder without specifiying a Filename Pattern. What you need to do is check "Use Filename Pattern" with a specific word that can be ...
Zak Ben's user avatar
  • 463
2 votes
Accepted

Marketing Cloud FTP sub folder management

Both are possible. Here are the steps and information to achieve your request. 1) You can use a FTP client application like FileZilla or Cyberduck to manage subfolders in FTP location. 2) Once the ...
Brad Sapkota - altus.digital's user avatar
2 votes
Accepted

How to set SFMC FTP password to not expire?

If you are talking about marketing cloud, you do this in setup:
EazyE's user avatar
  • 8,547

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