Versions Compared

Version Old Version 72 New Version 73
Changes made by

Melanie Shaw

Melanie Shaw

Saved on

Key

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

FTP download software/app:

...

  • Open WinSCP

  • type in the vendor’s ftp site address and log in with user name & password:

...

  • Image Added

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, best to keep up weekly so they’re not overwhelming

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

  • Start with just shepherding one file at a time thru the process

  • But, once you have good idea of this process, start merging the daily files into one big weekly file (as shown below) for faster processing

...

  1. Use MarcEdit to join individual files

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

    1. Save file: navigate to folder for future joined file; [give it an descriptive name]; Save

      1. example: CAMBRIDGE_BOOKS_ONLINE_EBCOLL_6000746_10202023-11082023

    2. File(s) to join: navigate to folder containing your files to join: select all; Save

  3. Process

...

Replace; add prepend cambridge to 001

  • Edit; Find: =001 ← 2 blank spaces for the indicators

  • Replace: =001 cambridge

...

delete fields (Tools; Add/Delete Field):

037
655
949 (important!)
975
976

find all, and delete field if found (Edit; Find All) =111

...

  • Check for any problems: look for local z subfields; plus extra URLs (for contents, title page), other library’s local data

  • good example: =856 $uhttps://doi.org/10.1017/9781009347181 ← clean with nothing extra

...

  • 856 add |z subfield

    • Tools; Edit subfield data:

    • 856 *add |z Replace with: Available online; click to view

    • New subfield only;

    • Replace Text

...

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

    • Tools; edit subfield data:

    • Field Data ^ (regex symbol meaning: insert in front)

    • 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 check that 856 fields still line up; and no digits (especially subfield letters) are misplaced

Add field:

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

Check for errors/typos (Reports; MARCValidator)

...

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

  • Use Review Files

  • Test first

  • then Load

After loading, go to Create Lists Load

  • Create Lists

  • Copy

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

  • Remove file: Yes

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

...