The Canadian node manager is not surfaced in the portal

14852
Reporter: jlegind
Assignee: ahahn
Type: Bug
Summary: The Canadian node manager is not surfaced in the portal
Priority: Major
Resolution: Fixed
Status: Closed
Created: 2014-01-21 10:42:23.563
Updated: 2015-07-16 16:19:08.87
Resolved: 2015-07-16 16:19:08.818
        
Description: The new node manager for Canada is James Macklin which the drupal live database also states. As per Cip:
{quote}
I'm sorry but the information has been synchronized long time ago. The proof is in the SQL which can be run against the drupal_live DB

SELECT gbifims_Contact.Name_First, gbifims_Contact.Name_Last, gbifims_Grouprole.Name, gbifims_Node.Name_Full FROM gbifims_Contact LEFT JOIN gbifims_ContactGrouproleNodeParticipant ON gbifims_Contact.ContactID = gbifims_ContactGrouproleNodeParticipant.ContactID
LEFT JOIN gbifims_Grouprole ON
gbifims_ContactGrouproleNodeParticipant.GrouproleID = gbifims_Grouprole.GrouproleID LEFT JOIN gbifims_Node ON gbifims_ContactGrouproleNodeParticipant.NodeID
= gbifims_Node.NodeID
WHERE Name_First="James" AND Name_Last="Macklin" AND Address LIKE "%Canada%" AND Active="1"

Wich returns

Name_First    Name_Last  Name           Name_Full
James         Macklin    Nodes Staff    Canada Biodiversity Information
Facility
James         Macklin    Node Manager   Canada Biodiversity Information
Facility

In other words he IS Node Manager for CaBIF! :-o Now why the portal doesn't read it like this? I think only Markus would be able to answer this. Most likely the SQL didn't account for the situation where a person can have multiple roles, especially for the same institution/country/etc...
{quote}]]>
    

Author: ahahn@gbif.org
Comment: Supposed reason: the group membership in the IMS specifies "Nodes Committee: Node Manager" and "Nodes Staff: Nodes Staff" roles as active, but the group membership of "Nodes Staff: Node Manager" as inactive. Checking with IMS editors whether this can be changed.
Created: 2014-04-28 15:11:49.117
Updated: 2014-04-28 15:11:49.117

Author: ahahn@gbif.org
Comment: Reported fixed on the IMS side. Checking that the updates makes it through to the portal page.
Created: 2014-04-30 15:31:18.399
Updated: 2014-04-30 15:31:18.399

Author: ahahn@gbif.org
Comment: apparently solved - closing
Created: 2015-07-16 16:18:58.63
Updated: 2015-07-16 16:18:58.63