XML schemas for Excel

[Gamms]

Hi everyone,

I was wondering if anyone knew about creating schemas for exporting excel data to XML, as I'm a bit stumped. I've created my schema, data imports great, but data won't export. I've pinned down the bug: it's all because maxoccurs != 1. However, I need to have unbounded occurences, as I could have any number of shots and scenes that I need to express in XML. Does anyone know a workaround, so that I can keep the "unbounded" aspect of my schema, but manage to export?

Any help would be greatly appreciated! I've posted my schema below.

Thanks,
Gamms.

<?xml version="1.0" encoding="ISO-8859-1" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element name="PROJECT">
	<xs:complexType>
		<xs:sequence>
			<xs:element name="PROJECT_SETTINGS">
				<xs:complexType>
					<xs:sequence>
						<xs:element name="DEFAULT_RES" type="xs:string"/>
						<xs:element name="FRAMERATE" type="xs:string"/>
					</xs:sequence>
				</xs:complexType>
			</xs:element>
			<xs:element name="SCENE" maxOccurs="unbounded">
				<xs:complexType>
					<xs:sequence>
						<xs:element name="SHOT" maxOccurs="unbounded">
							<xs:complexType>
								<xs:sequence>
									<xs:element name="ACCESSORY" type="xs:string"/>
									<xs:element name="BACKGROUND" type="xs:string"/>
									<xs:element name="CHARACTER" type="xs:string"/>
									<xs:element name="DESCRIPTION" type="xs:string"/>
									<xs:element name="DURATION" type="xs:string"/>
								</xs:sequence>
								<xs:attribute name="shotNo" type="xs:string" use="required"/>						
							</xs:complexType>
						</xs:element>
					</xs:sequence>
				<xs:attribute name="sceneNo" type="xs:string" use="required"/>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
	</xs:complexType>
</xs:element>

</xs:schema>

[yamangman]

If the bug is due to, as you say, 'maxoccurs != 1', and you wish to have any number of occurrences (i.e. an optional element), doesn't a minoccurs=0 attribute value fix the problem? Can you give an example of data which is failing?

[Gamms]

Sample XML code which is failing:

<PROJECT>
    - <PROJECT_SETTINGS>
          <DEFAULT_RES>HD 720</DEFAULT_RES> 
          <FRAMERATE>25</FRAMERATE> 
      </PROJECT_SETTINGS>
- <SCENE sceneNo="001">
    - <SHOT shotNo="001">
          <ACCESSORY>Accessory1</ACCESSORY> 
          <BACKGROUND>Globe1</BACKGROUND> 
          <CHARACTER /> 
          <DESCRIPTION>There is a description here.</DESCRIPTION> 
          <DURATION>60</DURATION> 
      </SHOT>
    - <SHOT shotNo="002">
          <ACCESSORY /> 
          <BACKGROUND>Globe2</BACKGROUND> 
          <CHARACTER /> 
          <DESCRIPTION /> 
          <DURATION>55</DURATION> 
      </SHOT>
    - <SHOT shotNo="003">
          <ACCESSORY /> 
          <BACKGROUND>Globe3</BACKGROUND> 
          <CHARACTER /> 
          <DESCRIPTION>Another description test</DESCRIPTION> 
          <DURATION>80</DURATION> 
      </SHOT>
    - <SHOT shotNo="004">
          <ACCESSORY /> 
          <BACKGROUND>Globe</BACKGROUND> 
          <CHARACTER>Bob</CHARACTER> 
          <DESCRIPTION /> 
          <DURATION>67</DURATION> 
      </SHOT>
   </SCENE>
</PROJECT>

There is only ever one occurence of the <PROJECT_SETTINGS> tag, whereas there can be as many <SCENE> and <SHOT> tabs as you want.

I've just tried your suggestion of using minOccurs = "0" instead of setting maxOccurs, but sadly it just has the same effect as removing the maxOccurs tag

[yamangman]

Can't see anything wrong with that at all then, insofar as the XML you provided there does validate against the schema. Could be an excel problem.

[Gamms]

Thanks for taking a look yamangman! Nice to know I'm not doing anything too crazy!

[Gamms]

Anyone else got any insight on this? Any help would be much appreciated