FTP download software/app:

Since all browsers have stopped supporting FTP protocols, we will use LIT’s suggestion of the WinSCP software:

• Download for Windows, if needed: https://winscp.net/eng/download.php

  • All users

  • Accept all the defaults and lawyer repellant

  • and Open

Downloading

• Open WinSCP

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

• 

Cambridge University EBA

tracker: https://usu.app.box.com/file/1318202855178

• After downloading files; log them into the tracker

MarcEdit for Joining files

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

Cambridge EBA edits

Unicode - Check MarcEdit

Use MarcEdit to join individual files if desired: (Tools, Marc Processing Tools, MARCJoin).

• Detailed instructions here: Join two or more MARC files into one

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

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

533 (often there are all 3 5XX fields in a record)
538
583
773

check for problems in field 830

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

• Find: =830

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

check for problems in 856

• 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

• 

  hmmm…seems to be just another form of Cambridge link, tested the link, and it does work

If no problems show up, go on to 856 Edits

• 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)

• Fix simple errors by referring to Bib Formats and Standards or MARC21

• 

Compile into MARC

• File; Compile into MARC; copy/paste name from Tracker w/added done on end, if desired

Load into Sierra:

Track file name; date loaded; and your name in:

https://usu.app.box.com/integrations/officeonline/openOfficeOnline?fileId=1318202855178&sharedAccessCode=

Statistics: record stats to go into monthly CAP Statistics Airtable base in GenStacks-Batch-Modified

Finished

Notification of removals is generally by email

• and are deleted manually at that point.