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!
Support
Hi,
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.
Thanks & Happy Easter!Thanks and too you!!
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.
- Page :
- 1
There are no replies made for this post yet.
However, you are not allowed to reply to this post.
However, you are not allowed to reply to this post.
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.