[xsl] date grouping/sorting problem

Subject: [xsl] date grouping/sorting problem
From: Nathan Shaw <n8_shaw@xxxxxxxxx>
Date: Mon, 1 Mar 2004 07:31:35 -0800 (PST)
Hello all,

I am trying to group and sort some xml by dates,
especially by year, month and then day. It appears
that I need to use keys and a sorting method to do
this, but I am having trouble grokking it. Can someone
lend some help?

Here is a sample xml file that I am trying to group
and sort. I appreciate any help that can be given!

--Nathan


<?xml version="1.0" encoding="UTF-8"?>
<obprcal:top
xmlns="http://spaceresearch.nasa.gov/calendar";
xmlns:obprcal="http://spaceresearch.nasa.gov/calendar";
xmlns:xcal="http://www.ietf.org/internet-drafts/draft-ietf-calsch-many-xcal-01.txt";>
	<xcal:vcalendar xcal:version="2.0"
xcal:prodid="-//obpr-calendar//NONSGML 1.0//EN"
obprcal:category="General Interest"
obprcal:timeperiod="previous">
		<xcal:vevent>
			<obprcal:timeframe>previous</obprcal:timeframe>
			<xcal:summary>Birthday party</xcal:summary>
			<xcal:location>Home</xcal:location>
			<xcal:categories>General Interest</xcal:categories>
			<xcal:contact>Don Ho</xcal:contact>
			<xcal:description>Birthday party</xcal:description>
			<xcal:dtstart>2004-01-29 22:30:00</xcal:dtstart>
			<obprcal:dtstart_year>2004</obprcal:dtstart_year>
			<obprcal:dtstart_month>01</obprcal:dtstart_month>
			<obprcal:dtstart_day>29</obprcal:dtstart_day>
			<obprcal:dtstart_hour>22</obprcal:dtstart_hour>
			<obprcal:dtstart_minute>30</obprcal:dtstart_minute>
			<obprcal:dtstart_second>00</obprcal:dtstart_second>
			<xcal:dtend>2004-01-29 23:30:00</xcal:dtend>
			<obprcal:dtend_year>2004</obprcal:dtend_year>
			<obprcal:dtend_month>01</obprcal:dtend_month>
			<obprcal:dtend_day>29</obprcal:dtend_day>
			<obprcal:dtend_hour>23</obprcal:dtend_hour>
			<obprcal:dtend_minute>30</obprcal:dtend_minute>
			<obprcal:dtend_second>00</obprcal:dtend_second>
			<xcal:url>url</xcal:url>
			<obprcal:untimed>0</obprcal:untimed>
			<obprcal:allday>0</obprcal:allday>
		</xcal:vevent>
		<xcal:vevent>
			<obprcal:timeframe>previous</obprcal:timeframe>
			<xcal:summary>gdfgsdf</xcal:summary>
			<xcal:location>sd fgsfg</xcal:location>
			<xcal:categories>General Interest</xcal:categories>
			<xcal:contact>Cary Tellis</xcal:contact>
			<xcal:description>asrfasfa fasfasfasd fasd fasdf
asfas f</xcal:description>
			<xcal:dtstart>2003-11-06 15:00:00</xcal:dtstart>
			<obprcal:dtstart_year>2003</obprcal:dtstart_year>
			<obprcal:dtstart_month>11</obprcal:dtstart_month>
			<obprcal:dtstart_day>06</obprcal:dtstart_day>
			<obprcal:dtstart_hour>15</obprcal:dtstart_hour>
			<obprcal:dtstart_minute>00</obprcal:dtstart_minute>
			<obprcal:dtstart_second>00</obprcal:dtstart_second>
			<xcal:dtend>2003-11-06 16:00:00</xcal:dtend>
			<obprcal:dtend_year>2003</obprcal:dtend_year>
			<obprcal:dtend_month>11</obprcal:dtend_month>
			<obprcal:dtend_day>06</obprcal:dtend_day>
			<obprcal:dtend_hour>16</obprcal:dtend_hour>
			<obprcal:dtend_minute>00</obprcal:dtend_minute>
			<obprcal:dtend_second>00</obprcal:dtend_second>
			<xcal:url>url</xcal:url>
			<obprcal:untimed>0</obprcal:untimed>
			<obprcal:allday>0</obprcal:allday>
		</xcal:vevent>
		<xcal:vevent>
			<obprcal:timeframe>previous</obprcal:timeframe>
			<xcal:summary>xzdss</xcal:summary>
			<xcal:location>zzxzxc</xcal:location>
			<xcal:categories>General Interest</xcal:categories>
			<xcal:contact>Henry Ford</xcal:contact>
			<xcal:description>eduaction
general</xcal:description>
			<xcal:dtstart>2003-11-03 20:00:00</xcal:dtstart>
			<obprcal:dtstart_year>2003</obprcal:dtstart_year>
			<obprcal:dtstart_month>11</obprcal:dtstart_month>
			<obprcal:dtstart_day>03</obprcal:dtstart_day>
			<obprcal:dtstart_hour>20</obprcal:dtstart_hour>
			<obprcal:dtstart_minute>00</obprcal:dtstart_minute>
			<obprcal:dtstart_second>00</obprcal:dtstart_second>
			<xcal:dtend>2003-11-03 21:00:00</xcal:dtend>
			<obprcal:dtend_year>2003</obprcal:dtend_year>
			<obprcal:dtend_month>11</obprcal:dtend_month>
			<obprcal:dtend_day>03</obprcal:dtend_day>
			<obprcal:dtend_hour>21</obprcal:dtend_hour>
			<obprcal:dtend_minute>00</obprcal:dtend_minute>
			<obprcal:dtend_second>00</obprcal:dtend_second>
			<xcal:url>url</xcal:url>
			<obprcal:untimed>0</obprcal:untimed>
			<obprcal:allday>0</obprcal:allday>
		</xcal:vevent>
		<xcal:vevent>
			<obprcal:timeframe>previous</obprcal:timeframe>
			<xcal:summary>OBPR AA Monthy Review</xcal:summary>
			<xcal:location>Mic-6</xcal:location>
			<xcal:categories>General Interest</xcal:categories>
			<xcal:contact>Xylan Geneva</xcal:contact>
			<xcal:description>This is the monthly... plus any
other info you want.</xcal:description>
			<xcal:dtstart>2003-05-07 15:30:00</xcal:dtstart>
			<obprcal:dtstart_year>2003</obprcal:dtstart_year>
			<obprcal:dtstart_month>05</obprcal:dtstart_month>
			<obprcal:dtstart_day>07</obprcal:dtstart_day>
			<obprcal:dtstart_hour>15</obprcal:dtstart_hour>
			<obprcal:dtstart_minute>30</obprcal:dtstart_minute>
			<obprcal:dtstart_second>00</obprcal:dtstart_second>
			<xcal:dtend>2003-05-07 21:00:00</xcal:dtend>
			<obprcal:dtend_year>2003</obprcal:dtend_year>
			<obprcal:dtend_month>05</obprcal:dtend_month>
			<obprcal:dtend_day>07</obprcal:dtend_day>
			<obprcal:dtend_hour>21</obprcal:dtend_hour>
			<obprcal:dtend_minute>00</obprcal:dtend_minute>
			<obprcal:dtend_second>00</obprcal:dtend_second>
			<xcal:url>url</xcal:url>
			<obprcal:untimed>0</obprcal:untimed>
			<obprcal:allday>0</obprcal:allday>
		</xcal:vevent>
	</xcal:vcalendar>
	<obprcal:supplementalData>
		<obprcal:timeperiods>
			<obprcal:timeperiod>upcoming</obprcal:timeperiod>
			<obprcal:timeperiod>previous</obprcal:timeperiod>
		</obprcal:timeperiods>
		<obprcal:categories>
			<obprcal:category>Education
Events</obprcal:category>
			<obprcal:category>External Technical
Meetings</obprcal:category>
			<obprcal:category>General
Interest</obprcal:category>
			<obprcal:category>Internal Technical
Meetings</obprcal:category>
			<obprcal:category>NASA wide Management
Reviews</obprcal:category>
			<obprcal:category>OBPR Management
Reviews</obprcal:category>
		</obprcal:categories>
	</obprcal:supplementalData>
</obprcal:top>


__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread