Load An XML in sbo, and SQL Server

[Former Member]

Hi I have created an XML that correspond to a sales Order, I want to load this sales Order in my Sap Business One, and to introduce the data in the tables ORDR, RDR1, is there a way to load the XML in my sistem and generate a sales order in my Sap??.

Thanks and sorry for my English

[Former Member]

Hi,

you should probably load your sales order xml in an application and then use the DIApi to create a sales order. SAP will store the sales order in sql server then.

HTH Lutz Morrien

[Former Member]

Hi again:

I have found the following method to read the data form an XMl:

Private Sub XMLRead(oCompany As SAPbobsCOM.Company, vBP As SAPbobsCOM.Documents)

Dim FileName As String

Dim Ecount As Long

Dim ii As Long

FileName = "C:\Archivos de programa\SAP Manage\XML\Order1.Xml"

'Get the number of Business object in the file ...

Ecount = oCompany.GetXMLelementCount(FileName)

'Loop threw the objects and when finding the first

'BusinessPartner object , load it and stop.

For ii = 0 To Ecount - 1

If oCompany.GetXMLobjectType(FileName, ii) = oOrders Then

'Read the Business object data

Set vBP = vCmp.GetBusinessObjectFromXML(FileName, ii)

Exit For

End If

Next ii

End Sub

My cuestion is, how to set the data after reading the XMl in SBO.

Thank's