migration-tools.git
5 years agobetter usps suffix handling
Jason Etheridge [Thu, 10 Jan 2019 15:14:30 +0000]
better usps suffix handling

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

5 years agoadd x_org logic to handle_shelf
Jason Etheridge [Wed, 9 Jan 2019 19:35:52 +0000]
add x_org logic to handle_shelf

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

5 years agomigration_tools.normalize_address_suffix
Jason Etheridge [Wed, 9 Jan 2019 19:29:43 +0000]
migration_tools.normalize_address_suffix

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

5 years agomigration_tools.split_rows_on_column_with_delimiter
Jason Etheridge [Mon, 7 Jan 2019 20:03:20 +0000]
migration_tools.split_rows_on_column_with_delimiter

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

5 years agomigration_tools.name_parse_out_first_middle_last_comma_suffix
Jason Etheridge [Tue, 18 Dec 2018 00:25:57 +0000]
migration_tools.name_parse_out_first_middle_last_comma_suffix

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

5 years agotool to spit out records that contain the tag/subfield/value combination provided
Jason Etheridge [Tue, 4 Dec 2018 17:23:47 +0000]
tool to spit out records that contain the tag/subfield/value combination provided

5 years agoremove serial reports
Rogan Hamby [Wed, 7 Nov 2018 17:04:47 +0000]
remove serial reports

5 years agohandle ambiguity
Jason Etheridge [Fri, 5 Oct 2018 19:22:58 +0000]
handle ambiguity

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

5 years agomoar columns for bre
Jason Etheridge [Tue, 2 Oct 2018 17:49:45 +0000]
moar columns for bre

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

5 years agomig-reporter will now look for a file in the working directory if it's not in migrati...
Rogan Hamby [Mon, 17 Sep 2018 19:57:51 +0000]
mig-reporter will now look for a file in the working directory if it's not in migration-tools/mig-xml/

5 years agoadded documentation to mig-reporter for the captions feature
Rogan Hamby [Mon, 17 Sep 2018 18:52:00 +0000]
added documentation to mig-reporter for the captions feature

5 years agoadd ability to turn captions off in asciidoc with --captions_off parameter
Rogan Hamby [Mon, 17 Sep 2018 18:50:12 +0000]
add ability to turn captions off in asciidoc with --captions_off parameter

5 years agooauth.env no longer uses the export command and they are no longer read as environmen...
Rogan Hamby [Thu, 6 Sep 2018 20:19:53 +0000]
oauth.env no longer uses the export command and they are no longer read as environmental variables, also the optional --authfile is now accepted as a parameter for the file in any location

5 years agofix bug in vivicate for stat cat entries
Jason Etheridge [Tue, 4 Sep 2018 09:59:09 +0000]
fix bug in vivicate for stat cat entries

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

5 years agomigration_tools.handle_link3_skip_false
Jason Etheridge [Tue, 4 Sep 2018 09:12:46 +0000]
migration_tools.handle_link3_skip_false

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

5 years agomigration_tools.handle_barred_or_blocked
Jason Etheridge [Tue, 4 Sep 2018 08:20:33 +0000]
migration_tools.handle_barred_or_blocked

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

5 years agowe need some type-aware functions, but for now...
Jason Etheridge [Tue, 4 Sep 2018 06:09:28 +0000]
we need some type-aware functions, but for now...

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

5 years agomigration_tools.handle_link3_skip_true, and remove potential for ambiguous columns...
Jason Etheridge [Tue, 4 Sep 2018 05:53:28 +0000]
migration_tools.handle_link3_skip_true, and remove potential for ambiguous columns for all handle_link*

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

5 years agomigration_tools.handle_link3_concat_skip_null
Jason Etheridge [Tue, 4 Sep 2018 05:46:04 +0000]
migration_tools.handle_link3_concat_skip_null

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

5 years agomigration_tools.handle_link3_skip_null
Jason Etheridge [Tue, 4 Sep 2018 05:38:35 +0000]
migration_tools.handle_link3_skip_null

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

5 years agono btrim for handle_link3
Jason Etheridge [Tue, 4 Sep 2018 05:28:32 +0000]
no btrim for handle_link3

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

5 years agohandle_link3
Jason Etheridge [Tue, 4 Sep 2018 05:27:29 +0000]
handle_link3

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

5 years agohobgoblins, consistency
Jason Etheridge [Tue, 4 Sep 2018 03:52:05 +0000]
hobgoblins, consistency

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

5 years agoadding default schema name as sheet for common tables
Rogan Hamby [Fri, 31 Aug 2018 19:01:10 +0000]
adding default schema name as sheet for common tables

5 years agoadding sheet tracking to the common tables sql
Rogan Hamby [Fri, 31 Aug 2018 18:44:41 +0000]
adding sheet tracking to the common tables sql

5 years agoremoving redundant env declaration
Rogan Hamby [Fri, 31 Aug 2018 18:39:52 +0000]
removing redundant env declaration

5 years agofix apply_circ_matrix_to_specific_circ
Jason Etheridge [Thu, 23 Aug 2018 20:14:05 +0000]
fix apply_circ_matrix_to_specific_circ

when hitting an item price based max fine rule for an item with no price

we're still using the asset.copy table here and not asset_copy

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

5 years agoadding libraries to the gsheet for patron thresholds
Rogan Hamby [Wed, 15 Aug 2018 14:00:40 +0000]
adding libraries to the gsheet for patron thresholds

5 years ago added function to trim and null out all columns, useful when importing from reports
Rogan Hamby [Mon, 13 Aug 2018 19:27:54 +0000]
 added function to trim and null out all columns, useful when importing from reports

5 years agoupdating create accounts table to match latest sheet format used by PM
Rogan Hamby [Fri, 10 Aug 2018 14:36:23 +0000]
updating create accounts table to match latest sheet format used by PM

5 years agocleaning up bib report and adding source column to it
Rogan Hamby [Wed, 8 Aug 2018 17:45:45 +0000]
cleaning up bib report and adding source column to it

5 years agoadding precats to assets report
Rogan Hamby [Wed, 8 Aug 2018 17:36:27 +0000]
adding precats to assets report

5 years agowrapping some calls in eval to safeguard bad records crashing load
Rogan Hamby [Tue, 7 Aug 2018 19:59:53 +0000]
wrapping some calls in eval to safeguard bad records crashing load

5 years agoadding support to the circ policies table for more circ limit set munging
Rogan Hamby [Fri, 3 Aug 2018 20:10:48 +0000]
adding support to the circ policies table for more circ limit set munging

5 years agoadding circ limit sets table
Rogan Hamby [Fri, 3 Aug 2018 19:53:41 +0000]
adding circ limit sets table

5 years agofixing typo
Rogan Hamby [Fri, 3 Aug 2018 18:16:40 +0000]
fixing typo

5 years agoredoing the holds mapping table
Rogan Hamby [Fri, 3 Aug 2018 17:56:28 +0000]
redoing the holds mapping table

5 years agorebuild of derived values columns for map_circ_polices
Rogan Hamby [Thu, 2 Aug 2018 18:33:45 +0000]
rebuild of derived values columns for map_circ_polices

5 years agonew verion of circ policies map table
Rogan Hamby [Thu, 2 Aug 2018 18:05:23 +0000]
new verion of circ policies map table

5 years agobugfix to bib loading
Rogan Hamby [Thu, 26 Jul 2018 20:21:17 +0000]
bugfix to bib loading

5 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

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

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

5 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

5 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

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

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

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

5 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

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

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

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

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

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

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

5 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

5 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

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

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

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

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

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

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

5 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

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

5 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

5 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

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

5 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

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

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

5 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

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

5 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

5 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

5 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

5 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

5 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

5 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

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

6 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

6 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

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

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

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

6 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

6 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

6 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

6 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

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

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

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