XML Export

[nielsnorby]

I am evaluating a new in house pos / customer info system to use.
I would like to be able to export an order when it is recieved from actinic into a specific xml format required by this new program. Kinda of like the same as how the link with quickbooks works. The below is a sample xml file that I would need to create from an order recieved from actinic v7.

Any Ideas or even if this is possible!

<OrderHeader>
<CompanyName>MookBone Systems</CompanyName>
<ContactName>Shawn Berringer</ContactName>

<BillingAddressOne>17785 Carson Basin Road</BillingAddressOne>
<BillingAddressTwo></BillingAddressTwo>
<BillingCity>Philadelphia</BillingCity>
<BillingState>PA</BillingState>
<BillingPostalCode>48778</BillingPostalCode>

<ShippingMethod>UPS 3-Day Select</ShippingMethod>
<ShippingAddressType>Residential Address</ShippingAddressType>
<ShippingCharges>20.00</ShippingCharges>
<ShippingAddressOne>17785 Carson Basin Road</ShippingAddressOne>
<ShippingAddressTwo></ShippingAddressTwo>
<ShippingCity>Philadelphia</ShippingCity>
<ShippingState>PA</ShippingState>
<ShippingPostalCode>48778</ShippingPostalCode>

<PhoneNumber>797-551-1220</PhoneNumber>
<PhoneExtension>5454</PhoneExtension>
<FaxNumber>978-878-4444</FaxNumber>
<CellPhone></CellPhone>
<E-MailAddress>rando@2kweb.net</E-MailAddress>
</OrderHeader>

<OrderDetail>
<OrderLineItem>
<Quantity>4</Quantity>
<ProductCode>ACRYLIC</ProductCode>
<UnitPrice>44.95</UnitPrice>
<SpecialInstructions>Please ensure the engraving is centered. I would like an Arial or Tahoma Style font if possible. If not, please call me so we can discuss font choices</SpecialInstructions>
<EngravingText>Engrave with Company NAme, then Recipient NAme as follows: JAck, John, Jill, Joe</EngravingText>
<Logo>Company Logo will be e-mailed</Logo>
</OrderLineItem>

<OrderLineItem>
<Quantity>50</Quantity>
<ProductCode>TROPHY</ProductCode>
<UnitPrice>18.50</UnitPrice>
<SpecialInstructions>Please center all text on the engraving. Font Choice for this line item is left up to your discretion. I will be e-mailing the engraving for the 50 Names for these trophies</SpecialInstructions>
<EngravingText></EngravingText>
<Logo>No Logo on this Line Item</Logo>
</OrderLineItem>
</OrderDetail>

[Jan]

I have written a few systems to produce this sort of order export, I did it by writing a report using crystal reports that produces the correct output and then using a program to run the report and produce the file. It is not an easy thing to do but once done works well.

One issue that has caused problems each time I have done this is matching the Actinic order numbers with the external order numbers.

Regards,

[nielsnorby]

Jan,

thanks for your reply, this sounds like something that is beyound my abilities.
What I would need is the ability to export an order in the format listed above then have it open up in a window that I could simply copy and past into my other program. I don't process alot of orders each day, right now about 3 a day. So copy and pasting would not be difficult. Would you be willing for a fee to facilitate this for me?

[Jan]

No problem, send me an email (jan at mole-end.biz) and we can talk about this further.

Regards,