import remote csv in xslt

Go to solution

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Paul Hulatt 47 posts 59 karma points

Aug 12, 2009 @ 14:42

0

Import Remote CSV in XSLT

Does anyone know of an easy way that I can import a remote CSV file via XSLT? I have tried using GetXmlDocumentByUrl but it (quite correctly) errors as the file being loaded is not an XML document. IS there an equivalent for loading non-XML documents from remote locations.

Cheers in advance

Paul.

Copy Link
Bert 128 posts 251 karma points

Aug 12, 2009 @ 14:45

0

As far as I know, no.

Copy Link
Thomas Höhler 1237 posts 1709 karma points MVP

Aug 12, 2009 @ 14:48

0

Write your own xslt extension which loads the csv file into an XmlDocument and returens an XmlNodeIterator.

If you have questions I can give you an example

Thomas

Copy Link
Richard Soeteman 4046 posts 12899 karma points MVP 2x

Aug 12, 2009 @ 14:58

0

Hi Paul,

GetXmlDocumentByUrl is only for Xml. If you just want to import a csv file you could use umbImport. I've build a csv option, so you can select a csv file. This is not a remote file.

If you need to access the file dynamicly. You can create an xslt extension that returns the data as an xpathNodeIterator.

Hope this helps you,

Richard

Copy Link

Thomas Höhler 1237 posts 1709 karma points MVP

Aug 12, 2009 @ 14:59

Something like that will do it:

public static XPathNodeIterator GetCsv(string filename)
{
    XmlDocument xdoc = new XmlDocument();
    XmlElement rows = xdoc.CreateElement("rows");
    xdoc.AppendChild(rows);

    using (System.IO.StreamReader sr = new System.IO.StreamReader(filename))
    {
        String line;
        // Read and display lines from the file until the end of 
        // the file is reached.
        while ((line = sr.ReadLine()) != null)
        {
            XmlElement row = xdoc.CreateElement("row");
            rows.AppendChild(row);
            foreach (var item in line.Split(";".ToCharArray()))
            {
                XmlElement col = xdoc.CreateElement("col");
                col.Value = item;
                row.AppendChild(col);
            }
        }
    }
    XPathNavigator xp = xdoc.CreateNavigator();
    return xp.Select("/rows");
}

hth, Thomas

Copy Link

Lee Kelleher 4026 posts 15836 karma points MVP 13x admin c-trib

Aug 12, 2009 @ 15:19

Following on from Thomas' reply, (at present) a custom method is the only way to go.

If you need a quick-and-ready solution to this, and don't want to get involved with Visual Studio (God knows why? We all love it), you can do this all natively in XSLT ... using a custom function (see Extend your XSLT with custom functions wiki page)

Here's an example:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet
 version="1.0"
 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:msxml="urn:schemas-microsoft-com:xslt"
  xmlns:umbraco.library="urn:umbraco.library"
   xmlns:bodenko="urn:bodenko"
   exclude-result-prefixes="msxml umbraco.library bodenko">
   <xsl:output method="xml" omit-xml-declaration="yes"/>

 <xsl:param name="currentPage"/>

   <msxml:script implements-prefix="bodenko" language="C#">
    <msxml:assembly name="System" />
    <msxml:assembly name="umbraco" />
   <msxml:using namespace="System.Net" />
  <msxml:using namespace="umbraco" />
 <![CDATA[
      public static XPathNodeIterator GetCsvByUrl(string url, string separator)
     {
         String csv = String.Empty;
            using (WebClient client = new WebClient())
            {
             csv = client.DownloadString(url);
         }
         return umbraco.library.Split(csv, separator);
     }
 ]]>
    </msxml:script>

   <xsl:template match="/">
        <xsl:variable name="csv" select="bodenko:GetCsvByUrl('http://www.domain.com/filename.csv', ',')" />
     <xsl:if test="count($csv/value) &gt; 0">
            <ul>
                <xsl:for-each select="$csv/value">
                  <li>
                        <xsl:value-of select="." />
                 </li>
               </xsl:for-each>
         </ul>
       </xsl:if>
   </xsl:template>
 
</xsl:stylesheet>

The "GetCsvByUrl" method doesn't take multi-line (rows) into account... you can quite easily replace this with Thomas' method (above).

Copy Link

Paul Hulatt 47 posts 59 karma points

Aug 12, 2009 @ 16:29

0

Cheers Lee, that was just the sort of start I was hoping for now I can concentrate of dealing with the actual data and displaying it in some kind on meaningful way.

Richard, thanks for your reply regarding umbImport, I've used your fantastic package already when migrating an existing site over to Umbraco so thanks for all your hard work.

Paul

Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?