Alternative for File Collector activity in ACS

Description

Environment

Adobe Campaign Standard

Issue/Symptoms

As ACS does not have the File Collector activity, you can build it using the following activities to achieve similar functionalities.

Resolution

The File Transfer will allow downloading multiple files based on filename pattern from an external server. Each file is passed into the Load File activity, giving data into the update.

Once completed, it continues with the following file and so on.

The File Transfer also has the Historization setting, as found in File Collector.

This is an example of a workflow execution log that processes four files from download to insert data into the schema.

log;Date;Activity name;Message
Workflow finished
writer1;1/1 record(s) processed (step 'Update data')
writer1;: Insertion of 0 record(s) ('Update data' step)
writer1;: updating 1 record(s) ('Update data' step)
writer1;: 0 record(s) unchanged ('Update data' step)
writer1;1/1 record(s) processed (step 'Update data')
writer1;: Insertion of 0 record(s) ('Update data' step)
writer1;: updating 1 record(s) ('Update data' step)
writer1;: 0 record(s) unchanged ('Update data' step)
writer1;1/1 record(s) processed (step 'Update data')
writer1;: Insertion of 0 record(s) ('Update data' step)
writer1;: updating 1 record(s) ('Update data' step)
writer1;: 0 record(s) unchanged ('Update data' step)
writer1;1/1 record(s) processed (step 'Update data')
writer1;: Insertion of 0 record(s) ('Update data' step)
writer1;: updating 1 record(s) ('Update data' step)
writer1;: 0 record(s) unchanged ('Update data' step)
fileImport2;1 records(s) loaded from the file '/usr/local/neolane/nl7/var/acs304_mkt_dev1/workflow/wf-WKF5/fileTransfer2/profiles_1_20191217205838a.csv' (step 'Load file 2' - 0 ignored)
fileImport2;Start loading file '/usr/local/neolane/nl7/var/acs304_mkt_dev1/workflow/wf-WKF5/fileTransfer2/profiles_1_20191217205838a.csv' into the database (step 'Load file 2')
fileImport2;1 records(s) loaded from the file '/usr/local/neolane/nl7/var/acs304_mkt_dev1/workflow/wf-WKF5/fileTransfer2/profiles_2_20191217205837a.csv' (step 'Load file 2' - 0 ignored)
fileImport2;Start loading file '/usr/local/neolane/nl7/var/acs304_mkt_dev1/workflow/wf-WKF5/fileTransfer2/profiles_2_20191217205837a.csv' into the database (step 'Load file 2')
fileImport2;1 records(s) loaded from the file '/usr/local/neolane/nl7/var/acs304_mkt_dev1/workflow/wf-WKF5/fileTransfer2/profiles_3_20191217205836a.csv' (step 'Load file 2' - 0 ignored)
fileImport2;Start loading file '/usr/local/neolane/nl7/var/acs304_mkt_dev1/workflow/wf-WKF5/fileTransfer2/profiles_3_20191217205836a.csv' into the database (step 'Load file 2')
fileImport2;1 records(s) loaded from the file '/usr/local/neolane/nl7/var/acs304_mkt_dev1/workflow/wf-WKF5/fileTransfer2/profiles_4_20191217205836a.csv' (step 'Load file 2' - 0 ignored)
fileImport2;Start loading file '/usr/local/neolane/nl7/var/acs304_mkt_dev1/workflow/wf-WKF5/fileTransfer2/profiles_4_20191217205836a.csv' into the database (step 'Load file 2')
fileTransfer2;Starting transfer of 'sftp://ftp.omniture.com/~/testfiles/profiles_1.csv' to 'profiles_1_20191217205838a.csv'
fileTransfer2;Starting transfer of 'sftp://ftp.omniture.com/~/testfiles/profiles_2.csv' to 'profiles_2_20191217205837a.csv'
fileTransfer2;Starting transfer of 'sftp://ftp.omniture.com/~/testfiles/profiles_3.csv' to 'profiles_3_20191217205836a.csv'
fileTransfer2;Starting transfer of 'sftp://ftp.omniture.com/~/testfiles/profiles_4.csv' to 'profiles_4_20191217205836a.csv'
fileTransfer2;4 file(s) to transfer
fileTransfer2;Starting file listing 'sftp://ftp.omniture.com/testfiles/profiles_*