CleanSlips 4.6
Update: A few bugs were found and Jeremy diligently tweaked and tested CleanSlips to create 4.6, which fixes the bugs, especially the ones effecting the sticker template. Please download 4.6 in the folder below. We have a new version of CleanSlips that has several requested enhancements. This new version has been added to the Alma Printing page along with updated book band and sticker templates. You can also access them below:
- Book Bands This link will take you to an external website in a new tab.
- Stickers This link will take you to an external website in a new tab.
The previous version is also included in those folders in case you need to return to an older version. The new version was programmed using Excel files generated from the new Alma UI. Jeremy has provided the following updates:
Call Number Sorting
Many people requested that the slips be pre-sorted by call number, to allow for easy searching in the stacks. This wasn't initially possible, because of the way Excel sorts LC call numbers. I fixed this by creating a normalization routine that transforms call numbers into a format Excel can understand and sort.
Cleaner Slips
I removed the "(1 copy, 1 available)" notes for a cleaner presentation and have broken out the location and call number fields into separate lines for better readability. In addition, I have removed the library name from the slips, since it was redundant.
Garbage handling
CleanSlips will now delete the source Excel spreadsheet upon completion, to keep people's Downloads folder nice and tidy and allow for easier finding of future spreadsheets.
Comments are OK
In previous versions, if a patron left a comment on the CSU+ request form, it would push all fields forward because of a quirk in how Alma exported its data to Excel. CleanSlips 4.5 accounts for this. Comments can now be turned back on without fear of printing mishaps.
Better Reliability
CleanSlips now creates a second copy of the spreadsheet to work on (and deletes it upon completion). This prevents the errors that occur when users keep their Alma spreadsheets open and try to run CleanSlips at the same time. Now, there are no more conflicts.
