1 Reply Latest reply: Jan 10, 2012 3:53 AM by 860425 RSS

    Configuring File adapter for OSB

    707257
      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
          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