Versions Compared

Key

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

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?

...

Item Base Status

...

Ex L

  •  for CO, make default availability “1”/Available; DONE on baseline CO form

College

  •  [action]; due

...

  •  Yes
  •  No

...

User Stat Categories did not load correctly

...

ExL

College

  •  Review results at TL Delivery PAge.
  •  Determine if additional or different incoming patron fields should be mapped as stat categories. (from Tony, April 26 - we will be using updated user stat categories from our SIS load for current users, all of the new values have been loaded and mapped in Alma. We are considering skipping migrating categories from Sirsi at cutover, but we realize any older/alumni/community/guest accounts not included in the SIS load would be missing stat category values in Alma)

...

  •  Yes
  •  No

...

Preferred name mapping

...

ExL

  •  amend CO field mapping so that Sirsi USER_NAME is not mapped as Alma USER_PREFERRED_NAME; DONE-added to CO baseline form

College

  •  Only Sirsi field sthat contain a first/personal name (should be mapped as preferred. (USER_NAME includes both first and last name)

...

  •  Yes
  •  No

...

course processing unit mapping

...

ExL

  •  there was a bug in migration scripts that created multiple departments in stead of a single department, as requested on the migration form. ExL will fix for Cutover.
  •  Make sure mig form preferences are honored

...

  •  Yes
  •  No

...

bib encoding

...

TL bibs were provided in UTF format, although the declared/expected format was Ansel/MARC-8 (according to OCLS)

College/OCLS

  •  Declare correct bib encoding

...

  •  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

...

Bibliographic Records (unshadowed records)

...

856=https://ebookcentral.proquest.com

...

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

...

we will be excluding Ebook Central from P2E

...

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

...

ADMIN, CASTEST, CIRC, ZCIRC, CUDDY1, CUDDY, ZTECH, ILL, INFO, JNALLAN, JNACIRC, JNALLANCIRC, JNALLANPUB, JNALLANTECH, JNALLANWEB, LONDONMAIN, LONDONMAINCIRC, LONDONMAIN-ILL, LONDONMAINPUB, LONDONMAINTECH, LONDONMAINWEB, PUBLIC, REF, RESERVES, LONDON-RESV, SIPCHK2, SIPCHK3, SIRSI, STACKER, TECH, DEBBIE, WEBSERVER, WOODSTOCK, WOODCIRC, WOODSTOCKCIRC, WOODSTOCK-ILL, WOODSTOCKPUB, WOODSTOCKTECH

...

Exclude User Profile=ADMIN

...

Sirsi pseudo-patrons to be excluded

...

Fines and Fees/Active Bills

...

Exclude Bill Reason=PROCESSFEE

...

The college is fine free.

...

Active Loans

...

Exclude all loans for the the pseudo user=MISSING

...

Requests/Available Holds

...

Not applicable

...

Serial Control

...

Exclude Serial Control Created > , or < DATE

...

Not provided at test load.

...

Issue

...

Exclude Issue Created > , or < DATE

...

Not provided at test load.

...

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)

Notes regarding Fanshawe College - Test Load Environment Release can be found on a different page: /wiki/spaces/CI/pages/379748435 Ex Libris has prepared pre-extraction baseline (“version zero”) forms based on your test load forms and changes discussed on the Fanshawe - 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 Draft Comments

From Andrea, June 16: aonorato (Unlicensed) , we have reviewed your e-Res Activation form on MFT and it looks good.

...

We will consider it final. Thanks!

June 17: aonorato (Unlicensed) , I saw your note below about a possible update to your E-res form. Just tag me here or comment below if you do up load a new version to MFT. Thanks!

June 21: Andrea Bainbridge (Unlicensed) just confirming there were no additional changes to our P2E or E-res form so the two that are already in MFT are final, thanks!

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_FANSH_CO_FieldMap_Baseline_4May2022.xlsx

name file like "...FieldMap_Reviewed_20May.xlxs"

View file
name01OCLS_FANSH_CO_FieldMap_Reviewed_13May2022.xlsx

name like “…FieldMap_Raw_June6…”

View file
name01OCLS_FANS_CO_FieldMap_Raw_June6.xlsx

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

View file
name01OCLS_FANS_CO_FieldMap_Draft_June6.xlsx

 

View file
name01OCLS_FANS_CO_FieldMap_Final_17June2022.xlsx

June 17:

Hi, aonorato (Unlicensed) . Here is your final field mapping. Please review and approve it below. (There were no changes from the draft you submitted at left, but please do approve this copy.)

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.

 

 

 

 


 

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_FANSH_CO_MigrationForm_Baseline_4May2022.xlsm

name like "MigrationForm_Raw_May25.xlsm"

View file
name01OCLS_FANS_CO_MigrationForm_Raw_June6.xlsm

June 9, from Andrea:

aonorato (Unlicensed) , here is your item subfield report I mentioned in Basecamp:

View file
nameFanshawe.xlsx

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

View file
name01OCLS_FANS_CO_MigrationForm_DRAFT_June10.xlsm

Andrea Bainbridge (Unlicensed) we’ve found a few records in Sirsi that are incorrect and have the library/location Londonmain and Reference, but they should be Cuddy Reference. Are we able to collapse both Reference locations into the Cuddy library during cutover, or will we have to update the location of these items in Alma after go-live?

aonorato (Unlicensed) , you can map those locations to an existing Alma location via the migration form mapping.

View file
name01OCLS_FANS_CO_MigrationForm_Final_17June2022__v002.xlsm

June 17:

aonorato (Unlicensed) , here is your final migration form. Please review and approve it below. Thanks!

June 24: version with additional locals added

View file
name01OCLS_FANSH_CO_MigrationForm_Final_23June2022__v002.xlsm

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.

 

 

 From Andrea, June 14:

aonorato (Unlicensed) I made some updates to your draft migration form. See below for a list of the “Changes” I made, and “Action Items” for you.

 

View file
name01OCLS_FANS_CO_MigrationForm_ExL_DRAFT_June13.xlsm

Download THIS VERSION of the migration form in order to make the changes requested in “Action Items” before you submit your final migration form.

For “Changes” listed below, there is no action needed unless you want to make a different choice than I did.

Changes Andrea Made

Questionnaire Tab

  • I added 950 as a local field, which is where your Sirsi catkey will be preserved.

Location Tab

  • I made “london” the default library for the “UNASSIGNED” location, as it was at Test Load. Line 5.

Item Type

  • Different codes can’t share the same description, so I changed Column D for lines 11 and 12, so they wouldn’t repeat the value from Column D, line 5.

Item Material

  • This tab needs a default value in line 5, so I chose “BOOK” for you in line 5.

Action Items for You

Questionnaire tab:

  • Review line 19. This was “no” for Test Load, but you listed “Yes.” Do you really want subfield indicators to appear in your item level/alt call numbers? If yes, that means the call nos will appear with the “$h” etc. like:

  • Image Added

Andrea Bainbridge (Unlicensed) here is our updated form, I did update line 19 of the questionnaire to match the test load

All of the other changes you made look good

If there are any other changes to our mapping or migration forms please let me know and I’ll get it updated asap

Our eResource Activation Form is uploaded to MFT as well - we may have one small change to make next week (I’ll upload a new copy if we do end up changing any resources for cutover)

View file
name01OCLS_FANS_CO_MigrationForm_ExL_DRAFT_June14.xlsm