migration-tools.git
6 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>

6 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>

6 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>

6 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>

6 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

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

6 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

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

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

6 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

6 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

6 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

6 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

6 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

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

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

6 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

6 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

6 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

6 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

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

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

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

6 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

6 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

6 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

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

6 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

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

6 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

6 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

6 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

6 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

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

6 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

6 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

6 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

6 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

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

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

6 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

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

6 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

6 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

6 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>

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

6 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

6 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

6 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

6 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

6 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

6 years agofixing some tlc maapping table bugs
Rogan Hamby [Tue, 27 Feb 2018 16:34:04 +0000]
fixing some tlc maapping table bugs

6 years agotaking out some dumper statements for troubleshooting that I had commented out
Rogan Hamby [Tue, 27 Feb 2018 16:09:29 +0000]
taking out some dumper statements for troubleshooting that I had commented out

6 years agoimproving tool tip
Rogan Hamby [Tue, 27 Feb 2018 14:26:19 +0000]
improving tool tip

6 years agofixed bug with not all tags converting to lowercase
Rogan Hamby [Mon, 26 Feb 2018 21:02:20 +0000]
fixed bug with not all tags converting to lowercase

6 years agoreplacing mig_schema with MIGSCHEMA per IRC decision
Rogan Hamby [Mon, 26 Feb 2018 20:54:48 +0000]
replacing mig_schema with MIGSCHEMA per IRC decision

6 years agofixed pathing issue with finding xml files
Rogan Hamby [Mon, 26 Feb 2018 20:45:12 +0000]
fixed pathing issue with finding xml files

6 years agomigration_tools.handle_actor_sc_and_sce
Jason Etheridge [Mon, 26 Feb 2018 05:38:12 +0000]
migration_tools.handle_actor_sc_and_sce

and migration_tools.vivicate_actor_sc_and_sce, though may want to tweak the
former to invoke the latter

This incarnation takes an org shortname as the last argument, but I want to
make a variant that looks for x_org in case we're doing branch level stat
cats, etc.

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

6 years agomigration_tools.handle_profile
Jason Etheridge [Mon, 26 Feb 2018 04:33:35 +0000]
migration_tools.handle_profile

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

6 years agomigration_tools.handle_not_migrate
Jason Etheridge [Mon, 26 Feb 2018 04:27:10 +0000]
migration_tools.handle_not_migrate

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

6 years agomigration_tools.handle_circmod
Jason Etheridge [Mon, 26 Feb 2018 04:10:28 +0000]
migration_tools.handle_circmod

for example:

select migration_tools.handle_circmod(:'migschema','map_item_l_location_clean');

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

6 years agomigration_tools.handle_shelf
Jason Etheridge [Mon, 26 Feb 2018 04:02:42 +0000]
migration_tools.handle_shelf

for example:

mig sql -c "select migration_tools.handle_shelf(:'migschema','map_item_l_location_clean','ORGSHORTNAME',1);"

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

6 years agosupport for some argument pass-thru for mig-quick
Jason Etheridge [Mon, 26 Feb 2018 02:30:32 +0000]
support for some argument pass-thru for mig-quick

6 years agomig-quick for doing the add/skip-iconv/clean/convert/stage dance without any argument...
Jason Etheridge [Sun, 25 Feb 2018 23:02:16 +0000]
mig-quick for doing the add/skip-iconv/clean/convert/stage dance without any arguments (for now)

6 years agodefault to tab for field separator for unaligned text
Jason Etheridge [Tue, 20 Feb 2018 16:54:46 +0000]
default to tab for field separator for unaligned text

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

6 years agotruncate field names here for now for WriteExcel
Jason Etheridge [Fri, 16 Feb 2018 21:29:34 +0000]
truncate field names here for now for WriteExcel

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

6 years agoconsolidating tracking tables for gsheet
Rogan Hamby [Fri, 16 Feb 2018 21:25:37 +0000]
consolidating tracking tables for gsheet

6 years agomoving tlc init file
Rogan Hamby [Fri, 16 Feb 2018 20:26:30 +0000]
moving tlc init file

6 years agotlc mapping sql
Rogan Hamby [Fri, 16 Feb 2018 19:33:23 +0000]
tlc mapping sql

6 years agorolling back some changes I made
Rogan Hamby [Fri, 16 Feb 2018 19:33:00 +0000]
rolling back some changes I made

6 years agoadjusted universal files to no longer need fields from tracked tables that were dropped
Rogan Hamby [Fri, 16 Feb 2018 19:15:51 +0000]
adjusted universal files to no longer need fields from tracked tables that were dropped

6 years agomaking the common tables more mig sql smart
Rogan Hamby [Fri, 16 Feb 2018 17:29:51 +0000]
making the common tables more mig sql smart

6 years agoadd migscheam local variable to invocation
Rogan Hamby [Fri, 16 Feb 2018 17:23:37 +0000]
add migscheam local variable to invocation

6 years agocommenting out the other way of invoking path
Rogan Hamby [Fri, 16 Feb 2018 16:52:11 +0000]
commenting out the other way of invoking path

6 years agoadd mig-sql the show path
Rogan Hamby [Fri, 16 Feb 2018 16:36:13 +0000]
add mig-sql the show path

6 years agocommon tables that will be used by gsheet
Rogan Hamby [Fri, 16 Feb 2018 16:08:08 +0000]
common tables that will be used by gsheet

6 years agomoving config into else clause for cleanliness
Rogan Hamby [Mon, 12 Feb 2018 19:17:33 +0000]
moving config into else clause for cleanliness

6 years agofixing typo and moving grab file into else clause
Rogan Hamby [Mon, 12 Feb 2018 19:16:37 +0000]
fixing typo and moving grab file into else clause

6 years agomade csv2sql mig aware
Rogan Hamby [Mon, 12 Feb 2018 16:50:21 +0000]
made csv2sql mig aware

6 years agoadding a report package for an overview of system data like that done in migrations
Rogan Hamby [Mon, 12 Feb 2018 16:02:31 +0000]
adding a report package for an overview of system data like that done in migrations

6 years agofix typo and add some security to output format
Rogan Hamby [Sun, 11 Feb 2018 23:07:46 +0000]
fix typo and add some security to output format

6 years agofixing doc
Rogan Hamby [Fri, 9 Feb 2018 22:04:16 +0000]
fixing doc

6 years agominor fixes to gsheet
Rogan Hamby [Fri, 9 Feb 2018 20:59:45 +0000]
minor fixes to gsheet

6 years agoadding the mig gsheet main file
Rogan Hamby [Fri, 9 Feb 2018 20:46:26 +0000]
adding the mig gsheet main file

6 years agoadding mig gsheet
Rogan Hamby [Fri, 9 Feb 2018 20:46:05 +0000]
adding mig gsheet

6 years agoclean up reporter share withs in remove ou scripts
Rogan Hamby [Fri, 9 Feb 2018 15:09:03 +0000]
clean up reporter share withs in remove ou scripts

6 years agostart of serial script in remove ou
Rogan Hamby [Fri, 9 Feb 2018 14:44:19 +0000]
start of serial script in remove ou

6 years agostart of distinct acq removal file
Rogan Hamby [Fri, 9 Feb 2018 13:44:59 +0000]
start of distinct acq removal file

6 years agoadmin user sanity check added to remove ou scripts
Rogan Hamby [Fri, 9 Feb 2018 13:23:52 +0000]
admin user sanity check added to remove ou scripts

6 years agomaking the user delete information a bit more robust
Rogan Hamby [Fri, 9 Feb 2018 13:18:14 +0000]
making the user delete information a bit more robust

6 years agomoving some cross saved templates and output folders
Rogan Hamby [Fri, 9 Feb 2018 13:14:37 +0000]
moving some cross saved templates and output folders

6 years agoadded location for added page file to be miggitdir
Rogan Hamby [Thu, 8 Feb 2018 19:51:49 +0000]
added location for added page file to be miggitdir

6 years agoadded reporter documentation to mig
Rogan Hamby [Thu, 8 Feb 2018 19:49:25 +0000]
added reporter documentation to mig

6 years agoinitial working branch for mig reporter
Rogan Hamby [Thu, 8 Feb 2018 19:39:22 +0000]
initial working branch for mig reporter

6 years agoadd removal of copy tag stuff from remove ou scripts
Rogan Hamby [Wed, 31 Jan 2018 13:47:22 +0000]
add removal of copy tag stuff from remove ou scripts

6 years agoadding last pushed timestamp to gsheet tracked table
Rogan Hamby [Tue, 30 Jan 2018 14:24:58 +0000]
adding last pushed timestamp to gsheet tracked table

6 years agoadd unique constraint for worksheet and tab name in ghseet tracked table
Rogan Hamby [Tue, 30 Jan 2018 14:23:34 +0000]
add unique constraint for worksheet and tab name in ghseet tracked table

6 years agoadding primary key to gsheet_tracked_table
Rogan Hamby [Tue, 30 Jan 2018 14:15:17 +0000]
adding primary key to gsheet_tracked_table

6 years agoMerge branch 'master' of git.esilibrary.com:migration-tools
Rogan Hamby [Mon, 29 Jan 2018 20:54:13 +0000]
Merge branch 'master' of git.esilibrary.com:migration-tools

6 years agogsheet blobs for mig init directory
Rogan Hamby [Mon, 29 Jan 2018 20:53:54 +0000]
gsheet blobs for mig init directory