XML Development Forum RSS Feed (Replies Included)

Problem in transforming SOAP message to XML using XSLT

Thu, 14 Feb 2013 15:09:33 -0700

Hi

Here is my XSLT for the SOAP Response given after the below. I am not getting any output. Please help where is the issue?
----------------------------------------------------
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

<xsl:template match="/">
<SyncSolarInvoiceToBp>
<ApplicationArea>
<Sender>
<LogicalID>infor.database.cmd_db</LogicalID>
<ConfirmationCode>OnError</ConfirmationCode>
<ComponentID>External</ComponentID>
</Sender>
<CreationDateTime></CreationDateTime>
<BODID></BODID>
</ApplicationArea>
<DataArea>
<Sync>
<TenantID>SOLAR</TenantID>
<AccountingEntityID/>
<LocationID/>
<ActionCriteria/>
</Sync>
<xsl:for-each select="//s:Body/ExecuteMultipleOperationsResponse /Operations/Operation">
<SolarInvoiceToBp>
<AddressType><xsl:value-of select="Object/ObjectReference/AddressType"/></Add ressType>
<CMDID><xsl:value-of select="Object/ObjectReference/CMDID"/></CMDID>
<WFMKey><xsl:value-of select="Object/ObjectReference/@Key"/></WFMKey>
<Region/>
<District/>
<Action/>
<InvoiceToBp/>
<ParentBp/>
<Country>
<CountryCode/>
<Customer>
<PostalCode/>
<Street/>
<CityDescr/>
<StateCode/>
<RPStatusID/>
<Latitude/>
<Longitude/>
<LocationName/>
</Customer>
</Country>
</SolarInvoiceToBp>
</xsl:for-each>
</DataArea>
</SyncSolarInvoiceToBp>
</xsl:template>
</xsl:stylesheet>

----------------------------------------------
My SOAP response is as shown below

-----------------------------------------------
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Header/>
<s:Body>
<ExecuteMultipleOperationsResponse xmlns="http://www.clicksoftware.com">
<Operations>
<Operation xmlns:d3p1="http://www.w3.org/2001/XMLSchema-instance" d3p1:type="SucceededOperation">
<Action>Create</Action>
<Object>
<ObjectReference DisplayString="" Key="257849395" d3p1:type="SolarAddressReference">
<AddressType DisplayString="Invoice To" Key="127543298">Invoice To</AddressType>
<CMDID>59549</CMDID>
</ObjectReference>
</Object>
</Operation>
</Operations>
<Warnings xmlns="">
<Warning>
<Number>1003</Number>
<Description>No revision specified , default is used</Description>
</Warning>
</Warnings>
</ExecuteMultipleOperationsResponse>
</s:Body>
</s:Envelope>
-----------------------------------------------

what programming language to learn to make renderning script

Wed, 23 Jan 2013 13:13:15 -0700

Dear All,

I want to make script or program help me to import XML balance sheet with specific ordering and calculation

and rendering it , on the new ordering and calculation I assign in the code then export it

all based on XML codes

so would you tell me what language to learn to make that?? using script or program? and guess will need SQL so please want to tell what to learn exactly

for example"

Co. A calculate

Profit = revenues - Expenses

and revenues ( goods sold - cost of goods sold depending on X method)
expenes ( e.g. selling and administrative expenses)

co. B calculate
Profit = revenues - Expenses

and revenues ( goods sold - cost of goods sold depending on Y method)
expenes ( e.g. selling expenses ONLY)

so I want to import that READY XML file equation and rendering it so I made Co. A profit be calculated like Co. B profit means
convert X method to Y method
and Deduct the Administrative Expenses
and export it with the same original file extension XML

so What to learn to help me to do that??

XML Schema Validation issues

Mon, 17 Dec 2012 02:46:10 -0700

Hi

I need some help regarding XML Schema Validation.

I am struck with XSD validation issues when I try to reference other schema in base schema.

I am getting the error message "src-resolve: Cannot resolve the name 'cmn:MasterNode' to a(n) 'type definition' component."

Stripped Version of Schema Design is listed below

1. Base Schema file (v21.xsd) references element "MasterNode" of the schema v2_refer.xsd . On validation of schema , gets the error message as listed above
<xs:schemaattributeFormDefault="unqualified"
elementFormDefault="qualified"
xmlns:cmn="file:///Users/tarun/schema/v2refer/v2_r efer"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
targetNamespace="file:///Users/tarun/schema">

<xs:importnamespace="file:///Users/tarun/schema/v2 refer/v2_refer"schemaLocation="/Users/tarun/schema /v2refer/v2_refer.xsd"/>

<xs:elementname="TestMaster"type="cmn:MasterNode">< ;/xs:element>
<xs:elementname="ROOT">

<xs:complexType>
<xs:sequence>
<xs:elementname="NOD">
<xs:complexType>
<xs:sequence>
<xs:elementname="Nod"maxOccurs="10">

</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

2) Schema that is being referenced is defined below
<xs:schemaattributeFormDefault="unqualified"elemen tFormDefault="qualified"
targetNamespace="file:///Users/tarun/schema/v2refe r/v2_refer"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:cmn="file:///Users/tarun/schema/v2refer/v2_r efer"
>
<xs:elementname="MasterNode">
<xs:complexType>
<xs:sequence>
<xs:elementtype="xs:string"name="Tomcat"/>
</xs:sequence>
</xs:complexType>
</xs:element>

</xs:schema>

Any help will be highly appreciated.

Thanks,
Tarun

How to call a XML in XSL by giving relative reference instead of absol

Thu, 12 Apr 2012 00:19:33 -0700

In following code in xsl as follows:

<xsl:variable name="OrgCode"><xsl:value-of select="document('C:\Documents and
Settings\Administrator\Value.xml')

Instead of using this absolute reference, want to call Value.xml by giving relative reference.

help would be appreciated

thank u

How to call a XML in XSL by giving relative reference instead of absol

Wed, 11 Apr 2012 23:59:45 -0700

Urgent:

In following code in xsl as follows:

<xsl:variable name="OrgCode"><xsl:value-of select="document('C:\Documents and
Settings\Administrator\Value.xml')

Instead of using this absolute reference, want to call Value.xml by giving relative reference.

help would be appreciated

thank u

(to delete please)Need help PHP -> XML (then maybe>mysql)

Fri, 06 Apr 2012 02:08:08 -0700

sorry to delete please

Need help PHP -> XML (then maybe>mysql)

Fri, 06 Apr 2012 01:56:20 -0700

Hi everyone,

I'm working as a network system administrator and I do realize that I have too many troubles in PHP and XML.

Thus, could someone help me to extract only few information from an PHP tread to XML. OS is win7 or xp.

It consists to load my php website through Wamp for exemple (only 600ko), then I will need just 5 or 6 information to be displayed in an external XML file.

Maybe, you could help me through Teamviewer remote control access for a while...

Thank you so much for your help coming.

Attachment: system_info.zip (611974 bytes | downloaded 75 times)

XSLT nestled for-each problem

Thu, 22 Mar 2012 03:49:55 -0700

Hi,
I have a problem with a nestled "for-each". I want information from every orditem. Every orderitem have one "orderitem id" and could have several "job id". The sample belove do not work,any suggestions?

XML

<order orderid="20">
  <workflows>
    <workflow id="97"
      <items>
        <orderitem id="1">
          <jobs>
            <job id="150"/>
            <job id="151"/>
          </jobs>
        </orderitem>
      </items>
    </workflow>
    <workflow id="97">
      <items>
        <orderitem id="2">
          <jobs>
            <job id="152"/>
          </jobs>
        </orderitem>
      </items>
    </workflow>
  </workflows>
</order>

XSLT

 <xsl:for-each select="//items/orderitem[@id != '0']">
          <xsl:value-of select="@item-number"/>
	  <xsl:for-each select="/order/jobs/job">
            <xsl:value-of select="@id"/>
          </xsl:for-each>
    </xsl:for-each>

I want the output to be:
1 150 151
2 152

Kind regards / trady

XSLT nestled for-each problem

Thu, 22 Mar 2012 03:45:43 -0700

<order orderid="20">
  <workflows>
    <workflow id="97"
      <items>
        <orderitem id="1">
          <jobs>
            <job id="150"/>
            <job id="151"/>
          </jobs>
        </orderitem>
      </items>
    </workflow>
    <workflow id="97">
      <items>
        <orderitem id="2">
          <jobs>
            <job id="152"/>
          </jobs>
        </orderitem>
      </items>
    </workflow>
  </workflows>
</order>

XSLT

 <xsl:for-each select="//items/orderitem[@id != '0']">
          <xsl:value-of select="@item-number"/>
	  <xsl:for-each select="/order/jobs/job">
            <xsl:value-of select="@id"/>
          </xsl:for-each>
    </xsl:for-each>

I want the output to be:
1 150 151
2 152

Kind regards / trady

XSL Formatting Help Needed

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

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 -0700

Need help to compare two sets of nodes in xsl

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

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 -0700

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>

Re: XML vs database

Fri, 02 Dec 2011 03:17:41 -0700

Nice information about XML vs database, thanks for sharing.....

Coupon Codes
Coupon Codes

Re: XML vs database

Fri, 02 Dec 2011 03:15:07 -0700

Nice information about XML vs database, thanks for sharing.....

Coupon Codes
Coupon Codes

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

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

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 -0700

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 -0700

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 -0700

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

Re: XML DTD Assistance

Sat, 23 Oct 2010 23:32:44 -0700

how to generate XML to another programming language ????

XML DTD Assistance

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

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 -0700

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 -0700

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 -0700

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 -0700

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?