CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • Would like to View / Edit Member Directory on public side of site - Joomla
Pages: [1]

Author Topic: Would like to View / Edit Member Directory on public side of site - Joomla  (Read 2197 times)

NASC2009

  • I post occasionally
  • **
  • Posts: 32
  • Karma: 0
Would like to View / Edit Member Directory on public side of site - Joomla
May 05, 2010, 12:24:29 pm
We are using Joomla and have the need to display our member Directory on the front end of our site. I see in the manual that it is possible using Drupal but not Joomla v1.5. We would also like to have each registered member to be able to view and edit his own profile after he/she joins our association. Is this possible. Can do need a Joomla programmer to help us or could our website designer possibly do this?

Thank you in advance for your help.

krankie

  • I’m new here
  • *
  • Posts: 22
  • Karma: 2
  • CiviCRM version: 3.3.5
  • CMS version: Joomla! 1.5.22
  • MySQL version: 5.0.22-log
  • PHP version: 5.2.11
Re: Would like to View / Edit Member Directory on public side of site - Joomla
May 16, 2010, 10:41:55 am
I'm fairly new here myself so bear with me.

It isn't currently possible to allow full CiviCRM access at the Joomla Front End due to the absence of granular Access Control in Joomla.  The next version of Joomla, 1.6, will have this but is taking forever to reach a stable release.  I'm waiting patiently on this and in the meantime have had to give the membership secretary a full admin signon to the Joomla back-end.

I suspect once it is eventually released there will be changes required to CiviCRM Joomla release to make use of the Joomla ACL?

However it IS possible to allow users to edit their own Civi Details on Joomla.  You need to create a Profile in CiviCRM with all the required fields on it,  then create a menu item on Joomla of type CiviCRM Profile Edit which makes use of that Profile.
In order for it to work though, you need to sync your Joomla users with your CiviCRM constituents which you do in CiviCRM under Administer > Manage > Synchronise Users to Contacts.

EdP

  • I post frequently
  • ***
  • Posts: 260
  • Karma: 7
  • CiviCRM version: 4.4
  • CMS version: Joomla 2.5.x
Re: Would like to View / Edit Member Directory on public side of site - Joomla
May 16, 2010, 02:05:56 pm
I'm basically in the same position as krankie and would echo his comments.

You start by asking about displaying the member directory. You can do this, or at least something almost identical. If you have a group which all your members belong to (i.e. a smart group which selects all contacts with memberships in the valid states) then you can do a profile search form and (because it allows wildcards) you can see the complete membership list. Depending how you set the profiles up, a user could see quite a lot about other users, search by locality etc.

However, as krankie says I don't think they can then edit, except their own. On that topic:

1. Users will have their Dashboard which shows part of their information. The Dashboard provides a route to see some information held about you, including (depending how permissions have been done) your households and related contacts. This can be a bit hit and miss, and isn't a coherent way to view information or edit it, but is useful for many things.
2. If you let users edit their information, be careful what you let them edit. CiviCRM has no logging system, and so if you let them edit their name you can get very confused because then you will have a name for one contact but partial information about others and no way to detect what got changed. I'd therefore recommend that for editing your profile you don't let them change their name.

tabletguy

  • I post occasionally
  • **
  • Posts: 73
  • Karma: 2
Re: Would like to View / Edit Member Directory on public side of site - Joomla
May 25, 2010, 03:35:38 am
Quote from: krankie on May 16, 2010, 10:41:55 am
However it IS possible to allow users to edit their own Civi Details on Joomla.  ...
In order for it to work though, you need to sync your Joomla users with your CiviCRM constituents which you do in CiviCRM under Administer > Manage > Synchronise Users to Contacts.

Does anyone know a way that does NOT need a Joomla user?  I have almost 5000 contacts in CiviCRM, but only about 100 registered users on the Joomla site. I would like to send out a mailing to contacts asking them to come to the site to review and edit contact details.

Failing the above, does anyone know a way to do the reverse?  I.E. "Synchronize Contacts to Users"?  I don't know the SQL to select the preferred email address, although getting names is easy enough.

EdP

  • I post frequently
  • ***
  • Posts: 260
  • Karma: 7
  • CiviCRM version: 4.4
  • CMS version: Joomla 2.5.x
Re: Would like to View / Edit Member Directory on public side of site - Joomla
May 27, 2010, 03:27:50 am
I think you can do this in theory, as follows:

1. Create the profile that all your civi users will be directed to to edit. In the settings for that profile, select the option which requires them to create a Joomla account. *
2. Send them all an email via CiviMail, with a link to that profile which will be prefilled for them. See checksum tokens http://wiki.civicrm.org/confluence/display/CRMDOC/Mail-merge+Tokens+for+Contact+Data here about that one.

They should then be able to click on that link, be taken to the profile with their info, update it, join Joomla and you're done.

*However, I think that this feature isn't working in 3.1.4. I asked on this forum about it http://forum.civicrm.org/index.php/topic,13711.0.html and Lobo appeared to agree that it didn't work. I don't know whether it got filed as a bug and/or it works for you but I'd be interested to know.
« Last Edit: May 27, 2010, 03:32:38 am by EdP »

tabletguy

  • I post occasionally
  • **
  • Posts: 73
  • Karma: 2
Re: Would like to View / Edit Member Directory on public side of site - Joomla
May 27, 2010, 05:01:30 am
Thanks for the detailed replies (this and other thread).

I had also reported this problem in 3.1.3, but I haven't been able to get it working in either 3.1.4 or 3.1.5. I can generate the emails with the checksum tokens, but when an already registered in Joomla user clicks on that, it brings them to a blank form, or, as I alluded to in the other email, a search form.

I will try turning off "public search" on all fields, and also try it with a form that doesn't have any custom fields, to see if there are any ways to get this to work...

I DO have working profiles if the user a) signs in and then b) selects a MENU option to edit their data. The problem I have there is that I have 4600+ users who are not registered in Joomla, and getting them to do that many steps a) register b) click confirmation link (70+% failure at this step), c) log in d) click the "edit" link...

It's not a very "tech savvy" group of users, unfortunately.  Perhaps a video would help...

I've been thinking of trying to replicate all uses FROM CiviCRM to the joomla user table, but I don't know how (yet) to give them an automatically generated temporary (and unique) password that I could email from CiviCRM...


EdP

  • I post frequently
  • ***
  • Posts: 260
  • Karma: 7
  • CiviCRM version: 4.4
  • CMS version: Joomla 2.5.x
Re: Would like to View / Edit Member Directory on public side of site - Joomla
May 27, 2010, 05:15:56 am
Presumably however you first populate the Joomla users (and I suppose those pw's have to be hashed) you create a copy of each password as a Civi Custom Data field. That field you can email out easily enough, and it need not be visible to the user ever again.

For these users;
1. They can either be directed to a profile which has nothing for them to enter other than the Joomla signup or they can edit all their data at that step (if it works at all, obviously), whichever you think is easier for them.
2. The Joomla signup confirmation email is useful for checking that the person isn't a spammer and typed their address right. However, you can activate users who haven't clicked on the link from the backend (and presumably via a general SQL query too, if you're not up for 4,700 manual bypass operations).

However, getting them to ever log in again is a challenge!

tabletguy

  • I post occasionally
  • **
  • Posts: 73
  • Karma: 2
Re: Would like to View / Edit Member Directory on public side of site - Joomla
May 27, 2010, 07:53:42 am
Quote
you create a copy of each password as a Civi Custom Data field.

Actually, that's the step I haven't figured out yet. I haven't found the documentation on how to join the CiviCRM user with a specific custom field value. I already have the custom values set up, etc. I even populated a couple manually, and then went searching...

From `civicrm_custom_group`.Table_Name I can look up the value table. Since for me it's fixed, I don't need to put this part into a query!

In my case table is : civicrm_value_bridge_5

I'm at a loss as to what to link to. :(

From that table, I just discovered a new trick with phpMyAdmin ... If the table has an FK relationship for a field, one can click directly on the row value to generate a query. That query "revealed" the relationship :)

SELECT * FROM `<myDb>`.`civicrm_contact` WHERE `id` =14588;

only three fields in the table:
  • id -- Just a primary key
  • entity_id -- Links to `civicrm_contact`
  • loginid_20  (What I chose to match up with Joomla, for testing)

When I looked at the table a couple days ago, the very large "14588" value fooled me into not believing it could be as simple as the contacts table....

Well, off to play around.

Thanks for tips and encouragement.

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Would like to View / Edit Member Directory on public side of site - Joomla
May 27, 2010, 07:36:32 pm
Regarding your scenario: you have lots of imported CiviCRM contacts, but only a few Joomla users and you want everyone to login and update their details.  To accomplish this:

1) Create a CiviCRM profile that contains the fields you want people to see/update.  Configure the profile to require a Joomla login.

2) Create a Joomla menu item of type "CiviCRM -> Edit Profile "  . Restrict this menu item to "registered"

3) email the hyperlink to the new page out to the masses.

4) The moment a logged in user submits the profile, their existing CiviCRM contact record will be updated.  If there is not a "matching" contact record, a new contact record will be created.  ( Matches are based on the settings in the CiviCRM dedup global settings ). The default rule for matches is email address only. 


  This does not require any coding to solve. To
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • Would like to View / Edit Member Directory on public side of site - Joomla

This forum was archived on 2017-11-26.