Import without special characters

  • Resolved gurudlan

    (@gurudlan)


    6 years, 1 month ago

    Hello,

    i have a csv file with UTF-8 coding…
    When i import users it’s like a good import result as you can see here: https://ctrlv.cz/5NHW (screenshot), but after -> i go to users and new imported users is without special characters (stored to db). This printscreen: https://ctrlv.cz/Llnw

    Special characters like: ????yáň…

    How to solve that please?

    Thank you

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter gurudlan

    (@gurudlan)

    + i check my WP DB and it is set to utf8mb4 coding, but that is not problem….or?

    Thread Starter gurudlan

    (@gurudlan)

    + when i create user manually with special characters, WP save user with special characters to DB too…That is info about special characters working in my DB…

    Plugin Author Javier Carazo

    (@carazo)

    @gurudlan,

    Good evening, if the problem persists also doing it manually, this is not in the plugin.

    Talk with your hosting, maybe there is some kind of bad configuration.

    Thread Starter gurudlan

    (@gurudlan)

    Hello,

    i make test about that import on my different web with wp (different hosting) and result was the same…

    here is my csv…can you try it? link: https://ufile.io/ih9dg

    Thank you

    Plugin Author Javier Carazo

    (@carazo)

    @gurudlan,

    Sorry but we do not provide personal support (not here at least, if you contact us we can provide you proffessional support).

    Opening the file in LibreOffice appears to be ok.

    Thread Starter gurudlan

    (@gurudlan)

    Hello,

    yes, but i report it as bug of plugin… Because it’s not working with special characters…

    Thank you

    Thread Starter gurudlan

    (@gurudlan)

    Hello,

    I fix that.

    It was because in your plugin is user-name and user-login the same. But i need user-login for example set to email and user-name to show from my csv username+lastname(with specialcharacters…).

    But user-login in default in WP is blocked for special characters…Wp remove them.

    Solution is to change tags in csv:

    Username(user-login),email,display_name(=this is for user name display in WP for example: Jaňko? Hra?ko)…

    But i found this solution by debuging WP and user.php where i found how wp create user…

    You maybe need re-name your expected(needed column) Username to => UserLogin and add new needed UserName or UserDisplayName…

    Thank you

    Thread Starter gurudlan

    (@gurudlan)

    Solved

    Plugin Author Javier Carazo

    (@carazo)

    @gurudlan good morning,

    Ok but do not worry, you can:

    • User in the first column the username
    • In any other column from the 3rd one the user_displayname

    Plugin now supports it.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Import without special characters’ is closed to new replies.