- Koha - lists.katipo.co.nz

Searching problem
by Dibyendra Hyoju 11 Dec '19

11 Dec '19

Hello All, I am having trouble searching some of the records in the database having a colon ":" punctuation mark in the titles such as "Marx at the Margins: On Nationalism, Ethnicity, and Non-Western Societies", "Bhutan: new pathways to growth", "Dayananda Sarasvati: his life and ideas", etc. However, I could search these records without typing a colon punctuation mark during the search just like "Bhutan new pathways to growth", "Dayananda Sarasvati his life and ideas". The complete title is in the 245a tag field without using remainder of the title. What could be the problem? I have rebuilt the index by issuing koha-rebuild-zebra -f -v <instance> twice but some of the titles mentioned above are still not searchable using full title including colon punctuation mark. I'd appreciate if anyone in the list could share the solution to this issue. Thank you. -- Dibyendra Hyoju

2 2

SQL help
by Kerrie Stevens 11 Dec '19

11 Dec '19

Our overall library collection is currently split between 2 different catalogues. The other catalogue can produce a report showing the number of opac searches (total, successful and unsuccessful) for each day of each month for the year. Can anyone help with how I can replicate that in Koha? Thank you, Kerrie Stevens Alphacrucis College Melbourne, Australia

1 0

Re: [Koha] Installation from Source Code
by Charles Kelley 10 Dec '19

10 Dec '19

Hello again, all! In a recent exchange, on 9 Dec. 2019, at 07:05, Franz Dietrich wrote: It is quite possible but a lot of work... I think it would be easier to > carry the server to an internet access install and setup everything then > bring it back to where it is supposed to run. > > because else the source code is only the first bit. You are needing all > the dependencies like SQL, PHP, etc. In addition to that you need all > development packages if you are building from source. > > So if it must be without internet I would setup a similar ubuntu with > internet access and install koha on it carefully noting everything that has > been installed and then download all those packages manually transfer them > to the server and install them there. - but still it is rather unlikely > that you will manage to install the server without internet in case of > problems (especially since this seems to be your first koha install). > > Another variant would be to create a virtual machine on a computer with > internet. Setup everything on the virtual machine and then transfer the > virtual machine to the target. > Later, on 9 Dec. 2019, at 09:07, Joel Coehoorn wrote: Another vote for the virtual machine option. That will make maintenance > over time so much easier. I was afraid of that. It is my first installation of Koha and it's my first substantive use of a Linux environment. In the last several months, I have installed Koha on virtual boxes through the package installer. The installation to run, of course, but I can't quite figure out how to copy it from one Linux environment to another. That's the trouble when one is used to strickly GUIs over terminals, I suppose. Again from Franz Dietrich: hope that helps. Yes, it does. Many thanks. -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 1-5-2 Tsukimino #210 Yamato-shi, Kanagawa-ken, 〒242-0002 JAPAN 1-301-741-7122 [US cell] 011-81-80-4714-5490 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

1 0

koha-US general meeting: Wednesday, December 11th, 2019
by Jason Robb 09 Dec '19

09 Dec '19

Date: Wednesday, December 11th, 2019 Time: 10:30 AM - 11:30 AM CST (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+general+m…> ) Location: https://kslib.zoom.us/j/110290143 Agenda: https://docs.google.com/document/d/1M3UVQzdil7kRHdXAC8cS9ePpaCXwcLOnnMvwpuh… With the year coming to a close, we have some housekeeping tasks to go through including the announcement of 2020 officers, a look at next year's budget, and information on membership renewal. We also have reports from the various committees on recent and upcoming initiatives. And as always, there will be time to discuss bugs, issues, upgrades, and all things Koha. If you have specific topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops, and Android and iOS on mobile devices. For help getting started, visit: https://support.zoom.us/hc/en-us/categories/200101697 These meetings are free and open to any and all. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Installation from Source Code
by Charles Kelley 09 Dec '19

09 Dec '19

Hello, everyone! We are installing Koha on a server that is off network and has no internet access. Is it possible to do this? I have downloaded the source code through the Koha-Community website, and I have printed-to-PDF the Packages and GIT instructions. We're installing on Ubuntu 18.3.4 LST. Many thanks for whatever insight you can give us. -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 1-5-2 Tsukimino #210 Yamato-shi, Kanagawa-ken, 〒242-0002 JAPAN 1-301-741-7122 [US cell] 011-81-80-4714-5490 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

3 2

CHAT/POETRY: exporting records cataloged on a certain date
by King, Fred 07 Dec '19

07 Dec '19

Esteemed colleagues: PLEASE NOTE: this entirely frivolous; please hit the delete key if you wish. Any opinions expressed here are mine and mine only, not necessarily shared by my employer, the Koha community, koha-US, or any poultry that might be associated with me. A while back I was trying to figure out a way to export records that I had just uploaded to Koha so I could get information in the 999 field. (So I could build a new RSS file with links to the bib in the MedStar Authors' Catalog, but that doesn't really matter at the moment.) "Export Data" wasn't working-the export files had zero bytes. While I was pondering a possible solution, the muse grabbed me by the keyboard and we produced a litter of couplets. Then someone (Katrin, was it you?) suggested unchecking the "With items owned by the following libraries" box, and it worked like a charm. That left me with an obsolete poem. I hate waste. What to do? Well, I added a few more couplets below the "-----" as an appendix wherein I reveal the solution. The meter gets a bit twisty in places, but it really does scan. I won't attest to the accuracy of all the information presented. I upload records by the score Into Koha's reservoir >From "Manage Records" dialog Import into the catalog Rebuild Zebra then I look To see what's new, with bib as hook. To find one is no chore at all Search for bib number? What a doll My Koha is! if only one Bib record I want and I'm done But now I want to see the batch That with my Koha I did hatch I want to see all that is new But soon I'm mired deep in glue Perhaps Reports will now display The records that I've done today. The Koha SQL collection Might point me in the right direction. Alas, I get an error message! It doesn't work! There's no expressage! Then from the menu Main I go To menu Tools, because I know That in the column Catalog Export Data, like a dog Has served me faithfully before And helped me through the catalog's door. Export records by the date they're cataloged? No bytes, not great. Export records by bib range? Still no bytes, it's very strange. If these don't work, what can I do To see my MARC creations new? Can I put them in a cart? All bibs selected, part by part? That seems to work; they are just fine Complete with MARC tag 999. But now I want to add a date 260$c--is it too late? I add the line and recompile Then upload the replacement file Check dups on field 097 A field I added--plucked from heaven Still I'd like to understand What happens to my little band Of records new that with my hand >From Reference Manager so grand I fashioned into format MARC So they can shine out in the dark To show the world what we have done In MedStar's realm of medicine Does anybody have some thoughts? I'd sure appreciate them, lots. For curiosity, you know, Librarians do not forgo. ---- BUT WAIT! I think I found a way To find additions for the day Most likely other specs as well But on this point I shall not dwell. >From Export Data uncheck the box For owning lib'ry, that unlocks The filter that prevents me from A happy, joyous MARC outcome. And if you have more than one branch "Clear all" allows the avalanche Without a lot of extra clicking. Make haste! I hear the clock is ticking. And that, my friends, is my solution That works well at my institution. And I'm reminded every day Where there's a Koha, there's a way. Fred King, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king(a)medstar.net<mailto:fred.king@medstar.net> 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org As we neared our sixties the cloaks we had wrapped about our essential selves were wearing thin. --Robertson Davies, Fifth Business ---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. Help conserve valuable resources - only print this email if necessary.

4 3

Re: [Koha] Source of Acquisition
by Charles Kelley 07 Dec '19

07 Dec '19

Hello, Fred! In our latest exchange, on 6 Dec 2019, at 12:42, you wrote: You probably know this already, possibly because I posted something similar > a few weeks ago, but MarcEdit has a Delimited Text Translator that makes > converting from a spreadsheet to MARC absurdly easy. You can see a very > short example in my "MarcEdit in three minutes" presentation at > http://avengingchicken.online/misc/king_marcedit_in_three_minutes_with_note… > and get MarcEdit at https://marcedit.reeset.net/ > Thank you, Fred. I'll look at your presentation in case you offer insights others do not. I do use MarcEdit for indicators, punctuation marks, and all kinds of things. It's easier in my particular case. I have watched other videos on YouTube and I've learned how to convert to MARC records from the Access DB through spreadsheets from the videos. The substantive questions are what information is to be ported over and in what format. My immediate problem is that no call numbers *per se* have been assigned, so I've had to make them up from four fields in order to keep the call numbers unique: the collection code, the Dewey number, an author code (which can serve as the Cutter number), and the library number all cobbled together right now. Easy enough, a little bit of concatenation does the trick. Take my venerable case, *A dictionary of Japanese and English idiomatic equivalents*. Collection code is GE for "General Shelves", Dewey code = 495.631, author code = WAE, and the acquisition number = 1986-1003. I concatenated everything together to make GE 495.631 WAE 1986-1003. I can put the collection code separate from the call number, of course, putting it in the shelving location field (952$c), and the call number will still be unique (or nearly so). But once I drop the library acquisition number, there are all kinds of collisions. On top of that, the acquisition number seems rather important to the library staff; and, as I wrote earlier, I'm too new to challenge them about it, especially if I can't provide a substitute or alternative. I'm trying to limit the collisions and provide for the staff's needs. After all, they too will have to work with the system. But do the staff still need the Access DB ID number? That's the substantive question in this matter. Probably not once we bring Koha alive, for the library acquisition number is probably enough. If they have to get information from the old Access DB, that ought to be enough, I would think. But I have to hear it from them, not just assert it myself and impose the assertion on them. I have worked with that type of manager before, and it brings about a deterioration in the morale and the working relationship between the manager and the staff. I want upper management and the staff to have confidence in me and KSATs; and for them to invest in the new system in order to make it work.* I know that's a tall, heavy order and a collectivist solution; but in my environment, it's ultimately the right one. So there are these questions and others that I'd like to get settled as soon as possible, certainly before we bring Koha online. It's harder to retroactively fix a catalog, any catalog. And it's worse when questions that could have been settled beforehand were not. The catalog can be fixed, mind you, but it's a lot more work both on the technical side and on the relational side. Thanks for your input, everyone. Keep it coming. Footnote * I know there are times when the manager has to assert timself and I may have to do so in some instances. But I don't think this is one of them. The establishment of a new ILS is too big for that. -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 1-5-2 Tsukimino #210 Yamato-shi, Kanagawa-ken, 〒242-0002 JAPAN 1-301-741-7122 [US cell] 011-81-80-4714-5490 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

1 0

Re: [Koha] Source of Acquisition
by Charles Kelley 07 Dec '19

07 Dec '19

Hello again, Alvaro! In our latest exchange, on 6 Dec. 2019, at 10:14, you wrote: I don't know if you can do the replacement/truncate the 952 from koha but > you can do it directly in mysq with a query like: > > > https://basitaalishan.com/2014/02/23/removing-part-of-string-before-and-aft… > > > https://stackoverflow.com/questions/7481361/how-to-remove-part-of-string-in… > > Of course you need to work the sample query to suit your needs. > > Hope this helps, > Yes, it does. I can change the relevant 952 fields before we upload the finished product into the new Koha server. Many thanks! -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 1-5-2 Tsukimino #210 Yamato-shi, Kanagawa-ken, 〒242-0002 JAPAN 1-301-741-7122 [US cell] 011-81-80-4714-5490 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

1 0

Re: [Koha] Source of Acquisition
by Charles Kelley 06 Dec '19

06 Dec '19

Hello Alvaro et al! In our latest exchange, on 5 Dec 2019 08:28, you wrote: You might concatenate the acquisition number and the Access Db id on 952$i > with a character separator like a pipe, asterisk, semicolon, etc. ie > 2019-01325|54342. > Yes, that's an excellent suggestion. My supervisor and I are arranging a meeting with the other principals to look at a number of issues and settle them before the catalog goes live. Once you get rid of the old Access DB system you can run a query to the > Koha DB biblio table and, using the separator, remove all reference to the > old AccessDB. How does one do that in Koha, through the Tool -> Batch Item Modification? I know how to run a query, but it's the changing of a group of records by removing a portion of one field or subfield that I don't understand. This is all new to me, and I'd be grateful for whatever help your can offer. -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 1-5-2 Tsukimino #210 Yamato-shi, Kanagawa-ken, 〒242-0002 JAPAN 1-301-741-7122 [US cell] 011-81-80-4714-5490 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

2 1

Source of Acquisition
by Charles Kelley 06 Dec '19

06 Dec '19

Hello, all! I have been asked to add a new indexed item field (subfield, that is). Here's the story. My library keeps track of its acquisitions in an old Access database. Each acquisition is given a unique ID number consisting of two parts: the year of acquisition and its sequence in the acquisition scheme for the year. <acquisition year>-<sequence number> For example the acquisition number of *A dictionary of Japanese and English idiomatic equivalents*, ISBN 0870111116, c. 1, is 1986-1003. The acquisition number of the same title, c. 2, ordered in the same batch as c. 1, is 1986-1003. This means, as you might already induce, that in 1986, c. 1 and c. 2 were the 1003rd books ordered. A third copy ordered later in the year would get the acquisition number 1986-1657. If a fourth copy is ordered in two years, it might get acquisition number 1988-0384; meaning it was the 384th work ordered in 1988. I am building a Koha catalog this library's from a spreadsheet and Access database, I have been asked to preserve this acquisition number. It is very important to the staff, and I am too new to challenge the staff about it. I am confident that in a few years, we'll have a better different system in operation; but for the present, I think I ought to keep it. Well, I can insert the number into the 952$e field. I could repurposed the 952$k field since that field is not in use. If I do the former (952$e), I can rely on the regular Koha indexing handle the number, the indexing, and so on. If I do the latter (952$k), I have to create and build a new index;* and I run the risk that Koha will dedicate 952$k to a function in the future. Have libraries in this discussion list done 952$e? Have libraries in this discussion list done $952$k? Is there an alternative solution? Abandoning the porting is not, at this stage, an option although I concede that in the future, we will likely end up dropping this version of the acquisition number. * I have read the sections on building an index on the Koha wiki. Thanks for your help, everyone. -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 1-5-2 Tsukimino #210 Yamato-shi, Kanagawa-ken, 〒242-0002 JAPAN 1-301-741-7122 [US cell] 011-81-80-4714-5490 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

3 2