XML Export Problems

General ShopSite user discussion

XML Export Problems

Postby jontaco » Mon Dec 05, 2011 4:20 pm

My problem has to do with the way in which Shopsite is exporting product information into an XML file, specifically the product information field.

After I have successfully exported an XML file, which simply contains the unique product SKU and the product description field, I notice some text gets misplaced.

As an example, here is a non-escaped product description, as it appears before export:

8"<br>
plush fur with poly stuffing<br>
Round and round and round we go! This soft sculpted plush piece is constructed with internal wires preserving the heart warming poses. Packaged in an open sided box for easy on-shelf merchandising while providing full view and "touch-ability" for your customers!


And here is the same product description once it is exported as XML (and HTML characters are escaped)

<Product>
<SKU>94004</SKU>
<ProductDescription>&quot;&lt;br&gt;
plush fur with poly stuffing&lt;br&gt;
Round and round and round we go! This soft sculpted plush piece is constructed with internal wires preserving the heart warming poses. Packaged in an open sided box for easy on-shelf merchandising while providing full view and &quot;touch-ability&quot; for your customers!8</ProductDescription>
</Product>


If you look very carefully, you will see that Shopsite has placed the numeral 8 at the end of the product description, just before the closing </ProductDescription>, rather than after <ProductDescription>, where it should be.

One more example:

Non-escaped, non-XML version:

8"<br>
plush fur with poly stuffing<br>
Creative fun to go! Crayola&reg; Crayon color-inspired Boyds Bear comes complete with its own backpack for traveling along with a four-pack of Crayola&reg; Crayons and a Boyds paw print-shaped doodlepad to give the kids hours of fun!


Exported XML version:

<Product>
<SKU>919120</SKU>
<ProductDescription>&quot;&lt;br&gt;
plush fur with poly stuffing&lt;br&gt;
Creative fun to go! Crayola8&reg; Crayon color-inspired Boyds Bear comes complete with its own backpack for traveling along with a four-pack of Crayola&reg; Crayons and a Boyds paw print-shaped doodlepad to give the kids hours of fun!</ProductDescription>
</Product>


This latest example takes the numeral 8, which belongs at the beginning of the product-description, and places it between Crayola and &reg;.

Does anyone have any thoughts why the XML parser is getting confused here?

Thank you.
jontaco
 
Posts: 39
Joined: Sun Apr 20, 2008 8:05 pm
Location: Huntsville, AL

Re: XML Export Problems

Postby loren_d_c » Mon Dec 05, 2011 4:37 pm

Doesn't happen to me, and I copied your product descriptions exactly. I am using ShopSite Pro 11 sp1 r2, downloading in the version 11.1 XML format, and looking at the raw XML data in Notepad.

What version of ShopSite are you using?
What download format/version are specifying when you download?
And what application are you looking at the resulting HTML in?

-Loren
loren_d_c
 
Posts: 2572
Joined: Fri Aug 04, 2006 12:02 pm
Location: Anywhere


Return to User Forum

Who is online

Users browsing this forum: No registered users and 141 guests

cron