Write nested XML file with powershell in foreach loops

Question

I am trying to write a nested XML file using powershell and XmlWriter. However the output is not what I am expecting, nor does it adhere to how I have logically set it out in the code. I know its slightly long but please look at the code below:

function newXML($output_file, $hubs_array){
        #create directory
    new-item -path "$outage_dir\$current_year\$current_month" -type directory -force
    # Create The Document and format
    $XmlWriter = New-Object System.XMl.XmlTextWriter($output_file,$Null)
    #format xml
    $xmlWriter.Formatting = [System.Xml.Formatting]::Indented
    # Write the XML Decleration
    $xmlWriter.WriteStartDocument()
    # Set the XSL
    $XSLPropText = "type='text/xsl' href='style.xsl'"
    $xmlWriter.WriteProcessingInstruction("xml-stylesheet", $XSLPropText)
    # <identifier><start of outage><end of outage><outage as perc>
    # Write Root Element    
    $xmlWriter.WriteStartElement("Hubs")
    # Write the Document
    foreach ($hub in $hubs_array){
            $xmlWriter.WriteStartElement("Hub")
            $xmlWriter.WriteAttributeString("name",$hub.hubname)
            foreach($device in $hub.devices){
                $xmlWriter.WriteStartElement("Device")
                $xmlWriter.WriteElementString("identifier", $device.device_id)
                $xmlWriter.WriteEndElement
                $xmlWriter.WriteElementString("sla", $device.SLA)
                $xmlWriter.WriteEndElement
                $xmlWriter.WriteElementString("outage_as_perc", $device.down_4dp)
                $xmlWriter.WriteEndElement
                $xmlWriter.WriteStartElement("Outages")
                $xmlWriter.WriteAttributeString("total",$device.outages)
                foreach($outage in $device.outagesArray){
                    $xmlWriter.WriteStartElement("Outage")
                    $xmlWriter.WriteElementString("start_of_outage", $outage.down_start)
                    $xmlWriter.WriteEndElement
                    $xmlWriter.WriteElementString("end_of_outage", $outage.down_end)
                    $xmlWriter.WriteEndElement
                    $xmlWriter.WriteElementString("total_downtime", $outage.downtime)
                    $xmlWriter.WriteEndElement
                    #close tag for outage
                    $xmlWriter.WriteEndElement
                }
                #close tag for outages
                $xmlWriter.WriteEndElement
                #close tag for device
                $xmlWriter.WriteEndElement

            }
            #close tag for hub
            $xmlWriter.WriteEndElement
    }
    #close tag for hubs
    $xmlWriter.WriteEndElement
    $xmlWriter.WriteEndDocument() 
    # Finish The Document
    $xmlWriter.Finalize
    $xmlWriter.Flush
    $xmlWriter.Close()
}

I assumed this would output in the following format:

<Hubs>
  <Hub>
    <Device>
      <identifier></>
      <sla></>
      <outage_as_perc></>
      <Outages total="2">
         <outage>
         </outage>
      </Outages>
    </Device>
   </Hub>
</Hubs>

The fact that I am looping through seems to be messing it up but I don't know why....

The result i do get is:

<Hubs>
  <Hub>
    <Device>
      <identifier></>
      <sla></>
      <outage_as_perc></>
      <Outages total="2">
         <outage>
           <outage>
              <outage>
                 <outage>
                    <outage>
                    </outage>
                 </outage>
              </outage>
           </outage>
         </outage>
      </Outages>
    </Device>
   </Hub>
 </Hubs>

Thanks in advance and sorry for the long read!!!

What is the output that you do get?

alroc
– alroc

2013-07-11 11:25:59 +00:00
Commented Jul 11, 2013 at 11:25 — alroc
– alroc, Commented Jul 11, 2013 at 11:25
@alroc please see the edit I have made

user1044585
– user1044585

2013-07-11 11:31:49 +00:00
Commented Jul 11, 2013 at 11:31 — user1044585
– user1044585, Commented Jul 11, 2013 at 11:31

Community · Accepted Answer · 2017-05-23 10:09:46Z

1

using

$xmlWriter.WriteEndElement()

instead of

$xmlWriter.WriteEndElement

should fix your problem

same problem in this post

edited May 23, 2017 at 10:09

CommunityBot

11 silver badge

answered Jul 19, 2013 at 7:01

aledra

971 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Write nested XML file with powershell in foreach loops

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related