Versions Compared

Key

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

...

Cambridge

Record source:  YBP ftp

ftp://ftp.ybp.com

utahstate

M&45rt

eba folder (both Cambridge and Taylor & Francis will be in folder)

Cambridge records are first, Taylor & Francis below that

Useful info:

Might as well also download the Taylor&Francis while you’re there

  • Cambridge and T&F create files daily, it’s best to keep up weekly loads, so it doesn’t get overwhelming

  • It’s a good idea to delete earlier Cambridge and T&F files from whatever folder you use for downloading

  • You can start with just shepherding one file at a time thru the process,

  • Then start merging daily files into one (or 2) big weekly file (as shown below) for faster processing

...

  1. Tools,-->Marc Processing Tools-->MARCJoin:

    • Save file: navigate to your chosen folder for the future joined file; [give it an descriptive name]; Save

      • name example: CAMBRIDGE_BOOKS_ONLINE_EBCOLL_6000746_10202023-11082023

    • File(s) to join: navigate to folder containing your files: select all of them; Save

  2. Click Process

...

Open in MarcEdit MarcBreaker:

...

  1. Open: navigate to joined file (.mrc)

  2. Save As: I give it the same name (will be in .mrk) and location

  3. UTF8 for Default Character Encoding

...

  1. Execute:

...

  1. Before closing the MarcJoin window: record the joined filename and number in the tracker

  2. click on Edit Records

MarcEdits

...

Prepend addition of cambridge to 001

...

  1. Edit-->Replace

    • Find: =001 ← and 2 blank spaces

    • Replace: =001 cambridge

    • Replace all

    • Save (I generally save after each major edit)

  2. Quality Check: number modifications should match number of records in file

    • Can also do a Find: =001

Delete a selection of fields

  • Tools-->Add/Delete Field):

...

Delete Fieldall these Fields (each deletion will have different numbers of fields removed)

037
655
949
975
976

Delete selection of fields if any: Edit-->Find, and delete field if found

...

Edit-->Find Find: =533 Find All

  • 533

  • 538

  • 583

  • 773

  • If not found, no need to open Add/Delete Field

  • If found use Tools-->Add/Delete Field to delete

Check for problems in field 830

  • Check for any problematic 830s indicating other libraries' DDA & other vendors' programs, & if found, delete them

    • Such as Project MUSE

    • Delete if found, but leave regular series titles in

  • Edit-->Find

    • Find: =830

  • You can enlarge the Results window up/down and sideways:

...

If in doubt of any one 830 title:

  • select title, Jump to Record, & check for a matching field of 490 for a regular series title

Check for problems in 856

  1. Check for any problems

    1. Edit --> Find:

    2. look for local z subfields; plus extra URLs (for contents, title page), other library’s local data

...

      • clean example:

        • =856 $uhttps://doi.org/10.1017/9781009347181

...

        • with nothing extra

...

      • Alternate clean example:

        • =856 40$uhttps://www.cambridge.org/core/product/identifier/9781839983382/type/BOOK

...

If no problems show up, go on to 856 Edits

  • 856 add |z subfield

    1. Tools-->Edit subfield data:

    2. Field: 856 Subfield: |z Field Data: [leave blank]

      • Replace with: Available online; click to view

      • Select New subfield only

    3. Replace Text

    4. Save

    5. QC: scroll down and check that 1st 856 z looks good

...

  • 856 add prepend to front of |u https://library2.usu.edu/eval_dist/url856.php?url=

    1. Tools-->Edit subfield data:

    2. Field: 856 Subfield: u Field Data:

    ^
    1. ^b (regex symbol meaning: insert in front)

    2. Replace with: https://library2.usu.edu/eval_dist/url856.php?url=

      • Use regular expression, and

        • Remove Subfield code from scope (otherwise u will be pushed to the end)

        • Replace text

...

  • Do a quick quality check on the 856 fieldsFile

    • Edit --> Find --> Find: =856

    • Image Added

  • Save

Add

...

fields

  • Tools-->Add/Delete Field

Field

Field Data

910

\\$aCambridge University Press EBA with GOBI

949

\\$lcoonl$t20$nCambridge University Press EBA with GOBI$x50$zn

number added should match number of records in file

  • Save

Look at first record to make sure the new fields line up, more or less

Image Added

Check for errors/typos

...

  • Reports --

...

  • > MARCValidator

    • You must Save before running the validator

  • Fix simple errors by referring to Bib Formats and Standards or MARC21 or just follow the Validator suggestions if clear

...

...

  • Duplicates as reported in the example above, are generally not true dups. (I started out checking most of them, and all of them so far have had similar titles, but were different publications entirely)

  • If any corrections were needed: Save

Compile into MARC

  • File -->Compile → Compile into MARC;

    • copy/paste name from Tracker w/added done or ready on end, if desired

...

Load into Sierra

...

Function-->Data Exchange-->Get PC-->navigate to “done” file

  • Prep (should have same number of records)

  • Select lmarc -->Load

loader:  BATCH LOAD Worldcat Collection Sets (.collectionsets) - *

  • Use Review Files

  • Test first (check number of records loaded is correct)

  • then Load

After loading, go to Create Lists

  • Create Lists

  • Copy

  • locate & select Load review file (no way of sorting review files, alas)

  • Do you want to remove file: Yes

Double-click and check a record or two:

  • 001 cambridge

  • bib 910 Cambridge University Press EBA with GOBI

  • item internal note: Cambridge University Press EBA with GOBI

  • item code 1 (repurposed from completed Wiley EBA): 50

  • Can also View; Public Display to see OPAC, then test the URL

After loading, do title search in Encore, confirm bib record number (bottom of record in Encore - Bookmark This Record, Persistent Link) and check link

Note – batch loads may take a while to get uploaded into Encore

Clean up files in Data Exchange and the Create Lists review file of inserted records -

  • HIghlight review file name

  • Empty

...