Import files from amazon S3 | Community
Skip to main content
E
EtienneRo
August 4, 2022
Solved

Import files from amazon S3

  • August 4, 2022
  • 2 replies
  • 2102 views

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 ?

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 JohnWi12

DEF_nomprogramme

 

Change it to that.  That will work for transfers.

2 replies

J
JohnWi12
Level 5
August 4, 2022

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

 

John

E
EtienneRoAuthor
August 5, 2022

Hello John,

 

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

Thanks

J
JohnWi12Accepted solution
Level 5
August 5, 2022

DEF_nomprogramme

 

Change it to that.  That will work for transfers.

    H
    HugoTh
    March 8, 2023

    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 🙂 

    Terms & ConditionsAccessibility statement

    Loading footer...