XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
the code cowboySubject: Schema replacement in Microsoft generated XML
Author: the code cowboy
Date: 01 Feb 2008 05:59 AM
Hi,

I would like to process some XML documents which have been provided without the correct XML schema definitions. All fields are set to type="xs:string", regardless of whether they contain integers, text, currency values etc.

The XML schema is embedded in the XML file itself between <xs:schema and <xs:element> tags. I would be grateful if anyone can provide some pointers for doing the following in Stylus Studio (I am currently on a trial license of Enterprise edition):

either:

- strip out the schema and replace it with a new one, containing the correct data types. Process and convert to MYSQL tables.

- strip out the schema and generate external schemas for referencing from the web application (for which the XML docs are intended).

Many thanks

Posttop
(Deleted User) Subject: Schema replacement in Microsoft generated XML
Author: (Deleted User)
Date: 01 Feb 2008 06:33 PM
It's not so hard to do it in .NET code, if that's useful to you. There are classes which allow you to read an element (etc) as a particular data type. For example, XmlReader.ReadContentAsInt Method
(see http://msdn2.microsoft.com/en-us/library/system.xml.xmlreader_methods.aspx)

Ian Thomas
--------------
Stylus Studio 2008 XML Enterprise Suite R1 (Build 1050e)

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.