1-Wageningen eBook Packages (non-batch): OCLC Cataloging Workflow
Version 1.2
8/3/2023-8/7/2023
Melanie Shaw
Wageningen Academic Publishers Cataloging
Cheryl’s note: w have always cataloged Wageningen e-books individually from OCLC Connexion &/or MarcEdit, rather than batch loading vendor records; and it has been very challenging to figure out what titles are included. The initial order title list may be incomplete or misleading, with many items that haven’t been published yet, and very often the published e-book has a different title. Given all this, we have come up with a fairly quick method that can get several records done and loaded at a time.
Note (Nov.2023): recently bought by Brill.com, so some workflow steps are in flux. This is pretty common in batch ebook processing, something is always changing.
Further note: Hopefully the URLs are not going to change, since Wagenginen used DOI’s for their http links, but best check on brill.com to make sure. If they do change, we will need to change all earlier records of WAP eBook purchases in Sierra.
- 1 Extra documentation:
- 2 I. Wageningen eBook Packages:
- 3 Copy Cataloging of WAP e-books:
- 4 Complex or Original Cataloging
Extra documentation:
MARC records reference:
https://www.oclc.org/bibformats/en.html
https://www.loc.gov/marc/bibliographic/
PROVIDER-NEUTRAL GUIDES:
Review PCC Provider-Neutral Guides:
Or here:
USU Sierra CODE GUIDES:
Master list of E-Resources hooks (latest version): https://usu.app.box.com/file/1326778691763
Largely used for batch loading, but with some overlap for tangible items (2019 version):
Title lists of WAP ebooks:
2022 title list (downloaded from website):
Finished 8/30/2023
2023 titles ordered :
I. Wageningen eBook Packages:
https://www.wageningenacademic.com/
Acquisitions will forward the Wageningen Academic Publisher (or WAP) ebook package title list, with many of the titles being unpublished: preliminary will be noted instead of ISBN; and titles are often subject to change. Paste the newest inventory title list above, and download an unfinished title list from the publisher to work on. I like to highlight titles when I’m finished cataloging & loading them. It may be useful to load the title lists to Box with the other trackers.
Wageningen publisher site is no longer being updated; they are in the processes of switching to Brill.com
Wageningen has recently been acquired by Brill – working on updating this workflow as the website changes are added.
2a. As of 11/7/2023: go to: https://brill.com/page/LibrarianMain/librarians
b. Librarians
c. Books
d. E-Book Collections Title Lists and MARC Records:
e. Or go directly to here: https://brill.com/page/ebooktitles/ebook-collections-title-lists-and-marc-records
f. Then scroll down to E-Book Collections and click in the V in the Alphabetic list to get closer to the W’s
g. Find latest Wageningen list, click on Title List; download (might be useful to investigate the MARC records they are now offering, Wageningen did not)
h. Open title list inside of Excel:
h. I’ve started using the title list to check against acquisitions invoice for title changes, publisher year, etc. - some of the titles open source, and we do have access, so I've been cataloging them (as was Cheryl Adams, our predecessor)
Click on the http link to open the eBook to reference during cataloging
Copy Cataloging of WAP e-books:
II. Review and Select a Record
Search Sierra by title to locate any existing records or brief records.
If record is found in Sierra, and it is for the correct Wageningen eBook edition, then it has already been cataloged. Mark it as cataloged.
If no record is found, run various keyword searches to ensure a thorough search, but then go to OCLC.
Search OCLC for the appropriate record. Key searches could include:
ISBN (cut and paste from Wageningen site, removing hyphens)
Title or Title keywords of document
Author of document
Title and author (or add publisher: Wageningen) combined searches,
If too many results consider, limiting to online resources only
Check that the following fields are correct and/or match the item online:
Fixed Fields in OCLC:
Fixed Fields: check mandatory codes:
(LDR/Leader)
06 - Type: a = Language (textual) material
07 - BLvl: m = monographic item
(008/23) - Form: o = Online
006 - Additional Material Characteristics
examples
006 m d
006 m o d
01 - Type (of Material): m = computer/electronic resource
06 - Form (Reproduction) o = online (doubling the fixed fields)
09 - File (Type of file): d = document/text
To add missing 006 in OCLC, use Guided entry:
Edit; Guided Entry; insert 006; Computer files
007 field:
minimum required codes are these two:
007 c ǂb r
00 - Category of material: c = electronic resource
01 - Specific Material Designation: r = remote
May also contain several other subfield values, which we can ignore unless they contain errors, in which case; either replace them the correct ones, or blank them out to just the two required subfields above.
If missing, add in OCLC, go to: Tools; Macros; Manage; click OCLC + Add&Edit007; Run;
fill in Specific material designation: r
don’t bother adding the other specifics (they can vary over time & between vendors and vendor buyouts)
Variable fields (a selection of MATCHPOINT fields, or generally useful descriptive fields):
020 field: correct ISBN for eBook with (electronic book) or similar designation at the end or in ǂq subfield
Print ISBN goes in ǂz subfield
245 field: MATCHPOINT for most of eBook title page
260/264 field: MATCHPOINT on publisher & year (sometimes or place)
The Netherlands : ǂb Wageningen Academic Publishers, ǂc 2023.
300 is a MATCHPOINT:
300 1 online resource (# pages) : ǂb illustrations. ← check Wagengingen site for page numbers (no $c subfield)
Add 33x fields if missing:
Good to have, if possible:
Add or check for 505 or 520 ← But, only if easy to copy/paste from WAP website
At least one subject: 600, 650, 651, 655
650 0 Potatoes ǂx Breeding. ← easily found on Classification Web
Also note: Although USU don’t require call numbers (050/08x/09x) in ebooks, they can be useful; don’t delete existing call numbers.
Go to WAP MarcEdit WF for mass edits on 856 & 9xx fields: https://usulibrary.atlassian.net/wiki/spaces/ULC/pages/1699676161
OR Continue in OCLC Connexion, to manually add 856 & 9xx fields, if you prefer:
Quick & easy chart for pasting in Connexion (do not use if doing original cataloging)
856 | prefix to link |
|
---|---|---|
| add |z public note |
|
| Example | ǂu https://library2.usu.edu/eval_dist/url856.php?url=https://doi.org/10.3920/978-90-8686-936-7 ǂz Available online: click to view |
949 | create blank line; paste |
|
909 | create blank line; paste |
|
Full Description of 856 and 9xx field editing:
856 field edits:
Delete any other 856 fields that refer to non-Wageningen providers.
856 40 ǂz Click here to view book ǂu https://public.ebookcentral.proquest.com/choice/PublicFullRecord.aspx?p=7137003
If there are more than one version of WAP addresses, choose the https version, unless
there is a DOI version of the URL (can be found in downloaded Title List, if not in the record)
856 ǂ3 Wageningen ǂu https://doi.org/10.3920/978-90-8686-946-6
856 4ǂu [USU prepend][doi webaddress] ǂz Available online: click to view
Delete any ǂ3 subfields
Insert this prepend in front of the ǂu web-address
https://library2.usu.edu/eval_dist/url856.php?url=
Add USU ǂz text to end of 856
Delete existing z subfields, if any
Then add to end of 856:
ǂz Available online: click to view
If 856 is missing (does happen sometimes), find the doi web-address link in the downloaded title list from Brill.com
IF YOU’RE MAKING AN ORIGINAL RECORD, use the Wageningen doi version of web-address of the 856 field without our edits:
856 4 ǂ3 Wageningen ǂu [doi webaddress only]
example:
856 40 ǂ3 Wageningen ǂu https://doi.org/10.3920/978-90-8686-936-7
Add your original record to OCLC…with Action; Holdings; Update Holdings;
Save record
--then copy/paste to make our 856 version (with prepend and public note), before continuing,
856 4ǂu [USU prepend][doi webaddress] ǂz Available online: click to view
example:
856 4ǂu https://library2.usu.edu/eval_dist/url856.php?url=https://doi.org/10.3920/978-90-8686-946-6 ǂz Available online: click to view
Add 949 automatic item creation field:
949 ǂl coonl ǂt 20 ǂn Wageningen 2023 ebook package purchased 2023 ǂz n
Details:
ǂl - Item location: coonl = Online (USU and USU Eastern)
ǂt - Item type: 20 = Electronic Book
ǂn - Has various phrasings, but should probably always have Wageningen ebook package with the year on the e-book package, and year of our purchase (if known).
ǂz - Item code 2 n = Suppress (from public view)
Add a 909 field to sign your work/support statistics in ǂa, the date in ǂb, and “Copy” in ǂc. Include actions taken and notes in ǂe and ǂz, if desired.
example:
909 Melanie Shaw ǂb 2023-08-30 ǂc COPY ǂd CMS STATS
Validate
Edit; Validate OR Shift+F5
Save or F4 each record to the Wageningen Local Save file
Update Holdings
Action; Holdings; Update holdings OR Shift+F8 (if not already done)
When finished with all the titles you can find, mark all records in save file; and Export, naming the file something like: WAP-2023-[month]
Action; Export OR F5
III-Import and Edit in Sierra
Bibliographic Record Load Table
Once edits are made, import into Sierra using the:
BATCH LOAD WorldCat Collection Sets (.collectionsets)
this loader will not look for matches or for duplicate control numbers
no overlay or rejection of records; all will be loaded
Get PC; find file; lfts
Click in Use Review Files box before loading
Test (and if all is well)
Load
IV-Check records in Create Lists
Go to Create Lists; COPY; find file; open LOAD file
Check bibliographic record’s fixed fields Material Type is z for Ebook
Check item has these correct codes:
Field | Field Number | Indicator | Code/Data | Notes |
---|---|---|---|---|
Copy No. | n/a | n/a | 1 |
|
Item Code 1 | n/a | n/a | 0 |
|
Item Code 2 | n/a | n/a | n - Suppress | will allow the 856 url to display |
Item type | n/a | n/a | 20 - electronic book |
|
Location | n/a | n/a | coonl - Online (USU and USU Eastern) |
|
Status | n/a | n/a | available |
|
Barcode | do not add | n/a | no barcode |
|
Call Number | do not add | blank/blank | none |
|
Internal Note | n/a | n/a | Wageningen 2023 ebook package purchased 2023 | or similar. |
Go to View Public Display:
Make sure the record displays as an ebook in the OPAC
Check URL link displays properly and click to test it goes to the title:
Once finished checking through the list, Empty the load list in Create Lists;
then Delete the load files in Data Exchange
VI-Statistics
Record number of records cataloged & loaded; in title list mark titles cataloged/loaded with yellow
Clean up by marking & deleting all records in your OCLC WAP save file & move back to default save file
Complex or Original Cataloging
Bibliographic Record Structure: book format
II. Create a record or Update a minimal record in OCLC Connexion:
CHART FORM:
Field | Indicator | Code/Data | Notes |
Language | n/a | eng | Usually English, for titles we purchase |
Material Type | n/a | a (books, language material) |
|
BLvl | n/a | m (monograph) |
|
Country | n/a | ne | At present: in the Netherlands |
035 | blank/blank | variable | Input/verify OCLC number is included |
049 | blank/blank | UUSA |
|
050/080/090 |
| variable | Leave call nos. if already in upgraded or derived bib |
variable | Author/Agency/etc. | ||
245 | variable | MATCHPOINT | |
264 | 264 1The Netherlands : ǂb Wageningen Academic Publishers, ǂc YYYY. | At present, in the Netherlands, will be changing to Brill at some point…and everything will no doubt be changed | |
300 | 300 1 online resource (### pages) : ǂb illustrations ← if known |
| |
336 | n/a | text ǂb txt ǂ2 rdacontent | add if missing |
337 | n/a | computer ǂb c ǂ2 rdamedia | add if missing |
338 | n/a | online resource ǂb cr ǂ2 rdacarrier | add if missing |
490 | variable |
| |
505/520 | n/a | variable | Add if easily copy/pasted |
650 | variable | Refer to ClassWeb or Library of Congress Subject Headings. Add one subject heading, if possible | |
variable |
| ||
830 | variable |
| |
856 | 1st 856 4ǂu https://doi.org/10.3920/978-90-8686-946-6 2nd 856 4ǂu https://library2.usu.edu/eval_dist/url856.php?url=https://doi.org/10.3920/978-90-8686-946-6 ǂz Available online: click to view
| Add 856 with doi version of URL, Validate and Update/Produce the bib record in OCLC Then add USU prepend and |z public note to 856 before importing into Sierra: 856 4ǂu [USU prepend][doi webaddress] ǂz Available online: click to view | |
949 | blank/blank | 949 ǂl coonl ǂt 20 ǂn Wageningen 2023 ebook package purchased 2023 ǂz n |
|
909 |
| 909 [Firstname Lastname] ǂb YYYY-MM-DD ǂc ORIGINAL ǂd CMS STATS ǂz Wageningen eBooks | Sign your work & support statistics |
Fields in Detail:
Fixed Fields in OCLC:
(Leader/LDR - manditory codes)
Type: a = Language (textual) material
BLvl: m = monographic item
(008/23) - Form: o = Online
006 - Additional Material Characteristics
example and details:
006 m o d
Type of Material: m = computer/electronic resource
Form/Reproduction o = online ← also may have
Type of Computer file: d = document/text
Guided entry:
Edit; Guided Entry; insert 006; Computer files
007 field (minimum required codes):
examples:
007 c ǂb r
00 - Category of material: c = electronic resource
01 - Specific material designation: r = remote
Tools; Macros; Manage; OCLC+; Add&Edit007; Run;
fill in Specific material designation: r
don’t bother adding the other specifics (they can vary over time & between suppliers)
Variable fields (a selection of matchpoints or generl usefulness):
020 field: correct ISBN for eBook with (electronic book) or similar designation at the end or in |q subfield
Print ISBN goes in z subfield
245 field: MATCHPOINT
260/264 field: MATCHPOINT on publisher & year
The Netherland : ǂb Wageningen Academic Publishers, ǂc 2023. ← with current year
MATCHPOINTS for physical (online) form:
300 1 online resource (# pages if known) : ǂb illustrations (if any) ← all online e-resources (no $c subfield)
336 text ǂb txt ǂ2 rdacontent ← all eBooks
337 computer ǂb c ǂ2 rdamedia ← all e-resources
338 online resource ǂb cr ǂ2 rdacarrier ← all online e-resources
Good to have, if possible:
505 or 520 ← if easily copy/pasted
Good to have at least one subject: 600, 650, 651, 655
650 0 Potatoes ǂx Breeding. ← easily found on Classification Web
Also note: Although USU doesn’t require call numbers (050/08x/09x) in e-material, they can be useful; don’t delete existing call numbers when deriving from an existing record.
We will need to keep our specialized data in the 856 field separate from the original/updated) record going into WorldCat.
856 field maneuvers:
Copy the web address from the doi link in the WAP info box:
Add an 856 GENERAL field containing only the doi first:
856 4 ǂ3 Wageningen ǂu [doi webaddress only]
example:
856 4 ǂ3 Wageningen ǂu https://doi.org/10.3920/978-90-8686-946-6
Update Holdings to produce the record in OCLC:
Action; Holdings; Update Holdings; ← OCLC will assign number & add that version of the record as the master record
F4
Then copy/paste our additions into the 856
USU prepend: https://library2.usu.edu/eval_dist/url856.php?url=
USU public note: ǂz Available online: click to view
856 4ǂu [USU prepend][doi webaddress] ǂz Available online: click to view
example:
856 4ǂu https://library2.usu.edu/eval_dist/url856.php?url=https://doi.org/10.3920/978-90-8686-946-6 ǂz Available online: click to view
Add the 949 automatic item creation field:
949 ǂl coonl ǂt 20 ǂn Wageningen 2023 ebook package purchased 2023 ǂz n
Details:
ǂl - Item location: coonl = Online (USU and USU Eastern)
ǂt - Item type: 20 = Electronic Book
ǂn - Has various phrasings, but should probably always have Wageningen ebook package with the year on the e-book package, and year of our purchase (if known).
ǂz - Item code 2 n = Suppress (from public view)
Add your 909 field:
909 Melanie Shaw ǂb 2023-06-23 ǂc ORIGINAL ǂd CMS STATS ǂz Wageningen eBooks
10-Save or F4 each record to the Wageningen Local Save file
12-When finished with all titles you can find, mark all records in save file; and Export, naming the file something like: WAP-2023-[month]
Action; Export OR F5
III-Import and Edit in Sierra
Bibliographic Record Load Table
Once edits are made, import into Sierra using the:
BATCH LOAD WorldCat Collection Sets (.collectionsets)
this loader will not look for matches or for duplicate control numbers
no overlay or rejection of records; all will be loaded
Get PC; find file; lfts
Click in Use Review Files box before loading
Test (and if all is well)
Load
IV-Check records in Create Lists
Go to Create Lists; COPY; find file; open LOAD file
Check bib record’s fixed fields Material Type is z for Ebook
Check item has these correct codes:
Field | Field Number | Indicator | Code/Data | Notes |
---|---|---|---|---|
Copy No. | n/a | n/a | 1 |
|
Item Code 1 | n/a | n/a | 0 |
|
Item Code 2 | n/a | n/a | n - Suppress | will allow the 856 url to display |
Item type | n/a | n/a | 20 - electronic book |
|
Location | n/a | n/a | coonl - Online (USU and USU Eastern) |
|
Status | n/a | n/a | available |
|
Barcode | do not add | n/a | no barcode |
|
Call Number | do not add | blank/blank | none |
|
Internal Note | n/a | n/a | Wageningen 2023 ebook package purchased 2023 | or similar. |
Go to View Public Display:
Make sure the record displays as an ebook in the OPAC
Check URL link displays properly and click to test that it goes to the title:
Once finished checking through the list, Empty the load list in Create Lists;
then Delete the load files in Data Exchange
these have not been recorded in Batch Tracking on Box; might want to consider doing so from now on?
VI-Statistics
Record downloaded/edited records in CAP statistics base under: Genstacks-CopyCat-Electronic
Mark the titles cataloged in current title list and reload current file at top of workflow
Clean up OCLC by marking & deleting all records in your OCLC WAP save file (if you are using it; also switch back to regular save file)
If not using separate OCLC save file, just delete all loaded WAP files