Support

  1. Rusty320
  2. Support
  3. Thursday, August 04 2016, 07:14 AM
Hi,

I've read all the similar posts I can find but we are still having problems importing users. We are working on a staging site, which is backed up regularly, so no problems with messing anything up.

Can you please try the attached file and advise where we are failing? Each time we try we get an error, the last one being "Error Unknown fields: username"

Thanks for your help,

Alan
Rusty320 Accepted Answer
Pro
Thanks for your help. I couldn't see the strange characters when I opened the file. After some research (which may help others with the same issue) I changed my Windows (7) settings to have the delimiter set to ";" rather than "," so I didn't have to find and replace all of these in Notepad ++. Search for "how to change field separator in excel". Strange it's a Windows setting and not an Excel setting.

I also used the import feature in Excel rather than the "open file". This way I could set the delimiter, see the columns and the they didn't all go under one column as I had before.

After doing this and another test import it worked fine. Now onto the import of over 10,000 members with multiple fields. I think I may need some further assistance soon though.

Thanks for a wonderful product and your excellent support.

Alan
References
  1. http://superuser.com/questions/291445/how-do-you-change-default-delimiter-in-the-text-import-in-excel
  2. https://support.office.com/en-us/article/Import-data-using-the-Text-Import-Wizard-40c6d5e6-41b0-4575-a54e-967bbe63a048
  1. more than a month ago
  2. Support
  3. # 1
admin Accepted Answer
Admin
Hi,
when I open this file with Excel I see some strange char in first line (see screenshot). try to delete first line and rewrite it manually with some text editor tool like NotePad++

PS. I have removed your attachment for privacy purpose :D
Attachments (1)
  1. more than a month ago
  2. Support
  3. # 2
Rusty320 Accepted Answer
Pro
Sorry, I remembered at 3:00 AM. Here it is.
  1. more than a month ago
  2. Support
  3. # 3
admin Accepted Answer
Admin
Hi,
this forum does not accept .csv files, so reject it. Can you please resend in a ZIP format :D ?
  1. more than a month ago
  2. Support
  3. # 4
  • 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 Online

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.