Support » Plugin: CSV Importer » Urgent: Characters that doesn't support CSV import?

  • Hi,

    I have noticed the following:

    () and () both these inverted commas are different. When I import the posts having () this inverted comma have problem, it doesn’t read the text after this punctuation. However when I change it to () it works perfect.

    Since I have huge list of data to import, I want to what other Characters are there which prevents to read the entire content successfully.

    I know it can be fixed easily by Find and Replace function in Excel. But in case if there are other such characters that are preventing to read the data, I cannot verify each and every post if it is successfully been read/imported, to detect those other characters. It could be = or @ or ^ or *

    Please let me know, this is very important!

Viewing 2 replies - 1 through 2 (of 2 total)
  • If you’re using Windows, you can try the fix that I’ve mentioned a couple times before to see if it’s what’s also causing your issue.

    I’ve copied and pasted it below:
    On a Windows machine, what I do is re-open the CSV file in Notepad and do a Save As. In the dialog box, I change it from ANSI to UTF-8. Then special characters can be imported.

    I too have come across this issue. I’ve also used musicman’s suggestion, which does work for the majority of issues.

    It doesn’t fix a few things like Microsoft Word-specific characters like em-dashes, double spaces, and a few others. But, it is a start.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Urgent: Characters that doesn't support CSV import?’ is closed to new replies.