1496371 - Data for community research

Status: RESOLVED FIXED

(Webtools Graveyard :: Pontoon, enhancement, P2)

Description

[Rubén Martín [:Nukeador] ❌ [away till Aug 31st]]

Hello,

In order for vendor to start the research, they would need the following sets of data:

- Latest version of the Pontoon database as a .sql dump
- List with URLs to all the Mercurial repositories
- List of any official Mozilla communication we should be measuring on in the goal "Does official Mozilla communication play a role in when contributions are received? (Release dates, meetups dates)"

Thanks!

Comment 1

[Jeff Beatty [:gueroJeff]]

(In reply to Rubén Martín [:Nukeador] from comment #0)
> Hello,
> 
> In order for vendor to start the research, they would need the following
> sets of data:
> 
> - Latest version of the Pontoon database as a .sql dump
> - List with URLs to all the Mercurial repositories
Here you go: https://hg.mozilla.org/l10n-central/ 
> - List of any official Mozilla communication we should be measuring on in
> the goal "Does official Mozilla communication play a role in when
> contributions are received? (Release dates, meetups dates)"
Oooo, this will be harder to compile. How soon do you need these data points?
> 
> Thanks!

Also, it just dawned on me that if we're sharing a .sql dump, I'm wondering if there's a reasonable expectation of privacy with that data that obligates us to make this bug confidential. Thoughts?

Comment 2

[Matjaz Horvat [:mathjazz]]

:Nukeador, I'll share the link to the anonymized DB dump privately.

I'll also include the repository URLs.

Comment 3

[Rubén Martín [:Nukeador] ❌ [away till Aug 31st]]

For the analysis I suspect we should not anonymize it, they have signed a privacy agreement to handle this kind of data.

https://biztera.com/projects/12353

Comment 4

[Matjaz Horvat [:mathjazz]]

(In reply to Rubén Martín [:Nukeador] from comment #0)
> - Latest version of the Pontoon database as a .sql dump

I shared today's Pontoon DB dump privately with :Nukeador.

> - List with URLs to all the Mercurial repositories

Mercurial repositories are used by the following projects in Pontoon:
https://pontoon.mozilla.org/projects/firefox/
https://pontoon.mozilla.org/projects/firefox-for-android/
https://pontoon.mozilla.org/projects/thunderbird/
https://pontoon.mozilla.org/projects/lightning/
https://pontoon.mozilla.org/projects/seamonkey/

The source strings (en-US) for all these projects are stored in the following repository:
https://hg.mozilla.org/l10n/gecko-strings/

Translations are stored in per-locale repositories listed here:
https://hg.mozilla.org/l10n-central/

For example, the link to the German (de) repository is this:
https://hg.mozilla.org/l10n-central/de/

--

This is it as far as Pontoon/VCS data is concerned, so I'm marking the bug as fixed. Should you or the vendor have more questions, please let us know.