## Postupak migracije ferlib dump-a iz informix-a u Kohu

#1 - import Informix dump-a u SQLite

http://blog.rot13.org/2011/02/migration-of-informix-unl-dump-files-using-sql.html

https://github.com/dpavlin/informix_unl_import

dpavlin@llin:~/private/Koha-FER$ scp -r ferlib-2011-06-16 webpac2.rot13.org:/srv/Koha-FER/

dpavlin@webpac2:/srv/Koha-FER$ time ./informix_unl_import.pl ferlib-2011-06-16
# ...
created /dev/shm/ferlib-2011-06-16.sqlite 52142080 bytes

real    3m40.668s
user    2m53.355s
sys     0m46.359s


#2 - konverzija bibliografskih podataka s WebPAC-om


#3 - migracija MARC podataka u Kohu
# biblio:
fer-koha@lib:/srv/koha/misc/migration_tools$ time ./bulkmarcimport.pl -d -v -file /home/mglavica/marcdata/kohafer-biblio.marc
real    5m20.943s
user    3m4.440s
sys     0m20.577s
# authorities - UDK
fer-koha@lib:/srv/koha/misc/migration_tools$ time ./bulkmarcimport.pl -a -d -v -file /home/mglavica/marcdata/kohafer-udk.marc
# authorities - personal name
fer-koha@lib:/srv/koha/misc/migration_tools$ time ./bulkmarcimport.pl -a -v -file /home/mglavica/marcdata/kohafer-pname.marc
# authorities - korporate name
fer-koha@lib:/srv/koha/misc/migration_tools$ time ./bulkmarcimport.pl -a -v -file /home/mglavica/marcdata/kohafer-kname.marc


#4 - import ostatka podataka
dpavlin@gimpoz:/srv/ferlib2koha$ time sudo FULL=1 ./ferlib2koha.pl 2>/tmp/log

real    6m24.537s
user    2m58.347s
sys     0m10.133s

real    7m50.226s
user    2m36.966s
sys     0m13.229s


#5 rebuild MARC from items

fer-koha@lib:/srv/koha/misc/maintenance$ time ./sync_items_in_marc_bib.pl --run-update
real    7m45.627s
user    6m3.859s
sys     0m22.669s


#6 rebuild zebra
fer-koha@lib:/srv/koha/misc/migration_tools$ time ./rebuild_zebra.pl -a -b -v -r
real    9m3.355s
user    8m54.653s
sys     0m29.978s


#7 transfer database to production
dpavlin@gimpoz:/srv/ferlib2koha$ time sudo mysqldump koha_fer | ssh dpavlin@lib.fer.hr  mysql koha_fer

real    1m57.901s
user    0m9.541s
sys     0m2.288s



## Testirati na FER-u
- firefox plugin
- čitanje bar-kodova knjiga
- čitanje JMBAG-a s x-ice

- printer settings



# podesiti Kohu za produkciju
- SessionStorage as /tmp/ files!!

# dupli nespojeni djelatnici
sqlite> select count(*),ime_djel,prez_djel from djelat group by ime_djel,prez_djel having count(*) > 1 ;
2|Domagoj|Kovačević
2|Ivica|Vukoja
2|Josip|Jurić
2|Marko|Horvat
2|Tomislav|Petković