sorry, I have not upload the CSV file, please see the attachment. thank you.

attachment.

sorry, I encounter another problem, I have uploaded the CSV file but got the different error message, please see the attachment "error.png".

my CSV file contains Chinese text field, so after uploading CSV file, the error message display the garbled of all Chinese field.

but in user management of joomla, there are users imported, but no name field to choose, please see the attachment "screenshot2.png".

please help me to solve this problem. thank you very much.

I keep trying and error.

I change the CSV file format to UTF-8, but after uploading the file, no matter what the first field is, it display the error message "Unknown fields: XXXXXX", for example, the first filed is "number", the message "Unknown fields: number", the first filed is "title", the message "Unknown fields: title",

I wonder why ?

Hi,
sorry for late reply, it was night for us.
I can't see attachment, this forum accept only images and .zip files. Can you please compress your CSV file to zip and re-send?

ok, thank you.

I have attached the zip of CSV file.

please check it.

Hi,
the problem is due to ";" separator in some line,
You have declared 13 fields:
memberid;group;company;title;firstname;phone;fax;email;website;address;products;username;password

but for example in row like this (line 20 of your file) you have some value with ";" char, so the line seems to have more than 13 fields:
332;0;嘉明機械(股)公司;顧問;江福全;+886-4-22332281;+886-4-22306247;cm.pet@msa.hinet.net;;台中市北區東成路90號;"中空成型機;PET二步法拉吹機;PET射拉吹機;押出成型;整廠設備製造";TRP332;

for this line you have products value like "中空成型機;PET二步法拉吹機;PET射拉吹機;押出成型;整廠設備製造", this contain many ";" chars.

ok, thank you very much.

I will try to edit the CSV file to meet the requirement.

if problem still occur, I will report and need further help.

thank you.

hello

I edit the CSV file for proper format and import it successfully without error message, it show me "281 user imported".

but in user management, there is no name field for me to click to enter the user detail, please see the screenshot.

why ?

please help me to solve the problem.

thank you very much.

I attach the screenshot of no name field to edit, thank you.

Hi,
try to use UTF8 encoding, I can't open correctly your last CSV (see screenshot)

sorry, I have attached the CSV file with UTF-8 encoding.

please try again.

thank you.

Hi,
I think there is some encoding problem.

Try to re-create a new UFT8 file with some tools like NotePad++, rewrite manually first line and copy/past users infos.

Hi,
for me works, see screenshot

I found a problem at first line in your file, there some strange hidden char, so I have copied all content in a new file.

NOTE: Some username and email address missing and some email are not correctly, so some users can have access problem on your site.
NOTE2: You assign a empty password, but this is not allowed by Joomla, remove password column, the system will generate a new one for each user.