[Koha] How to Send Mail Alerts for approval of Library Committee Group for a Suggested Item
Hello, We are working on to integrate a particular function in Koha Acquisition module for Suggestion Management. In our Institute we have Committee Members that approve the suggested item and we achieve this by mailing them the Suggested details by the user. this is done with a single click in our old library software. we want KOHA to have similar feature hence the effort. We have pointed out a peculiar function working in KOHA i.e when the status is changed in suggestion management a mail from Notices slips with similar status id is sent to the person who has suggested the document . we could use this function for sending the mails for approval from the Committee members How do we achieve this milestone is there any way to do it . Pointers for any leads will be appreciated Regards Arunkumar National Institute of Oceanography Dona-Paula, Goa, India ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Regarding SMS integration in KOHA 3.12
Hi friends, I am looking for SMS integration in koha 3.12 in India. How to proceed for SMS integration. What are the necessary steps to be taken for Integration. As it's very important for our Library. Thanks in Advance. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Regarding SMS integration in KOHA 3.12
See here: http://manual.koha-community.org/3.12/en/circfaq.html#smsnoticefaq You have to have a driver to enable SMS messaging. There is also this: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9021 -- a new feature that is in the works to make it so that you can use SMS via email. Thanks Nicole On Mon, May 5, 2014 at 5:43 AM, rocky bang rockyba...@gmail.com wrote: Hi friends, I am looking for SMS integration in koha 3.12 in India. How to proceed for SMS integration. What are the necessary steps to be taken for Integration. As it's very important for our Library. Thanks in Advance. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] printing of callslips
Does anyone do item-level holds? If so, how does it work with printing callslips? -- Jenice S. Tate, Systems Administrator MS Department of Archives History Archives Records Services Division - Computer Support Phone: (601) 576-6821 Fax: (601) 576-6824 Email:jt...@mdah.state.ms.us ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Misleading item status between OPAC search result and full item details
Such items have been assigned PROC (in processing) status under Shelf Location. This is fine and shows correctly on the OPAC full item detail screen under Holdings. However, on the OPAC search result list, they are shown as Available for loan at ..., after Availability. This causes confusion whether such item is actually ready for loan or still being processed! Shelf location in Koha does not have any influence over availability in Koha - it's just part of the address of the item. You could check out the items to Processing as a patron and then check them in when the book is ready for public access. That way they would show in the OPAC as being in the library's collection, but not available for use. If your library has a holds system, people would be able to put a hold on the item for when it is available. Alternatively (and slower if you have a barcode reader) you can individually change each item record to not for loan until it is ready for loan, and then change it again when it's ready to go. On Sun, May 4, 2014 at 8:40 AM, Iming Chan imingc...@yahoo.com.au wrote: Dear all, I'm try to resolve a misleading/contradicting status for new items that are currently being processed by our Technical Services team. Such items have been assigned PROC (in processing) status under Shelf Location. This is fine and shows correctly on the OPAC full item detail screen under Holdings. However, on the OPAC search result list, they are shown as Available for loan at ..., after Availability. This causes confusion whether such item is actually ready for loan or still being processed! Now I have been trying to a few options, but none seems to have worked on the search result list: 1. To show description for the PROC status (In processing in our case) instead of Available for loan at ...; or 2. Totally remove/hide Availability detail. I haven even tried to assign these items to our Technical Services branch under Current Location (while assigned to correct branch for Permanent Location). However, availability message still use permanent instead of current location regardless. P.S. Unfortunately check-in function would not change status for Not for loan (it shouldn't be anyway), otherwise, I would have assigned a status under Not for loan instead of Shelf location instead to solve this confusion! Looking forward to your comments or suggestions. Regards, Iming Chan Translib Information Service Melbourne, Australia - Iming Chan Translib Information Service Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Misleading-item-status-between-OPAC-search-result-and-full-item-details-tp5796889.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Multiple 999$c biblionumbers Koha 3.14
- Question: What is the best way to find out if we have records with multiple 999c fields? I need to find out if the record below is an anomaly, or if there is a bigger problem. I've reported a similar problem before, and commented on bug 6657 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6657 . I now have a record that seems to have lost its item records, acquired an item record from another record (which itself has vanished) and has a scary number of 999$c fields. To add to the confusion, the one item that is attached to the record was uploaded *before* the biblio record was created (and its parent record is gone without a trace). See record below. Some of this could be human error (merging two records that should not have been merged, or typing in the wrong number - we don't actually have barcodes). But the 999c is machine generated, and that's the worrying thing. Do you see anything strange about this record in addition to the 999c fields? How did that strange $d end up in the midst of them? Any ideas? =LDR 02138nam a22003737a 4500 =001 201211211518.nw =003 UkLoVW =005 20140319230939.0 =008 121120s1922enkg\\\g\\000\0\eng\d =040 \\$aUkLoVW$beng$cUkLoVW =099 \\$aQS 40 =100 \\$9822$aSharp, Cecil J. =245 10$aCountry dance tunes, set Xl :$bfrom The English dancing master (1650-1728) /$cArranged by Cecil J. Sharp. =260 \\$aLondon :$bNovello Co.,$c1922. =300 \\$a26 p. :$bmusic ;$c31 cm. =500 \\$aIssued in connection with 'The country dance book, part Vl'. =600 \\$91045$aPlayford, John =650 \\$9163$aEngland =650 \\$910905$aCountry dance tunes =942 \\$2VWML$cBK$hQS 40$n0$6QS0040 =999 \\$c17304 | 18206 | 18205 | 18203 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194$d17304 | 18206 | 18205 | 18203 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 =999 \\$c18206 =999 \\$c18205 =999 \\$c18203 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 =999 \\$c18202 =999 \\$c18202 =999 \\$c18201 =999 \\$c18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 =999 \\$c18199 =999 \\$c18198 =999 \\$c18196 | 18194 | 18194 | 18194 =999 \\$c18194 | 18194 =999 \\$c18194 =952 \\$w2012-10-31$p17354$r2012-10-31$40$6AL_MACCOLL$918199$bVWML$10$oAL MACCOLL$d2010-01-01$71$2VWML$yBK$00$aVWML Hoping for a logical answer. Thanks! -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Multiple 999$c biblionumbers Koha 3.14
I don't know if this is a related problem, but some (not all) of the biblios I have found with multiple biblio numbers also seem to have display issues with the item info. In that the results list says one thing (no items, for instance) and the full record says something else (two items, for example). On Mon, May 5, 2014 at 8:21 PM, Elaine Bradtke e...@efdss.org wrote: - Question: What is the best way to find out if we have records with multiple 999c fields? I need to find out if the record below is an anomaly, or if there is a bigger problem. I've reported a similar problem before, and commented on bug 6657 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6657 . I now have a record that seems to have lost its item records, acquired an item record from another record (which itself has vanished) and has a scary number of 999$c fields. To add to the confusion, the one item that is attached to the record was uploaded *before* the biblio record was created (and its parent record is gone without a trace). See record below. Some of this could be human error (merging two records that should not have been merged, or typing in the wrong number - we don't actually have barcodes). But the 999c is machine generated, and that's the worrying thing. Do you see anything strange about this record in addition to the 999c fields? How did that strange $d end up in the midst of them? Any ideas? =LDR 02138nam a22003737a 4500 =001 201211211518.nw =003 UkLoVW =005 20140319230939.0 =008 121120s1922enkg\\\g\\000\0\eng\d =040 \\$aUkLoVW$beng$cUkLoVW =099 \\$aQS 40 =100 \\$9822$aSharp, Cecil J. =245 10$aCountry dance tunes, set Xl :$bfrom The English dancing master (1650-1728) /$cArranged by Cecil J. Sharp. =260 \\$aLondon :$bNovello Co.,$c1922. =300 \\$a26 p. :$bmusic ;$c31 cm. =500 \\$aIssued in connection with 'The country dance book, part Vl'. =600 \\$91045$aPlayford, John =650 \\$9163$aEngland =650 \\$910905$aCountry dance tunes =942 \\$2VWML$cBK$hQS 40$n0$6QS0040 =999 \\$c17304 | 18206 | 18205 | 18203 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194$d17304 | 18206 | 18205 | 18203 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 =999 \\$c18206 =999 \\$c18205 =999 \\$c18203 | 18202 | 18202 | 18201 | 18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 =999 \\$c18202 =999 \\$c18202 =999 \\$c18201 =999 \\$c18200 | 18199 | 18198 | 18196 | 18194 | 18194 | 18194 | 18194 | 18194 | 18194 =999 \\$c18199 =999 \\$c18198 =999 \\$c18196 | 18194 | 18194 | 18194 =999 \\$c18194 | 18194 =999 \\$c18194 =952 \\$w2012-10-31$p17354$r2012-10-31$40$6AL_MACCOLL$918199$bVWML$10$oAL MACCOLL$d2010-01-01$71$2VWML$yBK$00$aVWML Hoping for a logical answer. Thanks! -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org
[Koha] Report help needed 999$c
I've got something that extracts the biblio numbers from the 999c. Is there any way to ask it to only show the ones that contain multiple 999c? SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag=999]/subfield[@code=c]') AS comp FROM biblioitems -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Instructions to upgrade 3.10 to 3.10.13
ISM KIS schreef op ma 05-05-2014 om 13:31 [+0530]: I was wrong: running Ubuntu 12.10 and we installed using instructions from http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages basically: sudo apt-get install koha-common Is it enough just to do a apt-get update apt-get upgrade Is that how to update minor releases? Technically yes, but in this case, no. Packages are maintained for 3.14 and 3.12, so depending what apt source entry you used, you'll get upgraded to one of them. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to Send Mail Alerts for approval of Library Committee Group for a Suggested Item
Arun Kumar schreef op ma 05-05-2014 om 12:35 [+0530]: In our Institute we have Committee Members that approve the suggested item and we achieve this by mailing them the Suggested details by the user. this is done with a single click in our old library software. we want KOHA to have similar feature hence the effort. It seems like the easiest way to start this would be to make a report. However, it could also be done with some development work. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help needed 999$c
Elaine Bradtke schreef op ma 05-05-2014 om 22:55 [+0100]: I've got something that extracts the biblio numbers from the 999c. Is there any way to ask it to only show the ones that contain multiple 999c? SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag=999]/subfield[@code=c]') AS comp FROM biblioitems This is totally untested, but you might be able to use the XPath count() function in your ExtractValue. So,: ExtractValue(marcxml, 'count(//datafield[@tag=999]/subfield[@code=c])') An example here: http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html#function_extractvalue Note that it looked like your data also had multiple entries in one 999 $c field, separated with '|'. That's weird, and this won't find that. On the other hand, you can just do WHERE field LIKE %|% to catch those. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help needed 999$c
Note that it looked like your data also had multiple entries in one 999 $c field, separated with '|'. That's weird, and this won't find that. On the other hand, you can just do WHERE field LIKE %|% to catch those. Yes, that is weird. I'm trying to figure out where it is coming from. In a few cases I've seen like the one I posted, it appears they are multiple editions of the same book, in which case the cataloguer probably duplicated the record. I haven't tested this theory out, but I could see where it might just add in another biblionumber to the string already there. On Mon, May 5, 2014 at 11:57 PM, Robin Sheat ro...@catalyst.net.nz wrote: Elaine Bradtke schreef op ma 05-05-2014 om 22:55 [+0100]: I've got something that extracts the biblio numbers from the 999c. Is there any way to ask it to only show the ones that contain multiple 999c? SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag=999]/subfield[@code=c]') AS comp FROM biblioitems This is totally untested, but you might be able to use the XPath count() function in your ExtractValue. So,: ExtractValue(marcxml, 'count(//datafield[@tag=999]/subfield[@code=c])') An example here: http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html#function_extractvalue Note that it looked like your data also had multiple entries in one 999 $c field, separated with '|'. That's weird, and this won't find that. On the other hand, you can just do WHERE field LIKE %|% to catch those. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 3.16 beta available
Hi, A beta release of Koha 3.16 is available for download at http://download.koha-community.org. More details, including draft release notes, can be found at http://koha-community.org/koha-3-16-beta-released/. I strongly encourage folks to download and test the beta release. General release of 3.16.0 is scheduled to occur on Thursday, 22 May. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: g...@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web:http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org http://evergreen-ils.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha