- Koha - lists.katipo.co.nz

Easykoha latest live DVD 3.16.2 and open proposal to conduct workshop
by Vinod Kumar Mishra 25 Jul '14

25 Jul '14

Dear All, Easykoha a live DVD of latest Koha version (3.16.2) has been nicely made with customized bootstrap home page and teamviewer has been also packed in the live dvd so that any body can assist you remotely if needed. Please download and install for any purpose and feel free to contact if any help needed. Koha Live DVD : https://sourceforge.net/projects/vkmkoha/ Open proposal to conduct workshop We are working over open source software';s for the Libraries and willing to assist on the same. Many institutes are getting benefits and contacting us for implementation of the above but unfortunately due to some financial/administrative reasons they may not able to do that. Therefore i propose all specially new institutes who has not yet automated, developed repository, website etc. to organize one workshop on these topics and we ensure you to set up above during the period of workshop for your Library and if possible nearby libraries too. I feel lot of people will be benefited and new libraries will get good recognition in their institutes, as well as they need not to spend single penny over these software';s too. We accept only TA/DA (ready to travel by any mode/class depending upon the situation) and honorarium as per government rules (may be 1/2 thousand only). So if you are willing for the above please feel free to contact we will assist you in over all management/organization of the events too. Such workshops will have real/practical impact and strong bonding between the professionals for the benefit of LIS profession. For details contact: Vk mishra : 9439420860 Dp tripathi : 8895296796 Thanking You. With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librarian(a)rediffmail.com : mishravk79(a)gmail.com

1 0

Manual PDF Links Broken
by Nicole Engard 24 Jul '14

24 Jul '14

Hi all, It looks like the links to the PDFs on the documentation page are broken: http://koha-community.org/documentation/ Nicole

2 2

Add new serials
by Librarian for the Society of Jesus in South Africa 24 Jul '14

24 Jul '14

Hi I'm new on Koha, i'm struggling to add a new serials subscription ie The Tablet . I have done the budget part. *Francis.** * *On Thur*sday 24 July 2014 01:21 AM, koha-request(a)lists.katipo.co.nz wrote: > Send Koha mailing list submissions to > koha(a)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(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)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: Report help (Elaine Bradtke) > 2. Re: Report help (ramirouvia .) > 3. Re: Barcode generation in koha 2.2.9 Windows Version (xiaoyuandlg) > 4. Re: Report help (Elaine Bradtke) > 5. Report to find biblios without dates in 008 - needs work > (Elaine Bradtke) > 6. Koha 3.16.2 released (Galen Charlton) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 23 Jul 2014 19:57:26 +0100 > From: Elaine Bradtke <eb(a)efdss.org> > To: Robin Sheat <robin(a)catalyst.net.nz> > Cc: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Report help > Message-ID: > <CAPdfUuxn+=gBkZxgntAvRAskd8X16afksQHkU7_J_03RkZrnuQ(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > This is the basic report: > SELECT count(biblio.copyrightdate), biblio.copyrightdate,items.itype FROM > items LEFT JOIN biblioitems on > (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on > (biblioitems.biblionumber=biblio.biblionumber) GROUP BY > biblio.copyrightdate ORDER BY biblio.copyrightdate asc > > I also used an expanded version with more fields so I could see what the > numbers really mean. > > > - It doesn't pick up everything. A lot of our 18th and 19th century > publications have partial or conjectural dates in square brackets. These > seem to be ignored. > - It gives a count of the items. Not the biblios. So this skews the > count further (we have a lot of 18th century pamphlets bound together - > many biblios, but only one item record for the bound volume). > > Is there any way we can be more precise? > Would a query on the MARCXML for the 260 c produce a more accurate result? > Can we to force it to count biblios instead of items? > It may be we have to settle for doing the counting in the spreadsheet > rather than via Koha. But it would be nice to have some control over what > is counted. > > I know next to nothing about SQL, any help would be greatly appreciated. > > Thanks > > > > On Wed, Jul 23, 2014 at 12:31 AM, Robin Sheat <robin(a)catalyst.net.nz> wrote: > >> Elaine Bradtke schreef op di 22-07-2014 om 17:35 [+0100]: >>> One of my colleagues was asking if I could give statistics on what we >>> have >>> from the 17th, 18th and first half of the 19th century. Preferably by >>> year. >>> >> When my Elasticsearch work is finished, this'll be just a matter of >> finding an elasticsearch visualisation tool that lets you explore your >> data, and telling it to do what you want. >> >> The way I'd do it currently would be to script something that pulls the >> date from the MARC of each entry and exports that. Then you could pop it >> into libreoffice calc and make graphs or whatever you need. >> >> -- >> 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(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> > > -- Inline image *Mr Francis Zvigo* /Librarian/ Regional Library of the Society of Jesus in South Africa Mobile: +27 (74) 029-8901 | E-mail: SA-RegLibrary(a)sj.org.za | Web: http://www.sj.org.za/ Post: St Ignatius House, 15 Molesey Avenue Auckland Park, Johannesburg, 2092, South Africa

1 0

Report to find biblios without dates in 008 - needs work
by Elaine Bradtke 24 Jul '14

24 Jul '14

I'm halfway there: SELECT biblionumber, SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag="008"]'),8,4) as Date FROM biblioitems m LEFT JOIN biblio b USING (biblionumber) WHERE Date = '||||' Doesn't quite work. If I omit the last line, it spits out a list of all our biblios, and the date. I'd like to limit the results to just the biblios with |||| in the first date section of the 008 WHERE (Date = '||||') didn't work. NULL in place of '||||' doesn't work either. WHERE (ExtractValue(m.marcxml,'//controlfield[@tag="008"]'),8,4) = '||||' also didn't work. I've exhausted my cut and paste abilities. . . . -- Elaine Bradtke (What I don't know about SQL would fill a few books) 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)

2 1

Re: [Koha] Koha live dvd 3.14.08
by Vinod Kumar Mishra 24 Jul '14

24 Jul '14

No, how did you made live DVD now? if with remastersys than please confirm is it still working? because few day back i checked and found it does not work more now. On Thu, 24 Jul 2014 08:55:12 +0530 Quoc Uy wrote >I just updated from my old live dvd to latest oldstable version. Nothing special. Why did you ask? Did you get error to make new dvd? Sent from Yahoo Mail on Android > From: Vinod Kumar Mishra ; To: ; Cc: ; Subject: Re: [Koha] Koha live dvd 3.14.08 Sent: Thu, Jul 24, 2014 3:20:28 AM Dear Nguyen Quoc Uy, Are you able to make live DVD of latest version, if yes than please explain how? On Thu, 24 Jul 2014 06:36:04 +0530 Quoc Uy wrote >So this is second live dvd for version 3.14. Sorry all, i was so busy with my work and can';t make live dvd more frequently. You can download from here, don';t forget download koha-3.14.08_readme. koha-latest - Browse Files at SourceForge.net koha-latest - Browse Files at SourceForge.net No description View on sourceforge.net Preview by Yahoo Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn & http://vietnamlib.net _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librarian(a)rediffmail.com : mishravk79(a)gmail.comGet your own FREE website, FREE domain & FREE mobile app with Company email. �Know More > With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librarian(a)rediffmail.com : mishravk79(a)gmail.com

1 0

Koha live dvd 3.14.08
by Quoc Uy 24 Jul '14

24 Jul '14

So this is second live dvd for version 3.14. Sorry all, i was so busy with my work and can't make live dvd more frequently. You can download from here, don't forget download koha-3.14.08_readme. koha-latest - Browse Files at SourceForge.net koha-latest - Browse Files at SourceForge.net No description View on sourceforge.net Preview by Yahoo Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn & http://vietnamlib.net

2 1

Report help
by Elaine Bradtke 24 Jul '14

24 Jul '14

One of my colleagues was asking if I could give statistics on what we have from the 17th, 18th and first half of the 19th century. Preferably by year. So I guess I'm asking for a count by publication year. Any thoughts on the best way to approach this? -- 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)

4 5

Koha 3.16.2 released
by Galen Charlton 24 Jul '14

24 Jul '14

The Koha community is pleased to announce the release of version 3.16.2 of the Koha library automation system. Koha 3.16.2 is a bugfix release and can be downloaded from http://download.koha-community.org/ Debian packages of Koha 3.16.2 will be available shortly. Full release notes can be found at http://koha-community.org/koha-3-16-2-released/ Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)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

1 0

Cataloging questions
by Steve Sowder 23 Jul '14

23 Jul '14

I have altered the default framework to include marc tag 595. (590 is also there must I may have added that sometime ago.) 1. When loading records that have a 595 tag, and the framework includes it, what do I to get tag 595 contents to actually load? 2. When I edit a record neither the 590 nor the 595 is included in the list of the tags. What do I do to get the editor to include all of the tags that are in the framework? Thanks Steve Sowder Systems Librarian sowder(a)andrews.edu Andrews University

3 6

jquery : barcode triggers submit
by Chad Roseburg 23 Jul '14

23 Jul '14

Our cataloging department liked the short-lived behavior in 3.14 where scanning barcodes would submit forms [ no one else did ]. I decided to try and reintroduce that for the cataloging module only -- testing using greasemonkey. Here's what I've got so far [ doesn't work ]: $('tag_952_subfield_p_971027').keypress(function(e) { if ( e.which == 13 ) { $( "input[value='Save changes']").trigger('click'); } }); Any ideas? Thanks! Chad -- Chad Roseburg Automation Dept. North Central Regional Library

3 2