Automation Studio – File-based Automation Workflow Examples

Scenario 1: Importing a compressed and encrypted file as soon as file is dropped in FTP

File Name:	products.zip.pgp
Enhanced FTP Folder:	\Import\FileDrops
Starting Source:	File Drop
Included Activities:	1. File Transfer Activity (Manage File)
	2. Import Activity

Scenario 2: Importing a regular csv file as soon as file is dropped in FTP

File Name:	OrderDetails.csv
Enhanced FTP Folder:	\Import\Ecommerce
Starting Source:	File Drop
Included Activities:	1. Import Activity

Scenario 3: Importing a compressed and encrypted file from FTP based on a schedule

File Name:	products.zip.pgp
Enhanced FTP Folder:	\Import\
Starting Source:	Schedule
Included Activities:	1. File Transfer Activity (Manage File)
	2. Import Activity

Scenario 4: Importing a regular csv file from FTP based on a schedule

File Name:	OrderDetails.csv
Enhanced FTP Folder:	\Import\
Starting Source:	Schedule
Included Activities:	1. Import Activity

Scenario 5: Exporting data from a DataExtension as a compressed & encrypted file to FTP

Data Extension Name:	OrderDetailsDE
Starting Source:	Schedule
Target FTP Folder:	\Export\
Included Activities:	1. Data Extract Activity Extract type – Custom DE Extract with Zip Output – Safehouse\OrderDetails.zip
	2. File Transfer Activity (Move File from Safehouse) Encrypt – PGP option Output – FTP\Export\OrderDetails.zip.pgp (encrypted)

Scenario 6: Exporting data from a DataExtension as a compressed & encrypted file to FTP (alternate way and recommended)

Data Extension Name:	OrderDetailsDE
Starting Source:	Schedule
Target FTP Folder:	\Export\
Included Activities:	1. Data Extract Activity Extract type – Data Extension Extract (as CSV) Output – Safehouse\OrderDetails.csv (Unicode format)
	2. Data Extract Activity Extract type – File Convert (UTF8) Output – Safehouse\OrderDetails.csv (UTF8 format)
	3. File Transfer Activity (Move File from Safehouse) Encrypt – PGP option Output – FTP\Export\OrderDetails.csv.pgp (encrypted)
	4. Data Extract Activity Output – FTP\Export\OrderDetails.csv.pgp.zip (encrypted and compressed)