Report issues - data does not add up

[jerpelea]

I found 2 issues on the local generated reports:

people appear in the contributor ranking report but it are missing from the repository commits
EX:
cat OSCI_Contributors_ranking_YTD_2022-01-31.csv | grep enderborg
Sony,peter enderborg,xxxxxxxxxxxxx@xxxxxxxxxx,57

cat Company-contributors-repository-commits_YTD_2022-01-31.csv | grep enderborg
returns nothing

Do you have any idea why some persons are missing ?

In the same report my contributions are counted separate for the same email address
cat OSCI_Contributors_ranking_YTD_2022-01-31.csv | grep Alin
Sony,Alin Jerpelea,xxxxxxxxxxxxx@xxxxxxxxxx,90
Sony,Alin,xxxxxxxxxxxxx@xxxxxxxxxx,56
(the email address is the same)

Thanks

[jerpelea]

@vlad-isayko
can you please help

[jerpelea]

@vlad-isayko bump

[vlad-isayko]

@jerpelea Hello, sorry for the long reply. As for the different data in the reports, then the incorrect name Company-contributors-repository-commits_YTD_2022-01-31.csv has misled you. This report collects data for a specific day, not since the beginning of the year

OSCI/osci/transformers/company_contributors_repository_commits.py

Line 57 in 979b6cb

.filter(f.col(datetime_field).cast('date') == day) \

And in the case of duplicates, the problem is that in our business logic both the name and the e-mail are the aggregation keys. I think for a discussion on this topic, we'd better call @cm-howard

[jerpelea]

@vlad-isayko thanks for sharing the info

I would like to know more about the email bug