Expand my Community achievements bar.

SOLVED

Import files from amazon S3

Avatar

Level 1

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 ?

1 Accepted Solution

Avatar

Correct answer by
Level 6

DEF_nomprogramme

 

Change it to that.  That will work for transfers.

View solution in original post

5 Replies

Avatar

Level 6

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

 

John

Avatar

Level 1

Hello John,

 

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

ThanksCapture.PNG

Avatar

Correct answer by
Level 6

DEF_nomprogramme

 

Change it to that.  That will work for transfers.

Avatar

Level 1

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