- Koha - lists.katipo.co.nz

Re: [Koha] Query for report on items catalogue in a date.
by Paul 27 Aug '13

27 Aug '13

At 08:17 PM 8/27/2013 +0000, Gay Richards wrote: >Paul >This is great. I was looking for this too. Unfortunately the html doesn't >seem to work when downloaded to csv but I guess I could remove that. Without the html, it is a little shorter: SELECT biblio.title AS Title, biblio.author AS Author, items.barcode AS Barcode FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) WHERE DATE(items.dateaccessioned) BETWEEN <<Accessioned BETWEEN (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> Best - Paul >Thanks, Gay > >Gay Richards >Information Specialist >New Zealand Family Violence Clearinghouse >Tâmaki Innovation Campus >The University of Auckland >Ph: (09) 923 4640 > > > 09 923 4640 | www.nzfvc.org.nz | info(a)nzfvc.org.nz > >-----Original Message----- >From: koha-bounces(a)lists.katipo.co.nz >[mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Paul >Sent: Wednesday, 28 August 2013 2:26 a.m. >To: koha(a)lists.katipo.co.nz >Subject: Re: [Koha] Query for report on items catalogue in a date. > >At 04:41 AM 8/27/2013 -0700, Akin Adigun \(Akinomatics\) wrote: > >I want the title, author, barcode for all items catalogue in a date or > >range of date > >SELECT CONCAT('<a >href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',items.biblionumber,'\">',biblio.title,'</a>') >AS Title, biblio.author AS Author, >items.barcode AS Barcode >FROM items >LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) >WHERE >DATE(items.dateaccessioned) BETWEEN <<Accessioned BETWEEN (yyyy-mm-dd)>> >AND <<and (yyyy-mm-dd)>>; > >Best - Paul > >--- >Maritime heritage and history, preservation and conservation, research and >education through the written word and the arts. ><http://NavalMarineArchive.com> and <http://UltraMarine.ca> > >_______________________________________________ >Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

2 1

Re: [Koha] Query for report on items catalogue in a date.
by Paul 27 Aug '13

27 Aug '13

At 04:41 AM 8/27/2013 -0700, Akin Adigun \(Akinomatics\) wrote: >I want the title, author, barcode for all items catalogue in a date or >range of date SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',items.biblionumber,'\">',biblio.title,'</a>') AS Title, biblio.author AS Author, items.barcode AS Barcode FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) WHERE DATE(items.dateaccessioned) BETWEEN <<Accessioned BETWEEN (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>>; Best - Paul --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

2 1

Re: [Koha] "Check-Box Missing": Serial > Claims
by HRS 27 Aug '13

27 Aug '13

Hi!, Brooke Thank you showing me but even 3.12 manual( http://koha-community.org/documentation/) , the check boxes are available but in my installation( 3.12) they are not. what strange? it is a bug? help please Harsha The Open University-Sri Lanka > But Manual shows there are check box to do? the selction URL: > http://manual.koha-community.org/3.4/en/serialclaims.html > > Koha? Version : 3.12.01.00 > Please help me ,Thanks in advance > ??? You appear to be following the 3.4 manual to get directions for 3.12. Perhaps if you follow the links from http://koha-community.org/documentation/ ??? For your installation, you will enjoy greater success. :)

1 0

Re: [Koha] Who is Live DVD manager of version 3.12.x?
by Vimal Kumar V. 27 Aug '13

27 Aug '13

Dear Friends, Thank you for the explanation by Tomas. Thank you for the reply by Jared and Mark. Forgive me, if my words hurt you. I hope that next IRC meeting will discuss about Live DVD. Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

3 3

Re: [Koha] (no subject)
by Doug Dearden 27 Aug '13

27 Aug '13

Richard, If you have successfully installed Koha and can login to the staff client, then you have the basic installation done and are moving into the "librarian" steps. Check out the documentation here: http://koha-community.org/documentation/ . For migration you might need a tool like MarcEdit . You will find it and supporting info here: http://people.oregonstate.edu/~reeset/marcedit/html/index.php A couple of other things, when responding to posts make sure you include the email address of the list, as you are more likely to find the help you need from the group rather than from one person. Also, include a Subject on your email. It helps us identify those questions we might have some chance of answering as opposed to those that are out of our area of expertise. Best, Doug From: Richard Maileseni [mailto:rmaileseni@gmail.com] Sent: Monday, August 26, 2013 5:17 PM To: Doug Dearden Subject: Re: [Koha] (no subject) Thanks Doug. appreciate all the help! but could you direct me to where i could get the manual for setting up library in koha. Im quite new here and I have no library experience, im a student working on a project for our school. my task is to do a migration and I have just finished installing koha on ubundu server. could you please direct me to what i might have to do next. Cheers Richard On Tue, Aug 27, 2013 at 10:04 AM, Doug Dearden <dearden(a)sarsf.org<mailto:dearden@sarsf.org>> wrote: Richard, This has to do with your network setup. As it says in the Assumptions right above the Tweak Hosts File entry, you need some help from your network folks on this one. The instructions add the two lines to the /etc/hosts file. These point the names for the OPAC and the staff client to the local loopback address. This allows you to connect to the web installer from the same machine you are installing on in the following "Web Installation" step. Best, Doug -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz<mailto:koha-bounces@lists.katipo.co.nz> [mailto:koha-bounces@lists.katipo.co.nz<mailto:koha-bounces@lists.katipo.co.nz>] On Behalf Of Richard Maileseni Sent: Monday, August 26, 2013 1:55 AM To: koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> Subject: [Koha] (no subject) hi guys! Please can anyone explain the "Tweak Host File" step in http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages thanks. _______________________________________________ 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 -- Richard W. Maileseni Mob: 027-934-2039 PH: 042367222 Email: lisiate.maileseni(a)tti.to<mailto:lisiate.maileseni@tti.to> facebook: www.facebook.com/rmaileseni<http://www.facebook.com/rmaileseni> scype: ma_richie ~\\~

1 0

"Check-Box Missing": Serial > Claims
by HRS 27 Aug '13

27 Aug '13

Hi Check Boxes are missing in Serial > Claims > Late selections list . So I cannot export item more than one vendor. But Manual shows there are check box to do the selction URL: http://manual.koha-community.org/3.4/en/serialclaims.html Koha Version : 3.12.01.00 Please help me ,Thanks in advance Harsha Balasooriya Senior Assistant Librarian, System The Open University of Sri Lanka

2 1

Query for report on items catalogue in a date.
by Akin Adigun (Akinomatics) 27 Aug '13

27 Aug '13

Helllo All, I am running Koha 3.04 on Ubuntu server, I need a query to generate a report on Items catalogue in a date or range of date. e.g items catalogue on 01/01/2013 or items calaglogue between 01/01/2013 to 31/01/2013

3 4

Re: [Koha] Querry related to Deletion in KOHA.
by Adalid Ortiz 27 Aug '13

27 Aug '13

Try run a full reindex. We solve similiar problem this way. When deleted a record they remain searchable by the opac and send a 404 error message when clic on it. FAOA Biblioteca Loyola http://clavius.tij.uia.mx

3 5

IRC Meeting to Update KohaCon 13 Progress
by Keener, Nancy 27 Aug '13

27 Aug '13

There will be an IRC meeting on Wednesday August 28 to update everyone on the KohaCon 13 progress. Meeting time is 18 UTC. http://www.timeanddate.com/worldclock/fixedtime.html?msg=IRC+Planning+Meeti… UTC converter http://koha-community.org/get-involved/irc Get on the IRC Register for the free conference here http://koha-community.org/kohacon/kohacon13 Nancy Keener Systems Librarian I.T.O.S.C. Chair KohaCon 13 Chair Washoe County Library System Reno, Nevada 775 327-8347 nkeener(a)washoecounty.us

2 1

Apology
by Alice Esguerra 27 Aug '13

27 Aug '13

Dear Koha Community: My sincere apology for erroneously sending you a message which is not related nor beneficial to Koha and the Koha Community. Although it was not a spam message as it was an issue and an advocacy, it was inadvertently sent to this list. Again, my sincere apology to the group. Respectfully, alicia esguerra -- Alicia C. Esguerra Associate Professor I/ Librarian Bulacan State University City of Malolos, Bulacan 3000 Philippines +63 044 7961417 www.bulsu.edu.ph

2 1