Centennial College - Notes for Cutover

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

Action Items/Due Date (check when done)

Ready for Cutover?

TL users were missing “original ID”

Resolution Notes:

Per Katrina in Basecamp: data has been corrected; no need to update field mapping. https://3.basecamp.com/3765443/buckets/23965261/messages/4554663642#__recording_4746717058

Ex L

[action]; due Jan 10, 2022

College

Review field mapping at Cutover; is there a better candidate for what to map to “USER_ID”, instead of USER_ALT_ID? And/or: review patrons who are missing whichever value is mapped to “USER_ID”. See https://3.basecamp.com/3765443/buckets/23965261/messages/4554663642
See list of affected patrons here. NOTE: the tab is filtered to display only the missing USER_ALT_ID, but the other users are there. This way you can reference the same line numbers you see in stats:
Use other data in the record, like USER_ID field to identify the patron.
Yes
No

Preferred name mapping for patrons

ExL

Remove “USER_NAME” as preferred name on baseline migration form.

Only fields that contain personal/first names should be mapped as preferred.

USER_NAME includes user first and surname

@Andrea Bainbridge (Unlicensed) We aren’t including preferred name in our SIS load, so we actually don’t want any names mapped as preferred.

Yes
No

migrated patron barcode made internal per request

College

ExL

Course unit mapping

At TL 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.

ExL

items embedded in shadowed bibs were not migrated

ExL

College

CENTENN requests no resource be active for them in the NZ

College/OCLS

missing 360 selective titles

https://3.basecamp.com/3765443/buckets/23965261/messages/4667662902

ExL/College

change to patron email mapping at CO

See Basecamp: https://3.basecamp.com/3765443/buckets/23965261/messages/4853790805#__recording_4864624909

ExL

 

College

field mapping changes for CO

Bibs & Items tab

Patrons tab

Loans Tab

 

Fines & Fees Tab

migration form changes for CO

Questionnaire tab

 

Item Type tab Andrea Note (5/3): @Katrina Hansen , you can make these changes directly to the “raw” migration form that comes out of the data validator. See my other notes in green below.

We will be renaming some of these. Have already been configured to the proper Fulfillment Units (ex: DVD_3DAY already circulates in Alma for 7 days, which is what we want – now we need to rename that item type to DVD_7DAY) --- Below is the list of Item Types to be renamed:

Line 6 - 3_DAY_LOAN – change to 7_DAY_ACCM – change to description: Accompanying Book for DVD - 7 day loan

Line 13 - AUDIO_CD3 – change to AUDIO_CD7 – change to description: Accompanying Audio CD for DVD - 7 day loan

Line 29 - CDROM_3DAY – change to CDROM_7DAY – change to description: CDROM - 7 day loan (essentially they want them to be the same as Line 30)

Line 35 - DVD_3DAY -- change to DVD_7DAY – change to description: DVD - 7 day loan

Line 37 - DVD_3_DIV -- change to DVD_7_DIV – change to description: Diversity Collection - DVD - 7 day loan

Line 57 - VIDEO_3DAY – change to VIDEO_7DAY – change to description: Videocassette - 7 day loan *don’t ask why we still have videocassettes, but alas, we do…

Line 58 - VIDEO_DIV3 – change to VIDEO_DIV7 – change to description: Diversity Collection - Video - 7 day loan

 

 

User Group tab Andrea Note (5/3): @Katrina Hansen , you can make these changes directly to the “raw” migration form that comes out of the data validator.

IMPORTANT:

Line 15 – CCEMPLOYEE change to External

Line 36 – STAFF change to External

(we will be getting all employee records in our SIS load!)

 

UserStatCategories tab

Decision pending, as you know

 

Fine Fee Type tab

Line 6 and Line 11 – Jessica created new Fine/Fee types for us for these two fee types. Not sure if these new Fine/Fee types will be included to ‘match’ on our new migration form?

From Andrea (5/3): changes to Alma do not also update the migration form. But depending on the change, code vs. label, the form may offer the “correct” option. What are the two new types in Alma? I will take a look.

 @Andrea Bainbridge (Unlicensed) the two new types are ‘3D Printing’ and ‘Makerspace’; @Katrina Hansen , we won’t be able to assign that fine/fee type during migration.

Courses tab

Again, I think we will need to map these, in order to achieve what we currently have in our Alma test load. Andrea Note (5/3) Yes--and I have made this change to field mapping, which will cascade to the “raw” migration form.

 

 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

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

Confirm Serial Control - bib matchpoint

Backgrounder

Sirsi Item Material Type Mapping

 

See Basecamp FAQ

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

 

From Andrea (5/3): Done.

 

 

From Andrea (5/3): Done.

 

 

From Andrea (5/3): I’m unchecking “funds” to be retained, based on conversation below. Please submit a new funds file for Cutover.

PQIS Activations

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

 

From Andrea (5/3): Noted.

 

 

From Andrea (5/3): Noted.

 

From Andrea (5/3): Noted.

 

Data Preferences (For Colleges to Complete)

Check all that you are submitting again for Cutover.

Scope

Scope

 

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)

Fulfillment Data Exclusion Identifier

Fulfillment Data Status (For OCLS to Complete)

Data Type

Exclusion Identifier

 

Exclusion Identifier Examples

Notes

Status (For OCLS to Complete)

Fulfillment Data Exclusion Identifier

Fulfillment Data Status (For OCLS to Complete)

Bibliographic Records (Shadowed records)

13682 records extracted

68 records submitted for cutover (see comment - MM, 2022/06/06)

 

 

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

Extracted JM 2022/05/24

Not applicable

Not applicable

Bibliographic Records (unshadowed records)

70838 records

Sirsi Home Location = E_RESOURCE (same as test load)

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

Extracted JM 2022/05/24

Not applicable

Not applicable

Courses/Reserves

1527 records

 

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

 

Extracted JM 2022/05/24

Not applicable

Not applicable

Patrons

113895 records

 

Exclude User Profile=ADMIN

 

Extracted JM 2022/05/24

ACQU

ACQUFUND

ACQVIEW

ADMIN

BINDERY

BOOKING

CATA

CCTEST

CIRC

DISCARD

HYPERADMIN

HYPERION

ILL

LIBRARYUSE

LOST

LOSTCARD

MISSING

PROCESS

PUBLIC

REPORTS

SCANNER

SERIALS

SHIPCAMPUS

SIRSI

STANDALONE

SVA

TECH

TECHSERV

WASHTONBEE

WCC

WCCC

WDOWNSVIEW

WEBSERVER

WIT-PRO

WKIOSK

WPOLLOCK

WPROGRESS

WSTC

ZCASHTONBEE

ZCASHTONBE

ZCCCC

ZCDOWNSVIEW

ZCDOWNSVIE

ZCIT-PRO

ZCKIOSK

ZCPOLLOCK

ZCPROGRESS

ZCSTC

ZTASHTONBEE

ZTASHTONBE

ZTCCC

ZTDOWNSVIEW

ZTDOWNSVIE

ZTIT-PRO

ZTKIOSK

ZTPOLLOCK

ZTPROGRESS

ZTSTC

114799 records
Done JM 2022/07/21

Fines and Fees/Active Bills

575 records

 

Exclude Bill Reason=PROCESSFEE

 

Extracted JM 2022/05/24

718 records
Done JM 2022/07/21

Active Loans

1898 records

 

Exclude all loans for the the pseudo user=MISSING

 

Extracted JM 2022/05/24

2071 records
Done JM 2022/07/21

Requests/Available Holds

74 records

 

Not applicable

 

Extracted JM 2022/05/24

65 records
Done JM 2022/07/21

@Andrea Bainbridge (Unlicensed)

Serial Control

308 records

 

Exclude Serial Control Created > , or < DATE

 

Extracted JM 2022/05/24

Not applicable

Not applicable

Issue

30738 records

 

Exclude Issue Created > , or < DATE

 

Extracted JM 2022/05/24

Not applicable

Not applicable

Funds

137 records

 

Exclude Funds Created > , or < DATE

 

Extracted JM 2022/05/06

Not applicable

Not applicable

Orders (>2011)

5 records

 

Exclude Closed Orders

 

Extracted JM 2022/05/24

Not applicable

Not applicable

Invoices (>2011)

 

Exclude Invoices Created > , or < DATE

The college doesn’t migrate invoices at cutover

 

Not applicable

Not applicable

 

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

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

***As we did for test load, Centennial will again create our own short P2E file of bib records for physical items which also contain links to online versions of the resource. We will not need OCLS assistance. (MM)

N/A

N/A

 

 

 

 

 

 

Add additional Rows as necessary

 

 

 

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

Notes regarding Centennial College - Test Load Environment Release can be found on a different page: https://clo-collaboration-spaces.atlassian.net/wiki/spaces/CI/pages/379748394

Link to Mapping and Migration Form Version Tracking Page

Centennial College - Mapping & Migration Forms