Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Nathan Skidmore 63 posts 251 karma points c-trib
    Oct 21, 2015 @ 13:52
    Nathan Skidmore
    0

    Umbraco Forms Export to Excel displays & instead of & character

    Hi,

    I have created a form in Umbraco Forms (Contour) where within one of the fields I am storing a URL with querystring parameters.

    The entry data is displayed correctly in the backoffice (URL is valid) and this is also the case in a HTML Export. However in an Excel export, the URL is changed and the & symbol is converted to &

    Therefore when clicking this link in Excel, the URL doesn't work correctly as the querystring is not recognized.

    The database value is stored as &, the HTML markup on the HTML Export also displays as & when inspected. Therefore the export to Excel process must be encoding the & symbol to &.

    Does anyone know how I can override this or know of anything else I can do to resolve the issue?

    Thanks in advance.

    Nathan

    Copy Link
  • Sunnefa 22 posts 41 karma points
    Nov 25, 2015 @ 10:22
    Sunnefa
    0

    I'm having the same problem. Does anyone know the answer to this? This is really troublesome for us since we have a language with a lot of accented letters and they all get turned to their respective HTML entities when exporting, either to HTML or Excel.

    Copy Link
  • Dennis Aaen 4500 posts 18255 karma points admin hq c-trib
    Nov 25, 2015 @ 10:53
    Dennis Aaen
    0

    Hi Sunnefa,

    Perhaps you could try to use the workaround that is provided in this issue http://issues.umbraco.org/issue/CON-815

    Hope this helps,

    /Dennis

    Copy Link
  • Nathan Skidmore 63 posts 251 karma points c-trib
    Nov 25, 2015 @ 11:48
    Nathan Skidmore
    102

    Hi Sunnefa,

    Based on Dennis' tip I have managed to fix my issue. I edited the Views/Partials/Forms/Export/csv.cshtml file to decode the HTML. I changed the following code

    @Html.Raw(col).ToString().Replace(Environment.NewLine, " ")

    to

    @Html.Raw(HttpUtility.HtmlDecode(col.ToString().Replace(Environment.NewLine, " ")))

    You should be able to apply the same logic to the html export.

    Thanks,

    Nathan

    Copy Link

  • 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