1 ## Postupak migracije ferlib dump-a iz informix-a u Kohu
3 #1 - import Informix dump-a u SQLite
5 http://blog.rot13.org/2011/02/migration-of-informix-unl-dump-files-using-sql.html
7 https://github.com/dpavlin/informix_unl_import
9 dpavlin@llin:~/private/Koha-FER$ scp -r ferlib-2011-06-16 webpac2.rot13.org:/srv/Koha-FER/
11 dpavlin@webpac2:/srv/Koha-FER$ time ./informix_unl_import.pl ferlib-2011-06-16
13 created /dev/shm/ferlib-2011-06-16.sqlite 52142080 bytes
20 #2 - konverzija bibliografskih podataka s WebPAC-om
23 #3 - migracija MARC podataka u Kohu
25 fer-koha@lib:/srv/koha/misc/migration_tools$ time ./bulkmarcimport.pl -d -v -file /home/mglavica/marcdata/kohafer-biblio.marc
30 fer-koha@lib:/srv/koha/misc/migration_tools$ time ./bulkmarcimport.pl -a -d -v -file /home/mglavica/marcdata/kohafer-udk.marc
31 # authorities - personal name
32 fer-koha@lib:/srv/koha/misc/migration_tools$ time ./bulkmarcimport.pl -a -v -file /home/mglavica/marcdata/kohafer-pname.marc
33 # authorities - korporate name
34 fer-koha@lib:/srv/koha/misc/migration_tools$ time ./bulkmarcimport.pl -a -v -file /home/mglavica/marcdata/kohafer-kname.marc
37 #4 - import ostatka podataka
38 dpavlin@gimpoz:/srv/ferlib2koha$ time sudo FULL=1 ./ferlib2koha.pl 2>/tmp/log
49 #5 rebuild MARC from items
51 fer-koha@lib:/srv/koha/misc/maintenance$ time ./sync_items_in_marc_bib.pl --run-update
58 fer-koha@lib:/srv/koha/misc/migration_tools$ time ./rebuild_zebra.pl -a -b -v -r
64 #7 transfer database to production
65 dpavlin@gimpoz:/srv/ferlib2koha$ time sudo mysqldump koha_fer | ssh dpavlin@lib.fer.hr mysql koha_fer
75 - čitanje bar-kodova knjiga
76 - čitanje JMBAG-a s x-ice
82 # podesiti Kohu za produkciju
83 - SessionStorage as /tmp/ files!!
85 # dupli nespojeni djelatnici
86 sqlite> select count(*),ime_djel,prez_djel from djelat group by ime_djel,prez_djel having count(*) > 1 ;