migration-tools.git
3 years agokoha function for updating the 003 tag
Jason Etheridge [Tue, 9 Jun 2020 19:35:29 +0000]
koha function for updating the 003 tag

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

3 years agofixed help error in mig-stagebibs for emig
Rogan Hamby [Mon, 8 Jun 2020 16:42:25 +0000]
fixed help error in mig-stagebibs for emig

3 years agofixing on mung_sf9 where it declares int instead of bigint for bib ids
Rogan Hamby [Mon, 8 Jun 2020 16:19:10 +0000]
fixing on mung_sf9 where it declares int instead of bigint for bib ids

3 years agoadding a strip subfield function
Rogan Hamby [Mon, 8 Jun 2020 16:17:59 +0000]
adding a strip subfield function

3 years agomig-import missed a clause for deleting from the itemtypes table
Rogan Hamby [Wed, 3 Jun 2020 15:39:14 +0000]
mig-import missed a clause for deleting from the itemtypes table

3 years agofixed xpath issues with restore_itemtypes
Rogan Hamby [Wed, 3 Jun 2020 15:10:41 +0000]
fixed xpath issues with restore_itemtypes

3 years agoadded to kmig bookseller and budget support to import and export
Rogan Hamby [Tue, 2 Jun 2020 20:15:34 +0000]
added to kmig bookseller and budget support to import and export

3 years agoadding the start of base sql and marc functions for koha to mig-init
Rogan Hamby [Tue, 2 Jun 2020 13:49:23 +0000]
adding the start of base sql and marc functions for koha to mig-init

3 years agoadding the start of base sql and marc functions for koha to mig-init
Rogan Hamby [Tue, 2 Jun 2020 13:49:08 +0000]
adding the start of base sql and marc functions for koha to mig-init

3 years agobase staging tables for koha added for kmig.d/init
Rogan Hamby [Tue, 2 Jun 2020 13:42:49 +0000]
base staging tables for koha added for kmig.d/init

3 years agoreplace borrower_attributes with borrowerattributes for file name in mig-export
Rogan Hamby [Thu, 28 May 2020 17:46:35 +0000]
replace borrower_attributes with borrowerattributes for file name in mig-export

3 years agoadding borrower attributes to mig import/export
Rogan Hamby [Wed, 27 May 2020 20:33:51 +0000]
adding borrower attributes to mig import/export

3 years agoadding m_ for koha functions and an update_leader function
Rogan Hamby [Wed, 27 May 2020 15:52:37 +0000]
adding m_ for koha functions and an update_leader function

3 years agokmig import/export now support syncing reports
Rogan Hamby [Thu, 21 May 2020 20:58:28 +0000]
kmig import/export now support syncing reports

3 years agovarious enhacnements to emig bibstats including adding it to kmig
Rogan Hamby [Tue, 19 May 2020 20:16:03 +0000]
various enhacnements to emig bibstats including adding it to kmig

3 years agoadded profile for Destiny to mig bibstats
Rogan Hamby [Tue, 19 May 2020 17:21:33 +0000]
added profile for Destiny to mig bibstats

3 years agoadjust -test components of kohacatalog.com domains in kmig import
Rogan Hamby [Thu, 7 May 2020 14:41:01 +0000]
adjust -test components of kohacatalog.com domains in kmig import

3 years agoadd some new koha reports
Rogan Hamby [Tue, 5 May 2020 19:17:01 +0000]
add some new koha reports

3 years agochange default behavior for no --analyst tag
Rogan Hamby [Mon, 4 May 2020 19:33:36 +0000]
change default behavior for no --analyst tag

3 years agoset ->do('SET NAMES utf8mb4'); by default
Rogan Hamby [Mon, 4 May 2020 15:50:38 +0000]
set ->do('SET NAMES utf8mb4'); by default

3 years agomore robust versions of kmig import and export
Rogan Hamby [Mon, 4 May 2020 15:49:40 +0000]
more robust versions of kmig import and export

3 years agosimplify a few exports and add one for itemtypes
Rogan Hamby [Wed, 22 Apr 2020 19:10:20 +0000]
simplify a few exports and add one for itemtypes

3 years agoupdated mig export to use xml and mig import supports libraries and preferences
Rogan Hamby [Wed, 22 Apr 2020 17:57:34 +0000]
updated mig export to use xml and mig import supports libraries and preferences

3 years agoupdated mig export to use xml and mig import supports libraries and preferences
Rogan Hamby [Wed, 22 Apr 2020 17:57:22 +0000]
updated mig export to use xml and mig import supports libraries and preferences

4 years agoinitial version of mig-export added for kmig
Rogan Hamby [Fri, 17 Apr 2020 16:22:50 +0000]
initial version of mig-export added for kmig

4 years agounneeded variable declaration removed
Rogan Hamby [Thu, 16 Apr 2020 18:54:00 +0000]
unneeded variable declaration removed

4 years agoremoving no longer needed parameter
Rogan Hamby [Thu, 16 Apr 2020 18:51:43 +0000]
removing no longer needed parameter

4 years agodon't index x_count if we see it
Jason Etheridge [Thu, 16 Apr 2020 14:38:14 +0000]
don't index x_count if we see it

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

4 years agodefault charset and collate for csv2mysql
Jason Etheridge [Thu, 16 Apr 2020 14:36:45 +0000]
default charset and collate for csv2mysql

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

4 years agofirst cut of kmig-quick
Jason Etheridge [Thu, 16 Apr 2020 13:48:16 +0000]
first cut of kmig-quick

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

4 years agoseed kmig-quick with emig-quick
Jason Etheridge [Thu, 16 Apr 2020 13:47:29 +0000]
seed kmig-quick with emig-quick

4 years agoif we come across these, make them BIGINT. mysql/mariadb can't index TEXT
Jason Etheridge [Wed, 15 Apr 2020 20:32:46 +0000]
if we come across these, make them BIGINT. mysql/mariadb can't index TEXT

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

4 years agomake sure worksheet names do not go over 31 characters
Jason Etheridge [Wed, 15 Apr 2020 20:31:11 +0000]
make sure worksheet names do not go over 31 characters

4 years agosimplifying defaults a bit
Rogan Hamby [Wed, 15 Apr 2020 18:11:06 +0000]
simplifying defaults a bit

4 years agoadding kmig reporter
Rogan Hamby [Wed, 15 Apr 2020 18:09:17 +0000]
adding kmig reporter

4 years agowe don't need to pre-create Koha staging tables since mig link and mig stage can... kmig
Jason Etheridge [Fri, 10 Apr 2020 21:00:42 +0000]
we don't need to pre-create Koha staging tables since mig link and mig stage can do it

4 years agofirst cut of kmig-stage, and tweak kmig-link to allow linking to non-existent parent...
Jason Etheridge [Fri, 10 Apr 2020 21:00:12 +0000]
first cut of kmig-stage, and tweak kmig-link to allow linking to non-existent parent tables, since based on the naming convention we can vivicate them

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

4 years agoseed kmig-stage with emig-stage
Jason Etheridge [Fri, 10 Apr 2020 20:48:24 +0000]
seed kmig-stage with emig-stage

4 years agofirst cut of csv2mysql, mig-convert, and a needed tweak for mig-sql
Jason Etheridge [Fri, 10 Apr 2020 20:47:09 +0000]
first cut of csv2mysql, mig-convert, and a needed tweak for mig-sql

4 years agomove csv2mysql into the kmig hierarchy so we can better leverage KMig.pm
Jason Etheridge [Fri, 10 Apr 2020 20:03:57 +0000]
move csv2mysql into the kmig hierarchy so we can better leverage KMig.pm

4 years agoseed csv2mysql with csv2sql
Jason Etheridge [Fri, 10 Apr 2020 20:01:53 +0000]
seed csv2mysql with csv2sql

4 years agoseed kmig-convert with emig-convert
Jason Etheridge [Fri, 10 Apr 2020 19:53:43 +0000]
seed kmig-convert with emig-convert

4 years agofirst cut of kmig-unlink
Jason Etheridge [Fri, 10 Apr 2020 19:31:31 +0000]
first cut of kmig-unlink

4 years agoseed kmig-unlink with emig-unlink
Jason Etheridge [Fri, 10 Apr 2020 19:29:44 +0000]
seed kmig-unlink with emig-unlink

4 years agofirst cut of kmig-link
Jason Etheridge [Fri, 10 Apr 2020 19:29:18 +0000]
first cut of kmig-link

4 years agoseed kmig-link with emig-link
Jason Etheridge [Fri, 10 Apr 2020 19:21:48 +0000]
seed kmig-link with emig-link

4 years agomore path touchups
Jason Etheridge [Fri, 10 Apr 2020 19:20:37 +0000]
more path touchups

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

4 years agomig wrapper to kmig/emig
Jason Etheridge [Fri, 10 Apr 2020 18:44:58 +0000]
mig wrapper to kmig/emig

It won't handle first time setup; you'll need to call emig or kmig explicitly
until an environment is loaded.

Example:

    kmig env create demo
    kmig env use demo
    mig init
    mig add foo.txt etc

Also, the older ~/.mig environment directory, if used with the new mig, will
need to be moved or merged into ~/.emig, and the various *.env files ammended
with:

    export MIGCMD=emig

4 years agorewire to match the new naming scheme and layout
Jason Etheridge [Fri, 10 Apr 2020 18:28:17 +0000]
rewire to match the new naming scheme and layout

4 years agolet's not name these differently than the emig.d/ counterparts
Jason Etheridge [Fri, 10 Apr 2020 18:13:08 +0000]
let's not name these differently than the emig.d/ counterparts

4 years agotoward renaming mig to emig and tweaking the directory layout
Jason Etheridge [Fri, 10 Apr 2020 18:05:56 +0000]
toward renaming mig to emig and tweaking the directory layout

4 years agofirst cuts of kmig-*iconv
Jason Etheridge [Fri, 10 Apr 2020 17:57:28 +0000]
first cuts of kmig-*iconv

4 years agoseed kmig-*iconv with mig-*iconv
Jason Etheridge [Fri, 10 Apr 2020 17:54:59 +0000]
seed kmig-*iconv with mig-*iconv

4 years agofirst cut of kmig-clean
Jason Etheridge [Fri, 10 Apr 2020 17:54:19 +0000]
first cut of kmig-clean

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

4 years agoseed kmig-clean with mig-clean
Jason Etheridge [Fri, 10 Apr 2020 17:51:52 +0000]
seed kmig-clean with mig-clean

4 years agofirst cut of kmig-status
Jason Etheridge [Fri, 10 Apr 2020 16:21:19 +0000]
first cut of kmig-status

4 years agoseed kmig-status from mig-status
Jason Etheridge [Fri, 10 Apr 2020 16:20:10 +0000]
seed kmig-status from mig-status

4 years agofirst cut of kmig-remove
Jason Etheridge [Fri, 10 Apr 2020 16:18:53 +0000]
first cut of kmig-remove

4 years agoseed kmig-remove from mig-remove
Jason Etheridge [Fri, 10 Apr 2020 16:15:55 +0000]
seed kmig-remove from mig-remove

4 years agofirst cut of kmig-add
Jason Etheridge [Fri, 10 Apr 2020 16:13:45 +0000]
first cut of kmig-add

4 years agoseed kmig-add from mig-add
Jason Etheridge [Fri, 10 Apr 2020 16:10:08 +0000]
seed kmig-add from mig-add

4 years agoremove the migration-tools expectation for kmig
Jason Etheridge [Fri, 10 Apr 2020 16:06:29 +0000]
remove the migration-tools expectation for kmig

4 years agofirst cut of kmig-init
Jason Etheridge [Fri, 10 Apr 2020 15:43:43 +0000]
first cut of kmig-init

4 years agokmig-sql: kthere IS a way to pass session variables from the command-line and still...
Jason Etheridge [Fri, 10 Apr 2020 15:22:43 +0000]
kmig-sql: kthere IS a way to pass session variables from the command-line and still get a shell

4 years agoseed kmig-init from mig-init
Jason Etheridge [Fri, 10 Apr 2020 02:31:01 +0000]
seed kmig-init from mig-init

4 years agofirst cut off kmig-sql, and a needed fix to kmig
Jason Etheridge [Fri, 10 Apr 2020 02:29:59 +0000]
first cut off kmig-sql, and a needed fix to kmig

4 years agoseed kmig-sql from mig-sql
Jason Etheridge [Fri, 10 Apr 2020 02:04:17 +0000]
seed kmig-sql from mig-sql

4 years agofirst cut of kmig-env, and KMig.pm comment tweak
Jason Etheridge [Thu, 9 Apr 2020 21:51:54 +0000]
first cut of kmig-env, and KMig.pm comment tweak

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

4 years agoseed kmig-env from mig-env
Jason Etheridge [Thu, 9 Apr 2020 20:17:50 +0000]
seed kmig-env from mig-env

4 years agofirst cut of KMig.pm
Jason Etheridge [Thu, 9 Apr 2020 20:13:06 +0000]
first cut of KMig.pm

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

4 years agofirst cut of kmig
Jason Etheridge [Tue, 7 Apr 2020 20:49:36 +0000]
first cut of kmig

4 years agoseed KMig.pm with Mig.pm
Jason Etheridge [Tue, 7 Apr 2020 20:46:41 +0000]
seed KMig.pm with Mig.pm

4 years agoseed kmig with mig
Jason Etheridge [Tue, 7 Apr 2020 20:20:18 +0000]
seed kmig with mig

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

4 years agoadd a tab listing up to 65k rows of the actual data being summarized. Only for excel...
Jason Etheridge [Tue, 31 Mar 2020 20:14:00 +0000]
add a tab listing up to 65k rows of the actual data being summarized.  Only for excel, not the SQL output

4 years agofor convenience, add some other values to handle_not_migrate
Jason Etheridge [Mon, 23 Mar 2020 16:52:12 +0000]
for convenience, add some other values to handle_not_migrate

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

4 years agotesting for == 0
Rogan Hamby [Thu, 19 Mar 2020 13:27:55 +0000]
testing for  == 0

4 years ago--ignore_filetype flag added
Rogan Hamby [Fri, 6 Mar 2020 22:10:16 +0000]
--ignore_filetype flag added

4 years agocleaned up docs
Rogan Hamby [Fri, 6 Mar 2020 19:21:08 +0000]
cleaned up docs

4 years agoadd ability to specify div height and width from xml and donut chart type
Rogan Hamby [Fri, 6 Mar 2020 19:12:24 +0000]
add ability to specify div height and width from xml and donut chart type

4 years agofurther enchancements to mig-bibstats
Rogan Hamby [Thu, 5 Mar 2020 18:26:30 +0000]
further enchancements to mig-bibstats

4 years agostart of bibstats
Rogan Hamby [Thu, 5 Mar 2020 00:41:32 +0000]
start of bibstats

4 years agosample pie chart report
Rogan Hamby [Wed, 19 Feb 2020 16:56:00 +0000]
sample pie chart report

4 years agoadded pie chart support
Rogan Hamby [Wed, 19 Feb 2020 16:52:06 +0000]
added pie chart support

4 years agofixing label
Rogan Hamby [Mon, 17 Feb 2020 17:14:44 +0000]
fixing label

4 years agofields_requiring_mapping was removed
Jason Etheridge [Mon, 10 Feb 2020 16:35:47 +0000]
fields_requiring_mapping was removed

4 years agoremoving bracketed text
Rogan Hamby [Fri, 7 Feb 2020 16:18:36 +0000]
removing bracketed text

4 years agocounting segments of string by delimiter
Rogan Hamby [Fri, 7 Feb 2020 14:41:16 +0000]
counting segments of string by delimiter

4 years agoadding mariadb/mysql functions file starting with split_string
Rogan Hamby [Fri, 7 Feb 2020 14:37:14 +0000]
adding mariadb/mysql functions file starting with split_string

4 years agochange biblio_record_foo to m_biblo_record_foo in fixed field where necessary
Rogan Hamby [Wed, 29 Jan 2020 16:11:35 +0000]
change biblio_record_foo to m_biblo_record_foo in fixed field where necessary

4 years agoadding billing report for horizon from database extracts
Rogan Hamby [Fri, 24 Jan 2020 16:13:29 +0000]
adding billing report for horizon from database extracts

4 years agofixing errant line
Rogan Hamby [Thu, 23 Jan 2020 14:25:20 +0000]
fixing errant line

4 years agofixed merge conflict
Rogan Hamby [Thu, 23 Jan 2020 14:23:14 +0000]
fixed merge conflict

4 years agochanges to notification reports
Rogan Hamby [Thu, 23 Jan 2020 14:21:26 +0000]
changes to notification reports

4 years agofixing boolean to be more readable in report
Rogan Hamby [Thu, 23 Jan 2020 14:19:23 +0000]
fixing boolean to be more readable in report

4 years agofixed column issue with a report
Rogan Hamby [Wed, 22 Jan 2020 17:37:45 +0000]
fixed column issue with a report

4 years ago added ability to have reporter create and cleanup tables and added gov and freading...
Rogan Hamby [Wed, 22 Jan 2020 17:26:27 +0000]
 added ability to have reporter create and cleanup tables and added gov and freading to report for uris

4 years agoadded report for electronic services
Rogan Hamby [Wed, 22 Jan 2020 16:50:40 +0000]
added report for electronic services

4 years agomitigate chance for ambiguous column references TODO: I'm sure there's a better way...
Jason Etheridge [Tue, 21 Jan 2020 04:11:08 +0000]
mitigate chance for ambiguous column references TODO: I'm sure there's a better way to do this

4 years agosome extra arguments for mig-stagebibs to make it easier to, for example, load patron...
Jason Etheridge [Tue, 21 Jan 2020 04:03:28 +0000]
some extra arguments for mig-stagebibs to make it easier to, for example, load patrons from MARC--yes, you heard that right--to m_actor_usr_legacy

4 years agoadding missing x_migrate filter
Rogan Hamby [Tue, 14 Jan 2020 18:31:05 +0000]
adding missing x_migrate filter