Import files from amazon S3

[etienneroux]

Hello,

We have implemented the import and transfer of files from an amazon S3 bucket. Everything is working.

However, these files do not always have a common ending but the beginning does.

For example: TEST_FILES_DD_MM_YYYY

The * or % character after "TEST_FILES" does not work. Can you help me please ?

[johnwwilcoxmba]

For the transfers using nothing after the end of the file like adobeftp/TEST_FILES   and don't end with a underscore _

John

[etienneroux]

Hello John,

I don't understand your answer. Here a screenshot of my end.

Thanks

[johnwwilcoxmba · Accepted solution]

DEF_nomprogramme

Change it to that.  That will work for transfers.

[etienneroux]

Yes it works, thanks 🙂

[HugoThomas]

Hello,

I hope you are well 🙂 

Thanks for this method with ACS
I have the same question for ACC with an S3 bucket

this is working
incoming/IN/myfile_<%= formatDate(new Date(), "%4Y-%2M-%2DT%02H") %>:00:00+00:00.csv

but I would like to know how to retrieve all files from the date (or one by one in the right order according to the hour from the flat file name)

however as etienneroux i can not use the * character with S3

incoming/IN/myfile_<%= formatDate(new Date(), "%4Y-%2M-%2DT") %>*.csv

to retrieve :
myfile_2023-01-01T00:00:00+00:00.csv
myfile_2023-01-01T01:00:00+00:00.csv
myfile_2023-01-01T02:00:00+00:00.csv
....
myfile_2023-01-01T22:00:00+00:00.csv
myfile_2023-01-01T23:00:00+00:00.csv

Thanks in advance 🙂 

I will be very helpful when we have some backfill to do 🙂