XML Development Forum RSS Feed

XSL Formatting Help Needed

Fri, 20 Jan 2012 19:41:37 -0800

I'm new to XML Development, and needed some assistance with an XSL that I'm trying to write.

I don't understand why it's not listing the <TOKEN> and <MIJ> tags. Also, I really only want it to display the pages that are either CHECK, BTSUMMARY_2011_0841_P1, BTSUMMARY_2011_0841_P2, or BTSUMMARY_2011_0841_P3.

Here's my sample XML:

<?xml version="1.0" ?>
- <BATCH PROCESSDATE="20120120">
<BATCHDIRPATH>D:\qmserver35\IMAGES\OUT\2012\01\17\ 08412011100002\</BATCHDIRPATH>
<BATCHNUMBER>08412011100002_001</BATCHNUMBER>
<BATCHSOURCE>QIBMLInput</BATCHSOURCE>
<BATCHTYPE>MasterMoney</BATCHTYPE>
<DATERECEIVED>20120117</DATERECEIVED>
<DATESCANNED>20120117</DATESCANNED>
<IBMLIMAGEPATH>c:\batches\08412011FFAX_435970002</ IBMLIMAGEPATH>
<IBMLOPERATOR>admin</IBMLOPERATOR>
<IBMLSCANNERID>FFAX_43597</IBMLSCANNERID>
<NUMCHECKS>0</NUMCHECKS>
<NUMPAGES>24</NUMPAGES>
<NUMRETS>0</NUMRETS>
<NUMSUBS>1</NUMSUBS>
<NUMVIRTUALBATCHES>6</NUMVIRTUALBATCHES>
<ORIGINALBATCHNUMBER>08412011100002</ORIGINALBATCH NUMBER>
<ORIGNUMSUBS>6</ORIGNUMSUBS>
<REMITBATCHNUMBER />
<SCANPROFILE>MasterMoney084</SCANPROFILE>
<SUBBATCHTYPE>Others</SUBBATCHTYPE>
<TOTALCOLLECTED>0</TOTALCOLLECTED>
- <SUBMISSION SUBNUM="1">
- <PAGE PAGENUM="1">
- <TOKEN>
<ARTIFICIAL_OCR>0</ARTIFICIAL_OCR>
<BARCODE />
<DOCID>1</DOCID>
<ERRORSTATUS />
<IBMLFORMNAME>Check</IBMLFORMNAME>
<IMAGEFILENAME_1>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\10000001.tif</IMAGEFILENAME_1>
<IMAGEFILENAME_2>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\11000001.jpg</IMAGEFILENAME_2>
<IMAGEFILENAMECOLOR>11000001.jpg</IMAGEFILENAMECOL OR>
<IMAGESIDE>Front</IMAGESIDE>
<IMGFILENAME>10000001.tif</IMGFILENAME>
<PAGEDLN>08412011FFAX_435970002_0001</PAGEDLN>
<PAGEINDEX>0</PAGEINDEX>
<PCAERROR>0</PCAERROR>
<PCAPELAPSESECOND>0.922667825096141</PCAPELAPSESEC OND>
<PDATACAPTURE>Y</PDATACAPTURE>
<PDFAMTCOR>0</PDFAMTCOR>
<PDFAMTRAW>0</PDFAMTRAW>
<PFORMIDMETHOD />
<PFORMTYPE>CHECK</PFORMTYPE>
<PFORMTYPERAW>CHECK</PFORMTYPERAW>
<PPAGENUM>1</PPAGENUM>
<PPAGETYPE>FORM</PPAGETYPE>
<PRETNUM>0</PRETNUM>
<PSCANLINE><001003< :011401533: 1123456789<</PSCANLINE>
<PSLERROR>0</PSLERROR>
<PSUBNUM>1</PSUBNUM>
<PSZAMTCOR />
<PSZAMTRAW />
</TOKEN>
- <MIJ>
<CHECKAMOUNT CONFIDENCE="290">3202.00</CHECKAMOUNT>
<PMICRLINE CONFIDENCE="0" />
<PAUXILIARYONUS CONFIDENCE="1000">001003</PAUXILIARYONUS>
<PEPC CONFIDENCE="1000" />
<PROUTING CONFIDENCE="1000">011401533</PROUTING>
<PONUS CONFIDENCE="1000">1123456789<</PONUS>
<PACCTNUM CONFIDENCE="1000">1123456789</PACCTNUM>
<PCHECKNUM CONFIDENCE="1000">001003</PCHECKNUM>
</MIJ>
</PAGE>
- <PAGE PAGENUM="2">
- <TOKEN>
<BARCODE />
<DOCID>1</DOCID>
<ERRORSTATUS />
<IBMLFORMNAME>Check</IBMLFORMNAME>
<IMAGEFILENAME_1>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\20000001.tif</IMAGEFILENAME_1>
<IMAGEFILENAME_2>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\21000001.jpg</IMAGEFILENAME_2>
<IMAGEFILENAMECOLOR>21000001.jpg</IMAGEFILENAMECOL OR>
<IMAGESIDE>Back</IMAGESIDE>
<IMGFILENAME>20000001.tif</IMGFILENAME>
<PAGEDLN>08412011FFAX_435970002_0001</PAGEDLN>
<PAGEINDEX>1</PAGEINDEX>
<PCAERROR>0</PCAERROR>
<PDATACAPTURE>N</PDATACAPTURE>
<PDFAMTCOR>0</PDFAMTCOR>
<PDFAMTRAW>0</PDFAMTRAW>
<PFORMIDMETHOD />
<PFORMTYPE>CHECK_R</PFORMTYPE>
<PFORMTYPERAW>CHECK_R</PFORMTYPERAW>
<PPAGENUM>2</PPAGENUM>
<PPAGETYPE>FORM</PPAGETYPE>
<PRETNUM>0</PRETNUM>
<PSCANLINE><001003< :011401533: 1123456789<</PSCANLINE>
<PSLERROR>0</PSLERROR>
<PSUBNUM>1</PSUBNUM>
<PSZAMTCOR />
<PSZAMTRAW />
</TOKEN>
<MIJ />
</PAGE>
- <PAGE PAGENUM="3">
- <TOKEN>
<ARTIFICIAL_OCR>0</ARTIFICIAL_OCR>
<BARCODE>0BTSUM1110841</BARCODE>
<DOCID>2</DOCID>
<ERRORSTATUS />
<IBMLFIELD3OF9>0BTSUM1110841</IBMLFIELD3OF9>
<IBMLFORMNAME>BT-SUMMARY page 1</IBMLFORMNAME>
<IMAGEFILENAME_1>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\10000002.tif</IMAGEFILENAME_1>
<IMAGEFILENAME_2>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\11000002.jpg</IMAGEFILENAME_2>
<IMAGEFILENAMECOLOR>11000002.jpg</IMAGEFILENAMECOL OR>
<IMAGESIDE>Front</IMAGESIDE>
<IMGFILENAME>10000002.tif</IMGFILENAME>
<PAGEDLN>08412011FFAX_435970002_0002</PAGEDLN>
<PAGEINDEX>2</PAGEINDEX>
<PCAERROR>0</PCAERROR>
<PCAPELAPSESECOND>4.1378976936976</PCAPELAPSESECON D>
<PDATACAPTURE>Y</PDATACAPTURE>
<PDFAMTCOR>0</PDFAMTCOR>
<PDFAMTRAW>0</PDFAMTRAW>
<PFORMIDMETHOD />
<PFORMTYPE>BTSUMMARY_2011_0841_P1</PFORMTYPE>
<PFORMTYPERAW>BTSUMMARY_2011_0841_P1</PFORMTYPERAW> ;
<PPAGENUM>3</PPAGENUM>
<PPAGETYPE>FORM</PPAGETYPE>
<PRETNUM>0</PRETNUM>
<PSCANLINE />
<PSLERROR>0</PSLERROR>
<PSUBNUM>1</PSUBNUM>
<PSZAMTCOR />
<PSZAMTRAW />
</TOKEN>
- <MIJ>
<PERBEGDT CONFIDENCE="900">0101201</PERBEGDT>
<PERENDDT CONFIDENCE="900">91231201</PERENDDT>
<FORMERNAMECB CONFIDENCE="560">1</FORMERNAMECB>
<FORMERNAME CONFIDENCE="253">INNCNEIASTNIIING UMSTFORMCERNAMME NN I N 7</FORMERNAME>
<LASTNM1 CONFIDENCE="564">PROPRIETOBHIP BSR NA NE</LASTNM1>
<FIRSTNM1 CONFIDENCE="552">AETNAME</FIRSTNM1>
<MIDINIT1 CONFIDENCE="941">M</MIDINIT1>
<INDVIDNO1 CONFIDENCE="355">728089011</INDVIDNO1>
<LASTNM2 CONFIDENCE="304">JOINTI OWNEDPMPEN UANANE</LASTNM2>
<FIRSTNM2 CONFIDENCE="675">ABTNAME</FIRSTNM2>
<MIDINIT2 CONFIDENCE="923">M</MIDINIT2>
<INDVIDNO2 CONFIDENCE="328">338039811</INDVIDNO2>
<PRIMNM CONFIDENCE="254">CIIRP1ONMTOE PTAANIE SI P AT NATEITINI RST</PRIMNM>
<BUSIDNO CONFIDENCE="294">702800280</BUSIDNO>
<PIACODE CONFIDENCE="286">081100</PIACODE>
<STRADDR1 CONFIDENCE="93">NUNNBBN ERKSNTREETNADDRESS NN</STRADDR1>
<STRADDR2 CONFIDENCE="71">ADDRESS FCONTINUEDI</STRADDR2>
<CITY CONFIDENCE="361">CITYLTOWNA N</CITY>
<STATE CONFIDENCE="812">NS</STATE>
<ZIPPSTLCD CONFIDENCE="75">ZIIPIACDEF</ZIPPSTLCD>
<BETCBY CONFIDENCE="1000">0</BETCBY>
<BETCBN CONFIDENCE="1000">0</BETCBN>
<BPTCBY CONFIDENCE="1000">0</BPTCBY>
<BPTCBN CONFIDENCE="1000">0</BPTCBN>
<NP990TFLGY CONFIDENCE="1000">0</NP990TFLGY>
<NP990TFLGN CONFIDENCE="808">0</NP990TFLGN>
<CORPCB CONFIDENCE="1000">1</CORPCB>
<COMBCB CONFIDENCE="392">0</COMBCB>
<PARTCB CONFIDENCE="1000">1</PARTCB>
<NPCB CONFIDENCE="1000">0</NPCB>
<PROPCB CONFIDENCE="792">1</PROPCB>
<FIDCB CONFIDENCE="1000">0</FIDCB>
<AMNDRTNFLG CONFIDENCE="1000">1</AMNDRTNFLG>
<FINLRTNFLG CONFIDENCE="1000">0</FINLRTNFLG>
<RP87FLAG CONFIDENCE="1000">0</RP87FLAG>
<RP87YRS CONFIDENCE="136">608102010510000011</RP87YRS>
</MIJ>
</PAGE>
- <PAGE PAGENUM="4">
- <TOKEN>
<ARTIFICIAL_OCR>0</ARTIFICIAL_OCR>
<BARCODE>0BTSUM1110841</BARCODE>
<DOCID>2</DOCID>
<ERRORSTATUS />
<IBMLFORMNAME>BT-SUMMARY page 1</IBMLFORMNAME>
<IMAGEFILENAME_1>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\20000002.tif</IMAGEFILENAME_1>
<IMAGEFILENAME_2>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\21000002.jpg</IMAGEFILENAME_2>
<IMAGEFILENAMECOLOR>21000002.jpg</IMAGEFILENAMECOL OR>
<IMAGESIDE>Back</IMAGESIDE>
<IMGFILENAME>20000002.tif</IMGFILENAME>
<PAGEDLN>08412011FFAX_435970002_0002</PAGEDLN>
<PAGEINDEX>3</PAGEINDEX>
<PCAERROR>0</PCAERROR>
<PCAPELAPSESECOND>0.930081057787902</PCAPELAPSESEC OND>
<PDATACAPTURE>Y</PDATACAPTURE>
<PDFAMTCOR>0</PDFAMTCOR>
<PDFAMTRAW>0</PDFAMTRAW>
<PFORMIDMETHOD />
<PFORMTYPE>ATTACHMENT</PFORMTYPE>
<PFORMTYPERAW>ATTACHMENT</PFORMTYPERAW>
<PPAGENUM>4</PPAGENUM>
<PPAGETYPE>FORM</PPAGETYPE>
<PRETNUM>0</PRETNUM>
<PSCANLINE />
<PSLERROR>0</PSLERROR>
<PSUBNUM>1</PSUBNUM>
<PSZAMTCOR />
<PSZAMTRAW />
</TOKEN>
- <MIJ>
<DUMMY CONFIDENCE="0" />
</MIJ>
</PAGE>
- <PAGE PAGENUM="5">
- <TOKEN>
<ARTIFICIAL_OCR>0</ARTIFICIAL_OCR>
<BARCODE>0BTSUM1120841</BARCODE>
<DOCID>3</DOCID>
<ERRORSTATUS />
<IBMLFIELD3OF9>0BTSUM1120841</IBMLFIELD3OF9>
<IBMLFORMNAME>BT-Summary page 2</IBMLFORMNAME>
<IMAGEFILENAME_1>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\10000003.tif</IMAGEFILENAME_1>
<IMAGEFILENAME_2>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\11000003.jpg</IMAGEFILENAME_2>
<IMAGEFILENAMECOLOR>11000003.jpg</IMAGEFILENAMECOL OR>
<IMAGESIDE>Front</IMAGESIDE>
<IMGFILENAME>10000003.tif</IMGFILENAME>
<PAGEDLN>08412011FFAX_435970002_0003</PAGEDLN>
<PAGEINDEX>4</PAGEINDEX>
<PCAERROR>0</PCAERROR>
<PCAPELAPSESECOND>3.77495044761235</PCAPELAPSESECO ND>
<PDATACAPTURE>Y</PDATACAPTURE>
<PDFAMTCOR>0</PDFAMTCOR>
<PDFAMTRAW>0</PDFAMTRAW>
<PFORMIDMETHOD />
<PFORMTYPE>BTSUMMARY_2011_0841_P2</PFORMTYPE>
<PFORMTYPERAW>BTSUMMARY_2011_0841_P2</PFORMTYPERAW> ;
<PPAGENUM>5</PPAGENUM>
<PPAGETYPE>FORM</PPAGETYPE>
<PRETNUM>0</PRETNUM>
<PSCANLINE />
<PSLERROR>0</PSLERROR>
<PSUBNUM>1</PSUBNUM>
<PSZAMTCOR />
<PSZAMTRAW />
</TOKEN>
- <MIJ>
<CRSUB CONFIDENCE="905">,43</CRSUB>
<TAXNETSTCR CONFIDENCE="950">19947</TAXNETSTCR>
<TOTTAXNET CONFIDENCE="925">19990</TOTTAXNET>
<TOTEXTN CONFIDENCE="0" />
<TOTESTIM CONFIDENCE="926">12500</TOTESTIM>
<TOTPREVYR CONFIDENCE="786">11288</TOTPREVYR>
<TOTPDORIG CONFIDENCE="0" />
<TOTPYMT CONFIDENCE="941">16788</TOTPYMT>
<BALTAXDUE CONFIDENCE="895">8202</BALTAXDUE>
<TOTINT CONFIDENCE="0" />
<TOTFP CONFIDENCE="0" />
<TOTFF CONFIDENCE="0" />
<TOTUND CONFIDENCE="0" />
<TOTADDTN CONFIDENCE="0" />
<SUBTOTAL5A CONFIDENCE="606">,3023</SUBTOTAL5A>
<EFTRETPYT CONFIDENCE="0" />
<BALANCEDUE CONFIDENCE="0" />
<OVRPYMT CONFIDENCE="0" />
<OVRPYMTCR CONFIDENCE="0" />
<OVRPYMTRFD CONFIDENCE="0" />
</MIJ>
</PAGE>
- <PAGE PAGENUM="6">
- <TOKEN>
<ARTIFICIAL_OCR>0</ARTIFICIAL_OCR>
<BARCODE>0BTSUM1120841</BARCODE>
<DOCID>3</DOCID>
<ERRORSTATUS />
<IBMLFORMNAME>BT-Summary page 2</IBMLFORMNAME>
<IMAGEFILENAME_1>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\20000003.tif</IMAGEFILENAME_1>
<IMAGEFILENAME_2>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\21000003.jpg</IMAGEFILENAME_2>
<IMAGEFILENAMECOLOR>21000003.jpg</IMAGEFILENAMECOL OR>
<IMAGESIDE>Back</IMAGESIDE>
<IMGFILENAME>20000003.tif</IMGFILENAME>
<PAGEDLN>08412011FFAX_435970002_0003</PAGEDLN>
<PAGEINDEX>5</PAGEINDEX>
<PCAERROR>0</PCAERROR>
<PCAPELAPSESECOND>0.142443522847316</PCAPELAPSESEC OND>
<PDATACAPTURE>Y</PDATACAPTURE>
<PDFAMTCOR>0</PDFAMTCOR>
<PDFAMTRAW>0</PDFAMTRAW>
<PFORMIDMETHOD />
<PFORMTYPE>ATTACHMENT</PFORMTYPE>
<PFORMTYPERAW>ATTACHMENT</PFORMTYPERAW>
<PPAGENUM>6</PPAGENUM>
<PPAGETYPE>FORM</PPAGETYPE>
<PRETNUM>0</PRETNUM>
<PSCANLINE />
<PSLERROR>0</PSLERROR>
<PSUBNUM>1</PSUBNUM>
<PSZAMTCOR />
<PSZAMTRAW />
</TOKEN>
- <MIJ>
<DUMMY CONFIDENCE="0" />
</MIJ>
</PAGE>
- <PAGE PAGENUM="7">
- <TOKEN>
<ARTIFICIAL_OCR>0</ARTIFICIAL_OCR>
<BARCODE>0BTSUM1130841</BARCODE>
<DOCID>4</DOCID>
<ERRORSTATUS />
<IBMLFIELD3OF9>0BTSUM1130841</IBMLFIELD3OF9>
<IBMLFORMNAME>BT-Summary page 3</IBMLFORMNAME>
<IMAGEFILENAME_1>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\10000004.tif</IMAGEFILENAME_1>
<IMAGEFILENAME_2>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\11000004.jpg</IMAGEFILENAME_2>
<IMAGEFILENAMECOLOR>11000004.jpg</IMAGEFILENAMECOL OR>
<IMAGESIDE>Front</IMAGESIDE>
<IMGFILENAME>10000004.tif</IMGFILENAME>
<PAGEDLN>08412011FFAX_435970002_0004</PAGEDLN>
<PAGEINDEX>6</PAGEINDEX>
<PCAERROR>0</PCAERROR>
<PCAPELAPSESECOND>1.20544063561101</PCAPELAPSESECO ND>
<PDATACAPTURE>Y</PDATACAPTURE>
<PDFAMTCOR>0</PDFAMTCOR>
<PDFAMTRAW>0</PDFAMTRAW>
<PFORMIDMETHOD />
<PFORMTYPE>BTSUMMARY_2011_0841_P3</PFORMTYPE>
<PFORMTYPERAW>BTSUMMARY_2011_0841_P3</PFORMTYPERAW> ;
<PPAGENUM>7</PPAGENUM>
<PPAGETYPE>FORM</PPAGETYPE>
<PRETNUM>0</PRETNUM>
<PSCANLINE />
<PSLERROR>0</PSLERROR>
<PSUBNUM>1</PSUBNUM>
<PSZAMTCOR />
<PSZAMTRAW />
</TOKEN>
- <MIJ>
<POAFLG CONFIDENCE="1000">0</POAFLG>
<SIGNEDFLG CONFIDENCE="1000">1</SIGNEDFLG>
<SIGNSPSFLG CONFIDENCE="1000">0</SIGNSPSFLG>
<SIGNNAME CONFIDENCE="900">I</SIGNNAME>
<SIGNEMAIL CONFIDENCE="0" />
<SIGNTELE CONFIDENCE="0" />
<SURVSPSFLG CONFIDENCE="1000">0</SURVSPSFLG>
<PREPARNAME CONFIDENCE="0">JOHIU ?WV IM</PREPARNAME>
<PREPREMAIL CONFIDENCE="0" />
<PREPRTELE CONFIDENCE="940">6032891065</PREPRTELE>
<PREPRID CONFIDENCE="166">133456725</PREPRID>
<STRADDR1 CONFIDENCE="0" />
<STRADDR2 CONFIDENCE="0" />
<CITY CONFIDENCE="891">PL EASANT ST</CITY>
<STATE CONFIDENCE="0" />
<ZIPPSTLCD CONFIDENCE="0" />
</MIJ>
</PAGE>
- <PAGE PAGENUM="8">
- <TOKEN>
<ARTIFICIAL_OCR>0</ARTIFICIAL_OCR>
<BARCODE>0BTSUM1130841</BARCODE>
<DOCID>4</DOCID>
<ERRORSTATUS />
<IBMLFORMNAME>BT-Summary page 3</IBMLFORMNAME>
<IMAGEFILENAME_1>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\20000004.tif</IMAGEFILENAME_1>
<IMAGEFILENAME_2>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\21000004.jpg</IMAGEFILENAME_2>
<IMAGEFILENAMECOLOR>21000004.jpg</IMAGEFILENAMECOL OR>
<IMAGESIDE>Back</IMAGESIDE>
<IMGFILENAME>20000004.tif</IMGFILENAME>
<PAGEDLN>08412011FFAX_435970002_0004</PAGEDLN>
<PAGEINDEX>7</PAGEINDEX>
<PCAERROR>0</PCAERROR>
<PCAPELAPSESECOND>0.621659177355468</PCAPELAPSESEC OND>
<PDATACAPTURE>Y</PDATACAPTURE>
<PDFAMTCOR>0</PDFAMTCOR>
<PDFAMTRAW>0</PDFAMTRAW>
<PFORMIDMETHOD />
<PFORMTYPE>ATTACHMENT</PFORMTYPE>
<PFORMTYPERAW>ATTACHMENT</PFORMTYPERAW>
<PPAGENUM>8</PPAGENUM>
<PPAGETYPE>FORM</PPAGETYPE>
<PRETNUM>0</PRETNUM>
<PSCANLINE />
<PSLERROR>0</PSLERROR>
<PSUBNUM>1</PSUBNUM>
<PSZAMTCOR />
<PSZAMTRAW />
</TOKEN>
- <MIJ>
<DUMMY CONFIDENCE="0" />
</MIJ>
</PAGE>
- <PAGE PAGENUM="9">
- <TOKEN>
<ARTIFICIAL_OCR>0</ARTIFICIAL_OCR>
<BARCODE>0011201110841</BARCODE>
<DOCID>5</DOCID>
<ERRORSTATUS />
<IBMLFIELD3OF9>0011201110841</IBMLFIELD3OF9>
<IBMLFORMNAME>NH-1120 page 1</IBMLFORMNAME>
<IMAGEFILENAME_1>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\10000005.tif</IMAGEFILENAME_1>
<IMAGEFILENAME_2>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\11000005.jpg</IMAGEFILENAME_2>
<IMAGEFILENAMECOLOR>11000005.jpg</IMAGEFILENAMECOL OR>
<IMAGESIDE>Front</IMAGESIDE>
<IMGFILENAME>10000005.tif</IMGFILENAME>
<PAGEDLN>08412011FFAX_435970002_0005</PAGEDLN>
<PAGEINDEX>8</PAGEINDEX>
<PCAERROR>0</PCAERROR>
<PCAPELAPSESECOND>1.99137404334761</PCAPELAPSESECO ND>
<PDATACAPTURE>Y</PDATACAPTURE>
<PDFAMTCOR>0</PDFAMTCOR>
<PDFAMTRAW>0</PDFAMTRAW>
<PFORMIDMETHOD />
<PFORMTYPE>NH1120_2011_0841_P1</PFORMTYPE>
<PFORMTYPERAW>NH1120_2011_0841_P1</PFORMTYPERAW>
<PPAGENUM>9</PPAGENUM>
<PPAGETYPE>FORM</PPAGETYPE>
<PRETNUM>0</PRETNUM>
<PSCANLINE />
<PSLERROR>0</PSLERROR>
<PSUBNUM>1</PSUBNUM>
<PSZAMTCOR />
<PSZAMTRAW />
</TOKEN>
- <MIJ>
<PRIMNM CONFIDENCE="288">LIDKTHHIY1EY3ICQADISMAAJILIAD607Q RP</PRIMNM>
<BUSIDNO CONFIDENCE="950">38255133</BUSIDNO>
<PERBEGDT CONFIDENCE="900">01012011</PERBEGDT>
<PERENDDT CONFIDENCE="406">2312061</PERENDDT>
<GRBPTOT CONFIDENCE="935">8327544</GRBPTOT>
<IRC179EXP CONFIDENCE="938">480000</IRC179EXP>
<IRCBONDEPR CONFIDENCE="0" />
<IRCDOMPROD CONFIDENCE="0" />
<IRCOTHDEDF CONFIDENCE="771">0720001</IRCOTHDEDF>
<IRCADDDEPR CONFIDENCE="355">037</IRCADDDEPR>
<IRCOTHITEM CONFIDENCE="0" />
<IRCSLSALL CONFIDENCE="0" />
<IRCSUBTOT CONFIDENCE="0" />
<IRCCNETINC CONFIDENCE="0" />
<ADJNTITY CONFIDENCE="0" />
<ADJUSINT CONFIDENCE="911">2528</ADJUSINT>
<ADJTAXES CONFIDENCE="900">397107</ADJTAXES>
<ADJIRC337 CONFIDENCE="0" />
<ADJWAGES CONFIDENCE="0" />
<ADJEXPEXIN CONFIDENCE="0" />
<ADJFORGN CONFIDENCE="0" />
<ADJRESRCH CONFIDENCE="0" />
</MIJ>
</PAGE>
- <PAGE PAGENUM="10">
- <TOKEN>
<ARTIFICIAL_OCR>0</ARTIFICIAL_OCR>
<BARCODE>0011201110841</BARCODE>
<DOCID>5</DOCID>
<ERRORSTATUS />
<IBMLFORMNAME>NH-1120 page 1</IBMLFORMNAME>
<IMAGEFILENAME_1>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\20000005.tif</IMAGEFILENAME_1>
<IMAGEFILENAME_2>D:\qmserver35\IMAGES\OUT\2012\01\ 17\08412011100002\21000005.jpg</IMAGEFILENAME_2>
<IMAGEFILENAMECOLOR>21000005.jpg</IMAGEFILENAMECOL OR>
<IMAGESIDE>Back</IMAGESIDE>
<IMGFILENAME>20000005.tif</IMGFILENAME>
<PAGEDLN>08412011FFAX_435970002_0005</PAGEDLN>
<PAGEINDEX>9</PAGEINDEX>
<PCAERROR>0</PCAERROR>
<PCAPELAPSESECOND>0.130812994386361</PCAPELAPSESEC OND>
<PDATACAPTURE>Y</PDATACAPTURE>
<PDFAMTCOR>0</PDFAMTCOR>
<PDFAMTRAW>0</PDFAMTRAW>
<PFORMIDMETHOD />
<PFORMTYPE>ATTACHMENT</PFORMTYPE>
<PFORMTYPERAW>ATTACHMENT</PFORMTYPERAW>
<PPAGENUM>10</PPAGENUM>
<PPAGETYPE>FORM</PPAGETYPE>
<PRETNUM>0</PRETNUM>
<PSCANLINE />
<PSLERROR>0</PSLERROR>
<PSUBNUM>1</PSUBNUM>
<PSZAMTCOR />
<PSZAMTRAW />
</TOKEN>
- <MIJ>
<DUMMY CONFIDENCE="0" />
</MIJ>
</PAGE>
</SUBMISSION>
</BATCH>

And here is my XSL:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes" version="1.0" encoding="UTF-8"/>
<xsl:template match="/">
<xsl:apply-templates select="BATCH"/>
</xsl:template>
<xsl:template match="BATCH">
<BATCH>
<xsl:attribute name="PROCESSDATE">
<xsl:value-of select="@PROCESSDATE"/>
</xsl:attribute>
<BATCHDIRPATH>
<xsl:value-of select="BATCHDIRPATH"/>
</BATCHDIRPATH>
<BATCHNUMBER>
<xsl:value-of select="BATCHNUMBER"/>
</BATCHNUMBER>
<BATCHSOURCE>
<xsl:value-of select="BATCHSOURCE"/>
</BATCHSOURCE>
<BATCHTYPE>
<xsl:value-of select ="BATCHTYPE"/>
</BATCHTYPE>
<DATERECIEVED>
<xsl:value-of select="DATERECEIVED"/>
</DATERECIEVED>
<DATESCANNED>
<xsl:value-of select="DATESCANNED"/>
</DATESCANNED>
<SCANNER>
<xsl:value-of select="IBMLSCANNERID"/>
</SCANNER>
<xsl:for-each select="SUBMISSION">
<SUBMISSION>
<xsl:attribute name="SUBNUM">
<xsl:value-of select="@SUBNUM"/>
</xsl:attribute>
<xsl:for-each select="PAGE">
<PAGE>
<xsl:attribute name="PAGENUM">
<xsl:value-of select="@PAGENUM"/>
</xsl:attribute>
<xsl:if test="PAGE/TOKEN/PFORMTYPE=CHECK">
<xsl:call-template name="CHECK"/>
</xsl:if>
<xsl:if test="PAGE/TOKEN/PFORMTYPE='BTSUMMARY_2011_0841_P1 '">
<xsl:call-template name="BT-SUMMARY-P1"/>
</xsl:if>
<xsl:if test="PAGE/TOKEN/PFORMTYPE='BTSUMMARY_2011_0841_P2 '">
<xsl:call-template name ="BT-SUMMARY-P2"/>
</xsl:if>
<xsl:if test="PAGE/TOKEN/PFORMTYPE='BTSUMMARY_2011_0841_P3 '">
<xsl:call-template name="BT-SUMMARY-P3"/>
</xsl:if>
</PAGE>
</xsl:for-each>
</SUBMISSION>
</xsl:for-each>
</BATCH>
</xsl:template>
<xsl:template name="CHECK">
<TOKEN>
</TOKEN>
<MIJ>
</MIJ>
</xsl:template>
<xsl:template name="BT-SUMMARY-P1">
<TOKEN>
</TOKEN>
<MIJ>
</MIJ>
</xsl:template>
<xsl:template name="BT-SUMMARY-P2">
<TOKEN>
</TOKEN>
<MIJ>
</MIJ>
</xsl:template>
<xsl:template name="BT-SUMMARY-P3">
<TOKEN>
</TOKEN>
<MIJ>
</MIJ>
</xsl:template>
</xsl:stylesheet>

Here is the output I'm currently getting:

<?xml version="1.0" encoding="UTF-8"?>
<BATCH PROCESSDATE="20120120">
<BATCHDIRPATH>D:\qmserver35\IMAGES\OUT\2012\01\17\ 08412011100002\</BATCHDIRPATH>
<BATCHNUMBER>08412011100002_001</BATCHNUMBER>
<BATCHSOURCE>QIBMLInput</BATCHSOURCE>
<BATCHTYPE>MasterMoney</BATCHTYPE>
<DATERECIEVED>20120117</DATERECIEVED>
<DATESCANNED>20120117</DATESCANNED>
<SCANNER>FFAX_43597</SCANNER>
<SUBMISSION SUBNUM="1">
<PAGE PAGENUM="1"/>
<PAGE PAGENUM="2"/>
<PAGE PAGENUM="3"/>
<PAGE PAGENUM="4"/>
<PAGE PAGENUM="5"/>
<PAGE PAGENUM="6"/>
<PAGE PAGENUM="7"/>
<PAGE PAGENUM="8"/>
<PAGE PAGENUM="9"/>
<PAGE PAGENUM="10"/>
</SUBMISSION>
</BATCH>

I've been using Altova to debug, but I don't see a problem.

Can someone PLEASE help?

Thank you.

XSL Formatting Help Needed

Fri, 20 Jan 2012 19:39:18 -0800

Need help to compare two sets of nodes in xsl

Sun, 04 Dec 2011 04:36:08 -0800

Here's peace of my xml: Code:

<GetUserMenu>
<MenuList>
<row MenuID="1" MenuTitle="DuomenÅ³ pateikimas"/>
</MenuList>
<FunctionList>
<row FunctionID="1" FunctionTitle="DuomenÅ³ importavimas iÅ¡ failo" MenuID="1" WorkflowName="ImportDataWithoutF
ile" Order="1"/>
<row FunctionID="2" FunctionTitle="DuomenÅ³ Ä¯vedimas" MenuID="1" WorkflowName="ImportDataFrom
File" Order="2"/>
</FunctionList>
</GetUserMenu>

and peace of xsl: Code:

<xsl:template match="//Authentication/GetUserMenu">
        <div>
            <xsl:for-each select="//MenuList/row">
                <div><xsl:value-of select="@MenuID"/></div>
                tu
                <xsl:for-each select="//FunctionList/row[">
                    <div><xsl:value-of select="@MenuID"/></div>
                </xsl:for-each>
                tu
            </xsl:for-each>
        </div>
    </xsl:template>

I would like to make my xsl do this: 1)In outer for-each cycle xsl reads value of MenuId attribute of of . 2) then in inner cycle for-each my xsl compares that value to every value of MenuAttribute of 's of 3) then my xsl reads the value of MenuId attribute of following of and repeats second step

In normal programming language what i am trying to do would look like this: foreach (xitems as xitem) foreach (yitems as yitem) if xitem == yitem do smth

Could anyone give any advice or modify my code in order to solve my issue? I would be grateful

Need help to compare two sets of nodes in xsl

Sun, 04 Dec 2011 04:33:11 -0800

Here's peace of my xml: Code:

<GetUserMenu>
<MenuList>
<row MenuID="1" MenuTitle="DuomenÅ³ pateikimas"/>
</MenuList>
<FunctionList>
<row FunctionID="1" FunctionTitle="DuomenÅ³ importavimas iÅ¡ failo" MenuID="1" WorkflowName="ImportDataWithoutF
ile" Order="1"/>
<row FunctionID="2" FunctionTitle="DuomenÅ³ Ä¯vedimas" MenuID="1" WorkflowName="ImportDataFrom
File" Order="2"/>
</FunctionList>
</GetUserMenu>

and peace of xsl: Code:

<xsl:template match="//Authentication/GetUserMenu">
        <div>
            <xsl:for-each select="//MenuList/row">
                <div><xsl:value-of select="@MenuID"/></div>
                tu
                <xsl:for-each select="//FunctionList/row[">
                    <div><xsl:value-of select="@MenuID"/></div>
                </xsl:for-each>
                tu
            </xsl:for-each>
        </div>
    </xsl:template>

XSLT transform XML document to display two columns from right to left

Mon, 07 Feb 2011 14:37:25 -0800

Hello,

I am trying to create XSLT output that will style XML to the following criteria. I have been stuck on this for several days please help.

1. Only display a field and table row if a value is present in the XML
2. Display only two column table
3. Display the data from left to right only if a value is present

Please see sample XML, XSLT, current output table and desired output table.

Thanks in advance,

Matthew

Current XML - Employees.xml

<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="Employees.xslt"?>
<Employees>
  <Person>
    <LastName>Smith</LastName>
    <FirstName>John</FirstName>
    <MiddleName>David</MiddleName>
    <Generation>Jr.</Generation>
    <Address>101 Oak</Address>
    <City>Peoria </City>
    <State>AZ </State>
    <Zip>85345 </Zip>
  </Person>
  <Person>
    <LastName>Johnson</LastName>
    <FirstName>Mark</FirstName>
    <MiddleName/>
    <Generation>Sr.</Generation>
    <Address>105 Blue</Address>
    <City>New Albany </City>
    <State>IN </State>
    <Zip>70005 </Zip>
  </Person>
  <Person>
    <LastName>Walker</LastName>
    <FirstName>Jimmy</FirstName>
    <MiddleName>Frank </MiddleName>
    <Generation/>
    <Address/>
    <City/>
    <State>CA </State>
    <Zip>90052 </Zip>
  </Person>
</Employees>

Current - Employees.xslt

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE xsl:stylesheet  [
  <!ENTITY nbsp   "&#160;">
  <!ENTITY copy   "&#169;">
  <!ENTITY reg    "&#174;">
  <!ENTITY trade  "&#8482;">
  <!ENTITY mdash  "&#8212;">
  <!ENTITY ldquo  "&#8220;">
  <!ENTITY rdquo  "&#8221;">
  <!ENTITY pound  "&#163;">
  <!ENTITY yen    "&#165;">
  <!ENTITY euro   "&#8364;">
]>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <xsl:output method="html" encoding="utf-16"/>
  <xsl:template match="/">


    <xsl:for-each select="Employees/Person">

      <table border="1" style="font-size:12pt; width:50%;">
        <td>
          <p style="text-align:center; font-size:14pt; font-weight:bold; background-color:#404060; color:white;">
            (<xsl:value-of select="position()"/>&nbsp;of&nbsp;<xsl:value-of select="count(//Person)"/>&nbsp;records found)
          </p>
        </td>
      </table>
      <table border="1" style="font-size:12pt; width:50%;">
        <tr>
          <td width="50%">
            <span style="font-weight:bold;">First Name:</span>
            <xsl:value-of select="FirstName"/>
          </td>
          <td width="50%">
            <span style="font-weight:bold;">Last Name:</span>
            <xsl:value-of select="LastName"/>
          </td>
        </tr>
        <tr>
          <td width="50%">
            <span style="font-weight:bold;">Middle Name:</span>
            <xsl:value-of select="MiddleName"/>
          </td>
          <td width="50%">
            <span style="font-weight:bold;">Generation:</span>
            <xsl:value-of select="Generation"/>
          </td>
        </tr>
        <tr>
          <td width="50%">
            <span style="font-weight:bold;">Address:</span>
            <xsl:value-of select="Address"/>
          </td>
          <td width="50%">
            <span style="font-weight:bold;">City:</span>
            <xsl:value-of select="City"/>
          </td>
        </tr>
        <tr>
          <td width="50%">
            <span style="font-weight:bold;">State:</span>
            <xsl:value-of select="State"/>
          </td>
          <td width="50%">
            <span style="font-weight:bold;">Zip:</span>
            <xsl:value-of select="Zip"/>
          </td>
        </tr>
      </table>
    </xsl:for-each>
  </xsl:template>
</xsl:stylesheet>

Current table output

<table border="1" style="font-size: 12pt; width: 50%;">
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">First Name: </span>John
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Last Name: </span>Smith
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Middle Name: </span>Middle Name:David
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Generation: </span>Generation:Jr.
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Address: </span>Address:101 Oak
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">City: </span>Peoria
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">State: </span>AZ
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Zip: </span>85345
        </td>
    </tr>
</table>
<br />
<table border="1" style="font-size: 12pt; width: 50%;">
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">First Name: </span>Mark
        </td>
        <td>
            <span style="font-weight: bold;">Last Name: </span>Johnson
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Middle Name: </span>
        </td>
        <td>
            <span style="font-weight: bold;">Generation: </span>Sr.
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Address: </span>105 Blue
        </td>
        <td>
            <span style="font-weight: bold;">City: </span>New Albany
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">State: </span>IN
        </td>
        <td>
            <span style="font-weight: bold;">Zip: </span>70005
        </td>
    </tr>
</table>
<br />
<table border="1" style="font-size: 12pt; width: 50%;">
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">First Name: </span>Jimmy
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Last Name: </span>Walker
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Middle Name: </span>Frank
        </td>
        <td>
            <span style="font-weight: bold;">Generation: </span>
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Address: </span>
        </td>
        <td>
            <span style="font-weight: bold;">City: </span>
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">State: </span>CA
        </td>
        <td>
            <span style="font-weight: bold;">Zip: </span>90052
        </td>
    </tr>
</table>

Desired table output

<table border="1" style="font-size: 12pt; width: 50%;">
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">First Name: </span>John
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Last Name: </span>Smith
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Middle Name: </span>David
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Generation: </span>Jr.
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Address: </span>101 Oak
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">City: </span>Peoria
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">State: </span>AZ
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Zip: </span>85345
        </td>
    </tr>
</table>
<br />
<table border="1" style="font-size: 12pt; width: 50%;">
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">First Name: </span>Mark
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Last Name: </span>Johnson
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Generation: </span>Sr.
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Address: </span>105 Blue
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">City: </span>New Albany
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">State: </span>IN
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Zip: </span>70005
        </td>
        <td valign="top" width="50%">
        </td>
    </tr>
</table>
<br />
<table border="1" style="font-size: 12pt; width: 50%;">
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">First Name: </span>Jimmy
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Last Name: </span>Walker
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Middle Name: </span>Frank
        </td>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">State: </span>CA
        </td>
    </tr>
    <tr>
        <td valign="top" width="50%">
            <span style="font-weight: bold;">Zip: </span>90052
        </td>
        <td valign="top" width="50%">
        </td>
    </tr>
</table>

date addition in xslt

Fri, 21 Jan 2011 05:26:48 -0800

Hi

I have a date retrieved in xslt in this format "01/18/2011". I just want to know how to add 10 days to it.

the below code gives the current date,month and year.

<xsl:variable name="rightNow" select="cal:getInstance()" />
<xsl:variable name="month" select="cal:get($rightNow, 2) + 1" />
<xsl:variable name="day" select="cal:get($rightNow, 5) " />
<xsl:variable name="year" select="cal:get($rightNow, 1)" />

I have the date like this

<xsl:variable name="sampledate">01/18/2011</xsl:variable>

Plese let me know how to set this value of "sampledate" in calendar:getInstance and then add 10 days to it.

Thanks

XMPP/Jabber Client implementation

Wed, 22 Dec 2010 05:59:42 -0800

Hello

Im trying to implement a simple Jabber client app using C++.

I understand that connection, handshake and user login happens through XML message streams.

The code i have written is as follows :

1) open socket
iSocket = socket(AF_INET, iSocketType, 0);

2) connect to server hosted on same machine ie. localhost
if(connect(iSocket, (struct sockaddr*)&iSa, sizeof(iSa)) < 0)

3) server handshake
string str = "<?xml version='1.0'?> <stream to='192.168.2.3:5222' xmlns='jabber:client'/>";

int result = send(iSocket, str.c_str(), strlen(str.c_str()), 0);
while(true)
{
if(result <= 0)
break;
result = recv(iSocket, str2, strlen(str2), 0);
reply.append(str2);
}
reply is :
<?xml version='1.0'?><stream:stream xmlns:stream='http://etherx.jabber.org/streams' id='1d01dbe8470a1700077872538724988a227c4f54' from='5222' xmlns='jabber:client'>t'>t

My doubt is after this, any XML stream Im sending doesnt receive a reply

I have tried different combinations.
References :
http://java.sys-con.com/node/232087

I even tried to extract the id received from reply in step 3 and constructed the stream. Tried 127.0.0.1 instead of localhost.

Please help.

XSL Concatenate 3 values - having trouble!

Mon, 20 Dec 2010 15:40:21 -0800

QUESTION: The attributes for height and width appear in the rendered HTML, however the specified Background-color is not showing up. Any ideas why this might be?

EXAMPLE OF XML:

<?xml version="1.0" encoding="UTF-8"?>
<channel>
    <title>Colour Guide</title>
    <link></link>
    <description>hi</description>
    <lastBuildDate>Mon, 13 Dec 2010 12:14:59 GMT</lastBuildDate>
    <image>
        <title>hello</title>
        <url>pages/pagethirtytwo/subsection</url>
        <link></link>
    </image>
    <item>
        <title>Player 12</title>
        <link></link>
        <ref id="80-2563">
            <shortdesc>Midfield, Defense</shortdesc>
            <longdesc>Midfield Defensive player.</longdesc>
            <L>87.04</L>
            <A>-4.3</A>
            <B>84.39</B>
            <R>239</R>
            <G>216</G>
            <B2>33</B2>
        </ref>
    </item>
</channel>

XSLT code that is giving me trouble:

<xsl:for-each select="ref"><td><xsl:attribute name="style"><![CDATA[height:12px;width:12px;[B]ba
ckground-color:(]]><xsl:value-of select = "concat(R,',',G,',',B2)" /><![CDATA[)]]>[/b]</xsl:attribute></td></xsl:for-each>

Full code:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" encoding="utf-8"/>
	<xsl:template match="/">
	  <xsl:apply-templates select="channel" />
	  <xsl:call-template name="items"/>
	</xsl:template>
	<xsl:template match="channel">
		<div class="ChannelTitle">
		  <h1><xsl:element name="a"><xsl:attribute name="title"><xsl:value-of disable-output-escaping="yes" select="title" /></xsl:attribute><xsl:attribute name="href"><xsl:value-of disable-output-escaping="yes" select="link" /></xsl:attribute></xsl:element></h1>
		  <h3><xsl:value-of disable-output-escaping="yes" select="description" /></h3>
		</div>
	</xsl:template>
	<xsl:template name="items">
		<xsl:for-each select="channel/item">
		  <div class="Article">
		    <h3 id="ArticleTitle"><xsl:element name="a"><xsl:attribute name="title"><xsl:value-of disable-output-escaping="yes" select="title" /></xsl:attribute><xsl:attribute name="href"><xsl:value-of disable-output-escaping="yes" select="link" /></xsl:attribute></xsl:element></h3>
		    <p id="ArticleDescription">
		    	<table cellspacing="0" cellpadding="0" border="0">
					<tr>
						<xsl:for-each select="ref"><td><xsl:attribute name="style"><![CDATA[height:12px;width:12px;backg
round-color:(]]><xsl:value-of select = "concat(R,',',G,',',B2)" /><![CDATA[)]]></xsl:attribute> <xsl:value-of select = "concat(R,',',G,',',B2)" /> </td></xsl:for-each>
					</tr>
				</table>
			</p>
		  </div>
	  	</xsl:for-each>
	</xsl:template>
</xsl:stylesheet>

Thanks,
Seth

XML DTD Assistance

Sat, 23 Oct 2010 16:52:05 -0800

Good evening!

I am working on an assignment where I create DVD database in XML and validate it with a DTD. I believe that I have accomplished this, but I would like someone to look at it and tell me if you see any issues. So far, everything validates fine, in other words no errors when displayed in an Internet Explorer window. However, I would like to make sure that I am hitting the right points.

DVDs.dtd file


<!--DVDs Private External DTD for Validating DVDs.xml-->
<?xml version="1.0" encoding="UTF-8"?>
<!ELEMENT DVDs (DVD)+>

<!ELEMENT DVD (title, genre, movieRating, viewerRating, summary, year, director, runtime, studio, actors)>

<!ELEMENT title (#PCDATA)>

<!ELEMENT genre (#PCDATA)>
<!ATTLIST genre kind (action | comedy | drama | family | foreign | horror | musical | other) #REQUIRED >

<!ELEMENT movieRating (#PCDATA)>
<!ATTLIST movieRating rating (G | PG | PG-13 | R | NC-17) #REQUIRED >

<!ELEMENT viewerRating (#PCDATA)>
<!ATTLIST viewerRating rating (1 | 2 | 3 | 4 | 5) #REQUIRED >

<!ELEMENT summary (#PCDATA)>

<!ELEMENT year (#PCDATA)>

<!ELEMENT director (#PCDATA)>

<!ELEMENT runtime (#PCDATA)>

<!ELEMENT studio (#PCDATA)>

<!ELEMENT actors (actor)+>
<!ELEMENT actor (first, last)>
<!ELEMENT actor (#PCDATA)>
<!ELEMENT first (#PCDATA)>
<!ELEMENT last (#PCDATA)>
<!ATTLIST actor idnum CDATA #REQUIRED >

DVDs.xml


<?xml version="1.0" encoding="UTF-8" ?>
<!-- DVDs.dtd can be found in the same directory as DVDs.xml -->
<!DOCTYPE DVDs SYSTEM "DVDS.dtd">
<DVDs>
<DVD>
<title>Star Wars Episode IV: A New Hope</title>
<genre>action</genre>
<movieRating>PG</movieRating>
<viewerRating>5</viewerRating>
<summary>Young hero Luke Skywalker joins the Rebel Alliance to help overthrow the tyrannical Galactic Empire.
</summary>
<year>1977</year>
<director>George Lucas</director>
<runtime>121</runtime>
<studio>20th Century Fox</studio>
<actors>
<actor idnum="0001">
<first>Mark</first>
<last>Hamill</last>
</actor>
<actor idnum="0002">
<first>Harrison</first>
<last>Ford</last>
</actor>
<actor idnum="0003">
<first>Carrie</first>
<last>Fisher</last>
</actor>
</actors>
</DVD>
<!-- Rest of DVDs omitted for brevity's sake -->
</DVDs>

Main points that I am concerned about:

1) 'movieRatings' should only be one of the choices in the enumerated list (G, PG, etc.). When I tried to enter a different value in the xml file, it still validated in the Internet Explorer window (i.e. no errors). I thought it would fly unless it was one of the predetermined choices?

2) Although it does not specify in the assignment description, I would like to do something similar with 'viewerRating'. In other words, only a number of 1 to 5 may be entered.

3) Each actor has to have their first and last name listed and is to have a unique identifier. I think I did it right but would like to be sure.

Any and all suggestions, comments or observations are welcome. Thanks in advance!

xslt help

Fri, 10 Sep 2010 02:14:44 -0800

HI,

i have a problem with xslt for the bullet list item:

Here is my sample input xml:

<section1>
text

•text
•text
•text

text

•text
•text
•text

text
</section1>

Output needed:

<section1>
text

<list type="bullet">
<item>•text</item>
<item>•text
<item>•text
</list>

text

<list type="bullet">
<item>•text</item>
<item>•text
<item>•text
</list>

text
</section1>

Please suggest..
Thanks in advance
Sag

How to put video on iPod/iPhone/PSP/Zune/Zen/Sansa Fuze……

Wed, 04 Aug 2010 23:19:12 -0800

This guide is shared to help people put any video on their portable devices.

Most devices only accept the following common video formats:
iPod/iPhone: H.264 (up to 320*240, 768kbps, 30fps), MPEG-4 (up to 480*480, 2500kbps, 30fps).
Zune: WMV, MPEG-4, H.264(30fps).
Creative Zen: AVI.
Sansa: MPEG-4, MP4.

In order to put some unusual video on your portable devices you need a professional [url=http://www.4easysoft.com/total-video-converter.html]Video Converter [/url]

4Easysoft Total video converter can convert video between almost all video formats.
Input Video Formats: WMV, MP4, MOV, M4V, AVI, FLV, 3GP, 3G2, MPG, VOB, MPEG, MPG, ASF, MOD, MKV,RM,TOD, MPV, TS, HD videos, etc.
Output video formats:MP4, MOV, M4V, VOB, XviD, AVI, FLV, 3GP, 3G2, MPG, ASF, MKV, RM. H.264.MPEG-4, WMV, Super VCD(NTSC, PAL, SECAM), VCD(NTSC, PAL, SECAM) , DVD(NTSC, PAL, SECAM), HD video.

The following is about how to use video converter to convert almost any video formats to most portable devices supported video.
Step 0: Download and install [url=http://www.4easysoft.com/download/total-video-converter.exe]4Easysoft Total Video Converter[/url]
Step 1: Run it and click the “Add File” button to load your video.
Step 2: Select the output video format from the profile drop-download list.
The profile including video for almost any portable devices such as iPod, iPhone, Archos, iRiver, PSP, Zune. Creative Zen, Nokia Serials, Palm, and so on..
Big surprice:This converter can also support HD video and flash video as its input and output video, such as HD H.264, HD AVI, HD MPG, HD TS, HD WMV, etc.

http://www.4easysoft.com/guide/video-converter/start.jpg[/img]

Or you can click “setting” button to customize output settings by setting Video Encoder, Resolution, Frame Rate, Video Bitrate, etc.

http://www.4easysoft.com/guide/video-converter/setting.jpg[/img]

Step 3:Edit your video.
You can use the powerful editing function to edit your video.
Effect: You can use this function to optimize the video effect.
By clicking “Effect” button, you can set the video Brightness, Contrast, Saturation and check Deinterlacing which helps you to convert interlaced video to the progressive video.

http://www.4easysoft.com/guide/video-converter/effect.jpg[/img]

Trim: You can use this function to cut any clip of your video.
Click the “Trim” and a dialogue-box pops up. You can drag the slide-bar to the position you want.
You can also set the Start time and the End time to trim your video.

http://www.4easysoft.com/guide/video-converter/trim.JPG[/img]

Crop: You can remove the black edges around your movie video and customize the size of video play region as you wish. Click “Crop” to open the Trim window. Select a crop mode in the Crop Mode drop-down list and click OK to save the crop.

http://www.4easysoft.com/guide/video-converter/crop.JPG[/img]

Preferences: By clicking the “Preference” button you can select the output destination, the Snapshot foler, the format of the snapshot image. You can also choose to shut down your computer or do nothing after your conversion. You can also select the CPU usage.

http://www.4easysoft.com/guide/video-converter/preference.JPG[/img]

Merge: You can use this function to merge several videos into one.
Snapshot: You can use this function to capture your favorite image.

Step 4: Click the “Start” button to start your conversion and in a short while it will be finished.

Some related video editing tools:
[url=http://www.4easysoft.com/mod-converter.html]Mod Converter[/url]:
It can convert Mod and Tod videos (made by some digital camcorder such JVC, Sony and so on) to any popular video formats such as AVI, WMV, RM, RMVB, MP3, etc. Besides professional conversion, they also have functions of Trim, Crop and Merge chapters into one file.
[url=http://www.4easysoft.com/mkv-converter.html]MKV Converter[/url]

XML and relational database mapping

Wed, 05 May 2010 07:59:17 -0800

Hi
I'm very new to XML, and have the following question.
I have XML file like this:

<?xml version="1.0"?>
<Company>
<Department>
<Name>Enterprise Development</Name>
<Employee>
<Name>Jeff</Name>
</Employee>
<Employee>
<Name>Mike</Name>
</Employee>>
</Department>
<Department>
<Name>Foundation Services</Name>
<Employee>
<Name>Sam</Name>
</Employee>
</Department>
</Company>

There is a one to many relationship between 'Department' and 'Employee'. When I import this file into Access DB, it creates the two tables with the data in it, but it does not seem to know there is such a relationship between the two tables. The schema is inferred.
How do I fix this.?? Do I include the primary key of the Department in both the Department and the Employee, and then manually set up the relationship in Access, or is there a more 'correct' solution.??
Thanks
Anton

Suggestions for why this XSLT isn't working?

Wed, 07 Apr 2010 21:19:24 -0800

I'm a relative beginner when it comes to XSLT but I thought this would be a fairly straightforward example. I'm just trying to render the items from an RSS feed as a simple unordered list <ul>. It doesn't, however, return any results and I can't work out why.

here's the xslt code

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Edited by XMLSpy® -->
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
  <html>
  <body>
  <h2>DLG Circulars</h2>
    <ul>
       <xsl:for-each select="rss/channel/item/">
       <li><a href="<xsl:value-of select="link"/>">
             <xsl:value-of select="title"/></a>
             <br />
             <xsl:value-of select="description"/>
       </li>
       </xsl:for-each>
    </ul>
  </body>
  </html>
</xsl:template>
</xsl:stylesheet>

and here's a portion of the source rss/xml file:

<?xml version="1.0"?>
<rss version="2.0" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:media="http://search.yahoo.com/mrss/" xmlns:yt="http://gdata.youtube.com/schemas/2007">
   <channel>
      <title>DLG Circulars</title>
      <description>Circulars from the Department of Local Government</description>
      <link>http://pipes.yahoo.com/pipes/pipe.info?_id=61096c12df0a4826
a0c39f6b85da0ead</link>
      <pubDate>Wed, 07 Apr 2010 20:44:50 -0700</pubDate>
      <generator>http://pipes.yahoo.com/pipes/</generator>

      <item>
         <title>Walk Safely to School Day (28 kb)</title>
         <link>http://www.dlg.nsw.gov.au/dlg/dlghome/documents/Circulars/10-07.pdf</link>
         <description>Circular, Ref : 10-07</description>
         <guid isPermaLink="false">http://www.dlg.nsw.gov.au/dlg/dlghome/documents/Circulars/10-07.pdf</guid>
         <pubDate>Tue, 06 Apr 2010 17:00:00 -0700</pubDate>
         <media:thumbnail url="http://www.dlg.nsw.gov.au/images/dlglogo.gif"/>
         <category>DLG</category>
      </item>
      <item>
         <title>Characteristics Of Candidates And Councillors 2008 (38 kb)</title>
         <link>http://www.dlg.nsw.gov.au/dlg/dlghome/documents/Circulars/10-06.pdf</link>
         <description>Circular, Ref : 10-06</description>
         <guid isPermaLink="false">http://www.dlg.nsw.gov.au/dlg/dlghome/documents/Circulars/10-06.pdf</guid>
         <pubDate>Thu, 04 Mar 2010 16:00:00 -0800</pubDate>
         <media:thumbnail url="http://www.dlg.nsw.gov.au/images/dlglogo.gif"/>
         <category>DLG</category>
      </item>
      <item>
         <title>Updated guidelines on the exercise of functions under CA Act 1998 and Companion Animals Frequently Asked Questions (49 kb)</title>
         <link>http://www.dlg.nsw.gov.au/dlg/dlghome/documents/Circulars/10-05.pdf</link>
         <description>Circular, Ref : 10-05</description>
         <guid isPermaLink="false">http://www.dlg.nsw.gov.au/dlg/dlghome/documents/Circulars/10-05.pdf</guid>
         <pubDate>Thu, 04 Mar 2010 16:00:00 -0800</pubDate>
         <media:thumbnail url="http://www.dlg.nsw.gov.au/images/dlglogo.gif"/>
         <category>DLG</category>
      </item>

   </channel>
</rss>

what have I done wrong?

Question on using event handler with SAX Parsing and DOM

Wed, 17 Feb 2010 19:10:08 -0800

I plan to use SAX parsing for my project. The event handler logic gets complex and not clean when using SAX parsing. I was wondering if it is possible to capture events and create the DOM document for each row we are interested in and parse dom document to capture the information we want at each row end element notification? Can some one shed some light if we can achive this? Please provide your suggestions.

for example if we can create a dom document and add all elements, attributes for the row as events happen for row tag, During end element notification we could use dom methods to get what we want from each row.. If we can achive this that way the event handler would be clean.
<root>
<row>
<id>200</id><name>User1</name>.....
</row>
<row>
...
</row>
</root>

Help with XML file - PLEASE

Mon, 01 Feb 2010 07:30:43 -0800

Below is code for XML Index file:

<logo file="images/logo.png" x_position="-20" y_position="0" />
<menu
button_label = "Home"
module_swf = "slideshow.swf"
module_xml = "xml/slideshow_1.xml"
back_ground_file = ""
overlay_color = "0x151618"
module_color = "0x151618"
item_play_sound = "play"
>
<item
button_label = "Slideshow"
module_swf = "slideshow.swf"
module_xml = "xml/slideshow_2.xml"
back_ground_file = ""
overlay_color = "0x151618"
module_color = "0x151618"
item_link = ""
item_link_target = ""
item_play_sound = "play"
/>
<item
button_label = "Company"
module_swf = "long_text.swf"
module_xml = "xml/long_text.xml"
back_ground_file = ""
overlay_color = "0x151618"
module_color = "0x151618"
item_link = ""
item_link_target = ""
item_play_sound = "play"
/>
<item
button_label = "Services"
module_swf = "services.swf"
module_xml = "xml/services.xml"
back_ground_file = ""
overlay_color = "0x151618"
module_color = "0x151618"
item_link = ""
item_link_target = ""
item_play_sound = "play"
/>
<item
button_label = "News"
module_swf = "news.swf"
module_xml = "xml/news.xml"
back_ground_file = ""
overlay_color = "0x151618"
module_color = "0x151618"
item_link = ""
item_link_target = ""
item_play_sound = "play"
/>
<menu button_label="About us">
<item
button_label = "Staff"
module_swf = "staff.swf"
module_xml = "xml/staff.xml"
back_ground_file = ""
overlay_color = "0x151618"
module_color = "0x151618"
item_link = ""
item_link_target = ""
item_play_sound = "play"
/>
<item
button_label = "Contact"
module_swf = "contact.swf"
module_xml = "xml/contact.xml"
back_ground_file = ""
overlay_color = "0x151618"
module_color = "0x151618"
item_link = ""
item_link_target = ""
item_play_sound = "play"
/>
</menu>
<menu button_label="Galleries">
<item
button_label = "Galleries"
module_swf = "galleries.swf"
module_xml = "xml/galleries.xml"
back_ground_file = ""
overlay_color = "0x151618"
module_color = "0x151618"
item_link = ""
item_link_target = ""
item_play_sound = "play"
/>
<item
button_label = "Gallery"
module_swf = "galleries.swf"
module_xml = "xml/gallery.xml"
back_ground_file = ""
overlay_color = "0x151618"
module_color = "0x151618"
item_link = ""
item_link_target = ""
item_play_sound = "play"
/>
<item
button_label = "Image"
module_swf = "galleries.swf"
module_xml = "xml/image.xml"
back_ground_file = ""
overlay_color = "0x151618"
module_color = "0x151618"
item_link = ""
item_link_target = ""
item_play_sound = "play"
/>
<item
button_label = "Video"
module_swf = "galleries.swf"
module_xml = "xml/video.xml"
back_ground_file = ""
overlay_color = "0x151618"
module_color = "0x151618"
item_link = ""
item_link_target = ""
item_play_sound = "play"
/>
</menu>
<item
button_label = "Downloads"
module_swf = "downloads.swf"
module_xml = "xml/downloads.xml"
back_ground_file = ""
overlay_color = "0x151618"
module_color = "0x151618"
item_link = ""
item_link_target = ""
item_play_sound = "play"
/>
</menu>
<audio auto_start="true" volume_value="70" on_complete="playlist">
<item mp3 = "audio/adg3.com_cloudlessDays.mp3" />
<item mp3 = "audio/adg3.com_chuckedKnuckles.mp3" />
<item mp3 = "audio/adg3.com_bustedChump.mp3" />
<item mp3 = "audio/adg3.com_coreIssues.mp3" />
<item mp3 = "audio/adg3.com_crypticPsyche.mp3" />
<item mp3 = "audio/adg3.com_electroFreak.mp3" />
<item mp3 = "audio/adg3.com_freeForm.mp3" />
</audio>
<footer><![CDATA[<a href="http://h2o-website.blogspot.com/" target="_blank">© h2O Website Design</a>]]></footer>
</index>

I want to bring "About us" just BEFORE 'AUDIO' & AFTER 'Downloads'

My attempt failed resulting in NULL error and Undefined Error

Thanks - MAve

Add Existing node to another node's Child node

Thu, 31 Dec 2009 04:38:31 -0800

Hi there,

I have following XML and i want to transform it to my desire XML using XSLT ,So I need help

Given is My Input XML

<?xml version = '1.0'?>
<ROWSET>
<irp_account num="1">
<IRP_CARRIER_ID_NUMBER>274845</IRP_CARRIER_ID_NUMB ER>
<IRP_ACCOUNT_NUMBER>55002</IRP_ACCOUNT_NUMBER>
</irp_account>
<irp_account num="83">
<IRP_CARRIER_ID_NUMBER>928265</IRP_CARRIER_ID_NUMB ER>
<IRP_ACCOUNT_NUMBER>59897</IRP_ACCOUNT_NUMBER>
<NAME_TYPE>LG</NAME_TYPE>
<NAME>LAMBERT TRUCKING INC</NAME>
<ADDRESS_TYPE>PH</ADDRESS_TYPE>
</irp_account>
<irp_account num="97">
<IRP_CARRIER_ID_NUMBER>957858</IRP_CARRIER_ID_NUMB ER>
<IRP_ACCOUNT_NUMBER>59940</IRP_ACCOUNT_NUMBER>
<NAME_TYPE>LG</NAME_TYPE>
<NAME>SONNY DAVIS INC</NAME>
<ADDRESS_TYPE>MA</ADDRESS_TYPE>
</irp_account>
<irp_account num="98">
<IRP_CARRIER_ID_NUMBER>957858</IRP_CARRIER_ID_NUMB ER>
<IRP_ACCOUNT_NUMBER>59940</IRP_ACCOUNT_NUMBER>
<NAME_TYPE>LG</NAME_TYPE>
<NAME>SONNY DAVIS INC</NAME>
<ADDRESS_TYPE>PH</ADDRESS_TYPE>
</irp_account>
</ROWSET>

With the use of XSLT i want to generate Output XML like this.

<?xml version="1.0"?>
<T0020>
<IRP_ACCOUNT>
<IRP_CARRIER_ID_NUMBER>274845</IRP_CARRIER_ID_NUMB ER>
<IRP_ACCOUNT_NUMBER>55002</IRP_ACCOUNT_NUMBER>
<IRP_NAME>
<NAME_TYPE>LG</NAME_TYPE>
<NAME>A P SUPPLY CO</NAME>
<IRP_ADDRESS>
<ADDRESS_TYPE>PH</ADDRESS_TYPE>
</IRP_ADDRESS>
<IRP_ADDRESS>
<ADDRESS_TYPE>MA</ADDRESS_TYPE>
</IRP_ADDRESS>
</IRP_NAME>
</IRP_ACCOUNT>
</T0020>

I have tried below XSLT but it is not giving desire result

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/ROWSET">
<xsl:element name="T0020">
<xsl:apply-templates select="irp_account"/>
</xsl:element>
</xsl:template>
<xsl:template match="irp_account">
<xsl:element name="IRP_ACCOUNT">
<xsl:apply-templates select="IRP_CARRIER_ID_NUMBER"/>
<xsl:apply-templates select="IRP_ACCOUNT_NUMBER"/>
<xsl:apply-templates select="IRP_ACCOUNT_TYPE"/>
<xsl:apply-templates select="NAME_TYPE"/>
<xsl:apply-templates select="ADDRESS_TYPE"/>
</xsl:element>
</xsl:template>
<xsl:template match="IRP_CARRIER_ID_NUMBER">
<xsl:copy-of select="descendant-or-self::IRP_CARRIER_ID_NUMBER"/>
</xsl:template>
<xsl:template match="IRP_ACCOUNT_NUMBER">
<xsl:copy-of select="descendant-or-self::IRP_ACCOUNT_NUMBER"/>
</xsl:template>
<xsl:template match="IRP_ACCOUNT_TYPE">
<xsl:copy-of select="descendant-or-self::IRP_ACCOUNT_TYPE"/>
</xsl:template>
<xsl:template match="NAME_TYPE">
<xsl:element name="IRP_NAME">
<xsl:copy-of select="descendant-or-self::NAME_TYPE"/>
<xsl:copy-of select="following-sibling::NAME"/>
</xsl:element>
</xsl:template>
<xsl:template match="ADDRESS_TYPE">
<xsl:element name="IRP_ADDRESS">
<xsl:copy-of select="descendant-or-self::ADDRESS_TYPE"/>
<xsl:copy-of select="following-sibling::NAME"/>
</xsl:element>
</xsl:template>
</xsl:stylesheet>

Please help ....

Error in XSLT: There are several Java methods that match equally well

Sat, 26 Dec 2009 01:04:41 -0800

while i'm running the below code, I'm getting : "There are several Java methods that match equally well". Can any one solve this problem. Please i need u r help. Thanks in Advance

My XML:--

<?xml version="1.0" encoding="UTF-8"?>
<article1>
<title>kiran Java May Be a Fad</title>
<author>J. Burke</author>
<startdate>25/12/2009</startdate>
<enddate>30/10/2010</enddate>
</article1>

My XSLT:--

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0" xmlns:java="xalan://java.util.GregorianCalendar"
extension-element-prefixes="java">

<xsl:template match="article1">

<xsl:if test="startdate[.!=''] or enddate[.!='']">

<xsl:variable name="startDateCal" select="java:new(.)"/>

<xsl:variable name="sday" select="substring(startdate,1,2)"/>
<xsl:variable name="smonth" select="substring(startdate,4,2)"/>
<xsl:variable name="syear" select="substring(startdate,7,4)"/>
<xsl:variable name="sSetCalender" select="java:startDateCal.set($syear,$smonth,$sday )"/>
<xsl:variable name="sMilliSeconds" select="java:sSetCalender.getTimeInMillis()"/>
<Days>
<xsl:value-of select="$sday"/>
</Days>

</xsl:if>
</xsl:template>

</xsl:stylesheet>

Parameter Value is not Inserted to Database using XSLT.

Wed, 23 Dec 2009 01:59:22 -0800

Hello,
[1] We have XML file as below

MyExample.XML
<?xml version="1.0" encoding="ISO-8859-1"?>
<T0020
xsi:schemaLocation="http://www.safersys.org/namespaces/T0020V1 T0020V1.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.safersys.org/namespaces/T0020V1">
<INTERFACE>
<NAME>SAFER</NAME>
<VERSION>04.02</VERSION>
</INTERFACE>
<TRANSACTION>
<VERSION>01.00</VERSION>
<OPERATION>REPLACE</OPERATION>
<DATE_TIME>2009-09-01T00:00:00</DATE_TIME>
<TZ>CT</TZ>
</TRANSACTION>
<IRP_ACCOUNT>
<IRP_CARRIER_ID_NUMBER>274845</IRP_CARRIER_ID_NUMB ER>
<IRP_BASE_COUNTRY>US</IRP_BASE_COUNTRY>
<IRP_BASE_STATE>AR</IRP_BASE_STATE>
<IRP_ACCOUNT_NUMBER>55002</IRP_ACCOUNT_NUMBER>
<IRP_ACCOUNT_TYPE>I</IRP_ACCOUNT_TYPE>
<IRP_STATUS_CODE>100</IRP_STATUS_CODE>
<IRP_STATUS_DATE>2007-11-06</IRP_STATUS_DATE>
<IRP_UPDATE_DATE>2009-08-03</IRP_UPDATE_DATE>
<IRP_NAME>
<NAME_TYPE>LG</NAME_TYPE>
<NAME>A P SUPPLY CO</NAME>
<IRP_ADDRESS>
<ADDRESS_TYPE>PH</ADDRESS_TYPE>
<STREET_LINE_1>1400 N OATS</STREET_LINE_1>
<STREET_LINE_2/>
<CITY>TEXARKANA</CITY>
<STATE>AR</STATE>
<ZIP_CODE>71854</ZIP_CODE>
<COUNTY>MILLER</COUNTY>
<COLONIA/>
<COUNTRY>US</COUNTRY>
</IRP_ADDRESS>
</IRP_NAME>
</IRP_ACCOUNT>
<IRP_ACCOUNT> ………<IRP_ACCOUNT>
<IRP_ACCOUNT> ………<IRP_ACCOUNT>
</T0020>

[2] we have table MyTable to insert MyExample.XML Data
FILE_NAME VARCHAR2(120)
IRP_ACCOUNT_NUMBER VARCHAR2(32)
IRP_ACCOUNT_TYPE VARCHAR2(1)
IRP_CARRIER_ID_NUMBER VARCHAR2(12)
IRP_BASE_COUNTRY VARCHAR2(12)
IRP_BASE_STATE VARCHAR2(12)
IRP_STATUS_CODE VARCHAR2(12)
IRP_STATUS_DATE VARCHAR2(10)
IRP_UPDATE_DATE VARCHAR2(10)
XCVIEW_SOURCE_DATA VARCHAR2(100)
XCVIEW_PROC_STATUS VARCHAR2(100)
XCVIEW_PROC_TIME TIMESTAMP(6)

[3] so we have applied MyXSLT .xsl to insert data into database (into table MyTable ),our xslt file is as below.
MyXSLT .xsl
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:param name="FILE_NAME" select="T0020/IRP_ACCOUNT/FILE_NAME"/>

<xsl:template match="/">
<xsl:element name="T0020">
<xsl:apply-templates select="* | T0020/IRP_ACCOUNT"/>
</xsl:element>
</xsl:template>
<xsl:template match="*">
<xsl:element name="{local-name()}">
<xsl:apply-templates select="@* | node()"/>
</xsl:element>
</xsl:template>
<xsl:template match="@* | text()">
<xsl:copy/>
</xsl:template>

<xsl:template match="T0020/IRP_ACCOUNT">
<xsl:element name="IRP_ACCOUNT">
<xsl:element name="FILE_NAME">
<xsl:value-of select="$FILE_NAME"/>
</xsl:element>
<xsl:element name="IRP_CARRIER_ID_NUMBER">
<xsl:value-of select="IRP_CARRIER_ID_NUMBER"/>
</xsl:element>
<xsl:element name="IRP_BASE_COUNTRY">
<xsl:value-of select="IRP_BASE_COUNTRY"/>
</xsl:element>
<xsl:element name="IRP_BASE_STATE">
<xsl:value-of select="IRP_BASE_STATE"/>
</xsl:element>
<xsl:element name="IRP_ACCOUNT_NUMBER">
<xsl:value-of select="IRP_ACCOUNT_NUMBER"/>
</xsl:element>
<xsl:element name="IRP_ACCOUNT_TYPE">
<xsl:value-of select="IRP_ACCOUNT_TYPE"/>
</xsl:element>
<xsl:element name="IRP_STATUS_CODE">
<xsl:value-of select="IRP_STATUS_CODE"/>
</xsl:element>
<xsl:element name="IRP_STATUS_DATE">
<xsl:value-of select="IRP_STATUS_DATE"/>
</xsl:element>
<xsl:element name="IRP_UPDATE_DATE">
<xsl:value-of select="IRP_UPDATE_DATE"/>
</xsl:element>
</xsl:element>

</xsl:template>

</xsl:stylesheet>

[4] We are insert xml data to database using oracleXMLSave.insert utility for which we have set parameter file name
By oracleXMLSave.setXSLTParam(“FILE_NAME”,”mystestfil e”).

Only FILE_NAME Column is value is not coming into the Database.

please help...if you need more details then i can provide...

XML Template

Thu, 17 Dec 2009 05:47:58 -0800

Hi - i;ve managed to get hold a lovely XML Template. Unfortunately, it does'nt have 'Deep Linking' facility. Are there any XML Pros who can help me create 'Deep Linking' in the template

Mave

XSLT logic some dependent records

Tue, 15 Dec 2009 15:42:17 -0800

Hi All,

Am new to XSLT and trying to write some xslt which is having 1st record as the header,2nd record as the status and 3rd records as the trainings and all these 3 records can be occured n numbers of time, we want that fixed length file need to be converted into xml file, below is the simple input and out file should look like.

Sample Input is :

H123
S111SE
Tjavaasp
H231
S112SA
Tjavaaix

Output should be like below with above Input :

-<Information>
- <organization>
<id>123</id>
- <employee-status>
<employee-id>111</employee-id>
<employee-designation>SE</employee-designation>
</employee-status>
- <employee-trainings>
<employee-training1>java</employee-training1>
<employee-training2>asp</employee-training2>
</employee-trainings>
</organization>
- <organization>
<id>231</id>
- <employee-status>
<employee-id>112</employee-id>
<employee-designation>SA</employee-designation>
</employee-status>
- <employee-trainings>
<employee-training1>java</employee-training1>
<employee-training2>aix</employee-training2>
</employee-trainings>
</organization>
</Information>

In the above example we can distungish between record with first character of each record. I have tried but not able to getting the perfect logic.

Can any one plese help on getting this done. as this is urgent requirement for me.

Draw time limit with xslt 2.0 help

Fri, 11 Dec 2009 07:30:19 -0800

Hi,

I have a multiple xslt process.

I would like to divide a group, for example the party that start between
00:00:00 - 10:00:00 called as "Group A"
10:00:00 - 14:00:00 will call as "Group B"
or 14:00:00 - 20:00:00 will call as "Group C"

and I would like to record the "number" attribute where is start and end the party_group element can be anywhere, doesn't have to be at the beginning.

I'm also not sure how to do if time gt than 10:00:00 and less than 14:00:00 :confused:

So I was thinking to create another variable including the "start" element within phase1, therefore I can group by "start" date after I created the "number" then remove "start" element to get the final result. Not sure how to remove the element though :confused:

Will this be possible to do? I'm confused how to keep the start and end number. I hope someone can give me some tips. Thanks so much

Here is my input

<parties>
    <events>
        <event id="a">
            <type>dance party</type>
            <title>80s</title>
            <start>2009-12-01T00:28:30</start>
        </event>
        <event id="b">
            <type>cocktail party</type>
            <title>Flower Garden</title>
            <start>2009-12-01T10:09:34</start>
        </event>
        <event id="c">
            <type>cocktail party</type>
            <title>Prewedding party</title>
            <start>2009-12-01T14:30:34</start>
        </event>
        <event id="d">
            <type>kids party</type>
            <title>Fairy Party</title>
            <start>2009-12-01T20:00:00</start>
        </event>
        <event id="e">
            <type>kids party</type>
            <title>Animals Party</title>
            <start>2009-12-01T20:05:00</start>
        </event>
    </events>
</parties>

I would like my final result look like this

<mypartiescollection Version="1.1">
   <party_group name="Group A" fromNumber="1" toNumber="1"/>
    <party_group name="Group B" fromNumber="2" toNumber="3"/>
   <party_group name="Group C" fromNumber="4" toNumber="6"/>
    <dance_party number="1" id="a">
        <title>80s</title>
    </dance_party>
    <cocktail_party number="2" id="b">
        <title>Flower Garden</title>
    </cocktail_party>
    <cocktail_party number="3" id="c">
        <title>Prewedding party</title>
    </cocktail_party>
    <comment message="my comment" number="4"/>
    <kids_party number="5" id="d">
        <title>Fairy Party</title>
    </kids_party>
<comment message="my comment" number="5"/>
    <kids_party number="6" id="e">
        <title>Animals Party</title>
    </kids_party>
</mypartiescollection>

I have a multi phase xslt, the reason is so that I can put the number.

phase1.xslt

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:fn="http://www.w3.org/2005/xpath-functions">
        <xsl:output method="xml" indent="yes"/>
        <xsl:template match="/" mode="phase1">
                <xsl:element name="mypartiescollection">
                       <xsl:attribute name="Version">1.1</xsl:attribute>
           <xsl:apply-templates/>
                </xsl:element>
    </xsl:template>
    
        <xsl:template match="event">
       <xsl:if test="type='dance party'">
          <xsl:element name="dance_party">
          <xsl:attribute name="id"><xsl:value-of select="@id"/></xsl:attribute>
                          <xsl:element name="title">
               <xsl:value-of select="title"/>
                          </xsl:element>
                <xsl:element name="start">
                    <xsl:value-of select='start'/>
                </xsl:element>
            </xsl:element>
        </xsl:if>
        <xsl:if test="type = 'cocktail party'">
            <xsl:element name="cocktail_party">
                <xsl:attribute name="id"><xsl:value-of select='@id'></xsl:value-of></xsl:attribute>
                <xsl:element name="title">
                    <xsl:value-of select='title'/>
                </xsl:element>
                <xsl:element name="start">
                    <xsl:value-of select='start'/>
                </xsl:element>
            </xsl:element>
        </xsl:if>
        <xsl:if test="type = 'kids party'">
<xsl:element name="comment>
     <xsl:attribute name="message"/>my comment</xsl:attribute>
</xsl:element>
            <xsl:element name="kids_party">
                <xsl:attribute name="id"><xsl:value-of select='@id'></xsl:value-of></xsl:attribute>
                <xsl:element name="title">
                    <xsl:value-of select='title'/>
                </xsl:element>     
                <xsl:element name="start">
                    <xsl:value-of select='start'/>
                </xsl:element>
            </xsl:element>
        </xsl:if>
    </xsl:template>
</xsl:stylesheet>

my phase 1 result before having "number" attribute

<mypartiescollection Version="1.1">
    <dance_party id="a">
        <title>80s</title>
        <start>2009-12-01T00:28:30</start>
    </dance_party>
    <cocktail_party id="b">
        <title>Flower Garden</title>
        <start>2009-12-01T10:09:34</start>
    </cocktail_party>
    <cocktail_party id="c">
        <title>Prewedding party</title>
        <start>2009-12-01T14:30:34</start>
    </cocktail_party>
    <comment message="my comment" />
    <kids_party number="5" id="d">
        <title>Fairy Party</title>
        <start>2009-12-01T20:00:00</start>
   </kids_party>
   <comment message="my comment"/>
    <kids_party number="7" id="e">
        <title>Animals Party</title> 
        <start>2009-12-01T20:05:00</start>
    </kids_party>
</mypartiescollection>

phase2.xslt

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:fn="http://www.w3.org/2005/xpath-functions">
    <xsl:import href="test.xslt"/>
    <xsl:output method="xml" indent="yes"/>
    
    <xsl:variable name="data">
        <xsl:apply-templates select="/" mode="phase1"/>
    </xsl:variable>
    
    <xsl:template match="/">
        <xsl:variable name="data2">
        <xsl:apply-templates select="$data" mode="phase2"/>
    </xsl:variable>        
        <xsl:apply-templates select="$data2" mode="group"/>
    </xsl:template>

    <xsl:template match="/" mode="group">
        <xsl:for-each-group select="//dance_party|//cocktail_party|//kids_part
y" group-by="f:party-group(xs:time(xs:dateTime(start)))"> 

    
<!--I'm not so sure about this part. somehow this part have error of "An empty sequence is not allowed as the first argument of f:party_group()
-->
              <party_group name="{current-grouping-key()}"
                      fromNumber="{min(current-group()/number)}"
                       toNumber="{max(current-group()/number)}"
                       />
        </xsl:for-each-group>
    </xsl:template>

    
    <xsl:function name="f:party-group" as="xs:string">
       <xsl:param name="start-time" as="xs:time"/>
       <xsl:sequence select="if ($start-time gt xs:time('10:00:00')) then 'Group B' else 'Group A'"/>
       <!-- I'm also not sure how to do if time gt than 10:00:00 and less than 14:00:00 -->
    </xsl:function>
    
    <xsl:template match="mypartiescollection" mode="phase2">
    <xsl:copy>
        <xsl:copy-of select="@*"/>
        <xsl:apply-templates select="node()" mode="phase2"/>
    </xsl:copy>
    </xsl:template>
    
 <xsl:template match="dance_party|cocktail_party|kids_party" mode="phase2" name="party_collection">
  <xsl:copy>
    <xsl:attribute name="number">
       <xsl:number count="dance_party|cocktail_party|kids_party"/>
    </xsl:attribute>
    <xsl:copy-of select="@* | node()"/>
  </xsl:copy>
</xsl:template>
</xsl:stylesheet>

data2 result. after I generate the number.

<mypartiescollection Version="1.1">
    <dance_party number="1" id="a">
        <title>80s</title>
        <start>2009-12-01T00:28:30</start>
    </dance_party>
    <cocktail_party number="2" id="b">
        <title>Flower Garden</title>
        <start>2009-12-01T13:09:34</start>
    </cocktail_party>
    <cocktail_party number="3" id="c">
        <title>Prewedding party</title>
        <start>2009-12-01T13:30:34</start>
    </cocktail_party>
    <comment message="my comment" number="4" />
    <kids_party number="5" id="d">
        <title>Fairy Party</title>
        <start>2009-12-01T20:00:00</start>
   </kids_party>
   <comment message="my comment" number="6"/>
    <kids_party number="7" id="e">
        <title>Animals Party</title> 
        <start>2009-12-01T20:05:00</start>
    </kids_party>
</mypartiescollection>

Need help with xslt

Wed, 02 Dec 2009 15:03:53 -0800

Hi,

I need some help in xslt. I am trying to develop a xslt , I have pasted the short format of all 3 files below, The Input xml file. The xslt and output xml.
I will be very great full If anybody can help. I have tried everything but no luck. I am using @@@@ for comment or to explain in below files.

If you see my xml file I have 2 section in the xml <Partcase1> and <Testlot>

From the <Case1row> i want last 3 rows of data. But not from the first module , I want the data from second section of <Case1row>
example : (63,3,PASS) and (62,3,PASS) @@@@@@@@@@---these are located in property/data see below-Last2 sections in <case1row>--@@@@@@@@@@@@@@

I want these 3 values to be picked up and show in my output xml for parameters.

Example output :

<Parameters>
<Parameter>
<unit>m</unit>
<Value>63</Value>
<code>728</code>
</Parameter>
<Parameter>
<unit>ul</unit>
<Value>3</Value>
<code>137</code>
</Parameter>
<Parameter>
<unit>in</unit>
<Value>PASS</Value>
<code>1526</code>
</Parameter>
</Parameters>
<Parameters>
<Parameter>
<unit>SQ</unit>
<measurementValue>62</measurementValue>
<code>728</code>
</Parameter>
<Parameter>
<unit>MT</unit>
<Value>3</Value>
<code>137</code>
</Parameter>
<Parameter>
<unit>LT</unit>
<Value>FAIL</Value>
<code>1526</code>
</Parameter>
</Parameters>

You can see in above example If I am taking the Units from my 2nd section of xml <testlot>
and I want to take the <<value>> from 1st section of input xml <Case1row> and <<Code>> as you can see I hardcoded it in xslt.

Can anybody help me out with this

@@@@@@@@@@@@@@----My XML File : @@@@@@@@@@@@@@@@

<xml>
<parent>
<certificate>
<content>
<block >
<partcase1>
<case1>
<case1data>
<case1row >
<property><data> LNumber: </data></property>
<property><data> Date: </data></property>
<property><data>Reading</data></property>
<property><data>Disk</data></property>
<property><data>Thickness</data></property>
</case1row >
<case1row >
<property><data> A1 </data></property>
<property><data> 09/03/2009 </data></property>
<property><data>63</data></property>
<property><data>3</data></property>
<property><data>PASS</data></property>
</case1row >
<case1row >
<property><data> A0 </data></property>
<property><data> 09/03/2009 </data></property>
<property><data>62</data></property>
<property><data>3</data></property>
<property><data>FAIL</data></property>
</case1row >
</case1data>
</case1>
</partcase1>
</block>
<testlot>
<lnumber>
<label>LNumber:</label>
<value>A1</value>
<datelabel>Date</datelabel>
<date>09/03/2009</date>
</lnumber>
<aggheader>
<name>Property</name>
<units>Units</units>
<results>Results</results>
</aggheader>
<aggdata>
<namevalue>Reading</namevalue>
<units>m</units>
</aggdata>
<aggdata>
<namevalue>Disk</namevalue>
<units>ul</units>
</aggdata>
<aggdata>
<namevalue>Thickness</namevalue>
<units>in</units>
</aggdata>
</testlot>
<testlot>
<lnumber>
<label>Lnumber</label>
<value>A0</value>
<datelabel>Date</datelabel>
<date>09/03/2009</date>
</lnumber>
<aggheader>
<name>Test Property</name>
<units>Units</units>
<results>Results</results>
</aggheader>
<aggdata>
<namevalue>Reading</namevalue>
<units>SQ</units>
</aggdata>
<aggdata>
<namevalue>Disk</namevalue>
<units>MT</units>
</aggdata>
<aggdata>
<namevalue>Thicknessk</namevalue>
<units>LT</units>
</aggdata>
</testlot>
</content>
</certificate>
</parent>
</xml>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ XSLT File : ----------@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="xml" encoding="utf-8" omit-xml-declaration="no" indent="yes" />
<xsl:template match="/">
<xsl:element name="File" namespace="x-schema:../Schema/QualityCertificateSchema2001Jul.x ml">
<xsl:element name="Sites" namespace="x-schema:../Schema/Certificateschema2001Jul.xml">
<xsl:element name="Description" namespace="x-schema:../Schema/Certificateschema2001Jul.xml">
<xsl:element name="Certificates" namespace="x-schema:../Schema/Certificateschema2001Jul.xml">
<xsl:for-each select="//testlot">
<xsl:variable name="LotNode" select="." />
<xsl:variable name="Lot" select="./lotnumber/value" />
<xsl:element name="Certificate" namespace="x-schema:../Schema/Certificateschema2001Jul.xml">
<xsl:element name="Parameters" namespace="x-schema:../Schema/Certificateschema2001Jul.xml">
<xsl:for-each select="$LotNode/aggregatedresultsdata">
<xsl:variable name="PropertyNode" select="." />
<xsl:variable name="PropertyName" select="$PropertyNode/namevalue" />
<xsl:element name="Parameter" namespace="x-schema:../Schema/Certificateschema2001Jul.xml">
<xsl:element name="unit" namespace="x-schema:../Schema/Certificateschema2001Jul.xml">
<xsl:value-of select="units" />
</xsl:element>
<xsl:element name="measurementValue" namespace="x-schema:../Schema/Certificateschema2001Jul.xml">
<xsl:variable name="aggdisp" select="//testlot/@aggrDisp"/>
<xsl:variable name="data1" select="//partcase1/case1/case1data/case1row"/>
<xsl:variable name="data2" select="//partcase2/case1/case1data/case1row"/>
<xsl:variable name="data3" select="//partcase3/case1/case1data/case1row"/>
<xsl:variable name="data4" select="//partcase4/case1/case1data/case1row"/>
<xsl:variable name="Code1" select="$PropertyNode/namevalue" />
<xsl:variable name="datalot1" select="$data1/property/data[. mod 2=1][1]"/>
<xsl:variable name="datalot2" select="$data2/property/data[. mod 3=2][1]"/>
<xsl:variable name="datalot3" select="$data3/property/data[. mod 4=2][1]"/>
<xsl:choose>
<xsl:when test="$Code1='Reading'"><xsl:value-of select="$datalot1"/></xsl:when>
<xsl:when test="$Code1='Disk'"><xsl:value-of select="$datalot2"/></xsl:when>
<xsl:when test="$Code1='Thickness'"><xsl:value-of select="$datalot3"/></xsl:when>
<xsl:otherwise>
<xsl:value-of select="$Code1" />
</xsl:otherwise>
</xsl:choose>
</xsl:element>
<xsl:element name="code" namespace="x-schema:../Schema/Certificateschema2001Jul.xml">
<xsl:variable name="code_agg" select="$PropertyNode/namevalue" />
<xsl:choose>
<xsl:when test="$code_agg='Property'">test</xsl:when>
<xsl:when test="$code_agg='Flatness'">728</xsl:when>
<xsl:when test="$code_agg='Disk'">137</xsl:when>
<xsl:when test="$code_agg='Thickness'">1526</xsl:when>
<xsl:otherwise>
</xsl:otherwise>
</xsl:choose>
</xsl:element>
</xsl:element>
</xsl:for-each>
</xsl:element>
</xsl:element>
</xsl:for-each>
</xsl:element>
</xsl:element>
</xsl:element>
</xsl:element>
</xsl:template>
</xsl:stylesheet>

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ ---Output file----@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@
I am looking for the output like this

<?xml version="1.0" encoding="utf-8"?>
<File xmlns="x-schema:../Schema/QualityCertificateSchema2001Jul.x ml">
<Sites>
<Description>
<manufacturerNumber>006173082</manufacturerNumber>
<Certificates>
<certificate="Single">
<Description>
<pName>MA</pName>
<Part>1519-8</Part>
<Order>A_A1</Order>
<lNumber>A1</lNumber>
</Description>
<Parameters>
<Parameter>
<unit>m</unit>
<measurementValue>1</measurementValue>
<code>728</code>
</Parameter>
<Parameter>
<unit>ul</unit>
<Value>68</Value>
<code>137</code>
</Parameter>
<Parameter>
<unit>in</unit>
<Value>2</Value>
<code>1526</code>
</Parameter>
</Parameters>
<Parameters>
<Parameter>
<unit>m</unit>
<measurementValue>1</measurementValue>
<code>728</code>
</Parameter>
<Parameter>
<unit>ul</unit>
<Value>68</Value>
<code>137</code>
</Parameter>
<Parameter>
<unit>in</unit>
<Value>2</Value>
<code>1526</code>
</Parameter>
</Parameters>
</Certificate>
</Certificates>
</Description>
</Sites>
</File>

& character needed in URL link from XML file

Fri, 13 Nov 2009 06:00:54 -0800

Hi,

New to this forum but I was hoping somebody could help me...

I have an XML file controlling links from a flash file.

I need the XML file to return a URL containing the & character without encoding it to &

The XML reads as follows...

<?xml version="1.0" encoding="iso-8859-1"?>
<content>
<image>
<path><![CDATA[http://www.Domain.co.uk/UserFiles/Image/DoorsFlash/Amazonas.jpg]]></path>
<description><![CDATA[Amazonas]]></description>
<data><![CDATA[http://www.Domain.co.uk/default.aspx?page=83&HasProvider=Y&ProviderType=Node&Pr oviderID=825]]></data>
</image>
</content>

The URL in the <data> tags is being returned as...
http://www.Domain.co.uk/default.aspx?page=83&HasProvider=Y&ProviderType=Node&Provider ID=825

Because the & characters are being replaced with & the URL is incorrect!

Is there any way of making the XML file to return the link without replacing the & characters?

Any help would be greatly appreciated! :o)

Thanks,
Bruce!

GETTING COUNT AND POSITION using XSLT 1.0

Tue, 18 Aug 2009 06:53:26 -0800

Hi Guys,

Here is my requirement.

sample XML

<root>
<item>
...
<data name="x">...</data>
<data name="title">uday</data>
<data name="y">...</data>
....
</item>
<item>
...
<data name="x">...</data>
<data name="title">uday</data>
<data name="y">...</data>
....
</item>
<item>
...
<data name="x">...</data>
<data name="title">bhaskar</data>
<data name="y">...</data>
....
</item>
<item>
...
<data name="x">...</data>
<data name="title">bhaskar</data>
<data name="y">...</data>
....
</item>

<item>
...
<data name="x">...</data>
<data name="title">bhaskar</data>
<data name="y">...</data>
....
</item>

Desired o/p XML

<rss>
<item>
..
<position>1</position>
<total>2</total>
....
</item>
<item>
..
<position>2</position>
<total>2</total>
....
</item>
<item>
..
<position>1</position>
<total>3</total>
....
</item>
<item>
..
<position>2</position>
<total>3</total>
....
</item>
<item>
..
<position>3</position>
<total>3</total>
....
</item>
</rss>

for each item in the input xml, we get item in the output.
total represents the no. of items with the same title value
position represents the position of the item with a paticular title.

Iam using xslt 1.0. I guess it is possible by using keys.Can someone help me out please

Thanks you in advance
Uday

XSLT - Newbie up to his arm pits

Fri, 14 Aug 2009 17:15:49 -0800

Ok I'm trying to develop my first dynamic page with a XML feed. The code below works to display the first record of the file, then I moved on to have all records displaying and it all fall in a heap.

With a

"SAXParseException: Expected end of tag 'table' (Untitled-6.xsl, line 72, column 3)"

error message. The line it refers to is </xsl:for-all> which I thought was the correct code to cycle through and display all record in the table.

Can anyone assist me in identifying where this is falling over.

Micheal

Code

<table width="1500" border="1" cellpadding="2">
<tr bgcolour="#9acd32">
<th>Class</th>
<th>Co Drivers first Name</th>
<th>Co Driver Surname</th>
<th>Nationality </th>
<th>Drivers First name </th>
<th>Driver Surname</th>
<th>Entrant</th>
<th>Group</th>
<th>Manufacturer</th>
<th>Nat</th>
<th>No</th>
<th>Priority</th>
<th>Vehicle</th>
</tr>
<xsl:for-each select="main/entry"/>
<tr>
<td><xsl:value-of select="main/entry/@class" /></td>
<td><xsl:value-of select="main/entry/@coDriverName" /></td>
<td><xsl:value-of select="main/entry/@coDriverSurname" /></td>
<td><xsl:value-of select="main/entry/@coNat" /></td>
<td><xsl:value-of select="main/entry/@driverName"/></td>
<td><xsl:value-of select="main/entry/@driverSurname"/></td>
<td><xsl:value-of select="main/entry/@entrant"/></td>
<td><xsl:value-of select="main/entry/@group"/></td>
<td><xsl:value-of select="main/entry/@manufacturer"/></td>
<td><xsl:value-of select="main/entry/@nat"/></td>
<td><xsl:value-of select="main/entry/@no"/></td>
<td><xsl:value-of select="main/entry/@priority"/></td>
<td><xsl:value-of select="main/entry/@vehicle"/></td>
</tr>
</xsl:for-all>
</table>