Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (4)

Resolved Error when importing users

  1. Rusty320
    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
Responses (4)
admin
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. # 1
Rusty320
Rusty320 Accepted Answer
Pro
Sorry, I remembered at 3:00 AM. Here it is.
  1. more than a month ago
  2. Support
  3. # 2
admin
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)
Schermata 2016-08-04 alle 16.39.47.png Schermata 2016-08-04 alle 16.39.47.png
  1. more than a month ago
  2. Support
  3. # 3
Rusty320
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. # 4
  • Page :
  • 1


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