Click here to Skip to main content
15,899,679 members
Home / Discussions / XML / XSL
   

XML / XSL

 
Questionwhy my file not opened [modified] Pin
kalaveer29-Apr-07 20:49
kalaveer29-Apr-07 20:49 
AnswerRe: why my file not opened Pin
Stefan Troschuetz29-Apr-07 22:14
Stefan Troschuetz29-Apr-07 22:14 
AnswerRe: why my file not opened Pin
George L. Jackson30-Apr-07 16:15
George L. Jackson30-Apr-07 16:15 
Questionxslt query Pin
mhadamji26-Apr-07 22:30
mhadamji26-Apr-07 22:30 
AnswerRe: xslt query Pin
George L. Jackson27-Apr-07 12:37
George L. Jackson27-Apr-07 12:37 
AnswerRe: xml Pin
George L. Jackson25-Apr-07 23:50
George L. Jackson25-Apr-07 23:50 
GeneralRe: xml Pin
WhiteGirl2326-Apr-07 19:56
WhiteGirl2326-Apr-07 19:56 
QuestionImport XML into SQL Server using SSIS Pin
supD25-Apr-07 3:00
supD25-Apr-07 3:00 
I grabbed the following .xml and .xsd files from an online tutorial, and tried to import them into SQL Server by using XML Source. I want to be able to import ALL the data; however, the simpleType elements under the root <shiporder> are all missing from the XML source, e.g <orderpersion>. The root element, including any attributes from the root element are also missing...e.g <shiporder orderid="889923"

How can I import these missing fields? The .xml and .xsd files are below.

Any help will be greatly appreciated. Thanks.


.XML and .XSD files below.

shiporder.xml
----------------
<?xml version="1.0" encoding="ISO-8859-1"?>

<shiporder orderid="889923"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="shiporder.xsd">
<orderperson>John Smith</orderperson>
<shipto>
<name>Ola Nordmann</name>
<address>Langgt 23</address>
<city>4000 Stavanger</city>
<country>Norway</country>
</shipto>
<item>
<title>Empire Burlesque</title>
<note>Special Edition</note>
<quantity>1</quantity>
<price>10.90</price>
</item>
<item>
<title>Hide your heart</title>
<quantity>1</quantity>
<price>9.90</price>
</item>
</shiporder>
----------------


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

<xs:simpleType name="stringtype">
<xs:restriction base="xs:string"/>
</xs:simpleType>

<xs:simpleType name="inttype">
<xs:restriction base="xs:positiveInteger"/>
</xs:simpleType>

<xs:simpleType name="dectype">
<xs:restriction base="xs:decimal"/>
</xs:simpleType>

<xs:simpleType name="orderidtype">
<xs:restriction base="xs:string">
<xs:pattern value="[0-9]{6}"/>
</xs:restriction>
</xs:simpleType>

<xs:complexType name="shiptotype">
<xs:sequence>
<xs:element name="name" type="stringtype"/>
<xs:element name="address" type="stringtype"/>
<xs:element name="city" type="stringtype"/>
<xs:element name="country" type="stringtype"/>
</xs:sequence>
</xs:complexType>

<xs:complexType name="itemtype">
<xs:sequence>
<xs:element name="title" type="stringtype"/>
<xs:element name="note" type="stringtype" minOccurs="0"/>
<xs:element name="quantity" type="inttype"/>
<xs:element name="price" type="dectype"/>
</xs:sequence>
</xs:complexType>

<xs:complexType name="shipordertype">
<xs:sequence>
<xs:element name="orderperson" type="stringtype"/>
<xs:element name="shipto" type="shiptotype"/>
<xs:element name="item" maxOccurs="unbounded" type="itemtype"/>
</xs:sequence>
<xs:attribute name="orderid" type="orderidtype" use="required"/>
</xs:complexType>

<xs:element name="shiporder" type="shipordertype"/>

</xs:schema>
QuestionProblem in storing URL in XML file Pin
Affan Toor23-Apr-07 21:47
Affan Toor23-Apr-07 21:47 
AnswerRe: Problem in storing URL in XML file Pin
Fatbuddha 123-Apr-07 23:19
Fatbuddha 123-Apr-07 23:19 
GeneralRe: Problem in storing URL in XML file Pin
Affan Toor24-Apr-07 0:43
Affan Toor24-Apr-07 0:43 
GeneralRe: Problem in storing URL in XML file Pin
Fatbuddha 124-Apr-07 0:46
Fatbuddha 124-Apr-07 0:46 
GeneralRe: Problem in storing URL in XML file Pin
Fatbuddha 124-Apr-07 0:52
Fatbuddha 124-Apr-07 0:52 
GeneralRe: Problem in storing URL in XML file Pin
George L. Jackson24-Apr-07 1:52
George L. Jackson24-Apr-07 1:52 
GeneralRe: Problem in storing URL in XML file Pin
Fatbuddha 124-Apr-07 2:44
Fatbuddha 124-Apr-07 2:44 
AnswerRe: Problem in storing URL in XML file Pin
RupeshSidpara27-Apr-07 20:25
RupeshSidpara27-Apr-07 20:25 
QuestionProduct Table Export to XML Pin
Brendan Vogt23-Apr-07 10:03
Brendan Vogt23-Apr-07 10:03 
AnswerRe: Product Table Export to XML Pin
George L. Jackson23-Apr-07 12:08
George L. Jackson23-Apr-07 12:08 
QuestionGeneration of xml file Pin
sudidelaravindra23-Apr-07 3:49
sudidelaravindra23-Apr-07 3:49 
AnswerRe: Generation of xml file Pin
Stefan Troschuetz23-Apr-07 4:43
Stefan Troschuetz23-Apr-07 4:43 
QuestionIs there any open source tool like Castor(for java) in .NET Pin
Gokulan Venattil19-Apr-07 2:29
Gokulan Venattil19-Apr-07 2:29 
QuestionMethode in Xslt? Pin
Ollie198616-Apr-07 22:03
Ollie198616-Apr-07 22:03 
AnswerRe: Methode in Xslt? Pin
George L. Jackson17-Apr-07 14:21
George L. Jackson17-Apr-07 14:21 
AnswerRe: Methode in Xslt? Pin
Paresh Chitte17-Apr-07 20:04
Paresh Chitte17-Apr-07 20:04 
QuestionXSLT - Trailing values Pin
Tristan Rhodes16-Apr-07 8:26
Tristan Rhodes16-Apr-07 8:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.