10/6/2023
Open tracking spreadsheet here: https://usu.app.box.com/file/1321317102096
always copy/paste file name to tracker as part of the downloading process
Table of Contents |
---|
Downloading the files (both JSTOR and ProQuest)
...
YBP eDDA from JSTOR beginning April 1, 2021 | |||
Record source: YBP ftp | Name: utahstate | Password: M&45rt |
Do not use MarcEdit to merge these files; their delete files need to be loaded in succession with these files in date order and come in a little bit irregularly (usually, but not always monthly)
load weekly files of new records (if same date as deletes) first
then load the delete file (check that delete date is after the last new file loaded, but before the next new file)
JSTOR will be in same files as the ebc Proquest discovery records, so get those at the same time
Load jstor first, then ebc Proquest
filename will have .f2 at end: as of 12/10/2023, switched to .f1
001 will start with jstor
856 field will have: //www.jstor.org within link
also have 710 with JSTOR
...
MARC8, not Unicode (default for MarcEdit is MARC8)
Open MarcEdit-->MARC Tools-->navigate to file in Downloads or Documents (once Windows recognizes Marc files -- just double click on the file & MarcEdit will open it) keep the same name
click Execute:
record number of records that MarcEdit processed into mrk in the Tracking sheet (and use it as a quality check, while you go thru editing and loading)
Edit Records (to open MarcEditor)
...
Deletes: |
delete 037 fields: Tools-->Add/Delete Field--> Field: 037--> Delete Field
|
Look for misleading series titles for other ebook collections in 830’s |
check for 830s needing deletion such as =830 \0$aBook collections on Project MUSE. (But don’t delete real series statements):
|
|
you can double check results (if any) by redoing the =830 Find all |
If unsure that an 830 is a real series title; Jump to record and look for a matching 490 series title; usually libraries will not add 490 field titles for local ebook collections |
...
Replace provided prepend with our new one: | |
Prepend as provided by GOBI: Our current version: Edit-->Replace | =856 40$uhttps://library.usu.edu/catlog/url856.php?url=https://www.jstor.org/stable/10.2307/jj.5590586$zAvailable online; click to view |
=856 40$uhttps://library2.usu.edu/eval_dist/url856.php?url=https://www.jstor.org/stable/10.2307/jj.5590586$zAvailable online; click to view | |
copy/paste old version into Find: | https://library.usu.edu/catlog/url856.php?url= |
copy/paste new version into Replace: | https://library2.usu.edu/eval_dist/url856.php?url= |
Quality Check--> File-->Save You can do a Find all =856 if desired | Number of replacements should match the number of records in the file |
...
But if you want to fix the above error: Find: =082-->[scroll to find error]-->Jump to Record-->
copy entire field and use Replace change incorrect 1st indicator: \ to 0
...
Load table: | BATCH Load YBP DDA discovery records (.ybpdda) |
Always select:Use Review Files | |
Always Test first; check number of records loaded, look for problems, | and if none, then Load |
Quality Checking (no editing needed in Sierra for these files)
...
Remember to record in tracker: https://usu.app.box.com/file/1321317102096
General rules:
Do not use MarcEdit to merge the new files; their delete files need to be loaded concurrently in date order with the new, and come in a little bit irregularly (mainly, but not always, monthly)
will be in same download file list as JSTOR, so download at the same time
Load JSTOR first; and this one, ebc-ProQuest, second
Will have .f1 at end of file; as of 12/10/2023 changed to .f2
001 will start with ebc
856 will have: //ebookcentral.proquest.com
also: 710 with ProQuest
...
Prepend as provided: | =856 40$uhttps://library.usu.edu/catlog/url856.php?url=https://www.jstor.org/stable/10.2307/jj.5590586$zAvailable online; click to view |
No proxy prepend needed in this e collection, so we delete it | =856 40$uhttps://www.jstor.org/stable/10.2307/jj.5590586$zAvailable online; click to view |
| https://library.usu.edu/catlog/url856.php?url= |
| (leave empty) |
| |
|
|
...
Edit-->Find |
---|
Find: Creators in the academic library Jump to Record to look at each one (if desired) |
Can also Find each field; then sort the results by clicking on the 1st column header: |
The “duplicates” in the file above all appear to be false (possibly the validator is set too broad) |
File-->Save
File-->Compile File into MARC (with same name; I add Done to end)
...
Load Table: | BATCH Load YBP DDA discovery records (.ybpdda) |
Always checkmark:Use Review Files | |
Always Test; check numbers loaded, look for problems, | and if none, then Load |
Quality Check (no edits needed in Sierra)
...
Finish recording in spreadsheet: https://usu.app.box.com/file/1321317102096
Clean up data exchange and create lists
Take stats for Cataloging: records loaded: Modified Batch
YBP purchased records:
workflow is here: 3D-Purchased YBP UALC
...
eDDA/etc. GOBI workflow (via email)
...
UALC consortial eDDA
YBP eDDA from ProQuest Ebook Central
(file name as provided starts with dda; add ualc_ at the beginning for clarity)
Record source: YBP ftp | Name: ualc | Password: P#37sb | |
Records are in dda folder | ddaYYYYMMDDf1.mrc
| add ualc ----> | ualc-ddaYYYYMMDDDf1.mrc
|
Record file name in tracker after adding ualc: |
...
edit replace text in 856 | old version | ours |
Edit Subfield Data
| ualc-ebooks | usu |
edit subfield 856 z | Available online; click to view | |
Edit Subfield Data
| Available online; click to view |
910 edit
old version | our version | |
change 910 wording | =910 \\$aYBP DDA consortia | =910 \\$aUALC YBP DDA discovery record |
OR: | use Edit Subfield Data: |
|
check for 830s needing deletion such as: | =830 \0$aBook collections on Project MUSE. |
...
Load table: | BATCH Load UALC YBP DDA discovery records (.ualcybpdda) |
Select: Review Files | Test, then Load |
Create Lists-->Copy
Check hooks
Test link in OPAC and Encore
Finish recording in Tracking sheet: https://usu.app.box.com/file/1321317102096
Add to CAP stats: General Stacks-Batch-Modified
...
UALC Consortia Purchases
Recieve Receive email with mlib-acquisitions_users@lists.utah.edu among the addresses that there are UALC shared eDDA purchase records available; can log in to admin. site or or just check regularly in ecat, can download files from ecat to see titles to edit. Note invoice number from email.
General YBP UALC purchased workflow is here: https://usulibrary.atlassian.net/wiki/spaces/ULC/pages/1773437026/3D-Purchased+YBP+eDDA+etc.+GOBI+workflow+via+email
Academic Complete: on separate workflow page
...