Infosys Contributions count Not reflected at devstats

[Mohit-Nain]

Hi @lukaszgryglicki , again there have been contributions from Infosys where PRs have been merged to Kubernetes website but the count is not reflect at devstats.
Below are the PRs:
kubernetes/website#14669
kubernetes/website#14440
kubernetes/website#14439
kubernetes/website#14383
kubernetes/website#14355
kubernetes/website#14354

All of these have been contributed by [email protected] in last 30 days.

We had reconfirmed the count to be 72 during month of April 2019, but even today the count remains 72, however there have been contributions from Infosys.

[lukaszgryglicki]

I don't have that user data imported into DevStats yet. It will be imported during the next affiliations import, ETA Monday. Please also let me know which dashboard you are referring to.

[Mohit-Nain]

https://k8s.devstats.cncf.io/d/9/companies-table?orgId=1

this is the one we are referring

[lukaszgryglicki]

OK, will import new affiliations and then let you know when corrected. Please note that we're importing new affiliations data about 1-2 times/month.

[lukaszgryglicki]

The new affiliations are imported. It now shows 152 contributions from 5 contributors. I've also double checked rajesh.deshpande02 user and He's affiliated to Infosys in JSOn file at 1121299 line.

[Mohit-Nain]

is there a way to check details of these 5 contributors?

[lukaszgryglicki]

There is no dashboard showing all those details, k8s community didn't want such company-related additional dashboards.
I've pulled this data for you manually:

allprj=# select a.login, a.name, ae.email, an.name from gha_actors a, gha_actors_emails ae, gha_actors_names an where a.id = an.actor_id and a.id = ae.actor_id and a.id in (select actor_id from gha_actors_affiliations where company_name = 'Infosys');
       login       |         name         |                        email                        |         name         
-------------------+----------------------+-----------------------------------------------------+----------------------
 rajeshdeshpande02 | Rajesh Deshpande     | [email protected] | Rajesh Deshpande
 rajeshdeshpande02 | Rajesh Deshpande     | [email protected]                      | Rajesh Deshpande
 rajeshdeshpande02 | Rajesh Deshpande     | [email protected]          | Rajesh Deshpande
 irfanjs           | Irfan Sayed          | [email protected]                    | Irfan Sayed
 irfanjs           | Irfan Sayed          | [email protected]                                | Irfan Sayed
 king-julien       |                      | [email protected]                               | king-julien
 king-julien       |                      | [email protected]                | king-julien
 King-Julien       |                      | [email protected]                | king-julien
 rajeshdeshpande02 | Rajesh Deshpande     | [email protected] | Rajesh Deshpande
 rajeshdeshpande02 | Rajesh Deshpande     | [email protected]                      | Rajesh Deshpande
 rajeshdeshpande02 | Rajesh Deshpande     | [email protected]          | Rajesh Deshpande
 rajeshdeshpande02 | Rajesh Deshpande     | [email protected] | rajeshdeshpande02
 rajeshdeshpande02 | Rajesh Deshpande     | [email protected]                      | rajeshdeshpande02
 rajeshdeshpande02 | Rajesh Deshpande     | [email protected]          | rajeshdeshpande02
 irfanjs           | Irfan Sayed          | [email protected]                    | Irfan Sayed
 irfanjs           | Irfan Sayed          | [email protected]                                | Irfan Sayed
 Chids-gs          | Chidambaram Sundaram | [email protected]                             | Chidambaram Sundaram
 ramnar            |                      | [email protected]                                 | ramnar
 ramnar            |                      | [email protected]                          | ramnar
 ramnar            |                      | [email protected]                     | ramnar
 ljnaresh          |                      | [email protected]                   | ljnaresh
 ljnaresh          |                      | [email protected]                               | ljnaresh
(22 rows)

This is for all actors affiliated to Infosys - their details, emails and names. There can be more than 1 row for single actor - like multiple names, emails etc.

[lukaszgryglicki]

I'm closing this, please let me know if you need to reopen.