file adapter

[Former Member]

Hi,

1. I want to send only 8 records out of 10 records present in the sender file. For this to achieve how to configure sender file adapter?

2. In another scenario out of the 10 records present in the sender file i want to send from 5th to 10 th record to the receiver system. In this case how to configure the sender file adater?

Please help me with the answers.

Regards,

Suresh.

[sunil_singh13]

Hi Suresh,

Well i think this problem can be solved using mapping also

you can filter out the records based on some condition that u would be having and creat the file with only required records in it.

other way is to use X path.

Reward points if helpfu

thanks

Sunil Singh

[Former Member]

Hi Suresh,

For question 2 you can set the parameter "document offset" with value 4.

This way the adapter ignores the first 4 lines in the file.

Kind regards

Robert

[Former Member]

Hi,

try to provide one key field in file and use that key field in Xpath for providing the condition.Based on condition u provided in Xpath records will select.

[Former Member]

Hi,

Direactly with the file adapter it will not be possible to select the particular lines from Sender File.

(you may achieve with kind of customized adapter module development)

But there is one way that could resolve your purpose.

for e.g. You could DB lookup as to get all teh lines from file in to the database table in XI and then select the particular rows from database and process ahead on receiver side.

Here you need to delete the entries in the Database table after processing of each instance.

refer

access db via db api in the message mapping:

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

/people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

Thanks

Swarup