Re: [Koha] Hi from a total Koha beginner
Hi Robin, Thank you for your answer. In fact, i am just going to extract as much data as possible from the legacy database (which is SQL Server) as a CSV file, then I will try convert it as a MARC file. In Italy, National Libraries use UNIMARC, so I configured my Koha instance that way. My major difficulty at the moment is to understand how some informations that are stored into the old program's database can be transferred to Koha For example: the old program associates each book with one or more topics (like steam engines; steam locomotive boiler parts; signalling; traffic control, and so on); where are to be stored these topics in koha? I can't find any place, at the moment. But right now I am wondering if these informations _should_ ever be transferred, because - if I understand right - these topics relates to classify a book, whereas registering it in the catalog is just that: cataloguing it. And , if I am right, Koha catalogues pre-classified books, and doesn't allow to classify a a book from scratch. Is that right? If not, how to do that? Another question is, in the old database books and authors are linked by a many-to-many relation; so, when extracting records, this gives multiple rows in the CSV, each with a different author; the same with publishers. How can I handle this? Thanks in advance, Gianfranco Da: Koha koha-boun...@lists.katipo.co.nz A: koha@lists.katipo.co.nz Cc: Data: Tue, 16 Jun 2015 10:50:45 +1200 Oggetto: Re: [Koha] Hi from a total Koha beginner Gianfranco Nicola schreef op ma 15-06-2015 om 20:44 [+0200]: But now I am trying to figure out how to import data from our legacy software, and how to teach our library guy to use this new program, The first step is to get what data you can out of the old system. Only once you can see what you can migrate into Koha, is it possible to really start doing it. If you're really lucky you'll be able to export as MARC (UNIMARC or MARC21 typically. I'm not sure what Italy generally uses.) More likely you'll get something that looks somewhat like a CSV and you'll have to turn that into MARC. bearing in mind that neither him, nor me, are librarians. You'll know a whole lot more by the end of the process :) -- 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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Hi from a total Koha beginner
Hi Gianfranco, please find my answers in-line. On Tue, Jun 16, 2015 at 5:57 PM, Gianfranco Nicola/MFP gianfranco.nic...@museoferroviariopiemontese.com wrote: Hi Robin, Thank you for your answer. In fact, i am just going to extract as much data as possible from the legacy database (which is SQL Server) as a CSV file, then I will try convert it as a MARC file. In Italy, National Libraries use UNIMARC, so I configured my Koha instance that way. I'll try to answer some of your queries. First off, I've never worked with UNIMARC, rather with MARC21. So I'm going to refer to MARC21. Having said that, UNIMARC is a flavour of MARC so, there are enough similarities in the concepts. For example: the old program associates each book with one or more topics (like steam engines; steam locomotive boiler parts; signalling; traffic control, and so on); where are to be stored these topics in koha? In MARC21, these would go into subject headings i.e. under tag no 650 - http://www.loc.gov/marc/bibliographic/bd650.html But right now I am wondering if these informations _should_ ever be transferred, because - if I understand right - these topics relates to classify a book, whereas registering it in the catalog is just that: cataloguing it. And , if I am right, Koha catalogues pre-classified books, and doesn't allow to classify a a book from scratch. Is that right? If not, how to do that? No, Koha does allows a book to be cataloged from scratch. You would need to define the authority files ahead or else go on defining them as you go along. Either is possible. Another question is, in the old database books and authors are linked by a many-to-many relation; so, when extracting records, this gives multiple rows in the CSV, each with a different author; the same with publishers. How can I handle this? The way I would do it would be stage these into mysql tables. Write a perl script that accesses these tables, and extracts the JOINed data and finally save it a a MARC record using some of the same MARC modules that Koha uses. Then run a final check on the created MARC files using an utility like MarcEdit. And finally when satisfied with the same, do a bulk import into Koha. hope that helps -indranil -- Indranil Das Gupta L2C2 Technologies INDIA Phone : +91-98300-20971 / +91-9874580971 / +91-33-2443-0187 Blog: http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] New install was Koha Digest, Vol 116, Issue 16
Check your current system and see what formats it will export. The best is MARC or UNIMARC, if not CSV will work, but you'll have to convert it to some form of MARC before you import it. On Tue, Jun 16, 2015 at 6:18 AM, Sanjay Nayak Library sanjay.na...@cadilapharma.co.in wrote: Dear All, I am a librarian at private pharma company, Currently we are using librarian software (Paid), I would like to migrate from Librarian to Koha Can it possible to export all data in Koha successfully ? I am a new for Koha, can some guide from beginning ? How to install Koha in Windows 7 ? What preparation / pre-requirements are necessary? And Import Export guidelie. Thanks Regards, Sanjay Nayak | Library | RD-II | Cadila Pharmaceuticals Ltd. 1389, Trasad Road | Dholka | Dist. Ahmedabad | Gujarat | India | Pin-387810 | Mo. +91-9726374616 Tel. (O) +91-2714-221481 Ext. 213 Email: sanjay.na...@cadilapharma.co.in (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Fundraising Committee Draft Terms of Reference
2015-06-15 13:06 GMT-03:00 Brendan Gallagher i...@bywatersolutions.com: Hi all - Just to be clear again - this is what I had highlighted previously -- 4. Jonathan Druart has resigned from Biblibre effective May 1st and is currently unemployed. I propose the we use some of the money of the Fund to hire him as a contractor to a) sign-off on bugs b) QA bugs c) clean up bugzilla (for example we have a large number of bugs that are major or critical for some that have no patches even written for them, plus there is also a bunch of other clean up that will help every other developer in the community - that honestly none of us really have time to do). Since he has no allegiance to a support provider - he is exactly the third party person we are looking for. I think it would be a good idea to hire Jonathan as an independent consultant for Koha Fund, while the committee continues to work on the legal bylaws. Because the delays to have this properly discussed and agreed have put Jonathan in a difficult situation right now (unemployment). And it should be explicitly stated that once the legal bylaws are figured, the decision to hire him (and the terms of the contract) would be revisited by the comitee. Please join forces to have this sorted ASAP. All this legal stuff is scary to read and fully understand, but at least add your +1 to support people working on this. -- Tomás Cohen Arazi Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Fundraising Committee Draft Terms of Reference
I don't know how to say this without stepping on anyone's toes, but I think this discussion is taking a problematic direction. I don't think it is good to tie the general discussion and decision on all things fundraising to the personal situation of people that may be funded once all is settled. I refuse to agree I »have put somebody in a difficult situation« because I opposed voting on things that were made public on very short notice before meetings. I was not informed I was discussing anyone's situation. A situation I knew nothing about. It seems like behind the scenes it has already been agreed to 1) put money into the fund 2) pay somebody with that money so I have a simple proposal for the parties involved. Please consider contracting people directly until the fundraising stuff is actually up and running and everybody is happy. Hope that does not anger anyone, Mirko PS. Yes, I would like to see Jonathan continue his fine work on Koha. Just to make that clear. -- Mirko Tietgen mi...@abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de signature.asc Description: OpenPGP digital signature ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha installation on Debian 6.5
Hi, as you ave already been told, you have to upgrade the operating system, first. Then you'll be able to install the latest version of Koha. Here there is an excellent guide to install Koha on Ubuntu server (Ubuntu is Debian-based) - I followed just a couple of weeks ago, without any trouble. http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages greetings, Gianfranco -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-installation-on-Debian-6-5-tp5844116p5844269.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Fundraising Committee Draft Terms of Reference
I have had some thoughts: 1. Structure: I see no reason why a person should be limited to 3 years of service. I am happy for people to offer themselves up for election as many times as they like; the community will decide if they are still adding value to the committee; 2. Meetings: In addition to monthly formal meetings, my expectation is that the committee will make heavy use of email for discussion and debate in order to accommodate a globally disbursed committee straddling many timezones. This includes the ability to pass motions via email PROVIDED THAT such decisions and resolutions are recorded in the minutes of the monthly meetings; 3. Quorum: how about at least 50% of the membership. The reason being that 3 is only 30% of a 9 member committee. If the committee is 7 then you require 4 for a quorum. I am loath to support a 'miniority' rules situation. I have not considered what might be missing so I may well come back for second bite at this! Cheers Jo -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Brendan Gallagher Sent: Wednesday, 17 June 2015 9:33 a.m. To: Mirko Tietgen Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha Fundraising Committee Draft Terms of Reference Great anyone have more thoughts? BTW nothing has been done behind the scenes... All discussions have been posted to the mailing lists and talked about and presented at conferences / hackfests. Nothing has or will be hidden. I just want to make sure that we're clear on that :) Has anyone reviewed the document at all? And there was no push to get the bylaws voted on at the last meeting because we fell short of a long enough review period (but since we had finished the doc we wanted to make sure it was available for some discussion at the general meeting)... Not to vote on. Mirko we need more volunteers - are you willing to help here? You have good opinions. Thanks, Brendan On Tue, Jun 16, 2015 at 10:42 AM, Mirko Tietgen mi...@abunchofthings.net wrote: I don't know how to say this without stepping on anyone's toes, but I think this discussion is taking a problematic direction. I don't think it is good to tie the general discussion and decision on all things fundraising to the personal situation of people that may be funded once all is settled. I refuse to agree I »have put somebody in a difficult situation« because I opposed voting on things that were made public on very short notice before meetings. I was not informed I was discussing anyone's situation. A situation I knew nothing about. It seems like behind the scenes it has already been agreed to 1) put money into the fund 2) pay somebody with that money so I have a simple proposal for the parties involved. Please consider contracting people directly until the fundraising stuff is actually up and running and everybody is happy. Hope that does not anger anyone, Mirko PS. Yes, I would like to see Jonathan continue his fine work on Koha. Just to make that clear. -- Mirko Tietgen mi...@abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha -- --- Brendan A. Gallagher ByWater Solutions CEO Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Headquarters: Santa Barbara, CA - Office: Redding, CT Phone # (888) 900-8944 http://bywatersolutions.com i...@bywatersolutions.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha # This e-mail message and any attached files may contain confidential information, and may be subject to legal professional privilege. If you are not the intended recipient, please delete. Unless formally stated, this e-mail and any attachments do not necessarily reflect the views of the the The Horowhenua Trust. The Horowhenua Trust takes extensive precautions with the aim of detecting and removing any virus or defects from its e-mail system but accepts no liability for loss or damage should this e-mail not be virus or defect free or should there be any errors in transmission. # ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Fundraising Committee Draft Terms of Reference
Great anyone have more thoughts? BTW nothing has been done behind the scenes... All discussions have been posted to the mailing lists and talked about and presented at conferences / hackfests. Nothing has or will be hidden. I just want to make sure that we're clear on that :) Has anyone reviewed the document at all? And there was no push to get the bylaws voted on at the last meeting because we fell short of a long enough review period (but since we had finished the doc we wanted to make sure it was available for some discussion at the general meeting)... Not to vote on. Mirko we need more volunteers - are you willing to help here? You have good opinions. Thanks, Brendan On Tue, Jun 16, 2015 at 10:42 AM, Mirko Tietgen mi...@abunchofthings.net wrote: I don't know how to say this without stepping on anyone's toes, but I think this discussion is taking a problematic direction. I don't think it is good to tie the general discussion and decision on all things fundraising to the personal situation of people that may be funded once all is settled. I refuse to agree I »have put somebody in a difficult situation« because I opposed voting on things that were made public on very short notice before meetings. I was not informed I was discussing anyone's situation. A situation I knew nothing about. It seems like behind the scenes it has already been agreed to 1) put money into the fund 2) pay somebody with that money so I have a simple proposal for the parties involved. Please consider contracting people directly until the fundraising stuff is actually up and running and everybody is happy. Hope that does not anger anyone, Mirko PS. Yes, I would like to see Jonathan continue his fine work on Koha. Just to make that clear. -- Mirko Tietgen mi...@abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha -- --- Brendan A. Gallagher ByWater Solutions CEO Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Headquarters: Santa Barbara, CA - Office: Redding, CT Phone # (888) 900-8944 http://bywatersolutions.com i...@bywatersolutions.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Fundraising Committee Draft Terms of Reference
Good summary Jo :) On Tue, Jun 16, 2015 at 2:32 PM, Joann Ransom joa...@tetakere.org.nz wrote: Hi all, Can I just clarify my understanding of the situation: * The Koha community have decided to establish a Koha Fund for developing Koha, * Te Horowhenua Trust have agreed to be the 'banker' and umbrella for a Fundraising and a Grants subcommittee, * The Koha Community is developing operating guidelines for the two committees, * Johnathan is willing and available to work on Koha under contract to THT and paid from the Koha fund, * A number of potential donors to the fund are supportive of this plan, * Johnathan has made a decision to resign from BibLibre. My take on this is that the Koha community is not responsible for Jonathan's decision to resign from Biblibre and be in the difficult situation he now finds himself. Our responsibility is to collectively establish the 2 Koha fund committees. Have I over-simplified that or is that about right? Regards Jo. -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Mirko Tietgen Sent: Wednesday, 17 June 2015 5:43 a.m. To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha Fundraising Committee Draft Terms of Reference I don't know how to say this without stepping on anyone's toes, but I think this discussion is taking a problematic direction. I don't think it is good to tie the general discussion and decision on all things fundraising to the personal situation of people that may be funded once all is settled. I refuse to agree I »have put somebody in a difficult situation« because I opposed voting on things that were made public on very short notice before meetings. I was not informed I was discussing anyone's situation. A situation I knew nothing about. It seems like behind the scenes it has already been agreed to 1) put money into the fund 2) pay somebody with that money so I have a simple proposal for the parties involved. Please consider contracting people directly until the fundraising stuff is actually up and running and everybody is happy. Hope that does not anger anyone, Mirko PS. Yes, I would like to see Jonathan continue his fine work on Koha. Just to make that clear. -- Mirko Tietgen mi...@abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de # This e-mail message and any attached files may contain confidential information, and may be subject to legal professional privilege. If you are not the intended recipient, please delete. Unless formally stated, this e-mail and any attachments do not necessarily reflect the views of the the The Horowhenua Trust. The Horowhenua Trust takes extensive precautions with the aim of detecting and removing any virus or defects from its e-mail system but accepts no liability for loss or damage should this e-mail not be virus or defect free or should there be any errors in transmission. # ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha -- --- Brendan A. Gallagher ByWater Solutions CEO Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Headquarters: Santa Barbara, CA - Office: Redding, CT Phone # (888) 900-8944 http://bywatersolutions.com i...@bywatersolutions.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Fundraising Committee Draft Terms of Reference
Hi all, Can I just clarify my understanding of the situation: * The Koha community have decided to establish a Koha Fund for developing Koha, * Te Horowhenua Trust have agreed to be the 'banker' and umbrella for a Fundraising and a Grants subcommittee, * The Koha Community is developing operating guidelines for the two committees, * Johnathan is willing and available to work on Koha under contract to THT and paid from the Koha fund, * A number of potential donors to the fund are supportive of this plan, * Johnathan has made a decision to resign from BibLibre. My take on this is that the Koha community is not responsible for Jonathan's decision to resign from Biblibre and be in the difficult situation he now finds himself. Our responsibility is to collectively establish the 2 Koha fund committees. Have I over-simplified that or is that about right? Regards Jo. -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Mirko Tietgen Sent: Wednesday, 17 June 2015 5:43 a.m. To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha Fundraising Committee Draft Terms of Reference I don't know how to say this without stepping on anyone's toes, but I think this discussion is taking a problematic direction. I don't think it is good to tie the general discussion and decision on all things fundraising to the personal situation of people that may be funded once all is settled. I refuse to agree I »have put somebody in a difficult situation« because I opposed voting on things that were made public on very short notice before meetings. I was not informed I was discussing anyone's situation. A situation I knew nothing about. It seems like behind the scenes it has already been agreed to 1) put money into the fund 2) pay somebody with that money so I have a simple proposal for the parties involved. Please consider contracting people directly until the fundraising stuff is actually up and running and everybody is happy. Hope that does not anger anyone, Mirko PS. Yes, I would like to see Jonathan continue his fine work on Koha. Just to make that clear. -- Mirko Tietgen mi...@abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de # This e-mail message and any attached files may contain confidential information, and may be subject to legal professional privilege. If you are not the intended recipient, please delete. Unless formally stated, this e-mail and any attachments do not necessarily reflect the views of the the The Horowhenua Trust. The Horowhenua Trust takes extensive precautions with the aim of detecting and removing any virus or defects from its e-mail system but accepts no liability for loss or damage should this e-mail not be virus or defect free or should there be any errors in transmission. # ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha installation on Debian 6.5
I want to install koha latest version on debian 6.5. Please tell me which web links will be at sources.list file. Give a manual to install koha on debian 6.5 without hassle and easily. i am looking for your advise and will be grate full all of you. -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-installation-on-Debian-6-5-tp5844116.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Reg: Koha SIP connection
Hello Chris, Thank you. Please let me know if its enough to just change the below part. Will this work even if telnet is blocked? service port=8023/tcp * transport=RAW* protocol=SIP/2.00 timeout=60 / Thanks Regards, Arun Anand On 15 June 2015 at 03:30, Chris Cormack ch...@bigballofwax.co.nz wrote: On 10 June 2015 at 23:25, arun a aarun141...@gmail.com wrote: Hello Team, Could anyone please let me know if there is a provision in koha to use any other TCP port for initial handshake of SIP rather than telnet? Hi Yep, you can configure raw, or telnet based and what port all in the config Maybe read here http://wiki.koha-community.org/wiki/Koha_SIP2_server_setup and here http://wiki.koha-community.org/wiki/Koha_SIP2_Server_Capabilities For more details Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha installation on Debian 6.5
Greetings, The latest version of Koha (3.20.x) does not install on Debian 6. Consider that Debian 8 is already out. If you are creating a new server for Koha, using the latest stable version of Debian is always recommended. If you are attempting to reuse an existing server, the question is: why haven't you upgraded it already? GPML, Mark Tompsett ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Digest, Vol 116, Issue 16
Hi, Sanjay Nayak Library schrieb am 16.06.2015 How to install Koha in Windows 7 ? There is no version for Windows. You will have to install on a GNU/Linux server. HTH, Mirko -- Mirko Tietgen mi...@abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de signature.asc Description: OpenPGP digital signature ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] How to access OPAC from my website
Hello!I have configured Koha on a local machine and I would like to know what to do so that my koha OPAC can be linked to my website.Thanks Irène M Tel. (250)788623682 Head of Programming INILAK ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to access OPAC from my website
Hi, Irène Mushimiyimana schrieb am 16.06.2015 Hello!I have configured Koha on a local machine if you want Koha to be accessible from the web, you need to install it on a server with a public IP address,[1] or forward traffic on the ports you want to run Koha on from your internet gateway to the local machine. [1] https://en.wikipedia.org/wiki/IP_address#Public_addresses HTH, Mirko -- Mirko Tietgen mi...@abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de signature.asc Description: OpenPGP digital signature ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha