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:

• 

Once logged in to the ftp site, open eba:

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

• Click download and note where the program is saving them

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