Transfer glossary creation to Google Sheets

[LukasWallrich]

Currently, the glossaries get read from Google Docs (see content/glossary/_create_glossaries.py) … but this is very fiddly for everyone involved, as the Doc style needs to be precisely right, so that we will need to shift to an approach where the glossary translations live in a Google Sheet, before we can add the next batch of languages.

As a first step, we need to create the spreadsheets - probably best with this script that already turns the Docs into a more structured format. Firstly, that should be

• [ ] English master file with all the details from the English entries

and then translated files from the other languages

• [ ] German
• [ ] Arabic

and soon more, each with entry name, translated name, translated entry - and other fields that are not repeating the English.

Then we would need a script to generate the glossary entries from the spreadsheets (pulling all the meta-data from the English one, so that it only needs to be updated in one place - and only the translation and translator info from the respective language.

In this step, also a standard citation footer to each glossary entry (TASL format), with reference to original glossary article.

[da5nsy]

Just adding a little note here about the Carpentries and Glosario. I just found out about Glosario and I'm curious what we could learn from them/ share with them. This is just a stub for now to remind me look into this more. Also - they have an event tomorrow which I'll try to go to.

https://hachyderm.io/@thecarpentries/114459354773259110

[github-actions[bot]]

This issue has been inactive for more than 90 days. If there is no further activity, it will be automatically closed in seven days time. You can reopen the issue if it is still relevant.

[LukasWallrich]

Keep open

Lukas Wallrich 1001 Valegro House // London SE10 9LJ @.*** // +44 7591 975294 // +49 163 4704135 https://lukaswallrich.coffee

On Sun, 6 Jul 2025, 04:39 github-actions[bot], @.***> wrote:

github-actions[bot] left a comment (forrtproject/forrtproject.github.io#321) https://github.com/forrtproject/forrtproject.github.io/issues/321#issuecomment-3040599042

This issue has been inactive for more than 90 days. If there is no further activity, it will be automatically closed in seven days time. You can reopen the issue if it is still relevant.

— Reply to this email directly, view it on GitHub https://github.com/forrtproject/forrtproject.github.io/issues/321#issuecomment-3040599042, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOK6NGPRX3ZXRSMAA4FDRR33HCD65AVCNFSM6AAAAAB26UZ2VWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTANBQGU4TSMBUGI . You are receiving this because you authored the thread.Message ID: @.***>

[github-actions[bot]]

This issue has been inactive for more than 90 days. If there is no further activity, it will be automatically closed in seven days time. You can reopen the issue if it is still relevant.

[flavioazevedo]

Keep open!

[LukasWallrich]

@richarddushime this is the spreadsheet where the glossary entries live - https://docs.google.com/spreadsheets/d/1IelzKlB7_UmnwbqgpEZnkFubB0ks-qFaIxhqEJGBH2g/edit

To embed in code, this is the csv link https://docs.google.com/spreadsheets/d/e/2PACX-1vRKXOzAaBg19k2mjs6EIwY3la7DjX1XXDB2Wzkos4y3r7MS0f1g8bGskSEoQWkaAv4unczvpeGAQFwv/pub?gid=955789150&single=true&output=csv

[LukasWallrich]

Then review English Literature review contains the whole reference list for part 1

[LukasWallrich]

Enhancement would be to also make the references in glossary entries clickable - but first need to make reference section useful

[LukasWallrich]

Here two reference issues that were kindly flagged to us - they will help us to check whether the new approach improves things:

• In the glossary's "Red Team" entrance [https://forrt.org/glossary/english/red_teams/] there is a reference "Coles et al. (2020)" that does not appear in the references page [https://forrt.org/glossary/references/]; there is only one reference with an author called "Coles" [Obels, P., Lakens, D., Coles, N. A., Gottfried, J., & Green, S. A. (2020). Analysis of Open Data and Computational Reproducibility in Registered Reports in Psychology. Advances in Methods and Practices in Psychological Science, 3(2), 229–237. https://doi.org/10.1177/2515245920918872] and it is not the first author but the year is the same. So, or A)the citation is wrong and should be "Obels et al., 2020", or B)there is a reference missing.

• Also, less important, on the same page, for the "Lakens (2020)" reference, there are 2 "Lakens, 2020" refernces, so it would be nice to put either "a" or "b" on the glossary's reference citation.