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

• 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

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

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=

Finished

Taylor & Francis EBA workflow

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

Unicode

Use MarcEdit to join individual files (Tools, Marc Processing Tools, MARCJoin)

Taylor and Francis EBA edits

replace 001 add prepend taylorfrancis to 001

taylorfrancis

delete fields

037
655
773
949
975
976

find all, delete field if needed (usually there are all 3 5XX fields in a record)

533
538
583

check for problems 830 (Find all: =830)

Delete any with "Online Access". MyiLibrary, Online access with DDA: Askews (Architecture), Online access with purchase: Taylor & Francis, Online access with subscription: Proquest Ebook Central.

check for problems 856 (Edit; Find; Find: =856)

example of clean link: =856 40$uhttps://www.taylorfrancis.com/books/9781003397595

Ready for 856 edits

Add two 9xx fields

MARCValidator

Compile into MARC

Load into Sierra * Use Review Files; Test first; then Load

Check

Track file name; date loaded; and name in:

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

Done.

Notification of removals is generally by email

• and are deleted manually at that point.

example:

Tue 9/19/2023
From: Taylor & Francis eBooks support@email.taylorandfrancis.com
To: Cheryl Adams
Dear Customer,
Title Withdrawn: Sexual Misconduct in Academia: Informing an Ethics of Care in the University
We are writing to let you know about action we have taken with the title “Sexual Misconduct in Academia: Informing an Ethics of Care in the University” edited by Erin Pritchard and Delyth Edwards (ISBN 9781003289944).
This title is subject to a rights reversion process that requires the removal of all copies from all channels of distribution, including existing copies on Taylor & Francis eBooks.
We have identified two similar titles which we will be adding to your license as substitutes:
Toxic Masculinity: Men Meaning and Digital Media (ISBN 9781003263883)
Untaming Girlhoods: Storytelling Female Adolescence (ISBN 9780429491566)
We sincerely apologize for the inconvenience caused and would like to thank you for your understanding.
If you have any questions, please contact our Customer Service team at support@taylorfrancis.com
Kind regards
Taylor & Francis Team