Nestled within the structure of the Polaris database there is an unassuming folder that may confound and confuse someone new to Polaris SQL. The Polaris views can be a strange place, with some oddities built right into the code. But this folder is of fantastic tools that can help make your life easier whenever you find yourself writing a query. We'll dive deep into these views and discover what they do, how they can help you, and how (and why) you can make your own.
This presentation is aimed at beginning and intermediate Polaris SQL users, but everyone is welcome!
Denver Public Library had been watching Leap functionality evolve from the sidelines for several years. In 2023, we decided the time was right to jump in and teach hundreds of front line staff at our 26 branch system to swim these new waters. Why not? We were only in the midst of a major reorg and several large-scale building renovations.
Come learn our approach to leveraging circumstances and timing to help Denver Public Library Leap forward.
Messy metadata. We've all got it. (In fact, if you don't, please come to this session and tell us how you reached that pinnacle of perfection!) In this panel, cataloging and metadata enthusiasts will discuss how we clean-up and maintain our Polaris database through monthly tasks, SQL searches, and even soliciting help outside of tech services. We'll discuss how to plan, prepare and tackle bigger projects like changing the classification of an entire collection or subject heading changes. And, of course, how to do it all while the librarians keep ordering and the materials keep arriving. Panelists will include members from hosted and unhosted sites, as well as consortia and stand-alone libraries.
This presentation aims to share training strategies to make SQL Searching in the Find Tool more accessible for more library staff. In-house training on this powerful Polaris tool can be engaging and helpful. However, several pitfalls often seem to plague 101 Trainings: not directed at front line staff, don't reduce the intimidation associated with 'coding,' or struggle to convey how it can be useful. Our library held a session on Find Tool SQL for our annual Staff Education Day, which is transitioning to regularly available training due to staff interest. These trainings, along with redesigning our circ training modules, have provided insight into more effectively introducing complex information to a wide staff audience.
Come join us as we discuss all things Polaris Consortia related! Let's discuss strategies on managing multiple libraries using Polaris, overcoming technical challenges, managing staff workflows/permissions, fostering collaboration among member institutions, governance; or whatever you want to bring up! The forum is focused specifically on Consortia using Polaris so discussion may veer into challenges unique to Polaris, but all are welcome!
Dive into SQL with Our Beginner’s Guide! Discover the essentials of SQL, explore the Polaris database structure, access key documentation, and learn a basic query.
Are you seeking answers? Looking for advice? Are you a new Polaris ILS administrator or someone who's seen Polaris SA so many times you no longer get lost flipping through menus? Either way, you're always welcome at the Polaris System Administration Forum! We'll dive into all the complexity and simplicity of managing, operating, and dealing with the Polaris system. From WebAdmin to SQL, we'll help you any way we can!
