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='S']/BOM/BO/Documents/row/CardCode"></xsl:value-of>
</col>
<col>
<xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/BOM/BO/Documents/row/CardName"></xsl:value-of>
</col>
<col>
<xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/BOM/BO/Documents/row/DocTotal"></xsl:value-of>
</col>
<col>
<xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/BOM/BO/Documents/row/DocDueDate"></xsl:value-of>
</col>
<col>
<xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/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)....
