- Koha - lists.katipo.co.nz

Possible bug v 4.02 - serials_stat.pl
by Mahesh T Pai 15 Jun '11

15 Jun '11

Dear all, I have a fresh install of koha, installed from the stable tarball (v. 4.02.06) on a Debian stable + testing. I restored data from an earlier version (v. 3.???) of koha (the library is not fully "in production" yet). Most things are apparently as they ought to be, so far. But, I get this error from Staff interface > Reports > Statistics Wizards > Serials:- <quote from the browser> Koha error The following fatal error has occurred: Global symbol "$branches" requires explicit package name at /usr/share/koha/intranet/cgi-bin/reports/serials_stats.pl line 148. Global symbol "$branches" requires explicit package name at /usr/share/koha/intranet/cgi-bin/reports/serials_stats.pl line 148. Global symbol "$branches" requires explicit package name at /usr/share/koha/intranet/cgi-bin/reports/serials_stats.pl line 148. Execution of /usr/share/koha/intranet/cgi-bin/reports/serials_stats.pl aborted due to compilation errors. </quote> <from Koha-error_log> [Wed Jun 15 20:12:28 2011] [error] [client 127.0.0.1] [Wed Jun 15 20:12:28 2011] serials_stats.pl: Global symbol "$branches" requires explicit package name at /usr/share/koha/intranet/cgi-bin/reports/serials_stats.pl line 148., referer: http://library:8080/cgi-bin/koha/reports/reports-home.pl [Wed Jun 15 20:12:28 2011] [error] [client 127.0.0.1] [Wed Jun 15 20:12:28 2011] serials_stats.pl: Global symbol "$branches" requires explicit package name at /usr/share/koha/intranet/cgi-bin/reports/serials_stats.pl line 148., referer: http://library:8080/cgi-bin/koha/reports/reports-home.pl [Wed Jun 15 20:12:28 2011] [error] [client 127.0.0.1] [Wed Jun 15 20:12:28 2011] serials_stats.pl: Global symbol "$branches" requires explicit package name at /usr/share/koha/intranet/cgi-bin/reports/serials_stats.pl line 148., referer: http://library:8080/cgi-bin/koha/reports/reports-home.pl [Wed Jun 15 20:12:28 2011] [error] [client 127.0.0.1] [Wed Jun 15 20:12:28 2011] serials_stats.pl: Execution of /usr/share/koha/intranet/cgi-bin/reports/serials_stats.pl aborted due to compilation errors., referer: http://library:8080/cgi-bin/koha/reports/reports-home.pl [Wed Jun 15 20:25:39 2011] [error] [client 127.0.0.1] [Wed Jun 15 20:25:39 2011] serials_stats.pl: Global symbol "$branches" requires explicit package name at /usr/share/koha/intranet/cgi-bin/reports/serials_stats.pl line 148., referer: http://library:8080/cgi-bin/koha/reports/reports-home.pl [Wed Jun 15 20:25:39 2011] [error] [client 127.0.0.1] [Wed Jun 15 20:25:39 2011] serials_stats.pl: Global symbol "$branches" requires explicit package name at /usr/share/koha/intranet/cgi-bin/reports/serials_stats.pl line 148., referer: http://library:8080/cgi-bin/koha/reports/reports-home.pl [Wed Jun 15 20:25:39 2011] [error] [client 127.0.0.1] [Wed Jun 15 20:25:39 2011] serials_stats.pl: Global symbol "$branches" requires explicit package name at /usr/share/koha/intranet/cgi-bin/reports/serials_stats.pl line 148., referer: http://library:8080/cgi-bin/koha/reports/reports-home.pl [Wed Jun 15 20:25:39 2011] [error] [client 127.0.0.1] [Wed Jun 15 20:25:39 2011] serials_stats.pl: Execution of /usr/share/koha/intranet/cgi-bin/reports/serials_stats.pl aborted due to compilation errors., referer: http://library:8080/cgi-bin/koha/reports/reports-home.pl </quote> I refreshed the page, so the same entries have appeared twice. Perl info:- <begin> perl --version This is perl 5, version 12, subversion 3 (v5.12.3) built for x86_64-linux-gnu-thread-multi (with 37 registered patches, see perl -V for more detail) <end perl info> (perl -V is too verbose - I suspect it is not relevant. Libcgi-session-perl is version 4.43-1. I look at the man page, which shows this:- <quote from the man page> reports::serials_stats(.U3.sp.em.r)Contributed Perl Document.ra.et.pi.oo.rn.ts::serials_stats(3pm) serials_out plugin that shows a stats on serials DESCRIPTION POD ERRORS Hey! The above document had some coding errors, which are explained below: Around line 38: =over is the last thing in the document?! perl v5.12.3 2011-05-18 reports::serials_stats(3pm) </quote> I notice that all reports:*_stats.3pm files in man/man3 directory have this problem: "Around line XX =over is the last thing in the document" Is something misconfigured? Thanks in advance.

3 3

Re: [Koha] [greenstone-users] Koha integration
by Anuradha.K.T. 15 Jun '11

15 Jun '11

Dear Renate, As you have mentioned, if you understand the theory behind integrating Koha-Greenstone, you can implement it on your existing system. It was first implemented by me using SRU technique for searching. At the time of indexing (cataloguing) either you can write a script which takes the metadata details from koha and indexes in Greenstone along with fulltext document or use OAI-PMH concept for indexing in both Koha and Greenstone. The implementation can be accessed at: http://dharmaganja.ncsi.iisc.ernet.in/ Two workshops were conducted giving complete details of the integration of Koha-Greenstone and Koha-Fedora in 2009. Workshop details can also be accessed at the above mentioned URL. I have also tried using MySQL database of Koha for indexing and searching full text documents. This is also available at the above site. The details are discussed in the following articles: Anuradha, K.T. and Sivakaminathan, R. (2009), Enhancing full text search capability in library automation package: a case study with Koha and Greenstone Digital Library Software, paper presented at the International Conference on Computer Science and Information Technology, Singapore, 28-29 October, available at: http://dharmaganja.ncsi.iisc.ernet.in/documents/koha-gsdl.pdf K.T. Anuradha, R. Sivakaminathan, P. Arun Kumar (2011) Open-source tools for enhancing full-text searching of OPACs: Use of Koha, Greenstone and Fedora. Program: electronic library and information systems Volume: 45 Issue: 2 2011 You can go through Greenstone wiki page also at: http://wiki.greenstone.org/wiki/index.php/Koha_Greenstone_Integration All the best in your integration effort. Regards, Anuradha > Thanks for your mail. I had a look at version 8, but I would like to use Greenstone 2.84. > I am hesitant to install it on my existing Ubuntu Maverick installation as a second install, as I read that it might change/corrupt my system. The best would be to understand how to setup the integration in Koha and Greenstone. I tried to get it working, but I get an error in the building process in Greenstone with the version of Perl. I used the OAIMetadata plugin. I am seeing forward to your new GSDL/Koha CD. Do you know whether there is a recent version of Koha for Windows. The site where I would like to use it has a Windows 7 installation. > Until later. > Regards > Renate >> Dear Renate, >> Digital Library Network South Asia in collaboration with University of Waikato has developed Live CD of Integration of Koha ILS with GSDL. This >> is available in the Source Forge: >> http://sourceforge.net/projects/gsdlkohalive/ >> You can use the software. Once the software is installed you need to give >> only biblio ID of Koha ILS in GSDL. On Monday, we are updating the another >> release. Kindly let me know if you need further assistance >> Mohan Raj Pradhan >> General Secretary >> DlnetSA >> Message: 1 >> Date: Thu, 09 Jun 2011 11:03:36 +0100 >> From: Renate Morgenstern <rmorgenstern(a)iway.na> >> Subject: [greenstone-users] Error: Building collection with OIA Plugin To: Greenstone Team <greenstone_team(a)cs.waikato.ac.nz> >> Cc: greenstone-users(a)list.scms.waikato.ac.nz >> Message-ID: <1307613816.5776.7.camel@user-laptop> >> Content-Type: text/plain; charset="UTF-8" >> Good day, >> I have created a collection which should integrate with KOHA for full text retrieval using the OAI and Metadata plugin. I checked the KOHA server and the records can be viewed. However, when I want to build it on Ubuntu Maverick, it can't be build due to an error in perl libraries. >> Using Greenstone 2.84 for Linux. I am running Greenstone as root. Are there permissions which should be changed? >> Here is the error message: >> Thanks for any help. >> Regards >> Renate >> ================================================= >> Command: perl -S /var/www/greenstone/bin/script/full-import.pl -gli -language en -collectdir /var/www/greenstone/collect wimsa >> import.pl> Removing current contents of the archives directory... import.pl> Global file scan checking >> directory: /var/www/greenstone/collect/wimsa/import >> import.pl> MetadataXMLPlugin: processing metadata.xml >> import.pl> OAIMetadataXMLPlugin: Checking OAI server >> (http://127.0.1.1:8080/cgi bin/koha/oai.pl) connection >> import.pl> perl: symbol lookup >> error: /var/www/greenstone/perllib/cpan/auto/HTML/Parser/Parser.so: undefined symbol: Perl_Tstack_sp_ptr >> import.pl> Error: Failed to run: perl -S import.pl -removeold "-gli" "-language" "en" "-collectdir" "/var/www/greenstone/collect" "wimsa" import.pl> Command failed. >> _______________________________________________ >> greenstone-users mailing list >> greenstone-users(a)list.scms.waikato.ac.nz >> https://list.scms.waikato.ac.nz/mailman/listinfo/greenstone-users > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > _______________________________________________ > greenstone-users mailing list > greenstone-users(a)list.scms.waikato.ac.nz > https://list.scms.waikato.ac.nz/mailman/listinfo/greenstone-users -- Dr.Anuradha.K.T. National Centre for Science Information Indian Institute of Science Karnataka, Bangalore 560 012 URL: http://vidya-mapak.ncsi.iisc.ernet.in http://dharmaganja.ncsi.iisc.ernet.in FAX:(+91-80) 23601426/23600683 Tel:(+91-80) 22933274/22932511 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

1 0

Customized Interface of OPAC and Staff Client
by R Sunil Kumar 15 Jun '11

15 Jun '11

Dear All, We are planning to develop a customized interface for the Koha for both OPAC interface / Staff Client Interface. I request all those libraries who have done any customisation to the OPAC/Staff interface of Koha to send us the URL link / Screen shot of the same. Or suggest us what kind of interface customisation as librarian you will like to see on the KOHA OPAC / Staff Client Interface. Thanks and Regards R Sunil Kumar Library Technologist cid:image001.jpg@01CC250B.5782A730 Ecole Solutions Pvt Ltd Level 15 Concorde Towers UB City 1 Vittal Mallya Road Bangalore 560001,India Mobile: +91 9686576695 Fax: +91 80 40300400 eMail: sunil.kumar(a)ecoleglobal.com Web: www.ecoleglobal.com

1 0

Re: [Koha] Uploading the database from excel to KOHA : Copies notavailable / Missing
by Adalid Ortiz 14 Jun '11

14 Jun '11

In my experience, Koha needs the subfield "o" - Full call number. I migrate from CDS/ISIS DOS and the LC callnumber (050ab) was import in both fields, one for MARC21 and one for KOHA. When I add a record the LC callnumber was copied automaticaly to subfield "o" subfield in the Add ITEM secction. Try a search in my OPAC and export to MARC to study the format. Salduos, FAOA Biblioteca Loyola System librarian KOHA OPAC http://clavius.tij.uia.mx

1 0

Fwd: Super-tiny script to check for record errors before upgrading to 3.4.x
by Tomas Cohen Arazi 14 Jun '11

14 Jun '11

I just forward this as I noticed I sent it to dev list only. It was usefull for us. Regards To+ ---------- Forwarded message ---------- From: Tomas Cohen Arazi <tomascohen(a)gmail.com> Date: Tue, May 31, 2011 at 4:00 PM Subject: Super-tiny script to check for record errors before upgrading to 3.4.x To: koha-devel <koha-devel(a)lists.koha-community.org> Hi, being back to work after a few weeks abroad is a bit difficult, but here I am. Back to koha, and back to Perl suff. We are just planning our upgrade to 3.4 and face the problem that our install base (+30 libraries/koha deploys and growing) has several enconding (and posibly other) problems carried from the initial migration from different sources and encodings. Those problems obviously arise now that we have to access all the records to remove holdings information from them, and running remove_items_from_biblioitems.pl waiting for it to fail and discover "where" it failed is not suitable for us. So... I managed to get a script to tell me which records are "problematic" in the sense koha defines problematic. I'd like some other dev to take a look at it to check it. It can be obviously beautified and improved. There's a link here so anyone can read it: http://blogs.unc.edu.ar/koha/lang/en/2011/05/31/migracion-a-3-4-surgen-prob… Thanks in advance To+

1 0

Reminder: Global sign off day 2011-06-15 (in your time zone of choice)
by Magnus Enger 14 Jun '11

14 Jun '11

Dear Koha friends! Just a gentle reminder that Global sign off day is just 2,5 hours away in Kiribati, and fast approaching for other time zones too... Se the message below for details. Best regards, Magnus Enger ---------- Forwarded message ---------- From: Magnus Enger <magnus(a)enger.priv.no> Date: 7 June 2011 16:16 Subject: Global sign off day, 2011-06-15 To: Koha list <koha(a)lists.katipo.co.nz>, koha-devel(a)lists.koha-community.org Dear all! (And sorry for cross posting... At least a little bit ;-) We had such great fun in Marseilles earlier this year, signing off patches, that I have been wondering if it would be possible to re-create some of that experience without incurring the costs of travel. I broached the subject on IRC earlier today and after the briefest and least democratic of processes, "we" decided to declare 15th June 2011 as a Global Sign Off Day: http://wiki.koha-community.org/wiki/Global_sign_off_day,_2011-06-15 The hope is that as many people as possible will be able to set aside as much other work as possible on this day, and concentrate on signing off patches, to reduce the queue of bugs that are currently waiting for sign-off (66 at this moment: http://bugs.koha-community.org/bugzilla3/buglist.cgi?bug_status=NEW&bug_sta…) We will try to visualise and document the progress that is made, to make it more fun and maybe even tickle the competitive instincts a little bit... ;-) And who knows, if this day is a success, maybe we could turn it into a regular tradition? * If you have not signed off on a patch before, now is the perfect time to do it! The more the merrier! The process is outlined here: http://wiki.koha-community.org/wiki/Sign_off_on_patches And there will be people on IRC that you can ask for help and guidance! Best regards, Magnus Enger * On the other hand, let's hope we can keep the queue as short as possible...

1 0

Re: [Koha] Koha Digest, Vol 68, Issue 58
by R Sunil Kumar 14 Jun '11

14 Jun '11

Dear Rehman, I do understand that Accession / Barcode Number are unique numbers but as during the circulation which will be used for the circulation. Because Accession Number starts with numeric number but barcode number starts with "BK000....". Thanks and Regards R Sunil Kumar Library Technologist +91-9686576695 -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: 14 June 2011 11:45 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 68, Issue 58 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: Uploading the database from excel to KOHA : Copies not available / Missing (Ata ur Rehman) ---------------------------------------------------------------------- Message: 1 Date: Tue, 14 Jun 2011 11:14:50 +0500 From: Ata ur Rehman <ata.rehman(a)gmail.com> Subject: Re: [Koha] Uploading the database from excel to KOHA : Copies not available / Missing To: sunil.kumar(a)ecoleglobal.com Cc: koha(a)lists.katipo.co.nz Message-ID: <BANLkTi=oBmG6_isHBLvep2w72+8frrbsSA(a)mail.gmail.com> Content-Type: text/plain; charset="utf-8" Dear Sunil / All Accession number is a unique number assigned to every book in library and in most of cases accession number is used for circulation, holds, etc. But if this is not the case in your situation, you may put other values in barcode 952$p. But no of copies in each biblio record depends upon no of barcodes (952$p) associated with it. 952$p is repeatable tag. Regards Ata ur Rehman ------------------------------ AM Library, National Centre for Physics(NCP), Islamabad http://www.ncp.edu.pk/ http://www.ncplib.co.cc/ Coordinator, LISolutions? info(a)lisolutions.org http://www.lisolutions.org My profiles: [image: Facebook] <http://www.facebook.com/ataurrehman> [image: LinkedIn] <http://pk.linkedin.com/in/ataurrehman> [image: Flickr]<http://www.flickr.com/photos/lisolutions/> [image: Twitter] <http://twitter.com/ataurrehman> [image: Blogger]<http://www.lisolutions.net/> [image: Delicious] <http://www.delicious.com/ataurrehman> Contact me: [image: Google Talk] ata.rehman [image: Skype] ata.rehman [image: MSN] ata.rehman(a)gmail.com On Tue, Jun 14, 2011 at 11:09 AM, R Sunil Kumar <sunil.kumar(a)ecoleglobal.com > wrote: > Dear Rehman, > > > > But I have barcode also where I have already given 952$p wont? that clash > with Accession Number MARC Tag. > > > > I need to use barcode for the circulation purpose. > > > > Thanks and Regards > > > > R Sunil Kumar > > Library Technologist > > +91-9686576695 > > > > *From:* Ata ur Rehman [mailto:ata.rehman@gmail.com] > *Sent:* 14 June 2011 11:31 > *To:* sunil.kumar(a)ecoleglobal.com > *Cc:* koha(a)lists.katipo.co.nz > *Subject:* Re: [Koha] Uploading the database from excel to KOHA : Copies > not available / Missing > > > > Sunil > > Put your accession number in 952$p and re import the records > > Ata > > 2011/6/14 R Sunil Kumar <sunil.kumar(a)ecoleglobal.com> > > Dear All, > > > > I am trying to upload the database from excel file to KOHA below are the > list of fields available in the excel sheet and the corresponding MARC tags > code. > > > > But when I upload the data to the KOHA using MarcEdit Software, as there is > multiple copies of single ISBN number, I have used the matching rules (ISBN > as unique identifier) and it had successfully matched the record and > displayed the record number wherever there is a matching of records (biblio > number). Database is successfully created message comes and display the > biblio number. > > > > But when I do OPAC search it display two option. > > > > Error 1: Copies does not exit > > Error 2: Copies available in (library branch name) but when I try to Place > Hold, it shows copies not available or missing. > > > > Accession Number > > 082$b > > Language > > 041$a > > Language > > 041$a > > Language > > 041$a > > Location > > 952$c > > Status > > 952$4 > > CallNumber > > 082$a > > Title > > 245$a > > Reminder Title > > 245$b > > Author 1 > > 245$c > > Author 2 > > 700$a > > Author 3 > > 700$a > > ISBN > > 020$a > > Barcode > > 952$p > > Publisher Name > > 260$b > > Place of Publication > > 260$a > > Year of Publication > > 260$c > > Subject 1 > > 650$v > > Subject 2 > > 650$v > > Subject 3 > > 650$v > > Volume > > 440$v > > Pages > > 300$a > > Cover Type (Paperback/Hardbound) > > 300$b > > Edition > > 260$a > > Editor > > 700$a > > Translator > > 700$a > > Series Name > > 490$a > > Price > > 952$o > > Currency > > Condition > > 952$a > > Receipt Date > > Remark > > 500$a > > > > Can anybody please share the pre-migration / post migration requirements > for migration database from Excel to Koha. > > > > Thanks and Regards > > > > R Sunil Kumar > > Library Technologist > > [image: cid:image001.jpg@01CC250B.5782A730] > > *Ecole Solutions Pvt Ltd* > > Level 15 Concorde Towers UB City 1 Vittal Mallya Road > > Bangalore 560001,India > > Mobile: +91 9686576695 Fax: +91 80 40300400 > > eMail: sunil.kumar(a)ecoleglobal.com Web: www.ecoleglobal.com > > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > >

1 0

Re: [Koha] Koha Digest, Vol 68, Issue 57
by R Sunil Kumar 14 Jun '11

14 Jun '11

Dear Bob, Location (952$c) is basically the shelf location of the book in the library, regard to the library branch / holding branch. There is only one library with different shelf location (primary book, science book, reference book, etc). It will be appropriate if I use 952$a (for library branch/library holding as 'Main Library' in my database) and 952$c (as shelf location in my database) Please suggest. Thanks and Regards R Sunil Kumar Library Technologist +91-9686576695 -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: 14 June 2011 11:40 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 68, Issue 57 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: Uploading the database from excel to KOHA : Copies not available / Missing (Bob Birchall) 2. Re: Uploading the database from excel to KOHA : Copies not available / Missing (R Sunil Kumar) ---------------------------------------------------------------------- Message: 1 Date: Tue, 14 Jun 2011 16:06:49 +1000 From: Bob Birchall <bob(a)calyx.net.au> Subject: Re: [Koha] Uploading the database from excel to KOHA : Copies not available / Missing To: koha(a)lists.katipo.co.nz Message-ID: <4DF6FA79.6050301(a)calyx.net.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed On 14/06/11 15:27, R Sunil Kumar wrote: > Dear All, > > I am trying to upload the database from excel file to KOHA below are the > list of fields available in the excel sheet and the corresponding MARC > tags code. Be careful using Excel for this exercise - it will embed non-printing characters in your data. Use Libre Office and keep your file in csv format. > > But when I upload the data to the KOHA using MarcEdit Software, as there > is multiple copies of single ISBN number, I have used the matching rules > (ISBN as unique identifier) and it had successfully matched the record > and displayed the record number wherever there is a matching of records > (biblio number). Database is successfully created message comes and > display the biblio number. > > But when I do OPAC search it display two option. > > Error 1: Copies does not exit > > Error 2: Copies available in (library branch name) but when I try to > Place Hold, it shows copies not available or missing. You don't seem to have branch data in your holdings statement (952). Koha requires both Home Branch (952$a) and Holding Branch (952$b). Refer to Koha to Marc Mapping on the Administration page for the fields expected by Koha. You do have Location (952$c) so if that is your library/branch, change it to 952$a then copy that to 952$b. The value must match exactly (including case) a value in your Libraries definition (Administration/Libraries, Branches, Groups). But first move Condition from 952$a to a more suitable sub-field. Hope that helps, Bob Birchall CALYX ------------------------------ Message: 2 Date: Tue, 14 Jun 2011 11:39:21 +0530 From: "R Sunil Kumar" <sunil.kumar(a)ecoleglobal.com> Subject: Re: [Koha] Uploading the database from excel to KOHA : Copies not available / Missing To: "'Ata ur Rehman'" <ata.rehman(a)gmail.com> Cc: koha(a)lists.katipo.co.nz Message-ID: <000f01cc2a59$9cdae970$d690bc50$@kumar@ecoleglobal.com> Content-Type: text/plain; charset="utf-8" Dear Rehman, But I have barcode also where I have already given 952$p wont? that clash with Accession Number MARC Tag. I need to use barcode for the circulation purpose. Thanks and Regards R Sunil Kumar Library Technologist +91-9686576695 From: Ata ur Rehman [mailto:ata.rehman@gmail.com] Sent: 14 June 2011 11:31 To: sunil.kumar(a)ecoleglobal.com Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Uploading the database from excel to KOHA : Copies not available / Missing Sunil Put your accession number in 952$p and re import the records Ata 2011/6/14 R Sunil Kumar <sunil.kumar(a)ecoleglobal.com> Dear All, I am trying to upload the database from excel file to KOHA below are the list of fields available in the excel sheet and the corresponding MARC tags code. But when I upload the data to the KOHA using MarcEdit Software, as there is multiple copies of single ISBN number, I have used the matching rules (ISBN as unique identifier) and it had successfully matched the record and displayed the record number wherever there is a matching of records (biblio number). Database is successfully created message comes and display the biblio number. But when I do OPAC search it display two option. Error 1: Copies does not exit Error 2: Copies available in (library branch name) but when I try to Place Hold, it shows copies not available or missing. Accession Number 082$b Language 041$a Language 041$a Language 041$a Location 952$c Status 952$4 CallNumber 082$a Title 245$a Reminder Title 245$b Author 1 245$c Author 2 700$a Author 3 700$a ISBN 020$a Barcode 952$p Publisher Name 260$b Place of Publication 260$a Year of Publication 260$c Subject 1 650$v Subject 2 650$v Subject 3 650$v Volume 440$v Pages 300$a Cover Type (Paperback/Hardbound) 300$b Edition 260$a Editor 700$a Translator 700$a Series Name 490$a Price 952$o Currency Condition 952$a Receipt Date Remark 500$a Can anybody please share the pre-migration / post migration requirements for migration database from Excel to Koha. Thanks and Regards R Sunil Kumar Library Technologist cid:image001.jpg@01CC250B.5782A730 Ecole Solutions Pvt Ltd Level 15 Concorde Towers UB City 1 Vittal Mallya Road Bangalore 560001,India Mobile: +91 9686576695 Fax: +91 80 40300400 <tel:%2B91%2080%2040300400> eMail: sunil.kumar(a)ecoleglobal.com Web: www.ecoleglobal.com _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Re: [Koha] Uploading the database from excel to KOHA : Copies not available / Missing
by Ata ur Rehman 14 Jun '11

14 Jun '11

Dear Sunil / All Accession number is a unique number assigned to every book in library and in most of cases accession number is used for circulation, holds, etc. But if this is not the case in your situation, you may put other values in barcode 952$p. But no of copies in each biblio record depends upon no of barcodes (952$p) associated with it. 952$p is repeatable tag. Regards Ata ur Rehman ------------------------------ AM Library, National Centre for Physics(NCP), Islamabad http://www.ncp.edu.pk/ http://www.ncplib.co.cc/ Coordinator, LISolutions® info(a)lisolutions.org http://www.lisolutions.org My profiles: [image: Facebook] <http://www.facebook.com/ataurrehman> [image: LinkedIn] <http://pk.linkedin.com/in/ataurrehman> [image: Flickr]<http://www.flickr.com/photos/lisolutions/> [image: Twitter] <http://twitter.com/ataurrehman> [image: Blogger]<http://www.lisolutions.net/> [image: Delicious] <http://www.delicious.com/ataurrehman> Contact me: [image: Google Talk] ata.rehman [image: Skype] ata.rehman [image: MSN] ata.rehman(a)gmail.com On Tue, Jun 14, 2011 at 11:09 AM, R Sunil Kumar <sunil.kumar(a)ecoleglobal.com > wrote: > Dear Rehman, > > > > But I have barcode also where I have already given 952$p wont’ that clash > with Accession Number MARC Tag. > > > > I need to use barcode for the circulation purpose. > > > > Thanks and Regards > > > > R Sunil Kumar > > Library Technologist > > +91-9686576695 > > > > *From:* Ata ur Rehman [mailto:ata.rehman@gmail.com] > *Sent:* 14 June 2011 11:31 > *To:* sunil.kumar(a)ecoleglobal.com > *Cc:* koha(a)lists.katipo.co.nz > *Subject:* Re: [Koha] Uploading the database from excel to KOHA : Copies > not available / Missing > > > > Sunil > > Put your accession number in 952$p and re import the records > > Ata > > 2011/6/14 R Sunil Kumar <sunil.kumar(a)ecoleglobal.com> > > Dear All, > > > > I am trying to upload the database from excel file to KOHA below are the > list of fields available in the excel sheet and the corresponding MARC tags > code. > > > > But when I upload the data to the KOHA using MarcEdit Software, as there is > multiple copies of single ISBN number, I have used the matching rules (ISBN > as unique identifier) and it had successfully matched the record and > displayed the record number wherever there is a matching of records (biblio > number). Database is successfully created message comes and display the > biblio number. > > > > But when I do OPAC search it display two option. > > > > Error 1: Copies does not exit > > Error 2: Copies available in (library branch name) but when I try to Place > Hold, it shows copies not available or missing. > > > > Accession Number > > 082$b > > Language > > 041$a > > Language > > 041$a > > Language > > 041$a > > Location > > 952$c > > Status > > 952$4 > > CallNumber > > 082$a > > Title > > 245$a > > Reminder Title > > 245$b > > Author 1 > > 245$c > > Author 2 > > 700$a > > Author 3 > > 700$a > > ISBN > > 020$a > > Barcode > > 952$p > > Publisher Name > > 260$b > > Place of Publication > > 260$a > > Year of Publication > > 260$c > > Subject 1 > > 650$v > > Subject 2 > > 650$v > > Subject 3 > > 650$v > > Volume > > 440$v > > Pages > > 300$a > > Cover Type (Paperback/Hardbound) > > 300$b > > Edition > > 260$a > > Editor > > 700$a > > Translator > > 700$a > > Series Name > > 490$a > > Price > > 952$o > > Currency > > Condition > > 952$a > > Receipt Date > > Remark > > 500$a > > > > Can anybody please share the pre-migration / post migration requirements > for migration database from Excel to Koha. > > > > Thanks and Regards > > > > R Sunil Kumar > > Library Technologist > > [image: cid:image001.jpg@01CC250B.5782A730] > > *Ecole Solutions Pvt Ltd* > > Level 15 Concorde Towers UB City 1 Vittal Mallya Road > > Bangalore 560001,India > > Mobile: +91 9686576695 Fax: +91 80 40300400 > > eMail: sunil.kumar(a)ecoleglobal.com Web: www.ecoleglobal.com > > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > >

1 0

Re: [Koha] Uploading the database from excel to KOHA : Copies not available / Missing
by Ata ur Rehman 14 Jun '11

14 Jun '11

Sunil Put your accession number in 952$p and re import the records Ata 2011/6/14 R Sunil Kumar <sunil.kumar(a)ecoleglobal.com> > Dear All, > > > > I am trying to upload the database from excel file to KOHA below are the > list of fields available in the excel sheet and the corresponding MARC tags > code. > > > > But when I upload the data to the KOHA using MarcEdit Software, as there is > multiple copies of single ISBN number, I have used the matching rules (ISBN > as unique identifier) and it had successfully matched the record and > displayed the record number wherever there is a matching of records (biblio > number). Database is successfully created message comes and display the > biblio number. > > > > But when I do OPAC search it display two option. > > > > Error 1: Copies does not exit > > Error 2: Copies available in (library branch name) but when I try to Place > Hold, it shows copies not available or missing. > > > > Accession Number > > 082$b > > Language > > 041$a > > Language > > 041$a > > Language > > 041$a > > Location > > 952$c > > Status > > 952$4 > > CallNumber > > 082$a > > Title > > 245$a > > Reminder Title > > 245$b > > Author 1 > > 245$c > > Author 2 > > 700$a > > Author 3 > > 700$a > > ISBN > > 020$a > > Barcode > > 952$p > > Publisher Name > > 260$b > > Place of Publication > > 260$a > > Year of Publication > > 260$c > > Subject 1 > > 650$v > > Subject 2 > > 650$v > > Subject 3 > > 650$v > > Volume > > 440$v > > Pages > > 300$a > > Cover Type (Paperback/Hardbound) > > 300$b > > Edition > > 260$a > > Editor > > 700$a > > Translator > > 700$a > > Series Name > > 490$a > > Price > > 952$o > > Currency > > Condition > > 952$a > > Receipt Date > > Remark > > 500$a > > > > Can anybody please share the pre-migration / post migration requirements > for migration database from Excel to Koha. > > > > Thanks and Regards > > > > R Sunil Kumar > > Library Technologist > > [image: cid:image001.jpg@01CC250B.5782A730] > > *Ecole Solutions Pvt Ltd* > > Level 15 Concorde Towers UB City 1 Vittal Mallya Road > > Bangalore 560001,India > > Mobile: +91 9686576695 Fax: +91 80 40300400 > > eMail: sunil.kumar(a)ecoleglobal.com Web: www.ecoleglobal.com > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > >

2 1