Ben Ostrowsky [Mon, 8 Nov 2010 16:51:27 +0000]
A tool for generating Apache vhost configs from a table modeled after actor.org_unit_setting.
USAGE: ./opac_settings.pl --bootstrap /openils/conf/opensrf_core.xml --schema m_sage
Input will look like this:
evergreen=# select * from m_sage.opac_settings where org_unit = 107;
id | org_unit | name | value
-----+----------+-------------------+-----------------------------------
36 | 107 | opac.server_name | "conhs.sage.eou.edu"
93 | 107 | opac.server_alias | "www.conhs.sage.eou.edu"
147 | 107 | opac.directory | "condonhs"
251 | 107 | opac.ssl_cert | "ssl/wildcard.sage.eou.edu.crt"
301 | 107 | opac.ssl_key | "ssl/wildcard.sage.eou.edu.key"
Multiple libraries may share an 'opac.directory' (branches of a system with the same OPAC look and feel).
Multiple 'opac.server_alias' rows may be defined.
Ben Ostrowsky [Fri, 22 Oct 2010 16:28:37 +0000]
migration_tools.stage_not_applicable_asset_stat_cats
Ben Ostrowsky [Sun, 19 Sep 2010 01:11:42 +0000]
Better output-file renaming
Ben Ostrowsky [Fri, 10 Sep 2010 17:48:17 +0000]
Generates a TSV with egid and MARCXML snippets to preserve for post-deduping reinsertion (insert_tags).
Ben Ostrowsky [Fri, 10 Sep 2010 14:56:56 +0000]
Added feedback to remind the user where to find the results (since it doesn't go to STDOUT).
Ben Ostrowsky [Wed, 8 Sep 2010 16:07:48 +0000]
New function: apply_circ_matrix('m_foo.action_circulation').
Sets duration, fine, and max_fine names and values, and renewal_remaining,
based on a circ matrix (and patron profiles, and circ modifiers) already in place.
Ben Ostrowsky [Fri, 20 Aug 2010 16:27:50 +0000]
More precise deduping for insert_tags
Ben Ostrowsky [Fri, 20 Aug 2010 16:25:32 +0000]
Added function: insert_tags (marc, '<datafield tag="999" ... </datafield>')
Inserts into the proper numerical order, ignoring fields that are duplicates of each other.
Ben Ostrowsky [Thu, 10 Jun 2010 19:47:35 +0000]
attempt_phone can take '' as second argument to refrain from adding an area code; added is_blank(TEXT) for convenience
Ben Ostrowsky [Thu, 3 Jun 2010 15:44:09 +0000]
New function: migration_tools.is_staff_profile(actor.usr.profile), returns boolean
Ben Ostrowsky [Thu, 27 May 2010 15:15:24 +0000]
Built-in manual gave wrong command-line arguments. Fixed.
Ben Ostrowsky [Thu, 6 May 2010 16:29:04 +0000]
Added two MARC-manipulating functions from Galen
Ben Ostrowsky [Fri, 20 May 2011 19:52:18 +0000]
Eliminating one line of Perl 5.10 dependency
Ben Ostrowsky [Fri, 20 May 2011 16:16:41 +0000]
Fixed typo
Ben Ostrowsky [Fri, 20 May 2011 16:13:09 +0000]
Rewrote some regular expressions to make them compatible with Perl versions before 5.10
Ben Ostrowsky [Fri, 13 May 2011 15:54:46 +0000]
To be run immediately after normal EG installation
Galen Charlton [Fri, 17 Jun 2011 03:10:16 +0000]
add license statement
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Galen Charlton [Fri, 17 Jun 2011 03:06:00 +0000]
SCLENDS bibliographic dedupe routine
This implements a bibliographic deduplication routine based
on criteria and an algorithm specified by the South Carolina
State Library on behalf of the SC LENDS consortium. This work
was sponsored by SC LENDS, whose impetus is gratefully
acknowledged. Portions of this script were subseqently expanded
based on the advice of the Indiana State Library on the behalf
of the Evergreen Indiana project.
This is meant to run in an Evergreen database. Usage would
be something like:
psql -U evergreen < sclends_dedupe.sql
However, in practice it is highly recommend to edit the script
first; any bibliographic deduplication requires close attention
to the particular data found in the Evergreen database.
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Ben Ostrowsky [Wed, 11 May 2011 17:07:35 +0000]
Two new utilities that, together, can generate a zips.txt file customized for your patron database.
Galen Charlton [Thu, 6 May 2010 18:12:35 +0000]
update test case
Thanks to Sue Hopkins for the catch.
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Ben Ostrowsky [Thu, 22 Apr 2010 17:29:59 +0000]
Added note about non-ESI tools' licensing
Signed-off-by: Equinox Git Owner <koha@yeti.esilibrary.com>
Galen Charlton [Thu, 22 Apr 2010 04:53:33 +0000]
added COPYING, LICENSE, and README for release
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Galen Charlton [Tue, 13 Apr 2010 19:23:51 +0000]
skip over records that cannot be parsed
Galen Charlton [Tue, 13 Apr 2010 19:22:01 +0000]
revert previous commit (swept too much in)
Galen Charlton [Tue, 13 Apr 2010 19:18:52 +0000]
recover gracefully after an XML parsing error
Galen Charlton [Tue, 13 Apr 2010 00:19:06 +0000]
NAME
xlsx2tab
SUMMARY
Quick-and-dirty filter lifted from the Spreadsheet::XSLX POD to convert the first sheet of an Excel .xlsx file to TSV
USAGE
xlsx2tab foo.xlsx > foo.tsv
Ben Ostrowsky [Mon, 12 Apr 2010 22:08:34 +0000]
Will leave 'unlisted' alone
Ben Ostrowsky [Mon, 12 Apr 2010 22:06:41 +0000]
Handling a few more exceptions...
Ben Ostrowsky [Mon, 12 Apr 2010 21:54:27 +0000]
Added logic to attempt_phone for handling a few more variants correctly
Ben Ostrowsky [Mon, 12 Apr 2010 21:47:43 +0000]
Added function attempt_phone (TEXT,TEXT) RETURNS TEXT. First argument is legacy phone data, second is area code to prepend.
Ben Ostrowsky [Tue, 6 Apr 2010 14:55:30 +0000]
debugged a comment ;)
Ben Ostrowsky [Tue, 6 Apr 2010 14:50:54 +0000]
Renamed utility, added --help and perldoc documentation
Ben Ostrowsky [Tue, 6 Apr 2010 14:31:16 +0000]
Moving DBF-to-TSV utility (not Athena-specific)
Ben Ostrowsky [Tue, 6 Apr 2010 14:23:16 +0000]
First version of a utility to convert Athena DBF to TSV suitable for \copy.
Suitable includes escaping backslash, tab, newline, and carriage return,
and converting output to UTF-8.
Galen Charlton [Wed, 17 Mar 2010 19:20:33 +0000]
normalize output by escaping backslashes
This allows psql to import the data correctly; use
the new --disable-pg-normalization option to disable
this behavior if the output is not meant to go
directly into a Pg database via copy or \copy
Galen Charlton [Mon, 15 Mar 2010 16:34:57 +0000]
fix retrieval of correct column headers and data from non-holdings tags
This work was sponsored by the Indiana State Library.
Galen Charlton [Fri, 12 Mar 2010 20:32:45 +0000]
improved handling for drawing data from fields other than the holdings tag
Suppose the 852 is the main holdings tag, but information is needed
from the 590$a (e.g., as an item note). The extract_holdings configuration file
can now work as follows:
# to map the subfield contents to the item record
barcode 852 p
note 590 a
# to map, but have the 590$a information be associated
# only with the first item in the bib; if m:first is
# not supplied, the 590$a note will be supplied
# to all items associated with the bib
barcode 852 p
note 590 a m:first
# to put all occurrences of the 590$a into a separate
# file for linking with the appropriate items. m:multi
# *must* be supplied if the 590 tag occurs more than once
# in the bib records
barcode 852 p
note 590 a m:multi
# to concatenate repeats of $a in the 590 together
barcode 852 p
note 590 a m:concatenate
# to concatenate with a custom separator
barcode 852 p
note 590 a m:concatenate c:' / '
Development sponsored by the Indiana State Library
Galen Charlton [Mon, 8 Mar 2010 21:14:08 +0000]
fix error in Codabar checkdigit algorithm
Ben Ostrowsky [Tue, 2 Feb 2010 15:55:35 +0000]
asset.copy.price is NUMERIC(8,2),
not NUMERIC(6,2).
Galen Charlton [Fri, 29 Jan 2010 15:42:45 +0000]
new function add_codabar_checkdigit
-- add_codabar_checkdigit
-- $barcode source barcode
--
-- If the source string is 13 or 14 characters long and contains only digits, adds or replaces the 14
-- character with a checkdigit computed according to the usual algorithm for library barcodes
-- using the Codabar symbology - see <http://www.makebarcode.com/specs/codabar.html>. If the
-- input string does not meet those requirements, it is returned unchanged.
Ben Ostrowsky [Thu, 28 Jan 2010 17:35:37 +0000]
Added migration_tools.attempt_money, which returns NUMERIC(6,2)
Ben Ostrowsky [Tue, 5 Jan 2010 20:17:38 +0000]
Ligonier (PA) is Polaris, yes, but Ligonier (IN) is Mandarin.
Ben Ostrowsky [Tue, 5 Jan 2010 14:30:27 +0000]
Polaris patron extractor, first working version
Ben Ostrowsky [Tue, 29 Dec 2009 15:40:01 +0000]
A tool I found online
Ben Ostrowsky [Mon, 28 Dec 2009 17:34:46 +0000]
Script now handles Jr and Sr without a trailing period, and the suffix IV.
Galen Charlton [Wed, 9 Dec 2009 13:52:47 +0000]
quell warning if no Koha bib ID found
Galen Charlton [Tue, 8 Dec 2009 20:43:43 +0000]
added koha_bib_id fingerprint option (for Koha migrations for
Indiana from INCOLSA)
Galen Charlton [Wed, 25 Nov 2009 14:27:04 +0000]
fix regex for extracting bib ID from input
Ben Ostrowsky [Tue, 10 Nov 2009 18:11:14 +0000]
Fixed another inaccuracy in the inline documentation
Ben Ostrowsky [Tue, 10 Nov 2009 15:12:24 +0000]
Made inline-documentation references to Equinox::Migration modules more explicit
Ben Ostrowsky [Fri, 30 Oct 2009 14:43:58 +0000]
Migration schemas will now handle action.hold_notification
Galen Charlton [Mon, 12 Oct 2009 14:23:33 +0000]
fixed minor errors in extract_loadset that prevent it from functioning
Jason Etheridge [Tue, 8 Sep 2009 09:00:48 +0000]
utility methods for best-effort datatype casting
Galen Charlton [Wed, 26 Aug 2009 19:00:28 +0000]
declare expand_barcode to be STABLE
As noticed by Jason, doing this gives a signficant
performance boost.
Jason Etheridge [Wed, 26 Aug 2009 07:07:22 +0000]
support for dynamic mapping of circ fields
Galen Charlton [Mon, 24 Aug 2009 16:20:34 +0000]
added new function to pad barcodes
-- expand_barcode
-- $barcode source barcode
-- $prefix prefix to add to barcode, NULL = add no prefix
-- $maxlen maximum length of barcode; default to 14 if left NULL
-- $pad padding string to apply to left of source barcode before adding
-- prefix and suffix; set to NULL or '' if no padding is desired
-- $suffix suffix to add to barcode, NULL = add no suffix
--
-- Returns a new string consisting of prefix concatenated with padded barcode and suffix.
-- If new barcode would be longer than $maxlen, the original barcode is returned instead.
Example usage:
UPDATE foo
SET barcode = migration_tools.expand_barcode(barcode, '21234', 14, '0', '');
Jason Etheridge [Wed, 12 Aug 2009 05:53:55 +0000]
syntax
Jason Etheridge [Wed, 12 Aug 2009 05:11:04 +0000]
move copy location mapping functionality into base.sql
Jason Etheridge [Wed, 12 Aug 2009 04:58:48 +0000]
move dynamic item mapping functionality to base.sql; it's not ILS specific
Jason Etheridge [Tue, 11 Aug 2009 10:39:15 +0000]
this stored procedure is a true function with no side effects
Jason Etheridge [Tue, 11 Aug 2009 10:37:09 +0000]
name parser
Jason Etheridge [Sat, 8 Aug 2009 22:52:13 +0000]
fix signature
Jason Etheridge [Sat, 8 Aug 2009 22:41:00 +0000]
start moving this mapping functionality over to base, since the only part that is ILS specific is the data that drives it
Shawn Boyette [Mon, 27 Jul 2009 16:06:22 +0000]
MDMP require version bumped
believe non-holding multis work now
null non-holdings data handled better
Shawn Boyette [Mon, 27 Jul 2009 16:06:21 +0000]
1.005
added 'ignoremulti' modifier
mods handling slightly tweaked
Shawn Boyette [Tue, 14 Jul 2009 03:07:46 +0000]
newline at end of sample run
Shawn Boyette [Mon, 13 Jul 2009 18:14:12 +0000]
--marcfile no longer gets -m; --map does
Shawn Boyette [Thu, 9 Jul 2009 16:29:41 +0000]
autoset marcfile on prefix
Shawn Boyette [Thu, 9 Jul 2009 14:24:34 +0000]
oopses
Shawn Boyette [Thu, 9 Jul 2009 14:09:18 +0000]
redo
Shawn Boyette [Thu, 9 Jul 2009 14:09:17 +0000]
redoing previous changes
Shawn Boyette [Thu, 9 Jul 2009 13:56:41 +0000]
rescued changes
Shawn Boyette [Thu, 25 Jun 2009 17:31:51 +0000]
yanking DBM::Deep stuffs
Shawn Boyette [Thu, 25 Jun 2009 17:31:50 +0000]
removing DBMD, phase I
Shawn Boyette [Wed, 24 Jun 2009 19:20:19 +0000]
old2new generation now handles controlfields and will map any number of matches, not just one-per-record
Shawn Boyette [Wed, 24 Jun 2009 19:20:19 +0000]
tweaks
Shawn Boyette [Wed, 24 Jun 2009 19:20:19 +0000]
typo fix
Shawn Boyette [Wed, 24 Jun 2009 19:20:18 +0000]
improved multifile handling
Shawn Boyette [Wed, 24 Jun 2009 19:20:18 +0000]
multi extractions work now. holding seq# always included now
Shawn Boyette [Wed, 24 Jun 2009 19:20:17 +0000]
making sampling work better
Shawn Boyette [Wed, 24 Jun 2009 19:20:17 +0000]
added subs thresholding
Shawn Boyette [Wed, 24 Jun 2009 19:20:16 +0000]
version bump
Shawn Boyette [Wed, 24 Jun 2009 19:20:16 +0000]
fixes for multi subfields
added get_multis method
Shawn Boyette [Wed, 24 Jun 2009 19:20:15 +0000]
autoflush turned off for DBM::Deep
name method doesn't require rec# anymore
{names} gone from record dataset
Shawn Boyette [Thu, 18 Jun 2009 18:23:37 +0000]
test for existing DBMD file; die
Shawn Boyette [Thu, 18 Jun 2009 18:23:36 +0000]
set default window size to 9 lines
Shawn Boyette [Thu, 18 Jun 2009 18:23:35 +0000]
holdings dump status msg now counts holdings instead of records
Shawn Boyette [Fri, 12 Jun 2009 18:30:37 +0000]
works with new MDMP
Shawn Boyette [Fri, 12 Jun 2009 18:30:36 +0000]
take rcnt out of dstore and call it reccount
Shawn Boyette [Fri, 12 Jun 2009 18:30:36 +0000]
changed rptr to rcnt
Shawn Boyette [Fri, 12 Jun 2009 18:30:36 +0000]
args handling bug
Shawn Boyette [Fri, 12 Jun 2009 18:30:35 +0000]
Keeping MDMP from eating all teh rams (WIP)
Shawn Boyette [Fri, 12 Jun 2009 18:30:34 +0000]
scope tweaking
Shawn Boyette [Fri, 12 Jun 2009 18:30:34 +0000]
1.003 No longer purely OO, to allow XML::Twig to run in handler mode (cuts memory usage from 2G+ to ~25M for full sampling
Shawn Boyette [Fri, 12 Jun 2009 18:30:33 +0000]
test fixes for 1.003
Shawn Boyette [Wed, 10 Jun 2009 16:54:28 +0000]
changelog
Shawn Boyette [Wed, 10 Jun 2009 16:54:27 +0000]
1.002 if any instance of a sub has a value, that should now appear in detail sample output
Shawn Boyette [Fri, 29 May 2009 21:14:33 +0000]
subfield report added to detail
Shawn Boyette [Fri, 29 May 2009 21:14:32 +0000]
sbufield lengthtracking implemented
Shawn Boyette [Wed, 27 May 2009 17:01:29 +0000]
1.001 changed sample detail format to one which can be dumped directly into a dokuwiki page