- Koha - lists.katipo.co.nz

newbie: items from Follet export
by Nigel Barker 04 Jul '11

04 Jul '11

Dear All, I am the IT teacher at a very small school. For several years we have been running debian-edu/skolelinux on our servers and workstations. So when the librarian (who is a part-time volunteer and doesn't know anything about library systems) told me the ageing Follet system would no longer allow her to add books, I naturally turned to Koha. I have a test instance running, and I can bulkmarcimport.pl the marc records exported from Follet. So here is my question: Although the marc export from Follet had the "include copy info" box checked, and I can see the barcodes in the microlif.001 file, the catalogue on Koha has no items available for any record, and there are no barcodes showing. I am hoping someone with Follet migration experience will know what I have to do. Thanks! -- nigel Hiroshima International School

3 6

Reminder: Koha NZ Users group meeting.
by Joann Ransom 04 Jul '11

04 Jul '11

Hi all, Just a reminder about the upcoming Koha NZ User Group meeting in Levin on 26th July. Details and registration here: http://kete.library.org.nz/site/topics/show/216-nz-koha-users-group-meeting Cheers Jo. -- Joann Ransom RLIANZA Head of Libraries, Horowhenua Library Trust.

1 0

A couple of questions about Koha
by Christine Othitis 03 Jul '11

03 Jul '11

Hi group, I am new to the list and helping a non-profit organization out that is using Koha. I have a couple of questions. Is it possible to have polyhierarchy in Koha? They have some materials that don't categorize in one place very well. Also, I noticed that it looks like you can import a collection into Koha. Right now the organization's holdings are in an Excel spreadsheet. What needs to happen to the data before it can be migrated? Thanks, Christine

2 2

Invitation to connect on LinkedIn
by vikas salunkhe via LinkedIn 02 Jul '11

02 Jul '11

LinkedIn ------------ vikas salunkhe requested to add you as a connection on LinkedIn: ------------------------------------------ Marshall, I'd like to add you to my professional network on LinkedIn. - vikas Accept invitation from vikas salunkhe http://www.linkedin.com/e/-soc22i-gpm8nug7-4f/iF9pAju08sBE6lI-KHwOLjWiaq4y2… View invitation from vikas salunkhe http://www.linkedin.com/e/-soc22i-gpm8nug7-4f/iF9pAju08sBE6lI-KHwOLjWiaq4y2… ------------------------------------------ DID YOU KNOW that LinkedIn can find the answers to your most difficult questions? Post those vexing questions on LinkedIn Answers to tap into the knowledge of the world's foremost business experts: http://www.linkedin.com/e/-soc22i-gpm8nug7-4f/ask/inv-23/ -- (c) 2011, LinkedIn Corporation

1 0

Koha - insecure = off
by matsyuf 01 Jul '11

01 Jul '11

I am experiencing something here.. as i was reading a manual.. i wentto system preference and under insecure i change it to "yes" as i was trying to see what will happen however now i cant turn it back to now as it says am not logged in and i dont see the long page. What can i do to get this back to normal. -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-insecure-off-tp4305490p4305490.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 2

Report Help
by Nicole Engard 01 Jul '11

01 Jul '11

Hi all, I wrote this report to get all subject headings in a Koha system that start with key phrases: SELECT lcsh FROM (SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="610"]/subfield[@code>="a"]') AS lcsh FROM biblioitems) AS subjects WHERE lcsh LIKE "College%" OR lcsh LIKE "Seminary%" GROUP BY lcsh What's happening is if there is more than one 610 on a bib record it's showing them both on one line. I tried using DISTINCT, but that's didn't do the trick, so I'm up for ideas. Nicole

4 7

Edting label-create-pdf.pl does not make effect
by tanzeem 01 Jul '11

01 Jul '11

I edited label-create-pdf but no chnges was effected. Should i do any further steps to make the changes effected -- View this message in context: http://koha.1045719.n5.nabble.com/Edting-label-create-pdf-pl-does-not-make-… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Amazon Associate and AmazonAssocTag
by WTC 01 Jul '11

01 Jul '11

Hello. I'm using Koha 3.2.9 and have a query about AmazonAssocTag. I've entered my associate id for Amazon.co.uk and also the AWS Private Key and AWS Access Key ID. My assumption is that if a patron clicks on a cover image when they are taken to Amazon the associate id should also transfer over so that if they purchase the book we get our 5%. However, when clicking on the image the URL doesn't include the associate id so I don't see how Amazon will know that we sent them a customer. Is there a bug? Or is there another option I need to select. Does it work on Amazon.co.uk or only Amazon.com? Our installation is: http://library.wtctheology.org.uk/ Many thanks for your help. -- View this message in context: http://koha.1045719.n5.nabble.com/Amazon-Associate-and-AmazonAssocTag-tp453… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Share Koha-LDAP conf
by Oscar Gaona 01 Jul '11

01 Jul '11

Hi all There are many questions and solutions around Koha-LDAP connection / authentication, so it seems there is not a only way to get it because each Library / Institution has its own requirements / developments. If you has a successful / useful experience on this topic, may you share how you do it, please? Obviously, changing some real names / IP's Sometimes, examples are the better way to support people looking for solutions... Thanks in advance. Oscar G.

4 5

SQL for items with a lot of holds
by Cindy Weber 01 Jul '11

01 Jul '11

I'm trying to write a report that will list items with the number of holds/items over a certain number and then list the number of holds placed per library. Since the holds to items ratio is different depending on the format of the item (book, DVD, CD, etc.) I'm thinking I've got to have one report for each item type. My initial attempt: SELECT biblio.biblionumber, reserves.branchcode AS 'Library', biblio.title AS 'Title', COUNT(items.biblionumber) AS 'Copies', COUNT(reserves.biblionumber) AS 'Holds' FROM biblio LEFT JOIN items ON (items.biblionumber = biblio.biblionumber) LEFT JOIN reserves ON (reserves.biblionumber = items.biblionumber) LEFT JOIN biblioitems ON (biblioitems.biblionumber = biblio.biblionumber) WHERE items.ccode = 'BK%' GROUP BY biblio.biblionumber HAVING (COUNT(reserves.biblionumber)/COUNT(items.biblionumber)) > 15 When trying to troubleshoot why this didn't return any results, I discovered that SELECT biblio.title, COUNT(items.biblionumber), COUNT(reserves.biblionumber) FROM biblio JOIN items ON (items.biblionumber = biblio.biblionumber) JOIN reserves ON (reserves.biblionumber = biblio.biblionumber) returned really large numbers and the items and holds numbers wer all equal. For a specific bibionumber, it gave me 520 for both the count of items and the count of reserves. There are 8 holds and 65 items for that biblionumber. So it's multiplying the two counts together and returning that as the result. Changing the JOIN types didn't help any. Can anyone please tell me what I'm doing wrong and how to fix this? Thanks! Cindy -- Cindy Weber cweber(a)scls.lib.wi.us System Support Specialist (608)242-4710 South Central Library System

3 2