Subject:Schema replacement in Microsoft generated XML Author:the code cowboy Date:01 Feb 2008 05:59 AM
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):
- 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).