Hej Guys,
i'm trying to import some order from an XML document into Dynamicweb, but nothing happens even if i get no errors.
I inserted me XML below, it contains one order with one orderline.
The solutions in running the latest application from the developerforum.
i've checked the DB and the order table is empty, even after i run my pipeline.
My Pipeline contains an XML file source and an Order destination
Settings in XML file source is as following:
Root Element : Order
XPath: Order/Order
File: the path the my XML order file.
Settings in Order destination is as following:
Configuration: Shop1
The XML
<Order>
<OrderID>CART127</OrderID>
<OrderShopID>SHOP2</OrderShopID>
<OrderDate>11/19/2007 2:38:04 PM</OrderDate>
<OrderModified>11/19/2007 2:38:04 PM</OrderModified>
<OrderComplete>True</OrderComplete>
<OrderDeleted>True</OrderDeleted>
<OrderStateID>OS112</OrderStateID>
<OrderVAT>70</OrderVAT>
<OrderIP>195.184.55.2</OrderIP>
<OrderReferrer />
<OrderTransactionValue />
<OrderTransactionType />
<OrderTransactionStatus />
<OrderTransactionAmount>0</OrderTransactionAmount>
<OrderTransactionPayGatewayCode />
<OrderTrackTraceNumber />
<OrderShippingMethod>Post Danmark</OrderShippingMethod>
<OrderShippingMethodFee>800</OrderShippingMethodFee>
<OrderPaymentMethod>Dankort</OrderPaymentMethod>
<OrderPaymentMethodFee>0</OrderPaymentMethodFee>
<OrderSalesDiscount>0</OrderSalesDiscount>
<OrderCurrencyName />
<OrderCurrencyRate>0</OrderCurrencyRate>
<OrderCurrencyCode />
<OrderCart>False</OrderCart>
<OrderFieldsXML />
<OrderReSendEmail />
<OrderCustomerNumber />
<OrderCustomerCompany />
<OrderCustomerName>ujgj</OrderCustomerName>
<OrderCustomerAddress>hghghj</OrderCustomerAddress>
<OrderCustomerAddress2>23-11-2007</OrderCustomerAddress2>
<OrderCustomerZip>6767</OrderCustomerZip>
<OrderCustomerCity>hkhjh</OrderCustomerCity>
<OrderCustomerCountry>Denmark</OrderCustomerCountry>
<OrderCustomerRegion />
<OrderCustomerPhone>7667676767</OrderCustomerPhone>
<OrderCustomerFax />
<OrderCustomerEmail>mn@co3.dk</OrderCustomerEmail>
<OrderCustomerCell />
<OrderCustomerRefID />
<OrderCustomerEAN />
<OrderCustomerVatRegNumber />
<OrderDeliveryCompany />
<OrderDeliveryName />
<OrderDeliveryAddress />
<OrderDeliveryAddress2 />
<OrderDeliveryZip />
<OrderDeliveryCity />
<OrderDeliveryCountry>Denmark</OrderDeliveryCountry>
<OrderDeliveryRegion />
<OrderDeliveryPhone />
<OrderDeliveryFax />
<OrderDeliveryEmail />
<OrderDeliveryCell />
<OrderTotalPrice>0</OrderTotalPrice>
<OrderComment />
<OrderCustomerComment>sdg sdfg sfd</OrderCustomerComment>
<OrderWeight>0</OrderWeight>
<OrderVolume>0</OrderVolume>
<OrderPriceWithVAT>1150</OrderPriceWithVAT>
<OrderPriceWithoutVAT>1080</OrderPriceWithoutVAT>
<OrderPriceVAT>70</OrderPriceVAT>
<OrderPriceVATPercent>6.48148148148148</OrderPriceVATPercent>
<OrderShippingFeeWithVAT>800</OrderShippingFeeWithVAT>
<OrderShippingFeeWithoutVAT>800</OrderShippingFeeWithoutVAT>
<OrderShippingFeeVAT>0</OrderShippingFeeVAT>
<OrderShippingFeeVATPercent>0</OrderShippingFeeVATPercent>
<OrderPaymentFeeWithVAT>0</OrderPaymentFeeWithVAT>
<OrderPaymentFeeWithoutVAT>0</OrderPaymentFeeWithoutVAT>
<OrderPaymentFeeVAT>0</OrderPaymentFeeVAT>
<OrderPaymentFeeVATPercent>0</OrderPaymentFeeVATPercent>
<OrderPriceBeforeFeesWithVAT>350</OrderPriceBeforeFeesWithVAT>
<OrderPriceBeforeFeesWithoutVAT>280</OrderPriceBeforeFeesWithoutVAT>
<OrderPriceBeforeFeesVAT>70</OrderPriceBeforeFeesVAT>
<OrderPriceBeforeFeesVATPercent>25</OrderPriceBeforeFeesVATPercent>
<OrderCustomerAccessUserID>0</OrderCustomerAccessUserID>
<OrderCustomerAccessUserUserName />
<OrderShippingMethodID>SHIP1</OrderShippingMethodID>
<OrderPaymentMethodID>PAY1</OrderPaymentMethodID>
<OrderGatewayResult />
<OrderStepNum>6</OrderStepNum>
<OrderTransactionNumber />
<OrderCustomerCountryCode>DK</OrderCustomerCountryCode>
<OrderDeliveryCountryCode>DK</OrderDeliveryCountryCode>
<OrderStepHistory>1,2,3,4,6</OrderStepHistory>
<OrderLanguageID>LANG1</OrderLanguageID>
<ShopID>SHOP2</ShopID>
<ShopName>LILLY</ShopName>
<ShopCreated>8/22/2007 3:07:41 PM</ShopCreated>
<ShopDefault>True</ShopDefault>
<ShopIcon />
</Shop>
<OrderStateID>OS112</OrderStateID>
<OrderStateName>Deleted</OrderStateName>
<OrderStateDescription />
<OrderStateIsDefault>False</OrderStateIsDefault>
<OrderStateDontUseInstatistics>True</OrderStateDontUseInstatistics>
<OrderStateIsDeleted>True</OrderStateIsDeleted>
</OrderState>
<OrderLineID>OL213</OrderLineID>
<OrderLineOrderID>CART127</OrderLineOrderID>
<OrderLineParentLineID />
<OrderLineBOM>False</OrderLineBOM>
<OrderLineDate>11/19/2007 2:38:04 PM</OrderLineDate>
<OrderLineModified>11/19/2007 2:38:04 PM</OrderLineModified>
<OrderLineProductNumber>03-307</OrderLineProductNumber>
<OrderLineProductID>PROD23</OrderLineProductID>
<OrderLineProductVariantID>,</OrderLineProductVariantID>
<OrderLineProductName />
<OrderLineProductVariantText />
<OrderLineUnitPrice />
<OrderLineVatPercent />
<OrderLineVatPrice />
<OrderLineQuantity>1</OrderLineQuantity>
<OrderLineType>0</OrderLineType>
<OrderLineReference></OrderLineReference>
<OrderLineBOMItemID />
<OrderLineUnitID />
<OrderLineWeight>0</OrderLineWeight>
<OrderLineVolume>0</OrderLineVolume>
<OrderLinePriceWithVAT>350</OrderLinePriceWithVAT>
<OrderLinePriceWithoutVAT>280</OrderLinePriceWithoutVAT>
<OrderLinePriceVAT>70</OrderLinePriceVAT>
<OrderLinePriceVATPercent>25</OrderLinePriceVATPercent>
<OrderLineUnitPriceWithVAT>350</OrderLineUnitPriceWithVAT>
<OrderLineUnitPriceWithoutVAT>280</OrderLineUnitPriceWithoutVAT>
<OrderLineUnitPriceVAT>70</OrderLineUnitPriceVAT>
<OrderLineUnitPriceVATPercent>25</OrderLineUnitPriceVATPercent>
<OrderLinePageId>1</OrderLinePageId>
<OrderLineDiscountID />
</OrderLine>
</OrderLines>
</Order>
</Order>