Parsing XML fil med namespaces (med OPENXML, sp_xml_preparedocument eller lign.)
Jeg forsøger at indlæsee en XML med namespaces, men kan ikke få det til at fungere.Filen ser således ud (forkortet):
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<CreateSalesOrderAction xmlns="urn:Namespaces.AssaAbloy.Com:Cmf:Action:OrderManagement:IniCreateSalesOrderAction:0001" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:stdTypes="urn:Namespaces.AssaAbloy.Com:Cmf:StdTypes:0001" xmlns:info="urn:Namespaces.AssaAbloy.Com:Cmf:InfoModel:OrderManagement:IniSalesOrderObject:0001">
<DocStatus Version="1"/>
<SalesOrderInfo>
<info:InfoStatus Version="1"/>
<info:QuoteFlag>PROJ1</info:QuoteFlag>
<info:OrderHeader>
<info:OrderReferenceNo>
<stdTypes:IdentityItem IdType="evAnySystem">154006</stdTypes:IdentityItem>
</info:OrderReferenceNo>
</info:OrderHeader>
<info:CustomerInfo>
<info:CustomerId>
<stdTypes:IdentityItem IdType="evErpAny">301254</stdTypes:IdentityItem>
</info:CustomerId>
<info:BillTo>
<stdTypes:Name1/>
<stdTypes:ReferenceId IdType="evErpAny">301254</stdTypes:ReferenceId>
<stdTypes:ListOfAddressLines>
<stdTypes:AddressLine>Vesterlundvej 20</stdTypes:AddressLine>
</stdTypes:ListOfAddressLines>
<stdTypes:CompanyName>Låsepartner København-301254</stdTypes:CompanyName>
</info:BillTo>
</info:CustomerInfo>
<info:OrderDetails>
<info:ListOfOrderLines>
<info:OrderLine>
<info:ArticleNo>
<stdTypes:IdentityItem IdType="evErpAny">951111</stdTypes:IdentityItem>
</info:ArticleNo>
<info:LineHeader>
<info:OtherLineNo>
<stdTypes:IdentityItem IdType="evOther">795007</stdTypes:IdentityItem>
</info:OtherLineNo>
<info:LineName>951111</info:LineName>
<info:Sequence>795007</info:Sequence>
</info:LineHeader>
</info:OrderLine>
</info:ListOfOrderLines>
</info:OrderDetails>
<info:OrderSummary>
<info:OrderTotal>
<stdTypes:MonetaryAmount>270.25</stdTypes:MonetaryAmount>
</info:OrderTotal>
</info:OrderSummary>
</SalesOrderInfo>
</CreateSalesOrderAction>