Diff for "Translations/Specs/ReportingAPI"

Not logged in - Log In / Register

Differences between revisions 5 and 23 (spanning 18 versions)
Revision 5 as of 2010-02-22 16:30:12
Size: 7199
Editor: dpm
Comment:
Revision 23 as of 2011-02-22 15:34:23
Size: 8727
Editor: dpm
Comment:
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
= Launchpad Translations API = = Launchpad Translations Reporting API =
Line 5: Line 5:
This Launchpad enhancement proposal discusses extending the functionality of Launchpad Translations by developing an API which will expose the necessary interfaces to allow read and write access to translations-related data from Launchpad through launchpadlib. This Launchpad enhancement proposal discusses extending the functionality of Launchpad Translations by developing an API which will expose the necessary interfaces to allow read access to translations-related data from Launchpad through [[https://help.launchpad.net/API/launchpadlib|launchpadlib]] for reporting purposes. API access will be provided for both translatable distributions and projects in Launchpad.
Line 7: Line 7:
'''On Launchpad:''' https://blueprints.launchpad.net/rosetta/+spec/api '''On Launchpad:''' https://blueprints.launchpad.net/ubuntu/+spec/community-m-launchpad-translations-reporting-api
Line 9: Line 9:
'''As the ''' [[https://launchpad.net/~dpm|Ubuntu Translations Coordinator]]<<BR>>
'''I'd like to propose ''' the development of a Translations API<<BR>>
'''so that ''' the Ubuntu Translations community and other customers can benefit from accessing the Launchpad Translations data in alternative ways which will help them assessing the status of translations at the distro level, track progress and set translation goals which will improve the translation coverage of Ubuntu. In addition to that, other functionality provided by the API can assist the Ubuntu translations coordinators in managing the Ubuntu Translations import queue and automate the currently manual processes<<BR>>
== User stories ==

'''As an ''' Ubuntu Translations Coordinator<<BR>>
'''I want ''' to be able to report on the status of Ubuntu translations at the distro level (only default installation source packages)<<BR>>
'''so that ''' I can present the data to the community in a way they can see the real status of translation, track their work, set translation goals, and in short, improve the translation coverage in all languages<<BR>>

'''As an ''' OEM Engineer <<BR>>
'''I want ''' to be able to create an automated report on the translation coverage of a set of source packages in a given set of languages<<BR>>
'''so that ''' I can inform a customer and assess whether additional translation work is required before shipping

'''As an ''' Ubuntu translator<<BR>>
'''I want ''' to be able to obtain translations data in an automated way<<BR>>
'''so that ''' I can present and use the data in alternative ways that will help my team better organize translation work
Line 17: Line 27:
The main benefit accessing data through launchpadlib can provide to Ubuntu is on the statistics reporting side: currently the main access point to translating Ubuntu is at http://translations.launchpad.net/ubuntu. This view offers statistics to ''all'' translatable packages in the `main` and `restricted` repositories, regardless of distribution. While complete, it does not provide information on how well translated Ubuntu is as a distribution. This information can be very useful to Ubuntu translators in assessing what needs to be translated and on which packages they should concentrate their work. This can also be used to track progress, set up goals, and in short, as an aid to building community around translations. In the same way, this can be useful for commercial customers to assess translation coverage when evaluating to ship Ubuntu in a given language. The need of an API arises now from the necessity of [[https://blueprints.launchpad.net/ubuntu/+spec/community-lucid-improving-translation-status-reporting|better reporting the status of Ubuntu translations]]. The main benefit accessing data through launchpadlib can provide to Ubuntu is on the statistics reporting side: currently the main access point to translating Ubuntu is at http://translations.launchpad.net/ubuntu. This view offers statistics to ''all'' translatable packages in the `main` and `restricted` repositories, regardless of distribution. While complete, it does not provide information on how well translated Ubuntu is as a distribution. This information can be very useful to Ubuntu translators in assessing what needs to be translated and on which packages they should concentrate their work. This can also be used to track progress, set up goals, and in short, as an aid to building community around translations. In the same way, this can be useful for commercial customers to assess translation coverage when evaluating to ship Ubuntu in a given language.
Line 20: Line 30:

This is only one of the uses the API would enable (reporting), but there are other functionalities (import queue management, translation) which would not only greatly reducing the amount of work in managing Ubuntu translations, but also open up the Translations component to many interesting uses.
Line 26: Line 34:
 * Ubuntu Desktop Team: [[https://launchpad.net/~arnegoetje|Arne Goetje]]
Line 28: Line 35:

(David: as the drafter of this proposal, I'm regularly in touch with all of the stakeholders)
Line 31: Line 40:
The new behaviour must provide a way to access translations data from Launchpad, either in read (or depending on the value) or write mode through launchpadlib, without the need for an admin to query the database. The new behaviour must provide a way to access translations data from Launchpad, either in read (or depending on the value) or write mode through launchpadlib, without the need for an admin to query the database directly.
Line 33: Line 42:
It must not provide a way to circumvent any security privileges built in the layers above (e.g. Launchpad UI) It must not provide any additional functionality or a way to circumvent any security privileges built in the layers above (e.g. Launchpad UI)
Line 37: Line 46:
The API can be initially subdivided in several areas, which will be exposed separately below. This section will be used to list every separate aspect of reporting, with '''ATTRIBUTES''' lists as the proposals for the direct data to be exposed and '''METHODS''' as indirect data that can be obtained by calling a web app method or another referenced resource
Line 39: Line 48:
=== Reporting === === Language ===
Line 41: Line 50:
This part of the API focuses on exposing read-only data for the purpose of reporting on the status of translations. Each subsection treats a separate aspect of reporting, with '''DATA''' lists as the proposals for the data to be exposed. '''ATTRIBUTES:'''
 * [DONE] Language code
 * [DONE] Language name in English
 * [DONE] Language state (visible or not)
 * [DONE-FUZZY] Number of contributors
 * [DONE] ''Plural forms'' [optional, for checking language support]
 * [DONE] ''Text direction'' [optional]
 * ''The rest of the data at https://translations.launchpad.net/+languages/$LANG'' [optional]
Line 43: Line 59:
==== Languages ==== === Language Set ===
Line 45: Line 61:
Retrieving the list of all languages available in Launchpad. For each language the following data would be required: '''METHODS:'''
 * [DONE] Get all active languages in Launchpad
 * [DONE] Get all languages known in Launchpad
Line 47: Line 65:
'''DATA:''' === PO Template ===

For each template the following data would be required:

'''ATTRIBUTES''':
 * Template name in Launchpad
 * Priority
 * Length
 * Date last updated
 * Domain name
 * Iscurrent (active or not)
 * Source package associated
 * Source package component (option - to avoid a new query on source package)
 * Is it used in language packs
 * ''In which languages there is a translation available'' [optional]

'''METHODS''':
 * The list of POFiles associated with this POTemplate
 * Translation statistics per language for each POFile associated with this POTemplate

=== PO Files ===

'''ATTRIBUTES'''
Line 49: Line 89:
 * Language name in English
 * Language state (visible or not)
 * Plural forms [optional, for checking language support]
 * Text direction [optional]
 * The rest of the data at https://translations.launchpad.net/+languages/$LANG [optional]
 * Length
Line 55: Line 91:
It would be also desirable to have the ability of querying a single language as well. '''METHODS''':
 * A method to display translation statistics:
   * Number of translated messages
   * Number of unreviewed messages
   * Number of changed messages
   * When the translation was last updated
   * Who the last translator was
Line 57: Line 99:
==== PO Templates ==== === Source Package ===
Line 59: Line 101:
Retrieving the list of all templates available for a series in Launchpad. For each template the following data would be required: We already have a few exported attributes for source package, but to help in identifying translations moved to univers we also need to know the component for this sourcepackage (https://api.launchpad.net/+apidoc/devel.html#source_package)
Line 61: Line 103:
'''DATA''':
 * template name in Launchpad
 * priority
 * length
 * date last updated
 * domain name
 * iscurrent (active or not)
 * source package
 * is in lang pack
 * the list of POFiles associated with this POTemplate
 * in which languages there is a translation available [optional]
'''ATTRIBUTES:'''
 * [DONE] Component name as latest_published_component_name (ie: main or universe)
Line 73: Line 106:
It would also be required to be able to query a '''METHODS:'''
 * List of all associated PO Templates
 * Translation statistics for each language - per template and aggregated for all templates
Line 75: Line 110:
It would also be nice to be able to query a template from a series, based on the Launchpad template name. === Series (distribution and product) ===
Line 77: Line 112:
==== PO Files ====

Retrieve the list of all PO files for a template in a series.

The list should contain:
 * language code
 * when the translation was last updated
 * number of translated messages
 * number of unreviewed messages
 * number of changed messages
 * who was the last translator


=== Import queue ===

=== Translation ===
'''METHODS:'''
 * List of all associated PO Templates
 * Translation statistics for each language - per template and aggregated for all templates
Line 96: Line 118:
 * [[../ApiDevelopment|Previous discussion on the API development]]
 * Danilo's thoughts on structuring the work:
''
First, I'd do API for single PO file statistics: you'd have to worry about exporting a shared interface IRosettaStats through API, so all the other objects which are based on it will get the same API as well.
 * [[../../ApiDevelopment|Previous discussion on the API development]]
 * [[https://bugs.launchpad.net/rosetta/+bug/525371/comments/1|Danilo's thoughts on structuring the work]] for the reporting part:
  1. '''Exposing API for single ''PO file'' statistics''' - a shared interface IRosettaStats will need to be exported through API, so all the other objects which are based on it will get the same API as well.
  1. '''Devising a good API for a single ''PO template'' '''
   * Other than the simple properties, the most interesting bit here is how to get statistics for a bunch PO files attached to a template. If you don't do anything but just export a single method to list out all the PO files, you'll be doing one API call for each of the languages for a PO template and that's going to be very slow. Eg. to get full status export for Ubuntu out of LP you'd need to do some ~400k API calls.
   * A much better solution to that is to provide a method which gives you all related PO file statistics: e.g. `getPOFilesWithStatistics()` which returns tuples of form (`POFile`, `translated_count`, `changed_count`, `unreviewed_count`, `untranslated_count`) directly. FWIW, I'd keep this a separate step as well.
  1. '''IPOTemplateS(ubs)et API''' - as the final step, I'd do an export of `IPOTemplateS(ubs)et` APIs for all the different objects that have them. As another part of this step, you'd probably want to do the similar to above and provide a getPOFilesWithStatistics(language) method on them.
Line 101: Line 126:
Next step would be to figure out a good API for a single potemplate and work on that. Other than the simple properties, the most interesting bit here is how do you get statistics for a bunch of attached PO files. If you don't do anything but just export a single method to list out all the PO files, you'll be doing one API call for each of the languages for a PO template and that's going to be very slow. Eg. to get full status export for Ubuntu out of LP you'd need to do some ~400k API calls.

So, a much better solution to that is to provide a method which gives you all related PO file statistics: "getPOFilesWithStatistics()" which returns tuples of form (POFile, translated_count, changed_count, unreviewed_count, untranslated_count) directly. FWIW, I'd keep this a separate step as well, so this would be bug/branch 3 already :)

And only then, as the final step, I'd do an export of IPOTemplateS(ubs)et APIs for all the different objects that have them. As another part of this step, you'd probably want to do the similar to above and provide a getPOFilesWithStatistics(language) method on them.

If you don't divide the work in this manner, you are going to end up with a gigantic branch that'll be hard to get right and get landed, and everybody will easily get lost about what exactly should be the next step.
''
The idea behind this workflow is simply to use a gradual approach, which will be easier to get right and get landed, without ending up with a too large a branch to review or follow.
Line 112: Line 130:
''How will we know when we are done?'' Although the intention is to propose a full API, the two main success criteria are the implementation of API functions for reporting and the imports queue, so we will know that we are done when we can report on the status of Ubuntu translations at a distro level (i.e. on a given set of packages, for all Launchpad languages) by having sourced the data trough launchpadlib.
Line 114: Line 132:
''How will we measure how well we have done?'' The success can be measured in how seamlessly this data can be obtained and in whether all requirements in terms of exposed data have been implemented.

Launchpad Translations Reporting API

This Launchpad enhancement proposal discusses extending the functionality of Launchpad Translations by developing an API which will expose the necessary interfaces to allow read access to translations-related data from Launchpad through launchpadlib for reporting purposes. API access will be provided for both translatable distributions and projects in Launchpad.

On Launchpad: https://blueprints.launchpad.net/ubuntu/+spec/community-m-launchpad-translations-reporting-api

User stories

As an Ubuntu Translations Coordinator
I want to be able to report on the status of Ubuntu translations at the distro level (only default installation source packages)
so that I can present the data to the community in a way they can see the real status of translation, track their work, set translation goals, and in short, improve the translation coverage in all languages

As an OEM Engineer
I want to be able to create an automated report on the translation coverage of a set of source packages in a given set of languages
so that I can inform a customer and assess whether additional translation work is required before shipping

As an Ubuntu translator
I want to be able to obtain translations data in an automated way
so that I can present and use the data in alternative ways that will help my team better organize translation work

Rationale

Due to other higher priority development work, the Translations component has been lacking a full API for quite some time now.

The need of an API arises now from the necessity of better reporting the status of Ubuntu translations. The main benefit accessing data through launchpadlib can provide to Ubuntu is on the statistics reporting side: currently the main access point to translating Ubuntu is at http://translations.launchpad.net/ubuntu. This view offers statistics to all translatable packages in the main and restricted repositories, regardless of distribution. While complete, it does not provide information on how well translated Ubuntu is as a distribution. This information can be very useful to Ubuntu translators in assessing what needs to be translated and on which packages they should concentrate their work. This can also be used to track progress, set up goals, and in short, as an aid to building community around translations. In the same way, this can be useful for commercial customers to assess translation coverage when evaluating to ship Ubuntu in a given language.

As the current focus of Launchpad development is on upstream integration, and as there is no planned UI work in that area, an API appears to be the most adequate way to allow accessing the Launchpad Translations data and present it in alternative ways to suit the stakeholders' needs.

Stakeholders

(David: as the drafter of this proposal, I'm regularly in touch with all of the stakeholders)

Constraints

The new behaviour must provide a way to access translations data from Launchpad, either in read (or depending on the value) or write mode through launchpadlib, without the need for an admin to query the database directly.

It must not provide any additional functionality or a way to circumvent any security privileges built in the layers above (e.g. Launchpad UI)

Subfeatures

This section will be used to list every separate aspect of reporting, with ATTRIBUTES lists as the proposals for the direct data to be exposed and METHODS as indirect data that can be obtained by calling a web app method or another referenced resource

Language

ATTRIBUTES:

  • [DONE] Language code
  • [DONE] Language name in English
  • [DONE] Language state (visible or not)
  • [DONE-FUZZY] Number of contributors
  • [DONE] Plural forms [optional, for checking language support]

  • [DONE] Text direction [optional]

  • The rest of the data at https://translations.launchpad.net/+languages/$LANG [optional]

Language Set

METHODS:

  • [DONE] Get all active languages in Launchpad
  • [DONE] Get all languages known in Launchpad

PO Template

For each template the following data would be required:

ATTRIBUTES:

  • Template name in Launchpad
  • Priority
  • Length
  • Date last updated
  • Domain name
  • Iscurrent (active or not)
  • Source package associated
  • Source package component (option - to avoid a new query on source package)
  • Is it used in language packs
  • In which languages there is a translation available [optional]

METHODS:

  • The list of POFiles associated with this POTemplate
  • Translation statistics per language for each POFile associated with this POTemplate

PO Files

ATTRIBUTES

  • Language code
  • Length

METHODS:

  • A method to display translation statistics:
    • Number of translated messages
    • Number of unreviewed messages
    • Number of changed messages
    • When the translation was last updated
    • Who the last translator was

Source Package

We already have a few exported attributes for source package, but to help in identifying translations moved to univers we also need to know the component for this sourcepackage (https://api.launchpad.net/+apidoc/devel.html#source_package)

ATTRIBUTES:

  • [DONE] Component name as latest_published_component_name (ie: main or universe)

METHODS:

  • List of all associated PO Templates
  • Translation statistics for each language - per template and aggregated for all templates

Series (distribution and product)

METHODS:

  • List of all associated PO Templates
  • Translation statistics for each language - per template and aggregated for all templates

Workflows

  • Previous discussion on the API development

  • Danilo's thoughts on structuring the work for the reporting part:

    1. Exposing API for single PO file statistics - a shared interface IRosettaStats will need to be exported through API, so all the other objects which are based on it will get the same API as well.

    2. Devising a good API for a single PO template

      • Other than the simple properties, the most interesting bit here is how to get statistics for a bunch PO files attached to a template. If you don't do anything but just export a single method to list out all the PO files, you'll be doing one API call for each of the languages for a PO template and that's going to be very slow. Eg. to get full status export for Ubuntu out of LP you'd need to do some ~400k API calls.
      • A much better solution to that is to provide a method which gives you all related PO file statistics: e.g. getPOFilesWithStatistics() which returns tuples of form (POFile, translated_count, changed_count, unreviewed_count, untranslated_count) directly. FWIW, I'd keep this a separate step as well.

    3. IPOTemplateS(ubs)et API - as the final step, I'd do an export of IPOTemplateS(ubs)et APIs for all the different objects that have them. As another part of this step, you'd probably want to do the similar to above and provide a getPOFilesWithStatistics(language) method on them.

The idea behind this workflow is simply to use a gradual approach, which will be easier to get right and get landed, without ending up with a too large a branch to review or follow.

Success

Although the intention is to propose a full API, the two main success criteria are the implementation of API functions for reporting and the imports queue, so we will know that we are done when we can report on the status of Ubuntu translations at a distro level (i.e. on a given set of packages, for all Launchpad languages) by having sourced the data trough launchpadlib.

The success can be measured in how seamlessly this data can be obtained and in whether all requirements in terms of exposed data have been implemented.

Thoughts?

Translations/Specs/ReportingAPI (last edited 2011-02-22 15:34:23 by dpm)