Versions Compared

Key

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

Introduction

Ex Libris has prepared pre-extraction baseline (“version zero”) forms based on your test load forms and changes discussed on the Georgian - 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.

 

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

name file like "...FieldMap_Reviewed_20May.xlxs"

  •  reviewed. CMc

View file
name01OCLS_GEORG_CO_FieldMap_Baseline_4May2022 (3)_REVIEWED.xlsx

name like “…FieldMap_Raw_June6…”

View file
name01OCLS_GEORG_CO_Field_Map_RAW_31May2022.xlsx

Raw form, with UNLOCKED Bibs & Items tab:

View file
name01OCLS_GEORG_CO_Field_Map_RAW_31May2022_itemsUNLOCKED.xlsx

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

View file
name01OCLS_GEORG_CO_Field_Map_RAW_31May2022_itemsUNLOCKED (3)_BIBS tab revised_2022 June.xlsx

 

View file
name01OCLS_GEORG_CO_Field_Map_Final_24June2022.xlsx

June 27: Final field mapping posted above. Approved by Carol in comment thread below. --Andrea

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)
  •  Submitted to migration (Andrea will check this box)

 

 

 

 June 17: Carol McNabb I noticed you no longer had user stat categories mapped on the field mapping posted above. Was that intentional? Do you want to migrate those for Cutover?

Please note that that I expected the values we mapped would be present; they were not.

June 20: Carol McNabb , here is the form where the patron tab is unlocked, if you want to add the Sirsi user categories as note fields.

June 23: per discussion have added SIRSI USER_CATEGORY3 as a note.

View file
name01OCLS_GEORG_CO_Field_Map_ExLDraft_20June2022_edited by CMc.xlsx


 

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. Draft Version for Migration | June 14 | ExL

Final Version for Migration

 

View file
name01OCLS_GEORG_CO_MigrationForm_Baseline_4May2022.xlsm

name like "MigrationForm_Raw_May25.xlsm"

View file
name01OCLS_GEORG_CO_Migration_Form_RAW_31May2022.xlsm

June 9, from Andrea: Carol McNabb , here is your subfield report, as mentioned in Basecamp:

View file
nameGeorgian.xlsx

Posting reviewed form

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

View file
name01OCLS_GEORG_CO_Migration_Form_RAW_Reviewed_2022 June 15.xlsm

View file
name

Andrea will post

01OCLS_GEORG_CO_Migration_Form_Final_June24_v004.xlsm

June 27: final migration form for Cutover, approved by Carol in comment thread below. --Andrea

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)
  •  Submitted to migration (Andrea will check this box)
 

 

  June 17, from

Andrea :

Carol McNabb I have updated your migration form draft:

View file
name01OCLS_GEORG_CO_Migration_Form_exLDraft_June16__v002.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.

You can upload your next version below. Depending on your answer above about user stat category mapping, we may need to amend your migration form for that, but please attend to the comments below.

Changes

Alma Library tab

  • The values you entered do not actually exist in Alma. (You listed “BA” but the code in Alma for Barrie is “BARRIE.”) I replaced them with the library codes that do exist in Alma. See below for location tab implications.

Action Items

Alma Location Tab

  • For column C, you must use values from the “Alma Library” tab.

  • Fill in the lines at the bottom--all columns. These values are in your data but weren’t on the form.

  • Make sure that where you use the same Alma Library/Location pair in cols C/D that the rest of the cells are also the same. See the final tab of the migration form for a report of these errors. As an example, this is not allowed:

Image Removed

Item Type

  • Different Alma codes can’t have the same description. See the report tab for a report, but here’s an example:

  • Image Removed

(either map to the same code, or provide unique descriptions for the codes.)

User Groups tab

  • Please fill this in, all rows. Not: you can use the User Groups that already exist in Alma, otherwise new user groups will be created to match your form entries.

Uploaded reviewed form. Please advise if further changes required. Thanks.

- when I try to “edit” this page and attach the file it won’t open the table properly so posting here

View file
name01OCLS_GEORG_CO_Migration_Form_AndreaDraft_exLDraftJune24_June16__v002 (3)_v004_rev. by CMc.xlsm

June 24:

Carol McNabb, I’m still seeing over 100 warnings like:

Image Removed

As the warning says, we can let this go, and all rows were a code is repeated will just inherit the settings of the first row where the pair appears. In the example below we would force a “no” value for the one marked in red.

Image Removed

That’s option 1.

Option 2 is for me to post the full list of the warning, so you can try to reconcile all of them. Please let me know as soon as possible what you would like to do.

  •