migration-tools.git
3 years agomade loadbibs able to load any table
Rogan Hamby [Thu, 26 Jul 2018 20:03:59 +0000]
made loadbibs able to load any table

3 years agoremoving redundant lines commented out
Rogan Hamby [Thu, 26 Jul 2018 19:27:20 +0000]
removing redundant lines commented out

3 years agoadding report to xml file
Rogan Hamby [Mon, 9 Jul 2018 20:01:44 +0000]
adding report to xml file

4 years agocommenting out the default graphic in mig-reporter
Rogan Hamby [Tue, 26 Jun 2018 12:03:10 +0000]
commenting out the default graphic in mig-reporter

4 years agofixing column data type in circ matrix map table
Rogan Hamby [Thu, 21 Jun 2018 20:34:06 +0000]
fixing column data type in circ matrix map table

4 years agofixed typo
Rogan Hamby [Thu, 21 Jun 2018 18:57:26 +0000]
fixed typo

4 years agofix typos in table names
Rogan Hamby [Thu, 21 Jun 2018 17:26:20 +0000]
fix typos in table names

4 years agoremoving inheritance from matrix mapping tables
Rogan Hamby [Thu, 21 Jun 2018 17:20:23 +0000]
removing inheritance from matrix mapping tables

4 years agoMerge branch 'master' of git.esilibrary.com:migration-tools
Rogan Hamby [Thu, 21 Jun 2018 17:09:36 +0000]
Merge branch 'master' of git.esilibrary.com:migration-tools

4 years agoadded circ and hold combo sheets
Rogan Hamby [Thu, 21 Jun 2018 17:09:05 +0000]
added circ and hold combo sheets

4 years agoquoting
Jason Etheridge [Wed, 20 Jun 2018 13:47:54 +0000]
quoting

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

4 years agomig env clone
Jason Etheridge [Wed, 20 Jun 2018 13:43:08 +0000]
mig env clone

4 years agomigration_tools.reset_event
Jason Etheridge [Tue, 19 Jun 2018 12:33:20 +0000]
migration_tools.reset_event

but consider using action_trigger.purge_events instead

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

4 years agoremoving phones from tlc excel report
Rogan Hamby [Thu, 14 Jun 2018 20:53:43 +0000]
removing phones from tlc excel report

4 years agoadding circ and hold tables to git sql files
Rogan Hamby [Thu, 14 Jun 2018 20:00:52 +0000]
adding circ and hold tables to git sql files

4 years agoneeded to add explicity schema to function call from another function
Rogan Hamby [Thu, 14 Jun 2018 12:56:34 +0000]
needed to add explicity schema to function call from another function

4 years agomigration_tools.duplicate_templates(org,'{def1,def2,...}');
Jason Etheridge [Wed, 13 Jun 2018 12:54:43 +0000]
migration_tools.duplicate_templates(org,'{def1,def2,...}');

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

4 years agostrip_tag function
Jason Etheridge [Fri, 8 Jun 2018 19:51:25 +0000]
strip_tag function

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

4 years agoforce_add_sf9
Jason Etheridge [Fri, 8 Jun 2018 18:31:05 +0000]
force_add_sf9

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

4 years agostrict_add_sf9
Jason Etheridge [Wed, 6 Jun 2018 07:48:39 +0000]
strict_add_sf9

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

4 years agothinko
Jason Etheridge [Mon, 4 Jun 2018 19:22:36 +0000]
thinko

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

4 years agoMerge branch 'master' of git.esilibrary.com:migration-tools
Jason Etheridge [Mon, 4 Jun 2018 19:15:51 +0000]
Merge branch 'master' of git.esilibrary.com:migration-tools

4 years agomigration_tools.add_mod16_checkdigit
Jason Etheridge [Mon, 4 Jun 2018 19:15:16 +0000]
migration_tools.add_mod16_checkdigit

4 years agoadding samples of notes to items tab for tlc reports
Rogan Hamby [Fri, 25 May 2018 12:44:51 +0000]
adding samples of notes to items tab for tlc reports

4 years agofixed word error that resulted from copy and paste
Rogan Hamby [Wed, 16 May 2018 13:06:51 +0000]
fixed word error that resulted from copy and paste

4 years agocommenting out some unused reports
Rogan Hamby [Thu, 10 May 2018 12:28:24 +0000]
commenting out some unused reports

4 years agoadding tlc mappings for when run from reports
Rogan Hamby [Wed, 9 May 2018 17:37:05 +0000]
adding tlc mappings for when run from reports

4 years agochanging verbage for bib loading table
Rogan Hamby [Fri, 4 May 2018 22:08:42 +0000]
changing verbage for bib loading table

4 years agostreamlining tlc mapping reports
Rogan Hamby [Fri, 4 May 2018 18:03:24 +0000]
streamlining tlc mapping reports

4 years agoassume unicode in flux, may change again based on disucssion wiht phasefx
Rogan Hamby [Thu, 3 May 2018 14:05:01 +0000]
assume unicode in flux, may change again based on disucssion wiht phasefx

4 years agonotices reports added to mig-xml
Rogan Hamby [Thu, 26 Apr 2018 19:44:32 +0000]
notices reports added to mig-xml

4 years agoadded a null_empty_lcolumns function too
Rogan Hamby [Wed, 25 Apr 2018 13:17:08 +0000]
added a null_empty_lcolumns function too

4 years agoadded to sql a btrim_lcolumns function
Rogan Hamby [Wed, 25 Apr 2018 13:07:36 +0000]
added to sql a btrim_lcolumns function

4 years agotweaks to the create table failover logic
Rogan Hamby [Thu, 19 Apr 2018 22:41:44 +0000]
tweaks to the create table failover logic

4 years agofixed bug that prevented source from populating in mig-loadbibs
Rogan Hamby [Thu, 19 Apr 2018 20:14:52 +0000]
fixed bug that prevented source from populating in mig-loadbibs

4 years agomaking mig-loadbibs a bit more defensive with marc-8 data
Rogan Hamby [Thu, 19 Apr 2018 20:02:06 +0000]
making mig-loadbibs a bit more defensive with marc-8 data

4 years agoadding bin mode to reading of file for loadbibs
Rogan Hamby [Thu, 19 Apr 2018 13:53:30 +0000]
adding bin mode to reading of file for loadbibs

4 years agotweak to bib report
Rogan Hamby [Thu, 19 Apr 2018 12:52:30 +0000]
tweak to bib report

4 years agobug fixes that prevented creating ore prerequisites from being created for mig bibload
Rogan Hamby [Wed, 18 Apr 2018 18:08:51 +0000]
bug fixes that prevented creating ore prerequisites from being created for mig bibload

4 years agofixed some bugs in mig-xml staged reports looking for old bib_id_map rather than...
Rogan Hamby [Tue, 17 Apr 2018 16:45:00 +0000]
fixed some bugs in mig-xml staged reports looking for old bib_id_map rather than the staged table

4 years agomigration_tools.parse_out_address2 and some fixes to handle_*_barcode
Jason Etheridge [Tue, 17 Apr 2018 14:41:01 +0000]
migration_tools.parse_out_address2 and some fixes to handle_*_barcode

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

4 years agoalternate values for desired_not_migrate
Jason Etheridge [Sun, 15 Apr 2018 19:11:56 +0000]
alternate values for desired_not_migrate

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

4 years agoadding biblio.record_entry to init
Rogan Hamby [Fri, 13 Apr 2018 18:54:05 +0000]
adding biblio.record_entry to init

4 years agoadditional escaping and multiple table options for add_sf9 function
Rogan Hamby [Tue, 10 Apr 2018 18:42:40 +0000]
additional escaping and multiple table options for add_sf9 function

4 years agoadding to add_sf9 that you specifiy the bib table
Rogan Hamby [Tue, 10 Apr 2018 17:48:14 +0000]
adding to add_sf9 that you specifiy the bib table

4 years agosome security checks to make sure tables exist
Rogan Hamby [Tue, 10 Apr 2018 13:01:35 +0000]
some security checks to make sure tables exist

4 years agoadd a loading bibs module for mig
Rogan Hamby [Mon, 9 Apr 2018 23:29:12 +0000]
add a loading bibs module for mig

4 years agoasset stat cat functions
Jason Etheridge [Mon, 9 Apr 2018 06:51:50 +0000]
asset stat cat functions

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

4 years agomigration_tools.handle_org
Jason Etheridge [Mon, 9 Apr 2018 05:14:02 +0000]
migration_tools.handle_org

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

4 years agomigration_tools.handle_status
Jason Etheridge [Mon, 9 Apr 2018 04:08:29 +0000]
migration_tools.handle_status

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

4 years agomore more generic generic convenience function: migration_tools.handle_link2
Jason Etheridge [Mon, 9 Apr 2018 03:42:00 +0000]
more more generic generic convenience function: migration_tools.handle_link2

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

4 years agomore generic convenience function: migration_tools.handle_link
Jason Etheridge [Mon, 9 Apr 2018 03:07:54 +0000]
more generic convenience function: migration_tools.handle_link

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

4 years agomore table linking functions
Jason Etheridge [Thu, 5 Apr 2018 20:53:17 +0000]
more table linking functions

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

4 years agoupdate default wait time to 1 on staged overlay
Rogan Hamby [Tue, 3 Apr 2018 13:07:01 +0000]
update default wait time to 1 on staged overlay

4 years agofix outdated query
Rogan Hamby [Mon, 26 Mar 2018 18:47:42 +0000]
fix outdated query

4 years agonew trigger needs to be disabled for 3.0+ systems
Rogan Hamby [Mon, 26 Mar 2018 16:08:57 +0000]
new trigger needs to be disabled for 3.0+ systems

4 years agospeed improvements in removing circs
Rogan Hamby [Mon, 26 Mar 2018 15:18:01 +0000]
speed improvements in removing circs

4 years agoremoving unneeded file
Rogan Hamby [Tue, 20 Mar 2018 19:30:16 +0000]
removing unneeded file

4 years agomig-reporter can now output excel and has some mapping sheets defined
Rogan Hamby [Tue, 20 Mar 2018 19:19:05 +0000]
mig-reporter can now output excel and has some mapping sheets defined

4 years agosome failover to connect directly by socket if full TCP settings aren't found
Rogan Hamby [Tue, 20 Mar 2018 16:20:25 +0000]
some failover to connect directly by socket if full TCP settings aren't found

4 years agofixed but with mig diing because no environment set when trying to set environment
Rogan Hamby [Tue, 20 Mar 2018 16:19:23 +0000]
fixed but with mig diing because no environment set when trying to set environment

4 years agoMerge branch 'mig_invoking' simplifies the invocating code and provides a fail over...
Rogan Hamby [Tue, 20 Mar 2018 14:50:14 +0000]
Merge branch 'mig_invoking' simplifies the invocating code and provides a fail over to mig commands in profile path

4 years agoadding pod text directly into mig-reporter
Rogan Hamby [Tue, 20 Mar 2018 13:36:13 +0000]
adding pod text directly into mig-reporter

4 years agocleaned up version of arguments
Rogan Hamby [Tue, 20 Mar 2018 13:00:02 +0000]
cleaned up version of arguments

4 years agotypo
Rogan Hamby [Fri, 16 Mar 2018 13:11:12 +0000]
typo

4 years agoadd debug to mig-reporter and make default output easier to read
Rogan Hamby [Fri, 16 Mar 2018 12:45:42 +0000]
add debug to mig-reporter and make default output easier to read

4 years agofixed bug in sql query for a dedupe report
Rogan Hamby [Fri, 16 Mar 2018 12:18:29 +0000]
fixed bug in sql query for a dedupe report

4 years agoadditional string cleanup prevention added to checking table names
Rogan Hamby [Fri, 16 Mar 2018 12:17:08 +0000]
additional string cleanup prevention added to checking table names

4 years agoexpanding dedupe report in stock migration report
Rogan Hamby [Fri, 16 Mar 2018 11:53:09 +0000]
expanding dedupe report in stock migration report

4 years agofixing some tag typos
Rogan Hamby [Thu, 15 Mar 2018 19:26:51 +0000]
fixing some tag typos

4 years agotypo fix
Rogan Hamby [Tue, 13 Mar 2018 18:12:39 +0000]
typo fix

4 years agofix entry in resource mate file
Rogan Hamby [Tue, 13 Mar 2018 18:02:15 +0000]
fix entry in resource mate file

4 years agomaking sure gsheet --export output uses tab delimiter
Rogan Hamby [Tue, 13 Mar 2018 15:24:37 +0000]
making sure gsheet --export output uses tab delimiter

4 years agochange mig gsheet --push to use the tab name
Rogan Hamby [Tue, 13 Mar 2018 13:51:49 +0000]
change mig gsheet --push to use the tab name

4 years agovarious removals of unneeded m_wh and improved push speed
Rogan Hamby [Tue, 13 Mar 2018 13:18:43 +0000]
various removals of unneeded m_wh and improved push speed

4 years agoadded support for export flag
Rogan Hamby [Tue, 13 Mar 2018 12:28:42 +0000]
added support for export flag

4 years agoadded ability to define assets for reporter to read into an output file as sections
Rogan Hamby [Mon, 12 Mar 2018 19:00:10 +0000]
added ability to define assets for reporter to read into an output file as sections

4 years agodeduplication asciidoc
Rogan Hamby [Mon, 12 Mar 2018 18:24:40 +0000]
deduplication asciidoc

4 years agoadding deduping reports to evergreen staged file
Rogan Hamby [Mon, 12 Mar 2018 18:03:52 +0000]
adding deduping reports to evergreen staged file

4 years agomaking checking tables smarter after removing the m_wh uses
Rogan Hamby [Tue, 6 Mar 2018 15:55:31 +0000]
making checking tables smarter after removing the m_wh uses

4 years agoadded thresholds report for test load reports
Rogan Hamby [Tue, 6 Mar 2018 14:28:20 +0000]
added thresholds report for test load reports

4 years agoadding tlc code to billing type table
Rogan Hamby [Tue, 6 Mar 2018 13:58:46 +0000]
adding tlc code to billing type table

4 years agocleanup unneeded condition since removing schemas
Rogan Hamby [Sat, 3 Mar 2018 10:14:22 +0000]
cleanup unneeded condition since removing schemas

4 years agoremoving migschema defs from resource mate xml
Rogan Hamby [Sat, 3 Mar 2018 10:10:38 +0000]
removing migschema defs from resource mate xml

4 years agoadding search path to dbi connect and stripping out schema defs from xml
Rogan Hamby [Sat, 3 Mar 2018 10:09:49 +0000]
adding search path to dbi connect and stripping out schema defs from xml

4 years agoadding legacy value column to stat cats table
Rogan Hamby [Fri, 2 Mar 2018 21:10:20 +0000]
adding legacy value column to stat cats table

4 years agofix syntax in evergreen staged table xml
Rogan Hamby [Fri, 2 Mar 2018 16:41:36 +0000]
fix syntax in evergreen staged table xml

4 years agoadding branch mapping for tlc
Rogan Hamby [Thu, 1 Mar 2018 20:28:44 +0000]
adding branch mapping for tlc

4 years agoremoving phones from tlc mapping
Rogan Hamby [Thu, 1 Mar 2018 18:19:51 +0000]
removing phones from tlc mapping

4 years agoadding variant add subfield 9 that work only on tags with a 856 that matches conditio...
Rogan Hamby [Wed, 28 Feb 2018 20:53:07 +0000]
adding variant add subfield 9 that work only on tags with a 856 that matches condition passed as parameter

4 years agoadding bib manipulations table
Rogan Hamby [Wed, 28 Feb 2018 20:18:25 +0000]
adding bib manipulations table

4 years agomoving org to the holding code table
Rogan Hamby [Wed, 28 Feb 2018 18:26:42 +0000]
moving org to the holding code table

4 years agoadding x_shelf and x_org to the shelving location init table
Rogan Hamby [Wed, 28 Feb 2018 17:59:01 +0000]
adding x_shelf and x_org to the shelving location init table

4 years agoensure we don't use deleted copy locations
Jason Etheridge [Tue, 27 Feb 2018 21:26:09 +0000]
ensure we don't use deleted copy locations

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

4 years agofind shelf function
Rogan Hamby [Tue, 27 Feb 2018 20:59:12 +0000]
find shelf function

4 years agofixing column name in common gsheet tables
Rogan Hamby [Tue, 27 Feb 2018 20:16:54 +0000]
fixing column name in common gsheet tables

4 years agochanges to make some tables child tables
Rogan Hamby [Tue, 27 Feb 2018 19:28:59 +0000]
changes to make some tables child tables

4 years agoadding text string for mig sql via :migschema_text
Rogan Hamby [Tue, 27 Feb 2018 17:57:45 +0000]
adding text string for mig sql via :migschema_text

4 years agoupdating column name from copy_location to desired_shelf to match mig tools
Rogan Hamby [Tue, 27 Feb 2018 17:04:22 +0000]
updating column name from copy_location to desired_shelf to match mig tools

4 years agoadding load report file for resource mate
Rogan Hamby [Tue, 27 Feb 2018 16:34:46 +0000]
adding load report file for resource mate