Support

  1. woluweb
  2. General
  3. Tuesday, January 19 2021, 02:39 PM
  4.  Subscribe via email
Hi there,

I had seen that nice feature
Joomla Contacts Component Integration
If user is linked to contact you will see a direct link to contact page on User Profile Page.


and indeed it works
- with the Contacts which were previously manually created
- and also for the newly Registered Users since I enabled the plugin "Users - Contact Creator"

But what about the pre-existing Users ? How can I get them available as well in the Contacts ?

Any solution would do:
- SQL
- from the interface
- a hack of the plugin
- ...

(I apologize: I am aware that as such this is more a Joomla issue than an EasyProfile issue. But the question arises bc I want to take advantage of that EasyProfile feature... but I already have 500 Users :D )
admin Accepted Answer
Admin
Hi,
the best way is to use an SQL query like this
INSERT INTO prefix_contact_details(user_id,name,alias,catid,published,access,language,params,metakey,metadesc,metadata) SELECT id,name,username,11,1,1,"*","","","","" FROM prefix_users WHERE prefix_users.id NOT IN (SELECT user_id FROM prefix_contact_details)


This query should avoid duplicates.

NOTES:
- You need to replace "prefix" with your Joomla prefix ID
- Before launch this query you could check if the category ID is 11 (like my query)
  1. more than a month ago
  2. General
  3. # 1
woluweb Accepted Answer
Pro
That's excellent !
I have just tested and it works fine.

FYI, somebody else pointed this extension to me : https://github.com/pieter-groeneweg/joomla_plg_usersynccontact
It even synchronises :)
(it goes beyond what I needed here but it is good to know :) )

Txs again for your excellent support!
  1. more than a month ago
  2. General
  3. # 2
  • Page :
  • 1


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

Request Support

Support is currently Online

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.