# IUG Conference 2024 **URL:** https://forum.innovativeusers.org/c/conferences-events/iug-2024/32.md [Latest](https://forum.innovativeusers.org/latest.md) · [Categories](https://forum.innovativeusers.org/categories.md) · [Tags](https://forum.innovativeusers.org/tags.md) --- ## [Preparing Data with Unixesque Commands Redux](https://forum.innovativeusers.org/t/preparing-data-with-unixesque-commands-redux/1885)
**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\ **Replies:** 2\ **Last updated:** [May 28, 2024, 2:14pm UTC](https://forum.innovativeusers.org/t/preparing-data-with-unixesque-commands-redux/1885 "2024-05-28T14:14:43Z")
I was scheduled to deliver this presentation on the final day of IUG 2024 but had to cancel due to illness. On Monday and Tuesday of this week, staff from The Metropolitan Museum of Art and Marmot Library joined me in t… --- ## [The Rules of SQL-sitions: Mastering Sierra SQL for acquisitions](https://forum.innovativeusers.org/t/the-rules-of-sql-sitions-mastering-sierra-sql-for-acquisitions/1810)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 3\ **Last updated:** [May 23, 2024, 12:12pm UTC](https://forum.innovativeusers.org/t/the-rules-of-sql-sitions-mastering-sierra-sql-for-acquisitions/1810 "2024-05-23T12:12:08Z")
Program Title: The Rules of SQL-sitions: Mastering Sierra SQL for acquisitions ILS: Sierra Program Description: The third rule of SQL-sitions is never spend more effort on a query than you have to. Sierra’s acquisitio… --- ## [Missing Presentations](https://forum.innovativeusers.org/t/missing-presentations/1851)
**Author:** [@kdenboon](https://forum.innovativeusers.org/u/kdenboon)\ **Replies:** 12\ **Last updated:** [May 13, 2024, 7:40pm UTC](https://forum.innovativeusers.org/t/missing-presentations/1851 "2024-05-13T19:40:28Z")
Hi! I was looking back at my notes from IUG, and have two presentations I was hoping to review. The first is “10 Leap Hacks \[Features\] to Make Your Staff More Efficient”. Samantha Quell presented it on March 26. The sec… --- ## [IUG 2024 Hackathon: Detect Changes to Sierra Code Tables](https://forum.innovativeusers.org/t/iug-2024-hackathon-detect-changes-to-sierra-code-tables/1848)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 1\ **Last updated:** [May 8, 2024, 3:32pm UTC](https://forum.innovativeusers.org/t/iug-2024-hackathon-detect-changes-to-sierra-code-tables/1848 "2024-05-08T15:32:23Z")
Program Title: Detect Changes to Sierra Code Tables ILS: Sierra Program Description: The Sierra Administrator adds, occasionally renames and on rare occasions, deletes fundamental system codes. Common examples include … --- ## [IUG 2024 Hackathon: Appless Checkouts (It's a big deal)](https://forum.innovativeusers.org/t/iug-2024-hackathon-appless-checkouts-its-a-big-deal/1847)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 17, 2024, 1:42pm UTC](https://forum.innovativeusers.org/t/iug-2024-hackathon-appless-checkouts-its-a-big-deal/1847 "2024-04-17T13:42:12Z")
Program Title: Appless Checkouts (It’s a big deal) ILS: General Program Description: Empower patrons to handle self-checkout using the browser on their mobile phone without the need to download any specific app. After … --- ## [IUG 2024 Hackathon: The IMDB LUNK](https://forum.innovativeusers.org/t/iug-2024-hackathon-the-imdb-lunk/1849)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 17, 2024, 1:52pm UTC](https://forum.innovativeusers.org/t/iug-2024-hackathon-the-imdb-lunk/1849 "2024-04-17T13:52:31Z")
Program Title: The IMDB LUNK ILS: Polaris Program Description: Adding IMDB links into a Polaris catalog through Polaris API and OMDB API. Speaker/ Information: Andrew McDonald - SILS Chase Pronger - RHPL Jason Bedsa… --- ## [IUG 2024 Hackathon: Spotify "Wrapped" but for your library use!](https://forum.innovativeusers.org/t/iug-2024-hackathon-spotify-wrapped-but-for-your-library-use/1846)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 17, 2024, 1:38pm UTC](https://forum.innovativeusers.org/t/iug-2024-hackathon-spotify-wrapped-but-for-your-library-use/1846 "2024-04-17T13:38:38Z")
Program Title: Spotify “Wrapped” but for your library use! ILS: General Program Description: Spotify Wrapped is a viral marketing campaign by Spotify. Released annually since 2016, every early December, the campaign al… --- ## [Borrowing Brilliance: Tech Tips Inspired by Other Sectors](https://forum.innovativeusers.org/t/borrowing-brilliance-tech-tips-inspired-by-other-sectors/1799)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:42pm UTC](https://forum.innovativeusers.org/t/borrowing-brilliance-tech-tips-inspired-by-other-sectors/1799 "2024-04-03T15:42:29Z")
Program Title: Borrowing Brilliance: Tech Tips Inspired by Other Sectors ILS: General Program Description: Pablo Picasso once reportedly said ‘good artists borrow, great artists steal.’ This session aims to inspire us … --- ## [In-House On-boarding of a New Library](https://forum.innovativeusers.org/t/in-house-on-boarding-of-a-new-library/1789)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:10pm UTC](https://forum.innovativeusers.org/t/in-house-on-boarding-of-a-new-library/1789 "2024-04-03T15:10:18Z")
Program Title: In-House On-boarding of a New Library ILS: Polaris Program Description: We would like to present our in-house method of on-boarding a library into our consortium. In the past, our consortium would usuall… --- ## [Panic! At The Library: Preparing Diverse Collections For A Building Renovation](https://forum.innovativeusers.org/t/panic-at-the-library-preparing-diverse-collections-for-a-building-renovation/1794)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:28pm UTC](https://forum.innovativeusers.org/t/panic-at-the-library-preparing-diverse-collections-for-a-building-renovation/1794 "2024-04-03T15:28:42Z")
Program Title: Panic! At The Library: Preparing Diverse Collections For A Building Renovation ILS: Sierra Program Description: The Huntington Library will be undergoing a major renovation to older sections of the build… --- ## [Leaping Forward with Technical Services](https://forum.innovativeusers.org/t/leaping-forward-with-technical-services/1793)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:27pm UTC](https://forum.innovativeusers.org/t/leaping-forward-with-technical-services/1793 "2024-04-03T15:27:02Z")
Program Title: Leaping Forward with Technical Services ILS: Polaris Program Description: CCS is a consortium of 31 public libraries serving over 2,000 staff across our members. While public services staff at our librar… --- ## [Polaris SQL for the Absolute Beginner](https://forum.innovativeusers.org/t/polaris-sql-for-the-absolute-beginner/1791)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 2\ **Last updated:** [April 10, 2024, 1:27pm UTC](https://forum.innovativeusers.org/t/polaris-sql-for-the-absolute-beginner/1791 "2024-04-10T13:27:08Z")
Program Title: Polaris SQL for the Absolute Beginner ILS: Polaris Program Description: CLC ILS System Administrator, Kalee Burkett, will share the experience of creating Polaris SQL scripts for the very first time. Thi… --- ## [Drawing Down the Data - An introduction to the PolarisTransactions database](https://forum.innovativeusers.org/t/drawing-down-the-data-an-introduction-to-the-polaristransactions-database/1787)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 1\ **Last updated:** [April 4, 2024, 7:57pm UTC](https://forum.innovativeusers.org/t/drawing-down-the-data-an-introduction-to-the-polaristransactions-database/1787 "2024-04-04T19:57:19Z")
Program Title: Drawing Down the Data - An introduction to the PolarisTransactions database ILS: Polaris Program Description: The PolarisTransactions database is a massive repository of information about almost everythi… --- ## [Tales from the Dark Side: What Our ILSes Can Learn from Shadow Libraries](https://forum.innovativeusers.org/t/tales-from-the-dark-side-what-our-ilses-can-learn-from-shadow-libraries/1808)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 1\ **Last updated:** [April 4, 2024, 7:56pm UTC](https://forum.innovativeusers.org/t/tales-from-the-dark-side-what-our-ilses-can-learn-from-shadow-libraries/1808 "2024-04-04T19:56:34Z")
Program Title: Tales from the Dark Side: What Our ILSes Can Learn from Shadow Libraries ILS: General Program Description: Circulation, acquisitions, online catalogues, patron management, statistics and analytics. Your … --- ## [Polaris Single Sign-on: Tips, tricks, pitfalls, and other things to avoid](https://forum.innovativeusers.org/t/polaris-single-sign-on-tips-tricks-pitfalls-and-other-things-to-avoid/1803)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 2\ **Last updated:** [April 4, 2024, 5:47pm UTC](https://forum.innovativeusers.org/t/polaris-single-sign-on-tips-tricks-pitfalls-and-other-things-to-avoid/1803 "2024-04-04T17:47:37Z")
Program Title: Polaris Single Sign-on: Tips, tricks, pitfalls, and other things to avoid ILS: Polaris Program Description: Chicago Public Library transitioned its 1000+ staff members to Active Directory single-sign-on … --- ## [Your Ideas: Innovative and IUG Enhancement Processes](https://forum.innovativeusers.org/t/your-ideas-innovative-and-iug-enhancement-processes/1815)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 4:18pm UTC](https://forum.innovativeusers.org/t/your-ideas-innovative-and-iug-enhancement-processes/1815 "2024-04-03T16:18:25Z")
Program Title: Your Ideas: Innovative and IUG Enhancement Processes ILS: General Program Description: At this joint Innovative/IUG presentation, the members of the Enhancement Leadership Team will give an overview of h… --- ## [Two More Weird Tricks From Marmot](https://forum.innovativeusers.org/t/two-more-weird-tricks-from-marmot/1814)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 4:14pm UTC](https://forum.innovativeusers.org/t/two-more-weird-tricks-from-marmot/1814 "2024-04-03T16:14:07Z")
Program Title: Two More Weird Tricks From Marmot ILS: Sierra Program Description: This presentation will explain procedures I have developed for dealing with two problems encountered on Sierra. First I will show how I … --- ## [Transitioning to the Google Cloud: A multi-phased journey to bid farewell to Windows](https://forum.innovativeusers.org/t/transitioning-to-the-google-cloud-a-multi-phased-journey-to-bid-farewell-to-windows/1813)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 4:12pm UTC](https://forum.innovativeusers.org/t/transitioning-to-the-google-cloud-a-multi-phased-journey-to-bid-farewell-to-windows/1813 "2024-04-03T16:12:08Z")
Program Title: Transitioning to the Google Cloud: A multi-phased journey to bid farewell to Windows ILS: General Program Description: Please join the Rochester Hills Public Library as we navigate a multi-phased transit… --- ## [Top Speed: From Zero to Polaris in Six Months](https://forum.innovativeusers.org/t/top-speed-from-zero-to-polaris-in-six-months/1812)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 4:09pm UTC](https://forum.innovativeusers.org/t/top-speed-from-zero-to-polaris-in-six-months/1812 "2024-04-03T16:09:38Z")
Program Title: Top Speed: From Zero to Polaris in Six Months ILS: Polaris Program Description: Where do you start when you need to migrate 1.8 million item records, 225 thousand patron records, and train 300 staff acro… --- ## [There is no such thing as a permanent URL. Ways to identify and repair broken links in your catalog](https://forum.innovativeusers.org/t/there-is-no-such-thing-as-a-permanent-url-ways-to-identify-and-repair-broken-links-in-your-catalog/1811)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 4:06pm UTC](https://forum.innovativeusers.org/t/there-is-no-such-thing-as-a-permanent-url-ways-to-identify-and-repair-broken-links-in-your-catalog/1811 "2024-04-03T16:06:05Z")
Program Title: There is no such thing as a permanent URL. Ways to identify and repair broken links in your catalog. ILS: Sierra Program Description: URLs, the unique identifiers that direct users to specific online res… --- ## [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… --- ## [Revolutionizing Patron Engagement: Exploring Vega Promote at the Rochester Hills Public Library](https://forum.innovativeusers.org/t/revolutionizing-patron-engagement-exploring-vega-promote-at-the-rochester-hills-public-library/1806)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:55pm UTC](https://forum.innovativeusers.org/t/revolutionizing-patron-engagement-exploring-vega-promote-at-the-rochester-hills-public-library/1806 "2024-04-03T15:55:49Z")
Program Title: Revolutionizing Patron Engagement: Exploring Vega Promote at the Rochester Hills Public Library ILS: General Program Description: Embark on a transformative communication journey at the Rochester Hills P… --- ## [Python Power-Up: Supercharging Sierra Integration with sierra-ils-utils](https://forum.innovativeusers.org/t/python-power-up-supercharging-sierra-integration-with-sierra-ils-utils/1805)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:53pm UTC](https://forum.innovativeusers.org/t/python-power-up-supercharging-sierra-integration-with-sierra-ils-utils/1805 "2024-04-03T15:53:46Z")
Program Title: Python Power-Up: Supercharging Sierra Integration with sierra-ils-utils ILS: Sierra Program Description: Integration of information systems, particularly the Sierra Integrated Library System (ILS), prese… --- ## [More Product AND More Process : Automating Archival Processing Workflows](https://forum.innovativeusers.org/t/more-product-and-more-process-automating-archival-processing-workflows/1801)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:48pm UTC](https://forum.innovativeusers.org/t/more-product-and-more-process-automating-archival-processing-workflows/1801 "2024-04-03T15:48:20Z")
Program Title: More Product AND More Process : Automating Archival Processing Workflows ILS: Sierra Program Description: In the Spring of 2023, the Systems and Cataloging Librarian and the Archival Processing Manager b… --- ## [Exploring Aspen Discovery](https://forum.innovativeusers.org/t/exploring-aspen-discovery/1800)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:45pm UTC](https://forum.innovativeusers.org/t/exploring-aspen-discovery/1800 "2024-04-03T15:45:03Z")
Program Title: Exploring Aspen Discovery ILS: General Program Description: Two public libraries discuss their experiences implementing hosted Aspen Discovery. We’ll start with the selection process, through the data lo… --- ## [Automating Patron Room Reservations with Localhop and OpenPath](https://forum.innovativeusers.org/t/automating-patron-room-reservations-with-localhop-and-openpath/1798)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:40pm UTC](https://forum.innovativeusers.org/t/automating-patron-room-reservations-with-localhop-and-openpath/1798 "2024-04-03T15:40:37Z")
Program Title: Automating Patron Room Reservations with Localhop and OpenPath ILS: General Program Description: Join Rochester Hills Public Library (RHPL) and LocalHop as they unveil their success in creating an innova… --- ## [Applied SQL: How One Library is Using Sierra Direct SQL Access to Troubleshoot Issues and Collect Statistics](https://forum.innovativeusers.org/t/applied-sql-how-one-library-is-using-sierra-direct-sql-access-to-troubleshoot-issues-and-collect-statistics/1797)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:37pm UTC](https://forum.innovativeusers.org/t/applied-sql-how-one-library-is-using-sierra-direct-sql-access-to-troubleshoot-issues-and-collect-statistics/1797 "2024-04-03T15:37:34Z")
Program Title: Applied SQL: How One Library is Using Sierra Direct SQL Access to Troubleshoot Issues and Collect Statistics ILS: Sierra Program Description: Do you find Create Lists too limiting for collecting statisti… --- ## [Reporting with a Twist](https://forum.innovativeusers.org/t/reporting-with-a-twist/1796)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:34pm UTC](https://forum.innovativeusers.org/t/reporting-with-a-twist/1796 "2024-04-03T15:34:44Z")
Program Title: Reporting with a Twist ILS: Polaris Program Description: Learn different libraries’ approaches to reporting that are outside of the box (eg: pulling together data from different sources or presenting fre… --- ## [A Reusable Pattern for Scheduled Python/SQL/API Jobs](https://forum.innovativeusers.org/t/a-reusable-pattern-for-scheduled-python-sql-api-jobs/1790)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 1\ **Last updated:** [April 3, 2024, 3:31pm UTC](https://forum.innovativeusers.org/t/a-reusable-pattern-for-scheduled-python-sql-api-jobs/1790 "2024-04-03T15:31:18Z")
Program Title: A Reusable Pattern for Scheduled Python/SQL/API Jobs ILS: Sierra Program Description: Goals of this presentation: To encourage those who have not begun to automate their SQL queries or leverage the RES… --- ## [Polaris SIP Logs: Monthly Self-Check Statistics Report](https://forum.innovativeusers.org/t/polaris-sip-logs-monthly-self-check-statistics-report/1795)
**Author:** [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)\ **Replies:** 0\ **Last updated:** [April 3, 2024, 3:30pm UTC](https://forum.innovativeusers.org/t/polaris-sip-logs-monthly-self-check-statistics-report/1795 "2024-04-03T15:30:41Z")
Program Title: Polaris SIP Logs: Monthly Self-Check Statistics Report ILS: Polaris Program Description: This presentation describes a custom PowerShell script to search our Polaris SIP logs to report the number of chec… [Next page](https://forum.innovativeusers.org/c/conferences-events/iug-2024/32.md?page=1)