KOHA
Upgrade drugi: Revision 33
Contents


Instalacija

Tue Feb 16 15:29:31 2010 Makefile.PL: Warning: prerequisite Graphics::Magick not found.
Tue Feb 16 15:29:31 2010 Makefile.PL: Warning: prerequisite IPC::Cmd 0.46 not found. We have 0.401.
Tue Feb 16 15:29:31 2010 Makefile.PL: Warning: prerequisite Lingua::Stem::Snowball 0.952 not found.
Tue Feb 16 15:29:31 2010 Makefile.PL: Warning: prerequisite Memoize::Memcached 0.03 not found.
Tue Feb 16 15:29:31 2010 Makefile.PL: Warning: prerequisite Number::Format 1.52 not found.
Tue Feb 16 15:29:32 2010 Makefile.PL: Warning: prerequisite PDF::API2::Simple 1 not found.
Tue Feb 16 15:29:32 2010 Makefile.PL: Warning: prerequisite PDF::Table not found.
Tue Feb 16 15:29:32 2010 Makefile.PL: Warning: prerequisite Storable 2.21 not found. We have 2.18.
Tue Feb 16 15:29:32 2010 Makefile.PL: Warning: prerequisite Test::More 0.8 not found. We have 0.72.
Tue Feb 16 15:29:32 2010 Makefile.PL: Warning: prerequisite Text::CSV::Encoded 0.09 not found.

SIP2

Dobrica

Admin

isključiti Amazon, uključiti Google
Enhanced content: Amazon AWS private key (naknadno, treba li nam uopće?)

Upstream:

  • lijepo novo sučelje za sysprefs
  • nove sysprefs opcije

Prijevodi

generirati hr-HR templates

Upstream:

  • novi wrapper za instalaciju prijevoda - ne radi :)

Opac

Poboljšan prikaz podataka u OPAC-u, na stranici s rezultatima i na stranici s detaljnim opisom.

  • postojanje polja 856u na stranici s rezultatima više ne uzrokuje nestajanje podataka o fizičkoj dostupnosti
  • dodano polje 245c (odgovornost) - prije nije bilo jasno tko je autor, prevodioc, urednik i dr.
  • dodano mjesto izdavanja
  • uređen prikaz za situaciju s više mjesta izdavanja i više izdavača

Treba još:

  • urediti kriterije za sortiranje rezultata
  • refine search - dodati lokaciju ili stručnu oznaku iz signature (razmisliti kako dobiti taj podatak, raspraviti)
  • pretraživanje po jeziku
  • nakladnička kad je u 490

tagovi?
OPACBaseURL ?
LibraryName ?
OpacMaintenance ?

OpacSuppession
Note that you must have the Suppress index set up in Zebra and at least one suppressed item, or your searches will be broken.

hidelostitems

OpacNav- dodatna navigacija s korisnim linkovima - gdje to staviti (lijevo, desno) i kako
formatirati?

more searches -
dodati relevantne izvore (sada se to radi preko admin sučelja, ne više kroz template)

https u URL

Upstream:

  • prikaz lokacije i signature na stranici s rezultatima
  • lost items na stranici s rezultatima ne prikazati (niti na detaljnoj stranici, ali tamo je radilo i prije)
  • search history
  • pretraživanje po jeziku (ne radi!)

Intranet

Katalog

NORMAL prikaz sada izgleda kao ISBD! Na mjestu napomene je samo podatak iz 500a (za ocjenske radove još i 567a, a treba dodati i 502a). Ostale napomene (sadržaj, zastupljeni autori, ...) nalaze se pod Descriptions tabom.

U NORMAL prikazu trebalo bi se vidjeti što više podataka. Treba se još dogovoriti oko napomena - koje napomene prikazati u ISBD-u, a koje ispod taba "Descriptions".

ISBD prikaz maknut je iz menija zato što prikaz Normal sada ima ISBD fromat. Taj prikaz imao je puno nedostataka, a među najvažniji su prikaz podataka o izdavanju, URL-a i problemi s intepunkcijama.

Dodani su linkovi na povezani zapis - od skupnog prema primjercima (Look for related records) i od primjeraka prema skupnom (Collection). Treba popraviti tako da pretražuje samo preko polja 035a, a ne preko ključnih riječi. To nije jošt sasvim dovršeno - link bi se trebalo pokazivati samo na onim zapisima koji u leaderu imaju oznaku za related record.

Inventarni broj se sada prikazuje u tablici s primjercima na obje stranice rezultata (results i detail). - treba još vratiti inv. broj na stranicu s rezultatima.

Omogućiti pretraživanje po ccode.

Urediti limitere za pretraživanje.

promjene u predlošcima:

/usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/catalogue/detail.tmpl
/usr/share/koha/intranet/cgi-bin/catalogue/detail.pl
/usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/catalogue/results.tmpl

Keywords to MARC mapping:

mappiranje za LIB i OCJ framework (prema 252)

Obrada

(MG) Testirati dodavanje multiple items

Micanje primjeraka - tehnički radi, praktično treba definirati postupak - koji zapis ostaje koji se briše, tko smije brisati zapis, na šta sve treba paziti. (vidi: Premještanje primjeraka s jednog na drugi bibliografski zapis)

Brisanje bib zapisa izaziva prilično lošu grešku u pretraživanju javnog kataloga, pod oređenim uvjetima. (vidi: Zebra indexing)

Instalirati dodatak za generiranje signatura u zatvorenom spremištu - Pisanje Koha plugina

LCCN maknuti iz displeya u Z39.50 klijentu

DefaultClassificationSource

Plugins

000 - marc21_leader_ffzg.pl
008 - marc21_field_008_ffzg.pl

Barcode - window title

kad je naslov
predugačak onda se barcode ne vidi, pa se ne može niti čipirati

Novosti na naslovnici

Dati svim knjižničarima ovlasti da pišu obavijesti koje se vide na početnoj stranici u intranetu.

Upstream:

  • mogućnost dodavanja više primjeraka odjednom
  • mogućnost micanja primjeraka s jednog na drugi bib zapis
  • granularne ovlasti za katalogizaciju

Pretraživanje

pogađanje riječi za sva polja osim signature (koje još polje ne treba pogađanje riječi?)

pretraživanje po jeziku

Migracija items.itemnotes u items.copynumber

  • backup items.itemnotes
  • itemnotes je mediumtext, copynumber je varchar(32) - treba ispraviti zapise u itemnotes duže od 32 znaka
  • premapirati items.itemnotes
  • pokrenuti skriptu ./misc/maintenance/sync_items_in_marc_bib.pl ( _Replaces the item data embedded in the MARC bib records (for indexing) with the authoritative item data as stored in the items table. If Zebra is used, run rebuild_zebra.pl -b -r after running this script. _ )
mysql> update items set copynumber = itemnotes ;
Query OK, 316711 rows affected, 11 warnings (59.70 sec)
Rows matched: 317021  Changed: 316711  Warnings: 11

mysql> SHOW WARNINGS ;
+---------+------+------------------------------------------------------+
| Level   | Code | Message                                              | bib       item
+---------+------+------------------------------------------------------+
| Warning | 1265 | Data truncated for column 'copynumber' at row 10021  | 
| Warning | 1265 | Data truncated for column 'copynumber' at row 12687  | 
| Warning | 1265 | Data truncated for column 'copynumber' at row 133128 | 
| Note    | 1265 | Data truncated for column 'copynumber' at row 148603 | 118292    149220    lin13531
| Warning | 1265 | Data truncated for column 'copynumber' at row 234903 | 
| Warning | 1265 | Data truncated for column 'copynumber' at row 240681 | 
| Note    | 1265 | Data truncated for column 'copynumber' at row 252496 | 203477    253517    etn6059
| Note    | 1265 | Data truncated for column 'copynumber' at row 267457 | 216220    268698    psiF-54
| Warning | 1265 | Data truncated for column 'copynumber' at row 272653 | 
| Warning | 1265 | Data truncated for column 'copynumber' at row 277954 | 
| Warning | 1265 | Data truncated for column 'copynumber' at row 282443 | 
+---------+------+------------------------------------------------------+
11 rows in set (0.00 sec)

mysql> select biblionumber, itemnumber, itemnotes , copynumber from items where itemnotes != copynumber ;
+--------------+------------+----------------------------------------------------------------------------------+-----------------------------------+
| biblionumber | itemnumber | itemnotes                                                                        | copynumber                        |
+--------------+------------+----------------------------------------------------------------------------------+-----------------------------------+
|         7468 |      10092 | slf56588 (nisu otisnute sve str.)                                                | slf56588 (nisu otisnute sve str.  | 
|         8899 |      12778 | slf67394 (bibliofilski primjerak)                                                | slf67394 (bibliofilski primjerak  | 
|       104612 |     133701 | filDodatni pod. o odgovornosti: Gottfried Gabriel                                | filDodatni pod. o odgovornosti:   | 
|       189568 |     235908 | rom13568,13569,13569/f-a,13569/f-b,13569/f-c,13569/f-d,13569/f-e,13569/f-f,13570 | rom13568,13569,13569/f-a,13569/f  | 
|       192861 |     241688 | rom1792/2,1792/4,1792/5,1792f/f,1792f/h,26379E                                   | rom1792/2,1792/4,1792/5,1792f/f,  | 
|       220139 |     273925 | pum66/1996 (u RS, nedostaju str. s tablama: 208-215 )                            | pum66/1996 (u RS, nedostaju str.  | 
|       224967 |     279247 | pumŠAR/1987a(neuvezani primjerak)                                                | pumŠAR/1987a(neuvezani primjerak | 
|       227773 |     283828 | ang1000/AMS do 1084/AMS (84 copies)                                              | ang1000/AMS do 1084/AMS (84 copi  | 
+--------------+------------+----------------------------------------------------------------------------------+-----------------------------------+
8 rows in set (0.95 sec)

mysql> update items set itemnotes = null ;
Query OK, 316711 rows affected (43.04 sec)
Rows matched: 317021  Changed: 316711  Warnings: 0

Koha to MARC mapping

  upgrade sada u produkciji demo default framework irb
biblio.frameworkcode 942b 942b   nema polja  
biblio.notes   653a 500a 500a 500a
biblio.copyrightdate   ništa 260c 260c 260c*
biblio.abstract 080a 080a 520a 520a 520a
biblioitems.volume 245p 245n 440v 440v 440v
biblioitems.number 245n 942d 440n 440n 440n
biblioitems.publicationyear 260c 260c ništa ništa 260c*
biblioitems.volumedesc 362a 245p 362a 362a 362a
biblioitems.collectiontitle 773t 773t ništa ništa ništa
biblioitems.collectionissn 773z ništa ništa ništa ništa
biblioitems.collectionvolume 773g 773g ništa ništa ništa
biblioitems.editionstatement 250a 250a ništa ništa ništa
biblioitems.lccn 035a 035a 010a 010a 010a
items.itemnotes 952z 952i** 952z 952z 952z
items.copynumber 952t ništa 952t 952t 952t

*mapirano dva puta

**polje dodano u framework (nema ga default framework)

Rebuild biblio tables

mglavica@koha-2010-02-15:/usr/share/koha/bin$ ./batchRebuildBiblioTables.pl -c

..................................................225350 in 37818.0600130558 s
...Can't call method "field" on an undefined value at ./batchRebuildBiblioTables.pl line 64.

editirati zapis 225354 i pokušati ponovo

Sync items in marc bib

mglavica@koha-2010-02-15:/usr/share/koha/bin/manintenance/sync_items_in_marc_bib.pl --run-update

Could not retrieve bib 225771 from the database - record is corrupt.
Could not retrieve bib 225773 from the database - record is corrupt.
Could not retrieve bib 225774 from the database - record is corrupt.
Could not retrieve bib 229768 from the database - record is corrupt.
Could not retrieve bib 229811 from the database - record is corrupt.
Could not retrieve bib 231170 from the database - record is corrupt.
Could not retrieve bib 236269 from the database - record is corrupt.
Could not retrieve bib 231170 from the database - record is corrupt.
Could not retrieve bib 241167 from the database - record is corrupt.
Could not retrieve bib 241457 from the database - record is corrupt.
Could not retrieve bib 242341 from the database - record is corrupt.
Could not retrieve bib 245586 from the database - record is corrupt.


Embedded item synchronization report
------------------------------------
Number of bibs checked:                   246606
Number of bibs modified:                  232417
Number of item fields removed from bibs:  317032
Number of item fields added to bibs:      317030
Number of bibs with errors:               11


mysql> select title, biblioitems.biblionumber, biblioitems.biblioitemnumber, marc, marcxml from biblioitems joiitems.biblionumber where marcxml = '' ;
+--------------------------------------------------+--------------+------------------+------+---------+
| title                                            | biblionumber | biblioitemnumber | marc | marcxml |
+--------------------------------------------------+--------------+------------------+------+---------+
| Priručni anatomski atlas :                       |       225771 |           225771 | NULL |         |
| Priručni anatomski atlas :                       |       225773 |           225773 | NULL |         |
| Priručni anatomski atlas :                       |       225774 |           225774 | NULL |         |
| Zlatan čovek                                     |       229768 |           229768 | NULL |         |
| Tko govori, tko piše :                           |       229811 |           229811 | NULL |         |
| Stupnjevi organskog i čovjek :                   |       231170 |           231170 | NULL |         |
| Ispravci i dopune starijoj hrvatskoj historiji / |       236269 |           236269 | NULL |         |
| Deutsch :                                        |       241167 |           241167 | NULL |         |
| Tradition och förnyelse inom språket :           |       241457 |           241457 | NULL |         |
| Geneza ustaškog pokreta :                        |       242341 |           242340 | NULL |         |
| Social emergence :                               |       245586 |           245585 | NULL |         |
+--------------------------------------------------+--------------+------------------+------+---------+
11 rows in set (3 min 48.40 sec)

pobrisati te zapise.

bib-bez-marc.xls

mysql> delete from biblio where biblionumber = 225771 or biblionumber = 225773 or biblionumber = 225774 or biblionumber = 229768 or biblionumber = 229811 or biblionumber = 231170 or biblionumber = 236269 or biblionumber = 241167 or biblionumber = 241457 or biblionumber = 242341 or biblionumber = 245586 ;
Query OK, 11 rows affected (0.68 sec)

drugi pokušaj rebuild biblio tables zapne ovako

..................................................241600 in 4839.90223407745 s
..................................................241650 in 4843.83456802368 s
.................Can't call method "field" on an undefined value at ./batchRebuildBiblioTables.pl line 64.


mysql> select * from biblioitems where biblionumber = 242219 ;
Empty set (0.00 sec)

i taj zapis treba pobrisati

mysql> delete from biblio where biblionumber = 242219 ;
Query OK, 1 row affected (0.31 sec)

Izvještaji

  • signature
  • biblioitems.publisherdate -> biblio.copyrightdate

Patrons

EnhancedMessagingPreferences

Upstream:

  • popravljen encoding u slanju e-maila preko opac user update

Cirkulacija

Nova pravila posudbe - novi itemtypes (nakon što se donese pravilnik)

Location processing
permanent_location - sysprefs http://koha.org/documentation/manual/3.2/circulation/in-processing-book-cart-locations.
Da li nam treba PROC i CART?

Novčane naknade

definirati razloge za naplatu

Rezervacije

testiraj

Patrons can only have 10 holds at once.

Serials

promjenjeno, testitari

Admin - Cataloging preferences - Record Structure - Routing Serials:
Add extra information to items automatically added to serials.

Upstream:

  • popravljeno dodavanje primjeraka
  • dorađene reklamacije

Nabava

Ovlasti za knjižničare

definirati uloge za nabavu i sukladno tome podesiti ovlasti

Upstream

  • novi modul - granular permissions, hijerarhije budžeta, planiranje
  • opcije za stvaranje primjeraka - prilikom nabave, u prijemu, u katalogizaciji

Procedura za produkciju

  • prije instalacije pobrisane sessions i zebraqueue tablice
  • pobrisani bibliografski zapisi bez biblio.marc polja (sačuvati pobrisane zapise)
mysql> select title, biblioitems.biblionumber, biblioitems.biblioitemnumber, marc, marcxml from biblioitems join biblio on biblio.biblionumber=biblioitems.biblionumber where marc is null ;
+--------------------------------------------------+--------------+------------------+------+---------+
| title                                            | biblionumber | biblioitemnumber | marc | marcxml |
+--------------------------------------------------+--------------+------------------+------+---------+
| Priručni anatomski atlas :                       |       225771 |           225771 | NULL |         | 
| Priručni anatomski atlas :                       |       225773 |           225773 | NULL |         | 
| Priručni anatomski atlas :                       |       225774 |           225774 | NULL |         | 
| Zlatan čovek                                     |       229768 |           229768 | NULL |         | 
| Tko govori, tko piše :                           |       229811 |           229811 | NULL |         | 
| Stupnjevi organskog i čovjek :                   |       231170 |           231170 | NULL |         | 
| Ispravci i dopune starijoj hrvatskoj historiji / |       236269 |           236269 | NULL |         | 
| Deutsch :                                        |       241167 |           241167 | NULL |         | 
| Tradition och förnyelse inom språket :           |       241457 |           241457 | NULL |         | 
| Geneza ustaškog pokreta :                        |       242341 |           242340 | NULL |         | 
| Social emergence :                               |       245586 |           245585 | NULL |         | 
+--------------------------------------------------+--------------+------------------+------+---------+
11 rows in set (34.63 sec)

mysql> delete from biblio where biblionumber = 225771 or biblionumber = 225773 or biblionumber = 225774 or biblionumber = 229768 or biblionumber = 229811 or biblionumber = 231170 or biblionumber = 236269 or biblionumber = 241167 or biblionumber = 241457 or biblionumber = 242341 or biblionumber = 245586 ;
Query OK, 11 rows affected (0.10 sec) ;

bib-bez-marc.xls

  • pobrisan biblio zapis bez podataka u biblioitems tablici
delete from biblio where biblionumber = 242219 ;
Query OK, 1 row affected (0.00 sec)

biblio-bez-biblioitems.xls

mysql> select count(*) from biblio ;
+----------+
| count(*) |
+----------+
|   246779 |
+----------+
1 row in set (0.20 sec)

mysql> select count(*) from biblioitems ;
+----------+
| count(*) |
+----------+
|   246779 |
+----------+
1 row in set (11.73 sec)

mysql> select count(*) from items ;
+----------+
| count(*) |
+----------+
|   317896 |
+----------+
1 row in set (0.50 sec)

mysql> select count(*) from items where itemnotes is null ;
+----------+
| count(*) |
+----------+
|      322 |
+----------+
1 row in set (1.00 sec)

  • preseliti itemnotes u copynumber
mysql> update items set copynumber = itemnotes ;
Query OK, 317574 rows affected, 8 warnings (57.21 sec)
Rows matched: 317896  Changed: 317574  Warnings: 8

mysql> show warnings ;
+---------+------+------------------------------------------------------+
| Level   | Code | Message                                              |
+---------+------+------------------------------------------------------+
| Warning | 1265 | Data truncated for column 'copynumber' at row 10021  | 
| Warning | 1265 | Data truncated for column 'copynumber' at row 12687  | 
| Warning | 1265 | Data truncated for column 'copynumber' at row 133126 | 
| Warning | 1265 | Data truncated for column 'copynumber' at row 234900 | 
| Warning | 1265 | Data truncated for column 'copynumber' at row 240678 | 
| Warning | 1265 | Data truncated for column 'copynumber' at row 272650 | 
| Warning | 1265 | Data truncated for column 'copynumber' at row 277951 | 
| Warning | 1265 | Data truncated for column 'copynumber' at row 282440 | 
+---------+------+------------------------------------------------------+
8 rows in set (0.00 sec)

mysql> select biblionumber, itemnumber, itemnotes , copynumber from items where itemnotes != copynumber ;
+--------------+------------+----------------------------------------------------------------------------------+-----------------------------------+
| biblionumber | itemnumber | itemnotes                                                                        | copynumber                        |
+--------------+------------+----------------------------------------------------------------------------------+-----------------------------------+
|         7468 |      10092 | slf56588 (nisu otisnute sve str.)                                                | slf56588 (nisu otisnute sve str.  |
|         8899 |      12778 | slf67394 (bibliofilski primjerak)                                                | slf67394 (bibliofilski primjerak  |
|       104612 |     133701 | filDodatni pod. o odgovornosti: Gottfried Gabriel                                | filDodatni pod. o odgovornosti:   |
|       189568 |     235908 | rom13568,13569,13569/f-a,13569/f-b,13569/f-c,13569/f-d,13569/f-e,13569/f-f,13570 | rom13568,13569,13569/f-a,13569/f  |
|       192861 |     241688 | rom1792/2,1792/4,1792/5,1792f/f,1792f/h,26379E                                   | rom1792/2,1792/4,1792/5,1792f/f,  |
|       220139 |     273925 | pum66/1996 (u RS, nedostaju str. s tablama: 208-215 )                            | pum66/1996 (u RS, nedostaju str.  |
|       224967 |     279247 | pumŠAR/1987a(neuvezani primjerak)                                                | pumŠAR/1987a(neuvezani primjerak  |
|       227773 |     283828 | ang1000/AMS do 1084/AMS (84 copies)                                              | ang1000/AMS do 1084/AMS (84 copi  |
+--------------+------------+----------------------------------------------------------------------------------+-----------------------------------+
8 rows in set (1.20 sec)

mysql> update items set itemnotes = 0 ;
Query OK, 317896 rows affected (28.21 sec)
Rows matched: 317896  Changed: 317896  Warnings: 0

  • Koha to MARC mapping - premapirana polja
  • pokrenut rebuildBiblioTables
  • Keywords to MARC mapping - definirane keywords
  • sysadmin - staff - intranetstylesheet
  • sysadmin - opac - stylesheet
  • popravljeni frameworks - 952i 952z 952r
  • pokrenut syncitems
Embedded item synchronization report
------------------------------------
Number of bibs checked:                   246779
Number of bibs modified:                  232631
Number of item fields removed from bibs:  317898
Number of item fields added to bibs:      317896
Number of bibs with errors:               0

  • pokrenuti rebuild zebra
...
06:35:43-21/02 zebraidx(1905) [log] Records: 246779 i/u/d 246510/269/0
...
NOTHING cleaned : the export /tmp/KXMJFxLzlj has been kept.
...

  • prijevodi
  • testirano slanje maila iz cart i liste
  • testirano update user record (popravljen encoding!)
  • preseliti (kako?) more_subfields_xml u itemnotes
  • maknuti sličice s mjeseca
  • testirati nove template - ne radi select all

Mozda sam negdje preskocila u tekstu - ali ne radi bas pretrazivanje preko kohe - npr. ako utipkam u onaj mali prozorcic gore ped15322 ne izbaci mi nista jer ulovi jos neke oznake prije. isto se dogodilo i kad sam isla preko search s naslovom knjige.

contributed by Visnja Novosel on Feb 22 3:13am