WordPress.org

Ready to get started?Download WordPress

Forums

RSVP Plugin
International characters in guest names (3 posts)

  1. marcoskirsch
    Member
    Posted 2 years ago #

    Hello,
    I've run into a problem with the RSVP Plugin. When importing a guest list in an Excel spreadsheet file in which a guest name contain an international character such as a vowel with an accent (i.e. á), the word gets cut off at that character.

    For example, let's say I have a guest:
    Ramón Valdez
    it gets imported as Ram Valdez.

    Interestingly, if I try to edit the guest, then it is shown in the text field as: R�a�m�.

    Seems like a character encoding bug.

    You can reproduce the bug using this test Excel spreadsheet that shows the problem: https://dl.dropbox.com/u/350859/rsvp-bug.xls

    Any help is greatly appreciated - lots of foreigners are invited to my wedding! Thanks.

    http://wordpress.org/extend/plugins/rsvp/

  2. marcoskirsch
    Member
    Posted 2 years ago #

    More information:

    - If I enter the name "Ramón" within the Administration interface, then it gets saved and displayed fine.
    - If I export it, the file is save with extension .csv.xls but it's actually a .csv file. I can edit the extension and the import it - I need to select "Windows (ANSI)" under "File origin" for the international characters to look fine. This makes sense to me. The other options are "Macintosh" and "DOS or OS/2 (PC-8).
    - I created the sample file linked in my original post using Google Docs, with the option under File->Download As->Excel. I am assuming that Google Docs encodes things right and opening the file in Excel displays it fine.
    - All these tests I'm doing in a Mac, using Excel for Mac.

  3. r8r
    Member
    Posted 1 year ago #

    Open up wp-rsvp.php and replace all occurrences of "htmlentities" with "htmlspecialchars", except the two occurrences with the second parameter "ENT_QUOTES" around line 308.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic