Exportes csv invalid

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: ,

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • 01/08/2019 at 11:06 am #481123
    Reinhard Guenther
    Participant

    Hi Steve,
    exporting my contacts as .csv with the plugins export function, the german special characters are misrepresented. For example like this: “Günther”. What can I do to avoid this?

    Regards
    Reinhard

    01/08/2019 at 1:18 pm #481141
    Steven Zahm
    Keymaster

    @ Reinhard

    RE: What can I do to avoid this?

    Don’t open it in Excel… Use Google Sheets or LibreOffice since they properly open UTF8 encoded files (required to properly support extended characters which exist in German and other languages). One open in them, you can save out as an Excel file.

    There is a non obvious option to default to UTF8 when opening a CSV file in Excel … I can only recall it had to do something with an import option. I tried searching for the link I found before but came up short.

    A workaround is to open a new blank workbook in Excel, click the Data tab, click the Import from CSV button in the ribbon. In the popup choose you file. After you choose your file, the popup will display an option for the “File Origin”. Choose the 65001: Unicode (UTF8) option.

    The downside with this workaround is that line breaks in the bio/notes fields will be read as new rows by Excel, breaking the those entries.

    Hope this helps!

    ps. I just made a very slight tweak to the export code which will be included in the next version that might “help” excel properly open the CSV file with the UTF8 encoding. This tweak will be in the updated planned for the end of the week.

    01/22/2019 at 7:42 am #482335
    Reinhard Guenther
    Participant

    Thank you! The downloads now work as they should.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)

You cannot reply to this support topic. Please open your own support topic.