Page MenuHomePhabricator

Enable missing words collection for Wikimedia's Apertium server
Open, MediumPublic


Apertium identifies words that it cannot translate and has an ability to log it. We should consider collecting this information and sending it to Apertium developers.


  1. Package python-toro (See: T101947)
  2. Determine location for missingFreqs.db and access to it (It is sqlite DB).
  3. Puppet config.
  4. Deployment in Beta and Production.

From #apertium on IRC:
aharoni 2. How can Wikipedia help Apertium improve this? Can we report the most frequent missing words, for example?
TinoDidriksen Unhammer and jacobEo, the currently online maintainers of dan-nor; what say you?
aharoni I've been thinking how to report untranslated words from Wikipedia back to Apertium
TinoDidriksen Well, APY keeps a database of untranslated words, with frequency afaik.
aharoni Where is it collected?
TinoDidriksen Some SQLite db on the APY host.
aharoni [ hi kart_ ]
aharoni If we have our own package installed, do we already collect it?
aharoni kart_ handles all the packaging for us, I don't know the technical details.
TinoDidriksen Don't know what version you have packaged, or whether it has that part enabled.
aharoni kart_: do you know?
TinoDidriksen File is called missingFreqs.db in the APY folder.
aharoni OK, let's say that we do have it.
aharoni If we periodically send it to Apertium, will it be useful?
aharoni Will somebody bother to add the translations?
kart_ TinoDidriksen: you mean -apy?
kart_ TinoDidriksen: I think I need to update package then.
kart_ aharoni: ^^
kart_ aharoni: can I have task in Phab? :D
aharoni kart_: ack
aharoni TinoDidriksen: you know, you could just run Apertium over a dump of all Wikipedia articles and collect the most frequent untranslated words :)
kart_ aharoni: how to access is another subject, as we do run it on production service.
aharoni If you haven't already :)
aharoni kart_: How about just copying it once a month and emailing it to an Apertium contact :)
TinoDidriksen Whether anyone will care to look most missing words is a whole other story. I guess it's good incentive because there is a direct feedback loop.
aharoni It shouldn't be too big for email.
TinoDidriksen Ours is 130MB currently.
aharoni TinoDidriksen: If there is somebody who will care and add the translations, I'd gladly provide it.
TinoDidriksen Nobody is even looking at our own, currently...but it also hasn't been advertised to the mailing list. We should do that.
kart_ TinoDidriksen: Please do.
kart_ Even I came to know today, we should have send feedback earlier.
kart_ TinoDidriksen: can location of db configurable?
TinoDidriksen I don't maintain any of the Python code. Unhammer and sushain handle APY. But I can only assume the answer is yes, 'cause that sounds trivial.
TinoDidriksen Oh, it already is, with -f
TinoDidriksen There was also a cmdline flag to make it keep an in-memory buffer, so that it doesn't hog I/O with SQLite commits: -M1000
Unhammer hi
Unhammer yeah, probably good idea to use -M1000 (or some number like that)
Unhammer and yeah I'd like seeing the wp missingfreqs, it's probably more directly useful

Event Timeline

Amire80 created this task.Mar 4 2015, 10:15 AM
Amire80 raised the priority of this task from to Needs Triage.
Amire80 updated the task description. (Show Details)
Amire80 added subscribers: Amire80, KartikMistry.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 4 2015, 10:15 AM
Amire80 triaged this task as Medium priority.Mar 5 2015, 8:36 AM
Amire80 set Security to None.
KartikMistry renamed this task from enable missing words collection for Wikimedia's Apertium server to Enable missing words collection for Wikimedia's Apertium server.Apr 14 2015, 11:30 AM
KartikMistry updated the task description. (Show Details)
KartikMistry added a subscriber: santhosh.
Arrbee moved this task from Needs Triage to CX5 on the ContentTranslation board.Apr 20 2015, 6:09 AM
santhosh edited a custom field.Jun 10 2015, 6:27 AM
KartikMistry updated the task description. (Show Details)Jun 10 2015, 9:06 AM
KuboF added a subscriber: KuboF.Jun 12 2015, 2:15 PM
Restricted Application added a project: Notice. · View Herald TranscriptJun 25 2015, 4:06 PM
gpaumier moved this task from Backlog to Triaged on the Notice board.Jun 26 2015, 8:27 PM
Amire80 moved this task from CX5 to CX6 on the ContentTranslation board.Jul 2 2015, 4:32 PM
gpaumier edited a custom field.
gpaumier moved this task from Triaged to Archive on the Notice board.Jul 2 2015, 8:19 PM
Pginer-WMF moved this task from CX6 to CX7 on the ContentTranslation board.Jul 21 2015, 5:55 PM
KuboF removed a subscriber: KuboF.Feb 6 2016, 4:55 PM
Aklapper removed KartikMistry as the assignee of this task.Jun 19 2020, 4:25 PM

This task has been assigned to the same task owner for more than two years. Resetting task assignee due to inactivity, to decrease task cookie-licking and to get a slightly more realistic overview of plans. Please feel free to assign this task to yourself again if you still realistically work or plan to work on this task - it would be welcome!

For tips how to manage individual work in Phabricator (noisy notifications, lists of task, etc.), see for available options.
(For the records, two emails were sent to assignee addresses before resetting assignees. See T228575 for more info and for potential feedback. Thanks!)