Need help with creating XMLPort for Invoice Import

navimbs · 2008-05-28

How do i create an XMLPort to import an invoice from following XML File?

<?xml version="1.0" encoding="utf-8"?>
<Invoice>
<ID>8007121</ID>
<IssueDate>03-19-2007</IssueDate>
<InvoiceTypeCode>CreditNote</InvoiceTypeCode>
<DocumentCurrencyCode>EUR</DocumentCurrencyCode>
<BuyerCustomerParty>
<Party>
<PartyIdentification>
<ID>
</ID>
</PartyIdentification>
<PartyName>
<Name>Vila Leidschendam</Name>
</PartyName>
<PostalAddress>
<Postbox>2262 AC</Postbox>
<StreetName>Liguster 38-40 </StreetName>
<CityName>Leidschendam</CityName>
<PostalZone>2262 AC</PostalZone>
<Country />
</PostalAddress>
<PartyTaxScheme />
<Contact />
<Person>
<FirstName>NL012</FirstName>
</Person>
</Party>
</BuyerCustomerParty>
<SellerSupplierParty>
<Party>
<PartyIdentification>
<ID>5704027000016</ID>
</PartyIdentification>
<PartyName>
<Name>VILA BENELUX BV</Name>
</PartyName>
<PostalAddress>
<Postbox>3817 CG</Postbox>
<StreetName>Arnhemseweg 213-2</StreetName>
<CityName>Amersfoort</CityName>
<PostalZone>3817 CG</PostalZone>
<Country />
</PostalAddress>
<PartyTaxScheme />
<Contact />
<Person>
<FirstName>VI-NL040</FirstName>
</Person>
</Party>
</SellerSupplierParty>
<Delivery>
<DeliveryParty>
<PartyIdentification />
<PartyName>
<Name>Vila Leidschendam</Name>
</PartyName>
<PostalAddress>
<Postbox>2262 AC</Postbox>
<StreetName>Liguster 38-40, </StreetName>
<CityName>Leidschendam</CityName>
<PostalZone>2262 AC</PostalZone>
<Country>
<IdentificationCode>3</IdentificationCode>
</Country>
</PostalAddress>
<PartyTaxScheme />
<Contact />
<Person>
<FirstName />
</Person>
</DeliveryParty>
</Delivery>
<DeliveryTerms>
<AllowanceCharge>
<ChargeIndicator>true</ChargeIndicator>
<Amount currencyID="EUR">0</Amount>
</AllowanceCharge>
</DeliveryTerms>
<PaymentTerms>
<SettlementPeriod>
<EndDate>2007-04-18</EndDate>
</SettlementPeriod>
</PaymentTerms>
<TaxTotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
<TaxSubtotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
<TaxCategory>
<ID>Standard</ID>
<TaxScheme>
<ID>VAT</ID>
</TaxScheme>
</TaxCategory>
</TaxSubtotal>
</TaxTotal>
<LegalMonetaryTotal>
<LineExtensionAmount currencyID="EUR">-3270.04</LineExtensionAmount>
<TaxExclusiveAmount currencyID="EUR">-3270.04</TaxExclusiveAmount>
<TaxInclusiveAmount>-3891.34</TaxInclusiveAmount>
</LegalMonetaryTotal>
<InvoiceLine>
<ID>182127838</ID>
<InvoicedQuantity>-30</InvoicedQuantity>
<LineExtensionAmount currencyID="EUR">-369.07</LineExtensionAmount>
<OrderLineReference>
<LineID>1</LineID>
<OrderReference>
<ID>R4-8397</ID>
</OrderReference>
</OrderLineReference>
<DespatchLineReference>
<LineID>1</LineID>
<DocumentReference>
<ID>0</ID>
<DocumentType>DeliveryNote</DocumentType>
</DocumentReference>
</DespatchLineReference>
<AllowanceCharge>
<ChargeIndicator>false</ChargeIndicator>
<Amount currencyID="EUR">-19.5</Amount>
</AllowanceCharge>
<TaxTotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
</TaxTotal>
<Item>
<Description>SONDRINE O-NECK X·</Description>
<BrandName>VILA</BrandName>
<SellersItemIdentification>
<ID>467863</ID>
</SellersItemIdentification>
<StandardItemIdentification>
<ID>5704027800609</ID>
<MeasurementDimension>
<AttributeID>NetWeight</AttributeID>
<Measure>.322</Measure>
</MeasurementDimension>
<MeasurementDimension>
<AttributeID>GrossWeight</AttributeID>
<Measure>.378</Measure>
</MeasurementDimension>
</StandardItemIdentification>
<OriginCountry>
<Name>CHINA</Name>
</OriginCountry>
<AdditionalItemProperty>
<Name>GrossPrice</Name>
<Value>12.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>NetPrice</Name>
<Value>12.3</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>RetailPrice</Name>
<Value>34.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>FabricComposition</Name>
<Value>SHIRT WITH RIB</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
<AdditionalItemProperty>
<Name>AccountNumber</Name>
<Value>10200</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
</Item>
<Price>
<PriceAmount currencyID="EUR">-388.49</PriceAmount>
<PriceType>LineGoodsItemAmount</PriceType>
</Price>EUR</InvoiceLine>
<InvoiceLine>
<ID>182127839</ID>
<InvoicedQuantity>-33</InvoicedQuantity>
<LineExtensionAmount currencyID="EUR">-405.98</LineExtensionAmount>
<OrderLineReference>
<LineID>1</LineID>
<OrderReference>
<ID>R4-8397</ID>
</OrderReference>
</OrderLineReference>
<DespatchLineReference>
<LineID>1</LineID>
<DocumentReference>
<ID>0</ID>
<DocumentType>DeliveryNote</DocumentType>
</DocumentReference>
</DespatchLineReference>
<AllowanceCharge>
<ChargeIndicator>false</ChargeIndicator>
<Amount currencyID="EUR">-21.45</Amount>
</AllowanceCharge>
<TaxTotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
</TaxTotal>
<Item>
<Description>SONDRINE ROLLNECK X·</Description>
<BrandName>VILA</BrandName>
<SellersItemIdentification>
<ID>467867</ID>
</SellersItemIdentification>
<StandardItemIdentification>
<ID>5704027800647</ID>
<MeasurementDimension>
<AttributeID>NetWeight</AttributeID>
<Measure>.306</Measure>
</MeasurementDimension>
<MeasurementDimension>
<AttributeID>GrossWeight</AttributeID>
<Measure>.369</Measure>
</MeasurementDimension>
</StandardItemIdentification>
<OriginCountry>
<Name>CHINA</Name>
</OriginCountry>
<AdditionalItemProperty>
<Name>GrossPrice</Name>
<Value>12.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>NetPrice</Name>
<Value>12.3</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>RetailPrice</Name>
<Value>34.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>FabricComposition</Name>
<Value>PLAIN ROLLNECK WITH RIB</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
<AdditionalItemProperty>
<Name>AccountNumber</Name>
<Value>10200</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
</Item>
<Price>
<PriceAmount currencyID="EUR">-427.35</PriceAmount>
<PriceType>LineGoodsItemAmount</PriceType>
</Price>EUR</InvoiceLine>
<InvoiceLine>
<ID>182127842</ID>
<InvoicedQuantity>-26</InvoicedQuantity>
<LineExtensionAmount currencyID="EUR">-245.76</LineExtensionAmount>
<OrderLineReference>
<LineID>1</LineID>
<OrderReference>
<ID>R4-8397</ID>
</OrderReference>
</OrderLineReference>
<DespatchLineReference>
<LineID>1</LineID>
<DocumentReference>
<ID>0</ID>
<DocumentType>DeliveryNote</DocumentType>
</DocumentReference>
</DespatchLineReference>
<AllowanceCharge>
<ChargeIndicator>false</ChargeIndicator>
<Amount currencyID="EUR">-13</Amount>
</AllowanceCharge>
<TaxTotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
</TaxTotal>
<Item>
<Description>POLISH ROLLNECK A E·</Description>
<BrandName>VILA</BrandName>
<SellersItemIdentification>
<ID>469226</ID>
</SellersItemIdentification>
<StandardItemIdentification>
<ID>5704027911848</ID>
<MeasurementDimension>
<AttributeID>NetWeight</AttributeID>
<Measure>.33</Measure>
</MeasurementDimension>
<MeasurementDimension>
<AttributeID>GrossWeight</AttributeID>
<Measure>.39</Measure>
</MeasurementDimension>
</StandardItemIdentification>
<OriginCountry>
<Name>CHINA</Name>
</OriginCountry>
<AdditionalItemProperty>
<Name>GrossPrice</Name>
<Value>9.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>NetPrice</Name>
<Value>9.45</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>RetailPrice</Name>
<Value>26.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>FabricComposition</Name>
<Value>KNIT TOP W. LUREX</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
<AdditionalItemProperty>
<Name>AccountNumber</Name>
<Value>10200</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
</Item>
<Price>
<PriceAmount currencyID="EUR">-258.69</PriceAmount>
<PriceType>LineGoodsItemAmount</PriceType>
</Price>EUR</InvoiceLine>
<InvoiceLine>
<ID>182127840</ID>
<InvoicedQuantity>-6</InvoicedQuantity>
<LineExtensionAmount currencyID="EUR">-73.81</LineExtensionAmount>
<OrderLineReference>
<LineID>1</LineID>
<OrderReference>
<ID>R4-8397</ID>
</OrderReference>
</OrderLineReference>
<DespatchLineReference>
<LineID>1</LineID>
<DocumentReference>
<ID>0</ID>
<DocumentType>DeliveryNote</DocumentType>
</DocumentReference>
</DespatchLineReference>
<AllowanceCharge>
<ChargeIndicator>false</ChargeIndicator>
<Amount currencyID="EUR">-3.9</Amount>
</AllowanceCharge>
<TaxTotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
</TaxTotal>
<Item>
<Description>BARY SHIRT X/ LL·</Description>
<BrandName>VILA</BrandName>
<SellersItemIdentification>
<ID>468250</ID>
</SellersItemIdentification>
<StandardItemIdentification>
<ID>5704027859034</ID>
<MeasurementDimension>
<AttributeID>NetWeight</AttributeID>
<Measure>.178</Measure>
</MeasurementDimension>
<MeasurementDimension>
<AttributeID>GrossWeight</AttributeID>
<Measure>.211</Measure>
</MeasurementDimension>
</StandardItemIdentification>
<OriginCountry>
<Name>TURKEY</Name>
</OriginCountry>
<AdditionalItemProperty>
<Name>GrossPrice</Name>
<Value>12.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>NetPrice</Name>
<Value>12.3</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>RetailPrice</Name>
<Value>34.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>FabricComposition</Name>
<Value>SHIRT WITH LUREX STRIBE</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
<AdditionalItemProperty>
<Name>AccountNumber</Name>
<Value>10200</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
</Item>
<Price>
<PriceAmount currencyID="EUR">-77.69</PriceAmount>
<PriceType>LineGoodsItemAmount</PriceType>
</Price>EUR</InvoiceLine>
<InvoiceLine>
<ID>182127837</ID>
<InvoicedQuantity>-59</InvoicedQuantity>
<LineExtensionAmount currencyID="EUR">-165.35</LineExtensionAmount>
<OrderLineReference>
<LineID>1</LineID>
<OrderReference>
<ID>R4-8397</ID>
</OrderReference>
</OrderLineReference>
<DespatchLineReference>
<LineID>1</LineID>
<DocumentReference>
<ID>0</ID>
<DocumentType>DeliveryNote</DocumentType>
</DocumentReference>
</DespatchLineReference>
<AllowanceCharge>
<ChargeIndicator>false</ChargeIndicator>
<Amount currencyID="EUR">-8.85</Amount>
</AllowanceCharge>
<TaxTotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
</TaxTotal>
<Item>
<Description>PORCHE PRINT TOP BOX A·</Description>
<BrandName>VILA</BrandName>
<SellersItemIdentification>
<ID>462803</ID>
</SellersItemIdentification>
<StandardItemIdentification>
<ID>5704027339208</ID>
<MeasurementDimension>
<AttributeID>NetWeight</AttributeID>
<Measure>.09</Measure>
</MeasurementDimension>
<MeasurementDimension>
<AttributeID>GrossWeight</AttributeID>
<Measure>.106</Measure>
</MeasurementDimension>
</StandardItemIdentification>
<OriginCountry>
<Name>POLAND</Name>
</OriginCountry>
<AdditionalItemProperty>
<Name>GrossPrice</Name>
<Value>2.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>NetPrice</Name>
<Value>2.8</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>RetailPrice</Name>
<Value>7.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>FabricComposition</Name>
<Value>TOP BOX WITH MIX OFPORCHE PRINT TOP 1 AN</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
<AdditionalItemProperty>
<Name>AccountNumber</Name>
<Value>10200</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
</Item>
<Price>
<PriceAmount currencyID="EUR">-174.05</PriceAmount>
<PriceType>LineGoodsItemAmount</PriceType>
</Price>EUR</InvoiceLine>
<InvoiceLine>
<ID>182127841</ID>
<InvoicedQuantity>-29</InvoicedQuantity>
<LineExtensionAmount currencyID="EUR">-219.02</LineExtensionAmount>
<OrderLineReference>
<LineID>1</LineID>
<OrderReference>
<ID>R4-8397</ID>
</OrderReference>
</OrderLineReference>
<DespatchLineReference>
<LineID>1</LineID>
<DocumentReference>
<ID>0</ID>
<DocumentType>DeliveryNote</DocumentType>
</DocumentReference>
</DespatchLineReference>
<AllowanceCharge>
<ChargeIndicator>false</ChargeIndicator>
<Amount currencyID="EUR">-11.6</Amount>
</AllowanceCharge>
<TaxTotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
</TaxTotal>
<Item>
<Description>OPTION TOP U·</Description>
<BrandName>VILA</BrandName>
<SellersItemIdentification>
<ID>468720</ID>
</SellersItemIdentification>
<StandardItemIdentification>
<ID>5704027887211</ID>
<MeasurementDimension>
<AttributeID>NetWeight</AttributeID>
<Measure>.11</Measure>
</MeasurementDimension>
<MeasurementDimension>
<AttributeID>GrossWeight</AttributeID>
<Measure>.12</Measure>
</MeasurementDimension>
</StandardItemIdentification>
<OriginCountry>
<Name>LITHUANIA</Name>
</OriginCountry>
<AdditionalItemProperty>
<Name>GrossPrice</Name>
<Value>7.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>NetPrice</Name>
<Value>7.55</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>RetailPrice</Name>
<Value>21.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>FabricComposition</Name>
<Value>TOP WITH PRINT STYLE AS SAMPLE</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
<AdditionalItemProperty>
<Name>AccountNumber</Name>
<Value>10200</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
</Item>
<Price>
<PriceAmount currencyID="EUR">-230.55</PriceAmount>
<PriceType>LineGoodsItemAmount</PriceType>
</Price>EUR</InvoiceLine>
<InvoiceLine>
<ID>182127846</ID>
<InvoicedQuantity>-60</InvoicedQuantity>
<LineExtensionAmount currencyID="EUR">-313.5</LineExtensionAmount>
<OrderLineReference>
<LineID>1</LineID>
<OrderReference>
<ID>R4-8397</ID>
</OrderReference>
</OrderLineReference>
<DespatchLineReference>
<LineID>1</LineID>
<DocumentReference>
<ID>0</ID>
<DocumentType>DeliveryNote</DocumentType>
</DocumentReference>
</DespatchLineReference>
<AllowanceCharge>
<ChargeIndicator>false</ChargeIndicator>
<Amount currencyID="EUR">-16.2</Amount>
</AllowanceCharge>
<TaxTotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
</TaxTotal>
<Item>
<Description>FAUNDATION MIX BOX U·</Description>
<BrandName>VILA</BrandName>
<SellersItemIdentification>
<ID>470533</ID>
</SellersItemIdentification>
<StandardItemIdentification>
<ID>5708073698173</ID>
<MeasurementDimension>
<AttributeID>NetWeight</AttributeID>
<Measure>.09</Measure>
</MeasurementDimension>
<MeasurementDimension>
<AttributeID>GrossWeight</AttributeID>
<Measure>.09</Measure>
</MeasurementDimension>
</StandardItemIdentification>
<OriginCountry>
<Name>LITHUANIA</Name>
</OriginCountry>
<AdditionalItemProperty>
<Name>GrossPrice</Name>
<Value>5.5</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>NetPrice</Name>
<Value>5.23</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>RetailPrice</Name>
<Value>14.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>FabricComposition</Name>
<Value>JERSY TOP W. FRONT PRINT</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
<AdditionalItemProperty>
<Name>AccountNumber</Name>
<Value>10200</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
</Item>
<Price>
<PriceAmount currencyID="EUR">-330</PriceAmount>
<PriceType>LineGoodsItemAmount</PriceType>
</Price>EUR</InvoiceLine>
<InvoiceLine>
<ID>182127843</ID>
<InvoicedQuantity>-28</InvoicedQuantity>
<LineExtensionAmount currencyID="EUR">-211.47</LineExtensionAmount>
<OrderLineReference>
<LineID>1</LineID>
<OrderReference>
<ID>R4-8397</ID>
</OrderReference>
</OrderLineReference>
<DespatchLineReference>
<LineID>1</LineID>
<DocumentReference>
<ID>0</ID>
<DocumentType>DeliveryNote</DocumentType>
</DocumentReference>
</DespatchLineReference>
<AllowanceCharge>
<ChargeIndicator>false</ChargeIndicator>
<Amount currencyID="EUR">-11.2</Amount>
</AllowanceCharge>
<TaxTotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
</TaxTotal>
<Item>
<Description>FLAIR SHORT SLEEVE TOP X·</Description>
<BrandName>VILA</BrandName>
<SellersItemIdentification>
<ID>469471</ID>
</SellersItemIdentification>
<StandardItemIdentification>
<ID>5704027934533</ID>
<MeasurementDimension>
<AttributeID>NetWeight</AttributeID>
<Measure>.145</Measure>
</MeasurementDimension>
<MeasurementDimension>
<AttributeID>GrossWeight</AttributeID>
<Measure>.166</Measure>
</MeasurementDimension>
</StandardItemIdentification>
<OriginCountry>
<Name>TURKEY</Name>
</OriginCountry>
<AdditionalItemProperty>
<Name>GrossPrice</Name>
<Value>7.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>NetPrice</Name>
<Value>7.55</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>RetailPrice</Name>
<Value>21.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
<AdditionalItemProperty>
<Name>AccountNumber</Name>
<Value>10200</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
</Item>
<Price>
<PriceAmount currencyID="EUR">-222.6</PriceAmount>
<PriceType>LineGoodsItemAmount</PriceType>
</Price>EUR</InvoiceLine>
<InvoiceLine>
<ID>182127844</ID>
<InvoicedQuantity>-33</InvoicedQuantity>
<LineExtensionAmount currencyID="EUR">-437.33</LineExtensionAmount>
<OrderLineReference>
<LineID>1</LineID>
<OrderReference>
<ID>R4-8397</ID>
</OrderReference>
</OrderLineReference>
<DespatchLineReference>
<LineID>1</LineID>
<DocumentReference>
<ID>0</ID>
<DocumentType>DeliveryNote</DocumentType>
</DocumentReference>
</DespatchLineReference>
<AllowanceCharge>
<ChargeIndicator>false</ChargeIndicator>
<Amount currencyID="EUR">-23.1</Amount>
</AllowanceCharge>
<TaxTotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
</TaxTotal>
<Item>
<Description>BASI TOP X/REP BLACK/WHITE·</Description>
<BrandName>VILA</BrandName>
<SellersItemIdentification>
<ID>469511</ID>
</SellersItemIdentification>
<StandardItemIdentification>
<ID>5704027937237</ID>
<MeasurementDimension>
<AttributeID>NetWeight</AttributeID>
<Measure>.148</Measure>
</MeasurementDimension>
<MeasurementDimension>
<AttributeID>GrossWeight</AttributeID>
<Measure>.167</Measure>
</MeasurementDimension>
</StandardItemIdentification>
<OriginCountry>
<Name>TURKEY</Name>
</OriginCountry>
<AdditionalItemProperty>
<Name>GrossPrice</Name>
<Value>13.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>NetPrice</Name>
<Value>13.25</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>RetailPrice</Name>
<Value>39.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
<AdditionalItemProperty>
<Name>AccountNumber</Name>
<Value>10200</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
</Item>
<Price>
<PriceAmount currencyID="EUR">-460.35</PriceAmount>
<PriceType>LineGoodsItemAmount</PriceType>
</Price>EUR</InvoiceLine>
<InvoiceLine>
<ID>182127845</ID>
<InvoicedQuantity>-73</InvoicedQuantity>
<LineExtensionAmount currencyID="EUR">-589.47</LineExtensionAmount>
<OrderLineReference>
<LineID>1</LineID>
<OrderReference>
<ID>R4-8397</ID>
</OrderReference>
</OrderLineReference>
<DespatchLineReference>
<LineID>1</LineID>
<DocumentReference>
<ID>0</ID>
<DocumentType>DeliveryNote</DocumentType>
</DocumentReference>
</DespatchLineReference>
<AllowanceCharge>
<ChargeIndicator>false</ChargeIndicator>
<Amount currencyID="EUR">-30.66</Amount>
</AllowanceCharge>
<TaxTotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
</TaxTotal>
<Item>
<Description>NUGGIE TOP U·</Description>
<BrandName>VILA</BrandName>
<SellersItemIdentification>
<ID>469817</ID>
</SellersItemIdentification>
<StandardItemIdentification>
<ID>5704027956535</ID>
<MeasurementDimension>
<AttributeID>NetWeight</AttributeID>
<Measure>.17</Measure>
</MeasurementDimension>
<MeasurementDimension>
<AttributeID>GrossWeight</AttributeID>
<Measure>.2</Measure>
</MeasurementDimension>
</StandardItemIdentification>
<OriginCountry>
<Name>TURKEY</Name>
</OriginCountry>
<AdditionalItemProperty>
<Name>GrossPrice</Name>
<Value>8.5</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>NetPrice</Name>
<Value>8.08</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>RetailPrice</Name>
<Value>21.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>FabricComposition</Name>
<Value>WATERFALL TANK TOP IN MIXED QUALITIES</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
<AdditionalItemProperty>
<Name>AccountNumber</Name>
<Value>10200</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
</Item>
<Price>
<PriceAmount currencyID="EUR">-620.49</PriceAmount>
<PriceType>LineGoodsItemAmount</PriceType>
</Price>EUR</InvoiceLine>
<InvoiceLine>
<ID>182127847</ID>
<InvoicedQuantity>-23</InvoicedQuantity>
<LineExtensionAmount currencyID="EUR">-239.26</LineExtensionAmount>
<OrderLineReference>
<LineID>1</LineID>
<OrderReference>
<ID>R4-8397</ID>
</OrderReference>
</OrderLineReference>
<DespatchLineReference>
<LineID>1</LineID>
<DocumentReference>
<ID>0</ID>
<DocumentType>DeliveryNote</DocumentType>
</DocumentReference>
</DespatchLineReference>
<AllowanceCharge>
<ChargeIndicator>false</ChargeIndicator>
<Amount currencyID="EUR">-12.65</Amount>
</AllowanceCharge>
<TaxTotal>
<TaxAmount currencyID="EUR">-621.3</TaxAmount>
</TaxTotal>
<Item>
<Description>MARJON MINI SKIRT U/B·</Description>
<BrandName>VILA</BrandName>
<SellersItemIdentification>
<ID>470733</ID>
</SellersItemIdentification>
<StandardItemIdentification>
<ID>5704495003236</ID>
<MeasurementDimension>
<AttributeID>NetWeight</AttributeID>
<Measure>.24</Measure>
</MeasurementDimension>
<MeasurementDimension>
<AttributeID>GrossWeight</AttributeID>
<Measure>.26</Measure>
</MeasurementDimension>
</StandardItemIdentification>
<OriginCountry>
<Name>CHINA</Name>
</OriginCountry>
<AdditionalItemProperty>
<Name>GrossPrice</Name>
<Value>10.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>NetPrice</Name>
<Value>10.4</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>RetailPrice</Name>
<Value>29.95</Value>
</AdditionalItemProperty>
<AdditionalItemProperty>
<Name>FabricComposition</Name>
<Value>MINI SKIRT</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
<AdditionalItemProperty>
<Name>AccountNumber</Name>
<Value>10200</Value>
</AdditionalItemProperty>
<AdditionalItemProperty />
<AdditionalItemProperty />
</Item>
<Price>
<PriceAmount currencyID="EUR">-251.85</PriceAmount>
<PriceType>LineGoodsItemAmount</PriceType>
</Price>EUR</InvoiceLine>
</Invoice>

I am getting errors due to namespaces & prefixes like 'cac' & 'cbc'.
How can we read through without import program throwing errors due to namespaces?

Thanks,

andhilda · 2008-05-28

First you have to know sometihing about XML. You should start with a smaller XML document. But you create a XML port and build it like your XML document and then you create a codeunit to controle and consume the XML file:

IF OneFileImport <> '' THEN BEGIN
  InFile.OPEN(OneFileImport);
  InFile.CREATEINSTREAM(InStream);
  XMLPORT.IMPORT(XMLPORT::"Web Salesorder Import",InStream);
  InFile.CLOSE;
end

On the XMP port you can controle what you want to do with the data imported.

/Andhilda

jlandeen · 2008-05-28

One thing you will have to do before you can import an XML file is to make sure that you remove all Namespace references.

MS has posted some documentation on how to work with XML ports & Namespaces here:
https://mbs.microsoft.com/CMS/Templates/document/HowTo.aspx?NRMODE=Published&NRNODEGUID={319D4D3C-F1E0-483E-961B-D53F1E8B25FE}&NRORIGINALURL=/partnersource/documentation/howtoarticles/xmlportswebservices.htm?printpage=false&NRCACHEHINT=Guest&printpage=false&wa=wsignin1.0

Basically you have to add a namespace when you export a XML document and remove any namespaces using a XSLT transform when you import a XML document.

jlandeen · 2008-05-28

https://mbs.microsoft.com/CMS/Templates/document/HowTo.aspx?NRMODE=Published&NRNODEGUID={319D4D3C-F1E0-483E-961B-D53F1E8B25FE}&NRORIGINALURL=/partnersource/documentation/howtoarticles/xmlportswebservices.htm?printpage=false&NRCACHEHINT=Guest&printpage=false&wa=wsignin1.0

jlandeen · 2008-05-28

https://mbs.microsoft.com/partnersource/documentation/howtoarticles/xmlportswebservices.htm?printpage=false

Ok lets see if that link works

dago · 2009-05-19

jlandeen wrote:

https://mbs.microsoft.com/partnersource/documentation/howtoarticles/xmlportswebservices.htm?printpage=false

Ok lets see if that link works

this link is not accessible for everyone, is there any other way how i can see check it ?

Howdy, Stranger!

Quick Links

Categories

Need help with creating XMLPort for Invoice Import

Comments