AnsweredAssumed Answered

XML export to FileMaker Pro

Question asked by SteveWalsh on Sep 24, 2014
Latest reply on Sep 25, 2014 by FentonJones

Title

XML export to FileMaker Pro

Post

We want to develop an ERP type database for a small business niche in FileMaker Pro.

We need to update this database with an XML feed from our eCommerce system. What is the best way to map our XML feed from our shopping cart to the data elements in FileMaker Pro so all the customer info, product and product variations, etc. come over accurately?

Anyone with experience here?

Here is a small XML feed sample:

<Orders>
<Order>
<OrderId>1637</OrderId>
<OrderDate>2013-05-01 10:09:24</OrderDate>
<OrderStatus>on-hold</OrderStatus>
<BillingFirstName>Steve</BillingFirstName>
<BillingLastName>Jobs</BillingLastName>
<BillingFullName>Steve Jobs</BillingFullName>
<BillingCompany>Apple, Inc.</BillingCompany>
<BillingAddress1>1 Infinite Loop</BillingAddress1>
<BillingAddress2/>
<BillingCity>Cupertino</BillingCity>
<BillingState>CA</BillingState>
<BillingPostCode>90143</BillingPostCode>
<BillingCountry>US</BillingCountry>
<BillingPhone>414-398-1412</BillingPhone>
<BillingEmail>steve@apple.com</BillingEmail>
<ShippingFirstName>Steve</ShippingFirstName>
<ShippingLastName>Jobs</ShippingLastName>
<ShippingFullName>Steve Jobs</ShippingFullName>
<ShippingCompany>Apple, Inc.</ShippingCompany>
<ShippingAddress1>1 Infinite Loop</ShippingAddress1>
<ShippingAddress2/>
<ShippingCity>Cupertino</ShippingCity>
<ShippingState>CA</ShippingState>
<ShippingPostCode>90143</ShippingPostCode>
<ShippingCountry>US</ShippingCountry>
<ShippingMethodId>flat_rate</ShippingMethodId>
<ShippingMethod>Flat Rate</ShippingMethod>
<PaymentMethodId>cheque</PaymentMethodId>
<PaymentMethod>Cheque Payment</PaymentMethod>
<OrderDiscountTotal>0.00</OrderDiscountTotal>
<CartDiscountTotal>0.00</CartDiscountTotal>
<DiscountTotal>0.00</DiscountTotal>
<ShippingTotal>1.00</ShippingTotal>
<ShippingTaxTotal>0.00</ShippingTaxTotal>
<OrderTotal>30.00</OrderTotal>
<TaxTotal>0.00</TaxTotal>
<CompletedDate>2013-05-01 10:09:24</CompletedDate>
<CustomerNote/>
<CustomerId>0</CustomerId>
<OrderLineItems>
<SKU>W007</SKU>
<Quantity>1</Quantity>
<Price>29</Price>
<LineTotal>29</LineTotal>
<Meta/>
</OrderLineItems>
</Order>
</Orders>

Outcomes