CSV Import with apostrophes

  • Post date

Home › Forums › Calendar Products › Events Calendar PRO › CSV Import with apostrophes

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • March 12, 2015 at 4:21 am #947842
    edmundus
    Participant

    Hi there,

    I am having an issue with csv importing. Some of the descriptions for my events are in french and contain many apostrophes. When importing the description is cut off at the first instance of this and therefore all descriptions are wrong.

    Is there a solution for this or a way around it?

    Thanks,

    Ed

    March 12, 2015 at 7:38 am #947881
    Barry
    Member

    Hi Ed,

    Would it be possible to see your CSV data? When I try to replicate this and insert apostrophes and other accents (such as é) within the fields I don’t encounter any problems.

    Though you cannot upload files directly to the forum, if you are able to upload the file to your own WordPress site (or else a service such as Dropbox) you can share the link here, as a private reply if you prefer.

    Thanks!

    March 12, 2015 at 10:55 am #947937
    edmundus
    Participant

    This reply is private.

    March 12, 2015 at 10:56 am #947938
    edmundus
    Participant

    Also here is a link to the demo site where the output is: http://s554446553.websitehome.co.uk/tv-guide/category/france/

    March 12, 2015 at 12:13 pm #947964
    Barry
    Member

    Thanks!

    I think the problem is that the file itself was not saved or created using UTF-8 encoding (which is simply one of a number of formats that can be used when characters from extended/international alphabets are needed).

    While I could replicate the issue initially using your sample CSV file, once I converted the file to UTF-8 it imported perfectly. Could you give the same thing a try?

    How you do this will vary according to your operating system and the tools you have at your disposal, but most popular and up-to-date text editors and spreadsheet applications will include options to save files using UTF-8 encoding 🙂

    March 13, 2015 at 2:42 am #948093
    edmundus
    Participant

    Hi Barry,

    That has done the trick! Very helpful. I was using excel 2010 which doesn’t seem to create using UTF-8. Interestingly using Google Spreadsheets does, so that has made everything easy.

    Thanks for the help.

    Ed

    March 13, 2015 at 9:19 am #948177
    Barry
    Member

    Glad that worked.

    I’m surprised to hear Excel doesn’t make it easy to generate UTF-8 output, but it definitely looks like the same approach you used here – using Google Sheets – is what others have had to fall back on, too.

    Anyway, happy it’s all working 🙂

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)
  • The topic ‘CSV Import with apostrophes’ is closed to new replies.