CSV's ANSI encoding causes problems with special characters

Resolved evrenk
(@evrenk)

12 years, 11 months 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://ww.wp.xz.cn/extend/plugins/wp-ultimate-csv-importer/

Viewing 8 replies - 1 through 8 (of 8 total)

Plugin Author Smackcoders Inc.,
(@smackcoders)

12 years, 11 months ago

evrenk,

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

Thanks

hansa1
(@hansa1)

12 years, 11 months 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.

Thread Starter evrenk
(@evrenk)

12 years, 11 months 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

Plugin Author Smackcoders Inc.,
(@smackcoders)

12 years, 10 months ago

Hope @hansa1 got that worked to.

eyoungquist
(@eyoungquist)

12 years, 5 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?

LeRedac
(@leredac)

12 years, 3 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 😉

Plugin Author Smackcoders Inc.,
(@smackcoders)

12 years, 3 months ago

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

Plugin Author Smackcoders Inc.,
(@smackcoders)

12 years, 3 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.