I am trying to build an xml document containing customer orders to be automatically sent to my manufacturer.
Orders come in from my online shop (Ecwid platform) in a particular format which needs to be reformatted to a different layout for my manufacturer.
I’ve managed to use the formatting tool to arrange them in the layout that my manufacturer needs.
They require it in a text file attached to an email in xml layout like this (partial example file shown);
<?xml version="1.0" encoding="UTF-8"?>
<Orders>
<Order>
<SuppliersCodeForBuyer>HBK</SuppliersCodeForBuyer>
<Order_Date>2023-08-17 12:40:06 +0000</Order_Date>
<Order_Number>H009999</Order_Number>
<SuppliersCodeForCarrier>Courier</SuppliersCodeForCarrier>
<Name>Joe Bloggs</Name>
<AddressLine>1 Any Street</AddressLine>
<AddressLine>AddrLine2</AddressLine>
<AddressLine>AddrLine3</AddressLine>
<City>Anytown</City>
<County>TheShire</County>
<Postcode>AA1 12AA</Postcode>
<Country>GB</Country>
<Email>email@test-email.com</Email>
<Mobile>+441234123456</Mobile>
<Carrier/>
<Products>
I’ve successfully built the formatting steps to build this using the Convert to ASCII formatter step, but when it’s passed to google docs all the XML specific code characters and everything in between such < / > are removed and the following is what is created in the google doc;
HBK
2023-08-17 12:40:06 +0000
H009999
Courier
Joe Bloggs
1 Any Street
AddrLine2
AddrLine3
Anytown
TheShire
AA1 12AA
GB
email@test-email.com
+441234123456
As the contents of the google doc require it to contain the XML layout codes, I’m stuck. Anyone have any pointers as to what I’m doing wrong or a fix for this?
Thanks in advance.
Simon
