Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. 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: Thursday 11:51 pm
Add a reply View Replies (5)

Resolved Can't get phone number to show in User List or User Table

  1. ScubaGuy
    ScubaGuy
  2. Support
  3. Friday, April 14 2017, 05:09 PM
Phone, which seems to be a core field in the J! user setup is not visible in my Easy Profile setup, whereas email, for example, is. I've manually added a phone field in Easy Profile, but it doesn't show the data that's in the core user field.

This is probably a classic "duh" moment, but how can I get the phone number to show in Easy Profile lists?

Thanks!
Accepted Answer
admin
admin Accepted Answer
Admin
I can try the query, but I assume I'd have to do this every time a new user registers, correct?
My solution is useful to import value from "User - Profile" plugin to Easy Profile, after import you should use Easy Profile phone field instead "User - Profile" plugin phone field.

So when user edit own profile (or register a new account) then he will change the value of Easy Profile phone field.

You can disable "User - Profile" plugin phone field from Extensions->Plugins->User - Profile
  1. more than a month ago
  2. Support
  3. # Permalink
Responses (5)
admin
admin Accepted Answer
Admin
Hi,
sorry for late reply :D

Phone field is not a Joomla core field, it come from plugin called "User - Profile".

Easy Profile extends Joomla user management (not replace), so you can works with all Joomla User Plugins, but, of course, with Easy Profile you can only manage Easy Profile fields.
  1. more than a month ago
  2. Support
  3. # 1
ScubaGuy
ScubaGuy Accepted Answer
Pro
Thanks for your reply.

I see ... so is there a way I can "import" the phone data from the user plugin into Easy Profile and include it in, for example, the list of users? It would be of some importance to the functionality...

Thanks & Happy Easter!
  1. more than a month ago
  2. Support
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
Thanks & Happy Easter!
Thanks and too you!! :D

I think the best way is to create a phone field with Easy Profile and import all data from "User - Plugin" into Easy Profile with a simple query like this:
UPDATE prefix_jsn_users SET phone = ( SELECT REPLACE( profile_value ,'"' , '' ) FROM prefix_user_profiles WHERE profile_key = "profile.phone" AND user_id = prefix_jsn_users.id )

replace "phone" with alias of Easy Profile phone field, and "prefix_" with your Joomla DB prefix.

NOTE:
you can launch this query with a DB manage tool like PhpMyAdmin normally it is provided from all hosting provider.
  1. more than a month ago
  2. Support
  3. # 3
ScubaGuy
ScubaGuy Accepted Answer
Pro
Many thanks for your help ... and on Easter Sunday! Great service.

I can try the query, but I assume I'd have to do this every time a new user registers, correct?

Thanks,

Roger
  1. more than a month ago
  2. Support
  3. # 4
ScubaGuy
ScubaGuy Accepted Answer
Pro
Brilliant! Thanks so much for this excellent support! I've added the extra field, copied the information from the user profile plugin and activated that plugin. Works like a charm!

Much appreciated!!
  1. more than a month ago
  2. Support
  3. # 5
  • Page :
  • 1


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