Sftp File Transfer - WildCard

Hi Gaetano,

I think that in that case the wildcard only works if used as last character. So something like \Campaign\files\test_*

Florent

Hi Florent,

Can you tell me what Adobe Campaign does in the event there are 2 files that meet the filename/wild card criteria?

Seems to just pick one file when I've run a simple test?

Is that correct? And if so, how does it decide which one to download?

Is there a way to make it download all files and then load all records across all files that met the criteria using a subsequent data loading activity.

Thanks

David

Hi David,

I believe that it should trigger the event as many times as there is a matching file. So in your case, all activities should be executed twice. But I'm not sure if there's anything visible in the UI to confirm that, besides checking the execution logs of the workflow.

Florent

Hi florentlb​

I agree, I feel like thats what it should do (and what I'd like it to do) but as mentioned, when running a simple test - it only seems to download a single file (and i have no idea how it decides which one to process).

Any chance you could look into this a little further? I'd love a solution where a wildcard downloads all files that meet the condition.

Finally, is there anyway around the wildcard only working at the end of the filename? I have a situation where I really need it to work at the start (a regular file is coming from a client where the prefix of the file is an unknown date/time stamp but the end of the filename is a known constant).

Thanks for your help.

David

Hi,

Were you able to find something relevant for your query here?

Gaurang

Hi gaetanog59246633

Unfortunately not.

Is there any additional insight you can offer? Have you tested a similar situation yourself?

Thanks

David

Hi Gaurang,

I meant to message you.

I've not been able to find a way of using the wildcard to download multiple files from SFTP.

Is there any additional insight you can offer? Have you tested a similar situation yourself?

Thanks

David

Hi Gaetano,

Apologies, I didn't mean to message you.

Thats great that you found a resolution to your original problem by using the wildcard at the end.

What I'm keen to understand is, in the event 2 (or more) files meet the filename convention when a wildcard is used - get it to load the data of all files.

From basic testing, it only seems to load the data of one (and i'm not sure which).

I've asked Guarang above for more insight. Will be interesting/useful to know.

Thanks

David

Hi Gaetano,

Wildcard symbols are built into ACS. So just leave the appended file name blank:

File transfer:

\Campaign\files\test_

Will Return

\Campaign\files\test_20200105.csv