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.
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_*