Support

  1. wirecreative
  2. Bug Report
  3. Friday, May 01 2015, 09:58 PM
Hi, I'm another person having trouble importing users from a CSV. I keep getting the message:
Missing some required fields: Email, Name or Firstname


I have email & firstname noted in my first row. I've tried shorter files, longer files, fewer columns, checked the encoding, using ";" instead of "," as a delimiter; I just can't get it to work. Can you please look at this file and let me know what I'm doing wrong?

Thanks,
Greg
Attachments (1)
admin Accepted Answer
Admin
If I buy the full version, is it possible to set some fields to auto-populate during registration?
To do this, you need to develop custom plugin, follow these steps:
- Download, install and enable our Skeleton plugin (you can download at the end of this page https://www.easy-profile.com/docs/44-triggers.html)
- Open file /plugins/jsn/skeleton/skeleton.php
- Remove sample functions: triggerFieldAvatarUpdate and triggerProfileUpdate
- Add this function:
triggerProfileUpdate($user,&$data,$changed,$isNew){ 
if($isNew){
// Make your code to auto-populate fields
// To auto-populate Easy Profile custom fields you can use this code $data['field_alias']='your-value'
$data['OurID']=$user->id;
$data['MemberDate']=$user->registerDate;
}
}


is it possible to import the new users into a specific User Group?
No, but you can set specific usergroup with 2 ways after import
1. Users are added into Default Registrered group, you can select this from Users->User Manager->Option->New User Registration Group parameter
2. After import all imported users have same Registered Date, so you can order by Registered date and with Batch Process add these into specific usergroup
  1. more than a month ago
  2. Bug Report
  3. # 1
wirecreative Accepted Answer
Pro
BTW, is it possible to import the new users into a specific User Group? I've tried setting the values in the "Type" column to both the group name and the group ID #, but in both cases the new users are placed in the Registered group.

Thanks.
  1. more than a month ago
  2. Bug Report
  3. # 2
wirecreative Accepted Answer
Pro
OK, thanks. I was hoping to get their register date synced with the date they joined our organization, but I'll to make iut a separate field. Was also hoping to sync the UserID with the numeric IDs weve been using offline for years, but that's OK.

I changed those field and imported 3 users successfully.

If I buy the full version, is it possible to set some fields to auto-populate during registration?

That is, if we add custom fields for that legacy data, named OurID and MemberDate, can we set them so for new members these fields will populate with the same data as UserID and RegisterDate?

Thanks for all your help!
  1. more than a month ago
  2. Bug Report
  3. # 3
admin Accepted Answer
Admin
Hi,
registerdate appears to a valid field. Is that one not importable?
Hi, yes this column is not importable, register date is generated by plugin and is date of importation.

Also, it would let me attempt to import the UserId
no sorry this is not possible, if you want to copy IDs and register date from another Joomla installation you need to do this:
- Export with SQL manager (like PhpMyAdmin) data from table #__users of old DB
- Import with SQL manager these data into table #__users (change prefix of table) of new DB
- Now you have all users without usergroups, so go to Joomla Administration->User Manager and add "Registered" group with "Batch Process" button
- Import only Easy Profile custom fields and email address (to identify the user)
  1. more than a month ago
  2. Bug Report
  3. # 4
wirecreative Accepted Answer
Pro
OK, that made some progress! Semicolons work, but now I'm getting a new error:

"ERROR: 1054

Unknown column 'registerdate' in 'field list' SQL=INSERT INTO tt8zw_jsn_users(id,`firstname`, `lastname`, `PersonID`, `secondname`, `Addr1`, `Addr2`, `Addr3`, `City`, `State`, `ZIP`, `PhnHome`, `PhnOffice`, `PhnMobile`, `registerdate`, `Type`, `PersonNote`, `NoticeText`, `user_signature`) VALUES(924, 'Byron', 'Odle', '2', 'Murphy', '123 Street Lane', '#333', 'Gladstone', 'Clackamas', 'OR', '97027', '503 555-5555', '503 555-4444', '503 555-33333', '04/13/2015', 'Producer', 'Is a person.', 'Not really a person.', 'Signed')"

registerdate appears to a valid field. Is that one not importable?

Also, it would let me attempt to import the UserId. I had to remove that column. Is it not possible to set the ID to a specific value? If possible, we'd like that to correspond with our existing customer numbers.

Thanks for your help on this. If I can get this working, I will be purchasing the pro version.

Greg
  1. more than a month ago
  2. Bug Report
  3. # 5
admin Accepted Answer
Admin
Try to use ";" as separator instead ","
  1. more than a month ago
  2. Bug Report
  3. # 6
wirecreative Accepted Answer
Pro
Here's my latest file, attached.
  1. more than a month ago
  2. Bug Report
  3. # 7
admin Accepted Answer
Admin
Can you please post me new CSV file? we will check it
  1. more than a month ago
  2. Bug Report
  3. # 8
wirecreative Accepted Answer
Pro
I've tried that. I get the same error.
  1. more than a month ago
  2. Bug Report
  3. # 9
admin Accepted Answer
Admin
Hi,
sorry for late reply,

try to remove quote from Columns and Values.
  1. more than a month ago
  2. Bug Report
  3. # 10
  • 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

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.