migration-tools.git
2 weeks agoearly version of a mig pg_dump, untested so far master
Rogan Hamby [Tue, 9 Apr 2019 20:14:17 +0000]
early version of a mig pg_dump, untested so far

2 weeks 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

2 weeks 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

2 weeks 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

4 weeks 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

4 weeks 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

4 weeks 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

5 weeks 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 weeks agoadd new munge_sf9 function
Rogan Hamby [Tue, 26 Feb 2019 12:56:28 +0000]
add new munge_sf9 function

8 weeks 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

2 months agoavoid trimming trailing empty fields
Jason Etheridge [Wed, 20 Feb 2019 03:28:36 +0000]
avoid trimming trailing empty fields

3 months agoadd asset.copy_alert to default base staging tables
Jason Etheridge [Mon, 21 Jan 2019 05:42:33 +0000]
add asset.copy_alert to default base staging tables

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

3 months agoimperfect but good enough handling of array datatypes for create_linked_legacy_table_from
Jason Etheridge [Sat, 19 Jan 2019 22:31:31 +0000]
imperfect but good enough handling of array datatypes for create_linked_legacy_table_from

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

3 months agomigration_tools.create_linked_legacy_table_from
Jason Etheridge [Sat, 19 Jan 2019 22:03:31 +0000]
migration_tools.create_linked_legacy_table_from

for working outside of mig link/convert

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

3 months agobetter usps suffix handling
Jason Etheridge [Thu, 10 Jan 2019 15:49:41 +0000]
better usps suffix handling

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

3 months 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>

3 months 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>

3 months 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>

3 months 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>

4 months 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>

4 months 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 months agoremove serial reports
Rogan Hamby [Wed, 7 Nov 2018 17:04:47 +0000]
remove serial reports

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

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

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

7 months 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/

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

8 months 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>

8 months 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

8 months 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

8 months 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

8 months 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

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

8 months 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

8 months 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

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

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

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

8 months 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

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

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

9 months agomade loadbibs able to load any table
Rogan Hamby [Thu, 26 Jul 2018 20:03:59 +0000]
made loadbibs able to load any table

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

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

10 months 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

10 months 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

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

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

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

10 months 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

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

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

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

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

10 months 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>

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

10 months 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

10 months 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

10 months 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>

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

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

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

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

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

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

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

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

10 months 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

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

11 months 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

11 months 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

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

11 months 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

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

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

11 months 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

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

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

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

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

12 months 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

12 months 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

12 months 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

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

12 months 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

12 months 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

12 months 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>

12 months 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>

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

12 months 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

12 months 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