472,977 Members | 2,019 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,977 software developers and data experts.

URGENT HELP needed in creating xml from xsd schema

3
Hi all, I need urgent help with an xml issue. Let me explain the scenario:
My VB.NET app needs to read an xml (e.g. Sales Orders). This xml contains say 10 sales orders. Next the app needs to split the original xml into 10 individual SalesOrder xml files, each file containing a single sales order. The xml files created must be created based on a set xsd schema.See example below:
Here I have 2 sales orders in my original xml, I want to create 1 xml file for each Sales order.
e.g. <Sales Order>
<DocNum>"1234"</DocNum>
<ItemCode>"321"</ItemCode>
<DocDate>20070215</DocDate>
<Qty>1</Qty>
<Amount>$1500.00</Amount>
</Sales Order>
<Sales Order>
<DocNum>"1234"</DocNum>
<ItemCode>"321"</ItemCode>
<DocDate>20070215</DocDate>
<Qty>1</Qty>
<Amount>$1500.00</Amount>
</Sales Order>

Here are list of my issues:
1) Easier way to extract individual SalesOrders from the original xml: I can extract the inner text of all e.g. "DocNum" nodes in the original xml etc, but there must an easier way to extract all the childnodes inner text per SalesOrder node. (i.o.w. DocNum,ItemCode,DocDate,Qty,Amount together)

2) How to write the extracted xml information into an xml file based on a provided xsd file/schema.

I've been strugling for a week to find clear information on this and have been unsuccesfull thus far.
Any help would be greatly appreciated!
Thank you for your time
Feb 15 '07 #1
1 1506
shweta123
692 Expert 512MB
Hi,

Plase refer

this

There is information for both your questions.

Shweta
Feb 15 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Wolfgang Lipp | last post by:
my question is: do we need container elements for repeating elements in data-centric xml documents? or is it for some reason very advisable to introduce containers in xml documents even where not...
0
by: Jeremy Summers | last post by:
Has anyone run into problems creating typed datasets from complex schemas? I am attempting to create a Typed Dataset in Visual Studio .Net from a .xsd schema file for a industry standard web...
3
by: Kiran | last post by:
Hi, I want to back up my data in some table in SQL server and import it back using Bulk Load of SQL server 2K. I can use the following code to backup the data in XML ...
3
by: Mae | last post by:
Dear All, I have a problem here, I'm using C# Webform calling a webservices. The webservices return me a XMLnode, using this XMLnode I want to convert it to dataset so I can bind to the...
3
by: Sindarian | last post by:
I have a Schema from the folk that shows how they want the data received. I have my own database that has that data, but in a different way (they use 33 freaking tables to store what I do in 1)....
3
by: N. Spiker | last post by:
I am attempting to receive a single TCP packet with some text ending with carriage return and line feed characters. When the text is send and the packet has the urgent flag set, the text read from...
3
by: JMD | last post by:
A set of xsd files has been working fine for us at this site, but now it gives *intermittent* errors for someone at a different cite (who is consuming the code we are producing). Most of the time...
1
by: ah123 | last post by:
Hi guys, I am resonably new to XSD so I appologise if my question is simple. I am attempting to use an XSD to validate my XML document which previously used a DTD for validation. The problem is that...
1
by: kwartz | last post by:
Can someone please explain with examples to me 1. How storage parameters are select for a locally managed tablespace. 2. Creating appropriate indexes for a schema. 3. how to tune the database for...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.