[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Xml to HTML using XSL kinda tricky

• To: xml-dev@l...
• Subject: Re: Xml to HTML using XSL kinda tricky
• From: "G. Ken Holman" <gkholman@C...>
• Date: Thu, 31 Oct 2002 10:16:12 -0500
• In-reply-to: <20021030200259.90882.qmail@w...>
• References: <20021030184235.E57C45542@c...>

XSLT and XPath questions would be better posted to the following list:

   http://www.mulberrytech.com/xsl/xsl-list

There are a number of subscribers who would enthusiastically respond to 
such questions.

There is also an *excellent* FAQ at:

   http://www.dpawson.co.uk

At 2002-10-30 12:02 -0800, Nischal Muthana wrote:
>I have an Xml file like the following.
>...
>What I am tryin to do is:
>
>1. Group all the CustomerID's
>(/CustomerList/Customer/CustomerInfo/CustomerID's)
>present in the XML file and display a column of Unique
>CustomerID's.
>...
>I have a criteria table for the products like the
>following
>
>ProductIDs
>1000,1001,1005,1100 -- Groceries
>2000,2001,2005,2300 -- Food
>3000,3004,6000,5000 -- Books
>
>(I wouldnt mind having this as an Xml)

You will need it in XML in order to bring into XSLT ... all inputs to XSLT 
are node trees, usually derived from XML documents.

>2. Then take all the Product ID's(
>/CustomerList/Customer/Product/ProductID), for each of
>the CustomerID that is grouped above, map against the
>above Criteria table and find the count of each of the
>product categories that a particular CustomerID has
>bought.
>
>The resulting table should be like the following
>...
>Any help in how to go about will be greatly
>appreciated.

See the FAQ regarding grouping algorithms and use the customer file as the 
basis of your transformation.

The headings that you need can be derived from the XML you create for the 
product information.

Because of the totalling requirements, you may find it easier to do two 
passes, creating an intermediate file and then totalling from the 
intermediate file.

Given the early stage of your data and requirements, this should be enough 
to get you started.

I hope this helps.

.................... Ken


--
G. Ken Holman               mailto:gkholman@C...
Crane Softwrights Ltd.        http://www.CraneSoftwrights.com/x/
Box 266, Kars, Ontario CANADA K0A-2E0  +1(613)489-0999 (F:-0995)
ISBN 0-13-065196-6                     Definitive XSLT and XPath
ISBN 0-13-140374-5                             Definitive XSL-FO
ISBN 1-894049-08-X Practical Transformation Using XSLT and XPath
ISBN 1-894049-10-1             Practical Formatting Using XSL-FO
Next public training:          2002-12-08,2003-02-03,06,03-03,06

• References:
  • Re: What is XML For?
    • From: Alaric Snell <alaric@a...>
  • Xml to HTML using XSL kinda tricky
    • From: Nischal Muthana <nischal_muthana@y...>

• Prev by Date: Re: Article: "The horror of XML"
• Next by Date: Re: Article: "The horror of XML"
• Previous by thread: Xml to HTML using XSL kinda tricky
• Next by thread: Re: What is XML For?
• Index(es):
  • Date
  • Thread