Your message dated Wed, 1 Jul 2020 12:51:32 +0200 with message-id <[email protected]> and subject line [DONE] Re: [DDTP] Please provide pages to list descriptions that had been previously translated has caused the Debian Bug report #860386, regarding [DDTP] Please provide pages to list descriptions that had been previously translated to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 860386: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=860386 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---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";
--- End Message ---
--- Begin Message ---Thanks for implementing this feature! https://salsa.debian.org/l10n-team/ddtp/-/commit/ef31e1cb7154242d39de3d2b3d1ae827ea26c738
--- End Message ---
