Support

  1. chen-hui-ching
  2. Support
  3. Wednesday, July 06 2016, 03:29 AM
hello

I use "import user plugin" to import my users CSV file, but after uploading my CSV file I got a error message of "invalid address", please see the attachment.

please help me to check my CSV file and find out where the problem is, thank you.

if further you want the site details, please tell me and I will give you, than you.
Attachments (1)
admin Accepted Answer
Admin
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.
Attachments (2)
  1. more than a month ago
  2. Support
  3. # 1
chen-hui-ching Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Support
  3. # 2
admin Accepted Answer
Admin
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.
  1. more than a month ago
  2. Support
  3. # 3
chen-hui-ching Accepted Answer
Pro
sorry, I have attached the CSV file with UTF-8 encoding.

please try again.

thank you.
  1. more than a month ago
  2. Support
  3. # 4
admin Accepted Answer
Admin
Hi,
try to use UTF8 encoding, I can't open correctly your last CSV (see screenshot)
Attachments (1)
  1. more than a month ago
  2. Support
  3. # 5
chen-hui-ching Accepted Answer
Pro
I attach the screenshot of no name field to edit, thank you.
  1. more than a month ago
  2. Support
  3. # 6
chen-hui-ching Accepted Answer
Pro
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.
  1. more than a month ago
  2. Support
  3. # 7
chen-hui-ching Accepted Answer
Pro
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.
  1. more than a month ago
  2. Support
  3. # 8
admin Accepted Answer
Admin
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;[email protected];;台中市北區東成路90號;"中空成型機;PET二步法拉吹機;PET射拉吹機;押出成型;整廠設備製造";TRP332;

for this line you have products value like "中空成型機;PET二步法拉吹機;PET射拉吹機;押出成型;整廠設備製造", this contain many ";" chars.
  1. more than a month ago
  2. Support
  3. # 9
chen-hui-ching Accepted Answer
Pro
ok, thank you.

I have attached the zip of CSV file.

please check it.
  1. more than a month ago
  2. Support
  3. # 10
admin Accepted Answer
Admin
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?
  1. more than a month ago
  2. Support
  3. # 11
chen-hui-ching Accepted Answer
Pro
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 ?
  1. more than a month ago
  2. Support
  3. # 12
chen-hui-ching Accepted Answer
Pro
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.
  1. more than a month ago
  2. Support
  3. # 13
chen-hui-ching Accepted Answer
Pro
attachment.
  1. more than a month ago
  2. Support
  3. # 14
chen-hui-ching Accepted Answer
Pro
sorry, I have not upload the CSV file, please see the attachment. thank you.
  1. more than a month ago
  2. Support
  3. # 15
  • Page :
  • 1


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

Request Support

Support is currently Offline

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.