XML File Nodes and Attributes

Posted by: mikenorris21 on 4 August 2017, 2:34 pm EST

  • Posted 4 August 2017, 2:34 pm EST

    <font size="2"> I am trying to process through the attached XML file, but am having a problem when I get to the point of processing the Order Details section...all of the other data will process fine.

    <AttributeList> 
       <Attribute id="sometext0">Valaue of sometext0</Attribute>
       <Attribute id="sometext1">Valaue of sometext1</Attribute>   
       <Attribute id="sometext2">Valaue of sometext2</Attribute>
       <Attribute id="sometext3">Valaue of sometext3</Attribute>
       <Attribute id="sometext4">Valaue of sometext4</Attribute>
    </AttributeList>

    If anyone knows how to process through this portion of the XML file i would greatly appreciate your help.  Thanks


    THE XML FILE CONTENTS****************


    </font>

    <div class="e"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <font color="#0000ff"> <span class="m"> <?</span> <span class="pi"> xml version="1.0" encoding="UTF-8"</span> <span class="m"> ?></span></font></div> <div class="e"> <div class="c" style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <font face="Courier New" color="#ff0000"> -</font> <span class="m"> <font color="#0000ff"> < companyName</font></span><span class="ns">  <font color="#ff0000"> xmlns</font></span> <span class="m"> <font color="#0000ff"> ="</font></span> <b class="ns"> <font color="#ff0000"> http://www.companyName.com</font></b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font></div> <div> <div class="e"> <div class="c" style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <font face="Courier New" color="#ff0000"> -</font> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> AdviseOfOrder</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div> <div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> OrderNumber</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 00000061</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> OrderNumber</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> OrderDate</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 03/30/05</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> OrderDate</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> PurchaseOrderNumber</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 202301-MT</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> PurchaseOrderNumber</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div class="c" style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <font face="Courier New" color="#ff0000"> -</font> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> Shipping</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div> <div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> ShippingMethod</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> UPS Ground</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> ShippingMethod</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div class="c" style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <font face="Courier New" color="#ff0000"> -</font> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> Address</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div> <div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> Company</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> Maverick test</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Company</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> FirstName</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> Mark</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> FirstName</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> LastName</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> Trumper</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> LastName</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> Address1</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 965 East Midlothian BLVD</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Address1</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> Address2</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 4th Floor</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Address2</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> City</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> edmonds</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> City</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> State</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> WA</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> State</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> Zipcode</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 98020</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Zipcode</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> Country</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> United States</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Country</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> PhoneDay</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 425-771-6500</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> PhoneDay</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> PhoneNight</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 425-771-6500</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> PhoneNight</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> Fax</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 425-771-6500</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Fax</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> Email</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> MarkTrumper@MaverickLabel.Com</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Email</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Address</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div></div> <div> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Shipping</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> ShippingCost</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 6.49</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> ShippingCost</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div class="c" style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <font face="Courier New" color="#ff0000"> -</font> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> LineItem</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div> <div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> JobNumber</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> PS050-890-009</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> JobNumber</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> Quantity</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 1000</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Quantity</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div class="c" style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <font face="Courier New" color="#ff0000"> -</font> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> AttributeList</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div> <div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Core Size</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> 3"</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Usage</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> Indoor Use</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Material</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> Flexible Clear Film</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Shape</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> Rectangle</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Size</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> 1 1/2" x 3/4"</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Barcode</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> None</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Proofs</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> true</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Roll Unwind Direction</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> #4</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Color</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> Black</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Color</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> Warm Red</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Custom Color</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> 206</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Customer Part Number</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> test</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Label Description</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> test XML</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <font color="#990000"> <span class="t"> Attribute</span> <span class="t"> id</span></font> <span class="m"> <font color="#0000ff"> ="</font></span> <b> Special Instructions</b> <font color="#0000ff"> <span class="m"> "</span> <span class="m"> ></span></font> <span class="tx"> testing new XML feature</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Attribute</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> AttributeList</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> Expedite</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> Standard</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> Expedite</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> ScheduledShipDate</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 04/05/05</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> ScheduledShipDate</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> ScheduledDeliveryDate</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 04/11/05</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> ScheduledDeliveryDate</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div class="e"> <div style="MARGIN-LEFT: 1em; TEXT-INDENT: -2em"> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> <</font></span> <span class="t"> <font color="#990000"> PackingList</font></span> <span class="m"> <font color="#0000ff"> ></font></span> <span class="tx"> 1</span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> PackingList</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div> <div> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> LineItem</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div></div> <div> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> </</font></span> <span class="t"> <font color="#990000"> AdviseOfOrder</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div></div> <div> <span class="b"> <font face="Courier New" color="#ff0000">  </font></span> <span class="m"> <font color="#0000ff"> </</font></span><span class="t">  <font color="#990000"> companyName</font></span> <span class="m"> <font color="#0000ff"> ></font></span></div></div></div>
  • Replied 4 August 2017, 2:34 pm EST

    Could you be a bit more specific as to what doesn't work? Also, posting the report in question would help me determine what's happening. Could you zip either the RPX or the dsr & dsx files for this report and attach them to your response? Thanks!
  • Replied 4 August 2017, 2:34 pm EST

    <font size="2"> Hi Brandon,

    I was having trouble bringing the <Attribute> elements value and its corresponding attribute id="somedata" in pattern by patteren. 

    I have contacted the company that emails this file out to us and had them re-write the XML file to say this.

    <font size="1"> <AttributeList>
       <Attribute id="DataDesc1" value="DataValue1">DataValue1</Attribute>
       <Attribute id="DataDesc2" value="DataValue2">DataValue2</Attribute>
       <Attribute id="DataDesc3" value="DataValue3">DataValue3</Attribute>
       <Attribute id="DataDesc4" value="DataValue4">DataValue4</Attribute>
       <Attribute id="DataDesc5" value="DataValue5">DataValue5</Attribute>
       <Attribute id="DataDesc6" value="DataValue6">DataValue6</Attribute>
    </AttributeList>
    </font>
    The attribute "id" corresponds to a database field and attribute "value" corresponds to its data that is inserted to the database.

    This way i can step through RecordPattern in a Loop statement and get this information to add to a database.

    I think I have it figured out...If it dosen't work I will attach the report i am having trouble with.

    thanks

    Mike Norris
    </font>

  • Replied 4 August 2017, 2:34 pm EST

    Hi Brandon...here is the DSR file and the XML file...let me know what you see.

    I am trying to get the records out of the XML file and in to a SQL Server Database.

    Thanks

    Mike
    2005/04/Process XML File.zip
  • Replied 4 August 2017, 2:34 pm EST

    Hi Mike,

    You'll need to setup each datafield to reflect the correct RecordsetPattern for each attribute. For example, I used "LineItem/AttributeList/Attribute/@id" to return the attribute @id in the AttributeList. If the number of attributes changes, you'll need to add a dynamic subreport that adds controls in its ReportStart event based on your input from the Attribute list.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels