Linking databases from your library's website

Linking databases from your library's website oplin Fri, 03/14/2008 - 10:12

OPLIN can provide remote access to nearly any subscription database a library purchases; contact the OPLIN Support Center for more information.

**Links for the statewide databases licensed as part of the Ohio Web Library**
Database name	Correct URL
All EBSCOhost Databases	https://ohioweblibrary.org/db/ebsco-all
Academic Search Premier	https://ohioweblibrary.org/db/academic
Alt HealthWatch	https://ohioweblibrary.org/db/healthwatch
Biography Reference Bank	https://ohioweblibrary.org/db/ebsco-bios
Business Source Premier	https://ohioweblibrary.org/db/business
Computer Source	https://ohioweblibrary.org/db/computer
Consumer Health Complete	https://ohioweblibrary.org/db/consumerhealth
ERIC	https://ohioweblibrary.org/db/ebsco-eric
Explora for Educators	https://ohioweblibrary.org/db/ebsco-explora-ed
Explora Primary School	http://ohioweblibrary.org/db/ebsco-explora-primary
Explora Public Libraries	https://ohioweblibrary.org/db/ebsco-explora
Explora Secondary School	http://ohioweblibrary.org/db/ebsco-explora-secondary
Health Source: Consumer Edition	https://ohioweblibrary.org/db/healthsource
Health Source: Nursing/Academic Edition	https://ohioweblibrary.org/db/nursing
Hobbies & Crafts Reference Center	https://ohioweblibrary.org/db/hobbies
Home Improvement Reference Center	https://ohioweblibrary.org/db/homeimprovement
Literary Reference Center	https://ohioweblibrary.org/db/literary
MAS Ultra - School Edition	https://ohioweblibrary.org/db/mas
MASTERFILE Premier	https://ohioweblibrary.org/db/masterfile
MEDLINE	https://ohioweblibrary.org/db/medline
Middle Search Plus	https://ohioweblibrary.org/db/middle
Newspaper Source	https://ohioweblibrary.org/db/newspaper
Points of View Reference Center	https://ohioweblibrary.org/db/pov
Professional Development Collection	https://ohioweblibrary.org/db/professional
Psychology and Behavioral Sciences Collection	https://ohioweblibrary.org/db/psychology
Religion and Philosophy Collection	https://ohioweblibrary.org/db/religion
Science Reference Center	https://ohioweblibrary.org/db/ebsco-science
Small Business Reference Center	https://ohioweblibrary.org/db/ebsco-smallbusiness
Vocational and Career Collection	https://ohioweblibrary.org/db/vocational

African American Heritage	https://ohioweblibrary.org/db/africanamericanheritage
American & English Literature	https://ohioweblibrary.org/db/literature
Ancestry Library Edition	https://ohioweblibrary.org/db/ancestry
Chilton Library	https://ohioweblibrary.org/db/chilton
Fold3 Library Edition	https://ohioweblibrary.org/db/fold3
Gale In Context: Elementary (formerly Kids InfoBits)	https://ohioweblibrary.org/db/kidsinfobits
Heritage Quest	https://ohioweblibrary.org/db/heritagequest
LinkedIn Learning	https://ohioweblibrary.org/db/linkedinlearning
Oxford Research Encyclopedias	https://ohioweblibrary.org/db/oxfordre
Sanborn Fire Insurance Maps	https://ohioweblibrary.org/db/sanborn
Transparent Languages	https://ohioweblibrary.org/db/transparent
Very Short Introductions	https://ohioweblibrary.org/db/veryshort
World Book	https://ohioweblibrary.org/db/worldbook
World Book Advanced	https://ohioweblibrary.org/db/worldbook-advanced
World Book Early World of Learning	https://ohioweblibrary.org/db/worldbook-early
World Book French	http://ohioweblibrary.org/db/worldbook-french
World Book Kids	https://ohioweblibrary.org/db/worldbook-kids
World Book Spanish (Banco de Contenidos aulaPlaneta)	https://ohioweblibrary.org/db/worldbook-his
World Book Student	http://ohioweblibrary.org/db/worldbook-student
World Book Student-Spanish (Enciclopedia Estudiantil Hallzazgos)	https://www.ohioweblibrary.org/db/worldbook-spa
World Book Timelines	http://ohioweblibrary.org/db/worldbook-timelines

**General resources provided by OPLIN**
Website name	Correct URL
Find an Ohio Public Library tool	https://www.oplin.org/fal
Ohio Web Library	https://www.ohioweblibrary.org
What Tree Is It?	https://www.oplin.org/tree
What's That Snake?	https://www.oplin.org/snake
What's the Point?	https://www.oplin.org/point

Get MARC records for your catalog

Get MARC records for your catalog oplin Wed, 03/05/2008 - 13:05

Some of the Ohio Web Library vendors provide MARC records that can be loaded into a library's catalog, so their online resources will appear in catalog search results. These MARC records will contain a link to the resource in the 856 field of the record (subfield u); however, for people outside the library, these links will not allow access to the resource, because they do not pass through the user authentication associated with our statewide subscriptions.

To fix this, the URLs in the 856 fields must be modified in two ways:

Add this to the beginning of each link:
https://auth.oplin.org/?url=
Replace every "&" in every link with "%26" (percent-encoded ampersand)

For example, a link to Consumer Reports in the MARC record downloaded from EBSCO might have "https://search.ebscohost.com/direct.asp?db=f5h&jid=%22CRP%22&scope=site" in the 856u tag, and that would need to be changed to "https://auth.oplin.org/?url=https://search.ebscohost.com/direct.asp?db=f5h%26jid=%22CRP%22%26scope=site".

One easy way to make these modifications is to use Terry Reese's MarcEdit tool (free download). Open the MarcEditor, open the file of MARC records downloaded from the vendor, and from the "Tools" menu choose "Edit Subfield Data." In field 856, subfield u, look for field data https:// and replace it with https://auth.oplin.org/?url=https://. Repeat this process, looking for & and replacing it with %26. Save the edited file and it should be ready for importing into your catalog.

The vendors below currently provide MARC records for Ohio Web Library databases:

EBSCO: A large selection of MARC record files can be downloaded from the EBSCO Administrator interface. (If you don't know your login credentials, contact OPLIN Support.) Navigate to "Database Title Lists" and click on the "MARC 21" tab.
World Book: World Book provides some very general MARC records from their Training & Support site.
LinkedIn Learning: LinkedIn Learning MARC records require access to the LinkedIn Learning administrator interface. Contact OPLIN Support for assistance.