Thanks to everyone who attended! Please add your thoughts in the comments!
Notes from the discussion and chat
-
Permissions management:
- Always use permission groups (never assign permissions outside of a group - even if you have to create groups of 1)
- When staff members encounter permission errors, ask them for a screen shot so get the exact wording and know which permission they are lacking
- To clean up individually assigned permissions, use the “remove all permissions” button. Any permissions assigned from a group will remain.
- Once permission groups and staff roles are set up, copy permissions from existing users to create new ones. It is quicker and better for accuracy and standardization (though it can also reproduce mistakes).
- Here is an earlier forum post related to permissions
- New permissions to consider after (or before) an upgrade:
- Polaris documentation includes a permissions document for each version
- Permissions related to each new feature are also included in the What’s New.
-
Things to do on a monthly/annual basis:
- We didn’t get this in the discussion, but here is a related forum post
At my consortium, we have a bunch a regular (scheduled) reports that run monthly and annually. We have a end-of-year and new year tasks that we do (prep for fiscal rollover, update Dates Closed, annual record clean-ups, etc.)
- We didn’t get this in the discussion, but here is a related forum post
-
Resources for SQL
- Polaris SQL training (looks like Intro to Polaris SQL will be held in April)
- IUG forum clearinghouse
- Use Google for specific questions about queries you are working on (use “T-SQL” in your search)
- Daniel’s git repository
- Polaris “CHM” file outlining the database schema is very helpful for figuring out how to join tables (requires Supportal login)
- There are a lot of free online resources. Googling for “beginner t-sql class” or something similar will get plenty of results.
- Post questions to the Discord or the Forum! Include your query!
-
SQL querying versus using SimplyReports:
- If you can easily get the data you need from SR, go for it
- SR is limited in how it can pull together data from different tables (i.e. each search type has a set of tables and views it pulls from, so you can’t combine item data and patron data for example)
- SR has output limitations
- If you have complicated parameters for an SR report, save the report! It will save you from trying to reproduce it and wondering why you can’t get the same results.
- Generally speaking, SR is good for snapshot data, while SQL querying is better for historical or statistical data
- Capturing point-in-time data after the fact can be tricky if it includes things that may have been modified or deleted (e.g. item records). If this is very important for you to be able to capture, either run regular snapshot reports and retain them or create database tables to retain historical data.
-
Creating a new branch:
- Can be done manually or as a paid service by Support
- Always use a check-list!
- This Supportal article covers a lot of the process (requires Supportal login)
- Pain points/things to consider:
- Permissions (need to be added for all branch specific activities, like registering a patron, assigning items, etc.)
- All ‘codes’ need to be added (collections, patron codes, etc.)
- All the tables that govern circ rules are set to default values. Ask your site manager (or use SQL if you are comfortable) to update the values. Copy from an existing branch if possible.
- Think about what the branch will be used for and what settings will be needed and when (is it a real branch or a holds locker? Is it going to be fully open immediately or should holds and notices be turned off initially?)
- Once created, branches are kind of permanent
- They can be removed by Polaris support (paid service)
- It is usually better to close them and ignore them
- If you repurpose a branch, consider previous transactions associated with the orgID
- Article for temporary branch closures (requires Supportal login)
- Article for permanent branch closures (requires Supportal login)
-
Bulk waiving charges:
- Functionality to do this is coming in 7.6!
- In the meantime, you can pay to have charges waived
- If you are comfortable trying it yourself, there are Javascript/SQL options that some libraries have used. Ask in the Discord for more information.
- Always add a note with a date stamp
-
System upgrades:
- Frequency
- Depends on the library and the content of the new versions, but it is generally a good idea to do them about once a year. If too many versions accumulate, it is a lot of work to go through all the new features.
- Polaris 7.5
- Known Issues has been updated (requires Supportal login)
- All the really big features are manual/optional, so you can take the time to explore any that make sense for your library
- Check out Discord and the Forum for conversations about 7.5 features
- Use a checklist for upgrade tasks (pre, during, and post)
- Frequency
Other useful links
- Polaris documentation: Innovative Documentation Portal Polaris
- Polaris libguides: Polaris Home - Polaris Home - support.iii.com at Innovative Interfaces
- Previous IUG conference content: Previous IUG Conferences - Innovative Users Group
- Wes Osborn’s Acquisitions for Sys Admins presentation: Polaris Acquisitions for System Administrators - Google Slides
- Wes’s Things I WIsh I’d Known About Polaris:Things I wish I’d known About Polaris 8 years ago - Google Slides
- Jesse Jesen’s Fiscal Rollover presentation: Fiscal Year Rollover - Roll without worry: the basics of Fiscal Year Rollover
- Katie LeBlanc’s Beginner’s Guide to Sys Admin presentation: Beginner's Guide to System Administration for Polaris (Polaris)
- Idea Exchange: https://ideas.iii.com/