aspose file tools*
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
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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

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 ]

My Blog: Down Home Country Coding with Scott Selikoff
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18570
    
    8

Or the XML forum.
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

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