September 27 2021
Patrons often ask Miss Honey where to find a specific poem or short story which isn't published as its own title. The patron would need to search a much broader topic first, and then think to search the index or the table of contents for the specific work they were looking for. We have an easier solution–adding Contents Notes!
Contents Notes allow you to add in additional information about a title's contents, which then simplifies the Smart Search process for your patrons. For example, Contents Notes for an anthology may list the works included within the anthology, so if they search for a specific part of the anthology, the title that contains it will come up in their search.
So how do you add Contents Notes?
Locate the Item record in Items Management using the Find command (< ctrl + f > on a PC or < cmd + f > on a Macintosh).
Unlock the record.
Click on the Notes tab, then click Add at the bottom right to select 505 - Formatted Contents Notes.
Enter the desired information.
Click OK at the bottom-right, then Save in the upper-right corner of the Items Management window.
If it is a list of songs on a CD or a list of the short stories in a book of short stories, just list the various titles or short stories in the Content Notes field with a <space> - - <space> between them and a period ( . ) at the end, and they will be searchable (see the screenshot for an example of what this looks like).
Take a look at the Notes tab of the Title Records page for more information.
September 20, 2021
Miss Honey is ordering books from a specific vendor. She knows the range of barcodes that is assigned for this particular vendor, but how can she tell which barcodes are already in use, and which are unused and available for new copies? Enter: the Unused Barcodes Report.
The Unused Barcodes Report allows you to generate a list of unused barcode ranges, or unused barcode labels. There are a few different settings that you can adjust within this report to make sure it is populating the information you need.
In the Miss Honey example above, she would run the report with the Range Information format, to get an available range to use for the vendor order. She could also run the report with the Barcode List format, which will give her a list of all the individual barcodes available within the range.
If Miss Honey received items that didn't have an import file (from Amazon, donations, etc), she could run this report with the Barcode Labels (3x10) format to generate and print some unused barcodes and simply scan the unused barcodes as new copy records.
- Go to Tools>Reports>Special>Unused Barcodes.
- Under the Options tab, specify if you are running the report with the Range Information, Barcode List, or Barcode Labels (3x10) format.
- For the Range Information or Barcode list:
- Item or Patron Barcode Range. Enter a start and end value to find all unused barcodes within the search parameters.
- Alphanumeric Barcode Leader. If the barcode range being searched has a leader, enter it here. For instance, if all the searchable barcodes begin with BI2C, and the numeric parameters to be searched include 5000 through 500000 then the range is actually BI2C5000 through BI2C500000. Only values which are between 5000 and 500000 but begin with BI2C (e.g. BI2C5000-BI2C500000) that are unused will be returned.
- Look for ranges of 'XXXX' or more unused barcodes. Specify how many barcodes are necessary to include on the list. Values can be between 1 and 100,000.
- For the Barcode Labels (3x10):
- Item or Patron Barcode Range. Searches either Items or Patrons for unused Barcodes within a range.
- Alphanumeric Barcode Leader. Allows the librarian to prepend all found barcodes with an alphanumeric character or characters.
- Labels to Skip. Skips a certain number of labels from the top before beginning printing. Useful if you're using a sheet of labels in which you've already begun printing. Applies to the first page only.
- Limit Report to. This limits the number of barcodes to be found. The maximum number of labels that can be found is 3,000.
- Label Copies. Allows you to make multiple copies of the same barcode.
Check out our Complete Reports List for more information on each of our reports.
September 7th, 2021
Disaster struck, and Miss Honey has found her library with no access to Alexandria. It may or may not have been because of some road construction cutting essential wiring... and this story may or may not sound familiar to you. Whether it's cables, hardware, or hurricanes, when the show must go on, Alexandria has Offline Mode.
How to use Offline Mode
As long as you have loaded Alexandria Librarian (or Textbook Tracker) in your browser since the last time your cache was cleared, Offline Mode will be available to use.
If your access was interrupted from Circulation, you'll get a notice that asks if you want to work offline. You can also go to yourlibrary.goalexandria.com/offline.
If your computers are down or you need to be mobile, you can use Offline Mode on your phone!
- Choose the mode to Check In, Check Out, or Inventory.
- Scan barcodes. Just like usual, you'll need a patron barcode to check items out, but not to check items in.
- Remove any mistaken transaction by clicking on it and pressing the .
- When connection is reestablished, you'll log in to the appropriate site, and upload your records.
- Check Operations Management to see when the upload is finished, and to download the summary file . Review the summary file for any exceptions.
This way, you can continue recording important transactions, and keep your library running.
What if Offline Mode isn't working, or you need to record other types of transactions? You can still get things done by using Transaction Scripts.
August 30th, 2021
Miss Honey has an initiative to increase reading and library interaction with each grade level, but especially the 4th-grade class. How can she measure this? With checkouts, Researcher usage, and the right reports!
Patron Monthly Checkouts
You can see some simple and helpful checkout numbers over time, by grade.
- Open Reports.
- Look in the Statistics / Usage category and click on the Patron Monthly Checkout Count report.
- Select by the grade or grade range you want to compare. Leave it blank to see all grades.
- Under the Options tab, sort by Grade.
- Optionally, fill in a date range to concentrate on a particular range of years.
- Run the report.
Miss Honey can compare the numbers month-by-month, over the years, and even with other grades to see how those 4th-graders are doing. Let's hope her efforts pay off with an upward trend!
Do you have a lot of ebooks? Ebook usage can be tracked when patrons click the access URL in Researcher. This is part of our Online Services Integration—call our Sales team at 1.800.347.6439 to learn more!
Miss Honey can also gauge patron involvement in the library by measuring their interactions with the different areas of Researcher.
- Open Reports.
- Look in the Statistics / Usage category and click on the Researcher Monthly Usage report.
- Select by a date range if you want to concentrate on a particular range of months. Since this is a new report, the data is limited to interactions after June 2021.
- Run the report.
Compare the usage over the months and, eventually, the years. If students don't know they can access their own account to renew items and suspend holds, you may hold particular lessons showing them how to use Status. After that, you would expect to see the access to Status go up in the next few months.
Remind yourself to review these statistics by scheduling the reports. Then you can aggregate the relevant data in a spreadsheet, and even make yourself some graphs!
There's a lot more you can do with your data...
August 9th, 2021
It's the beginning of the school year, meaning it's time for Miss Honey to take a look at her collection and decide what needs to be ordered, weeded, or enhanced. What percentage of her collection is ebooks? Which records are still using AACR2 rather than RDA? Are any books missing an Accelerated Reader level?
While this may sound like a daunting task, there are a couple services you could use to get a quick analysis!
Mitinet AnalyzeMARC and EnhanceMARC
We have recently partnered with Mitinet to bring you some awesome tools for improving your collection! Since these tools are integrated Alexandria utilities, Mitinet is the easiest way to analyze and enhance your catalog.
- AnalyzeMARC. Send your MARC data to Mitinet and receive a diagnostics report.
- EnhanceMARC. Choose how you would like to clean up and enhance your MARC records. Convert to RDA, add reading program information, update subjects, and more!
Not yet registered for our Mitinet services? Contact our Sales Team for more information!
If you usually use Titlewave to analyze your collection, you can export data from Alexandria to then import into Titlewave:
- Log into Alexandria Librarian and go to Tools > Export.
Select Export Items, Copy Based in the Items category.
Leave the defaults on the Selections tab.
Click the Options tab and set the following:
Sort by: Copy Call Number
Click the wrench iconat the top right-hand corner of the window to open Operations Management.
Once the export is complete, click the TXT iconto download the file. It will be called Export Items, Copy Based.txt.
- Import the file into Titlewave.
If Titlewave won't accept the export file, try changing the extension from .txt to .mrc.
July 12th, 2021
Hello there! We're popping in with a mid-summer announcement... the Support Center officially has a Frequently Asked Questions (FAQs) page!
Still working on inventory? Or are you getting ready to catalog? Take a look at the applicable sections on the new FAQs page.
The Trending FAQs section highlights the most common questions recently answered by Customer Support. We highly encourage you to check them out every now and then. Someone else may have had the same question you do!
And there you have it. We'll officially be back with more tips in August. In the meantime, we hope you enjoy the rest of your summer!
May 17th, 2021
Are you signed up for these email lists and groups? If not, consider doing so!
- Alexandria Makeover. It's coming soon! Sign up to receive special Makeover announcements, sneak peeks, and beta access.
- Newsletter. Subscribe to our monthly newsletter for seasonal posters, book reviews, activity ideas, and more.
- Releases. Sign up to receive information on new features and other updates.
- User Research Group. Apply to join a group of Alexandria users who give feedback on future features and projects.
- Alexandria Users Group. Join our Facebook group to discuss all things Alexandria with other librarians.
May 10th, 2021
Miss Honey needs to enter each student's charges and fines into her school's student information system (SIS). That sounds like... a lot of work. But luckily, there's no need to do it manually! She can export that information.
Exports come in handy when you need to transfer data from Alexandria to another program. And since they come in a text file, exports have an extra perk: unlike reports, you can edit the information! So if Miss Honey only needed lost charges, she could sort through the data and delete what she doesn't need. This can be done in the text file itself, but it's much easier in a spreadsheet.
Run an Export
- Go to Tools > Export.
- Choose the export you want. Usually patron or circulation exports are the most beneficial. Miss Honey would use Export Patrons Fines.
- On the Selections tab, choose the types of records you want included.
- On the Options tab, choose how you would like the export sorted, which fields to include, and the header type.
- Click Run.
- In Operations Management, download the text file.
Edit the Export's Data in a Spreadsheet
Each spreadsheet program is a little different, but there should be an option to import files. Once you've imported the Export's text file, you can edit or arrange things as needed before saving it.
May 3rd, 2021
A lot of students have recently told Miss Honey they've submitted a book review. Awesome! But where does she approve those reviews so they show up in Researcher? Enter... Reviews Management.
Reviews are a great way to engage patrons and get them excited about what's in your collection. But you may also need to make sure they are appropriate and protect student privacy. In Reviews Management, you can control what makes it to Researcher.
Here's everything you need to know about reviews in Alexandria!
You'll need to adjust some Security Preferences depending on how you want reviews to work in your library:
- Security > Tools > Reviews. Determine how individuals are allowed to interact with Reviews Management.
- We recommend Remove, which allows librarians full management of patron reviews.
- Security > Account > Reviews. Determine if newly submitted reviews require approval or are always automatically approved by default.
- We recommend Add - Requires Approval.
- Security > Account > Show Reviewer As. Determine whether reviews will post the patron's whole name, first name and last initial, initials only, or nothing at all.
- We recommend Full First Name and Last Name Initial. (e.g. Darla A.)
Submitting a review through Search or Explore is easy! Teach your patrons how to submit reviews by showing our patron-facing video on reviews. (We also have written instructions on how to submit a review if that works better for you.)
March 15th, 2021
The end of the school year is approaching, and Miss Honey is wondering what she should do about holds since none of them will be fulfilled over the summer. How can she remove holds so patrons don't get any notifications about them over break? Alexandria has a utility that makes this a breeze!
Did you know that we consolidated all of our holds utilities into one back in 20.3?
This makes it easier to do everything in one place.
Go to Tools > Utilities > Titles > General > Remove Holds.
- Use the Selections tab to specify which titles should be included.
- Choose which types of holds to remove under the Options tab. Unless you want to fill one last round of in-stock holds (in which case, use Remove queue holds only), you can probably just remove all holds.
Remove queue holds only. Removes all holds in the queue for selected titles and their copies, which includes suspended holds. View the holds queue for a specific title in its Copy List.
- Remove in-stock and on-shelf holds only. Removes all in-stock and on-shelf holds for selected titles and their copies, but does not remove queue holds.
- Remove all holds. Removes all holds for selected titles and their copies.
- Click Run.
And you're done!
Use the Clear Titles Holds and Clear Title Holds, In-Stock Holds, and In-Transit Holds utilities to remove holds.
Bookmark this tip so you remember to remove holds when school ends!
March 8th, 2021
Miss Honey's district is standardizing everyone's call numbers, which means all of her F prefixes need to be changed to FIC. Her first thought? This sounds like a lot of work. Luckily, Alexandria has a few utilities to make this easier.
First, it's important to understand thein Alexandria. Unless otherwise specified in individual copy records, all copies will inherit and change with the title's call number.
Continuing with Miss Honey's example, she would use the Change Title Call Number and Change Copy Call Number utilities to update everything to her district's new standards.
Go to Tools > Utilities > Titles > General >
- Use the Selections tab to specify the records you want to include. Miss Honey would enter F AAA - F ZZZ in the Titles in Call Number Range selection.
- Under the Options tab, choose how you want to modify the call numbers. Miss Honey would select Replace prefix and enter F in the Replace field. Then she would enter FIC in the with field.
- Choose whether or not you want to change the case or remove slashes under the Options tab.
- Run the utility.
- Repeat these steps for all call number ranges you need to change.
If you're changing a lot of title call number ranges and want the copies to all match, simply run thetab, select Match Copy to Title Call Number.
Using the same example, you'll need to run the utility twice: once to change the prefix and again to change the case. The nice thing here is that you can choose to modify both title and copy call numbers at the same time.
Go to Tools > Utilities > Titles > General >
- Choose Replace Prefix as the operation. Miss Honey would enter F in the Replace Prefix field and FIC in the With field.
- Use selections to specify a call number range. Miss Honey would select by Item Call Number and enter F AAA in the Starting With field and F ZZZ in the Ending With field.
- Run the utility.
- After you have modified all of the prefixes that need to be changed, run this utility again to change the case. Change the operation to Change Case and use the dropdown menu to select the case you want. Select by All Titles if you want to change the case for all of your call numbers.
And there you go! Your call numbers are updated in Alexandria.
March 1st, 2021
Historical fiction, coming-of-age, or supernatural... all of these genres fit The Book Thief. While you may have to choose just one for your physical library, you can add as many genres as you want to this book in your digital catalog. In fact, giving your books several genres can help make your catalog more searchable!
Alexandria has several tools to help you make sure your genres are ready to go!
Put genres in the right tag
Researcher uses the 655_a tag to display and search by genre, so it's important to have genres listed there. The 650_v tag is sometimes used for genre but is considered outdated. So if you have some MARC records with the 650_v tag, you'll want to use the
Add more genres
The first genre listed in the item record is the one that's visible in search results. However, you can still search or filter by any of an item's listed genres to find it.
Use the Selections tab to choose which titles will have the additional genre added to their MARC record. You could use selections like Titles in Call Number Range (e.g. all F, FIC, JF, etc. would be Fiction and all NF and 300-399 would be Nonfiction), Titles with a Policy of, Titles added, or others, depending on which would be the easiest way to group your books. Then, under the Options tab, type 655_a in the Add Tag_Subfield field. In the Value to Add field, type the genre.
You may need to run it several times to catch all of your books.
Alternatively, you can use the
You can edit or combine genre terms in
February 22nd, 2021
Miss Honey is about to remove a bunch of old titles from her catalog. But there's one thing she should do beforehand: run an archive.
An archive is a complete copy of your Alexandria database that can be used as a restore point in the event that your data is lost or damaged. It's a quick and automatic way of saving your database before making any large changes, such as performing an import, utility, update, or upgrading your machine.
Run an Archive
In v7, Alexandria no longer prompts you to run an archive before imports and utilities. Archives are a full copy of the entire database, so running too many can take up a lot of space on servers. Alexandria will only hold a certain number of archives before removing older ones.
An archive is automatically run every night during daily maintenance. If you are self-hosted, keep your server on at night for this reason.
There are two places you can manually run an archive if you need another:
/admin > Status >
Tools > Utilities > Database >
In v6, Alexandria will still prompt you to create an archive before imports and utilities. To manually run an archive, go to File > Archive Now.
Restore an Archive
Keep in mind that while you can restore your last archive, anything that happened after the last time it ran—checkouts, holds, etc—will be lost. You can restore archives from
February 16th, 2021
It's time to run another patron import. You have the import saved, which makes things easier... but what about the field mapping? Well, Alexandria saves that too!
It's true! When you create a saved import, your field mapping will also be saved. You'll just need to make sure the order of the fields in your file always remains the same.
Create a Saved Patron Import
- Go to Tools > Import and select the Patrons category.
- Click Create Saved Import. Enter a name for the import and click OK. (You can fill out the settings either before or after you save the import.)
- Fill out all the tabs:
- Overview. Edit the name, add notes, and decide whether you want to mark the import as a favorite and share it.
- Settings. If you didn't fill out the setting prior to saving the report, fill them out now. This lets you define defaults, updates, and how barcodes are handled.
- Schedule. Schedule the import to run automatically if you would like. Note that this is only available for FTP/FTPS imports.
- Notification. If you would like an email notification whenever the import runs, turn on Enable Email Notification and enter the appropriate email address(es).
- File Source. Choose where the import file is coming from (choose a file from your computer or use FTP/FTPS). This is also where you'll do your field mapping.
- Click Save in the upper right-hand corner when you're done.
And there you go! You'll be able to find your saved import by going to the Saved tab while the Patrons category is selected. Note that if you're using the Choose File option to select where the import is coming from, you'll need to unlock the import, go to the File Source tab, and select a new import file for future imports. Otherwise, it will just import the same file every time.
February 8th, 2021
Have you ever needed to leave your computer for a moment and wanted a quick way to clear the current patron and item? Well, here's a simple trick to clear those panes so everyone's information remains confidential!
The X command is a great way to perform multiple time-saving functions within Circulation. Let’s take a look at what the “Magic X” can do for you!
Clear the Screen
- With a current patron and item in Circulation, type X in the Command Line.
- Hit Enter/Return on your keyboard.
Tada! In two quick keystrokes, you can clear your patron and item panes!
View Item Information
Another time to use the X command is whenever you want to just view an item without changing its status.
- In the Command Line, type an X followed by the barcode, like this: x 10101.
- Hit Enter/Return on your keyboard.
This will allow you to see the status of the book without initiating any commands.
View Patron Information
You can also do this with a patron. Say you are changing homerooms, and Darla walks up and asks you for a list of all her checkouts.
- Simply type X and Darla's barcode into the Command Line (e.g. x 1000).
- Hit Enter/Return on your keyboard.
You can then quickly print her Patron Details without skipping a beat!