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, [email protected] <[email protected]> wrote: > Send Koha mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: SATISH <[email protected]> > Cc: koha list <[email protected]> > Subject: Re: [Koha] Catalogue - SQL Report Help > Message-ID: > <CAEm3SZ1Vh2BG=G3awd_AFG=phfehk5srqou2djbws_r1vdy...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hello, > > On Sat, Jan 24, 2015 at 1:17 PM, SATISH <[email protected]> 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 <[email protected]> > To: adnan adil <[email protected]> > Cc: [email protected] > Subject: Re: [Koha] Taxonomy and Enquiry Management features within > KOHA > Message-ID: <[email protected]> > 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 <[email protected]> > To: Zeno Tajoli <[email protected]> > Cc: [email protected] > Subject: Re: [Koha] Taxonomy and Enquiry Management features within > KOHA > Message-ID: > <caon_9qmppwxpiz7cjhmpzduassfc6+qcmrfohruuga2mh-w...@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 <[email protected]> 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 > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > End of Koha Digest, Vol 111, Issue 37 > ************************************* > _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
