- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
SQL/xsd/xml beginner question...need help
Posted on 7/14/16 at 8:53 am
Posted on 7/14/16 at 8:53 am
I ran a SQL query to pull some data a vendor needed. Then I converted the data into an XML file (using XML AUTO function in SQL) per their request. However, it didn’t match the xsd schema that the vendor wanted. They have sent me the xsd schema, but I have no clue how to convert my existing SQL data or XML file into their preferred schema.
Any help would be greatly appreciated. If the question doesn’t make sense, tell me why I sound like an idiot. This is all new to me
Any help would be greatly appreciated. If the question doesn’t make sense, tell me why I sound like an idiot. This is all new to me
Posted on 7/14/16 at 9:30 am to TheCaterpillar
Go to stackoverflow.com and ask that question. You will get better responses
Posted on 7/14/16 at 10:29 am to TheCaterpillar
Depending on: how different your XML AUTO generated file looks compared to their XSD schema, if this is a one time thing, and the complexity of the xml...it might be easier just go manually do some find/replace voodoo on your generated file to match their schema.
If it's fairly complex, your auto generated file is drastically different than their XSD schema, and this is an ongoing process, then you're going to have to work on a tiny script/program to accomplish this.
I've never done this personally, so someone with more experience could possibly chime in.
If it's fairly complex, your auto generated file is drastically different than their XSD schema, and this is an ongoing process, then you're going to have to work on a tiny script/program to accomplish this.
I've never done this personally, so someone with more experience could possibly chime in.
Posted on 7/14/16 at 10:36 am to Baers Foot
quote:
you're going to have to work on a tiny script/program to accomplish this.
Yep, just talked to our programmers and engineers and they are going to build a program to do this.
And I'm going to miss a deadline.
Fml.
Posted on 7/14/16 at 2:41 pm to TheCaterpillar
Hypothetically, the tiny script program is available on global elements, and requires a valid XML schema set.
This feature typically generates valid XML documents. However, if the schema contains one or more of the following, the sample might not be valid:
The xs:key, xs:keyref, and xs:unique identity constraints.
xs:pattern facets.
Enumerations of the xs:QName type.
xs:ENTITY, xs:ENTITIES, and xs:NOTATION types.
Also, note that xs:base64Binary content will be generated only if enumerations occur in the schema for that type.
This feature typically generates valid XML documents. However, if the schema contains one or more of the following, the sample might not be valid:
The xs:key, xs:keyref, and xs:unique identity constraints.
xs:pattern facets.
Enumerations of the xs:QName type.
xs:ENTITY, xs:ENTITIES, and xs:NOTATION types.
Also, note that xs:base64Binary content will be generated only if enumerations occur in the schema for that type.
Posted on 7/14/16 at 7:53 pm to TheCaterpillar
Popular
Back to top
Follow TigerDroppings for LSU Football News