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

More information and how to save sites here: https://usulibrary.atlassian.net/wiki/spaces/ULC/pages/1756725317/FTPing+with+WinSCP

Downloading

• Open WinSCP

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

• 

Once logged in to the ftp site, open eba:

• Select the most recent (usually a week’s worth) of Cambridge files

• Click download and note where the program is saving them. or Browse to put them somewhere else (I have separate named folders for all ftp batch files)

Cambridge University EBA processing

• After downloading files; log them into the tracker https://usu.app.box.com/file/1318202855178

MarcEdit for Joining files

Use MarcEdit to join individual files

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

4. File will show up in your folder of choice

Cambridge EBA edits

Unicode

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

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

Open in MarcEdit MarcBreaker:

• Open: navigate to joined file (.mrc)

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

• UTF8 for Default Character Encoding

• 

  Execute:

• Note the number of records; record the joined filename and number in the tracker

• Edit Records

MarcEdits

Replace; add prepend cambridge to 001

• Edit-->Replace

  • Find: =001 ← and 2 blank spaces

  • Replace: =001 cambridge

  • Replace all

• Quality Check: number modifications should match number of records in file

  • Can also do a Find: =001

Delete fields

• Tools-->Add/Delete Field):

Edit-->Find, and delete field if found

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

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

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:

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

• 

  variant form of Cambridge link, tested one as weblink, and it does work

If no problems show up, go on to 856 Edits

• 856 add |z subfield

  • Tools-->Edit subfield data:

  • Field: 856 Subfield: |z Field Data: [leave blank]

    • 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: 856 Subfield: u 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 quality check on the 856 fields

• File-->Save

Add field:

• Tools-->Add/Delete Field

Check for errors/typos (Reports-->MARCValidator)

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

File-->Save (if not already saved)

Compile into MARC

• File-->Compile into MARC; copy/paste name from Tracker w/added done or ready 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.