Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Thursday 11:42 pm
Add a reply View Replies (1)

Resolved Support for national characters in import script

  1. NielsHenrik
    NielsHenrik
  2. General
  3. Wednesday, March 01 2017, 12:07 PM
I have imported several hundred users with the import script, and I have found out, that there is no support for national characters.
If a name field contains a national character (in danish æ, ø or å) that user is not imported. National characters in other fields are converted to ?.
I am in the process of creating the rejected users manually and editing out the ?.
Responses (1)
admin
admin Accepted Answer
Admin
Hi,
this is due to charset of Exported CSV.

For example if your CSV come from Excel probably it have Windows-1252 or ISO-8859-1 charset, but Mysql server probably use UTF-16.

Works with charset is not simple, we recommend to make some test with some tools like notepad++ (windows). this is a text editor that allow you to change charset encoding.
  1. more than a month ago
  2. General
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.