Create ability to search using OCLC number in 001 tag field to confirm if holdings set for your library

[ndonahoo]

Data extraction is currently tied to ISSN/eISSN or ISBN and LCCN. Government publications generally do not have either of those. Would be beneficial to be able to search the OCLC database by 001 tag field and be able to confirm - yes or no - that holdings for your institution are set.

[lmccoll44]

Hello! This is Lisa McColl from Lehigh - I was just speaking with Michelle and I wanted to make sure I understand this request. It sounds like your main goal in the case is for MatchMARC to tell you if your holdings are set or not set in OCLC for government documents, and that the best way to do that lookup is to use the 001 field (I'm assuming as provided by MARCIVE? so for example =001 ocm03208653)

Is that correct?

[ndonahoo]

Yes, that is correct!

If we just overlay MARC records already in the catalog with those received from Marcive, we erase 'clean up' work done after the records go to Backstage Library Works for Authority Control. Backstage is a service that compares subject and name headings in our MARC records against databases maintained by the Library of Congress and other authoritative sources in order to standardize access points.

By being able to run MatchMARC with the ability to tell us if holdings are set or not set in OCLC for government documents, using the 001 field - as provided by MARCIVE - so for example =001 ocm03208653, I can have Library Computer Services load records in totality for any title where holdings are not set for OIP [Boise State University]. Where holdings are already set for OIP [Boise State University] in OCLC, I can use MARCEdit to strip out the fields we do not want to be changed and have Library Computer Services load the remaining fields for that MARC record for updating.

I have found no other way to achieve what needs to be done without requiring untold hours of manual checking and changes. If you are willing and able to add this functionality to MatchMARC, I think you will find that this capability will have far-reaching support and use by any number of libraries.

Many thanks for considering helping us by adding this capability to MatchMARC and I look forward to hearing from you.

Regards,

Nancy Donahoo

Nancy Donahoo

Manager - Serials, Continuing Resources & Government Documents Acquisitions & Collections Albertsons Library Boise State University 1910 University Drive, MS1430 Boise, Idaho 83725-1430 208.426.4038 @.***

On Fri, Oct 14, 2022 at 10:01 AM lmccoll44 @.***> wrote:

Hello! This is Lisa McColl from Lehigh - I was just speaking with Michelle and I wanted to make sure I understand this request. It sounds like your main goal in the case is for MatchMARC to tell you if your holdings are set or not set in OCLC for government documents, and that the best way to do that lookup is to use the 001 field (I'm assuming as provided by MARCIVE? so for example =001 ocm03208653)

Is that correct?

— Reply to this email directly, view it on GitHub https://github.com/suranofsky/tech-services-g-sheets-addon/issues/10#issuecomment-1279189840, or unsubscribe https://github.com/notifications/unsubscribe-auth/A3OYNVIS5QYNTHST47NYKKLWDF7XFANCNFSM6AAAAAAQ63TNF4 . You are receiving this because you authored the thread.Message ID: @.***>

[lmccoll44]

That makes sense - so you would use MARCEdit to extract that 001 field and that would be your input into the MatchMARC sheet I'm imagining, correct?

[lmccoll44]

@mis306lu - I think this calls upon the same functionality that I've heard others would like, but I can't remember when or where: the ability to input OCLC numbers into MatchMARC and then use MatchMARC features for the returned records. In the case above and in many cases OCLC numbers are prefixed by letters - MatchMARC could require the user to input numbers only or if the code could ignore letters and only take the numbers that would be easier on the user - eliminating a find/replace step.

[ndonahoo]

Hello again -

Here is how I would obtain the OCLC numbers to run in MatchMARC for determining if holdings are set for OIP [Boise State University].

We receive an Excel spreadsheet each month showing titles, etc. for the government documents that are in that month's Marcive load:

OCLC number SuDoc number Item number Title Date Holdings Location on1346170301 A 1.1/8-2: 0006-J-04 (online) Budget summary. 2017 BDOCEJRNL on1343175586 A 13.151:H 36/2 0079-B-12 (online) Investigating potential effects of heli-skiing on golden eagles in the Wasatch Mountains, Utah : 2007 BDOCEBK on1241968601 A 13.66/2:SC 2/4 0079-C (online) 2019 science highlights : 2019 BDOCEBK on1243325191 A 13.66/2:SC 2/5 0079-C (online) 2018 science highlights : 2018 BDOCEBK ocn156850451 A 13.78:FPL-14 0083-B (online) Strength and related properties of white fir / 1964 BDOCEBK ocn156873777 A 13.78:FPL-15 0083-B (online) Stiffness and shrinkage of green and dry joists / 1964 BDOCEBK ocn679725875 A 13.78:FPL-16 0083-B (online) Wood structure performance in an earthquake in Anchorage, Alaska / 1964 BDOCEBK ocn903166032 A 13.78:FPL-19 0083-B (online) Heat of combustion of the volatile pyrolysis products of fire-retardant-treated ponderosa pine / 1964 BDOCEBK

I can just copy the OCLC number column and paste it into the MatchMARC Google sheet and then process. Then I would use a piece of software called Ablebits [https://www.ablebits.com/ https://www.ablebits.com/] to compare the 'holdings set='YES' OR 'NO' against the monthly list so I can assure that I know not only the OCLC number but other information that will assure I know which can be loaded immediately and those that need MARCEdit. Once sorted, I can use the list of OCLC numbers in MARC Edit to globally make changes in the specific OCLC records.

Please let me know if you have further questions or need additional information.

Thanks!

Nancy Donahoo

Manager - Serials, Continuing Resources & Government Documents Acquisitions & Collections Albertsons Library Boise State University 1910 University Drive, MS1430 Boise, Idaho 83725-1430 208.426.4038 @.***

On Fri, Oct 14, 2022 at 10:47 AM lmccoll44 @.***> wrote:

That makes sense - so you would use MARCEdit to extract that 001 field and that would be your input into the MatchMARC sheet I'm imagining, correct?

— Reply to this email directly, view it on GitHub https://github.com/suranofsky/tech-services-g-sheets-addon/issues/10#issuecomment-1279240155, or unsubscribe https://github.com/notifications/unsubscribe-auth/A3OYNVKHBAMZDSNEJEU7OKLWDGFB3ANCNFSM6AAAAAAQ63TNF4 . You are receiving this because you authored the thread.Message ID: @.***>

[ndonahoo]

That is a possibility but when I batch process holding changes in OCLC Connexxion using OCLC numbers, I don't take out the prefixed letters and the processing continues with or without. I do know Worldcat requires the prefixed letters to be present for the 856 links to show up.

Nancy Donahoo

Manager - Serials, Continuing Resources & Government Documents Acquisitions & Collections Albertsons Library Boise State University 1910 University Drive, MS1430 Boise, Idaho 83725-1430 208.426.4038 @.***

On Fri, Oct 14, 2022 at 10:57 AM lmccoll44 @.***> wrote:

@mis306lu https://github.com/mis306lu - I think this calls upon the same functionality that I've heard others would like, but I can't remember when or where: the ability to input OCLC numbers into MatchMARC and then use MatchMARC features for the returned records. In the case above and in many cases OCLC numbers are prefixed by letters - MatchMARC could require the user to input numbers only or if the code could ignore letters and only take the numbers that would be easier on the user - eliminating a find/replace step.

— Reply to this email directly, view it on GitHub https://github.com/suranofsky/tech-services-g-sheets-addon/issues/10#issuecomment-1279248590, or unsubscribe https://github.com/notifications/unsubscribe-auth/A3OYNVP55CWLK6U4WKDOEF3WDGGGNANCNFSM6AAAAAAQ63TNF4 . You are receiving this because you authored the thread.Message ID: @.***>

[lmccoll44]

Thank you for the info and the info about Ablebits, which I never heard of - so good to know about. It really helpful to understand your workflow. When you get to the step of comparing sheets:

You are comparing OCLC numbers from the MARCIVE sheet to the MatchMarc sheet, correct and therefore need your prefixes in place for that comparison, correct?

"That is a possibility but when I batch process holding changes in OCLC Connexxion using OCLC numbers, I don't take out the prefixed letters and the processing continues with or without. I do know Worldcat requires the prefixed letters to be present for the 856 links to show up."

If MatchMarc's "behind the scene" lookup eliminates the prefixes (but leaves them intact in the sheet) that would not affect the results.

[ndonahoo]

When you get to the step of comparing sheets, yes, correct -- I am comparing OCLC numbers from the MARCIVE sheet to the MatchMARC sheet. However, I don't have to have the prefixes present because Ablebits allows me to easily extract by position if needed:

[image: image.png]

If having the prefixes creates problems elsewhere in the code or necessitates a lot more coding, just know I can do without the prefixes.

Nancy Donahoo

Manager - Serials, Continuing Resources & Government Documents Acquisitions & Collections Albertsons Library Boise State University 1910 University Drive, MS1430 Boise, Idaho 83725-1430 208.426.4038 @.***

On Fri, Oct 14, 2022 at 11:17 AM lmccoll44 @.***> wrote:

Thank you for the info and the info about Ablebits, which I never heard of

• so good to know about. It really helpful to understand your workflow. When you get to the step of comparing sheets:

You are comparing OCLC numbers from the MARCIVE sheet to the MatchMarc sheet, correct and therefore need your prefixes in place for that comparison, correct?

"

That is a possibility but when I batch process holding changes in OCLC Connexxion using OCLC numbers, I don't take out the prefixed letters and the processing continues with or without. I do know Worldcat requires the prefixed letters to be present for the 856 links to show up."

If MatchMarc's "behind the scene" lookup eliminates the prefixes (but leave them intact in the sheet) that would not affect the results.

— Reply to this email directly, view it on GitHub https://github.com/suranofsky/tech-services-g-sheets-addon/issues/10#issuecomment-1279269113, or unsubscribe https://github.com/notifications/unsubscribe-auth/A3OYNVJ6DIOTGSMFLYKVZTLWDGISDANCNFSM6AAAAAAQ63TNF4 . You are receiving this because you authored the thread.Message ID: @.***>