Can We just add date instead of complete time-stamp in SFTP receiver adapter? also how to retain source file extension?

[Former Member]

Dear All,

I have a bypass(without ESR) file to SFTP scenario to transfer the employee data(in CSV) to Successfactors SFTP folder. everything is working fine and file is transferring to SuccessFactors, however there are few specific requirements for file name, to avoid the time segment in the file name instead just date should be appended at the end of file name.

for example the file name in Successfators SFTP folder should be "TEST_EMP_yymmdd.csv", I have used ASMA in sender file adapter and receiver SFTP adapter to achieve this requirement. However, after placing the file in Successfactor SFTP folder file name is coming

as "TEST_EMP_20141016-075025-488 " which is adding the time at which the file placed and also without the source file type(.CSV) extension, file type is CSV only but its not appearing as extension,But my requirement is to remove the time and just retain the date and source file type(.CSV) extension.

Please see the below sender and receiver adapter configuration and suggest me if we can achieve this requirement.

Sender file adapter configuration

ASMA configration

Receiver SFTP adapter configuration

SFTP ASMA

Thanks,

Farhan

[former_member462539]

How did you resolve this glitch in your case? We have the same situation in our case, looking forward for s solution.

[javier_alcubilla]

Hi Farhan

SFTP uses regular expressions for filenames, but i don't know if it runs in receiver adapter, i only used regular expressions in sender adapters

On the other hand you can create an adapter module to modify your filename

Developing Adapters and Modules - SAP Library

Custom Adapter Module Development - SAP PI 7.1 - Netweaver Technology - SCN Wiki

Regards

Javi

[engswee]

Creating a custom adapter module for such a scenario seems to be an overkill. Unless the module is written in a very flexible/configurable manner that allows it to be reused in future scenarios, then that might be worth the effort.

Since this cannot be achieved with ASMA, and development is required, why not go back to the old fashion way of ESR based scenario with a UDF in Message Mapping to set the filename.

Rgds

Eng Swee

[iaki_vila]

Hi Farhan,

With no ESR development you can not use the ASMA and the dynamic configuration to change the format. As far as I know the only way that you can do it is with shell script in the sender file adapter and to have the name modified there before to pick it.

To implement  a module bean for this could be difficult, at least for me .

Regards.