File collector activity alternative in ACS

Description

As we do not have the File collector activity in ACS, you can build it using the following activities and you will get more or less same functionality

Resolution

The File collector 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 settings, as you know it from 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_\*

On this page