WordPress.org

Support

Support » Plugins and Hacks » [Resolved] Characters that doesn't support CSV import?

[Resolved] Characters that doesn't support CSV import?

  • [Moderator Note: Topic title amended. Your problem is no more urgent than anyone else’s.]

    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!

    http://wordpress.org/plugins/wp-ultimate-csv-importer/

Viewing 2 replies - 1 through 2 (of 2 total)
  • http://webbictive.files.wordpress.com/2013/11/sample_data.xlsx

    Please check the file… it includes the sample data that I am trying to import… similarly I have a huge list of data to import in different languages.

    I had tried to save it with UTF-8, I tried to open the CSV in notepad and then save it to UTF-8 csv format but the non English characters shows like this: ???????????????? ?????????? ??????? ???????

    Please let me know how can I fix this?

    Plugin Author smackcoders

    @smackcoders

    This is already answered in this forum and added to the faq no.5 as well.

    It should strictly UTF-8 format. Users have reported that utf-8 without BOM works well for languages like Polish characters etc.
    Follow these simple steps to import other languages. Thanks for the steps mojeprogramy.com.
    1) Prepare a CSV file with the data (I used Excel)
    2) Saving files to CSV (Excel function)
    3) I opened the CSV file in Notepad + +
    4) CTR + A, CTR + C (copy all the text)
    5) The “Encoding”> “Encode without BOM”
    6) CTR + V to paste all text
    7) Save the file
    8) Imports for WordPress

    Hope this helps.

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