Databases
StackOverflow2013
Postsdbo
POProperly mapping an xml schema in Excel
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POProperly mapping an xml schema in Excel
    text
    copied!<p>Long time reader, first time poster. It's time to mine this site for all it's knowledge!</p> <p>I'm trying to set up an xml schema and populate the data inside excel. I've made some definitions for some complexTypes because they will be reused quite often. If I reference the type, for example 3 times, inside excel it only maps the type once.</p> <p>I'm pretty new to schemas but my boss wants me to use them. Any other criticism would be greatly appreciated.</p> <p>XML SCHEMA:</p> <pre><code>&lt;xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt; &lt;!-- Type Definitions (DoorStyle, Colour, Accessory and TamarackModel) --&gt; &lt;xsd:complexType name="DoorStyle"&gt; &lt;xsd:sequence&gt; &lt;xsd:element name="style" type="xsd:string"/&gt; &lt;xsd:element name="wood" type="xsd:string"/&gt; &lt;xsd:element name="colour" type="xsd:string"/&gt; &lt;xsd:element name="imgsrc" type="xsd:string"/&gt; &lt;/xsd:sequence&gt; &lt;/xsd:complexType&gt; &lt;xsd:complexType name="Colour"&gt; &lt;xsd:sequence&gt; &lt;xsd:element name="colour" type="xsd:string"/&gt; &lt;xsd:element name="wood" type="xsd:string"/&gt; &lt;xsd:element name="imgsrc" type="xsd:string"/&gt; &lt;/xsd:sequence&gt; &lt;/xsd:complexType&gt; &lt;xsd:complexType name="Accessory"&gt; &lt;xsd:sequence&gt; &lt;xsd:element name="pdf" type="xsd:string"/&gt; &lt;/xsd:sequence&gt; &lt;/xsd:complexType&gt; &lt;xsd:complexType name="TamarackModel"&gt; &lt;xsd:sequence&gt; &lt;xsd:element name="drawing" type="xsd:string"/&gt; &lt;xsd:element name="reverseDrawing" type="xsd:string"/&gt; &lt;xsd:element name="priceSheet" type="xsd:string"/&gt; &lt;/xsd:sequence&gt; &lt;/xsd:complexType&gt; &lt;!-- Group Definitions (DoorStyles, Colours, Accessories and TamarackModels) --&gt; &lt;xsd:element name="DoorStyles"&gt; &lt;xsd:complexType&gt; &lt;!-- &lt;xsd:attribute name="url" type="xsd:string" fixed="http://www.muskokacabco.com/muskoka-kitchens-gallery-door-styles.html"/&gt; --&gt; &lt;xsd:sequence&gt; &lt;xsd:element name="DoorStyle" type="DoorStyle"/&gt; &lt;xsd:element name="DoorStyle" type="DoorStyle"/&gt; &lt;xsd:element name="DoorStyle" type="DoorStyle"/&gt; &lt;/xsd:sequence&gt; &lt;/xsd:complexType&gt; &lt;/xsd:element&gt; &lt;xsd:element name="Colours"&gt; &lt;xsd:complexType&gt; &lt;!-- xsd:attribute name="url" type="xsd:string" fixed="http://www.muskokacabco.com/muskoka-kitchens-gallery-stain-colours.html"/&gt; --&gt; &lt;xsd:sequence&gt; &lt;xsd:element name="Colour" type="Colour"/&gt; &lt;xsd:element name="Colour" type="Colour"/&gt; &lt;xsd:element name="Colour" type="Colour"/&gt; &lt;/xsd:sequence&gt; &lt;/xsd:complexType&gt; &lt;/xsd:element&gt; &lt;xsd:element name="Accessories"&gt; &lt;xsd:complexType&gt; &lt;!-- &lt;xsd:attribute name="url" type="xsd:string" fixed="http://www.muskokacabco.com/muskoka-kitchens-accessories.html"/&gt; --&gt; &lt;xsd:sequence&gt; &lt;xsd:element name="Accessory" type="Accessory"/&gt; &lt;xsd:element name="Accessory" type="Accessory"/&gt; &lt;xsd:element name="Accessory" type="Accessory"/&gt; &lt;/xsd:sequence&gt; &lt;/xsd:complexType&gt; &lt;/xsd:element&gt; &lt;xsd:element name="TamarackModels"&gt; &lt;xsd:complexType&gt; &lt;!-- &lt;xsd:attribute name="url" type="xsd:string" fixed="http://www.muskokacabco.com/muskoka-kitchens-tamarack-models.html"/&gt; --&gt; &lt;xsd:sequence&gt; &lt;xsd:element name="TamarackModel" type="TamarackModel"/&gt; &lt;xsd:element name="TamarackModel" type="TamarackModel"/&gt; &lt;xsd:element name="TamarackModel" type="TamarackModel"/&gt; &lt;/xsd:sequence&gt; &lt;/xsd:complexType&gt; &lt;/xsd:element&gt; &lt;!-- Overall Structure --&gt; &lt;xsd:element name="MuskokaSite"&gt; &lt;!-- &lt;xsd:attribute name="url" type="xsd:string" fixed="http://www.muskokacabco.com"/&gt; --&gt; &lt;xsd:complexType&gt; &lt;xsd:sequence&gt; &lt;xsd:element ref="DoorStyles"/&gt; &lt;xsd:element ref="Colours"/&gt; &lt;xsd:element ref="Accessories"/&gt; &lt;xsd:element ref="TamarackModels"/&gt; &lt;/xsd:sequence&gt; &lt;/xsd:complexType&gt; &lt;/xsd:element&gt; &lt;/xsd:schema&gt; </code></pre> <p>So I reference each type about 3 times, but in excel it only lets me map each type once if I choose as root. I would have loved to include a screenshot but apparently new users can't do that...</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload