Issue 13834

Node manager contact not showing for Israel

13834
Reporter: lilia
Assignee: ahahn
Type: Feedback
Summary: Node manager contact not showing for Israel
Priority: Critical
Resolution: Fixed
Status: Closed
Created: 2013-09-12 10:20:11.471
Updated: 2013-10-04 11:46:34.367
Resolved: 2013-10-03 17:11:46.185
        
        
Description: In the IMS there is a Node manager entered for Israel, but he is not shown on the country page. Could it be because he is also their Head of Delegation? As HoD he appears on the country page, but not as Node manager.

Lina

*Reporter*: Lina
*E-mail*: [mailto:lilia]]]>
    

Attachment groupRoles.png


Attachment NodeManagerGroups.png



Author: ahahn@gbif.org
Comment: I can confirm that the node manager is stored with the node entry, institutionID 191
Created: 2013-09-27 11:41:11.193
Updated: 2013-09-27 13:30:17.18


Author: ahahn@gbif.org
Created: 2013-10-03 16:36:02.415
Updated: 2013-10-03 16:36:02.415
        
The immediate cause for this is the filter for grouprole ids line 53 in https://code.google.com/p/gbif-portal/source/browse/drupal-mybatis/trunk/src/main/resources/org/gbif/drupal/mybatis/ImsNodeMapper.xml#53. In the IMS, table __Grouprole contains multiple entries for certain roles, referencing different groups (see screenshot). The groups currently linked to the Node Manager Grouprole in the IMS are: 3 (Nodes Committee), 14 (SEP-CEPDEC) and 31 (Nodes Staff). The filter only considers the Nodes Staff group:
 JOIN gbifims_Group g ON gr.GroupID = g.GroupID AND gr.GroupID in (11,12,13,31) 

Assuming that it is correct that the Nodes Committee group is not supposed to be listed on participant node pages, the contact relationship table should use the Node Manager grouprole that is linked to the Nodes Staff group (__Grouprole.__kp_ID=105, not = 14). Updated table __ContactGrouproleNodeParticipant._kf_GrouproleID accordingly for record 4395.
    


Author: ahahn@gbif.org
Comment: In essence: this is an IMS data management issue; I am not sure how accidents like this can be prevented in the IMS editor - is it possible to chose between the three different groups that the Node Manager role belongs to, to pick the right entry?
Created: 2013-10-03 16:38:16.129
Updated: 2013-10-03 16:38:16.129


Author: ahahn@gbif.org
Comment: Correction: the issue was due to a missing entry in the "GBIF Nodes Database" form, assigning the contact Grouprole=Node Manager to the Group=Nodes Staff. The previously existing entry, assigning to Group=Nodes Committee was correct (and has now been restored), being needed in other contexts. For the participant pages, however, the "Nodes Staff" group is the relevant one.
Created: 2013-10-04 11:46:34.302
Updated: 2013-10-04 11:46:34.302