Support » Plugin: RSVP and Event Management Plugin » [Plugin: RSVP Plugin] International characters in guest names

  • 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:

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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.

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Plugin: RSVP Plugin] International characters in guest names’ is closed to new replies.