Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Formatting XML child parent structure

Posted on 2015-02-12
4
Medium Priority
?
39 Views
Last Modified: 2015-03-04
I am trying to figure out how to structure my xml document to show
a state as a parent and the counties of that state as its children.
I  have attached a copy of the file.  Am I doing this correctly?
countystates.xml
0
Comment
Question by:cookiejar
  • 2
4 Comments
 
LVL 14

Expert Comment

by:Mark Bullock
ID: 40607299
Move the following to the line after the last county in your state:  </state>

The idea is that the county tags are in between the opening state tag <state ...> and the closing state tag </state>
0
 

Author Comment

by:cookiejar
ID: 40608632
Just to see if I understood.  Is the following correct?  I want to add other states as well with their counties.

<?xml version="1.0"?>
<statecounty>

      <state weather="rainy">Washington      
            <county>
              <name>Franklin County</name>
              <countyseat>Pasco</countyseat>
              <established>1883</established>
              <origin>Whitman County</origin>
              <population>17,863</population>
            </county>                        
      </state>
     
       <state weather="sunny">California      
            <county>
              name>Los Angeles</name>
              <countyseat>Los Angeles</countyseat>
              <established>1850</established>
              <origin>Los Angeles</origin>
              <population>10,017,068</population>            
             </county>                        
      </state>
      
</statecounty>
0
 
LVL 14

Expert Comment

by:Mark Bullock
ID: 40609370
Yes that is valid XML.
You can open your .xml file in Chrome or Firefox (and maybe Internet Explorer) and it will show you a nice indented view if your syntax is correct.
0
 
LVL 36

Accepted Solution

by:
mccarl earned 2000 total points
ID: 40611513
I would also move the name of the sate into either it's own element or an attribute of the state element, such as...

<state weather="sunny">
  <name>California</name>
  <county>
  ...
  </county>
</state>

Open in new window


...or...
<state weather="sunny" name="California">
  <county>
  ...
  </county>
</state>

Open in new window

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

885 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