how to read multiple files using SAP SFTP adapter

[Former Member]

Hi Folks,

In our company we are trying to migrate few of the file based interface from ADVANTCO adapter to SAP SFTP adapter. In one of our scenario(FILE-PROXY) we have an requirement to pick multiple files from different directories. does this possible using SAP SFTP adapter because the "Advanced selection for source file" option is not present in SAP SFTP.

Could you please give your suggestion how we can do this using SAP SFTP adapter?

appreciate for quick response.

Thanks in advance.

[mike_sibler]

Hello Anjani,

based on recent information I got from SAP development this feature will be available with SP3 of the B2B Addon which should be shipped in the next weeks.

Regards,

Mike

[Former Member]

Hi Sen/Praveen,

It is just the business requirement that PI has to pick these multiple files based on the corresponding trigger files.  It is the same file schema that is used for all 4 files.

the actual requirement is that there are 2 different servers XXX and YYY.

PI has to pick file1.csv based on the trigger file file1.xml from XXX server and then PI has to pick file2.csv, file3.csv, and file4.csv based on trigger files file2.xml, file3.xml and file4.xml from YYY server.

we are using 2 SAP SFTP sender channels to pick from 2 different servers. but how does SAP SFTP adapter supports to pick trigger based selection and the multiple files.

since SAP SFTP had no option of "Advanced selection for source file" is there any workaround that can be done.

appreciate for quick response.

Thanks in advance.

[Former Member]

Hi,

Any update..

Thanks

Anjani

[former_member181985]

Hi,

sorry I am late. I think without a BPM (with external channel control for trigger files) your requirement is not possible. One question, do you merge all the four files for target system?

How many transactions in a day?

Regards,

Praveen Gujjeti

[Former Member]

Hi,

PI is able to pick all the csv files based on trigger files using "Additional Files" option in the SAP SFTP sender cc. but again the problem here is the except for the main file ,all the additional files which have been mentioned in File List are transported unchanged without conversion options.

Here the additional files are getting included in the XI message as attachments. how do i retreive those attached files to do the content conversion.

appreciate for quick response.

Thanks in advance.

[nabendu_sen]

Hi Anjani,

You can use PayloadSwapBean at sender side, but it will help to make one attachment to payload.

Please find the below blog:

http://scn.sap.com/people/gaurav.agarwal11/blog/2012/04/12/handling-attachments-in-mail-to-file-scen...

Otherwise you have to go for Custom Adapter. Please find the below:

http://scn.sap.com/people/yugapreetha.t/blog/2009/08/24/read-the-attachments-of-the-input-xi-message...

[former_member181985]

Hi,

Any business reason to pick multiple files together? Do the file schemas are same or different.

If any correlation between files, you should use BPM concept in XI to achieve the requirement.

Regards,

Praveen

[Former Member]

Hi Praveen,

All together need to pick 3 files from 3 different directories and all the 3 file schemas are same.

do we need to use any modules in SAP SFTP adapter to achieve this.

Thanks

Anjani

[nabendu_sen]

Hi Anjani,

SAP SFTP adapter does not have the capability to pick multiple files in a single polling from different locations. Please check the below thread:

http://scn.sap.com/thread/3209618

If you can provide some detail about your requirement (means why its needed to pick up multiple files), may be someone can help you.