- Koha - lists.katipo.co.nz

SQL help request
by Kerrie Stevens 10 Nov '16

10 Nov '16

How would I insert another column in the results table of this report to show the biblio number as well? I keep getting syntax errors with everything I try. SELECT barcode, itemcallnumber FROM items WHERE datelastseen < CAST(<<Date of stocktake (YYYY-MM-DD)>> AS DATETIME) AND homebranch = <<Choose branch|branches>> AND itemnumber NOT IN (SELECT itemnumber FROM issues) ORDER BY barcode Thank you for your help, Kerrie

2 1

Please unsubscribe the xanana gusmao reading room from this list
by XGRR 10 Nov '16

10 Nov '16

Del Bovill Resource Centre Management Adviser Xanana Gusmão Reading Room. with NZ Volunteer Service Abroad (VSA) Rua Belamino Lobo No 1, Lecidere, Dili, East Timor Ph: +670 3312890 Mob: +670 78239745 Email: delbovill(a)gmail.com Email: xgreadingroom(a)gmail.com

2 1

Re: [Koha] Linking subject authority records to 650 via MarcEdit?
by Paul A 09 Nov '16

09 Nov '16

At 08:26 PM 11/8/2016 +0000, Craig Butosi wrote: >Hi Brain Trust, >Koha 16.05.03 on Ubuntu 14.04 (package install) >I am seeking advice for the following: >Problem: 650 field text in bib records are not linked to Koha authorities >database (via $9), but the text itself has been validated against LCSH >(using OpenRefine). In other words, the text is in its authorized form, >just not linked to its auth record. Question: how were your biblio records created? Manually? Z39.50? or some sort of other "import"? We have experienced, over the years, a few problems, but intrinsically can see a "9 (RLIN)" for every 650 entry. The biggest problem is that if -- for whatever reason, accident, stupidity, IT -- you have *two* authorities, same text, different RLIN, and the cataloguer doesn't do a "search, choose" for a 650, then you get yet *another* RLIN adding up to eventually hundreds of non-cross-referenced but identical "authorities." If there's only one, single RLIN, then Koha finds it, uses it, perfection... I'm fairly certain that most of our "duplicate RLINs" were my fault when I migrated ($deity forbid) Excel flat files through the 2010 version of MarcEdit. I was wet behind the ears, knew nothing, and in a hurry -- it's been biting me ever since ;={ And there's no (apparent) simple manner to sort it out, except go manually through every authority... But I'm at a loss to understand how you can "save" a biblio without the 650 creating its own (proper or duplicate/erroneous) RLIN. Disclaimer: Koha 3.8.24 from tarball. Best -- Paul >Solution: Link 650 field data with its extant authority using MarcEdit > >Process: > > >1. Run a Koha report to extract biblionumbers from records based on >some Subject (i.e., "Symphonies") > >2. Import these records from Koha into MarcEdit using the batch >search function on "Record Number" (upload a plain-text file with >biblionumbers only) > >3. Check that 650 data is in its authorized form. > >4. Append a $9 subfield with the appropriate RLIN number to the >batch (i.e., 650 //$aSymphonies --> 650 //$aSymphonies $917) > >5. Upload batch back into Koha db. > >Questions: > > >1. Have any of you linked authority records to controlled variable >fields using this method? > >2. Is there anything I am missing? > >3. Is this an utterly dangerous and careless way to be linking >controlled fields to the Koha authorities db? > >Thank you! > >C > >Craig Butosi, MA, MLIS, B Mus (Hons.) >LIBRARY SERVICES MANAGER >the royal conservatory >TELUS Centre for Performance and Learning >273 Bloor Street West >Toronto, ON M5S 1W2 >416.408.2824 x338 >www.rcmusic.ca<http://www.rcmusic.ca/> > > > >Note: This email message and any attachments are intended only for the use >of the individual to which it is addressed, and may contain information >that is privileged, confidential and exempt from disclosure under >applicable law. If the recipient of this email is not the intended >recipient (or the employee or agent responsible for delivering the email >to the intended recipient), you are hereby notified that any review, >dissemination, distribution or copying or other use of this message is >strictly prohibited. If you have received this communication in error, >please notify the sender immediately by return email and delete this >message and attachments from your system, thank you. >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >https://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>

4 3

koha-conf.xml empty
by Angela 09 Nov '16

09 Nov '16

I've just installed stable on Debian Jessie. Apache2, Perl, and MySQL all seem fine. Both interfaces load in the browser. Alas, koha-conf.xml seems to be empty. The file is there. I can paste the one from github, of course, but I'm not sure what all must be edited. Any help appreciated. Best regards, Angela -- View this message in context: http://koha.1045719.n5.nabble.com/koha-conf-xml-empty-tp5910363.html Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Koha development meeting reminder - 9 November 2016
by Nick Clemens 08 Nov '16

08 Nov '16

Hi All, The next Koha development meeting is on IRC tomorrow 9 November 2016 at 19:00 UTC You can see what that is in your local time here: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+I… Agenda is here: https://wiki.koha-community.org/wiki/Development_IRC_meeting_9_November_2016 Please make sure to add any topics you wish to discuss. I will be chairing the meeting so I can learn, so attend and be nice :-) -Nick

1 0

non-XSLT views
by Tomas Cohen Arazi 08 Nov '16

08 Nov '16

Is anyone NOT using teh XSLT-driven views on their OPAC? Thanks in advance -- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F

2 1

a request to be added
by Daniel Deogratus 08 Nov '16

08 Nov '16

Company Name: Automate Tanzania Contact Person: Deogratus Daniel Contact email:info@automate.co.tz / ddeogratus(a)gmail.com Website:http://automate.co.tz Telephone:+255768021321 / +255 62 107 5749

3 3

Re: [Koha] Koha Community Marketing Initiative
by BOUIS Sonia 08 Nov '16

08 Nov '16

Hello Nathan, It's a great idea. Perhaps, I could try to write small content on the use of Koha in academic libraries in France (10 universities and almost the same number of "grandes écoles") Cheers, Sonia Message: 7 Date: Mon, 7 Nov 2016 10:09:42 -0500 From: Nathan Curulla <nate(a)bywatersolutions.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] Koha Community Marketing Initiative Message-ID: <BFA22242-9780-4FE3-B1F5-A1853D878296(a)bywatersolutions.com> Content-Type: text/plain; charset=us-ascii Greetings fellow Koha users! During the last general IRC meeting it was decided that it is time we got serious about marketing Koha globally as a community. There is still too much misunderstanding and fear based on misconceptions circulated by the larger proprietary ILS systems and it is time we fight back and educate our librarians on the realities of what we do. I will be heading up this initiative and would like to see who else is interested in taking part. For now, we have no budget for this so most of the marketing will be content that is created during volunteer time such as more regular press regarding features, website content, blog posts and social media. If you have experience marketing products or have a desire to be involved by writing content and directing the message we are trying to put out please let me know and we can put together a committee. Thanks much and I am excited to get our message out to a broader global user base! All the best, -Nate > Nathan A. Curulla > Owner, CRO > ByWater Solutions > Support and Consulting for Open Source Software > Headquarters: Portland, OR. > East Coast Office: Redding, CT. > Phone/Fax # (888) 900-8944 xt 2 > Cell # (203) 685-7207 > http://bywatersolutions.com <http://bywatersolutions.com/> > nate(a)bywatersolutions.com <mailto:nate@bywatersolutions.com> ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 133, Issue 13 *************************************

1 0

.mrc file import issue
by Via Vitae Solutions 08 Nov '16

08 Nov '16

Hi, I am new to Koha. I am facing some problem regarding database. If I want to import a .mrc file after truncating biblio, biblioitems and items tables, then the biblionumber is increasing. For example, if I truncate 3000 rows from the above tables, then after impoting the .mrc file, it is starting from 3001. If you kindly help why I am not getting biblionumber 1 second time, then I will be grateful. -- Via Vitae Solutions Kolkata - 700064 India

2 1

Koha Community Marketing Initiative
by Nathan Curulla 08 Nov '16

08 Nov '16

Greetings fellow Koha users! During the last general IRC meeting it was decided that it is time we got serious about marketing Koha globally as a community. There is still too much misunderstanding and fear based on misconceptions circulated by the larger proprietary ILS systems and it is time we fight back and educate our librarians on the realities of what we do. I will be heading up this initiative and would like to see who else is interested in taking part. For now, we have no budget for this so most of the marketing will be content that is created during volunteer time such as more regular press regarding features, website content, blog posts and social media. If you have experience marketing products or have a desire to be involved by writing content and directing the message we are trying to put out please let me know and we can put together a committee. Thanks much and I am excited to get our message out to a broader global user base! All the best, -Nate > Nathan A. Curulla > Owner, CRO > ByWater Solutions > Support and Consulting for Open Source Software > Headquarters: Portland, OR. > East Coast Office: Redding, CT. > Phone/Fax # (888) 900-8944 xt 2 > Cell # (203) 685-7207 > http://bywatersolutions.com <http://bywatersolutions.com/> > nate(a)bywatersolutions.com <mailto:nate@bywatersolutions.com>

2 1