Skip to Content
avatar image
Former Member

File to File & Idoc through a single interface in PI 7.3

Hello,

Please suggest whether the following sceanrio is possible in PI 7.3.........If so, please provide the solution in detail........

I have a scenario where i'm pulling a comma seperated file from FTP server. The file has records with last line as footer. The footer is the count of no. of records present in the file. The file structure is as below :

11,23,ABC,990

21,34,XYZ,288

44,83,PQR,833

3,,,,

I have to validate this file whether the no. of records and the footer is same. That means, in the above mentioned file structure i have 3 records and the footer is 3.

Now if the count matches, i have to pass the records to target structure to generate IDOC ignoring the footer(since there will be no IDOC generation for footer data) and if the count does not match, i have to write the specific error message in a file and send back to FTP server via File adapter.

Can i confige it through PI 7.3 through a single interface where the source adapter is file and receiver adapters are file and Idoc?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 09, 2013 at 10:43 AM

    Hello,

    I think using multimapping you can achieve your scenario.

    Convert entire text into XML file and then validate the count of records at mapping level....If in case validation is successful thenĀ  create idoc and if not then create text file with ur custom message .

    Note: You have to use java idoc adapter

    Thanks

    Amit Srivastava

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 09, 2013 at 11:45 AM

    Hi Ashmitha,

    You would be able to achieve it in a single interface with multimappin as amit suggested. also other alternative is building the logic in mapping and write the condetion in Receiver determination.

    if the satisfies count send it to IDOC channel else send it to file channel.

    Also you need to keep in mind that you can handle the custom message also in mapping.

    Thanks and Regards,

    Naveen

    Add comment
    10|10000 characters needed characters exceeded