Bug 41319 - Link content of 'Contributing companies and institutions' to bug sponsors
Summary: Link content of 'Contributing companies and institutions' to bug sponsors
Status: Signed Off
Alias: None
Product: Koha
Classification: Unclassified
Component: About (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Martin Renvoize (ashimema)
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-11-26 17:56 UTC by Martin Renvoize (ashimema)
Modified: 2025-11-27 18:18 UTC (History)
5 users (show)

See Also:
GIT URL:
Initiative type: ---
Sponsorship status: ---
Comma delimited list of Sponsors:
Crowdfunding goal: 0
Patch complexity: Trivial patch
Documentation contact:
Documentation submission:
Text to go in the release notes:
This enhancement automates the generation of contributing companies and institutions on the about page (About Koha > Koha team), and (where known): - Links to their website - Includes the country
Version(s) released in:
Circulation function:


Attachments
Bug 41319: Automate sponsor tracking from git trailers (31.58 KB, patch)
2025-11-27 15:53 UTC, Martin Renvoize (ashimema)
Details | Diff | Splinter Review
Bug 41319: Automate sponsor tracking from git trailers (31.62 KB, patch)
2025-11-27 18:15 UTC, David Nind
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Martin Renvoize (ashimema) 2025-11-26 17:56:28 UTC
Right now the 'Contributing companies and institutions' list on the about page is a simple hard-coded list in the template.

We should maintain this in a similar way to the rest of the team detail in a yaml file of contributors and have a script to pull these out of the 'Sponsored-by' trailers in git which are much better maintained now and even give a clear link back to what the sponsoring organisation contributed.
Comment 1 Martin Renvoize (ashimema) 2025-11-27 15:53:16 UTC
Created attachment 189998 [details] [review]
Bug 41319: Automate sponsor tracking from git trailers

This patch replaces the hardcoded "Contributing companies and
institutions" list on the about page with an automated system that
extracts sponsor information from git commit trailers.

Changes:

1. about.pl: Load sponsor data from docs/sponsors.yaml using YAML::XS
2. about.tt: Replace hardcoded list with dynamic rendering from
   sponsors.yaml, displaying sponsors with their locations
3. docs/sponsors.yaml: Generated sponsor data file containing 212
   unique sponsors with contribution counts, locations, and URLs

The sponsor data is generated at release time using the
koha-update-sponsors script from release-tools (see release-tools
commit a30b8a3). The script:

- Extracts Sponsored-by: trailers from git history
- Applies alias resolution to consolidate duplicate names
- Preserves historical sponsors without git trailers
- Merges location and URL data from sponsor_map.yaml

This replaces the manual process of updating the sponsor list with
a maintainable approach that automatically captures all Sponsored-by:
entries from the git history while preventing duplicate entries through
alias resolution.

The about page now displays sponsors in the format:
"Organization Name, Country" instead of showing contribution counts.

To update the sponsor list at release time:
1. Run koha-update-sponsors from the Koha source directory
2. Review and commit the updated docs/sponsors.yaml

See release-tools README.md for detailed documentation.
Comment 2 David Nind 2025-11-27 18:15:22 UTC
Created attachment 189999 [details] [review]
Bug 41319: Automate sponsor tracking from git trailers

This patch replaces the hardcoded "Contributing companies and
institutions" list on the about page with an automated system that
extracts sponsor information from git commit trailers.

Changes:

1. about.pl: Load sponsor data from docs/sponsors.yaml using YAML::XS
2. about.tt: Replace hardcoded list with dynamic rendering from
   sponsors.yaml, displaying sponsors with their locations
3. docs/sponsors.yaml: Generated sponsor data file containing 212
   unique sponsors with contribution counts, locations, and URLs

The sponsor data is generated at release time using the
koha-update-sponsors script from release-tools (see release-tools
commit a30b8a3). The script:

- Extracts Sponsored-by: trailers from git history
- Applies alias resolution to consolidate duplicate names
- Preserves historical sponsors without git trailers
- Merges location and URL data from sponsor_map.yaml

This replaces the manual process of updating the sponsor list with
a maintainable approach that automatically captures all Sponsored-by:
entries from the git history while preventing duplicate entries through
alias resolution.

The about page now displays sponsors in the format:
"Organization Name, Country" instead of showing contribution counts.

To update the sponsor list at release time:
1. Run koha-update-sponsors from the Koha source directory
2. Review and commit the updated docs/sponsors.yaml

See release-tools README.md for detailed documentation.

Signed-off-by: David Nind <david@davidnind.com>
Comment 3 David Nind 2025-11-27 18:18:59 UTC
Anything that automates this is a great idea!

I've signed off, although I did note these things that may require a follow-up to fix:

1. For all organisations with a country, there is a space between the organisation name and the comma, for example: Allen Ginsberg Library , USA

2. Duplicated country:
   . Horowhenua District Council, New Zealand , New Zealand

3. Possible duplicated entries:
   - Catalyst , New Zealand
   - Catalyst IT.
   - North Central Regional Library (NCRL) , USA
   - North Central Regional Library System
   - NEKLS
   - Northeast Kansas Library System , USA
   - Northeast Kansas Library System, NEKLS (http://nekls.org/)
   - Region Halland (not sure about this one and the next one)
   - Regionbibliotek Halland / County library of Halland
   - Ville de Victoriaville , Canada
   - Ville de Victoriaville, QC
   - Virginia Polytechnic Institute and State University
   - Virginia Tech , USA
   - Virginia Tech Libraries
   - Wiko
   - Wiko (https://www.wiko-berlin.de/)
   - Association KohaLa , France
   - KohaLa

4. Out of alphabetical order - might be tricky, is at the end of the list: Écoles nationales supérieure d'architecture (ENSA)

5. Weird ones 8-)
   . KillerRabbitAosA
   . Not wanting to read in my maths book
   . Sunday TV is boring
   . The Will to Procrastinate
   . Wanting the darn packages to build

Testing notes:
1. Go to More > About Koha > Koha team
2. Scroll down to the 'Contributing companies and institutions' section
3. Note that there is a relatively short list
4. Apply the patch
5. Refresh the page
6. Not that there is now:
   - A more comprehensive list
   - Some organisations are now linked to their website
   - It now includes the organisation's country