Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

Introduction

The tables below will be used to capture important notes for Cutover including actions that must be taken prior to migration as well as your library’s data migration preferences. Please follow the instructions included with each table. Please complete sections for colleges by April 29th.

Notes for Cutover (For Ex Libris and Colleges to Complete)

Complete each action item assigned to the College below. Select the check box next to the action item when the item is complete. New items should only be added to this table by Ex Libris. Please contact Ex Libris via Basecamp for questions about these action items.

...

Issue Description

...

Action Items/Due Date (check when done)

...

Ready for Cutover?

...

[issue description]

...

Ex L

  •  [action]; due

College

  •  [action]; due

...

  •  Yes
  •  No

...

[issue description]

...

College

  •  [action]; due

...

  •  Yes
  •  No

...

[issue description]

...

College

  •  [action]; due

...

  •  Yes
  •  No

...

Migration Preferences (For Colleges to Complete)

Indicate your library’s migration preferences by selecting the appropriate check boxes below. Use the links in the header row to find background information and documentation to assist with each decision.

...

Confirm Serial Control - bib matchpoint

Backgrounder

Sirsi Item Material Type Mapping

See Basecamp FAQ

...

Retain at Cutover

ExL Documentation;

See #13 of Cutover Prep slides

Acquisitions Options at Cutover

...

Do you want PQIS enrichment and/or EBC run for you at Cutover, in addition to your 360 or LR form activations?

Troubleshooting E-Resource Duplication Issues

...

Will you participate in Fulfillment Cutover?

ExL Documentation

...

Will you use the Alma offline Circ Utility during Fulfillment Freeze?

ExL Documentation

...

  •  SERC_TITLE_KEY
  •  SISAC_ID
  •  OTHER:
  •  I do need to identify specific parameters for SERC_TITLE_KEY or OTHER as described in the Backgrounder (OCLS and Ex Libris will follow up with you)

...

  •  Map nothing (items inherit material types from bibs)
  •  Map to same field as item type (usually Sirsi 999$t)
  •  Map to 999$x

...

  •  Courses & Reading List Headers
  •  Ledgers and Funds
  •  Licenses
  •  COUNTER data

...

PQIS Activations

  •  I want PQIS at Cutover
  •  I do NOT want PQIS at Cutover

Ebook Central Integration (Ebook Central Perpetual, DDA and Subscription)

  •  I want E-Book Central Pro Integration (EBC) run at Cutover
  •  I do NOT want EBC at Cutover

...

  •  Yes
  •  No

...

  •  Yes
  •  No

Data Preferences (For Colleges to Complete)

Check all that you are submitting again for Cutover.

...

Scope

...

  •  Bib Records (Shadowed)
  •  Bib Records (Unshadowed)
  •  Course/Reserves
  •  Patrons
  •  Fines and Fees/Active Bills
  •  Active Loans

...

  •  Requests/Available Holds
  •  Serial Control
  •  Issue
  •  Funds
  •  Orders (>2011)
  •  Invoices (>2011)

...

  •  E-resource Activation Form
  •  P2E

...

Data Extract Tracking (For Sirsi Colleges and OCLS to Complete)

This table will be used to capture details of the data extract scope indicated above in the Data Preferences table. You may prefer to exclude records from the data extracts that OCLS will complete on your behalf. Use the second column of this table to provide the details OCLS will use to exclude data from your extracts if this is your preference. For example, indicate “exclude bib records that contain 996=Proquest. You will find examples of exclusion identifiers in the third column. Please provide whatever information will be necessary to identify records for exclusion.

...

Data Type

Exclusion Identifier

...

Exclusion Identifier Examples

...

Notes

...

Status (For OCLS to Complete)

...

Bibliographic Records (Shadowed records)

...

Exclude bib records that contain certain MARC fields such as 996=Proquest, or 856=www.nfb.ca

...

Do you want Multi-volume custom script?

Background information

  •  Yes
  •  No

...

Bibliographic Records (unshadowed records)

...

Exclude bib records that contain certain MARC fields such as 996=Proquest, or 856=www.nfb.ca

...

Courses/Reserves

...

Exclude Item Type=LAPTOP (Laptops or other equipment items can be put into another location in Alma.)

...

Not provided at test load.

...

Patrons

...

Exclude All

...

We’re not migrating Sirsi Patrons. Going with a fresh SIS load at Go-Live

...

Fines and Fees/Active Bills

...

Exclude Bill Reason=PROCESSFEE

...

Would like a list of accounts with active fines/fees, but the information does not need to be migrated to Alma as we will not be migrating patron accounts from Sirsi.

...

Active Loans

...

Exclude all loans for the the pseudo user=MISSING

...

Same as above. Not required as we’re not migrating patron accounts.

...

Requests/Available Holds

...

Not applicable

...

Not required

...

Serial Control

...

Exclude Serial Control Created > , or < DATE

...

Changing to SISAC_ID based on recommendation from OCLS

...

Issue

...

Exclude Issue Created > , or < DATE

...

Funds

...

Exclude Funds Created > , or < DATE

...

Not provided at test load.

...

Orders (>2011)

...

Exclude Closed Orders

...

Not provided at test load.

...

Invoices (>2011)

...

Exclude Invoices Created > , or < DATE

...

Not provided at test load.

OCLS Assistance with P2E (For Colleges to Complete)

Do not include collections in P2E that will be activated by other means. See the Troubleshooting e-Resource Duplication Issues note for more information.

Use the table below to identify collection titles that can be extracted in batch by OCLS for your P2E files. Include information OCLS staff can use to identify the collection records.

...

Collection Title

...

Collection Identifier (For example, 996=Curio, or 856=https://www.nfb.ca)

...

Indicate if this collection is a Database or Portfolio

Ex Libris Documentation

...

Add additional Rows as necessary

Test Load Environment Release Notes (For Ex Libris to Complete)

...

Ex Libris has prepared pre-extraction baseline (“version zero”) forms based on your test load forms and changes discussed on the Fleming - Notes for Cutover page. The baseline forms, both Field Mapping and Migration, have been posted below. Please review these forms and follow instructions included in the Sirsi Field Mapping Form Version Tracking table and the Sirsi Migration Form Version Tracking table below.

E-Resource Activation Form

June 24: Alex Homanchuk (Deactivated) , I have uploaded an updated e-Res form to MFT, within the “Cutover Inputs” folder. Please review and approve here. Thanks! --Andrea Andrea Bainbridge (Unlicensed) Thanks Andrea, approved!

...

Sirsi Field Mapping Form Version Tracking

Version | Drop-dead Due Date | Who Will Post

  1. Baseline/Version Zero | May 6 | ExL

  1. Field Mapping for Data Validation | May 20 | Colleges

  1. Raw Field mapping form from the validator | June 6 | Jennifer/Stacey

  1. Draft Form for ExL Review | June 14 | Colleges/Jennifer/Stacey

  1. Final Version for Migration | June 21 | ExL

 

View file
name01OCLS_FLEM_CO_FieldMap_Baseline_5May2022.xlsx

View file
name01OCLS_FLEM_CO_FieldMap_Baseline_Reviewed25May2022.xlsx

name like “…FieldMap_Raw_June6…”

View file
name01OCLS_FLEM_CO_FieldMap_Raw_May30.xlsx

name file like "...FieldMap_DRAFT_June11.xlxs").

View file
name01OCLS_FLEM_CO_FieldMap_DRAFT_June22.xlsx

 

View file
name01OCLS_FLEM_CO_FieldMap_Final_June24.xlsx

June: 24: Alex Homanchuk (Deactivated) , please review and indicate your approval below. Thanks!

Notes

  • This is an unlocked copy of the Test Load (TL)  form that includes changes discussed in Notes for Cutover.

  • Make changes in the form if necessary by May 20th.

  • Communicate changes you make by posting comments on this page.

Notes

  • If no changes were required to the Baseline form at left, repost the form above, or...

  • ...post amended form with required changes above by May 20.

  • Jennifer and Stacey will  use this version when they validate your data.

Notes

  • Jennifer and Stacey will post your copy of the raw field mapping form from the validator here by June 6th.

  • This version of the form is locked. You cannot make changes to this version.

  • Communicate changes needed by posting comments on this page before June 14th if necessary.

  • If no changes are needed, re-post the form at right by June 14th.

Notes

  • If no changes are needed, this may be the final version of your field mapping form.

  • Andrea will post comments or questions to this page if needed.

  • Versions under discussion can be posted below, if needed.

Notes

  • **No Further Changes**

  • Andrea will post the final version of your form here by June 21st.

  • Select the “Approved by College” option below and “@” mention yourself to confirm.

  •  Approved by College /("@" mention yourself to confirm) Alex Homanchuk (Deactivated) Approved.
  •  Submitted to migration (Andrea will check this box)

 

 

 

 June 22: Cheryl Wardell , Alex Homanchuk (Deactivated) , Danielle Emon ,

on Fleming’s Notes for Cutover page, Cheryl indicates that you wanted SERC_TITLE_KEY as the serial control to bib matchpoint. But his version of field mapping has “SISAC_ID” as the matchpoint.

Image Added

Which is your preference? If you want it to be SERC_TITLE_KEY, I can make the change for you.

Thanks! --Andrea

Hi Andrea Bainbridge (Unlicensed) – I noted SISAC_ID on Fleming’s notes for cutover page.

Image Added

Maybe Cheryl Wardell or Alex Homanchuk (Deactivated) can clarify?

>> Danielle Emon , it’s in a comment to Notes for Cutover. --Andrea

Image Added

Andrea Bainbridge (Unlicensed), thx!

 

Sirsi Migration Form Version Tracking

Version | Drop-dead Due Date | Who Will Post

  1. Baseline/Version Zero | May 6 | ExL

  1. Raw Output from the Data Validator | June 6 | Jennifer/Stacey

  1. Draft Form for ExL Review | June 14 | Colleges

  1. Final Version for Migration | June 21 | ExL

 

View file
name01OCLS_FLEM_CO_MigrationForm_Baseline_4May2022.xlsx

name like "MigrationForm_Raw_May25.xlsm"

View file
name01OCLS_FLEM_CO_MigrationForm_Raw_May30.xlsm

June 9, from Andrea:

Liana Giovando , here is the subfield report for Fleming, mentioned in Basecamp:

View file
nameFleming.xlsx

name file like "...MigrationForm_DRAFT_date.xlxs")

View file
name01OCLS_FLEM_CO_MigrationForm_DRAFT_June 22.xlsm

View file
name01OCLS_FLEM_CO_MigrationForm_Final_June24__v006.xlsm

June 24: Alex Homanchuk (Deactivated) , here is the migration form for you to review and approve. Thanks! --Andrea

cc: Danielle Emon , Cheryl Wardell

Notes

  • This document is FOR REFERENCE ONLY.

  • This is a copy of Test Load (TL) form that includes changes discussed in Notes for Cutover.

  • On many tabs it also still contains TL mapping preferences. Use this as a reference for filling out the CO form produced by the validator after June 6th, but DO NOT COPY/PASTE from this form into the CO form.

Notes

  • Jennifer and Stacey will post your copy of the raw migration form from the validator here by June 6th.

  • Colleges: download this form and fill out all tabs manually by June 14.

  • Use the baseline form posted at left as a REFERENCE ONLY.

  • Be sure to fill in all tabs, including the Questionnaire Tab.

  • When complete, post the new version in the column to the right.

Notes

  • Post your approved draft here by June 14.

  • If no changes are needed, this may be the final version of your migration form.

  • Andrea will post comments or questions to this page if needed.

  • Versions under discussion can be posted below if needed.

Notes

  • **No Further Changes**

  • Andrea will post the final version of your form here by June 21st.

  • Select the “Approved by College” option below and “@” mention yourself to confirm.

  •  Approved by College /("@" mention yourself to confirm) Alex Homanchuk (Deactivated) Approved Migration form.
  •  Submitted to migration (Andrea will check this box)