Copied to clipboard

Flag this post as spam?

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


  • Rick van der Zwart 8 posts 28 karma points
    Mar 05, 2013 @ 14:49
    Rick van der Zwart
    0

    Converting external CSV to internal XML with XSLT

    As the title says, I need to convert an external CSV to an internal XML by using XSLT.

    I've been looking all over Google for a way to do this. However, all I can find are codes which use an internal CSV; Something I'm not allowed to use.

    I cannot give you the contents of the CSV due to sensitive company property, but I was hoping that somebody would be able to explain to me how it works.

    Let's use this as an example CSV, found this fictional link:

    www.examplecvs.nl/nl/affiliates/feed.csv

    "Name", "Age", "Gender"
    "Rick", "21", "Male"

    How could I make an internal XML out of this external CSV?

  • Charles Afford 1163 posts 1709 karma points
    Mar 10, 2013 @ 10:45
    Charles Afford
    0

    Hello :) are you able to attach the csv in Umbraco prehaps to the media folder?

  • Charles Afford 1163 posts 1709 karma points
    Mar 10, 2013 @ 10:47
    Charles Afford
    0

    If so you could write an extension method in C# that would parse the CSV to XML that would then be returned to your XHTML page as XML that you could then render. Charlie :)

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies