Versions Compared

Key

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

...

  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_BROWN_CO_FieldMap_Baseline_ModifiedMay202022.xlsx
View file
name01OCLS_BROWN_CO_FieldMap_Baseline_4May2022.xlsx

name file like "...FieldMap_Reviewed_20May.xlxs"

View file
name01OCLS_BROWN_CO_FieldMap_Baseline_ModifiedMay202022.xlsx

Joy Wen (Unlicensed) , this is the box where you should post the version of the form you want to see in the data validator. Please post here. Thanks! --Andrea

Andrea Bainbridge (Unlicensed) Jennifer Mo (Unlicensed) Stacey Boileau Uploaded. Thanks!

name like “…FieldMap_Raw_June6…”

View file
name01OCLS_BROWN_CO_FieldMap_RAW_31May2022.xlsx

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

View file
name01OCLS_BROWN_CO_FieldMap_Draft_7June2022.xlsx

 

View file
name01OCLS_BROWN_CO_FieldMap_Final_17June2022.xlsx

June 17

Joy Wen (Unlicensed) , this is the final version of your field mapping. Please confirm below that you ahve reviewed and approve it. (It's just a copy of your draft--no changes were needed, but I still need a confirmation.)

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.

Comment from Joy:

We are letting SIS populate statistical categories, should I remove Patrons / USER_STAT_CATEGORY?

From Andrea (5/9): Yes, Joy Wen (Unlicensed) , you can remove that mapping.

Andrea Bainbridge (Unlicensed) Please find the modified version with the above mentioned change. Thanks!

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

 

 

 

 


...

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

name like "MigrationForm_Raw_May25.xlsm"

View file
name01OCLS_BROWN_CO_MigrationForm_RAW_31May2022.xlsm

June 9, from Andrea:

Joy Wen (Unlicensed) , here is the item subfield report I mentioned in Basecamp:

View file
nameGeorge-Brown.xlsx

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

View file
name01OCLS_BROWN_CO_MigrationForm_Draft_14June2022.xlsm

View file
name01OCLS_BROWN_CO_MigrationForm_ExLDraft_20June__v010.xlsm

Hi, Joy Wen (Unlicensed) . Here is your final migration form for approval. Please review and indicate your approval below.

One small, additional change I made: on the User Group form, I switched line 5, the default, to be an internal group, since all of the groups your had mapped to “NotFound” you had marked as internal. Thanks!

June23:

migration from with additional local tags added.

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

  •  Approved by College /("@" mention yourself to confirm) Joy Wen (Unlicensed)
  •  Submitted to migration (Andrea will check this box)

 

 

 June 17: Joy Wen (Unlicensed)

I have updated your migration form draft:

View file
name01OCLS_BROWN_CO_MigrationForm_ExLDraft_16June__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, which I’ll review before making it final. Thanks!

Changes

  • Questionnaire tab: you must choose to list either a Central order library, or a Default--not both. At Test Load St_James was central, so I deleted the “Default.” But, since you aren’t migrating funds this time, this question is just a formality.

  • User Groups tab: I cleared out the notes you made in some rows, since they were interfering with migration from validation. No migration options changed.

  • Base Status tab: I removed HOLDS and CHECKEDOUT since these statuses are set via the loans and requests extracts

Action Items

  • Alma location tab: please fill in line 112.

View file
name01OCLS_BROWN_CO_MigrationForm_ExLDraft_20June.xlsm

Hi Andrea Bainbridge (Unlicensed) , I made the following changes based on the June 17th draft:

  1. Alma location tab: filled in line 112.

  2. Item Material tab: cleared my notes

  3. User Groups Tab: added a user group missing from the form: STUDENTEXT. Please make sure it’s in our data as the spreadsheet sheet you previously sent only includes item information . Thanks a lot!

 

 June 30 Andrea Bainbridge (Unlicensed) , Hi Andrea, I just wonder whether it’s too late to make one small edit in the migration form: in the “Item Material” tab, map REF-BOOK to MANUSCRIPT. I know it sounds weird but we’ll change it after Go Live. The reason is the material type REF-BOOK is supposed to be globally changed to the location “Reference” to tell them apart from regular books, however, I just noticed this global change didn’t happen… So have to map them somewhere to avoid them being mixed with regular books. So sorry for this late notice and I hope we can still make the edit. Please let me know. Thanks!