This discussion is archived
1 Reply Latest reply: Jan 10, 2012 1:53 AM by 860425 RSS

Configuring File adapter for OSB

707257 Newbie
Currently Being Moderated
Hi,

I wish to process invoice data that will be in the csv file . The structure of the file is as following :

$H$<<Supplier Name>>,<<Supplier Site>>,<<Invoice Number>>
$D$<<Line Number>> ,<<Business Unit>>,<<Location>>,<<Store Name>>
$D$<<Line Number>> ,<<Business Unit>>,<<Location>>,<<Store Name>>
$H$<<Supplier Name>>,<<Supplier Site>>,<<Invoice Number>>
$D$<<Line Number>> ,<<Business Unit>>,<<Location>>,<<Store Name>>
$D$<<Line Number>> ,<<Business Unit>>,<<Location>>,<<Store Name>>

The intent is to configure the file adapter in such a fashion that it rejects the entire invoice if there are any errors in any of the lines that belong to that invoice. The invoices that follow the erred inovice should be processed normally. How do I configure the adapter to achieve this? Any help is greatly appreciated.
  • 1. Re: Configuring File adapter for OSB
    860425 Newbie
    Currently Being Moderated
    Hi,

    Configuring the adapter for rejecting the invalid invoice rows is not possible. Adapter should be configured as usual to read all the rows. Once the rows are read, you can have all validation in the proxy service. If you find any invalid rows, you can write those rows to a saperate file so that it can be corrected and fed again. And all the other valid rows can be sent for further processing.

    Thanks,
    Vishwa

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points