Greetings to all How to convert data of microsoft acces into marc base guide me in this process. And also help me the list tags which mostly used in koha cataloging data entry and they cover all type of library material e.g books . encyclopedias.almanics.cd.micro film.journal.magazine etc. On 1/26/15, koha-request@lists.katipo.co.nz <koha-request@lists.katipo.co.nz> wrote:
Send Koha mailing list submissions to koha@lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."
Today's Topics:
1. Re: Catalogue - SQL Report Help (Indranil Das Gupta) 2. Re: Taxonomy and Enquiry Management features within KOHA (Zeno Tajoli) 3. Re: Taxonomy and Enquiry Management features within KOHA (adnan adil)
----------------------------------------------------------------------
Message: 1 Date: Sun, 25 Jan 2015 14:14:36 +0530 From: Indranil Das Gupta <indradg@gmail.com> To: SATISH <lis4satish@gmail.com> Cc: koha list <koha@lists.katipo.co.nz> Subject: Re: [Koha] Catalogue - SQL Report Help Message-ID: <CAEm3SZ1Vh2BG=G3awd_AFG=PHFEhk5srQoU2DjBws_R1vdyQNQ@mail.gmail.com> Content-Type: text/plain; charset=UTF-8
Hello,
On Sat, Jan 24, 2015 at 1:17 PM, SATISH <lis4satish@gmail.com> wrote:
can you please help me how to alter this code, so that , It could fetch only non-repeatable/unique records ( by collection code -or- merging all collections codes) only including item types =book and =book bank.
You have answered your own question :) You simply need to insert an AND to WHERE clause. Google up basic SQL syntax that should get you going.
-idg
-- Indranil Das Gupta
Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards.
For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org
------------------------------
Message: 2 Date: Sun, 25 Jan 2015 10:46:18 +0100 (CET) From: Zeno Tajoli <z.tajoli@cineca.it> To: adnan adil <aidnan.adil@gmail.com> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Taxonomy and Enquiry Management features within KOHA Message-ID: <741774154.1695982.1422179178956.JavaMail.root@cineca.it> Content-Type: text/plain; charset=utf-8
Dear Adnan,
We're looking to possibly embed two features in our LMS: first, an enquiry management system feature (we do have 'ask a librarian' service);
probably the software code to do an 'ask a librarian service' is not very adapt to be insert in Koha sources. In fact checking https://foss4lib.org/ and Google there isn't a free open source software for a 'ask a librarian service'.
-You can buy a specific product, as https://libraryh3lp.com/ask-a-librarian
-Ask to Florida 'Ask a Library' what they use, http://info.askalibrarian.org/
-Implement the service with a generic reletion managment system with a web chat, like http://www.citadel.org/doku.php/doku.php?id=start
To connect the service an koha you need only to insert a link in Koha Opac. To do this task see: http://www.koha.org/library/resources/Documentation/OPAC-Customization.pdf http://www.myacpl.org/koha/ https://sometimesmotion.wordpress.com/ ttp://wiki.koha-community.org/wiki/JQuery_Library
and secondly, to adopt hierarchy-based taxonomy scheme (as opposed to keywords only). See example at: http://www.nphl.nhs.uk/
In fact you are speacking about a classification. To insert data only, you need to select the MARC21 code in cataloguing. For generic classification the code is 084.
Now you need to experiment by yourself. Try to integrate 084 with an authority. Try to use an authority 'thesaurus' type. Try the solr browse hack of Stefano Bargioni, http://www.slideshare.net/stefanobargioni/adding-browse-tokohausingsolr
If it is not enough, you can try to develop your solution with specific cgi (perl .pl) and web templates (template toolkit .tt)
Bye Zeno Tajoli
------------------------------
Message: 3 Date: Sun, 25 Jan 2015 10:30:24 +0000 From: adnan adil <aidnan.adil@gmail.com> To: Zeno Tajoli <z.tajoli@cineca.it> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Taxonomy and Enquiry Management features within KOHA Message-ID: <CAON_9QmPPWXPiZ7CjhmpzDuASSfC6+QcmRFohrUuGa2MH-WNXw@mail.gmail.com> Content-Type: text/plain; charset=UTF-8
Dear Zeno,
Thank you so much for your swift & thorough reply. Much appreciated. Service model for our 'ask a librarian' is different; as its only opened to internal staff via intranet (not through chat box). Hence enquiry management is more like a 'enquiry tracking. I was looking something like this solution:
http://www.baileysolutions.co.uk/enquiry-tracking
I am also open to embed 'off-the-shelf' (commercial product), which can be opted to deliver this functionality. I came across RT (an open source product) https://www.bestpractical.com/rt/ ; was wondering if anyone has experimented this before.
Kind regards
Adnan
On Sun, Jan 25, 2015 at 9:46 AM, Zeno Tajoli <z.tajoli@cineca.it> wrote:
Dear Adnan,
We're looking to possibly embed two features in our LMS: first, an enquiry management system feature (we do have 'ask a librarian' service);
probably the software code to do an 'ask a librarian service' is not very adapt to be insert in Koha sources. In fact checking https://foss4lib.org/ and Google there isn't a free open source software for a 'ask a librarian service'.
-You can buy a specific product, as https://libraryh3lp.com/ask-a-librarian
-Ask to Florida 'Ask a Library' what they use, http://info.askalibrarian.org/
-Implement the service with a generic reletion managment system with a web chat, like http://www.citadel.org/doku.php/doku.php?id=start
To connect the service an koha you need only to insert a link in Koha Opac. To do this task see: http://www.koha.org/library/resources/Documentation/OPAC-Customization.pdf http://www.myacpl.org/koha/ https://sometimesmotion.wordpress.com/ ttp://wiki.koha-community.org/wiki/JQuery_Library
and secondly, to adopt hierarchy-based taxonomy scheme (as opposed to keywords only). See example at: http://www.nphl.nhs.uk/
In fact you are speacking about a classification. To insert data only, you need to select the MARC21 code in cataloguing. For generic classification the code is 084.
Now you need to experiment by yourself. Try to integrate 084 with an authority. Try to use an authority 'thesaurus' type. Try the solr browse hack of Stefano Bargioni, http://www.slideshare.net/stefanobargioni/adding-browse-tokohausingsolr
If it is not enough, you can try to develop your solution with specific cgi (perl .pl) and web templates (template toolkit .tt)
Bye Zeno Tajoli
------------------------------
Subject: Digest Footer
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
End of Koha Digest, Vol 111, Issue 37 *************************************