migration-tools.git
2 months agoadding full paths
Rogan Hamby [Wed, 4 Sep 2019 17:40:54 +0000]
adding full paths

2 months agoMerge branch 'master' of git.esilibrary.com:migration-tools
Rogan Hamby [Wed, 4 Sep 2019 17:37:28 +0000]
Merge branch 'master' of git.esilibrary.com:migration-tools

2 months agoadd full path where needed
Rogan Hamby [Wed, 4 Sep 2019 17:37:13 +0000]
add full path where needed

2 months agoadding tables to support reporter output
Rogan Hamby [Fri, 30 Aug 2019 20:23:47 +0000]
adding tables to support reporter output

2 months agofix spelling error
Rogan Hamby [Fri, 30 Aug 2019 20:03:32 +0000]
fix spelling error

2 months agoremoving a few cargo culted lines
Rogan Hamby [Thu, 29 Aug 2019 12:46:17 +0000]
removing a few cargo culted lines

2 months agomissed adding this when removing the excel logic from mig-reporter
Rogan Hamby [Wed, 28 Aug 2019 19:04:12 +0000]
missed adding this when removing the excel logic from mig-reporter

2 months agomove stagebibs to getopt::long
Rogan Hamby [Wed, 28 Aug 2019 19:03:41 +0000]
move stagebibs to getopt::long

2 months agomoving mig-reporter to get opt long
Rogan Hamby [Wed, 28 Aug 2019 18:14:53 +0000]
moving mig-reporter to get opt long

2 months agoimproved docs for mig-stagebibs
Rogan Hamby [Wed, 28 Aug 2019 17:54:43 +0000]
improved docs for mig-stagebibs

2 months agoremoved excel option from mig-reporter, not needed now that spreadsheets copy and...
Rogan Hamby [Wed, 28 Aug 2019 17:52:02 +0000]
removed excel option from mig-reporter, not needed now that spreadsheets copy and paste html tables well

2 months agolaziness idea from rhamby for the win
Jason Etheridge [Tue, 27 Aug 2019 21:51:22 +0000]
laziness idea from rhamby for the win

Signed-off-by: Jason Etheridge <jason@equinoxinitiative.org>

2 months agomoving horizong by sql to its own tag
Rogan Hamby [Tue, 27 Aug 2019 19:36:35 +0000]
moving horizong by sql to its own tag

2 months agofixes for newer horizon reports
Rogan Hamby [Tue, 27 Aug 2019 19:30:33 +0000]
fixes for newer horizon reports

2 months agoadding file path to error when file can't be opened
Rogan Hamby [Tue, 27 Aug 2019 19:19:41 +0000]
adding file path to error when file can't be opened

2 months agohorizong from database mapping added
Rogan Hamby [Tue, 27 Aug 2019 18:49:13 +0000]
horizong from database mapping added

2 months agoadding fixed fields back in
Rogan Hamby [Fri, 23 Aug 2019 23:54:20 +0000]
adding fixed fields back in

2 months agofor convenience, see which file has which function
Jason Etheridge [Fri, 23 Aug 2019 20:57:30 +0000]
for convenience, see which file has which function

2 months agoMerge branch 'master' of yeti.esilibrary.com:migration-tools
Jason Etheridge [Fri, 23 Aug 2019 20:48:42 +0000]
Merge branch 'master' of yeti.esilibrary.com:migration-tools

2 months agogreat shuffling, not finished
Jason Etheridge [Fri, 23 Aug 2019 20:44:28 +0000]
great shuffling, not finished

2 months agocleaning up functions duplicated in 01-marc.sql
Rogan Hamby [Fri, 23 Aug 2019 19:06:29 +0000]
cleaning up functions duplicated in 01-marc.sql

2 months agomaking fixed fields fit with numbering scheme
Rogan Hamby [Fri, 23 Aug 2019 18:54:09 +0000]
making fixed fields fit with numbering scheme

2 months agorename marc.sql to 01-marc.sql
Jason Etheridge [Fri, 23 Aug 2019 18:53:03 +0000]
rename marc.sql to 01-marc.sql

2 months agotoward splitting things out
Jason Etheridge [Fri, 23 Aug 2019 18:46:17 +0000]
toward splitting things out

2 months agoadding fixed fields table to migration tools data
Rogan Hamby [Fri, 23 Aug 2019 18:40:51 +0000]
adding fixed fields table to migration tools data

2 months agomaking sure fixed field functions load to the correct schema
Rogan Hamby [Fri, 23 Aug 2019 18:33:49 +0000]
making sure fixed field functions load to the correct schema

2 months agomoving marc manipulation to it's own file
Rogan Hamby [Fri, 23 Aug 2019 18:29:19 +0000]
moving marc manipulation to it's own file

2 months agoadding functions for fixed field manipulations when importing records
Rogan Hamby [Fri, 23 Aug 2019 18:14:46 +0000]
adding functions for fixed field manipulations when importing records

2 months agoadding a function to allow createing more than one child table off a base evergreen...
Rogan Hamby [Fri, 23 Aug 2019 18:14:29 +0000]
adding a function to allow createing more than one child table off a base evergreen table

3 months agoget_marc_tag: return null if field not found
Jason Etheridge [Fri, 16 Aug 2019 16:57:23 +0000]
get_marc_tag: return null if field not found

Signed-off-by: Jason Etheridge <jason@equinoxinitiative.org>

3 months agotweaks to mig stagebibs
Jason Etheridge [Fri, 16 Aug 2019 16:38:01 +0000]
tweaks to mig stagebibs

Signed-off-by: Jason Etheridge <jason@equinoxinitiative.org>

3 months agotweaking mig-stagebibs creation of biblio_record_entry_legacy
Jason Etheridge [Tue, 13 Aug 2019 03:52:58 +0000]
tweaking mig-stagebibs creation of biblio_record_entry_legacy

Signed-off-by: Jason Etheridge <jason@equinoxinitiative.org>

3 months agotypoes
Jason Etheridge [Tue, 13 Aug 2019 03:27:33 +0000]
typoes

Signed-off-by: Jason Etheridge <jason@equinoxinitiative.org>

3 months agomaking headers bold
Rogan Hamby [Tue, 6 Aug 2019 14:59:07 +0000]
making headers bold

3 months agomultiple title hold report matches reports
Rogan Hamby [Tue, 6 Aug 2019 13:55:40 +0000]
multiple title hold report matches reports

3 months agomodified collision reports to use now x_ convention
Rogan Hamby [Fri, 2 Aug 2019 18:48:39 +0000]
modified collision reports to use now x_ convention

3 months agocommented out barcode lengths by library because it takes up a lot of space and isn...
Rogan Hamby [Fri, 2 Aug 2019 18:36:55 +0000]
commented out barcode lengths by library because it takes up a lot of space and isn't needed as much as it once was

4 months agoadding x_migrate flag and changing reference to text for defensive input munging
Rogan Hamby [Tue, 16 Jul 2019 15:46:32 +0000]
adding x_migrate flag and changing reference to text for defensive input munging

4 months agoexpanding columns on map_tlc_holding_code
Rogan Hamby [Tue, 16 Jul 2019 15:38:52 +0000]
expanding columns on map_tlc_holding_code

4 months agomore logic checkinf for existing bre tables
Rogan Hamby [Mon, 15 Jul 2019 16:03:31 +0000]
more logic checkinf for existing bre tables

4 months agomake biblio_record_entry be biblio_record_entry_legacy
Rogan Hamby [Mon, 15 Jul 2019 15:55:07 +0000]
make biblio_record_entry be biblio_record_entry_legacy

4 months agoadded version of strip_tag to take string and subfield as arguments
Rogan Hamby [Mon, 8 Jul 2019 18:20:18 +0000]
added version of strip_tag to take string and subfield as arguments

4 months agoimprovement for migration_tools.is_circ_rule_safe_to_delete
Jason Etheridge [Mon, 24 Jun 2019 22:21:57 +0000]
improvement for migration_tools.is_circ_rule_safe_to_delete

Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>

4 months agowait, you thought this was EG specific? :) migration_tools.generate_koha_holding_tag
Jason Etheridge [Mon, 24 Jun 2019 21:30:00 +0000]
wait, you thought this was EG specific? :)  migration_tools.generate_koha_holding_tag

Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>

4 months agocombine 245ab for openbiblio2marc
Jason Etheridge [Sun, 23 Jun 2019 07:51:11 +0000]
combine 245ab for openbiblio2marc

4 months agomigration_tools.consolidate_tag
Jason Etheridge [Sun, 23 Jun 2019 07:48:57 +0000]
migration_tools.consolidate_tag

4 months agouse 001 instead of 999 for storing the old openbiblio bibid
Jason Etheridge [Sun, 23 Jun 2019 03:15:11 +0000]
use 001 instead of 999 for storing the old openbiblio bibid

Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>

4 months agomigration_tools.openbiblio2marc
Jason Etheridge [Sun, 23 Jun 2019 03:04:38 +0000]
migration_tools.openbiblio2marc

4 months agooverzealous; control fields
Jason Etheridge [Sun, 23 Jun 2019 03:03:08 +0000]
overzealous; control fields

5 months agovariant of make_stub_bib that takes indicator values
Jason Etheridge [Sat, 22 Jun 2019 19:26:40 +0000]
variant of make_stub_bib that takes indicator values

Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>

5 months agoalternate versions of the barcode collision handlers.. rebarcodes to migschema +...
Jason Etheridge [Tue, 18 Jun 2019 20:05:15 +0000]
alternate versions of the barcode collision handlers.. rebarcodes to migschema + barcode for incumbent collisions; less robust than the originals but easier for end-users

5 months agoadd message to check for it being XML
Rogan Hamby [Thu, 6 Jun 2019 14:56:15 +0000]
add message to check for it being XML

5 months agoadding explicit disconnect to save on listeners
Rogan Hamby [Fri, 31 May 2019 14:48:04 +0000]
adding explicit disconnect to save on listeners

5 months agomigration_tools.is_circ_rule_safe_to_delete
Jason Etheridge [Thu, 30 May 2019 20:24:25 +0000]
migration_tools.is_circ_rule_safe_to_delete

5 months agoadding user setting report
Rogan Hamby [Wed, 29 May 2019 12:29:05 +0000]
adding user setting report

5 months agocleaning up notices reports
Rogan Hamby [Tue, 28 May 2019 16:31:25 +0000]
cleaning up notices reports

5 months agoMerge branch 'master' of git.esilibrary.com:migration-tools
Rogan Hamby [Tue, 28 May 2019 16:06:44 +0000]
Merge branch 'master' of git.esilibrary.com:migration-tools

5 months agoadd notices to default mig reports
Rogan Hamby [Tue, 28 May 2019 16:06:28 +0000]
add notices to default mig reports

6 months agosimplify git path
Jason Etheridge [Wed, 22 May 2019 17:58:25 +0000]
simplify git path

6 months agoMerge branch 'master' of git.esilibrary.com:migration-tools
Rogan Hamby [Wed, 22 May 2019 15:11:19 +0000]
Merge branch 'master' of git.esilibrary.com:migration-tools

6 months agoadded more bib reports
Rogan Hamby [Wed, 22 May 2019 13:50:03 +0000]
added more bib reports

6 months agoMerge branch 'master' of git.esilibrary.com:migration-tools
Rogan Hamby [Wed, 22 May 2019 12:54:18 +0000]
Merge branch 'master' of git.esilibrary.com:migration-tools

6 months agofixed sql typo
Rogan Hamby [Wed, 22 May 2019 12:53:58 +0000]
fixed sql typo

6 months agoremoving looking for usrname collections only on non-deleted records since constraint...
Rogan Hamby [Mon, 20 May 2019 18:44:45 +0000]
removing looking for usrname collections only on non-deleted records since constraint is on all usrnames

6 months agocopy/paste-o
Jason Etheridge [Mon, 20 May 2019 12:01:30 +0000]
copy/paste-o

6 months agosql vs plpgsql
Jason Etheridge [Sun, 19 May 2019 23:49:33 +0000]
sql vs plpgsql

6 months agotypo
Jason Etheridge [Sun, 19 May 2019 23:46:38 +0000]
typo

6 months agointernal _handle_shelf we can call without assertions
Jason Etheridge [Sun, 19 May 2019 23:45:16 +0000]
internal _handle_shelf we can call without assertions

6 months agodebugging
Jason Etheridge [Sun, 19 May 2019 23:32:25 +0000]
debugging

6 months agomigration_tools.munge_sf9_qualifying_match
Jason Etheridge [Sun, 19 May 2019 21:33:10 +0000]
migration_tools.munge_sf9_qualifying_match

6 months agovariation on yet another 856$9 munger
Jason Etheridge [Wed, 15 May 2019 17:53:42 +0000]
variation on yet another 856$9 munger

6 months agomigration_tools.get_marc_tags_filtered
Jason Etheridge [Wed, 15 May 2019 17:40:17 +0000]
migration_tools.get_marc_tags_filtered

6 months agoMerge branch 'master' of git.esilibrary.com:migration-tools to remove unlogged statements
Rogan Hamby [Tue, 14 May 2019 11:58:08 +0000]
Merge branch 'master' of git.esilibrary.com:migration-tools to remove unlogged statements

6 months agoremoving the last of the unlogged statements
Rogan Hamby [Tue, 14 May 2019 11:57:47 +0000]
removing the last of the unlogged statements

6 months agofixed bug for mig-stagebibs when the output is already all in a single line
Rogan Hamby [Mon, 13 May 2019 18:19:58 +0000]
fixed bug for mig-stagebibs when the output is already all in a single line

6 months agoadded funcitonality for --marcfile as documentation suggested it had
Rogan Hamby [Mon, 13 May 2019 17:51:06 +0000]
added funcitonality for --marcfile as documentation suggested it had

6 months agodoh
Jason Etheridge [Mon, 13 May 2019 12:28:36 +0000]
doh

Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>

6 months agoanother 856$9 munger
Jason Etheridge [Mon, 13 May 2019 12:23:35 +0000]
another 856$9 munger

Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>

6 months agomigration_tools.handle_actor_barcode_collisions
Jason Etheridge [Fri, 10 May 2019 16:28:54 +0000]
migration_tools.handle_actor_barcode_collisions

convenience function for handling patron barcode/usrname collisions in actor_usr_legacy

this should be ran prior to populating actor_card

Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>

6 months agomigration_tools.handle_asset_barcode_collisions
Jason Etheridge [Fri, 10 May 2019 15:37:29 +0000]
migration_tools.handle_asset_barcode_collisions

convenience function for handling item barcode collisions in asset_copy_legacy

Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>

6 months agobibs not loaded report added
Rogan Hamby [Thu, 9 May 2019 20:00:24 +0000]
bibs not loaded report added

6 months agonew mig-loadbibs
Rogan Hamby [Thu, 9 May 2019 19:39:25 +0000]
new mig-loadbibs

6 months agonew faster version of mig-bibload
Rogan Hamby [Thu, 9 May 2019 18:41:55 +0000]
new faster version of mig-bibload

6 months agosimplifying the bibs loaded report and making it specific to loaded not staged
Rogan Hamby [Thu, 2 May 2019 14:25:53 +0000]
simplifying the bibs loaded report and making it specific to loaded not staged

6 months agotypo fixed
Rogan Hamby [Thu, 2 May 2019 14:13:43 +0000]
typo fixed

6 months agoadding a simple counts dedupe report and fixing a typo
Rogan Hamby [Thu, 2 May 2019 13:01:25 +0000]
adding a simple counts dedupe report and fixing a typo

6 months agodedupe report
Rogan Hamby [Wed, 1 May 2019 20:04:49 +0000]
dedupe report

6 months agoMerge branch 'master' of git.esilibrary.com:migration-tools while adding mig reporter...
Rogan Hamby [Wed, 1 May 2019 19:47:15 +0000]
Merge branch 'master' of git.esilibrary.com:migration-tools while adding mig reporter report for copy alerts

6 months agoadding asset.copy_alert report
Rogan Hamby [Wed, 1 May 2019 19:46:55 +0000]
adding asset.copy_alert report

6 months agomore concise output for mig-reporter and circs
Jason Etheridge [Tue, 30 Apr 2019 15:46:26 +0000]
more concise output for mig-reporter and circs

7 months agoearly version of a mig pg_dump, untested so far
Rogan Hamby [Tue, 9 Apr 2019 20:14:17 +0000]
early version of a mig pg_dump, untested so far

7 months agofix Experimental unshift on scalar is now forbidden with newer Perl
Jason Etheridge [Mon, 8 Apr 2019 09:11:42 +0000]
fix Experimental unshift on scalar is now forbidden with newer Perl

7 months agoremoving the strict and force since they are superceded by munge
Rogan Hamby [Sat, 6 Apr 2019 18:14:23 +0000]
removing the strict and force since they are superceded by munge

7 months agoadding force and strict add sf9 to replace old add sf9
Rogan Hamby [Sat, 6 Apr 2019 18:11:28 +0000]
adding force and strict add sf9 to replace old add sf9

7 months agoMerge branch 'master' of git.esilibrary.com:migration-tools
Rogan Hamby [Mon, 25 Mar 2019 18:31:57 +0000]
Merge branch 'master' of git.esilibrary.com:migration-tools

7 months agoadding columsn for specifying to migrates items and or patrons on tlc branches
Rogan Hamby [Mon, 25 Mar 2019 18:31:41 +0000]
adding columsn for specifying to migrates items and or patrons on tlc branches

7 months agomigration_tools.name_parse_out_fuller_last_first_middle_and_random_affix2
Jason Etheridge [Sun, 24 Mar 2019 16:59:26 +0000]
migration_tools.name_parse_out_fuller_last_first_middle_and_random_affix2

8 months agoresolve ambiguities if you are working with mapping tables with their own id column
Jason Etheridge [Fri, 22 Mar 2019 15:36:45 +0000]
resolve ambiguities if you are working with mapping tables with their own id column

Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>

8 months agoadd new munge_sf9 function
Rogan Hamby [Tue, 26 Feb 2019 12:56:28 +0000]
add new munge_sf9 function

8 months agoremoving the add_sf9 function that doesn't check for indicators or reset them
Rogan Hamby [Tue, 26 Feb 2019 11:45:12 +0000]
removing the add_sf9 function that doesn't check for indicators or reset them