Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 16, 2014 at 08:20 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2014 at 08:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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