WordPress.org

Ready to get started?Download WordPress

Forums

WP Ultimate CSV Importer Plugin
[resolved] Characters that doesn't support CSV import? (3 posts)

  1. faizzsheikh
    Member
    Posted 7 months ago #

    [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/

  2. faizzsheikh
    Member
    Posted 7 months ago #

    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?

  3. smackcoders
    Member
    Plugin Author

    Posted 6 months ago #

    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.

Reply

You must log in to post.

About this Plugin

About this Topic