- Koha - lists.katipo.co.nz

Help with ExportWithCsvProfile
by Nicole Engard 25 Jul '14

25 Jul '14

I created a CSV Profile (that obviously isn't right) http://screencast.com/t/49bnF9SY1 , named it 'checkouts, and then set the ExportWithCsvProfile preference to 'checkouts'. When I exported I got a blank CSV file. Can someone tell me how to use this preference to get a list of the patron's checkouts as a CSV file? I will share your example in the manual. Thanks Nicole

3 3

Building OAI sets - additional question
by Steve Sowder 25 Jul '14

25 Jul '14

Does the program build_oai_sets.pl need to know which setname to build? Without a setname does it build an OAI-PMH file with the entire database as content? Steve sowder(a)andrews.edu

2 1

Acquisitions Report Help
by Nicole Engard 25 Jul '14

25 Jul '14

While waiting for a solution to bug 10461 , could someone help me with a report to get accurate information. I'm looking for: Year-to-date, sorted by fund code showing funds allocated - [funds spent + tax] = funds available. Thanks in advance! Nicole

1 0

A Koha hackmeeting in Italy at November
by Zeno Tajoli 25 Jul '14

25 Jul '14

Hi to all, I write to all you because I'm starting to plan about the topic. So, what do you think about an Koha hackermeeting in Italy at November ? More exctly near Milan in Segrate in our building. http://www.cineca.it/en/content/where-we-are-located We have free place in our meeting rooms at 13-14/Nov/2014 and at 20-21/Nov/2014. The plan for release 3.18.0 is 22 Nov 2014. Language: English with italian librarians Do you think is it useful ? Do you have a preference about the date ? Bye Zeno Tajoli -- Dr. Zeno Tajoli Soluzioni per la Ricerca Istituzionale - Automazione Biblioteche z.tajoli(a)cineca.it fax +39 02 2135520 CINECA - Sede operativa di Segrate

1 0

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