Transfer Sale order Record to flat file using Integration Framework

Dear All,
    Today ,we will discuss how to Transfer Sale order Record to flat file using Integration Framework.


Scenario : Transfer Sale order Record to flat file
The following record fetched from Sale Order

1)Card Code 2) Card Name 3) Doc Total 4) Doc Currency 5) DocDate 6) DocNum

Step by Step Procedure to Transfer record from SAP Business One to File Format

1) Create Scenario Package
2) Create Scenario Steps
              2.1   Inbound
              2.2   Outbound
              2.3   Processing
3) Create System
4) Test


1) Create Scenrio Package
    Go To Scenario Tab
    Click "Package Design"
    Click  "+" button for Create Scenario Package.
    Enter  Package Name on Scenario package Idetifier.
    Select "No Authentication" Authentication Browse Button.
    Click "Save"icon.
2) Create Scenario Steps
   Go To Scenario Tab
   Click "Scenario Package Design"
    Click  "+" button for Create Scenario Steps.
    Enter  Steps Name on Scenario steps Idetifier.
    Assign Scenario Package in Scenario Package Identifier.
    Click "Save"icon.

 2.1 Create Inbound
    Click "Inbound" Button.
      2.1.1) Create Channel
    Click "Channel" Button.
        Select Inbound Type "SAP Business One"
        Select Process Mode "Asynchronous"
        Select Process Trigger "B1Event"
        Select Identification Method "B1Event"
        Enter Identification Paramter :n.a
        Select Identifier  (In Our case  Select "17")
        Click "Save"icon.
        Click "Close" button.
      2.1.2) Create Retrieval
                  Click "Retrieval" Button.
                        Select "DI API" in Retrieval Adapter.
                        Select "Object" in Retrieval Type.
                        Click "Save"icon.
                Click "Close" button.

  2.2) Outbound
             Click "Outbound" Button.
             Select  "FlatFile" in Outbound Channel.
             Select "file" in Outbound Format.
             Click "Details" button
                  Select Scenario Step identifier
                  Select "dsv" Output Format.
                  Select "Write" in Mode.
                  Select "ISO-8859-1" in Character Encoding (if you want you can change it based on your requirement)
                   Click "Save"icon.
           Click "Close" button.
             Click "Save"icon.
         Click "Close" button. 
  2.3) Processing
             If you have any issue when you press "Processing" button,You can follow below step(s).
                Click "Control" on the Scenarios Page.
                Find your "Package Name"
                Click "Overview" Button.
                you see Integration Framework - Scanrio Overview Screen.
                Click/Double Click "Final Processing step"
                 you see the BixFlow Screen.
                 Click "Final" icon
                 you see "Integration Framework - XML Editor"
                 Paste below XSLT Code under transform tag
                          <Fileout type="file">
<row>
<col>
<xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role=&apos;S&apos;]/BOM/BO/Documents/row/CardCode"></xsl:value-of>
</col>
<col>
<xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role=&apos;S&apos;]/BOM/BO/Documents/row/CardName"></xsl:value-of>
</col>
<col>
<xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role=&apos;S&apos;]/BOM/BO/Documents/row/DocTotal"></xsl:value-of>
</col>
<col>
<xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role=&apos;S&apos;]/BOM/BO/Documents/row/DocDueDate"></xsl:value-of>
</col>
<col>
<xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role=&apos;S&apos;]/BOM/BO/Documents/row/DocNum"></xsl:value-of>
</col>

</row>
</Fileout>
                 Click "Save"icon.

3) Create System
      Go To SLD Tab
      Click "Create System"
      Select "F:AnySystem" on the Type
      Enter Name of the System.
      Select "Id" on the ID .
      Enter "output Path" in filePattern FILO
       Eg: D:\SAPB1if\data????.xml
                Do not remove this "\data????.xml" content on the Input Box.
       Click "Test Connection" button.
       Connect to <Name>(FILO) successfully.
       
         Click "Save"icon.       


4) Test
    Open SAP Business One
    Add Sale Order Document
    Go and Check Output Path Folder.
    XML File will created.like this (data0000 and so on)....