[Koha] Barcode - Gaps
Dear Colleagues, I do not know if the question has been answered in the koha list. However I want to know if there is a SQL script to find the missing barcodes or accession numbers in the database. As I have done bulk import and I would like to find accession/barcode number gaps, so that I would fill the gaps. Thanks __ Yesan Sellan, B.Com., MLISc., PGDLAN Chief Librarian South Asia Institute of Advanced Christian Studies (SAIACS) 363 Dodda Gubbi Cross Road, Kothanur Post Office, Bangalore -560077, INDIA Phone: 91 80 2846 5235/5344/ 5649, Fax : 91 80 28465412, Mobile : 91-9972348251 Website : http://www.saiacs.org/ www.saiacs.org Alternative Email: mailto:yesan.sel...@saiacs.org yesan.sel...@saiacs.org or mailto:yes...@gmail.com yes...@gmail.com __ IMPORTANT : This message is intended only for the addressee. It may contain confidential information. Any unauthorized disclosure is strictly prohibited. If you have received this message in error, please notify us immediately so that we may correct our internal records. Please then delete the original message. Thank you. P Please consider the environment before printing this email. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Barcode - Gaps
Hi Yesan. I do not know if the question has been answered in the koha list. However I want to know if there is a SQL script to find the missing barcodes or accession numbers in the database. As I have done bulk import and I would like to find accession/barcode number gaps, so that I would fill the gaps. I'm not familiar with Koha's reports, but you could try or adapt some of the Catalog/Bibliographic Reports e.g. Null barcodes: http://wiki.koha-community.org/wiki/SQL_Reports_Library http://wiki.koha-community.org/wiki/SQL_Reports_Library#Catalog.2FBibliographic_Reports David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Data Migration
i have a big experience in data conversion but unfortunately i don't know MAELISA library systemso could you tell us is the data is MARC format i what format and send me a sample of data Mohamed El ZalabanyIntegrated library systems consultant Zalabany Knowledge Systems Team© For Libraries and Information systems Development and support mh_zalab...@hotmail.com Mobile: 202-0111291444 From: manny_tama...@sil.org To: koha@lists.katipo.co.nz Date: Tue, 23 Oct 2012 10:21:40 +0800 Subject: [Koha] Data Migration Good day to all, I'm Manny from Manila and in the process of data migration of the library from MAELISA to KOHA. Is there anyone who had done this process or has a script that may help? Salamat Manny Tamayao Librarian/Archivist SIL Philippines skype: mannytamayao mobile: 09152822329 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 3.6.10 released
The Koha release team are proud to announce the release of 3.6.10. This is a maintenance and security release, and contains a lot of useful bug fixes, as well as fixing several serious security vulnerabilities. Everyone running an earlier version of Koha 3.6 is strongly encouraged to update to 3.6.10. You can download the release from http://download.koha-community.orgpackages will be available shortly at http://debian.koha-community.org Please read on for the release notes. RELEASE NOTES FOR KOHA 3.6.10 23 Oct 2012 Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.6.10 can be downloaded from: http://download.koha-community.org/koha-3.06.10.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.6.10 is a bugfix/maintenance release. Highlights of 3.6.10 == 7589 blocker tinymce editor broken in .deb packages - in 'en' templates 8071 blocker link beween bib and authorities with the authid 3652 critical XSS vulnerabilities 8162 critical packaging scripts create user incorrectly 8447 critical can't save new records / indicator error 8497 critical Strange behavior when modifying the 'timeout' system preference. 8576 critical Software error on authority edition when using merge 8743 critical ZOOM error when merging authority change to biblios 6976 major User hold limit can be avoided by users in OPAC 7068 major autobarcode not working when duplicating patrons 8172 major Missing dereference marker for buildQuery parameter in addbooks.pl 8678 major XSLT stylesheets output XML, but HTML is needed Bugs fixed in 3.6.10 == 3782 normal delivered z39.50 targets wrong for NY Public Library and NY University Library 4064 normal Uninitialized variable errors in opac-search.pl 6037 normal Invalid markup, missing breadcrumbs on Keyword to MARC Mapping page 7628 normal Required format is not enforced for Patron Categories 8275 normal xml parsing error when the webservice GetPatronInfo/show_loans is called 8350 normal Searching for a 10 or 13 digit string (with a number in it) that does not exist in one's catalog will fail to affect SQL statement correctly in C4::Breeding 8455 normal Check ins processed through Check Out tab of the Patron Record ignore Circulation System Preferences 8594 normal A report containing a subquery that has a 'limit' will have that limit stripped out 8659 normal Inactive funds in neworderempty not disabled in IE/Opera 8702 normal System preferences search does not allow accented letters 8705 normal Software error on help of main page 8716 normal Reordering of routing list entries doesn't work 8744 normal Thesaurus in authorities should not lock fields 8796 normal patron cards not starting on designated card 8810 normal Opac: Cart should display branchname instead of branchcode 7690 minor hidelostitems not working in Normal Display 8339 minor div id=login should be id=login_controls in header.inc 8421 minor patron images fail when barcode for patron has a + 8533 minor Non-numeric cardnumbers screw up autoMemberNum 8646 minor Certain search terms cause browser script taking too long error 8677 minor table overlapping to the right on holds waiting 8721 minor typo in AllowItemsOnHoldCheckout 8730 minor browse overlaying powered by 6655 trivial Sorting order of serial issues in OPAC 7143 trivial Bug for tracking changes to the about page 8012 trivial defaultSortOrder and OPACdefaultSortOrder are set to ascending on install 8713 trivial Warning message triggered by clicking keyword to marc mapping. 8714 trivial Poorly ordered and triggers warning in marctagstructure.pl 8772 trivial Uninitialized variable triggers error log entry in smart_rules.pl 8806 enhancement Debian packaging updates System requirements == Important notes: * Perl 5.10 is required * Zebra is required Documentation == As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, only the English version of the Koha manual is available: http://manual.koha-community.org/3.6/en/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations == Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * Chinese (China) (95%) * Chinese (Taiwan) (99%) * Danish (99%) * English (New Zealand) (99%) *
Re: [Koha] Data Migration
Hello Mohamed what about data migration from mandarin M3 especially the holdings? On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany mh_zalab...@hotmail.comwrote: i have a big experience in data conversion but unfortunately i don't know MAELISA library systemso could you tell us is the data is MARC format i what format and send me a sample of data Mohamed El ZalabanyIntegrated library systems consultant Zalabany Knowledge Systems Team© For Libraries and Information systems Development and support mh_zalab...@hotmail.com Mobile: 202-0111291444 From: manny_tama...@sil.org To: koha@lists.katipo.co.nz Date: Tue, 23 Oct 2012 10:21:40 +0800 Subject: [Koha] Data Migration Good day to all, I'm Manny from Manila and in the process of data migration of the library from MAELISA to KOHA. Is there anyone who had done this process or has a script that may help? Salamat Manny Tamayao Librarian/Archivist SIL Philippines skype: mannytamayao mobile: 09152822329 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Dennis K. Njuguna ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Data Migration
Hello conversion from mandarin M3 will be easy if your version is supporting Marc 21 for holding you need to know what is the local field that the system uses to put the items information and edit the record by MARC edit to change the tag of the item field to (952) koha local field for item information Mohamed El ZalabanyIntegrated library systems consultant Zalabany Knowledge Systems Team© For Libraries and Information systems Development and support mh_zalab...@hotmail.com Mobile: 0111291444 Date: Tue, 23 Oct 2012 17:08:09 +0300 Subject: Re: [Koha] Data Migration From: cknjug...@gmail.com To: mh_zalab...@hotmail.com CC: manny_tama...@sil.org; koha@lists.katipo.co.nz Hello Mohamed what about data migration from mandarin M3 especially the holdings? On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany mh_zalab...@hotmail.com wrote: i have a big experience in data conversion but unfortunately i don't know MAELISA library systemso could you tell us is the data is MARC format i what format and send me a sample of data Mohamed El ZalabanyIntegrated library systems consultant Zalabany Knowledge Systems Team© For Libraries and Information systems Development and support mh_zalab...@hotmail.com Mobile: 202-0111291444 From: manny_tama...@sil.org To: koha@lists.katipo.co.nz Date: Tue, 23 Oct 2012 10:21:40 +0800 Subject: [Koha] Data Migration Good day to all, I'm Manny from Manila and in the process of data migration of the library from MAELISA to KOHA. Is there anyone who had done this process or has a script that may help? Salamat Manny Tamayao Librarian/Archivist SIL Philippines skype: mannytamayao mobile: 09152822329 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Dennis K. Njuguna ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-devel] Koha 3.6.x EOL
A hearty congratulations on a job well-done Jared! Kind Regards, Chris On Tue, Oct 23, 2012 at 11:11 AM, Jared Camins-Esakov jcam...@cpbibliography.com wrote: Good morning. Earlier today I released Koha 3.6.10, my final release as Release Maintainer for the Koha 3.6.x branch. So far no one has accepted the position of RMaint for 3.6.x during the 3.12 release cycle, despite my various pleas, entreaties, and threats. It is my hope that a new release maintainer will step forward for 3.6.x, since I believe that this branch has not yet exhausted its usefulness, but until this happens the 3.6.x branch should be considered orphaned, and libraries should begin to consider upgrading to 3.8.x or the forthcoming 3.10. One further note about 3.6.10: this upgrade included fixes for several cross-site scripting (XSS) vulnerabilities in Koha that have been present at least since 3.4. ALL USERS OF KOHA SHOULD UPGRADE TO THE LATEST RELEASE ON THE BRANCH THEY ARE FOLLOWING TO RECEIVE PROTECTION FROM THESE THREATS. Regards, Jared -- Jared Camins-Esakov Bibliographer, C P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha-devel mailing list koha-de...@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha 3.6.x EOL
Hi all, Congratulations Jared on a job well done. However I plan to ask Liz to take over rmaint of 3.6.x as part of the work at Catalyst. At least for a few months. So if Liz and the community are happy with that 3.6.x might have a bit of life left in it yet. Chris Jared Camins-Esakov jcam...@cpbibliography.com wrote: Good morning. Earlier today I released Koha 3.6.10, my final release as Release Maintainer for the Koha 3.6.x branch. So far no one has accepted the position of RMaint for 3.6.x during the 3.12 release cycle, despite my various pleas, entreaties, and threats. It is my hope that a new release maintainer will step forward for 3.6.x, since I believe that this branch has not yet exhausted its usefulness, but until this happens the 3.6.x branch should be considered orphaned, and libraries should begin to consider upgrading to 3.8.x or the forthcoming 3.10. One further note about 3.6.10: this upgrade included fixes for several cross-site scripting (XSS) vulnerabilities in Koha that have been present at least since 3.4. ALL USERS OF KOHA SHOULD UPGRADE TO THE LATEST RELEASE ON THE BRANCH THEY ARE FOLLOWING TO RECEIVE PROTECTION FROM THESE THREATS. Regards, Jared -- Jared Camins-Esakov Bibliographer, C P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Barcode - Gaps
Hi Yasan. I want to know list of accession numbers/barcode that are not in the database. ** ** Eg. I have barcodes 25, 26, 29, 30, 45, 49 .etc. I want to list those numbers that are not used in the database, so that I could find the books to be entered in the database. In my earlier library software I had an option generate list of unused accession numbers. By this I will know those accession numbers are not in the database. ** ** Can we generate a list like this in KOHA SQL Reports? My understanding is that you want a report that lists items where there is no barcode for the record. There is not a standard report in Koha to do this. However, it is possible by creating your own custom report. I'm not very familiar with creating Koha SQL reports. Tools to help you create a custom report: - Nicole has produced some videos on creating reports (some are for earlier versions, but they are still relevant): http://bywatersolutions.com/?cat=56s=report - The manual has a great section on writing custom reports: http://manual.koha-community.org/3.8/en/reports.html - The Koha database schema: http://schema.koha-community.org/index.html - The Koha SQL reports library: http://wiki.koha-community.org/wiki/SQL_Reports_Library I would suggest you try and create a report using some of the above material. If you can't get a report to work properly - post it back to the list along with the error message or problem, and the version of Koha you are using. Someone more familiar with SQL reports maybe able to help you identify the problem/point you in the right direction. If you are really lucky someone may have already created such a report and can share it with you. David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha