Issue 14030

'Member since' column missing some values in participant list

14030
Reporter: feedback bot
Assignee: mdoering
Type: Bug
Summary: 'Member since' column missing some values in participant list
Description: The column showing 'member since' is blank for several Participants.
Priority: Critical
Resolution: Fixed
Status: Resolved
Created: 2013-09-24 11:34:16.495
Updated: 2014-01-20 16:27:40.533
Resolved: 2014-01-20 16:27:40.505
        
    


Author: ahahn@gbif.org
Comment: This relates to the IMS information import; need to show at least the year, better the full date, for all participants. Current issue, if I understand correctly, is a data type incompatibility between the two systems
Created: 2013-09-25 17:30:08.006
Updated: 2013-09-25 17:30:08.006


Author: thirsch@gbif.org
Comment: Actually year would be fine, but need to have a value for all participants to avoid confusion
Created: 2013-09-26 19:30:52.906
Updated: 2013-09-26 19:30:52.906


Author: ahahn@gbif.org
Comment: After having been fixed at some point, the issue reappeared at http://www.gbif.org/participation/list: The 2013 values are missing again.
Created: 2013-10-28 12:11:33.994
Updated: 2013-10-28 12:11:33.994


Author: thirsch@gbif.org
Comment: Just to clarify, the missing ones are Chinese Academy of Sciences (2013), the European Environment Agency (2010) and Vertnet (2013).
Created: 2013-10-28 14:04:40.107
Updated: 2013-10-28 14:04:40.107


Author: omeyn@gbif.org
Comment: [~cvizitiu@gbif.org] also interesting for you
Created: 2014-01-20 11:48:47.444
Updated: 2014-01-20 11:48:47.444


Author: mdoering@gbif.org
Created: 2014-01-20 15:32:10.481
Updated: 2014-01-20 15:32:10.481
        
the live drupal db seems to be fine.
The mapper sql query returns the year correctly too.

{noformat}
mysql> SELECT p.ParticipantID AS imsId, c.ISO2 AS country, n.Name_Full AS title, p.Name_Full AS participantTitle, p.Name_Short AS abbreviation, n.URL AS homepage,   p.Name_Full AS participantTitle, p.Member_AsOf AS participantSince, p.PublicDescription AS description,   null AS modified,   i.Name AS institution, i.Address AS address, i.City AS city, i.ZipCode AS postalCode, i.State AS province, i.Telephone AS phone, i.Email AS email,   p.GBIFmembership, null AS Region, p.MOU2012_Date AS MOU2012_Date  FROM gbifims_Node n   JOIN gbifims_Participant p ON n.ParticipantID = p.ParticipantID   LEFT JOIN gbifims_Country c ON p.CountryID = c.CountryID   LEFT JOIN gbifims_Institution i ON p.InstitutionID = i.InstitutionID  WHERE p.ParticipantID = 361;
+-------+---------+---------+------------------+--------------+----------+------------------+---------------------+---------------------+----------+----------------------------+---------+------+------------+----------+-------+-------+-----------------------------+--------+---------------------+
| imsId | country | title   | participantTitle | abbreviation | homepage | participantTitle | participantSince    | description         | modified | institution                | address | city | postalCode | province | phone | email | GBIFmembership              | Region | MOU2012_Date        |
+-------+---------+---------+------------------+--------------+----------+------------------+---------------------+---------------------+----------+----------------------------+---------+------+------------+----------+-------+-------+-----------------------------+--------+---------------------+
|   361 | NULL    | VertNet | VertNet          | VertNet      |          | VertNet          | 2013-08-01 12:00:00 | http://vertnet.org/ |     NULL | Information not available  |         |      |            |          |       |       | Other Associate Participant |   NULL | 2013-08-17 12:00:00 |
+-------+---------+---------+------------------+--------------+----------+------------------+---------------------+---------------------+----------+----------------------------+---------+------+------------+----------+-------+-------+-----------------------------+--------+---------------------+
1 row in set (0.00 sec)
{noformat}

But the ws still returns it wrongly, bypassing varnish:
http://jawa.gbif.org:8080/b_registry-ws/node/d205def7-82c3-472a-be4b-31d11dcd51fd

    


Author: mdoering@gbif.org
Created: 2014-01-20 15:43:25.935
Updated: 2014-01-20 15:43:25.935
        
Turns out that the IMS participant ids are missing in the registry for the nodes in question.
[~ahahn@gbif.org], could you liase with Jan, Lina, Susanne or who is managing the IMS to enter the missing ones in the registry console please?

----------

registry=# select n.key,n.title from node n left join node_identifier ni on n.key=ni.node_key where identifier_key is null order by title;
                 key                  |                           title
--------------------------------------+------------------------------------------------------------
 41d4686c-f6b7-42ec-aa54-a5792700e784 | BioNET-SAFRINET
 e760dc6f-dd68-474d-ab41-bd3588571793 | Chinese Academy of Sciences
 2970c4c9-9169-41b6-91b7-a3a176e66946 | Equatorial Guinea
 844d4915-35d0-4bf7-ae86-dcfcd1a81026 | European Environment Agency
 c13e0e4a-bb5b-4bd8-8fa9-aa0dba71698a | Finding Species
 86b37808-0fa3-489a-af1f-53e72b2d75ce | Freshwater Biological Association - FreshwaterLife
 02c40d2a-1cba-4633-90b7-e36e5e97aba8 | GBIF Secretariat
 ecc358f9-a1ad-4cca-aba3-70265c630c23 | International Commission on Zoological Nomenclature (ICZN)
 6b02945e-1567-4cd1-8f3b-86c355cfe9ea | International Species Information System
 b31933e2-061d-46b3-be69-dc6dd82066dd | Major Systematic Entomology Facilities
 d205def7-82c3-472a-be4b-31d11dcd51fd | VertNet
 140074eb-2d9e-4289-8f51-7d987841013d | World Data Center for Biodiversity and Ecology (WDCBE)
 3a9a7db1-988f-4d90-99ee-b4dbe868a27c | World Data Center for Biodiversity and Ecology (WDCBE)
 5025e030-ce5b-4fc0-bb8d-009b12e6f934 | World Federation for Culture Collections (WFCC)
(14 rows)
    


Author: ahahn@gbif.org
Comment: Participant IDs (from the IMS) entered for the three concerned participants: EEA (ID 349), CAS (ID 363), VertNet (ID 361). Values needed to be added to the Identifiers for each Node (type: gbif_participant). Verify that the entries are complete again at http://www.gbif.org/participation/list#other within 1h.
Created: 2014-01-20 16:03:19.73
Updated: 2014-01-20 16:03:19.73


Author: ahahn@gbif.org
Comment: The portal list is ok now, back to you, [~mdoering@gbif.org]
Created: 2014-01-20 16:11:53.89
Updated: 2014-01-20 16:11:53.89