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.
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.
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>
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