KOHA
Upgrade drugi: Revision 39
OpacPoboljšan prikaz podataka u OPAC-u, na stranici s rezultatima i na stranici s detaljnim opisom. Dodan prikaz svih lokacija i signatura na stranicu s rezultatima pretraživanja. Postojanje polja 856u na stranici s rezultatima više ne uzrokuje nestajanje podataka o fizičkoj dostupnosti. Sakriven podatak o izgubljenim primjercima na stranici s rezultatima. Dodano polje 245c (odgovornost) - prije nije bilo jasno tko je autor, prevodioc, urednik i dr. Dodano mjesto izdavanja. Uređen prikaz podataka za slučajeve s više mjesta izdavanja i više izdavača. Treba još:
Raspraviti:
LibraryName ? IntranetCirkulacija
Cirkulacija nije testirana za sve slučajeve pa se desilo da je Koha počela onemogućavati posudbu onim korisnicima koji su prekoračili rok za vračanje. Treba: Treba složiti tako da se korisniku progleda kroz prste dan ili dva, a ne ovako kako je sada da im ne omogućava posuditi novo čak i ako im danas ističe rok posudbe. Raspraviti:
Location processing Katalog - prikaz podataka i pretraživanjeNORMAL prikaz sada izgleda kao ISBD! Na mjestu napomene je samo podatak iz 500a (za ocjenske radove još i 567a, a treba dodati i 502a). Sve napomene (polja 50X) trebale bi se nalaziti se pod Descriptions tabom. Prikaz ISBD 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. 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). Dodana je mogućnost pretraživanja po zbirci preko sučelja za napredno preraživanje. Treba još:
***Upstream:*
ObradaMicanje 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) Postoji bug u OPAC-u kod brisanja zapisa kojeg treba popraviti ali se za prvu ruku može jednostavno zaobići. Naime, kad pobrišemo zapis, u OPAC-u se na neko vrijeme potrga pretraživanje po riječima koje daju u rezultatima taj zapis. Ako je rezultat za taj zapis na prvoj stranici, onda se ne dobiju nikakvi rezultati nego prilično loša greška. Ako je rezultat za taj zapis na drugoj stranici onda se strga na toj stranici. Greška se dešava zbog toga što Zebra (program za indeksiranje zapisa) nije još stigla obnoviti zapis, a sučelje za pretraživanje ga ne zna preskočiti. Treba popraviti sučelje. Greška se može izbječi tako da zapis * najprije označimo oznakom "Sakrij u OPAC-u" u polju 942, a tek onda ga obrišemo.* Treba još:
Upstream:
Novosti na naslovniciTreba dati svim knjižničarima ovlasti da pišu obavijesti koje se vide na početnoj stranici u intranetu. PrijevodiDio oznaka na engleskom sučelju je napisano na hrvatskom. To treba popraviti, al nije jednostavno. Upstream:
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. SIP2Admin
isključiti Amazon, uključiti Google Upstream:
Migracija items.itemnotes u items.copynumber
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
*mapirano dva puta **polje dodano u framework (nema ga default framework) Rebuild biblio tablesmglavica@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 bibmglavica@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.xlsmysql> 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
PatronsEnhancedMessagingPreferences Upstream:
Serialspromjenjeno, testitari
Admin - Cataloging preferences - Record Structure - Routing Serials: Upstream:
NabavaOvlasti za knjižničare definirati uloge za nabavu i sukladno tome podesiti ovlasti Upstream
Procedura za produkciju
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
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)
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
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
... 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. ...
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 |