migration-tools.git
4 years agoget_marc_leader()
Jason Etheridge [Wed, 6 Dec 2017 04:54:41 +0000]
get_marc_leader()

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agofunction for setting passwords in actor.passwd quickly
Rogan Hamby [Wed, 29 Nov 2017 14:52:49 +0000]
function for setting passwords in actor.passwd quickly

4 years agobetter regexp for grabbing field names, redux
Jason Etheridge [Mon, 27 Nov 2017 22:42:16 +0000]
better regexp for grabbing field names, redux

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agobetter regexp for grabbing field names
Jason Etheridge [Mon, 27 Nov 2017 22:35:57 +0000]
better regexp for grabbing field names

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agoquicksheet experiment, do not omit tabs based on number of unique values
Jason Etheridge [Mon, 27 Nov 2017 22:21:48 +0000]
quicksheet experiment, do not omit tabs based on number of unique values

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agoupdate unicorn holdings example
Jason Etheridge [Mon, 27 Nov 2017 20:41:04 +0000]
update unicorn holdings example

4 years agoexample cleanup
Jason Etheridge [Mon, 27 Nov 2017 20:19:30 +0000]
example cleanup

4 years agoexample holdings map for Unicorn/Symphony
Jason Etheridge [Mon, 27 Nov 2017 20:15:31 +0000]
example holdings map for Unicorn/Symphony

4 years agooverzealous heuristic
Jason Etheridge [Wed, 8 Nov 2017 02:06:55 +0000]
overzealous heuristic

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agotoward better name parsing (handles names like "Van Horn, Fiona")
Jason Etheridge [Wed, 11 Oct 2017 08:40:44 +0000]
toward better name parsing (handles names like "Van Horn, Fiona")

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agotoward better name parsing (handles names like "Van Horn, Fiona")
Jason Etheridge [Wed, 11 Oct 2017 07:55:36 +0000]
toward better name parsing (handles names like "Van Horn, Fiona")

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agocomment
Jason Etheridge [Tue, 3 Oct 2017 19:07:14 +0000]
comment

4 years agopush bib sequence and return starting value for reserved range
Jason Etheridge [Tue, 3 Oct 2017 19:05:35 +0000]
push bib sequence and return starting value for reserved range

4 years agoMerge branch 'master' of git.esilibrary.com:migration-tools
Jason Etheridge [Tue, 3 Oct 2017 18:33:58 +0000]
Merge branch 'master' of git.esilibrary.com:migration-tools

4 years agofix mig-init
Jason Etheridge [Tue, 3 Oct 2017 18:33:47 +0000]
fix mig-init

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agoadding actor.usr_setting to production tables
Rogan Hamby [Tue, 26 Sep 2017 13:03:59 +0000]
adding actor.usr_setting to production tables

4 years agomigration_tools.attempt_sierra_timestamp
Jason Etheridge [Mon, 11 Sep 2017 07:34:18 +0000]
migration_tools.attempt_sierra_timestamp

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agomore address parsing helpers
Jason Etheridge [Mon, 11 Sep 2017 02:58:51 +0000]
more address parsing helpers

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agopsql variable for :migschema
Jason Etheridge [Sat, 9 Sep 2017 02:51:38 +0000]
psql variable for :migschema

mig-sql already puts the migration schema in the search path, but
this can be useful for things like

    creator = (SELECT id FROM actor_usr WHERE usrname = :'migschema' || '_admin')

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agomultiple file support for mig-quicksheet
Jason Etheridge [Mon, 28 Aug 2017 19:22:49 +0000]
multiple file support for mig-quicksheet

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agomig-init: loop through sorted mig-sql/ directory
Jason Etheridge [Wed, 23 Aug 2017 20:45:15 +0000]
mig-init: loop through sorted mig-sql/ directory

mig-init will look for .sql files in mig-sql to run

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

4 years agomig-sql: silence warning if no $BIBSTART
Jason Etheridge [Wed, 23 Aug 2017 20:42:32 +0000]
mig-sql: silence warning if no $BIBSTART

5 years agomig-env: set PGOPTIONS for search_path
Jason Etheridge [Tue, 8 Aug 2017 14:29:04 +0000]
mig-env: set PGOPTIONS for search_path

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years agoextract_holdings: --suffix support
Jason Etheridge [Tue, 8 Aug 2017 13:42:28 +0000]
extract_holdings: --suffix support

helps when you need to extract tag data from multiple MARC sources in a given migration

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years agoadding deletion of extra permissions and groups for users in remove ou scripts
Rogan Hamby [Thu, 3 Aug 2017 19:57:46 +0000]
adding deletion of extra permissions and groups for users in remove ou scripts

5 years agoadding basic program to convert from Apollo LDF to staging tables
Rogan Hamby [Thu, 3 Aug 2017 19:28:57 +0000]
adding basic program to convert from Apollo LDF to staging tables

5 years agoadding deletion of surveys to remove ou scripts
Rogan Hamby [Thu, 3 Aug 2017 19:23:38 +0000]
adding deletion of surveys to remove ou scripts

5 years agofix -fs, and more output when fixing stuff
Jason Etheridge [Thu, 29 Jun 2017 18:50:07 +0000]
fix -fs, and more output when fixing stuff

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years agosome marc mappings for III Sierra
Jason Etheridge [Thu, 29 Jun 2017 17:01:44 +0000]
some marc mappings for III Sierra

5 years agomig-sql: pass through the BIBSTART env variable
Jason Etheridge [Thu, 29 Jun 2017 15:57:45 +0000]
mig-sql: pass through the BIBSTART env variable

available as :bibstart

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years agomig-sql
Jason Etheridge [Wed, 3 May 2017 19:21:20 +0000]
mig-sql

Mig wrapper for psql.  Plan is to start injecting some useful mig-tracked
variables into psql sessions thus invoked.

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years agosome stuff I had lying around
Jason Etheridge [Wed, 3 May 2017 19:02:43 +0000]
some stuff I had lying around

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years agoASSERT not supported until PG 9.5
Jason Etheridge [Tue, 11 Apr 2017 20:04:25 +0000]
ASSERT not supported until PG 9.5

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years agosome useful wrappers for loading bre's
Jason Etheridge [Fri, 7 Apr 2017 14:53:13 +0000]
some useful wrappers for loading bre's

5 years ago"mig" tool
Jason Etheridge [Fri, 7 Apr 2017 12:31:31 +0000]
"mig" tool

Wraps some new and existing tools in a git-like command system,
currently great for quickly getting files into staging tables,
has aspirations for one day tracking mapping relationships and
doing code generation for mapping.

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years agothird variant of migration_tools.assert with success message as 3rd argument
Jason Etheridge [Thu, 30 Mar 2017 17:32:44 +0000]
third variant of migration_tools.assert with success message as 3rd argument

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years ago--force-utf8 in leader for marc_cleanup
Jason Etheridge [Thu, 30 Mar 2017 17:19:08 +0000]
--force-utf8 in leader for marc_cleanup

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years agoassert tool for use with \set ON_ERROR_STOP on
Jason Etheridge [Thu, 30 Mar 2017 17:18:25 +0000]
assert tool for use with \set ON_ERROR_STOP on

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years agouse UNLOGGED tables for the base staging tables
Jason Etheridge [Tue, 14 Mar 2017 17:22:51 +0000]
use UNLOGGED tables for the base staging tables

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years agoadd note to readme
Rogan Hamby [Mon, 27 Feb 2017 13:38:29 +0000]
add note to readme

5 years agoadd vacuum analyze script for database maintenance in remove_ou scripts
Rogan Hamby [Mon, 27 Feb 2017 13:37:56 +0000]
add vacuum analyze script for database maintenance in remove_ou scripts

5 years agoadd a script to aid in generating the delete file for patrons in remove_ou scripts
Rogan Hamby [Mon, 27 Feb 2017 13:37:02 +0000]
add a script to aid in generating the delete file for patrons in remove_ou scripts

5 years agoadd disable/renable rule so that copy locations can be deleted in remove_ou scripts
Rogan Hamby [Mon, 27 Feb 2017 13:35:55 +0000]
add disable/renable rule so that copy locations can be deleted in remove_ou scripts

5 years agoadd removing usr circ history to remove_ou scripts
Rogan Hamby [Mon, 27 Feb 2017 13:34:45 +0000]
add removing usr circ history to remove_ou scripts

5 years agoadd removing call number suffixes and prefixes to remove_ou scripts
Rogan Hamby [Mon, 27 Feb 2017 13:33:59 +0000]
add removing call number suffixes and prefixes to remove_ou scripts

5 years agoremoved unncessary schema declared on column and fixed issue where value needed was...
Rogan Hamby [Thu, 9 Feb 2017 16:36:13 +0000]
removed unncessary schema declared on column and fixed issue where value needed was ID and org shortname was given

5 years agoremoved moving call numbers where items and call numbers were on incompatible orgs...
Rogan Hamby [Mon, 17 Oct 2016 18:50:31 +0000]
removed moving call numbers where items and call numbers were on incompatible orgs to be deleted

5 years agoadded check to make sure holds were fulfilled when deleting by fulfillment library
Rogan Hamby [Mon, 17 Oct 2016 18:47:19 +0000]
added check to make sure holds were fulfilled when deleting by fulfillment library

5 years agoremoved nulling of parent circs where child circ is at non-deleted library
Rogan Hamby [Mon, 17 Oct 2016 18:44:56 +0000]
removed nulling of parent circs where child circ is at non-deleted library

5 years agoRemove stat cats owned by to be deleted org unit, stat cat entries and entry user...
Rogan Hamby [Mon, 17 Oct 2016 16:25:44 +0000]
Remove stat cats owned by to be deleted org unit, stat cat entries and entry user mappings by those stat cats or patrons of those org units.

5 years agomove call numbers from to be deleted org to undeleted org when the copy is at an...
Rogan Hamby [Mon, 17 Oct 2016 16:03:20 +0000]
move call numbers from to be deleted org to undeleted org when the copy is at an undeleted org

5 years agoadd deleting holds by request lib
Rogan Hamby [Mon, 17 Oct 2016 15:03:02 +0000]
add deleting holds by request lib

5 years agoremove auditor history edits
Rogan Hamby [Mon, 17 Oct 2016 14:53:07 +0000]
remove auditor history edits

5 years agoremove holds based on fulfillment library
Rogan Hamby [Mon, 17 Oct 2016 14:34:18 +0000]
remove holds based on fulfillment library

5 years agoupdate the noncat circ code to note delete non cat circs when the staff member is...
Rogan Hamby [Mon, 17 Oct 2016 14:17:49 +0000]
update the noncat circ code to note delete non cat circs when the staff member is registered at the wrong library

5 years agodeletions of non cat circs
Rogan Hamby [Mon, 17 Oct 2016 14:08:39 +0000]
deletions of non cat circs

5 years agoremove albermale references by putting in a variable and deleting usr messages
Rogan Hamby [Mon, 17 Oct 2016 14:03:24 +0000]
remove albermale references by putting in a variable and deleting usr messages

5 years agoadded line to handle child checkouts where parent checkout is at the org being delete...
Rogan Hamby [Mon, 17 Oct 2016 12:48:24 +0000]
added line to handle child checkouts where parent checkout is at the org being deleted but child is not by nulling parent circ, unfortunately no way to indicate this

5 years agoOU data removal script
Galen Charlton [Fri, 14 Oct 2016 15:17:15 +0000]
OU data removal script

This is a set of SQL scripts to be run, in order, to completely
remove data belonging to an OU and its descendants in an Evergreen
database.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>

5 years agofilter out linefeeds and carriage returns from holding tag values
Jason Etheridge [Wed, 14 Sep 2016 13:59:42 +0000]
filter out linefeeds and carriage returns from holding tag values

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

5 years agofilter out tabs from holding tag values
Jason Etheridge [Wed, 14 Sep 2016 13:33:54 +0000]
filter out tabs from holding tag values

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

6 years agominor whitespace correction
Galen Charlton [Mon, 8 Aug 2016 18:25:17 +0000]
minor whitespace correction

Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agoMake --wait optional in eg_staged_bib_overlay.
Jason Stephenson [Sat, 6 Aug 2016 21:28:47 +0000]
Make --wait optional in eg_staged_bib_overlay.

This commit only causes load bibs to wait if the --wait option is
specified with a non-zero value.  It also changes the default for the
global $wait variable that the option is read into to zero.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agoPerl eval improvements in eg_staged_bib_overlay.
Jason Stephenson [Sun, 7 Aug 2016 14:23:42 +0000]
Perl eval improvements in eg_staged_bib_overlay.

Two changes to improve the eval conditions added in the previous
commit:

1. Both error handlers now warn with the same message:

   Record $i is bad: $@; skipping.

Thereby reporting the original message in case the user wants to try
and recover the records later.

2. If a bib record's 901$c is either missing or not numeric, die() is
called with a message to that effect.  This eliminates the Perl
warnings about exiting an eval block with next.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agoUse eval in eg_staged_bib_overlay.
Jason Stephenson [Sat, 6 Aug 2016 21:10:12 +0000]
Use eval in eg_staged_bib_overlay.

Wrap the parsing of MARC from input files in eval blocks with an error
handler to skip to the next record.  I have encounterd bad records
that have stopped the processing of the rest of the file.  This
occurred the very first time I used this script.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agoconvert DestinyCustomReport XML to TSV
Jason Etheridge [Tue, 19 Jul 2016 20:17:49 +0000]
convert DestinyCustomReport XML to TSV

6 years agoadd --fix-subfield
Jason Etheridge [Mon, 6 Jun 2016 19:59:44 +0000]
add --fix-subfield

and tweak some comments and command-line help

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

6 years agoexample Follet/Destiny 852 map
Jason Etheridge [Fri, 27 May 2016 19:17:59 +0000]
example Follet/Destiny 852 map

6 years agosyntax in INHERIT example
Jason Etheridge [Fri, 27 May 2016 19:17:32 +0000]
syntax in INHERIT example

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

6 years agoeg_staged_bib_overlay: add --link-skipped
Galen Charlton [Wed, 18 May 2016 16:04:23 +0000]
eg_staged_bib_overlay: add --link-skipped

The new --link-skipped switch modifies the link_auth_bibs
action to say that bibs that were skipped due to having been
edited after the cutoff should be linked to authorities (rather
than linking imported bibs).

The use case for this: the library decides that they don't
want to scribble over the skipped bibs, but still want to
take advantage of any new authorities that correspond to them.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agoeg_staged_bib_overlay: add actions to export skipped records
Galen Charlton [Mon, 16 May 2016 17:31:43 +0000]
eg_staged_bib_overlay: add actions to export skipped records

Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agoeg_staged_bib_overlay: fix help
Galen Charlton [Mon, 2 May 2016 18:57:35 +0000]
eg_staged_bib_overlay: fix help

Corrected the description of the --overlay_auths_stage1
and --overlay_auths_stage2 switches.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agoeg_staged_bib_overlay: add link_auth_bib action
Galen Charlton [Mon, 18 Apr 2016 19:57:17 +0000]
eg_staged_bib_overlay: add link_auth_bib action

Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agostaged record loader: add various authority record actions
Galen Charlton [Mon, 11 Apr 2016 19:32:52 +0000]
staged record loader: add various authority record actions

--action stage_auths          - load MARC authorities into staging
                                table
--action match_auths          - identify matches with authority
                                records already present in the
                                Evergreen database; matching is
                                based on LCCN, cancelled LCCN, and
                                main heading.
--action load_new_auths       - load new (unmatched) authorities
--action overlay_auths_stage1 - overlay based on LCCN where
                                heading has not change; this step
                                disables propagation to bib records
--action overlay_auths_stage2 - overlay based on LCCN where heading
                                has NOT changed; propagates changes
                                to bib records
--action overlay_auths_stage3 - overlay for records where a cancelled
                                LCCN is replaced with a new one
--action link_auth_auth       - run authority_authority_linker.pl for
                                the authorities that were overlaid
                                or added in this batch.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agotweaks to name parser
Jason Etheridge [Mon, 11 Apr 2016 15:53:33 +0000]
tweaks to name parser

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

6 years agostaged bib overlay: tweak bib filtering
Galen Charlton [Mon, 11 Apr 2016 14:18:18 +0000]
staged bib overlay: tweak bib filtering

Filtering now always ignores staged bibs that are
imported or already marked as not to be imported.

Also, bibs whose XML is not well-formed are now
excluded.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agoupdate usage information
Galen Charlton [Tue, 5 Apr 2016 14:26:22 +0000]
update usage information

Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agonew utility to overlay bib records in an Evergreen database
Galen Charlton [Tue, 5 Apr 2016 14:24:47 +0000]
new utility to overlay bib records in an Evergreen database

Utility to stage and overlay bib records in an Evergreen database. This
expects that the incoming records will have been previously exported
from that Evergreen database and modified in some fashion (e.g., for
authority record processing) and that the bib ID can be found in the
901$c subfield.

This program has several modes controlled by the --action switch:

  --action stage_bibs  - load MARC bib records into a staging table
  --action filter_bibs - mark previously staged bibs that should
                         be excluded from a subsequent load, either
                         because the target bib is deleted in Evergreen
                         or the record was modified after a date
                         specified by the --cutoff switch
  --action load_bibs   - overlay bib records using a previously staged
                         batch, one at a time. After each bib, it will
                         wait the number of seconds specified by the
                         --wait switch.

Several switches are used regardless of the specified action:

  --schema  - Pg schema in which staging table will live; should be
              created beforehand
  --batch   - name of bib batch; will also be used as the name
              of the staging table
  --db      - database name
  --dbuser  - database user
  --dbpw    - database password
  --dbhost  - database host

Examples:

./eg_staged_bib_overlay --schema bib_load --batch bibs_2016_01 --db evergreen \
   --dbuser evergreen --dbpw evergreen --dbhost localhost \
   --action stage_bibs -- file1.mrc file2.mrc [...]

./eg_staged_bib_overlay --schema bib_load --batch bibs_2016_01 --db evergreen \
   --dbuser evergreen --dbpw evergreen --dbhost localhost \
   --action filter_bibs --cutoff 2016-01-02

./eg_staged_bib_overlay --schema bib_load --batch bibs_2016_01 --db evergreen \
   --dbuser evergreen --dbpw evergreen --dbhost localhost \
   --action load_bibs

Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agoteach export_evergreen_library how to emit serials data
Galen Charlton [Thu, 17 Mar 2016 16:59:53 +0000]
teach export_evergreen_library how to emit serials data

Signed-off-by: Galen Charlton <gmc@esilibrary.com>

6 years agoacq.fund_tag_map
Jason Etheridge [Fri, 11 Mar 2016 21:31:11 +0000]
acq.fund_tag_map

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

6 years agoadd acq.provider_contact and acq.provider_contact_address to base staging table
Jason Etheridge [Fri, 11 Mar 2016 19:22:37 +0000]
add acq.provider_contact and acq.provider_contact_address to base staging table

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

6 years agoadd action.transit_copy and action.hold_transit_copy to base tables
Jason Etheridge [Mon, 29 Feb 2016 14:46:47 +0000]
add action.transit_copy and action.hold_transit_copy to base tables

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

6 years agoadd action.hold_request_note to the list of base tables
Jason Etheridge [Mon, 29 Feb 2016 14:39:56 +0000]
add action.hold_request_note to the list of base tables

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

6 years agomigration_tools.attempt_hz_date
Ben Ostrowsky [Fri, 19 Feb 2016 02:33:10 +0000]
migration_tools.attempt_hz_date

6 years agotweak for case when just last name
Jason Etheridge [Fri, 19 Feb 2016 02:07:04 +0000]
tweak for case when just last name

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

6 years agomigration_tools.name_parse_out_last_first_middle_and_random_affix for LAST FIRST...
Jason Etheridge [Fri, 19 Feb 2016 02:01:09 +0000]
migration_tools.name_parse_out_last_first_middle_and_random_affix for LAST FIRST MIDDLE with no comma

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

6 years agomigration_tools.find_hold_matrix_matchpoint2
Jason Etheridge [Thu, 28 Jan 2016 17:08:58 +0000]
migration_tools.find_hold_matrix_matchpoint2

another convenience function

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

6 years agoremove config fig.circ_matrix_circ_mod_test
Jason Etheridge [Thu, 24 Sep 2015 04:45:37 +0000]
remove config fig.circ_matrix_circ_mod_test

and _map from the list of base tables so that .build() will work with newer
versions of EG

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

7 years agomore money converters
Jason Etheridge [Mon, 10 Aug 2015 03:45:03 +0000]
more money converters

migration_tools.attempt_money_from_pennies
and migration_tools.attempt_money_from_pennies6

Avoids dividing by 100 when doing the conversion

2nd argument, the fail value, should not be pennies

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

7 years agoduplicate_template_but_change_delay
Jason Etheridge [Thu, 6 Aug 2015 03:22:21 +0000]
duplicate_template_but_change_delay

Let's us get around duplicate key issues in some cases by tweaking the delay as
part of the cloning process.

Example:

    ubuntudeskfx=# SELECT * FROM migration_tools.duplicate_template(5,'{3,4}','00:30:00'::INTERVAL);

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

7 years agoMinor typo fix in export_evergreen_library
Mike Rylander [Thu, 18 Jun 2015 13:49:27 +0000]
Minor typo fix in export_evergreen_library

Signed-off-by: Mike Rylander <mrylander@gmail.com>

7 years agotweak migration_tools.insert_856_9
Jason Etheridge [Mon, 20 Apr 2015 16:10:02 +0000]
tweak migration_tools.insert_856_9

rename original to migration_tools.insert_856_9_conditional, since it has
behavior based on 856$u content.  New version simply adds a $9 if one does
not already exist (regardless of org unit referenced)

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

7 years agohandle dates like 051980
Jason Etheridge [Tue, 24 Mar 2015 20:17:16 +0000]
handle dates like 051980

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

7 years agoadd some in-db matchpoint tables, for potential ease of staging policy rules
Jason Etheridge [Wed, 18 Mar 2015 14:49:20 +0000]
add some in-db matchpoint tables, for potential ease of staging policy rules

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

7 years agoconvenience wrappers for finding in-db rules
Jason Etheridge [Mon, 16 Mar 2015 18:22:57 +0000]
convenience wrappers for finding in-db rules

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

7 years agomake migration_tools.apply_circ_matrix_to_specific_circ use the more recent apply_cir...
Jason Etheridge [Mon, 16 Mar 2015 17:56:21 +0000]
make migration_tools.apply_circ_matrix_to_specific_circ use the more recent apply_circ_matrix code

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

7 years agoadd a delimiter paramater, and a variant that returns an array of tags
Jason Etheridge [Wed, 25 Feb 2015 15:54:20 +0000]
add a delimiter paramater, and a variant that returns an array of tags

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

7 years ago.get_marc_tag
Jason Etheridge [Sat, 21 Feb 2015 01:53:35 +0000]
.get_marc_tag

Useful since you can't get unnormalized values out of metabib.full_rec

Signed-off-by: Jason Etheridge <jason@esilibrary.com>

7 years agoMerge branch 'master' of git.esilibrary.com:migration-tools
Jason Etheridge [Thu, 5 Feb 2015 17:30:30 +0000]
Merge branch 'master' of git.esilibrary.com:migration-tools

7 years agomigration_tools.apply_circ_matrix_to_specific_circ
Jason Etheridge [Thu, 5 Feb 2015 17:30:26 +0000]
migration_tools.apply_circ_matrix_to_specific_circ

Signed-off-by: Jason Etheridge <jason@esilibrary.com>