0

Setting up an automation to occur on file drop but it appears the only options for directory choice are in the import folder or the legacy triggered automations folder.

The file that I'm dropping is actually dropping to a different business unit's FTP (the parent). Is there any way to select a different FTP directory for the File drop starting source?

1

Short answer, it is not possible. The listener for this is only viable on SFMC Import folder and those subdirectories below it.

Now, it is possible to 'fake' this, but it requires your 3rd party system to drop the main file on your external FTP and then drop an empty or small file to SFMC SFTP folder when that file is finished being uploaded.

To elaborate:

  1. Set up a Triggered Automation (select your desired folder and file name pattern for the 'dummy' file)
  2. Set your import activity to pull from the external FTP to grab the data file
  3. Create the activity in your 3rd party data system to first drop the data file to your external FTP.
  4. After this file has finished loading, have it shoot over a dummy file to the SFMC to trigger the automation.

Another option if your system can send API calls is to:

  1. Have a 'scheduled' automation set up with the import activity but do not schedule it.

  2. You then have your external system shoot over an Automation Studio API call to start the automation once the file has finished uploading to the FTP.

  3. Your Automation runs, importing the file from the external FTP.

Both of these are a bit much and require a good amount of extra work. Unless it is necessary to store this file elsewhere, I would adjust the process to drop it to SFMC instead.

  • Really helpful. The reason for the ask is my external system (Dell Boomi) has a limited amount of connector licenses (already maxed out) and I was hoping I could rig it to grab files from the Parent BU's FTP. You're right - easiest and best option is to just purchase more connection licenses. – Tom Callahan Sep 7 '18 at 15:31
  • Another possible solution: have the file drop activity on the parent and instead of an import, do a file transfer to the import folder of a child BU into the import folder there. Thoughts? – Tom Callahan Sep 7 '18 at 16:00
  • NOPE! FileTransfer activity doesn't work that way. You CAN use a shared FTP across other BU's. This is the route I'll go. – Tom Callahan Sep 7 '18 at 16:38

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.