Alma Test Load - Reports and Statistics

A note on file names: The general file naming convention for this spreadsheet is "01CARLI_XXX_Testload_Migration_Stats.xlsm" (where "XXX" is your institution's three-letter code), though the file name for your institution's own spreadsheet may vary from that. The file name may be missing the word "migration" or there may be a slight misspelling in one of the words.

This file contains your migration statistical counts from Ex Libris, divided by functional area in the spreadsheet tabs.

On each tab, after the Counts of records section, any records that did not migrate to Alma will be listed, along with the reason for rejection.  The Code/ID is provided for records that were rejected during the migration process, along with a brief description of the reason for rejection.  The Code/ID provided are for the record as found in Voyager since the rejected records were not migrated to Alma. 

In the future, the CARLI Office will be providing some recommendations on the best way to address or remediate these rejected records prior to the extract for the Spring 2020 production load. 

The File may contain the following tabs, depending on the types of data that your institution migrated: bib_inventory, vendor, fund, fund_tx, p_order, invoice, patron, loan, request, course, p2e.

bib_inventory:

• Counts of migrated bibs, holdings, and items in Alma. 
• Number of Portfolios in Alma from your Link Resolver migration. If you did not migrate any link resolver data, this number will be 0.
• Number of Portfolios in Alma from ILS (Voyager P2E) should closely match the number of portfolios assigned in your P2E file. If you did not submit a P2E file, this number will be 0.
• Number of Packages/DBs in Alma from your Link Resolver migration. If you did not migrate any link resolver data, this number will be 0.
• Number of Packages/DBs in Alma from ILS (Voyager P2E) should match closely with the number of packages or databases assigned in your P2E file. If you did not identify records as packages or databases in your P2E file, or did not submit a P2E file, this number will be 0.
• List of Voyager record IDs rejected during migration and a brief description of the reason. 

Where to check these counts in Alma:

Note: For Images of these click paths and other searches in Alma see Alma Data Migration Review - Alma Searches

if your institution didn't migrate Acquisitions, these five tabs will not be present:

• 1. vendor:

  • Number of Vendors from ILS (Voyager)
  • Number of Vendors matched from Electronic Resource Management System (ERMS) and ILS. If you did not migrate ERMS data, this number will be 0.
  • Number of Vendors from ERMS. If you did not migrate ERMS data, this number will be 0.
  • Number of Interfaces.
  • List of any vendors that were rejected and a brief description of the reason. 
•  
• Where to check number of Vendor counts in Alma: Acquisitions  >  Acquisitions Infrastructure - Vendors

• 2. fund:

  • Lists a count of the Ledger count, Summary fund count, and Allocated fund count for each Fiscal Year migrated.
  • List of any funds that were rejected during migration and a brief description of the reason. 
•  
• Where to check fund counts in Alma: Acquisitions >  Acquisitions Infrastructure - Funds and Ledgers. Alma defaults to Active funds and ledgers in the Current Fiscal Period. Use facets to check other years.

• 3. fund_tx:

  • Count of each type of fund transaction migrated.
•  
• Where to check fund transaction counts in Alma:  Acquisitions  > Acquisitions Infrastructure - Funds and Ledgers. Alma defaults to Active funds and ledgers in the Current Fiscal Period. Use facet type Allocated fund to check balances.

• 4. p_order:

  • Count of purchase orders migrated:
    • by order type present in Alma
    • by status in Alma
  • List of any purchase orders that were rejected during migration and a brief description of the reason. 
•  
• Where to find purchase order counts in Alma: Basic Search >  Order lines - All - wildcard character ? - Purchase Type facet arrow (on left) includes the by order types counts. Similarly, the Status facet includes the closed/cancelled, waiting for invoice, sent, and waiting for renewal counts. To compare the closed/cancelled counts with the stat number, add together the cancelled and closed counts.

• 5. invoice:

  • Count of invoices migrated by status in Alma
  • List of any invoices that were rejected during migration and a brief description of the reason. 
•  
• Where to find invoice counts in Alma:  Search Invoices >  All - search by status (ex. Closed)

patron

• Number of internal patrons migrated (those that would not typically be updated by batch load in Voyager). If your library does not add patrons by batch load in Voyager, all patrons will be listed as internal.
• Number of external patrons migrated (those that are typically updated by batch load in Voyager).
• List of any patrons that were rejected during migration and a brief description of the reason.

Where to find patron counts in Alma: Admin > User Management > Manage Users - Account dropdown arrow allows you to limit to external or internal users instead of all. 

loan

• Number of loans.
• List of any loans that were rejected during migration and a brief description of the reason. 

Where to find the number of loans in Alma: Basic Search: Physical Items > Keywords - wildcard character * - Process Type facet (on left) - add together the loan and lost counts. 

request

Note: this tab is related to call slip (local) requests only. This tab will not be present if your institution does not do local call slip.

• Number of requests.
• List of any requests that were rejected during migration and a brief description of the reason. 

Where to find requests in Alma: NOTE: Request Operator Role is required (scoped to each circulation desk where you want to check the Active Hold Shelf).

1. To check All requests in the institution, your current location must be set at the Circulation Desk. Then, select  Fulfillment >  Resource Requests > Monitor Requests & Item Processes.
2. To check requests on hold at a specific library/circulation desk, your current location must be that particular circulation desk. Select Fulfillment > Resource Requests > Active Hold Shelf.

course

• Number of courses.
• List of courses any that were rejected during migration and a brief description of the reason.

Where to find the number of courses in Alma: Fulfillment > Course Reserves > Courses

p2e

• New E-resources from bibs, holdings, and items.
• Total new Portfolios.
• Total new Electronic Collections.
• Total new Databases.
• List of any E-resources that were rejected and a brief description of the reason.

This information reflects the results of processing the P2E file you submitted pre-migration. Since related counts were already checked under bib_inventory, use this tab specifically to check for rejected records from the P2E processing.

Reference:
September 19, 2019 Open Office Hour on this topic

A note on file names: The general file naming convention for this report is "01CARLI_XXX_multi_match report.txt" or "01CARLI_XXX_NZ_multi_match report.txt" though the file name for your institution's own report may vary from that. The file name may be missing the "NZ" or may contain the term "link," or there may be a slight misspelling in one of the words. Your institution's copy of this report may be either a text file (.txt) or a comma-separated value file (.csv).

This report lists records that are included the "Number of records failed to link" to the Network Zone (NZ) Statistics. If a record in your database matches more than one record in the NZ, the linking will fail. This most often happens because of multiple OCLC numbers in the local bib (including multiple 035$a as well as 035$a plus an 035$z).

The report has at least 2 columns: the first column is the local IZ Alma Metadata Management System (MMS) record ID, and the additional columns are the NZ Alma MMS record ID numbers that it matched with.

This file is purely informational and I-Share libraries are not expected to do anything with this information at this point.

The CARLI Office will be providing some recommendations on the best way to address these records prior to the extract for the Spring 2020 production load. 

A note on file names: ProQuest 360 Link Resolver Activation Report: The general file naming convention for this report starts with "01CARLI_XXX_Link_Resolver" (where "XXX" is your institution's three-letter code) and is a Excel spreadsheet (.xlsx). The file name for your institution's own report may vary from that. It may begin or end with a string of numbers, or may include "360LR" or "Activation" in the file name.

Not every library will receive this report.

If your library migrated from ProQuest 360 products, you will receive this report containing four tabs:

• Statistics: total number of databases that matched or did not match to E-collections in the Community Zone.
• 360 DB to Alma E-collection: list of the original databases from 360 and the match found in Alma.
• Selective titles without ID: titles of portfolios that did not match in Alma.
• Titles for unmatched collections.

More information:
October 3, 2019: Reviewing P2E and Link Resolver Data
Ex Libris 360 and Intota Migration Guide

If your library has purchased e-resources through ProQuest but not all e-resources to which you subscribe were included in your Link Resolver data, you will also find a ProQuest Enrichment report listing those collections which Ex Libris has activated on your behalf.  Not every library will receive this report.

Each institution's data was loaded to their Alma Institution Zone first and then linked to the I-Share Network Zone. The I-Share Network Zone was created from an extract of Voyager UCdb data--that is, the I-Share union catalog--on 8/22/2019.

Example Report:

Network Zone Statistics: Your Alma environment has been linked to the CARLI I-Share Network Zone.

• Records processed: 43,821 (Number of Bib records attempted to link to Network Zone)
• Number of records successfully linked: 41,579 (Number of Bib records linked to Network Zone records)
• Rate of success: 94.88% 
• Number of records failed to link: 2,242 (Number of Bib records that did not link - Possible reasons: see multi-match report, no OCLC number to match, vendor records, short bibs for ordering, reserve items, etc.)

Records that failed to link are bib records that were loaded to your Institution Zone (IZ) successfully, but they were unable to be linked to a matching record in the Network Zone (NZ). CARLI knows of at least six reasons why records might have failed to link:

1. IZ bib has no OCLC number
2. NZ bib has no OCLC number
3. Both 1 and 2 are true for the same record of the same institution
4. IZ bib has multiple OCLC numbers, and matches to more than one NZ bib
5. IZ bib has a single OCLC number, and multiple NZ bibs have matching OCLC number
6. The record does not exist in the NZ

CARLI staff are working with Ex Libris on some strategies to identify these records so that we can recommend clean-up options for libraries. Some will require work in Voyager, but some will be more easily accomplished in Alma.

On each institution's test load migration stats report there is a reference on the Overview Tab to the IDMappings.zip file: "To see a list of all identifiers from the previous ILS mapped to the new Alma identifier, see the the ID mapping zip file. The ID mapping zip file contains all identifiers, and is generally not used to check migration. However, it may be useful in the future, for example if you have lists of records with your previous system's identifier and wish to perform cleanup based on these lists." 

CARLI will share these ID Mapping zip files with libraries as needed.

CARLI has provided the raw reports that were generated when your library's data were extracted from Voyager for the Test Load.  The Voyager extract reports are in a separate folder called "xxx voyager extract," where "xxx" is your institution's three-letter code.

report.xlsx

This is the main file with several tabs providing counts of the number of different types of records extracted from Voyager.  Possible tabs include: vendor*, patron, fund*, inventory, boundwith, p_order*, loan, invoice*, request, course, fund_tx*, ereport.  (*Only libraries that migrated Voyager Acquisitions data will have these tabs.) Of particular interest are these two tabs:

• inventory tab - contains counts on bib/holdings/items read and extracted, as well as bib records skipped due to link resolver migration.
• boundwith tab - contains counts of bib records created due to boundwiths.  For more information on how Voyager boundwiths migrate to Alma, see the Voyager to Alma Migration Guide.

Various other extract files are also provided in this folder, many of them detailing rejected records and the reason for their rejection. 

Reports were automatically generated even if they were empty for your institution, so if you have a file that is just a few bytes in size or zero bytes and looks empty when you open it, this means that your extracted data did not contain any of these kind of records and those files can be ignored.  For example, if the file invoice_line_item_funds_duplicates.csv is empty, no invoice line item fund duplicates were detected in your institution's extract.

If you have any questions about the contents of the Voyager extract reports, please contact CARLI.