WordPress.org

Ready to get started?Download WordPress

Forums

WP Ultimate CSV Importer Plugin
[resolved] CSV's ANSI encoding causes problems with special characters (9 posts)

  1. evrenk
    Member
    Posted 1 year ago #

    Hello,

    Your plugin is a blessing: I have an entire 900+ entries Excel spreadsheet to import into two custom post types. You just saved me a month of work.

    The values I have to import are in French. Excel's ANSI encoding caused strings to be cut before the first accentuated character for each one. I have opened the csv in NotePad++ and converted the encoding to UTF-8. Worked like a charm!

    Maybe someone could benefit from this piece of information :)

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

  2. smackcoders
    Member
    Plugin Author

    Posted 1 year ago #

    evrenk,

    Thank you for the feedback. Really it should help others. Also kindly rate our plugin.

    Thanks

  3. hansa1
    Member
    Posted 1 year ago #

    Hi smackcoders,
    I have Italian special Characters like "è,à".when i try to import it is not loading full text.it is breaking until this characters.please help me.i did evrenk approach ,but no luck.
    Thanks.

  4. evrenk
    Member
    Posted 1 year ago #

    Hi hansa1,

    The encoding you might get at the beginning might be different. When you open the file in a text editor, play with the encoding settings until the characters appear OK and then change the encoding to UTF-8. Does it work?

    Kind regards,

    Evren

  5. smackcoders
    Member
    Plugin Author

    Posted 11 months ago #

    Hope @hansa1 got that worked to.

  6. eyoungquist
    Member
    Posted 6 months ago #

    Thanks evrenk!!! I was pulling my hair out about this issue. Perfect solution! Will make our client very happy not to have to search/replace foreign chars with html entity codes in the csv file! Great plugin, smackcoders - any chance of accepting ANSI-encoded files in the future?

  7. LeRedac
    Member
    Posted 5 months ago #

    Merci beaucoup evrenk pour cette astuce !!! j'était en train de me prendre le choux grave sur cette histoire de uft8. J'ai moi aussi une base de plus de 4000 enregistrement à importer dans un post type ! La ac Notpad ++ ça marche nickel !

    smackcoders, i'm confirm Your plugin is a blessing !! Thank you so much ;-)

  8. smackcoders
    Member
    Plugin Author

    Posted 5 months ago #

    @ LeRedac, Merci pour votre commentaire, j'espère que vous pouvez poster votre avis qui nous aident à maintenir notre plugin grandit

  9. smackcoders
    Member
    Plugin Author

    Posted 5 months ago #

    @eyoungquist, yes we do have the plan to add in upcoming versions. Check back our next release. Dont forget to pass your review as well.

    Thanks for your comment.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic