eMember – Problem when importing csv comma with accent in Member Bulk Import

[croissance]

WordPress Version : 4.3.1

Wp eMember Version : v8.9.5

eMember Member Bulk Import Version 1.2

WP eStore Version 7 2 5

Hi,

When I want to import my csv with comma with the Member Bulk Import plugin, there is a problem of accents (I’m french) and the members just does not import at all.

What can I do ?

Thanks

[admin]

What happens if you import that same CSV file using PHPMyAdmin tool?

The following tutorial will teach you about this tool (if you don’t know it already):

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[croissance]

Hello,

Thanks for the fast answer and the tips, I’ve just imported the csv and it seems like it does not work either.

The word where and accent appears (e.g: Montréal) displays only the letters before the accents : Montr

Then, it does not take into account the Membership level (left blank) and I have a problem with the Expiry Date field during the importation (phpMyAdmin says that the name is not good but I put Membership Expiry has mentionned in the template I’ve downloaded and tested lots of other name…).

What do you propose ? Thanks.

[wzp]

Thanks for the fast answer and the tips, I’ve just imported the csv and it seems like it does not work either.

The word where and accent appears (e.g: Montréal) displays only the letters before the accents : Montr

It sounds like there is a mismatch between the character set used by the CSV file, and the database. Is the CSV file encoded with UTF-8?

[http://stackoverflow.com/questions/4245300/phpmyadmin-import-csv-with-symbols]

Is your database tables UTF-8 formatted?

[croissance]

Hello,

It was actually a bad encoded file…

I had to open the csv in Notepad, make the conversion and replace every ; by a comma…

It’s not very handy but it works now. WOUH !

Thanks everyone, now I have to deal with a reset password mail not received…

See you in another topic maybe !

[Author]

Posts