Package: debian-i18n
Tags: l10n
Severity: wishlist
Hi,
please provide HTML pages (such as this [1] or this [2]) to list the package
descriptions that had been translated but aren't anymore because the
description has
been modified (e.g. a trivial typo fixed by maintainer causes the loss of the
whole
translation).
Unfortunately the translators have no possibility to fetch this type of
descriptions
and the number of losses is very large if compared with "real" translations;
this is
a very sad situation and a waste of lot of work :(
E.g. for "pt" language we have 2425 complete translations in DDTP and 1877
formerly
translated descriptions (>77% ...) [3]
An indicative patch is attached ("something" words are not so explanatory).
Note that the query is the same as that which gathers the counts displayed in
[3]
(numbers between round brackets).
Thanks a lot for your work in l10n projects and happy Easter :)
[1] http://ddtp2.debian.net/ddt.cgi?alluntranslatedpackages=it
[2] http://ddtp2.debian.net/ddt.cgi?allpackages=it
[3] http://ddtp2.debian.net/
--- ddt.cgi 2017-04-15 18:11:39.932861451 +0200
+++ ddt.cgi-new 2017-04-15 18:13:45.586184068 +0200
@@ -135,4 +135,5 @@
'alltranslatedpackages' => $LANGUAGE_NAME,
'alluntranslatedpackages' => $LANGUAGE_NAME,
+ 'something' => $LANGUAGE_NAME,
'package' => $PACKAGE_NAME,
'diff1' => qr/^\d+$/,
@@ -834,4 +835,30 @@
print "<br>\n";
print "</BODY>\n";
+} elsif (param('something')) {
+
+ my $language=param('something');
+
+ my $package;
+ my $description_id;
+
+ print "Content-type: text/html; charset=UTF-8\n";
+ print "\n";
+ print "<HTML>\n";
+ print "<HEAD>\n";
+ print "<meta http-equiv=\"content-type\" content=\"text/html;charset=UTF-8\">";
+ print "<TITLE>Debian Description Tracking -- something -- </TITLE>\n";
+ print "</HEAD>\n";
+ print "<BODY>\n";
+ print "<h3>Something</h3>\n";
+
+ my $sth = $dbh->prepare("SELECT description_id,package FROM description_tb WHERE description_id in (SELECT description_id FROM active_tb) and description_id not in (SELECT description_id FROM translation_tb WHERE description_id in (SELECT description_id FROM active_tb) and language=?) and package in (SELECT package FROM description_tb WHERE description_id in (SELECT description_id FROM translation_tb WHERE language=?) GROUP BY package) ORDER BY package");
+ $sth->execute($language,$language);
+
+ print "<pre>";
+ while(($description_id,$package) = $sth->fetchrow_array) {
+ print "<a href=\"ddt.cgi?desc_id=$description_id&getuntrans=$language\">$package</a>";
+ print "\n";
+ }
+ print "</pre>";
} else {
print "Content-type: text/html; charset=UTF-8\n";
