# \#python **URL:** https://forum.innovativeusers.org/tag/python/97.md [Latest](https://forum.innovativeusers.org/latest.md) · [Categories](https://forum.innovativeusers.org/categories.md) · [Tags](https://forum.innovativeusers.org/tags.md) --- ## [Sample Python Code for Automating Web Interfaces, from OH-IUG 2026](https://forum.innovativeusers.org/t/sample-python-code-for-automating-web-interfaces-from-oh-iug-2026/3066)
**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\ **Replies:** 1\ **Last updated:** [October 11, 2026, 4:26pm UTC](https://forum.innovativeusers.org/t/sample-python-code-for-automating-web-interfaces-from-oh-iug-2026/3066 "2026-10-11T16:26:05Z")
This post contains the code discussed in this IUG Forum Topic. At OH-IUG 2026, Wes Osborn @wesochuck and I presented alternative approaches to automating the navigation of and data entry in web interfaces, my approach b… --- ## [Automating web-based Innovative products/utilities with Selenium and Python/Java/C++](https://forum.innovativeusers.org/t/automating-web-based-innovative-products-utilities-with-selenium-and-python-java-c/2949)
**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\ **Replies:** 12\ **Last updated:** [June 22, 2026, 5:01pm UTC](https://forum.innovativeusers.org/t/automating-web-based-innovative-products-utilities-with-selenium-and-python-java-c/2949 "2026-06-22T17:01:21Z")
Hello! I’d like to know if anyone has attempted to automate or script-drive Sierra’s web-based admin app using any method, and if so, what your experience has been. Use Case: I find myself in the position of needing… --- ## [A Companion Utility for Maintaining Locations Served Groups ...and a Useful Python Module](https://forum.innovativeusers.org/t/a-companion-utility-for-maintaining-locations-served-groups-and-a-useful-python-module/2927)
**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\ **Replies:** 0\ **Last updated:** [May 4, 2026, 1:47pm UTC](https://forum.innovativeusers.org/t/a-companion-utility-for-maintaining-locations-served-groups-and-a-useful-python-module/2927 "2026-05-04T13:47:43Z")
LocationsServedMaintenance.py (12.0 KB) The purpose of this utility is to output strings which mimic the keystrokes needed to delete and/or add location codes en masse when maintaining Locations Served groups in Admin C… --- ## [Minuteman Script Repository](https://forum.innovativeusers.org/t/minuteman-script-repository/2769)
**Author:** [@jmgold](https://forum.innovativeusers.org/u/jmgold)\ **Replies:** 0\ **Last updated:** [December 31, 2025, 7:43pm UTC](https://forum.innovativeusers.org/t/minuteman-script-repository/2769 "2025-12-31T19:43:33Z")
This is an ongoing project, but we are working to update (and properly comment) all of the various automated Python scripts Minuteman is currently using for various tasks, and to keep them current with Github. The repos… --- ## [ChiliCheck - a Python script that looks for missing cover images](https://forum.innovativeusers.org/t/chilicheck-a-python-script-that-looks-for-missing-cover-images/2539)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\ **Replies:** 4\ **Last updated:** [July 10, 2025, 4:09pm UTC](https://forum.innovativeusers.org/t/chilicheck-a-python-script-that-looks-for-missing-cover-images/2539 "2025-07-10T16:09:57Z")
Our PowerPACs use cover images provided by ChiliFresh, and they’re a fantastic cover image service. But I ran into a problem, how can I find those records in the PAC (and in Polaris Leap) that do not have a cover image a… --- ## [Convert IIS log to CSV - Python script](https://forum.innovativeusers.org/t/convert-iis-log-to-csv-python-script/2497)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\ **Replies:** 1\ **Last updated:** [May 30, 2025, 5:04pm UTC](https://forum.innovativeusers.org/t/convert-iis-log-to-csv-python-script/2497 "2025-05-30T17:04:40Z")
Hello. I suck at Python, but I’m trying to get better. Recently, I had the need to look through a massive IIS log because one of our catalogues was running bog-slow due to a Googlebot “incident.” Basically Googlebot was… --- ## [Dynamic T-SQL Script Parameterization Using Python](https://forum.innovativeusers.org/t/dynamic-t-sql-script-parameterization-using-python/2368)
**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\ **Replies:** 0\ **Last updated:** [March 24, 2025, 11:00am UTC](https://forum.innovativeusers.org/t/dynamic-t-sql-script-parameterization-using-python/2368 "2025-03-24T11:00:12Z")
One thing I never quite got around to in my Intermediate SQL session at IUG 2025 was to recommend the helpful resource SQL Server Central, not only for the Polaris attendees but for anyone writing SQL. This morning’s ar… --- ## [Unlocking Sierra's REST APIs: Practical Python Projects for Libraries](https://forum.innovativeusers.org/t/unlocking-sierras-rest-apis-practical-python-projects-for-libraries/2345)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 1\ **Last updated:** [March 20, 2025, 12:13pm UTC](https://forum.innovativeusers.org/t/unlocking-sierras-rest-apis-practical-python-projects-for-libraries/2345 "2025-03-20T12:13:11Z")
Program Title: Unlocking Sierra’s REST APIs: Practical Python Projects for Libraries ILS: Sierra Program Description: You know Sierra and have your API key: now what? Join Ray and Jeremy as they showcase real-world pro… --- ## [Example script for pasting fields from OCLC Connexion into Sierra](https://forum.innovativeusers.org/t/example-script-for-pasting-fields-from-oclc-connexion-into-sierra/2125)
**Author:** [@PatC](https://forum.innovativeusers.org/u/PatC)\ **Replies:** 2\ **Last updated:** [December 10, 2024, 3:19pm UTC](https://forum.innovativeusers.org/t/example-script-for-pasting-fields-from-oclc-connexion-into-sierra/2125 "2024-12-10T15:19:27Z")
I worked with AI to make a Python script to copy and paste fields straight from OCLC into a Sierra record. I can use this to quickly update old Sierra records (especially films with many 7xx fields) or vendor records. T… --- ## [Boilerplate Code to Run a SQL Query from a Python Script](https://forum.innovativeusers.org/t/boilerplate-code-to-run-a-sql-query-from-a-python-script/2003)
**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\ **Replies:** 0\ **Last updated:** [September 13, 2024, 2:37am UTC](https://forum.innovativeusers.org/t/boilerplate-code-to-run-a-sql-query-from-a-python-script/2003 "2024-09-13T02:37:34Z")
SamplePythonScript.py (1.6 KB) SierraDB.py (156 Bytes) SQL.py (230 Bytes) I am posting this code for a couple of folks on the Sierra listerv. The SierraDB.py file will have to be edited for your Sierra environment, b… --- ## [Semantic Search Swiftly: Thirty-Six minutes to Transform Sierra Data for Enhanced Data Discovery](https://forum.innovativeusers.org/t/semantic-search-swiftly-thirty-six-minutes-to-transform-sierra-data-for-enhanced-data-discovery/1807)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:57pm UTC](https://forum.innovativeusers.org/t/semantic-search-swiftly-thirty-six-minutes-to-transform-sierra-data-for-enhanced-data-discovery/1807 "2024-04-03T15:57:40Z")
Program Title: Semantic Search Swiftly: Thirty-Six minutes to Transform Sierra Data for Enhanced Data Discovery ILS: General Program Description: There’s no avoiding AI, so you may as well understand it a bit better! T…