[Wactclc-alma] EBSCO (State???) Ebook Collection

Thu Feb 23 12:38:50 PST 2023

Melinda,

The fact that there's no Interface or Collection listed in the Alma record, along with the fact that the Alma display shows an OCLC number in the "Record number" field suggests to me that these records were in your Voyager catalog before you migrated to Alma-Primo.

If you included these titles in your P2E list at migration, then Ex Libris would have brought over the bib records and created 1 portfolio record for every 856 field in the bib record, but Ex Libris did *NOT* put any P2E portfolios in any electronic collections.

In addition to figuring out what these things are, you want to get them into an electronic collection, right?

To get a list of all the electronic titles *NOT* in a collection, do an Alma Analytics report in the E-inventory subject area with the criteria:

Lifecycle - is not equal to/is not in - Deleted
Electronic Collection Public Name - is null

Here's a screenshot from the Criteria Tab of our report that we used to clean up electronic titles not in collections.
[cid:image007.png at 01D9477D.1DE96760]

Are the 15 audiobooks you bought directly from EBSCO already in an electronic collection? If not, put them in one right now. ;)

If the 15 directly-purchased audiobooks are their own electronic collection, you can probably assume that any electronic audiobooks that *aren't* in an electronic collection and that have "ebscohost.com" in the URL were part of that Washington State Library package.

Especially since the WSL project page<https://www.sos.wa.gov/library/eaudiobooks/libraries/HowToJoin.aspx> Carleigh found says that NetLibrary was one of the original vendors and I know that EBSCO bought NetLibrary.

But this is where it gets tricky.

When I pull up Demon Mistress in your Primo and "Display Source Record" to look at the MARC record, I don't see any common elements that can be easily used in an Alma Analytics search.

It *might* work to create an Alma Analytics report that looks for portfolio records with:

Electronic Material Type = Sound recording
Lifecycle = Active
Electronic collection name Is Null
URL contains ebscohost.com

In any case, I do see elements in the MARC record that you could use with Indication Rules to create a Set in Alma.

The bib record has these fields that I would expect to be present in all the audiobooks (probably):

300     ##$a1 online resource (1 sound file)

500     ##$aAudio file.

655     #7$aAudiobooks $2lcgft

So what I'm thinking is:

Step 1: Create a local electronic collection to add the portfolio records to
Step 1: Use an Indication Rule to find bib records in Alma that have "online resource" and "sound file" in the MARC 300 field.
Here I have to recommend contacting Hannah Micona at Renton, who knows more about how Indication Rules work than I do.
Step 2: Save the results as an All Titles Set in Alma
Step 3: Export the set as an Excel file
Step 4: Create an Alma Analytics report in the E-Inventory subject area that looks for:
              Portfolio lifecycle = Active
              Electronic Public Collection Name is Null
              Portfolio URL contains "ebscohost.com"
Make sure the Portfolio ID number is one of the display fields in the report.
Step 5: Add a filter for "Bibliographic Details.MMS Id" and copy the MMSID numbers from the Excel file into that filter
Step 6: Create an itemized "Electronic Portfolios" set in Alma and "Add Contents from File to Set > From Analytics" then select your Analytics report
Step 7: Follow the instructions here to add the portfolios in your set to your local electronic collection:
https://knowledge.exlibrisgroup.com/Alma/Product_Documentation/010Alma_Online_Help_(English)/Electronic_Resource_Management/030_Working_with_Local_Electronic_Resources/015Managing_Electronic_Resources#Adding_a_Set_of_Standalone_Local_Portfolios_to_a_Local_Electronic_Collection

Once that's done, you should have fewer things in your Alma Analytics report of electronic titles that aren't in any electronic collection. You can look through that list for any more audiobooks you may have missed and add them to the local electronic collection manually.

EBSCO should be able to give you a list of all the audiobook titles you have access to. Take out the 15 titles you know you bought and compare that against the titles you added to your new local electronic collection.

Does that make sense?

It will be ok!

Kirsti S. Thomas
Library Technical Services Manager & Systems Librarian
Seattle Colleges
kirsti.thomas at seattlecolleges.edu

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Martin, Melinda
Sent: Thursday, February 23, 2023 11:09
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: [Wactclc-alma] EBSCO (State???) Ebook Collection

Hi All,
This is follow-up to our conversation at today's meeting.  Here are some screenshots and what little background I have.
The first 15 or so are ones we purchased. The other 800 are of undetermined acquisition.  According to George Dragich, there was a State Purchased collection of audiobooks at one time.  From what I can tell, it was prior to 2014.

Example Screen Shots:

Shows up in EBSCO as a Database Choice
[cid:image001.png at 01D9477A.009DBCE0]

They are in Alma with an unnamed interface:
[cid:image002.png at 01D9477A.009DBCE0]

Shows up in Primo as "Audio CD" - but this is not always the case:
[cid:image003.png at 01D9477A.009DBCE0]

[cid:image004.png at 01D9477A.009DBCE0]
Melinda Martin (She/her/hers)
Collection Management and Systems Librarian
Spokane Community College

Office 509-533-8822  Front Desk 509-533-8821
Email Melinda.Martin at scc.spokane.edu<mailto:Melinda.Martin at scc.spokane.edu>
1810 N Greene Street, Spokane, WA 99217-5399
[Title: LinkedIn - Description: image of LinkedIn icon]<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Flinkedin.com%2Fin%2Fmelinda-martin-319a744&data=05%7C01%7C%7Cb02dafe6a7a24925c43808db15d1766c%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C638127761630005986%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=E3Gjqp%2FKsbQ8PjK03Oeor46e4JxiUgD6VpdAEsrQQp8%3D&reserved=0>[Title: Twitter - Description: image of Twitter icon]<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FQueriedAlive&data=05%7C01%7C%7Cb02dafe6a7a24925c43808db15d1766c%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C638127761630005986%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=yl8yHTaSceIDHuLHzaipNxxaBLyX7ivT8Xd16pM0%2FlA%3D&reserved=0>

CAUTION: This email originated outside of the Seattle Colleges' email system. Do not click links or open attachments unless you recognize the sender and know the content is safe. Questions? Contact IT Services at x6333 (Central), x3630 (North), x5844 (South) or email ITHelp at seattlecolleges.edu<mailto:ITHelp at seattlecolleges.edu>.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20230223/ed2f6378/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 126376 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20230223/ed2f6378/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 61311 bytes
Desc: image002.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20230223/ed2f6378/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 20875 bytes
Desc: image003.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20230223/ed2f6378/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 36267 bytes
Desc: image004.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20230223/ed2f6378/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 1437 bytes
Desc: image005.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20230223/ed2f6378/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 1413 bytes
Desc: image006.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20230223/ed2f6378/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 48484 bytes
Desc: image007.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20230223/ed2f6378/attachment-0006.png>