Easy Profile - Joomla Extension

Hi,
sorry for late reply,

try to remove quote from Columns and Values.

I've tried that. I get the same error.

Can you please post me new CSV file? we will check it

Here's my latest file, attached.

Try to use ";" as separator instead ","

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

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)

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!

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.

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