Bytes - answers http://bytes.com XML (Extensible Markup Language) - Get answers to questions about XML development, XML languages (RSS, xHTML, wsdl), trees, syntax, elements, attributes, validation, XSLT, DOM, parser, namespaces, CDATA, encoding, XML servers and more. en Fri, 20 Nov 2009 23:17:02 GMT vBulletin 60 http://bytes.com/images/misc/rss.jpg Bytes - answers http://bytes.com How to make a spring config file out of schema http://bytes.com/topic/xml/answers/877289-how-make-spring-config-file-out-schema Thu, 19 Nov 2009 05:14:15 GMT Hello... I want to make a spring config file with the help of a schema file. plz help me out.... Hello...
I want to make a spring config file with the help of a schema file.

plz help me out.... ]]> answers ruhi17 http://bytes.com/topic/xml/answers/877289-how-make-spring-config-file-out-schema Xpath to get the nearest preceding sibling - howto? http://bytes.com/topic/xml/answers/877272-xpath-get-nearest-preceding-sibling-howto Wed, 18 Nov 2009 21:32:22 GMT I need to write a Xpath for getting the closest sibling to the current node. It should return exactly 1 element. How to write it? I need to write a Xpath for getting the closest sibling to the current node. It should return exactly 1 element. How to write it? ]]> answers senglory http://bytes.com/topic/xml/answers/877272-xpath-get-nearest-preceding-sibling-howto XSD - Compare consecutive elements http://bytes.com/topic/xml/answers/877209-xsd-compare-consecutive-elements Tue, 17 Nov 2009 22:35:27 GMT Is there any way of requiring the value of an element's attribute to equal the value of a child element of the previous element. What I mean is hopefully explained by the following snippet from an XML file.
Expand|Select|Wrap|Line Numbers
  1. <venue city="London">
  2. <nextvenue>Sydney</nextvenue>
  3. </venue>
  4. <venue city="Sydney">
  5. <nextvenue>Rome</nextvenue>
  6. </venue> 
I have been asked to create an XSD file for existing XML files whose structure cannot be changed, and I need to ensure that each <nextvenue> element has a value that matches the city attribute of the following <venue> element. Is this possible? ]]> answers xmlnovice http://bytes.com/topic/xml/answers/877209-xsd-compare-consecutive-elements unexpected error (Does anyone know XQuery?) http://bytes.com/topic/xml/answers/877036-unexpected-error-does-anyone-know-xquery Sat, 14 Nov 2009 21:20:08 GMT ok, im going nuts, why am i getting an error here? PLEASE HELP

Expand|Select|Wrap|Line Numbers
  1. xquery version "1.0";
  2. let $count := 0
  3. for $dept in doc("store.xml")/root/dept
  4.  
  5. return 
  6.     <total_items>
  7.         {        
  8.                 <name>{ $dept/name/text() }</name>,                
  9.                 <count>
  10.                     {  
  11.                     if (contains($dept/toys, "test")) 
  12.                     then let $count := $count + 1 
  13.                     }
  14.                     </count>
  15.         }            
  16.     </total_items>
  17.  
  18.  
error:
XQuery Validation Error!
Unexpected token - "}</count> } </total_vacci" ]]> answers sevak316 http://bytes.com/topic/xml/answers/877036-unexpected-error-does-anyone-know-xquery comparing dates using XQuery http://bytes.com/topic/xml/answers/877005-comparing-dates-using-xquery Fri, 13 Nov 2009 23:29:26 GMT Hi, I would like to compare 2 dates and see which one is older using XQuery. Anyone? -Thanks. Hi,

I would like to compare 2 dates and see which one is older using XQuery.

Anyone?

-Thanks. ]]> answers sevak316 http://bytes.com/topic/xml/answers/877005-comparing-dates-using-xquery xsl table http://bytes.com/topic/xml/answers/876839-xsl-table Wed, 11 Nov 2009 09:12:15 GMT Maximum Points 10 ...]]> how can i display this table in xsl?

Expand|Select|Wrap|Line Numbers
  1. <grade>
  2.  <Student>
  3.     <Name>Maximum Points</Name>
  4.     <Asmt1>10</Asmt1>
  5.     <Asmt2>10</Asmt2>
  6.     <Asmt3>10</Asmt3>
  7.     <Asmt4>10</Asmt4>
  8.     <Asmt5>10</Asmt5>
  9.     <Midterm>50</Midterm>
  10.     <Asmt6>10</Asmt6>
  11.     <Asmt7>10</Asmt7>
  12.     <Project>30</Project>
  13.     <Final>50</Final>
  14.     <TotalPoints/>
  15.     <MaxPoints/>
  16.     <Pct/>
  17.  </Student>
  18.   <Student>
  19.     <Name> Ahmed ALBalushi</Name>
  20.     <Asmt1>10</Asmt1>
  21.     <Asmt2>9</Asmt2>
  22.     <Asmt3>9</Asmt3>
  23.     <Asmt4>10</Asmt4>
  24.     <Asmt5>9</Asmt5>
  25.     <Midterm>28</Midterm>
  26.     <Asmt6>10</Asmt6>
  27.     <Asmt7>10</Asmt7>
  28.     <Project>28</Project>
  29.     <Final>47</Final>
  30.     <TotalPoints>170</TotalPoints>
  31.     <MaxPoints>180</MaxPoints>
  32.     <Pct>0.94</Pct>
  33.   </Student>
  34.   <Student>
  35.     <Name> Bader ALShekaili</Name>
  36.     <Asmt1>10</Asmt1>
  37.     <Asmt2>9</Asmt2>
  38.     <Asmt3>8</Asmt3>
  39.     <Asmt4>10</Asmt4>
  40.     <Asmt5>9</Asmt5>
  41.     <Midterm>26</Midterm>
  42.     <Asmt6>10</Asmt6>
  43.     <Asmt7>9</Asmt7>
  44.     <Project>24</Project>
  45.     <Final>43</Final>
  46.     <TotalPoints>158</TotalPoints>
  47.     <MaxPoints>180</MaxPoints>
  48.     <Pct>0.88</Pct>
  49.   </Student>
  50.   <Student>
  51.     <Name> Maryam ALBalushi</Name>
  52.     <Asmt1>10</Asmt1>
  53.     <Asmt2>10</Asmt2>
  54.     <Asmt3>9</Asmt3>
  55.     <Asmt4>10</Asmt4>
  56.     <Asmt5>10</Asmt5>
  57.     <Midterm>29</Midterm>
  58.     <Asmt6>9</Asmt6>
  59.     <Asmt7>10</Asmt7>
  60.     <Project>29</Project>
  61.     <Final>50</Final>
  62.     <TotalPoints>176</TotalPoints>
  63.     <MaxPoints>180</MaxPoints>
  64.     <Pct>0.98</Pct>
  65.   </Student>
  66. </grade>

Attached Files
File Type: zip 26452-XSL.zip (48.1 KB)
]]> answers albalushi http://bytes.com/topic/xml/answers/876839-xsl-table <![CDATA[Why do I get <w:p> w/o attributes?]]> http://bytes.com/topic/xml/answers/876505-why-do-i-get-w-p-w-o-attributes Wed, 04 Nov 2009 01:28:02 GMT XML:

Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  2. <w:document xmlns:ve="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:m="http://schemas.openxmlformats.org/officeDocument/2006/math" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:wp="http://schemas.openxmlformats.org/drawingml/2006/wordprocessingDrawing" xmlns:w10="urn:schemas-microsoft-com:office:word" xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main" xmlns:wne="http://schemas.microsoft.com/office/word/2006/wordml">
  3.     <w:body>
  4.         <w:p w:rsidR="000E17AA" w:rsidRDefault="000E17AA">
  5.             <w:pPr>
  6.                 <w:tabs>
  7.                     <w:tab w:val="left" w:pos="8186"/>
  8.                 </w:tabs>
  9.                 <w:rPr>
  10.                     <w:sz w:val="14"/>
  11.                     <w:szCs w:val="14"/>
  12.                 </w:rPr>
  13.             </w:pPr>
  14.         </w:p>
  15.     </w:body>
  16. </w:document>

XSL:
Expand|Select|Wrap|Line Numbers
  1. <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  2.         xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main"
  3.         xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main"
  4.         xmlns:o="urn:schemas-microsoft-com:office:office"
  5.         xmlns:v="urn:schemas-microsoft-com:vml"
  6.         xmlns:WX="http://schemas.microsoft.com/office/word/2003/auxHint"
  7.         xmlns:aml="http://schemas.microsoft.com/aml/2001/core"
  8.         xmlns:w10="urn:schemas-microsoft-com:office:word"
  9.         xmlns:wp="http://schemas.openxmlformats.org/drawingml/2006/wordprocessingDrawing"
  10.         xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
  11.         xmlns:rs="http://schemas.openxmlformats.org/package/2006/relationships"
  12.         version="1.0">
  13.  
  14.     <xsl:output method="html" encoding="utf-8" omit-xml-declaration="no" indent="yes"/>
  15.  
  16.  
  17.     <xsl:template match="w:p[count(ancestor::w:tbl)=0]|w:tbl[count(ancestor::w:tbl)=0]|w:footnote[count(ancestor::w:tbl)=0]|w:endnote[count(ancestor::w:tbl)=0]|w:docPart[count(ancestor::w:tbl)=0]">
  18.  
  19.         <xsl:copy>
  20.             <w:smartTag w:uri="http://schemas.openxmlformats.org/2006/smarttags" w:element="livetechdocs">
  21.                 <w:smartTagPr>
  22.                     <xsl:element name="w:attr">
  23.                         <xsl:attribute name="w:name">remap</xsl:attribute>
  24.                     </xsl:element>
  25.                 </w:smartTagPr>
  26.             </w:smartTag>
  27.  
  28.             <xsl:apply-templates/>
  29.  
  30.         </xsl:copy>
  31.  
  32.     </xsl:template>
  33.  
  34.  
  35.     <xsl:template match="node() | text()">
  36.         <xsl:copy>
  37.             <xsl:copy-of select="@*"/>
  38.             <xsl:apply-templates/>
  39.         </xsl:copy>
  40.     </xsl:template>
  41.  
  42. </xsl:stylesheet>
  43.  

Why do I get <w:p> w/o attributes? And how to fix this?


Thanks, ]]> answers senglory http://bytes.com/topic/xml/answers/876505-why-do-i-get-w-p-w-o-attributes ParseException in .xhtml files http://bytes.com/topic/xml/answers/876491-parseexception-xhtml-files Tue, 03 Nov 2009 19:14:40 GMT Hi all,

I'm working on a Facelets project inside Eclipse and I keep getting the following error almost every time I open up a .xhtml page:

ParseException: Error validating the model: Server returned HTTP response code: 503 for url: http://www.w3.org/TR/html1/DTD/xhtml1-transitional.dtd

Even more odd is that Eclipse points location to line -1.

Attached is a picture of this error's property window.

Thanks in advance!
GTLudwig
Attached Thumbnails
Click image for larger version Name: parseException.jpg Views: N/A Size: 9.6 KB ID: 2367  
]]> answers gtludwig http://bytes.com/topic/xml/answers/876491-parseexception-xhtml-files xslt :how to check whether the value of a string variable is Yes or No? http://bytes.com/topic/xml/answers/876330-xslt-how-check-whether-value-string-variable-yes-no Sat, 31 Oct 2009 07:44:35 GMT how to check whether the value of a string variable is Yes or No?
Expand|Select|Wrap|Line Numbers
  1. xsl;variable name="test1" select="DBE:OBJECT/DBE:ATTRIBUTE[@name='test1']/DBE:String"/>
  2. xsl;variable name="test2" select="DBE:OBJECT/DBE:ATTRIBUTE[@name='test2']/DBE:String"/>
  3.  
  4. xsl;choose>
  5. xsl;when test="$test1 = 'Yes'>
  6.     xsl;apply-templates select="YES"/>
  7. /xsl;when>
  8. xsl;when test="$test2 = 'Yes'>
  9.     xsl;apply-templates select="Invalid"/>
  10. /xsl:when>
  11. xsl;otherwise>
  12.      xsl;apply-templates select="DBE:OBJECT/DBE:ATTRIBUTE[@name='test3']/DBE:String"/>
  13. /xsl;otherwise>
  14. /xsl;choose>
  15.  
Please let me know what is wrong in the above? ]]> answers prao2005 http://bytes.com/topic/xml/answers/876330-xslt-how-check-whether-value-string-variable-yes-no How do I append data to XML file with PHP http://bytes.com/topic/xml/answers/876319-how-do-i-append-data-xml-file-php Fri, 30 Oct 2009 20:50:55 GMT I have a XML file I am working with. This file has been created by hand and I now need to develop a PHP script that will create it in the same... I have a XML file I am working with. This file has been created by hand and I now need to develop a PHP script that will create it in the same format.

Here is what I have thus far:

Expand|Select|Wrap|Line Numbers
  1. $query = "select * from " . $table_name . " ORDER BY stateID ASC";
  2. $result = mysql_query($query, $connection) or die("Could not complete database query");
  3. $num = mysql_num_rows($result);
  4.  
  5. if ($num != 0) {
  6.  
  7.  $file= fopen("data/frlpsData.xml", "w");
  8.  
  9.  $_xml ="<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n";
  10.  
  11.  $_xml .="<statutes>\r\n";
  12.  $_xml .="<states>\r\n";
  13.  
  14.  while ($row = mysql_fetch_array($result)) {
  15.  
  16.     $_xml .="\t<state id=\"". $row["stateID"] . "\" name=\"". $row["stateName"] . "\">\r\n";
  17.  
  18.  if ($row["id"]) {
  19.  
  20.     $_xml .="\t\t<counties>\r\n";
  21.     $_xml .="\t\t\t<county name=\"". $row["countyName"] . "\">\r\n";
  22.     $_xml .="\t\t\t\t<documents>\r\n";
  23.     $_xml .="\t\t\t\t\t<document name=\"". $row["docName"] . "\">\r\n";
  24.     $_xml .="\t\t\t\t\t\t<types>\r\n";
  25.     $_xml .="\t\t\t\t\t\t\t<type id=\"". $row["entityType"] . "\" name=\"". $row["entityName"] . "\">\r\n";
  26.     $_xml .="\t\t\t\t\t\t\t\t<line>" . $row["line1"] . "</line>\r\n";
  27.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  28.     $_xml .="\t\t\t\t\t\t\t\t<line>" . $row["line2"] . "</line>\r\n";
  29.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  30.     $_xml .="\t\t\t\t\t\t\t\t<line>" . $row["line3"] . "</line>\r\n";
  31.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  32.     $_xml .="\t\t\t\t\t\t\t\t<line>" . $row["line4"] . "</line>\r\n";
  33.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  34.     $_xml .="\t\t\t\t\t\t\t\t<line>" . $row["line5"] . "</line>\r\n";
  35.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  36.     $_xml .="\t\t\t\t\t\t\t\t<line>" . $row["line6"] . "</line>\r\n";
  37.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  38.     $_xml .="\t\t\t\t\t\t\t\t<line>" . $row["line7"] . "</line>\r\n";
  39.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  40.     $_xml .="\t\t\t\t\t\t\t\t<line>" . $row["line8"] . "</line>\r\n";
  41.     $_xml .="\t\t\t\t\t\t\t</type>\r\n";
  42.     $_xml .="\t\t\t\t\t\t</types>\r\n";
  43.     $_xml .="\t\t\t\t\t</document>\r\n";
  44.     $_xml .="\t\t\t\t</documents>\r\n";
  45.     $_xml .="\t\t\t</county>\r\n";
  46.     $_xml .="\t\t</counties>\r\n";
  47.  
  48.   } else {
  49.  
  50.     $_xml .="\t\t<counties>\r\n";
  51.     $_xml .="\t\t\t<county name=\"". $row["countyName"] . "\">\r\n";
  52.     $_xml .="\t\t\t\t<documents>\r\n";
  53.     $_xml .="\t\t\t\t\t<document name=\"". $row["docName"] . "\">\r\n";
  54.     $_xml .="\t\t\t\t\t\t<types>\r\n";
  55.     $_xml .="\t\t\t\t\t\t\t<type id=\"". $row["entityType"] . "\" name=\"". $row["entityName"] . "\">\r\n";
  56.     $_xml .="\t\t\t\t\t\t\t\t<line>No Data For This State. Please Update.</line>\r\n";
  57.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  58.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  59.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  60.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  61.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  62.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  63.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  64.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  65.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  66.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  67.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  68.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  69.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  70.     $_xml .="\t\t\t\t\t\t\t\t<line></line>\r\n";
  71.     $_xml .="\t\t\t\t\t\t\t</type>\r\n";
  72.     $_xml .="\t\t\t\t\t\t</types>\r\n";
  73.     $_xml .="\t\t\t\t\t</document>\r\n";
  74.     $_xml .="\t\t\t\t</documents>\r\n";
  75.     $_xml .="\t\t\t</county>\r\n";
  76.     $_xml .="\t\t</counties>\r\n";
  77.  
  78.  }
  79.     $_xml .="\t</state>\r\n"; 
  80.  }
  81.  $_xml .="</states>\r\n";
  82.  $_xml .="</statutes>";
  83.  
  84.  fwrite($file, $_xml);
  85.  
  86.  fclose($file);
  87.  
  88.  echo "XML has been written.  <a href=\"data/frlpsData.xml\">View the XML.</a>";
  89.  
  90.  } else {
  91.  
  92.  echo "No Records found";
  93.  
  94.  } ?>
  95.  
Now, my problem is this. I need to create the XML file with the following format:

Expand|Select|Wrap|Line Numbers
  1. <states>
  2.         <state id="AL" name="Alabama">
  3.  
  4.                 <county name="Default" fipsID="9999">
  5.                     <documents>
  6.                         <document name="Summons and Complaint">
  7.                             <types>
  8.                                 <type id="biz" name="Business">
  9.                                     <line>ANY AUTHORIZED AGENT OVER THE AGE OF 18</line>
  10.                                     <line></line>
  11.                                     <line>DESCRIPTION: Sex____ Race_____ Age_____ Height_____ Weight_____ Hair_____ Glasses Y/N</line>                                                            
  12.                                 </type>
  13.                                 <type id="ind" name="Individual">
  14.                                     <line>PERSONAL-INDIVIDUAL SERVICE</line>
  15.                                     <line></line>
  16.                                     <line>SUBSTITUTE SERVICE -  ANY PERSON OVER THE AGE OF 18 WHO RESIDES AT DEFENDANT'S PLACE OF ABODE.</line>
  17.                                     <line></line>
  18.                                     <line>DESCRIPTION: Sex____ Race_____ Age_____ Height_____ Weight_____ Hair_____ Glasses Y/N</line>                                
  19.                                 </type>
  20.                             </types>
  21.                         </document>
  22.                         <document name="Subpeona">
  23.                             <types>
  24.                                 <type id="biz" name="Business">
  25.                                     <line>ANY AUTHORIZED AGENT OVER THE AGE OF 18</line>
  26.                                     <line></line>
  27.                                     <line>DESCRIPTION: Sex____ Race_____ Age_____ Height_____ Weight_____ Hair_____ Glasses Y/N</line>
  28.                                     <line>    </line>                                
  29.  
  30.                                 </type>
  31.                                 <type id="ind" name="Individual">
  32.                                     <line>MUST MAKE 3 ATTEMPTS ON 3 SEPERATE DAYS BEFORE SUBSERVING</line>
  33.                                     <line></line>
  34.                                     <line>ANY PERSON OVER THE AGE OF 18 WHO RESIDES AT SERVEES ABODE</line>
  35.                                     <line></line>
  36.                                     <line>DESCRIPTION: Sex____ Race_____ Age_____ Height_____ Weight_____ Hair_____ Glasses Y/N    </line>                                
  37.                                 </type>
  38.                             </types>
  39.                         </document>
  40.                         <document name="Subpoena Duces Tecum">
  41.                             <types>
  42.                                 <type id="biz" name="Business">
  43.                                     <line>ANY AUTHORIZED AGENT OVER THE AGE OF 18</line>
  44.                                     <line></line>
  45.                                     <line>DESCRIPTION: Sex____ Race_____ Age_____ Height_____ Weight_____ Hair_____ Glasses Y/N    </line>
  46.                                     <line>    </line>                                
  47.  
  48.                                 </type>
  49.                                 <type id="ind" name="Individual">
  50.                                     <line>MUST MAKE 3 ATTEMPTS ON 3 SEPERATE DAYS BEFORE SUBSERVING</line>
  51.                                     <line></line>
  52.                                     <line>ANY PERSON OVER THE AGE OF 18 WHO RESIDES AT SERVEES ABODE</line>
  53.                                     <line></line>
  54.                                     <line>DESCRIPTION: Sex____ Race_____ Age_____ Height_____ Weight_____ Hair_____ Glasses Y/N    </line>                                
  55.                                 </type>
  56.                             </types>
  57.                         </document>
  58.                     </documents>
  59.                 </county>        
  60.         </state>
  61.           </states>
  62.  
This is a truncated example, of course, leaving out the data for the other states in the country for this example.

What my PHP code does is creates a XML file from a MySQL table, but instead of appending the <document/> data to the various states/county, it creates a separate record for each document for each state. I need to condense the data so that all the documents are listed under the appropriate state for the appropriate county. I have been racking my brain trying to figure this out and I have come to the conclusion that I have just enough knowledge of PHP/MySQL/XML to make me dangerous.

What I am after is an example, some direction, or perhaps a tutorial that will show me how this is done and hopefully I can figure it out from there. All of the examples I have been able to find show how to append a new record to the file but I haven't been able to find one that shows how to append a child of a record while iterating through the results of the query.

Any help would be greatly appreciated. ]]> answers Hags007 http://bytes.com/topic/xml/answers/876319-how-do-i-append-data-xml-file-php how to retrieve node and child values that has xsi:type value http://bytes.com/topic/xml/answers/876291-how-retrieve-node-child-values-has-xsi-type-value Fri, 30 Oct 2009 12:00:35 GMT I have the below input XML sent by APP1.

Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <abc1:QWAARequest 
  3.   xmlns:abc1="http://www.mysite.com/myLink/v1/Test.xsd" 
  4.   xmlns:abc2="http://www.mysite.com/v1" 
  5.   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
  6.   xsi:schemaLocation="http://www.mysite.com/myLink/v1/Test.xsd Test.xsd">
  7.     <abc1:HostID>TEST</abc1:HostID>
  8.     <abc1:WorkForceEvent>
  9.         <abc2:ProjectElementHasCalendarEntry>
  10.             <abc2:relationshipType>ConfirmedSlot</abc2:relationshipType>
  11.             <abc2:CalendarEntry xsi:type="abc2:AppointmentEvent">
  12.                 <abc2:rescheduleReason>Standard Prefix</abc2:rescheduleReason>
  13.             </abc2:CalendarEntry>
  14.         </abc2:ProjectElementHasCalendarEntry>
  15.     </abc1:WorkForceEvent>
  16. </abc1:QWAARequest>
Another application APP2 sends a different XML file with different prefixes (say xyz1, xyz2 in place of abc1, abc2 in above xml) but with same namespace.

I am trying to build a generic xsl which can work with both xml files. Below is the same:

Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <xsl:stylesheet version="1.0" 
  3.                 xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
  4.                 xmlns:prefix1="http://www.mysite.com/myLink/v1/Test.xsd"  
  5.                 xmlns:prefix2="http://www.mysite.com/v1" 
  6.                 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  7.  
  8.   <xsl:template match="*">
  9.     <xsl:element name="{name()}">
  10.       <xsl:copy-of select="@*"/>
  11.       <xsl:apply-templates select="node() | text()"/>
  12.     </xsl:element>
  13.   </xsl:template>
  14.  
  15.   <xsl:template match="text()">
  16.     <xsl:copy-of select="."/>
  17.   </xsl:template>
  18.  
  19.   <xsl:template match="prefix1:*">
  20.     <xsl:element name="prefix1:{local-name()}">
  21.       <xsl:copy-of select="@*"/>
  22.       <xsl:apply-templates select="node() | text()"/>
  23.     </xsl:element>
  24.   </xsl:template>
  25.  
  26.   <xsl:template match="prefix2:*">
  27.     <xsl:element name="prefix2:{local-name()}">
  28.       <xsl:copy-of select="@*"/>
  29.       <xsl:apply-templates select="node() | text()"/>
  30.     </xsl:element>
  31.   </xsl:template>
  32.  
  33.   <xsl:template match="prefix1:QWAARequest">
  34.         <Output>
  35.       <xsl:value-of select="prefix1:HostID"/> |
  36.       <xsl:value-of select="prefix1:WorkForceEvent/prefix2:ProjectElementHasCalendarEntry/prefix2:relationshipType" /> |
  37.       <xsl:value-of select="prefix1:WorkForceEvent/prefix2:ProjectElementHasCalendarEntry[prefix2:relationshipType='ConfirmedSlot']/prefix2:CalendarEntry[@xsi:type='prefix2:AppointmentEvent']/prefix2:rescheduleReason" />
  38.     </Output>
  39.     </xsl:template>
  40. </xsl:stylesheet>
The above xsl works fine except where it tries to get the value for "rescheduleReason". I guess it is trying to look for exact value of 'prefix2:AppointmentEvent' but by xml has 'abc2:AppointmentEvent'.

Please suggest how to modify the xsl to interpret the value correctly.

I am using .Net 2.0 programming model to load the xml and xsl to generate the output.

Cheers
Rajani ]]> answers drajani http://bytes.com/topic/xml/answers/876291-how-retrieve-node-child-values-has-xsi-type-value Counter in XSLT http://bytes.com/topic/xml/answers/876213-counter-xslt Thu, 29 Oct 2009 08:15:15 GMT ]]> Hi All,

I'm having trouble counting the number of occurring nodes from my input XML.

I have this input:
Expand|Select|Wrap|Line Numbers
  1. <root>
  2.   <level1>
  3.     <countMeIn1/>
  4.   <level1>
  5.   <level1>
  6.     <countMeIn2/>
  7.   <level1>
  8.   <level1>
  9.     <countMeIn3/>
  10.     <countMeIn4/>
  11.     <countMeIn5/>
  12.   <level1>
  13. </root>
  14.  
And my desired output is:

Expand|Select|Wrap|Line Numbers
  1. <root>
  2.   <countMeIn count="1"/>
  3.   <countMeIn count="2"/>
  4.   <countMeIn count="3"/>
  5.   <countMeIn count="4"/>
  6.   <countMeIn count="5"/>
  7. </root>
  8.  
I have tried the position() function but that only renders an incremented number for 3,4 and 5.

Any help would be greatly appreciated. ]]> answers blacksab http://bytes.com/topic/xml/answers/876213-counter-xslt Extracting more than one attribute value http://bytes.com/topic/xml/answers/876174-extracting-more-than-one-attribute-value Wed, 28 Oct 2009 11:22:58 GMT I have an XML file that looks something like this
Expand|Select|Wrap|Line Numbers
  1. <MyXML>
  2.     <Stuff IDX="1"  Name="Swish" Manufacturer="Grimoto" ParentRef = "0" Ref = "1234567" />
  3.     : More elements
  4.     : More elements
  5.         <Stuff IDX="0"  Name="Swosh" Manufacturer="Grimoto" ParentRef = 1234567" Ref = "9876543" />
  6.         : More elements
  7.         : More elements
  8.         </IDX>
  9.     </IDX>
  10. <MyXML>
In the real file there are more attributes. I have managed to extract the complete Element with ParentRef = "0" using a Linq example I found on this site. Is it possible to extract a list of attributes from an Element in one hit using Linq (for instance the Name and Ref in this example) or do I have to process the Element I have extracted to get the information I want? ]]> answers pisicuta http://bytes.com/topic/xml/answers/876174-extracting-more-than-one-attribute-value Concatinating 2 tags inside the same node with xslt XSLT http://bytes.com/topic/xml/answers/876078-concatinating-2-tags-inside-same-node-xslt-xslt Mon, 26 Oct 2009 14:08:15 GMT Hi All,

I just started working with XSLT, so this question might be obvios for some; i'm struggling trying to concatenate 2 tags inside the same node. I will be receiving one XML file and my output is another XML file.

This is a sample of the xml i will be receiving:
Expand|Select|Wrap|Line Numbers
  1. <EquipmentList>
  2.     <EquipmentDetail>
  3.     <AssetSupplierName>Dealer 1</AssetSupplierName>
  4.     <Quantity>1</Quantity>
  5.                 <Specification>Asset 1</Specification>
  6.     </EquipmentDetail>
  7.     <EquipmentDetail>
  8.     <AssetSupplierName>Dealer 2</AssetSupplierName>
  9.     <Quantity>1</Quantity>
  10.                  <Specification>Asset 2</Specification>
  11.     </EquipmentDetail>
  12.     <EquipmentDetail>
  13.     <AssetSupplierName>Dealer 3</AssetSupplierName>
  14.     <Quantity>1</Quantity>
  15.                 <Specification>Asset 3</Specification>
  16.     </EquipmentDetail>
  17. <EquipmentList>
This is the code i have:
Expand|Select|Wrap|Line Numbers
  1. <xsl:template match="//Specification">
  2.     <xsl:copy>
  3.         <xsl:copy-of select="concat(., ' ', //EquipmentDetail/AssetSupplierName)"/>
  4.     </xsl:copy>
  5. </xsl:template>
The problem im having is that it always concatenates to Specification to the same AssetSupplierName Tag, i always get

Asset 1 Dealer 1
Asset 2 Dealer 1
Asset 3 Dealer 1

when im really expecting

Asset 1 Dealer 1
Asset 2 Dealer 2
Asset 3 Dealer 3

I have tried putting the same code above inside a for-each and i get the same results...

Thanks in advance! ]]> answers jpjpjpjp http://bytes.com/topic/xml/answers/876078-concatinating-2-tags-inside-same-node-xslt-xslt DTD is not working or validate the XML file Plz tell me what is the mistake? http://bytes.com/topic/xml/answers/876002-dtd-not-working-validate-xml-file-plz-tell-me-what-mistake Sat, 24 Oct 2009 15:43:39 GMT
Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0" ?> 
  2. <!DOCTYPE note [
  3.   <!ELEMENT note (to,from,heading,body)>
  4.   <!ELEMENT to      (#PCDATA)>
  5.   <!ELEMENT from    (#PCDATA)>
  6.   <!ELEMENT heading (#PCDATA)>
  7.   <!ELEMENT body    (#PCDATA)>
  8. ]>
  9. <note>
  10. <to>Tove</to> 
  11. <from>Jani</from> 
  12. <heading>Reminder</heading> 
  13. <message>Don't forget me this weekend!</message> 
  14. </note>
]]> answers uzairmemon http://bytes.com/topic/xml/answers/876002-dtd-not-working-validate-xml-file-plz-tell-me-what-mistake