11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Wed, 20 Apr 2011 23:44:37 +0000 (19:44 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoAdd org unit settings for default status of newly added copies
dbs [Wed, 20 Apr 2011 20:14:31 +0000 (20:14 +0000)]
Add org unit settings for default status of newly added copies

These two new org unit settings enable sites to control the
default status of newly added copies. The defaults match
the behaviour of the "Add Volumes" ("In Process") and
"Fast Add" ("Available") interfaces as of Evergreen 1.6.1,
but sites can choose to have the copies go directly to
"Reshelving", "Available", or any other status defined in

The org unit settings are:

  * cat.default_copy_status_fast (for "Fast Add")
  * cat.default_copy_status_normal (for "Add Volumes")

Signed-off-by: Dan Scott <dscott@laurentian.ca>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20263 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoflesh parts in Items Out
phasefx [Wed, 20 Apr 2011 19:05:07 +0000 (19:05 +0000)]
flesh parts in Items Out

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20259 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agosend the volume along in the payload for circ functions. Render CN prefixes/suffixes...
phasefx [Wed, 20 Apr 2011 19:05:05 +0000 (19:05 +0000)]
send the volume along in the payload for circ functions.  Render CN prefixes/suffixes correctly in xul lists if they're not fleshed

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20258 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agolabel tweaks to disambiguate prefix and suffix columns in checkin interface
phasefx [Wed, 20 Apr 2011 19:05:00 +0000 (19:05 +0000)]
label tweaks to disambiguate prefix and suffix columns in checkin interface

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20257 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Wed, 20 Apr 2011 18:51:21 +0000 (14:51 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoAdd support for facet and filter negation via "-" prefix
miker [Wed, 20 Apr 2011 18:50:44 +0000 (18:50 +0000)]
Add support for facet and filter negation via "-" prefix

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20255 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoNew targets for staff client Makefile
phasefx [Wed, 20 Apr 2011 16:46:58 +0000 (16:46 +0000)]
New targets for staff client Makefile

Sets up branding/xulrunner-stub for release builds
Includes a change to windowssetup.nsi to swap out image set

Sets up branding/xulrunner-stub for beta builds
Includes a change to windowssetup.nsi to swap out image set

Shortcut for re-using the same version/stamp as the last build

Updated stamp target to add files for rebuild.

Author: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Jason Etheridge <jason@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20253 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMerge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen...
Mike Rylander [Wed, 20 Apr 2011 16:17:32 +0000 (12:17 -0400)]
Merge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Wed, 20 Apr 2011 16:17:29 +0000 (12:17 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoAlways use BinaryEncodeing => "UTF-8" with MARC::File::XML
miker [Wed, 20 Apr 2011 16:07:55 +0000 (16:07 +0000)]
Always use BinaryEncodeing => "UTF-8" with MARC::File::XML

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20250 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoPatch from Jeff Davis addressing parameter usage issues
miker [Wed, 20 Apr 2011 15:40:32 +0000 (15:40 +0000)]
Patch from Jeff Davis addressing parameter usage issues

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20244 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoformat selector gets formats from CCVM fields, starting with 'mattype', falling back...
berick [Wed, 20 Apr 2011 15:01:45 +0000 (11:01 -0400)]
format selector gets formats from CCVM fields, starting with 'mattype', falling back to item_type

11 years agoadded simple field/value filter to the RO fetch/cache code; useful for limiting...
berick [Wed, 20 Apr 2011 15:00:22 +0000 (11:00 -0400)]
added simple field/value filter to the RO fetch/cache code;  useful for limiting larger sets of config data like ccvm objects

11 years agoReorder some functions to avoid creation failure on an empty db; remove unused (and...
miker [Wed, 20 Apr 2011 14:49:12 +0000 (14:49 +0000)]
Reorder some functions to avoid creation failure on an empty db; remove unused (and installation-killing) tsvector aggregate

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20238 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMerge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen...
Mike Rylander [Wed, 20 Apr 2011 14:34:41 +0000 (10:34 -0400)]
Merge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Wed, 20 Apr 2011 14:34:39 +0000 (10:34 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agouse the more explicit get_foo instead of find_foo for pub/cache object lookup
berick [Wed, 20 Apr 2011 13:57:34 +0000 (09:57 -0400)]
use the more explicit get_foo instead of find_foo for pub/cache object lookup

11 years agoadd marc_export to list of scripts installed in /openils/bin
gmc [Wed, 20 Apr 2011 13:47:09 +0000 (13:47 +0000)]
add marc_export to list of scripts installed in /openils/bin

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20237 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoflesh parts on items for circ functions. Hrmm, but this only works because unflesh_c...
phasefx [Wed, 20 Apr 2011 08:11:30 +0000 (08:11 +0000)]
flesh parts on items for circ functions.  Hrmm, but this only works because unflesh_copy doesn't know about parts.  Do we need unflesh_copy on checkout/checkin/renew result payloads?

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20233 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoremove the infinite loop that batch volume template application was causing
phasefx [Wed, 20 Apr 2011 08:10:08 +0000 (08:10 +0000)]
remove the infinite loop that batch volume template application was causing

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20232 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agofix export templates, copy/paste-o
phasefx [Wed, 20 Apr 2011 08:10:05 +0000 (08:10 +0000)]
fix export templates, copy/paste-o

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20231 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMore hotkey fixes - Invalidate keyset cache
phasefx [Wed, 20 Apr 2011 05:03:33 +0000 (05:03 +0000)]
More hotkey fixes - Invalidate keyset cache

Thanks to http://forums.mozillazine.org/viewtopic.php?f=19&t=2048501,

Author: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Jason Etheridge <jason@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20228 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoHotkey Fixes
phasefx [Wed, 20 Apr 2011 05:03:24 +0000 (05:03 +0000)]
Hotkey Fixes

Attempt to be more robust/forceful on clearing hint text

Reset hotkeys less often (such as *not* on operator change)

Re-enable keyset properly

Author: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Jason Etheridge <jason@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20227 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoTypo: Propeties/Properties
dbs [Tue, 19 Apr 2011 21:03:30 +0000 (21:03 +0000)]
Typo: Propeties/Properties

Should have merged this with the source file fix. Ah well.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20224 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoTypo: Propeties/Properties
dbs [Tue, 19 Apr 2011 21:02:34 +0000 (21:02 +0000)]
Typo: Propeties/Properties

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20223 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoUse top level join instead of subquery in hold queue position query
miker [Tue, 19 Apr 2011 19:56:04 +0000 (19:56 +0000)]
Use top level join instead of subquery in hold queue position query

This is more readily optimized by the Postgres planer.

Note also, for very large data sets (lots of holds, on the order of 100k+ active), the following is also advised:

 ALTER TABLE action.hold_copy_map alter column target_copy SET statistics 500, alter column hold set statistics 500;
 ANALYZE action.hold_copy_map;

This gives the planner better data about the hold-copy-map n-distinct.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20221 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoFix dump-style printing by ensuring 'params' is defined before accessing it
dbwells [Tue, 19 Apr 2011 17:55:47 +0000 (17:55 +0000)]
Fix dump-style printing by ensuring 'params' is defined before accessing it

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20216 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Tue, 19 Apr 2011 17:36:40 +0000 (13:36 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoStore the cache hash file in LOCALSTATEDIR/web/ so it can be used from within apache...
miker [Tue, 19 Apr 2011 16:36:14 +0000 (16:36 +0000)]
Store the cache hash file in LOCALSTATEDIR/web/ so it can be used from within apache via SSI

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20215 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoAdd a wrapper for autogen.sh which generates a date+content hash for use in (browser...
miker [Tue, 19 Apr 2011 16:15:01 +0000 (16:15 +0000)]
Add a wrapper for autogen.sh which generates a date+content hash for use in (browser) cache killing

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20213 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agomark these as binary
phasefx [Tue, 19 Apr 2011 16:01:21 +0000 (16:01 +0000)]
mark these as binary

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20211 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agolock in upgrade script version #, tweak org setting labels and descriptions
phasefx [Tue, 19 Apr 2011 15:52:54 +0000 (15:52 +0000)]
lock in upgrade script version #, tweak org setting labels and descriptions

Signed-off-by: Jason Etheridge <jason@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20208 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMenu Hotkeys and Toolbars
phasefx [Tue, 19 Apr 2011 15:52:49 +0000 (15:52 +0000)]
Menu Hotkeys and Toolbars

Dynamic Hotkey sets

New cataloging toolbar

New updates to circ toolbar

New menu items and updates to menus in admin menu area

Toolbar/hotkey settings can be saved to workstation prefs from admin -> workstation administration

Update org unit setting for button_bar to be a string, circ or cat by default to pick those two toolbars

Author: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Jason Etheridge <jason@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20207 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoPrint the path to files written by autogen in support of a cache-killing hash
miker [Tue, 19 Apr 2011 15:29:14 +0000 (15:29 +0000)]
Print the path to files written by autogen in support of a cache-killing hash

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20205 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agomark these as binary
phasefx [Tue, 19 Apr 2011 14:53:50 +0000 (14:53 +0000)]
mark these as binary

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20203 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agomark these as binary
phasefx [Tue, 19 Apr 2011 14:47:43 +0000 (14:47 +0000)]
mark these as binary

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20201 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMore Installer Fun
phasefx [Tue, 19 Apr 2011 14:37:24 +0000 (14:37 +0000)]
More Installer Fun

Define an Install Tag, defaulting to the product tag.
This will be used in the install location and registry setting for where we installed to.

Different install tags will mean different installs, so Trunk won't (by default) install over 2.1 (for example)

Plus, include riggings for Mike Peter's new install images.

Author: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Jason Etheridge <jason@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20199 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoUpdate for corrected cmc.name -> cmc.label marking in seed data
dbs [Tue, 19 Apr 2011 02:57:23 +0000 (02:57 +0000)]
Update for corrected cmc.name -> cmc.label marking in seed data

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20195 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMark cmc.label for translation, not cmc.name, in seed data
dbs [Tue, 19 Apr 2011 02:52:48 +0000 (02:52 +0000)]
Mark cmc.label for translation, not cmc.name, in seed data

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20192 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMark cmf and cmc labels as translatable
dbs [Tue, 19 Apr 2011 02:19:53 +0000 (02:19 +0000)]
Mark cmf and cmc labels as translatable

We went to the effort of extracting the translatable text from
950.data.seed-values.sql, but had not marked the fields as
translatable in the IDL. Now at least the out-of-the-box
fields and classes will easily be able to have translations.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20189 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoCheck in the POT files so that translation interface can be satisfied
dbs [Tue, 19 Apr 2011 02:14:04 +0000 (02:14 +0000)]
Check in the POT files so that translation interface can be satisfied

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20188 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoAdd openils.widget.Searcher Dojo NLS to the i18n build
dbs [Tue, 19 Apr 2011 01:48:43 +0000 (01:48 +0000)]
Add openils.widget.Searcher Dojo NLS to the i18n build

Necessary for the "advanced" searchbar on the Evergreen

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20185 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoCorrect encoding issue with authority_control_fields.pl
dbs [Tue, 19 Apr 2011 01:03:58 +0000 (01:03 +0000)]
Correct encoding issue with authority_control_fields.pl

Is there ever a time when MARC::File::XML would be invoked with
anything other than BinaryEncoding => 'utf-8'? Not here, at
least. Addresses LP# 764582.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20182 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Mon, 18 Apr 2011 20:02:07 +0000 (16:02 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoImprovements to search tuning
miker [Mon, 18 Apr 2011 19:57:01 +0000 (19:57 +0000)]
Improvements to search tuning

 * Move to in-core fts function, instead of the compat wrapper provided by the tsearch2 contrib
 * Provide default cover density tuning (config file)
 * Move default preferred language settings from storage to search, where they make more sense

More on the CD tuning:

  Evergreen uses a cover density algorithm for calculating relative ranking of matches.  There
  are several tuning parameters and options available.  By default, no document length normalization
  is applied.  From the Postgres documentation on ts_rank_cd() (the function used by Evergreen):

      Since a longer document has a greater chance of containing a query term it is reasonable
      to take into account document size, e.g., a hundred-word document with five instances of
      a search word is probably more relevant than a thousand-word document with five instances.
      Both ranking functions take an integer normalization option that specifies whether and how
      a document's length should impact its rank. The integer option controls several behaviors,
      so it is a bit mask: you can specify one or more behaviors using | (for example, 2|4).

          0 (the default) ignores the document length

          1 divides the rank by 1 + the logarithm of the document length

          2 divides the rank by the document length

          4 divides the rank by the mean harmonic distance between extents (this is implemented only by ts_rank_cd)

          8 divides the rank by the number of unique words in document

          16 divides the rank by 1 + the logarithm of the number of unique words in document

          32 divides the rank by itself + 1

      If more than one flag bit is specified, the transformations are applied in the order listed.

      It is important to note that the ranking functions do not use any global information, so it
      is impossible to produce a fair normalization to 1% or 100% as sometimes desired. Normalization
      option 32 (rank/(rank+1)) can be applied to scale all ranks into the range zero to one, but of
      course this is just a cosmetic change; it will not affect the ordering of the search results.

  In Evergreen, these options are set via search modifiers.  The modifiers are mapped in the
  following way:

      * #CD_logDocumentLength  => 1  :: rank / (1 + LOG(total_word_count))   :: Longer documents slightly less relevant
      * #CD_documentLength     => 2  :: rank / total_word_count              :: Longer documents much less relevant
      * #CD_meanHarmonic       => 4  :: Word Proximity                       :: Greater matched-word distance is less relevant
      * #CD_uniqueWords        => 8  :: rank / unique_word_count             :: Documents with repeated words much less relevant
      * #CD_logUniqueWords     => 16 :: rank / (1 + LOG(unique_word_count))  :: Documents with repeated words slightly less relevant
      * #CD_selfPlusOne        => 32 :: rank / (1 + rank)                    :: Cosmetic normalization of rank value between 0 and 1

  Adding one or more of these to the default_CD_modifiers list will cause all searches that use QueryParser to apply them.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20180 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoone more fix, for Show in Catalog on issuance holds
phasefx [Mon, 18 Apr 2011 19:45:27 +0000 (19:45 +0000)]
one more fix, for Show in Catalog on issuance holds

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20178 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agodisplay issuance label, not subscription label
phasefx [Mon, 18 Apr 2011 19:35:16 +0000 (19:35 +0000)]
display issuance label, not subscription label

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20176 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoadd Part Holds to Actions for this Record -> View Holds. Also add xul support for...
phasefx [Mon, 18 Apr 2011 18:40:30 +0000 (18:40 +0000)]
add Part Holds to Actions for this Record -> View Holds.  Also add xul support for displaying issuance holds (needs testing)

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20174 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agosupport Part Holds in xul lists
phasefx [Mon, 18 Apr 2011 18:03:41 +0000 (18:03 +0000)]
support Part Holds in xul lists

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20171 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agono need to flesh the record here
phasefx [Mon, 18 Apr 2011 18:03:38 +0000 (18:03 +0000)]
no need to flesh the record here

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20170 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agotypo
phasefx [Mon, 18 Apr 2011 17:30:11 +0000 (17:30 +0000)]

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20168 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Mon, 18 Apr 2011 15:42:46 +0000 (11:42 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoimprove comments on a couple config tables
gmc [Mon, 18 Apr 2011 15:41:20 +0000 (15:41 +0000)]
improve comments on a couple config tables

Based on suggestions from Mike Rylander and Thomas Berezansky.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20162 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoscript to update DB object comments
gmc [Mon, 18 Apr 2011 15:41:18 +0000 (15:41 +0000)]
script to update DB object comments

New script, update-db-comments.sh, to be run as part of upgrades
to refresh comments on database schema objects.  Usage is:

  update-db-comments.sh db-host db-port db-name db-user db-pass

The helper script grab-db-comment.pl is what actually parses out
the comment statements.

To avoid repetition, the list of default SQL scripts to use when
initializing an Evergreen database has been moved to a new file
called sql_file_manifest.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20161 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agominor improvements to database object comments
gmc [Mon, 18 Apr 2011 15:41:16 +0000 (15:41 +0000)]
minor improvements to database object comments

* remove copyright, license verbiage, and C-style comment marking
  from the comments; these can live in the SQL scripts
* updated several copyright headers
* minor improvements to documentation of a couple tables

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20160 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agofixes Edit Volumes action by flattening the volume objects before updating them
phasefx [Mon, 18 Apr 2011 15:37:12 +0000 (15:37 +0000)]
fixes Edit Volumes action by flattening the volume objects before updating them

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20158 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Mon, 18 Apr 2011 15:30:53 +0000 (11:30 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoin the MARC Editor, put the callnumber and barcode textboxes for Fast Item Add on...
phasefx [Mon, 18 Apr 2011 05:27:15 +0000 (05:27 +0000)]
in the MARC Editor, put the callnumber and barcode textboxes for Fast Item Add on a separate row

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20151 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoEnable relative paths in i18n testing scripts
dbs [Mon, 18 Apr 2011 05:14:41 +0000 (05:14 +0000)]
Enable relative paths in i18n testing scripts

We were 98% of the way there; now we no longer need to
cd into the same directory as the i18n testing scripts
to run them with meaningful output. Should be useful
for adding these to the CI server.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20148 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoDon't check .js files for entities
dbs [Mon, 18 Apr 2011 04:38:46 +0000 (04:38 +0000)]
Don't check .js files for entities

Must have asked this script to check JS files for valid entities
for a reason at some point in the dark past, but it couldn't have
been a very good reason; we're getting a false positive that needs
to be hushed now. Better to just stop looking for XML entities in

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20145 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoEmpty strings in oils_i18n_gettext() throw i18n errors
dbs [Mon, 18 Apr 2011 03:32:04 +0000 (03:32 +0000)]
Empty strings in oils_i18n_gettext() throw i18n errors

When you run 'make newpot', if you have an empty string in an
oils_i18n_gettext() function, you'll see errors like:

Error in line 1712 of SQL source file: 'NoneType' object has no attribute 'group'

This satisfies the i18n build process and also serves as a
more evident placeholder for expanded descriptions if someone
feels so inclined in the future.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20139 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoAdd new macros for print templates.
phasefx [Sun, 17 Apr 2011 19:25:38 +0000 (19:25 +0000)]
Add new macros for print templates.

Trims whitespace before the macro

Trims whitespace after the macro

Take substring starting at position # to end of string.
If # is negative count backwards from end of string.

Same as previous, but limit to second provided number characters after start point.
If second number is negative, count backwards instead of forwards.

TRIM macros inside of SUBSTR will be replaced first, then SUBSTR, then TRIM outside of SUBSTR.

Author: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Jason Etheridge <jason@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20137 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMerge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen...
Mike Rylander [Sun, 17 Apr 2011 13:13:02 +0000 (09:13 -0400)]
Merge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Sun, 17 Apr 2011 13:13:00 +0000 (09:13 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agofix Add Items off of volumes by changing the label key in copy_shortcut to callnumber...
phasefx [Sat, 16 Apr 2011 21:35:46 +0000 (21:35 +0000)]
fix Add Items off of volumes by changing the label key in copy_shortcut to callnumber composite key

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20136 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agotrace statements. need to change how copy_shortcut is constructed in parent interfaces
phasefx [Sat, 16 Apr 2011 21:35:44 +0000 (21:35 +0000)]
trace statements.  need to change how copy_shortcut is constructed in parent interfaces

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20135 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agotrace statements
phasefx [Sat, 16 Apr 2011 21:35:42 +0000 (21:35 +0000)]
trace statements

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20134 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agotrace statements
phasefx [Sat, 16 Apr 2011 21:35:40 +0000 (21:35 +0000)]
trace statements

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20133 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agocomment tweak
phasefx [Sat, 16 Apr 2011 21:35:38 +0000 (21:35 +0000)]
comment tweak

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20132 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoAllow NULL "use restriction" fields for located URIs
dbs [Sat, 16 Apr 2011 03:26:11 +0000 (03:26 +0000)]
Allow NULL "use restriction" fields for located URIs

The asset.uri.use_restriction field, which is really a sort of public notes
field for 856 fields, was grabbing the $u subfield (URL) as a sort of last-gasp
effort to give it some data. However, the effect was rather odd and led to
workarounds like Conifer's skin to avoid displaying the use restriction field
if its value was identical to the URL, etc.

Instead, stop grabbing $u and handle the case where use_restriction column is
NULL gracefully, just like the schema intended.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20123 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoDo not clear auri links in default skin
dbs [Sat, 16 Apr 2011 03:18:53 +0000 (03:18 +0000)]
Do not clear auri links in default skin

The dojo orphan() call which attempted to wipe any non-located 856s
was actually wiping the located 856s in the record detail display.

Removing the extra call makes this work in Firefox and Chromium,
at least.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20120 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoDelete ##URI## call numbers and uri_call_number_map entries on bib reingest
dbs [Sat, 16 Apr 2011 02:16:05 +0000 (02:16 +0000)]
Delete ##URI## call numbers and uri_call_number_map entries on bib reingest

This approach will lead to some acn/auricnm ID inflation, but it works.

Addresses LP# 761130 (immortal ##URI## entries in asset.call_number) reported
by Ben Shum and LP# 761085 (cannot delete bib with ##URI## volumes) reported
by Jason Etheridge.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20117 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoprune unused script; purpose now served by eg_db_config.pl
gmc [Fri, 15 Apr 2011 20:50:59 +0000 (20:50 +0000)]
prune unused script; purpose now served by eg_db_config.pl

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20115 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoProtect dumb JavaScript engines from having to deal with actual Unicode
dbs [Fri, 15 Apr 2011 20:13:46 +0000 (20:13 +0000)]
Protect dumb JavaScript engines from having to deal with actual Unicode

The holdings_xml format did not include an XML declaration, but adding that
as we do here still does not make the Firefox and Chromium JS engines capable
of consuming XML that contains Unicode content outside of the base ASCII

So, we invoke entityize() to convert anything outside of the realm of
ASCII to XML entities. An alternative would be to invoke entityize() in
OpenILS::Application::SuperCat::unAPI::acn but it's not clear if that
would interfere with any other uses.

With this change, library names / copy location names with Unicode content
can be displayed correctly on the search results page.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20112 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agomove utils.tt2 to printnav.tt2 just to give it a more explicit name; i18n and cleanup
berick [Fri, 15 Apr 2011 20:12:08 +0000 (16:12 -0400)]
move utils.tt2 to printnav.tt2 just to give it a more explicit name; i18n and cleanup

11 years agouse org unit shortname for site param; capture site/depth in search builder to pass...
berick [Fri, 15 Apr 2011 20:11:40 +0000 (16:11 -0400)]
use org unit shortname for site param; capture site/depth in search builder to pass on to unapi retrieval, though there's still some template work to do w/ displaying the correct data there (for copy counts)

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Fri, 15 Apr 2011 16:32:41 +0000 (12:32 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoMORE: Properly support extracting MARC21 fixed fields from the leader, not just the...
miker [Fri, 15 Apr 2011 16:27:46 +0000 (16:27 +0000)]
MORE: Properly support extracting MARC21 fixed fields from the leader, not just the 00x controlfields, in the "all fixed fields" version

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20107 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Fri, 15 Apr 2011 16:26:38 +0000 (12:26 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Fri, 15 Apr 2011 16:14:04 +0000 (12:14 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoProperly support extracting MARC21 fixed fields from the leader, not just the 00x...
miker [Fri, 15 Apr 2011 16:13:32 +0000 (16:13 +0000)]
Properly support extracting MARC21 fixed fields from the leader, not just the 00x controlfields

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20104 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agothinko in for-in-array loop, uncovered by error testing from Ben Shum
miker [Fri, 15 Apr 2011 15:38:13 +0000 (15:38 +0000)]
thinko in for-in-array loop, uncovered by error testing from Ben Shum

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20101 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Fri, 15 Apr 2011 15:09:32 +0000 (11:09 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoSupport mulitiple subfield-9 values in a single 856 tag
miker [Fri, 15 Apr 2011 14:49:34 +0000 (14:49 +0000)]
Support mulitiple subfield-9 values in a single 856 tag

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20100 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoProtect pcrud-ish retrieve from an empty result set
miker [Fri, 15 Apr 2011 13:55:20 +0000 (13:55 +0000)]
Protect pcrud-ish retrieve from an empty result set

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20094 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMerge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen...
Mike Rylander [Fri, 15 Apr 2011 13:21:42 +0000 (09:21 -0400)]
Merge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Fri, 15 Apr 2011 13:21:40 +0000 (09:21 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoRestore URIs in marcxml-uris unAPI format
dbs [Thu, 14 Apr 2011 21:09:32 +0000 (21:09 +0000)]
Restore URIs in marcxml-uris unAPI format

At some point (r16750) we started doing a numeric comparison of
$flesh instead of just checking to see if $flesh was defined; this
returned false when $flesh == 'uris', preventing URIs from being
included in the marcxml-uris unAPI format.

This restores URIs to marcxml-uris and so we can revert the extra
BibTemplate call in rdetail_summary.xml.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20091 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoSpecify the holdings_xml unAPI format for URI calls
dbs [Thu, 14 Apr 2011 20:38:04 +0000 (20:38 +0000)]
Specify the holdings_xml unAPI format for URI calls

The unAPI marcxml-uris format is not returning URIs at the moment.
While we're getting that fixed, use the holdings_xml format to
get the URI job done; requires an extra JS call, but that's
better than not working at all.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20088 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agofetch bookbags inside xact to avoid replication delays, which can occur directly...
berick [Thu, 14 Apr 2011 19:04:23 +0000 (15:04 -0400)]
fetch bookbags inside xact to avoid replication delays, which can occur directly after bookbag-update actions

11 years agoEscape rather than filter SIMILAR TO metacharacters in patron crazy search
dbs [Thu, 14 Apr 2011 18:18:37 +0000 (18:18 +0000)]
Escape rather than filter SIMILAR TO metacharacters in patron crazy search

The filtering I introduced in r19983 was overly aggressive, and included
characters that weren't actually SIMILAR TO metacharacters. Instead, escape
each character, carefully going through the list of metacharacters listed at

Works for email addresses like "foo.bar+baz@example.com".

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20085 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoAddress LP #754880, where printing happens before the progress dialog can be
senator [Thu, 14 Apr 2011 17:57:32 +0000 (17:57 +0000)]
Address LP #754880, where printing happens before the progress dialog can be
cleared in the alternate holds pull list print interface

Additionally, provide the usual "print page" button so that the list can be
reprinted at will

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20082 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoupgrade script for consistency w/ schema change in r20073
erickson [Thu, 14 Apr 2011 16:50:20 +0000 (16:50 +0000)]
upgrade script for consistency w/ schema change in r20073

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20079 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agotweaks to quick_metarecord_map.sql
gmc [Thu, 14 Apr 2011 15:48:55 +0000 (15:48 +0000)]
tweaks to quick_metarecord_map.sql

* used version from wiki, which provides same results as the
  previous version but performs better on large databases
* now works without editing (a vacuum cannot run inside of a transaction)
* don't do vacuum full, just a regular vacuum analyze

[1] http://evergreen-ils.org/dokuwiki/doku.php?id=scratchpad:random_magic_spells#how_to_generate_metarecords_for_a_newly_loaded_bib_batch

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20075 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agorely on search_path to locate the extract_marc_field() function which is now installe...
erickson [Thu, 14 Apr 2011 14:23:30 +0000 (14:23 +0000)]
rely on search_path to locate the extract_marc_field() function which is now installed in the 'evergreen' schema by default

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20073 dcc99617-32d9-48b4-a31d-7c20da2025e4

11 years agoMerge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen...
berick [Wed, 13 Apr 2011 18:26:01 +0000 (14:26 -0400)]
Merge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agouse unapi for record retrieval on details page; includes svf attrs for matttype,...
berick [Wed, 13 Apr 2011 18:25:58 +0000 (14:25 -0400)]
use unapi for record retrieval on details page; includes svf attrs for matttype, etc.; some i18n cleanup

11 years agoMerge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen...
Mike Rylander [Wed, 13 Apr 2011 18:14:34 +0000 (14:14 -0400)]
Merge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc

11 years agoMerge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equin...
Mike Rylander [Wed, 13 Apr 2011 18:14:31 +0000 (14:14 -0400)]
Merge branch 'master' of git+ssh://yeti.esilibrary.com/home/evergreen/evergreen-equinox into opac-tt-poc