This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes Websphere and the fly likes xml to xslt... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "xml to xslt..." Watch "xml to xslt..." New topic
Author

xml to xslt...

AshMir Anil
Greenhorn

Joined: Jun 23, 2006
Posts: 4
Will anyone tell me how to convert following xml file to xslt ...


<StatementOfAccount DCUABDS="060421" IEPSENT="001001001" ICUSTCN="00001001">
- <InvoiceItems>
- <InvoiceItem>
- <Billing-Transaction ICININO="BILL6">
<QCUA3SQ>2</QCUA3SQ>
<DCINISS>050408</DCINISS>
<DCINDUE>050408</DCINDUE>
<ACINTOT>3000.00</ACINTOT>
<ACINTOTL>3000.00</ACINTOTL>
<ACINTOTU>3000.00</ACINTOTU>
<ACINVAT>0.00</ACINVAT>
<ACINBAL>3000.00</ACINBAL>
<ACINBALL>3000.00</ACINBALL>
<ACINBALU>3000.00</ACINBALU>
<DCININS />
<CCUATST />
<DCINSET />
<FCUADPY />
<CCINRCN />
<FCUCARP />
<CCINITM>R</CCINITM>
<CCINREV>035</CCINREV>
<CUSICUR>USD</CUSICUR>
<ICUOPON />
<FCUSDDB />
<DCUSDDB />
<ICUOCTR />
<CAGLCNL />
<CCINLPC />
<ACINLPC>0.00</ACINLPC>
<DCINLPC />
<FILLVAT>000</FILLVAT>
<FLSUBIN>N</FLSUBIN>
<QSUISEQ>0</QSUISEQ>
<QNUMSUI>0</QNUMSUI>
<CCINAMC />
<DCINAMC />
<FCRCIDF>N</FCRCIDF>
</Billing-Transaction>
</InvoiceItem>
- <InvoiceItem>
- <Billing-Transaction ICININO="BILL7">
<QCUA3SQ>3</QCUA3SQ>
<DCINISS>050408</DCINISS>
<DCINDUE>050408</DCINDUE>
<ACINTOT>3500.00</ACINTOT>
<ACINTOTL>3500.00</ACINTOTL>
<ACINTOTU>3500.00</ACINTOTU>
<ACINVAT>0.00</ACINVAT>
<ACINBAL>3500.00</ACINBAL>
<ACINBALL>3500.00</ACINBALL>
<ACINBALU>3500.00</ACINBALU>
<DCININS />
<CCUATST />
<DCINSET />
<FCUADPY />
<CCINRCN />
<FCUCARP />
<CCINITM>R</CCINITM>
<CCINREV>040</CCINREV>
<CUSICUR>USD</CUSICUR>
<ICUOPON />
<FCUSDDB />
<DCUSDDB />
<ICUOCTR />
<CAGLCNL />
<CCINLPC />
<ACINLPC>0.00</ACINLPC>
<DCINLPC />
<FILLVAT>000</FILLVAT>
<FLSUBIN>N</FLSUBIN>
<QSUISEQ>0</QSUISEQ>
<QNUMSUI>0</QNUMSUI>
<CCINAMC />
<DCINAMC />
<FCRCIDF>N</FCRCIDF>
</Billing-Transaction>
</InvoiceItem>
- <InvoiceItem>
- <Billing-Transaction ICININO="22">
<QCUA3SQ>14</QCUA3SQ>
<DCINISS>060521</DCINISS>
<DCINDUE>060521</DCINDUE>
<ACINTOT>217.33</ACINTOT>
<ACINTOTL>296.37</ACINTOTL>
<ACINTOTU>217.33</ACINTOTU>
<ACINVAT>217.33</ACINVAT>
<ACINBAL>217.33</ACINBAL>
<ACINBALL>296.37</ACINBALL>
<ACINBALU>217.33</ACINBALU>
<DCININS />
<CCUATST />
<DCINSET />
<FCUADPY />
<CCINRCN>SET</CCINRCN>
<FCUCARP />
<CCINITM>I</CCINITM>
<CCINREV>061</CCINREV>
<CUSICUR>USD</CUSICUR>
<ICUOPON />
<FCUSDDB />
<DCUSDDB />
<ICUOCTR />
<CAGLCNL />
<CCINLPC />
<ACINLPC>0.00</ACINLPC>
<DCINLPC />
<FILLVAT>000</FILLVAT>
<FLSUBIN>N</FLSUBIN>
<QSUISEQ>0</QSUISEQ>
<QNUMSUI>0</QNUMSUI>
<CCINAMC />
<DCINAMC />
<FCRCIDF />
</Billing-Transaction>
</InvoiceItem>
- <InvoiceItem>
- <Billing-Transaction ICININO="BILL5">
<QCUA3SQ>1</QCUA3SQ>
<DCINISS>050408</DCINISS>
<DCINDUE>050408</DCINDUE>
<ACINTOT>2500.00</ACINTOT>
<ACINTOTL>2500.00</ACINTOTL>
<ACINTOTU>2500.00</ACINTOTU>
<ACINVAT>0.00</ACINVAT>
<ACINBAL>2500.00</ACINBAL>
<ACINBALL>2500.00</ACINBALL>
<ACINBALU>2500.00</ACINBALU>
<DCININS />
<CCUATST />
<DCINSET />
<FCUADPY />
<CCINRCN />
<FCUCARP />
<CCINITM>R</CCINITM>
<CCINREV>035</CCINREV>
<CUSICUR>USD</CUSICUR>
<ICUOPON />
<FCUSDDB />
<DCUSDDB />
<ICUOCTR />
<CAGLCNL />
<CCINLPC />
<ACINLPC>0.00</ACINLPC>
<DCINLPC />
<FILLVAT>000</FILLVAT>
<FLSUBIN>N</FLSUBIN>
<QSUISEQ>0</QSUISEQ>
<QNUMSUI>0</QNUMSUI>
<CCINAMC />
<DCINAMC />
<FCRCIDF>N</FCRCIDF>
</Billing-Transaction>
</InvoiceItem>
- <InvoiceItem>
- <Billing-Transaction ICININO="BILL9">
<QCUA3SQ>5</QCUA3SQ>
<DCINISS>050408</DCINISS>
<DCINDUE>050408</DCINDUE>
<ACINTOT>500.00</ACINTOT>
<ACINTOTL>500.00</ACINTOTL>
<ACINTOTU>500.00</ACINTOTU>
<ACINVAT>0.00</ACINVAT>
<ACINBAL>500.00</ACINBAL>
<ACINBALL>500.00</ACINBALL>
<ACINBALU>500.00</ACINBALU>
<DCININS />
<CCUATST />
<DCINSET />
<FCUADPY />
<CCINRCN />
<FCUCARP />
<CCINITM>R</CCINITM>
<CCINREV>045</CCINREV>
<CUSICUR>USD</CUSICUR>
<ICUOPON />
<FCUSDDB />
<DCUSDDB />
<ICUOCTR />
<CAGLCNL />
<CCINLPC />
<ACINLPC>0.00</ACINLPC>
<DCINLPC />
<FILLVAT>000</FILLVAT>
<FLSUBIN>N</FLSUBIN>
<QSUISEQ>0</QSUISEQ>
<QNUMSUI>0</QNUMSUI>
<CCINAMC />
<DCINAMC />
<FCRCIDF>N</FCRCIDF>
</Billing-Transaction>
</InvoiceItem>
- <InvoiceItem>
- <Billing-Transaction ICININO="BILL10">
<QCUA3SQ>6</QCUA3SQ>
<DCINISS>050408</DCINISS>
<DCINDUE>050408</DCINDUE>
<ACINTOT>1000.00</ACINTOT>
<ACINTOTL>1000.00</ACINTOTL>
<ACINTOTU>1000.00</ACINTOTU>
<ACINVAT>0.00</ACINVAT>
<ACINBAL>1000.00</ACINBAL>
<ACINBALL>1000.00</ACINBALL>
<ACINBALU>1000.00</ACINBALU>
<DCININS />
<CCUATST />
<DCINSET />
<FCUADPY />
<CCINRCN />
<FCUCARP />
<CCINITM>R</CCINITM>
<CCINREV>045</CCINREV>
<CUSICUR>USD</CUSICUR>
<ICUOPON />
<FCUSDDB />
<DCUSDDB />
<ICUOCTR />
<CAGLCNL />
<CCINLPC />
<ACINLPC>0.00</ACINLPC>
<DCINLPC />
<FILLVAT>000</FILLVAT>
<FLSUBIN>N</FLSUBIN>
<QSUISEQ>0</QSUISEQ>
<QNUMSUI>0</QNUMSUI>
<CCINAMC />
<DCINAMC />
<FCRCIDF>N</FCRCIDF>
</Billing-Transaction>
</InvoiceItem>
</InvoiceItems>
- <CustomerHeader>
<DDBSCRE>060425</DDBSCRE>
<CAGLLIC>BB</CAGLLIC>
<ICUSCNO>00001001</ICUSCNO>
<DCUABDS>060421</DCUABDS>
<IEPSENT>001001001</IEPSENT>
<ICUSTCN>00001001</ICUSTCN>
<CAGLDJV>01</CAGLDJV>
<IOLCDIS>01</IOLCDIS>
<IOLCBON>0022</IOLCBON>
<IJOBCUN>000006</IJOBCUN>
<ACUATOTL>10796.37</ACUATOTL>
<ACUATOTU>10717.33</ACUATOTU>
<ACUACBL>0.00</ACUACBL>
<ACUACPY>0.00</ACUACPY>
<ACUACCR>0.00</ACUACCR>
<ACUACAJ>0.00</ACUACAJ>
<CCUACRD>01</CCUACRD>
<CCUSSTM />
<DCUSLST />
<FCUSSEN />
<IOLCLEB />
<FCUALEG />
<ACUALEGL>0.00</ACUALEGL>
<ACUALEGU>0.00</ACUALEGU>
<DCUALEG />
<CCUACAG />
<FCUAAGY />
<FCUARLI />
<CDBSLAN>01</CDBSLAN>
<NCUSNAM>CHRISTMAS TREE CO</NCUSNAM>
<ICUS1AD />
<ICUS2AD>1005 XMAS ROAD</ICUS2AD>
<ICUS3AD>XMAS CITY</ICUS3AD>
<ICUS4AD />
<ICUS5AD>X1X 1X1</ICUS5AD>
<ICUS6AD />
<ICUSPOB>XXXXXXXXXXXXXXX</ICUSPOB>
<ICUSCTY>XMAS CITY</ICUSCTY>
<ICUSPCO>X1X 1X1</ICUSPCO>
<ICUABID>IN35902</ICUABID>
<CUSICUR />
<ACUANRBL>0.00</ACUANRBL>
<ACUANRBU>0.00</ACUANRBU>
</CustomerHeader>
- <CustomerFooter>
<CAGLDJV>01</CAGLDJV>
<IOLCDIS>01</IOLCDIS>
<IOLCBON>0022</IOLCBON>
<IJOBCUN>000006</IJOBCUN>
<NJOBCOL>H.VERMAAS</NJOBCOL>
<NJOBCTL>COLLECTOR</NJOBCTL>
<ITLECOL>416-474-2449</ITLECOL>
<IJOBCFX>999-888-777-6666</IJOBCFX>
<IJOBCEM>VERMAAS AT UITVM1</IJOBCEM>
</CustomerFooter>
</StatementOfAccount>

Thanks in Advance ....
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3739
    
  10

First off, I think there's a formatting problem (I don't see any XML data).

Second, you don't usually convert XML to XSLT, you usually convert XML to XML via an XSLT mapping file since XSLT is not neccessarily XML (the XSLT tags follow XML rules, but there could be other text that is ignored from parsing). For reference, XML is a data format language (stored informatio) and XSLT is a conversion mapping language (describes how do convert data, but doesn't usually store data).

Third, this isn't really the right forum for this. Try the EJB/JE2EE forum.
[ June 26, 2006: Message edited by: Scott Selikoff ]

[OCA 8 Book] [Blog]
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 19343
    
  10

Or the XML forum.
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3739
    
  10

Originally posted by Paul Clapham:
Or the XML forum.


That too
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: xml to xslt...