Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

View file
nameFieldMap_Confederation_Reviewed_17May.xlsx

name like “…FieldMap_Raw_June6…”

View file
name01OCLS_CONF_CO_FieldMap_Raw_June6.xlsx

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

View file
name01OCLS_CONFED_CO_FieldMap_Baseline_14JUNE2022_COMPLETE.xlsx

 

View file
name01OCLS_CONFED_CO_FieldMap_ExL_Draft_20June.xlsx

June 20: swalker7 (Sarah Walker) , this field mapping from has the mapping for 999$v added in. Please review this from and indicate below to (formally) show you approve. Thanks1 --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 swalker7 (Sarah Walker)
  •  Submitted to migration (Andrea will check this box)

 

 

 

 June 16, from Andrea:

cretter (Unlicensed) Tiffany.Miller (Unlicensed) swalker7 (Sarah Walker)

I have made a minor change to your field mapping form, and have one other note below. The new version is here:

View file
name01OCLS_CONFED_CO_FieldMap_ExL_Draft_15June.xlsx

  • On the serial control tab I mapped the old Sirsi SERC_TITLE_KEY to a note field (otherwise it wouldn’t migrate anywhere, since you switched to SISAC_ID as a matchpoint). The tab is unlocked, so you can delete this mapping if you like.

  • I noticed some of your items have 999$v, but “v” wasn’t mapped as “volume.” I unlocked the “Bibs & Items” tab in case you want to add this mapping.

If you are ok with my change and have no further changes yourself, you can post here to confirm you have reviewed/approved of my version.

Or, post a new version below if needed and I’ll review. Thanks!


...

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

name like "MigrationForm_Raw_May25.xlsm"

View file
name01OCLS_CONF_CO_MigrationForm_Raw_June6.xlsm

June 9, from Andrea: cretter (Unlicensed) , here is your item subfield report that I mentioned in Basecamp:

View file
nameConfederation.xlsx

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

View file
name01OCLS_CONF_CO_MigrationForm_14JUNE2022_COMPLETED.xlsm

Andrea will post

View file
name01OCLS_CONFED_CO_MigrationForm_Final__June21__v004.xlsm

June 21:

swalker7 (Sarah Walker) cretter (Unlicensed) Danielle Emon Tiffany.Miller (Unlicensed)

Please review this final version of your migration from and indicate your approval below. Thanks! (Please do the same for the field mapping form in the section above). --Andrea

June24:

version with additional local fields added

View file
name01OCLS_CONFED_CO_MigrationForm_Final__June24__v004.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 swalker7 (Sarah Walker)
  •  Submitted to migration (Andrea will check this box)

 

 

 June 16, from Andrea:

cretter (Unlicensed) , Tiffany.Miller (Unlicensed) swalker7 (Sarah Walker) I have updated your migration form draft:

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

Changes

Questionnaire tab

  • I added 950## as a local field, to preserve your Sirsi catkey.

Item Material Tab

  • I cleared all the values from this tab, since your mapping form and Cutover Survey indicated that you did not want this mapped.

Action Items

Base Status

  • I added lines 10, 11. Please fill these in.

Item Type Tab

  • Please provide mapping for all lines, like 9, 12, etc. You can map these to the “ZZZ”/”No Item Policy” if you don’t want to migrate the ones you had left blank.

  • I added three lines at the bottom--these were in your item subfield report. Plz fill these in, too.

View file
name01OCLS_CONFED_CO_MigrationForm_June21.xlsm

Andrea Bainbridge (Unlicensed) Updated file - can you check and make sure that this is completed correctly? We decided to not have item policies for most of the items since they will be captured in the location policy and we don’t have a lot of exceptions.