Skip to Content
0
Nov 16, 2020 at 02:49 AM

Dynamic filename for file to file interface - No ESR involved

51 Views

Hi

Scenario:

2 Interfaces for file transfer to SFTP

1) File to File - merge multiple file entries and append in one file with append parameter in File construction mode. As we are adding append parameter, we cant add timestamp to it. So the filename i entered in filename schema as "ISR_BUNDLE_SALES.csv"...

2) pick ISR_BUNDLE_SALES.csv (archive it with adding timestamp), and send it SFTP by adding timestamp in receiver SFTP channel.

There is a time variation in archiving and in sending the file in receiver SFTP...

Functional team requirement is filename that is sent to SFTP and archived filename should be same.

Eg:

20201114-113754-731_ISR_BUNDLE_SALES.csv - archive filename

ISR_BUNDLE_SALES_20201114-113754-956.csv - SFTP filename sent

I need both same. For that, in the first interface itself i have to generate filename with timestamp.

Let me how its possible with below methods:

1) Adding module in receiver File channel to append timestamp in filename "ISR_BUNDLE_SALES_*.csv"

2) Java mapping

I DONT PREFER ADDING OS COMMANDIN THE FILERECEIVER CHANNEL ,as it is unstable.Ifforsome reason 
command didn't execute,thenall files will fail.