- Koha - lists.katipo.co.nz

MySQL and year published
by Paul 10 Dec '12

10 Dec '12

In all our frameworks we use 260$c for "date of publication" (mandatory -- even to the point of "not known / n.k." so the field cannot be NULL.) However, 260$c appears to be saved EITHER as biblioitems.publicationyear OR as biblio.copyrightdate and we do not have any records at all that include both; hence reports have to use e.g. SELECT IFNULL (biblio.copyrightdate,biblioitems.publicationyear) AS Year, I get the impression (but am far from certain) that biblioitems.publicationyear was used in Koha 3.6 and biblio.copyrightdate is used in 3.8 Maybe one of you who was involved in the "update data tables" scripts (which I have always found to work satisfactorily) could help me? Is there any reason not to copy publicationyear to the copyrightdate? Is biblioitems.publicationyear still used in 3.8? SchemaSpy does not appear to answer this question (although publication year is given as text, 65535; copyrightdate as smallint, 5) and while the data transfer went well in my sandbox, I hesitate to do this in production in case there are side effects. The reason for my doubts is that a smallint should not be able to save e.g. " [c1974?] " but Koha does save it while MySQL reports purely 1974 ... so where is the "text" saved? Many thanks and best regards, Paul

2 1

Fwd: Re: Circulation in Koha
by Zeno Tajoli 09 Dec '12

09 Dec '12

-------- Messaggio originale -------- Subject: Re: [Koha] Circulation in Koha From: Chrispin Simasiku Sitali <libsitali(a)gmail.com> To: Zeno Tajoli <z.tajoli(a)cineca.it> If a book is on loan it means the book has been borrowed by a user and that's when another user can place a hold. If the book is available in the library, a user can easily borrow it. On 9 December 2012 13:01, Zeno Tajoli <z.tajoli(a)cineca.it <mailto:z.tajoli@cineca.it>> wrote: Hi to all, Il 09/12/2012 11:38, Sander898 ha scritto: > Maybe I don't have understand what "on loan" means: > > it mean that the book is potentially on loan > > or > > that a person has already place a hold for the book, and has the book on > loan at his home? "on loan" means: 'the book is on the hands of somoene outside the library' Bye Zeno Tajoli -- Dott. Zeno Tajoli Dipartimento CILEA z.tajoliAT_SPAM_no_prendiATcineca.it <http://z.tajoliAT_SPAM_no_prendiATcineca.it> fax +39 02 2135520 <tel:%2B39%2002%202135520> CINECA - Consorzio Interuniversitario _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha -- Charles Lwanga College of Education, P. O. Box 660193, Monze, ZAMBIA. Mobile: +26 0979 869471 SKYPE: Libsitali

1 0

Database update error in upadate to Koha 3.10.0
by Sander898 09 Dec '12

09 Dec '12

Hi everyone, I have just upadate my Koha from 3.8.6 to the latest 3.10.0 Everything seems to be ok, but I get these two errors in the update of the database, when i log in the first time, after the update, to koha: <http://koha.1045719.n5.nabble.com/file/n5736021/errore_aggiornamento_databa…> Does anyone have an idea of what can be these errors? Thank you very much for your help. Sander -- View this message in context: http://koha.1045719.n5.nabble.com/Database-update-error-in-upadate-to-Koha-… Sent from the Koha-general mailing list archive at Nabble.com.

3 4

Debian and Koha Installation
by AquaSnake 08 Dec '12

08 Dec '12

Is there anywhere I can find a detailed version of how to install Debian, Koha, Perl and MySQL? I checked the sites listed on some of the postings and they do not do the justice. Thanks. -- View this message in context: http://koha.1045719.n5.nabble.com/Debian-and-Koha-Installation-tp5735978.ht… Sent from the Koha-general mailing list archive at Nabble.com.

2 1

Re: [Koha] Debian and Koha Installation
by Mirko 08 Dec '12

08 Dec '12

Woops, forgot to reply to the list. Aquasnake, AquaSnake schrieb am 07.12.2012 > Is there anywhere I can find a detailed version of how to install Debian, > Koha, Perl and MySQL? Yes, the Koha Wiki: http://wiki.koha-community.org/wiki/Debian > > I checked the sites listed on some of the postings and they do not do the > justice. What postings did you check where? The official website is http://koha-community.org. -- Mirko

1 0

help in report
by Mohamed zalabany 08 Dec '12

08 Dec '12

I need to make report to extract serials data but its not workingi think there is sothing wrong but i don't konowcould any body help me select ExtractValue(marcxml,'//datafield[@tag="501"]/subfield[@code>="a"]') as ID, ExtractValue(marcxml,'//datafield[@tag="310"]/subfield[@code>="a"]') as Freq, ExtractValue(marcxml,'//datafield[@tag="245"]/subfield[@code>="a"]') as Title, ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code>="b"]') as Publisher, ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code>="a"]') as Publication place, ExtractValue(marcxml,'//datafield[@tag="546"]/subfield[@code>="a"]') as Language, ExtractValue(marcxml,'//datafield[@tag="500"]/subfield[@code>="a"]') as Note, ExtractValue(marcxml,'//datafield[@tag="500"]/subfield[@code>="a"]') as Subject, ExtractValue(marcxml,'//datafield[@tag="982"]/subfield[@code>="a"]') as Price, from biblioitems where itemtype = CR Mohamed El ZalabanyIntegrated library systems consultant Zalabany Knowledge Systems Team© For Libraries and Information systems Development and support mh_zalabany(a)hotmail.com Mobile: 0009989496

2 2

About looking for Architecture....
by John Herz 08 Dec '12

08 Dec '12

Hello I am looking for Koha arquitecture at glance, where I can find this? I was looking in the wiki Category:Development but nothing. Thank you in advance

3 4

Debian 6.0.6 and Koha
by Matthieu Carter 08 Dec '12

08 Dec '12

Hello, I have attempted to follow the link: http://git.koha-community.org/gitweb/?p=koha.git;a=blob_plain;f=INSTALL.deb… I had all sorts of issues -- I had to reinstall Debian because somehow multiple "koha" folders were installed in the same directory! I did not know this was even possible -- but it is. I am not familar with Debian so please bare with me. Okay, so I got step one done (1.1 Install debian via Business Card CD). ------------- Is there anywhere else that has a more detailed explantion of how to set Koha up and run successfully? -- View this message in context: http://koha.1045719.n5.nabble.com/Debian-6-0-6-and-Koha-tp5735821.html Sent from the Koha-general mailing list archive at Nabble.com.

3 8

Item not available at the OPAC display for some records
by Akin Adigun (Akinomatics) 07 Dec '12

07 Dec '12

Hello All, I am running Koha 3.04 on Ubuntu 10.10 I noticed that when i search on OPAC some of our records are showing Items not available mostly Journals and Reference items, and for those that are even available the correct number of items are not specified and some it shows checked out but when clicked on the Title, the item is available. How can i set the system preference to correct this. thanks

1 0

Re: [Koha] Search operators
by Stefano Bargioni 07 Dec '12

07 Dec '12

Dear Jared, good job. In my opinion, at least data that are or can be autoincrement (bib and auth system numbers, barcodes) require greater than and less than operators. Bye. Stefano On 06/dic/2012, at 18.18, Jared Camins-Esakov wrote: > As many of you know, I have been working on rewriting Koha's search code so > that it is more palatable than a plate of burned nine-day-old spaghetti. > The initial part of the development is nearing completion, and I look > forward to submitting a patch to the community for sign off[1]. > > In the course of the first section of the development, I have run into an > interesting question. We currently support greater than and less than > operators in our searches, but I cannot think of anywhere we might want to > use them other than with dates. Does anyone have any scenarios where a > greater than/less than operator would actually be useful in a bibliographic > or authority search (other than in date searches)? > > Regards, > Jared

1 0