Solved

XML Schema Question

Posted on 2009-07-10
4
925 Views
Last Modified: 2012-06-21
Hi, I am writing my first XML schema and (of course) I have run into a problem.  I have data in Excel similar to what is depicted in the code snippet below and I want to use this same set of data in several different places (intranet, logon scripts, and other in-house utilities ).  I figured the best way to do this was to create a single XML "master" that all the different interfaces would pull the data from so that everything is always consistent across the board.  

Anyway, what we are dealing with are drive mappings at many sites around the world.  What I would like to do is nest all the drive letters from a single site within that site in the XML data.  I tried creating my own schema and was able to successfully export to an XML file, but it is creating something similar to the following:

<site>
      <site_name>SiteA</site_name>
      <drives>
            <driveletter>F</driveletter>
            <path>\\ServerA\BD</path>
            <description>Business Development</description>
      </drives>
</site>
<site>
      <site_name>SiteA</site_name>
      <drives>
            <driveletter>G</driveletter>
            <path>\\ServerA\ACCT</path>
            <description>Accounting Data</description>
      </drives>
</site>
<site>
      <site_name>SiteA</site_name>
      <drives>
            <driveletter>G</driveletter>
            <path>\\ServerA\GIS</path>
            <description>GIS Data</description>
      </drives>
</site>

What I would like is for all three drives to be under a single site tag as I think that this would make it a little easier to parse in the future.  Is this possible?

Site	Ltr	Path		Desc

SiteA	F	\\svr-a\share1	desc1a

SiteA	G	\\svr-a\share2	desc2a

SiteA	G	\\svr-a\share3	desc3a

SiteB	H	\\svr-b\share1 	desc1b

SiteB	H	\\svr-b\share2 	desc2b

SiteB	I	\\svr-b\share3 	desc3b

SiteC	J	\\svr-c\share1 	desc1c

SiteC	L	\\svr-c\share2 	desc2c

SiteC	M	\\svr-c\share3 	desc3c

Open in new window

0
Comment
Question by:sublimnl_
  • 2
4 Comments
 
LVL 27

Accepted Solution

by:
Dabas earned 250 total points
ID: 24832794
What about the snippet below?
Same information, but much simpler!

I have used attributes instead of elements, as I believe it simplifies matters, but it is just throwing another idea on how to implement it.
Also I removed <description>, leaving it as the element value. Again, its just an idea.
<site site_name="SiteA">

	<drives driveletter="F" path="\\ServerA\BD">

            Business Development

      </drives>

	<drives driveletter="G" path="\\ServerA\ACCT">

            Accounting Data

      </drives>

	<drives driveletter="G" path="\\ServerA\GIS">

            GIS Data

      </drives>

</site>

Open in new window

0
 
LVL 27

Expert Comment

by:Dabas
ID: 25051784
I believe my answer addresses the question.
My comment did not have a response.
The moderator also did not explain why my answer should not be accepted.
The question as stated mentions: "What I would like is for all three drives to be under a single site tag"

My answer has all three drives under a single site tag.

Dabas
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now