Lee Kelleher

Archive for posts tagged with 'xml'

  1. Working with XSLT using new XML schema in Umbraco 4.1

    Posted on

    Most of the Umbraco community are aware that the XML schema in the upcoming Umbraco 4.1 release has changed. Instead of each document being a node element, the element name is the node-type alias, same with property values; they no longer use data elements with alias attributes. Here is a quick example, comparing the old/legacy with the new: <node id="1066" parentID="-1" level="1" nodeName="Home" ... nodeTypeAlias="Homepage" path="-1,1066"> <data alias="bodyText"><![CDATA[<p>Welcome to my homepage.</p>]]></data> </node> <Homepage id="1066" parentID="-1" level="1"…

    Tags: , , , , ,

  2. Convert XmlReader to String

    Posted on

    I was in the middle of developing a member look-up AJAX function for an Umbraco project, when I ran into a slight problem, (confusion rather), about how to pull the XML back from SQL Server and return it to the browser (AJAX). The SQL statement was straight-forward, very simple, does a LIKE query against the members table, no problem there. Added “FOR XML AUTO” to return the result-set back as an XML data-type ... all…

    Tags: , , , , , , ,

  3. Converting CSV to XML

    Posted on

    There’s a bit a functionality on one of the projects that I’m working on where I need to do a lookup. The data I’ve been given is in an Excel spreadsheet – which I needed to convert to XML (as ultimately the data will be stored in a CMS that handles XML better). I’ve done a lot of projects where I need to convert XML to Excel (via CSV), but not many where I need…

    Tags: , , , , , , , , , , ,