Support » Plugin: Quick Event Manager » Special symbols

  • Resolved Nanette Kalisvaart

    (@nanettekalisvaart)


    Hi,

    I just discovered that the export for registrations does not translate special symbols:

    So “ü” becomes “ü”, “ö” becomes “ö” and “ë” becomes “ë”.
    Is there a way to correct that in the *.csv?

    Kind regards,
    Nanette

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Alan Fuller

    (@alanfuller)

    Do you mean export to csv?

    I just tested that and it has no issues.

    Have you checked the raw CSV file – rather than import to spreadsheet?

    Thread Starter Nanette Kalisvaart

    (@nanettekalisvaart)

    I import csv to Excel. I don’t want to upload the file here (for privacy). I will e-mail you.

    Plugin Author Alan Fuller

    (@alanfuller)

    I don’t use Excel so it won’t help.

    Have a look at the csv file in a text editor – you will see it is encoded correctly.

    You will need to set Excel upload settings, as I said I don’t use it so can’t say but there are plenty of articles on Google is you search for

    ‘How to import a .csv file that uses UTF-8 character encoding into Excel’

    Thread Starter Nanette Kalisvaart

    (@nanettekalisvaart)

    You don’t use Excel, but many of us do …

    Is there no way to change the export instead of the import?
    I have never before had to do ‘something special’ to import a *.csv-file.

    Plugin Author Alan Fuller

    (@alanfuller)

    Sure lots of people use Excel.

    I’m saying that I can’t help you with Excel support, as I know nothing about Excel at a technical level.

    I can’t see anything special with the files you provided, in text editors, Google Sheets, Libre Office and Mac Numbers. So the logical conclusion is that the issue lies with Excel.

    Is there no way to change the export instead of the import?

    If some one can give me a technical definition of what Excel is expecting – perhaps – maybe – there is something that can be done. But at the moment, as it all looks fine, I have no idea what a change would be.

    Plugin Author Alan Fuller

    (@alanfuller)

    CSV’s files are generated to be UTF-8 compliant. This is done to ensure the CSV’s can be used on a variety of operating systems using a variety of programs.

    1. Open Excel
    2. Click “File” and “New”
    3. Click on the “Data” tab
    4. Click “From Text” and select the CSV file
    5. Select “Delimited”
    6. For “File origin”, select “65001 : Unicode (UTF-8)”
    7. Click “Next”
    8. Select “Comma”
    9. Click “Finish”

    Excel should now show you the CSV file and display the characters correctly.

    Thread Starter Nanette Kalisvaart

    (@nanettekalisvaart)

    Thank you for all your input. I just had no idea Excel works ‘backwards’ like that. I’ll check if I’m using an old version or something.

    Thanks again.

    Plugin Author Alan Fuller

    (@alanfuller)

    Hi Nannette as I haven’t heard back from you for a while I’ll mark this as resolved.

    Plugin Author Alan Fuller

    (@alanfuller)

    Helps if I actually mark it 🙂

    Thread Starter Nanette Kalisvaart

    (@nanettekalisvaart)

    Sorry, didn’t think you were expecting feedback. I’m using Excel 2010, but I guess that works like this. We don’t use events enough to go any further with this; the workaround suffices. Thanks.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Special symbols’ is closed to new replies.