search

TheRosettaFoundation / SOLAS-Match

Self-managed translation project interface
www.TheRosettaFoundation.org
GNU Lesser General Public License v3.0
12 stars 8 forks source link

NGO Report #1280

Closed alanbarrett closed 7 years ago

alanbarrett commented 7 years ago

Requested by @mari-na Raquel, Ambra

My colleague Raquel had made the following request. Would it be possible to prepare a report for this? Or are there any existing reports that we could use? (I'm copying Raquel on this in case you have any questions)

For each NGO: total wordcount requested in 2017 language pairs requested main contact point email website (if listed)

Alan.
alanbarrett commented 7 years ago

Commit abdda23e304591c0d9c906b374127e2bac3d300e implements this.

To use it go to... https://trommons.org/admin/ Click on "[Download NGO report]" to download a CSV spreadsheet

I have not done quite what I was asked so as to be compatible with the user reports. I was asked for requested words. Instead I counted words and language pairs completed (not requested).

I also do not include Archived (or deleted!) tasks (as they are stored separately). I believe we have stopped archiving completed tasks (which now can only be done by site admin). Not that we did this regularly before.

The spreadsheet contains the following columns... (Organisation/NGO) Name (Organisation/NGO) Email (Organisation/NGO) Website (Organisation/NGO) Admins (Organisation/NGO) Members (in so far they are not admins, don't seem to be many/any) 2017 Words Translated (2017) Words Proofread (2017) Language Pairs And the same for all years back in time in additional columns

I did a bit of a sanity check on a big NGO user "Foundation for Environmental Education (FEE)". They had 1,929,966 words translated or proofread over all years (and this seems to match the database properly). They seem to have requested 2,566,221 words. Maybe some of these might have been duplicated projects or maybe language pairs hard to source. I am not sure and someone like Paulina would probably be able to tell what happened.

Let me know if this is an issue or other problems.

I also am going to send this issue post around by email (for those not used to github). In the email I will attach the current output with the columns resized by hand and the totals added (also by hand) and saved in as a Excel document.

Alan.