Seeburger SFTP Sender File Pickup - Based on Date in File Name

[former_member187739]

Hello Experts,

We have a requirement, where we need to pick up files from a folder based on CurrentDate and Counter in the file name.

We are using SEEURGER SENDER SFTP Adapter to pick the files.

The folder will have many files, but we need to pickup only Today's files. Each day there can be more than 1 file.

Filename will be of the below format.

Test_(YYMMDD)(Counter)_File.txt

EX: Test_13020601_File.txt

      Test_13020602_File.txt

Where 13020601 = CurrentDate

           01, 02     = Counter

Is there an expression that we can give in the Seeburger Sender Filename parameter like Test_%CurrentDate%%Counter%_File.txt?????

Please help me on this issue!!!

Thanks,

Chan

[S0003485845 · Accepted solution]

Hello,

to pick up the files based on this criteria is not possible. The SFTP-Adapter doesn´t support such a specific naming.

One idea would be to use the "Pre-Execution-Script", which is available in version 2.2 to move certain data into a seperate directory which is then polled by the adapter, so that you then would not have to worry about the naming but could be sure that during the polling process only the correct data is in the specified directory

[former_member187739 · Accepted solution]

Thanks Stefan for your reply.

Since we dont have an option, we are going to develop a Custom Adapter module to solve this issue.