Enjoyed learning a bit about transforming XML documents with XSLT in doing some homicide mashup maps for a series of stories reporter Matt Lakin is doing.He had complied homicide cases since 2000 into two OpenOffice Calc (Excel compatible) spreadsheets. I converted the spreadsheets to XML docs, then "transformed" each XML document into an HTML file and an XML file in Yahoo's map format using a simple perl program (all my perl programs are simple) and an XSLT stylesheet.
One gotcha I ran into was that the same spreadsheets saved by Excel and OpenOffice produced different XML for the date field and another field with using XML||Excel in perl. I'll have to look at that some more.
I did run into some issues of things I didn't know how to do in XSLT stylesheets, but I worked around them and I did have to clean up some addresses in Yahoo..
I used XML and Perl
by Mark Riehl and Ilya Sterin to learn how to do this. It's a good introduction, but you'll need a book about XSLT if you want to do more than scratch the surface. The results:
Knoxville homicides
Knox County homicides
ShareThis; "Christmas Treats")
; "David Carr of the New York Times")
; "FLDemocracy2012.com")
; "4178265189_4785cf3fa5.jpg")
; "9-22-11-2.png")
; "markgalsergplus.jpg")
; "IMG_0520.JPG")
; "Knox County Cell Calls on AT&T")
; "Bonnaroo 2011")
; "Sourcing Stories")
Google+
Where did you get the data/spreadsheets for these?
The reporter created the spreadsheets after going through the reports. He'd been working on this for some time.