Skip to content

Instantly share code, notes, and snippets.

View sandbergja's full-sized avatar

Jane Sandberg sandbergja

18 followers · 17 following
View GitHub Profile
@sandbergja
sandbergja / hard_due_dates.txt
Last active August 29, 2015 14:08
hard_due_dates_documentation
Hard due dates
--------------
This feature allows you to specify a specific due date within your circulation policies. This is particularly useful for academic and school libraries, who may wish to make certain items due at the end of a semester or term.
NOTE: To work with hard due dates, you will need the CREATE_CIRC_DURATION, UPDATE_CIRC_DURATION, and DELETE_CIRC_DURATION permissions at the _consortium_ level.
Creating a hard due date
~~~~~~~~~~~~~~~~~~~~~~~~
Setting up hard due dates is a two-step process. You must first create a hard due date, and then populate it with specific values.
@sandbergja
sandbergja / holds_for_web_client.asc
Last active August 29, 2015 14:10
holds_web_client

Holds Management

Placing Holds

Holds can be placed by staff in the web client and by patrons in the OPAC. In this chapter we demonstrate placing holds in the web client.

Holds Levels

@sandbergja
sandbergja / gist:a2c00edff534689bab36
Created January 7, 2015 16:50
Basic eg search widget
<form action="http://libcat.linnbenton.edu/eg/opac/results" method="get" />
<input onblur="if (this.value == '') this.value = 'Find Books and More...';" onfocus="if (this.value == 'Find Books and More...') this.value = '';" value="Find Books and More..." name="query" class="catalog-search" />
<input name="locg" value="all" type="hidden" />
<input name="detail_record_view" value="1" type="hidden" />
<input name="search" type="submit" value="Search" />
</form>
@sandbergja
sandbergja / awesomizer_apis
Created March 11, 2015 21:45
APIs to use for LBCC OSC Awesomizer project
To get a book's TCN (Database ID) based on an ISBN:
http://libcat.linnbenton.edu/opac/extras/oisbn/[Example]
http://libcat.linnbenton.edu/opac/extras/oisbn/0672335956
To get information about a book (including title, author, subject, status, location, etc.):
http://libcat.linnbenton.edu/opac/extras/supercat/retrieve/atom-full/record/[[TCN]]
Example link: http://libcat.linnbenton.edu/opac/extras/supercat/retrieve/atom-full/record/293799
For more info about these "supercat" APIs: http://wiki.evergreen-ils.org/doku.php?id=backend-devel:supercat:examples
@sandbergja
sandbergja / gist:0ae971a0a6553ba0b29d
Created April 6, 2015 21:22
Test gist
The Open Source Club is currently meeting
@sandbergja
sandbergja / documentation_steps
Last active August 29, 2015 14:26
obiblio documentation project
1. Register for an account on github
2. Jane will give you access to the appropriate project
3. Go to https://github.com/sandbergja/obiblio-base/tree/master/locale/en/help and start documenting
a) the public site (http://www.sandbox.lbcc.linnlibraries.org/obiblio-base/opac/index.php, should be documented at https://github.com/sandbergja/obiblio-base/blob/master/locale/en/help/opac.php)
b) the cataloging, circulation, and admin features
@sandbergja
sandbergja / LBCC circ mod missing results
Last active August 29, 2015 14:26
no circ mod in LBCC
tcn | location | call_number | circ_modifier | barcode | title
--------+------------+--------------------------+---------------+-----------------+--------------------------------------------------------------------------
294079 | Child-Lit | PS3566.R36Z46 2008 | | 38813001098674 | {"Pizza, pigs, and poetry :"}
288613 | STACKS | PN1995.9.I48A44 2012 | | 38813001124322 | {"Making the white man's Indian :"}
289064 | STACKS | RG628.W47 2002 | | 38813001126798 | {"From conception to birth :"}
289511 | STACKS | E895.I44 2011 | | 38813001127945 | {"Liberal leviathan :"}
289063 | STACKS | HF5381.C6597 2012 | | 38813001126780 | {"Business model you :"}
289067 | STACKS | HM621.B57 2011 | | 38813001126822 | {"More :"}
289072 | STACKS | Q183.3.A1D734 2011 | | 38813001126871
@sandbergja
sandbergja / no 245 on 2015-08-05
Created August 6, 2015 03:05
no 245 on 2015-08-05
tcn | library | call_number | barcode
--------+------------------------+------------------------------------------+----------------
57120 | Carnegie Library | YR F KLEIN | IALB002042473$
57148 | Carnegie Library | PB F DUNNE | IALB0020415994
57154 | Carnegie Library | PUPPET 23 | IALB002009532
57156 | Carnegie Library | E SCHUL | IALB0020198273
57165 | Carnegie Library | *DELETED ITEM 008723 | IALB0020388937
16675 | Lebanon Public Library | 349.73 FEINM | ILEB000048110Z
57094 | Lebanon Public Library | PAM FILE GERMANY | ILEB000043820
57096 | Lebanon Public Library | PAM FILE: SPAIN #6 | ILEB0000437686
@sandbergja
sandbergja / LBCC items without LCSH
Last active November 27, 2015 18:13
LBCC items w/o LCSH
id
--------
256348
292907
255151
262003
250225
261867
46701
268202
@sandbergja
sandbergja / 490-no-830
Last active August 29, 2015 14:27
series problem (490 w/o 830)
SELECT DISTINCT b.id as tcn, ou.name as library, cn.label as call_number, c.barcode, xpath('//m:datafield[@tag="245"]/m:subfield[@code="a"]/text()', b.marc::xml, ARRAY[ARRAY['m','http://www.loc.gov/MARC21/slim']])::VARCHAR as title
FROM biblio.record_entry b
INNER JOIN asset.call_number cn ON cn.record=b.id
INNER JOIN asset.copy c ON c.call_number=cn.id
INNER JOIN actor.org_unit ou on ou.id=c.circ_lib
WHERE b.deleted=FALSE
AND b.id != -1
AND xpath_exists('//m:datafield[@tag="490" and @ind1="1"]', b.marc::xml, ARRAY[ARRAY['m','http://www.loc.gov/MARC21/slim']])
AND marc NOT LIKE '%tag="800%'
AND marc NOT LIKE '%tag="810%'