Multiple file processing in ACS | Community
Skip to main content
V
vikashg34827223
Level 2
December 4, 2019
Solved

Multiple file processing in ACS

  • December 4, 2019
  • 4 replies
  • 8728 views

Hi,

We have a scenario where we get multiple files as input at a SFTP server and we need to read all those files and send emails. We tried to use Transfer File activity, it could read all the files but while processing the data in further activities only the last file record are considered.

The file nomenclature is Marketinglist_<n>.csv where n is an integer.

so lets say we have files marketinglist_1.csv, marketinglist_2.csv so on. Each file may have varied number of records. we can to send email to each of these records.How can we achieve that?

any help will be appreciated.

Thanks!!

Vikash

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jyoti_Yadav

Hi,

You can select the option to generate an outbound transition in case no file is present. And loop your update activity back to 'Transfer file' activity. It will loop and perform operation until there are files present in your SFTP location.

Thanks.

4 replies

chan2111
chan2111
Level 4
December 4, 2019

HI Vikash,

In your transfer file activity when you give the file path for download are you giving as Marketing* to load all the files and process them. Ideally it should process all the files.

Thanks,

cl

V
vikashg34827223Author
Level 2
December 5, 2019

Hi Cl,

yes I am giving marketing* and it downloads all the files as I can see in the logs. but when we pass it through other activities like load file, enrichment etc. only one file records are processed.

Thanks!!

Vikash

A
aveggiani
Level 3
June 19, 2020
I have the same problem, how did you fix this issue?
Jyoti_Yadav
Jyoti_YadavAccepted solution
Level 8
December 6, 2019

Hi,

You can select the option to generate an outbound transition in case no file is present. And loop your update activity back to 'Transfer file' activity. It will loop and perform operation until there are files present in your SFTP location.

Thanks.

    V
    vikashg34827223Author
    Level 2
    December 6, 2019

    Thanks Jyoti!! It worked!!

    rajdeepk7439790
    rajdeepk7439790
    Level 2
    December 18, 2019
    Hi, We have also same requirement to upload multiple files from ftp server and sends an email without storing the records in table. we noticed that delivery is considering records only from the last file. Any help how you have managed this would be greatly appreciated. thank you in advance!!
    Terms & ConditionsAccessibility statement

    Loading footer...