Search Results for: patron records

Create a List of Online Registration Patron Records

 Searching for new online registrations in Create List:

  1. In an empty Review File, set store record type as “Patron p”.
  2. Leave the “Range” index setting in place.
  3. Use the following search strategy:
    • Line 1:  Type=Patron, Field=Created,  Condition=Between, Value A = the start of your date Range, and Value B= the end of your date range
    • Line 2: Type= Patron,  Field = Stat Class, Condition= The stat class value assigned in your template*
      *The number assigned uses a 0 in place of the asterisk in the terminal number
  4.  Click Search.

Reviewing Online Registration Patron Records

Remote/Patron Self-Registration Policy
[Resource Sharing Standards]

Staff shall review records that have been created online within 30 days for accuracy and duplicate records. The record will be considered temporary until verified by staff.  Records that have not been verified to meet previously stated registration policy or merged with an existing record within 30 days will be expired.

A verified record must include the library code and initials of who verified it and the date of verification.  The records must be reviewed within 30 days of the created date.

Remote/Patron Self-Registration Review Procedures

New Record Alerts: There are 2 ways to be alerted that new registrations have been completed.

  1. An email notification is sent by Sierra and forwarded by Mid-Hudson staff to a designated staff member of the library.  The notices are sent only on weekdays.  The notice includes only the name, and barcode (pnumber) of the registrant.  A separate notice is sent for each completed registration.  
  2. Create lists can be used to retrieve records to be reviewed in batches.

 Searching for new online registrations in Create List:

  1. In an empty Review File, set store record type as “Patron p”.
  2. Leave the “Range” index setting in place.
  3. Use the following search strategy:
    • Line 1:  Type=Patron, Field=Created,  Condition=Between, Value A = the start of your date Range, and Value B= the end of your date range
    • Line 2: Type= Patron,  Field = Stat Class, Condition= The stat class value assigned in your template*
      *The number assigned uses a 0 in place of the asterisk in the terminal number
  4.  Click Search.

Record Review and Necessary Edits

Libraries with online registration will review all patron records created through their form within 30 days to determine that someone is eligible. Staff completely and accurately fills in all required fields and checks Sierra to determine if a record already exists. Staff verifies home library and notifies home library when appropriate. Follow local procedure to issue a 14 – digit barcode.~RS Standards

  1. Is this your record?
    If this patron resides within another libraries service area, edit the home ptype and home library to reflect your best estimate of where the patron resides and send that library an email with identifying information or a screen capture.  They will be responsible for this record’s review or pass the record to another library.
  2. Check for duplicates
    1. Check to see if a record for this patron already exists using the name, birth date and other information in the new registration.  A second sierra session is helpful in this process.
    2. If a duplicate record exists.  Determine which of the records is the more complete and valid version.  This will become the Destination record in the merger process.   If the records are comparable, the activity on the record can be used to determine the Destination Record.  Recent activity will be indicated in the CIRCACTIVE field.   The record that is less complete or not recently used will become the Source record in the merge process.Merge Record Instructions.

      At this point you will be working with a new Patron.

  3. Insert and Create the APATID:  The Online form cannot produce an APATID (a patron ID) the review process includes creating the APATID.
    1. Click Insert field and scroll to find the APATID Field.
    2. Create the APATID as follows:
      The APATID is created from the first 4 letters of the Patron’s Last Name (if last name does not have 4 letters insert an “*” for each missing letter), followed by the first letter of their first name and then the single digit of their birth month followed by the two digits to indicate the day of the month. For October use the Letter O, for November use the letter N and For December use the letter D. The APATID IS TYPED IN UPPER CASE. This field is necessary to check for duplicate records.

      Example: Smith, John, born 7/04/1976 APATID = SMITJ704
      NOTE: To search by APATID, type the letter “u” before the APATID in the search box type “uSMITJ704” , and press enter.

  4. Review Record Content
    • Records should include all required fields according to Resource Sharing standards.  The form required fields and template defaults should have produced a complete record, but staff should verify.  
    • Check for corrections in formatting, Alphabetizing and spelling.
  5. Update the Created by field
    • You will add your libraries 3 letter code and your initials
    • Check with your director for your local policy on how this statement is formed.
  6. Complete the local procedures
    • Check with your library administration to review local procedures in place for updating message and note fields.

Circulation & Patron Records

Ordering Barcodes and Patron Cards

You never want to find yourself without a good stash of barcodes for your items or barcoded patron cards.  These are custom orders that must be ordered in advance using particular prefix and formats to work in our Integrated Library System.  Your new barcodes will need to use your current prefix, and duplicate any existing records or unused supply you may yet use.  

What do you need to know before you order?

    1. What type of barcode do we use?
      Codabar14 digit barcode, where the last digit is a check digit in a modulus 10 (Mod-10) complementary check digit format (more detail on this format).  When you are looking at the barcodes on a sheet, they may not look consecutive to you until you ignore that last number.
    2. What is a check digit?
      A check digit is the last digit in our codabar barcode.  It is the correct answer to an equation that is done on the previous 13 digits in the code.   It’s purpose is to check the validity of the barcode as it is scanned.  An incorrect answer would result in an error message, alerting you to rescan.
    3. What your next number should be?
      You wont want to repeat any number you have already used.  Create a list of all of your current records.  Sort the list by the barcode number.  Look at the first and last barcode number in your list.  The largest of the two numbers is the highest number that has been issued.  You will need to also check your current stock to find a higher number.  What is the next highest group that you would order.
      For example if your highest barcode is 22390000027896, you might consider moving to the next decimal place and order 2239000010000#, where the last digit is the check digit.  In this example we just added started the next range by replacing the last 0 with a 1.  

Document the order for the next time you need to order.

 Barcode Validity Checking: An Example
A typical barcode consists of 14 digits in the following pattern:
Example barcode
In this example, the barcode uses a modulus 10 (Mod-10) complementary check digit. The check digit derives from the barcode as follows:
Mod-10 Algorithms Differ Among Vendors

The method for calculating a Mod-10 check digit can differ from vendor to vendor. Check with your barcode vendor to determine if their algorithm matches the algorithm used here.

  1. Starting with the second digit from the left, add every other digit. Using the example barcode above (without the check digit):
    Add every other digit
  2. Multiply each of the remaining digits by 2. If any product has two digits, add the digits to produce a single-digit number. Sum the results:
    Add numbers together
  3. Add the results from steps 1 and 2. In the example:
    16 + 30 = 46
  4. Subtract the units digit obtained in step 3 from the number 10. The result is the check digit. In the example:
    10 – 6 = 4
4 is the check digit for the example barcode.

Can’t place holds on ordered records – RESOLVED

Problem: Patrons cannot place holds on titles that are yet to be released, like they can in Encore.

Reported: 11/19/21

Resolution: Mid-Hudson has adjusted the settings of each material type in Vega to be requestable even when no items are yet attached to bib records. The issue should be fixed. Please let us know if you are still having problems with this.

Continue reading

Create List: Import Records

Importing Records from a File

You can create a new review file by importing a list of barcodes, record numbers, or indexed field values. Before creating your list, see Format of Input Files for information on how to format your files.

To import from a file:

  1. Select Create Lists from the Function list.
  2. On the Review Files tab, select an empty review file by clicking its row, or select a file to overwrite. To find empty review files, select Empty from the drop-down menu of review file types.
  3. Click Import Records.
  4. If prompted to overwrite the existing file, do one of the following:
    • Click Yes to open the Import Records dialog box and overwrite the file.
    • Click No to return to the list of review files.
  1. Enter a name for the review file. The maximum length is 150 characters.
  2. Select how you want to import records into the review file by doing one of the following:
    • To import a list of barcodes, select the Barcode radio button.
    • To import a list of record numbers, select the Record Number radio button.
    • To import a list of index entries, select the Index radio button, and select an index from the drop-down menu.
  3. From the Store Record Type list, select a record type to store. The list shows only the valid record types for the import method or index you selected in the step above.
  4. Click Choose File. The Select File dialog box opens.
  5. Select the text file containing the data you want to import, and click Load. Create Lists processes the file and displays the results in the bottom half of the Import Records dialog box.
Error Messages During Loading

If the file you selected contains entries that cannot be loaded, Create Lists displays an error message. See Error Messages During Loading for more information.

  1. Click Import to create the review file, or click Cancel to close the dialog box without creating a review file.

Format of Input Files

Input files must be formatted with one value per line. The system searches for exact matches only; partial matching is not supported (for example, entering “12345” in a file will not find a barcode with the value of “123456”).

In addition to the rules above, each input method has additional formatting requirements listed below.

Barcodes
When importing a list of item or patron barcodes, keep the following in mind:
  • You can import barcodes using either a .txt or .csv file.
  • Include the barcode number only; do not include the field group tag.
Record Numbers
When importing a list of record numbers, keep the following in mind:
  • You can import record numbers using a .txt file only; .csv files are not supported.
  • Valid record numbers must begin with the record type tag, such as “b” for bibliographic records.
  • Create Lists recognizes record numbers with a character length equal to the smallest record number in the system up to the largest record number in the system.
  • The system ignores delimiters and other extraneous text.
  • The check digit is not required, but can be included. If your library has mixed-length record numbers, Innovative recommends excluding the check digit, as a 6-digit record number might be confused with a 7-digit record number. In this case, you can import 6-digit and 7-digit numbers separately.
Indexed Fields
When importing a list of indexed field values, keep the following in mind:
  • You can import record numbers using either a .txt or .csv file for indexed fields.
  • Phrase indexes are supported; keyword indexes are not supported.

Error Messages During Loading

When you load a .csv or .txt file, Create Lists processes each entry in the file. If any entries cannot be loaded, Create Lists displays an error message stating there are one or more entries that:

  • Don’t match any record
  • Match multiple records
  • Don’t fit in the review file

For example:

To download the error file:

  1. Click Download. The system opens the Save file dialog box.

If you are using Sierra Web, the system automatically saves the file to your Download folder.

  1. Enter a name for the error file.
  2. Navigate to the location where you want to save the file.
  3. Click Save. Create Lists saves your file and returns you to the Import Records dialog box.
  4. If you have valid entries (shown in the bottom half of the Import Records dialog box), continue with the import process above.

Serials – Holdings Records

While the traditional text holdings statements are enough for most libraries, it is also possible to configure the Serials module to let your patrons know exactly which issues you have.

You will do this by setting up the Holdings for your subscription

To begin, open the Card for your periodical subscription –

On the  left had side of the screen, there are six tabs. Along with the Card tab is one for Holdings

With no issues currently checked in, there is nothing to display in the Holdings window.

Before checking in the first issue, update the Card so that the check box Update Holdings? is checked. With this box checked, the Update Holdings? box on the Card screen will be checked as well.

When an issue is Checked In, the Card is updated to reflect that the Issue has Arrived.

When the Issue is Checked In, as long as the Update Holdings? box is checked, 

The Holdings tab display will reflect the issues the library owns.

When additional issues are Checked In, Sierra will update the Holdings display automatically.

The Holdings display will even correctly reflect when a Volume of Issues has bee received and a new Volume begins.

Sometimes an Issue will not have arrived before you receive the following issue – you may Check In Issue 3 before Issue 2 has arrived. When this happens, there is a Gap in your library’s Holdings.

Sierra will recognize this Gap and your Holdings will reflect this Gap accordingly.

But the previously missing Issue may arrive eventually and you will check it in,

When you Check In this issue, there is no longer a Gap in your Holdings and Sierra will update the Holdings display to close the Gap.

With the Holdings updated for your subscription, your patrons will know exactly which issues your library owns –

When patrons search for a periodical,

The Holdings for your library will display,

Showing both the latest issue you have received as well as the range of all the issues housed in your library.

Patron Images

Description: If your library chooses to use the Internal Patron Images feature, you can capture patron photographs of your patrons and display them in patron records.

Impact: By choosing to enable the Show patron photo option for staff members’ Sierra logins, library staff will be able to view and/or take patron photographs to be stored in patron records. These photographs can provide another level of security for the patron’s account.

If your library chooses to use the Patron Images feature, and you have access to a camera, you can take a patron’s photograph, which will be displayed in the Patron Record. Sierra will display the patron’s photograph in the patron display window.*

The Patron Images feature will be displayed from the Circulation Desk function as well as the Inter-Library Loan function. 

*If there is no photograph associated with the Patron’s Record, Sierra will display the photograph area as blank.

Merge Patron – Online Patron registration Record

Before you begin the actual merge process, you will want to really review the records to determine which will be the Source record (the record that you will copy from) and which will be the Destination record (the record you will copy to). The Destination record will be the one record remaining.

The following considerations should be taken to determine the best Destination. The considerations are listed in the order of importance, with 1 being the most important.

  1. Are there active transactions on the record? If items are checked out, holds, fines, or linked patrons, the record is currently “in use” and is likely the best Destination record.
  2. Is the Circ active date recent? This is an indicator that the card is being used in transactions, authentication, or has been logged into by the patron. This field is updated when the card is used by the patron.
  3. Is the record data more inclusive? If neither record has active transactions or a recent circ active date, then the completeness of the record can determine the Destination record.

Select “Merge Duplicate Patron Records” from the Functions drop down menu.

Sierra will open the Merge window, where you will identify the patrons you wish to merge.

In the first field, enter the patron record number that you want to serve as the source record (old or lesser record).

In the second field, enter the patron record number that you want to serve as the destination record (the record that will be kept).

After you enter a patron record in each field, Sierra enables the Merge Patrons button. To merge the patron records that you entered, select the “Merge Patrons” button. Sierra merges the patron records unless any of the following conditions is true:

    • Conditions that Prevent the Merging of Patron Records — Problems & Descriptions
      • Busy records – Item records that are linked to the source record cannot be busy.
      • Holdshelf – Source record cannot have a hold with an “on the holdshelf” status.
      • Identical records – You cannot merge a single record.
      • Length – Modified destination record cannot exceed 100K in size.
      • Too many links – The number of item links in the modified destination record cannot exceed 1900.

If any of the above conditions is true, Sierra displays a brief description of the problem. After you view the message, Sierra returns you to the previous screen.

If the patron records that you entered can be merged, Sierra displays both records. For example:

If you do not want to merge these records, select the Close icon. Sierra returns you to the previous screen.

If you want to merge these records, select “Merge Patrons”. Sierra combines information from both records into the destination record and then deletes the source record. Sierra Circulation adds a NOTE field that contains the source record number and the date to the destination record.

You may need to clean up the patron record a little to remove fields that are redundant or no longer accurate.

If the circ active date of the source record is populated.  You should ensure that an Overdrive account that may exist on the Source record is merged in that interface too.

Log into your Overdrive Market account and go to “Support”

In the merge patron function put the  8 digit Source record number in the “Original User” field, and the 8 digit Destination record number in the “New User ID”.