Support

    You are here:  
  1. Home
  2. Support
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. 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: Sunday 3:40 pm
Add a reply View Replies (8)

Resolved import csv

  1. tonnick
    tonnick
  2. General
  3. Wednesday, March 04 2015, 04:17 PM
Hello

I cannot find the information about importing user using csv file, and about those field :
- which is the syntax for checkboxlist fields ?
- How can I define the groups of the users imported ?
- how is username generated ?

thx for your feedback !
Responses (8)
admin
admin Accepted Answer
Admin
Hi,
which is the syntax for checkboxlist fields ?
JSON, so: 
["music","movie"]

How can I define the groups of the users imported ?
Not possible, all users have default registered group (set into Users->User Manager->Options->New User Registration Group parameter)
how is username generated ?
Username is based from name column (or firstname_lastname)
  1. more than a month ago
  2. General
  3. # 1
tonnick
tonnick Accepted Answer
Basic
If there is no specified username field, it will be generated for new users >>> it has not been generated.

regarding the checkbox, it did not work either. I guess because ["music","movie"] turned into "[""music"",""movie""]" in my file
  1. more than a month ago
  2. General
  3. # 2
tonnick
tonnick Accepted Answer
Basic
as well my first column has not been imported. Has the first column to be username ?
  1. more than a month ago
  2. General
  3. # 3
admin
admin Accepted Answer
Admin
Has the first column to be username ?
Not, order of columns is not important.

as well my first column has not been imported
Strange, can you please post me you CSV file* (same structure but samples data)

*You need to compress in ZIP format because this forum prohibits CSV extensions
  1. more than a month ago
  2. General
  3. # 4
tonnick
tonnick Accepted Answer
Basic
in attachement.
-username has not been generated
- first column has not been imported
- some user were corrupted, as I could not modify username (to put one)
- centro de interese were not imported either (but I guess due to wrong syntax)
  1. more than a month ago
  2. General
  3. # 5
admin
admin Accepted Answer
Admin
username has not been generated
Remove Username column, otherwise you declare a empty username.
first column has not been imported
Can you please post me your site details, we need to see your fields. You can fill the form below reply in "Site Details" tab.
some user were corrupted, as I could not modify username (to put one)
Maybe some problem with empty usernames. We need to check.
centro de interese were not imported either (but I guess due to wrong syntax)
Yes wrong syntax, example: you wrote "[""musica"",""literatura"",""teatro"",""arte_visual"",""bienestar""]" instead ["musica","literatura","teatro","arte_visual","bienestar"]
  1. more than a month ago
  2. General
  3. # 6
tonnick
tonnick Accepted Answer
Basic
Remove Username column, otherwise you declare a empty username

ok you mean if I want to let the plugin generate a username, I have to remove the column ?
  1. more than a month ago
  2. General
  3. # 7
admin
admin Accepted Answer
Admin
ok you mean if I want to let the plugin generate a username, I have to remove the column ?
Yes, Import Plugin is a simple tool to write user data directly on DB.
  1. more than a month ago
  2. General
  3. # 8
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.

Request Support

Support is currently Offline
Ask a Question
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00

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.

We use a few cookies

Our site uses non fat, delicious cookies which help us improve your user experience. You can read more about it in our Legal page.