- Koha - lists.katipo.co.nz

Re: [Koha] Help needed with report - how to extract subtitle and edition?
by mh_zalabany＠hotmail.com 25 Oct '12

25 Oct '12

I think in this case you need to make the report using the xml field in biblio items table because the rest of sub fields you will find there Sent from my HTC ----- Reply message ----- From: "Elaine Bradtke" <eb(a)efdss.org> To: "koha" <koha(a)lists.katipo.co.nz> Subject: [Koha] Help needed with report - how to extract subtitle and edition? Date: Wed, Oct 24, 2012 11:23 pm I'm trying to catch duplicate items in data before I upload it (ISBN won't help in this case). In order to do that I've written a report to list the books currently in Koha, and will compare them with my external files. However, if I can't include the subtitle (MARC 245 b) I will get too many false positives (we have lots of things with the same title, but different subtitles) It would also help if I could also have the 250 a (edition) This is what I have: SELECT biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioitems.place,biblioitems.publishercode,biblioitems.isbn FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype='BK' AND items.holdingbranch='VWML' ORDER BY biblio.author asc This works fine, but doesn't include the 245 b or the 250 a Can anyone help? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

CAS server /koha
by Samuel Desseaux 25 Oct '12

25 Oct '12

Hi, I've just enabled cas authentification and i've an error. Seems to be clear: The url which allows to connect is https://cas.ecp.fr//login?service=/index.html The index doesn't exists but i'd like to correct it. I suppose it's in the perl module? Best regards samuel

1 0

Re: [Koha] Improving the advanced search form (Mason James)
by Sunil Kumar 25 Oct '12

25 Oct '12

Dear James, Thanks for the input, but what about 3.6 version. Is there any solution for the same. Thanks and Regards R Sunil Kumar Library Technologist -----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: 25 October 2012 17:31 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 84, Issue 48 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: need help in zebra indexing for Arabic words (mh_zalabany(a)hotmail.com) 2. Fwd: Koha Database Migration (Chris Nighswonger) 3. Re: need help in zebra indexing for Arabic words (Karam Qubsi) 4. Re: Improving the advanced search form (Mason James) ---------------------------------------------------------------------- Message: 1 Date: Thu, 25 Oct 2012 11:39:25 +0200 From: mh_zalabany(a)hotmail.com <mh_zalabany(a)hotmail.com> To: karamqubsi(a)gmail.com, "Koha" <Koha(a)lists.katipo.co.nz>, Koha-devel(a)lists.koha-community.org Subject: Re: [Koha] need help in zebra indexing for Arabic words Message-ID: <BLU0-SMTP3851383E7C326B28479E844977F0(a)phx.gbl> Content-Type: text/plain; charset="utf-8" Hi karam I think this issue is very important to all users who use Arabic language We need to know what the important modifications in Zebra index And koha files to index the arabic words without suffix and prifex or searsh with root word using zebra I will give you example We need to search for word (al-madrasah) this mean school We have tow parts (al) mean (the)and (madrasah ) and the last caracter (h) may have tow forms( ? ? ) we need when we search for madrasa get madrasah and al-madrasah with all its forms Sent from my HTC ----- Reply message ----- From: "Karam Qubsi" <karamqubsi(a)gmail.com> To: "Koha" <Koha(a)lists.katipo.co.nz>, <Koha-devel(a)lists.koha-community.org> Subject: [Koha] need help in zebra indexing for Arabic words Date: Thu, Oct 25, 2012 11:12 am Hi All I sent this email to the zebra mailing list I wish that koha will support suffix and prefix in the arabic search by default in the future I wish if you have any Idea about the solution for this Best regards Karam. ---------- Forwarded message ---------- From: Karam Qubsi <karamqubsi(a)gmail.com> Date: Thu, Oct 25, 2012 at 4:20 AM Subject: need help in transliterate rule To: zebralist(a)lists.indexdata.dk Hi all , I'm new to zebra , and using it in "koha" ILS in the Arabic language there is some letter come before the words or after them these letters we don't need to index in our index I will give you an example : in English we can say : the car... in Arabic the same is : ??????? if you note that the letter in Red is "the" and it's ignored in English search but in Arabic search we need the zebra to find every record that have " the word " or just "word" ?????? or ???? so how to define that to zebra thanks a lot _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 2 Date: Thu, 25 Oct 2012 06:13:28 -0400 From: Chris Nighswonger <cnighswonger(a)foundations.edu> To: koha(a)lists.katipo.co.nz Subject: [Koha] Fwd: Koha Database Migration Message-ID: <CAP3yOomSLJTvDboaguJghre3L2rO=CF6csE7C7w4bVzfba8eGQ(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Yesan, Please send your support requests to the Koha User's list. You will have a much greater chance of getting a response that way. You should be able to do an "in place" upgrade. After taking a backup of your current database, just install the new version of Koha and browse to the staff interface to run the installer. There is also at least one script you will need to run from the command line to remove the items from the bibs. Probably the best way is to move to the packages. I believe there is a way when installing from the packages to import your existing database. Check out koha-create for more on that. Also, I think the packages will run all of the necessary back-end scripts. Someone else will correct me if I'm wrong. Read more here: http://wiki.koha-community.org/wiki/Debian Kind Regards, Chris ---------- Forwarded message ---------- From: Chief Librarian, SAIACS <library(a)saiacs.org> Date: Thu, Oct 25, 2012 at 1:58 AM Subject: Koha Database Migration To: paul.a(a)aandc.org Cc: cnighswonger(a)foundations.edu Dear friends, I would like to know if you have got a solution to migrate my KOHA database 3.6 to 3.8. I know marc records export and import. But I would like to know if we can migrate the database itself. 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 : www.saiacs.org Alternative Email: yesan.sellan(a)saiacs.org or yesans(a)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. ------------------------------ Message: 3 Date: Thu, 25 Oct 2012 06:17:52 -0400 From: Karam Qubsi <karamqubsi(a)gmail.com> To: "mh_zalabany(a)hotmail.com" <mh_zalabany(a)hotmail.com> Cc: Koha <Koha(a)lists.katipo.co.nz>, Koha-devel(a)lists.koha-community.org Subject: Re: [Koha] need help in zebra indexing for Arabic words Message-ID: <CAML=htZ+EQBrfLtrvkSac9oJXw9G97d1j_a286EpkToyFLhKow(a)mail.gmail.com> Content-Type: text/plain; charset=windows-1256 Thanks Mohamed for give more description about our same problem I wish we can find a solution for this problem for all the users of koha in the Arab world while I'm searching i find something about the " ? ? ?" letters to considers them all as "? " and I find something about the suffix " ? ? " the solution is to edit the words-icu.xml file and add these lines : for ? ? ? : <transliterate rule=" [\u0623 \u0625 \u0622] > \u0627 " /> and for the ? ? suffix add : <transliterate rule="? > ?"/> and for the ? ? suffix add : <transliterate rule=" ? > ? "/> I didn't try this I wish you try and tell me but about ignoring the ??? letters in words i didn't find how to do this I wish someone can help us about this best regards On Thu, Oct 25, 2012 at 5:39 AM, mh_zalabany(a)hotmail.com < mh_zalabany(a)hotmail.com> wrote: > Hi karam > I think this issue is very important to all users who use Arabic > language We need to know what the important modifications in Zebra > index And koha files to index the arabic words without suffix and > prifex or searsh with root word using zebra > > I will give you example > We need to search for word (al-madrasah) this mean school We have tow > parts (al) mean (the)and (madrasah ) and the last caracter (h) may > have tow forms( ? ? ) we need when we search for madrasa get madrasah > and al-madrasah with all its forms Sent from my HTC > > > > ----- Reply message ----- > From: "Karam Qubsi" <karamqubsi(a)gmail.com> > To: "Koha" <Koha(a)lists.katipo.co.nz>, > <Koha-devel(a)lists.koha-community.org > > > Subject: [Koha] need help in zebra indexing for Arabic words > Date: Thu, Oct 25, 2012 11:12 am > > > Hi All > > I sent this email to the zebra mailing list > > I wish that koha will support suffix and prefix in the arabic search > by default in the future > > I wish if you have any Idea about the solution for this > > Best regards > Karam. > > ---------- Forwarded message ---------- > From: Karam Qubsi <karamqubsi(a)gmail.com> > Date: Thu, Oct 25, 2012 at 4:20 AM > Subject: need help in transliterate rule > To: zebralist(a)lists.indexdata.dk > > > Hi all , > I'm new to zebra , and using it in "koha" ILS > > in the Arabic language there is some letter come before the words or > after them these letters we don't need to index in our index I will > give you an example : > in English we can say : the car... > in Arabic the same is : ??????? > if you note that the letter in Red is "the" and it's ignored in > English search but in Arabic search we need the zebra to find every > record that have " the word " or just "word" ?????? or ???? > > so how to define that to zebra > > thanks a lot > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- *Karam Qubsi* Arabic Koha Support Team The founder of Wikibrary (The Arabic Libraries And Information Science Encyclopedia ) *Email: karamqubsi(a)gmail.com* *Skype : karam.qubsi* *Mobile: +963 991 264 020* *Viber <http://viber.com/> / Tango <http://www.tango.me/> : +963 991 264 020 * *Wikibrary website : http://wikibrary.org* *Wiki and forum for Arabic Koha : http://koha.wikibrary.org<http://wikibrary.org/> * *??? ????.* ???? ?????? ? ???? ????? ???? ?????????? ( ???????? ??????? ???????? ?????????? ) ------------------------------ Message: 4 Date: Fri, 26 Oct 2012 01:00:31 +1300 From: Mason James <mtj(a)kohaaloha.com> To: sunil.kumar(a)ecoleglobal.com Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Improving the advanced search form Message-ID: <6A656B61-2350-4882-9E09-EEFFBEA910A5(a)kohaaloha.com> Content-Type: text/plain; charset=us-ascii On 2012-10-25, at 5:27 PM, Sunil Kumar wrote: > Dear All, > > I agree with the same, I always had problem in advance search especially for > the barcode based search. > > Even if I select the barcode as search option and enter the specific barcode > number, Koha opac always show all the titles wherever that specific number > is entered. But other that the barcode number. hmm, i just tested this on Koha 3.8.5 it works fine for me... ps: edit your email, before replying to digest messages > > Is there any solution for the same? > > Thanks and Regards > > R Sunil Kumar > Library Technologist > > > > > -----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: 25 October 2012 09:53 > To: koha(a)lists.katipo.co.nz > Subject: Koha Digest, Vol 84, Issue 46 > > 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. Improving the advanced search form (Srikanth Dhondi) > 2. Re: Improving the advanced search form (Chris Cormack) > 3. Re: Improving the advanced search form (Gay Richards) > 4. Re: Data Migration (Dennis Njuguna) (Sunil Kumar) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 25 Oct 2012 14:55:31 +1300 > From: Srikanth Dhondi <srikanth(a)catalyst.net.nz> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Improving the advanced search form > Message-ID: <50889C13.9080505(a)catalyst.net.nz> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hi there, > > I am currently working on improving accessibility of koha opac site with our > accessibility expert. > One of the things we noticed is that the advanced search option is not only > confusing for blind users but also even for normal users. > > I have noticed the following issues with it: > > 1) By default the Fewer Options option is selected, which is not obvious to > the normal users until they click on More Options. > > 2) The layout could be a lot better, in particular the Fewer Options search > form is quite abstract in what it does. > > For example, the default boolean operator is AND which is not obvious to > even normal user. > > In my opinion, layout similar to the one http://kea.massey.ac.nz/search/X, > is better. > > Looking forward to your comments/feedback. > > Srikanth > > > ------------------------------ > > Message: 2 > Date: Thu, 25 Oct 2012 15:03:21 +1300 > From: Chris Cormack <chris(a)bigballofwax.co.nz> > To: Srikanth Dhondi <srikanth(a)catalyst.net.nz> > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Improving the advanced search form > Message-ID: > <CA+95qVR9P0U4Wynn2p0PWP3Wb37J+7SSiMu1xjvZs1kbq=9=nw(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > On 25 October 2012 14:55, Srikanth Dhondi <srikanth(a)catalyst.net.nz> wrote: >> Hi there, >> >> I am currently working on improving accessibility of koha opac site >> with our accessibility expert. >> One of the things we noticed is that the advanced search option is not >> only confusing for blind users but also even for normal users. >> >> I have noticed the following issues with it: >> >> 1) By default the Fewer Options option is selected, which is not >> obvious to the normal users until they click on More Options. >> >> 2) The layout could be a lot better, in particular the Fewer Options >> search form is quite abstract in what it does. >> >> For example, the default boolean operator is AND which is not obvious >> to even normal user. >> >> In my opinion, layout similar to the one >> http://kea.massey.ac.nz/search/X, is better. >> > I'm going to disagree and say that site is horrid :) > > Maybe others will have different opinions though. > > Chris > > > ------------------------------ > > Message: 3 > Date: Thu, 25 Oct 2012 02:45:24 +0000 > From: Gay Richards <g.richards(a)auckland.ac.nz> > To: 'Chris Cormack' <chris(a)bigballofwax.co.nz>, Srikanth Dhondi > <srikanth(a)catalyst.net.nz> > Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Improving the advanced search form > Message-ID: > > <AB44DEB8CF4F784F90EBCDBBD9B817376D7E2714(a)uxcn10-5.UoA.auckland.ac.nz> > Content-Type: text/plain; charset="us-ascii" > > Agree advanced search could and should be improved, but don't like example > suggested. > > I generallly like the "look: of the Koha advanced search page. The problem > (apart from any accessibility issues) is that some functions don't work as > one might expect - as outlined below. Also: > > We would like to turn off or limit languages to onees that are actually > available in our catalog. > > The Search for additional content types is really misleading as it relies on > codes from marc field 008 which may or may not have been used. > I'm sure I have other issues with this screen and I would be keen to discuss > any improvements further. We support anything that makes it more accessible > too. Gay > > -----Original Message----- > From: koha-bounces(a)lists.katipo.co.nz > [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Chris Cormack > Sent: Thursday, 25 October 2012 3:03 p.m. > To: Srikanth Dhondi > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Improving the advanced search form > > On 25 October 2012 14:55, Srikanth Dhondi <srikanth(a)catalyst.net.nz> wrote: >> Hi there, >> >> I am currently working on improving accessibility of koha opac site >> with our accessibility expert. >> One of the things we noticed is that the advanced search option is not >> only confusing for blind users but also even for normal users. >> >> I have noticed the following issues with it: >> >> 1) By default the Fewer Options option is selected, which is not >> obvious to the normal users until they click on More Options. >> >> 2) The layout could be a lot better, in particular the Fewer Options >> search form is quite abstract in what it does. >> >> For example, the default boolean operator is AND which is not obvious >> to even normal user. >> >> In my opinion, layout similar to the one >> http://kea.massey.ac.nz/search/X, is better. >> > I'm going to disagree and say that site is horrid :) > > Maybe others will have different opinions though. > > Chris > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > Message: 4 > Date: Thu, 25 Oct 2012 09:52:23 +0530 > From: "Sunil Kumar" <sunil.kumar(a)ecoleglobal.com> > To: <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Data Migration (Dennis Njuguna) > Message-ID: <000301cdb268$57b958c0$072c0a40$@kumar@ecoleglobal.com> > Content-Type: text/plain; charset="us-ascii" > > Dear Dennis, > > I believe you are missing MARC tag 952 series, 952 is the local tags which > contain all the information about the holding. For example. > > 952$8$9$a$b$c$g$h$p$y > $8 is for collection code > $9 is for biblio number > $a is for permanent location > $b is for current location > $c is for shelf location > $g is for purchase price (you can include the vendor name, location and > invoice details also here) $h is for volume details of the resources mainly > it is used for the journal/magazine/periodicals $p is for the barcode $y is > for the item type > > Once you have all the required information in 952 series you can convert the > file into marc format and upload the same to koha, as the standard process. > > Thanks and Regards > > R Sunil Kumar > Library Technologist > > > > -----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: 25 October 2012 03:21 > To: koha(a)lists.katipo.co.nz > Subject: Koha Digest, Vol 84, Issue 45 > > 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: Data Migration (Dennis Njuguna) > 2. Re: Data Migration (Mohamed zalabany) > 3. Problems upgrading to 3.8 (Ramon Andi?ach) > 4. Re: Problems upgrading to 3.8 (Hugo Agud) > 5. Email. (Estel Porras) > 6. Help needed with report - how to extract subtitle and > edition? (Elaine Bradtke) > 7. Re: Help needed with report - how to extract subtitle and > edition? (mh_zalabany(a)hotmail.com) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 24 Oct 2012 12:17:39 +0300 > From: Dennis Njuguna <cknjuguna(a)gmail.com> > To: Mohamed zalabany <mh_zalabany(a)hotmail.com> > Cc: koha list <koha(a)lists.katipo.co.nz>, "manny_tamayao(a)sil.org" > <manny_tamayao(a)sil.org> > Subject: Re: [Koha] Data Migration > Message-ID: > <CAH0M1x-AbcrEvvzfvOL9oJ4nE7NMD0o4-UytqTUa0LfGxyOyAA(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > it is marc compliant, but when I take it to marcedit i view the file but I > cannot see/view the barcode, if I import the marc into koha I can only > import the biblios records, no holdings. > > > > On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany > <mh_zalabany(a)hotmail.com>wrote: > >> 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 Zalabaitny* >> ** >> *Integrated library systems consultant* >> >> Zalabany Knowledge Systems Team? >> For Libraries and Information systems Development and support >> mh_zalabany(a)hotmail.com >> Mobile: 0111291444 >> >> ** >> >> >> ------------------------------ >> Date: Tue, 23 Oct 2012 17:08:09 +0300 >> Subject: Re: [Koha] Data Migration >> From: cknjuguna(a)gmail.com >> To: mh_zalabany(a)hotmail.com >> CC: manny_tamayao(a)sil.org; koha(a)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_zalabany(a)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_zalabany(a)hotmail.com >> Mobile: 202-0111291444 >> >> >> >>> From: manny_tamayao(a)sil.org >>> To: koha(a)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(a)lists.katipo.co.nz >>> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> _______________________________________________ >> Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> >> >> -- >> >> Dennis K. Njuguna >> >> > > > -- > > Dennis K. Njuguna > > > ------------------------------ > > Message: 2 > Date: Wed, 24 Oct 2012 09:38:15 +0000 > From: Mohamed zalabany <mh_zalabany(a)hotmail.com> > To: <cknjuguna(a)gmail.com> > Cc: koha list <koha(a)lists.katipo.co.nz>, "manny_tamayao(a)sil.org" > <manny_tamayao(a)sil.org> > Subject: Re: [Koha] Data Migration > Message-ID: <BLU165-W49D11BF288626BB715E85597780(a)phx.gbl> > Content-Type: text/plain; charset="iso-8859-1" > > > > I think there is option to export item data with MARC record > > > Mohamed El ZalabanyIntegrated library systems consultant > > Zalabany Knowledge Systems Team? > For Libraries and Information systems Development and support > mh_zalabany(a)hotmail.com > Mobile: 0111291444 > > > > Date: Wed, 24 Oct 2012 12:17:39 +0300 > Subject: Re: [Koha] Data Migration > From: cknjuguna(a)gmail.com > To: mh_zalabany(a)hotmail.com > CC: manny_tamayao(a)sil.org; koha(a)lists.katipo.co.nz > > > it is marc compliant, but when I take it to marcedit i view the file but I > cannot see/view the barcode, if I import the marc into koha I can only > import the biblios records, no holdings. > > > > > On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany <mh_zalabany(a)hotmail.com> > wrote: > > > > > > 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 Zalabaitny > Integrated library systems consultant > > Zalabany Knowledge Systems Team? > For Libraries and Information systems Development and support > > mh_zalabany(a)hotmail.com > Mobile: 0111291444 > > > > > Date: Tue, 23 Oct 2012 17:08:09 +0300 > Subject: Re: [Koha] Data Migration > From: cknjuguna(a)gmail.com > To: mh_zalabany(a)hotmail.com > > CC: manny_tamayao(a)sil.org; koha(a)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_zalabany(a)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_zalabany(a)hotmail.com > > Mobile: 202-0111291444 > > > > > > > >> From: manny_tamayao(a)sil.org > >> To: koha(a)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(a)lists.katipo.co.nz > >> http://lists.katipo.co.nz/mailman/listinfo/koha > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > -- > > Dennis K. Njuguna > > > > > -- > > Dennis K. Njuguna > > > > ------------------------------ > > Message: 3 > Date: Wed, 24 Oct 2012 23:46:00 +0800 > From: Ramon Andi?ach <custard(a)westnet.com.au> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Problems upgrading to 3.8 > Message-ID: <96D8A573-0DC3-478B-BA5C-CBD5FD9974A5(a)westnet.com.au> > Content-Type: text/plain; charset=us-ascii > > Hi, > > This is going sound pathetic, and stupid, but I'm in need of some guidance. > It has been quite some time since I've tried to use koha. > > I've been upgrading my koha from 3.00 towards 3.8 via the tarball method. > > I was attempting to be good, and going in smallish steps so 3.00 to 3.02 to > 3.04 to 3.06 and then to 3.8. > > In between each upgrade I was trying a few searches to make sure that the > books end of the db was intact and then backing up the DB. > > After the 3.06 step it seemed to be working. > > But, after the 3.8 step suddenly most of the books seem to have vanished. > > I'd put it down to noticing in the upgrade notes some extra steps that I > didn't see in the 3.6 or 3.4 notes (the ones about removing the duplicated > item details). So I dropped the DB and reloaded the backup from the 3.6 step > and tried without these steps. > > I've also now tried the original backup too, without success. > > I'm not sure at this point if it's the items that have vanished or the > records too. Yes, I have run rebuild_zebra -b -r as the koha user (several > times no luck). > > So I suppose I'm looking for guidance on > a) working out what is going on. > b) how to get normality back again. > > -ramon. > > ------------------------------ > > Message: 4 > Date: Wed, 24 Oct 2012 18:01:53 +0200 > From: Hugo Agud <hagud(a)orex.es> > To: Ramon Andi?ach <custard(a)westnet.com.au> > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Problems upgrading to 3.8 > Message-ID: > <CADT_QRTsaDrrye_Ux-To_JkjQZk=eT3QN_b1UEoEPSg1N_k64Q(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi Ramon > > Do not worry it happens to a lot of people ... take a look on this > > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8665 > > Kindest Regards > > 2012/10/24 Ramon Andi?ach <custard(a)westnet.com.au> > >> Hi, >> >> This is going sound pathetic, and stupid, but I'm in need of some >> guidance. It has been quite some time since I've tried to use koha. >> >> I've been upgrading my koha from 3.00 towards 3.8 via the tarball method. >> >> I was attempting to be good, and going in smallish steps so 3.00 to >> 3.02 to 3.04 to 3.06 and then to 3.8. >> >> In between each upgrade I was trying a few searches to make sure that >> the books end of the db was intact and then backing up the DB. >> >> After the 3.06 step it seemed to be working. >> >> But, after the 3.8 step suddenly most of the books seem to have vanished. >> >> I'd put it down to noticing in the upgrade notes some extra steps that >> I didn't see in the 3.6 or 3.4 notes (the ones about removing the >> duplicated item details). So I dropped the DB and reloaded the backup >> from the 3.6 step and tried without these steps. >> >> I've also now tried the original backup too, without success. >> >> I'm not sure at this point if it's the items that have vanished or the >> records too. Yes, I have run rebuild_zebra -b -r as the koha user >> (several times no luck). >> >> So I suppose I'm looking for guidance on >> a) working out what is going on. >> b) how to get normality back again. >> >> -ramon. >> _______________________________________________ >> Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> > > > > -- > > *Hugo Agud - Orex Digital * > > *www.orex.es* > > * > * > > Director > > Avenida Sarri? 29 ? 08029 Barcelona <http://twitter.com/OrexDigital> > :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539 > 33 30 > hagud(a)orex.es ? http://www.orex.es/ > > > > No imprima este mensaje a no ser que sea necesario. Una tonelada de papel > implica la tala de 15 ?rboles y el consumo de 250.000 litros de agua. > > > > Aviso de confidencialidad > Este mensaje contiene informaci?n que puede ser CONFIDENCIAL y/o de USO > RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni est? > autorizado a recibirlo por el remitente), no est? autorizado a copiar, > reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje > por error, por favor, notif?quenoslo inmediatamente y b?rrelo de su sistema. > > > ------------------------------ > > Message: 5 > Date: Wed, 24 Oct 2012 10:11:18 -0700 (PDT) > From: Estel Porras <orlib(a)yahoo.com> > To: Koha community <koha(a)lists.katipo.co.nz> > Subject: [Koha] Email. > Message-ID: > <1351098678.37956.YahooMailNeo(a)web125305.mail.ne1.yahoo.com> > Content-Type: text/plain; charset=iso-8859-1 > > Just wanted to thank all the very helpful folks here. You guys rock! > > ? > ?Have a great day, ~Estel~ > Orland Free Library > 333 Mill St. > Orland CA. 95963 > [530]865-1640 > > ------------------------------ > > Message: 6 > Date: Wed, 24 Oct 2012 22:23:41 +0100 > From: Elaine Bradtke <eb(a)efdss.org> > To: koha <koha(a)lists.katipo.co.nz> > Subject: [Koha] Help needed with report - how to extract subtitle and > edition? > Message-ID: > <CAPdfUux1_GHutDqzKJrr-F+3DPU0fwCH8LYrfKiGmwtbEM5DHw(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > I'm trying to catch duplicate items in data before I upload it (ISBN won't > help in this case). In order to do that I've written a report to list the > books currently in Koha, and will compare them with my external files. > However, if I can't include the subtitle (MARC 245 b) I will get too many > false positives (we have lots of things with the same title, but different > subtitles) > It would also help if I could also have the 250 a (edition) > > > This is what I have: > SELECT > > biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit > ems.place,biblioitems.publishercode,biblioitems.isbn > FROM items > LEFT JOIN biblioitems on > (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) > WHERE items.itype='BK' AND items.holdingbranch='VWML' > ORDER BY biblio.author asc > > > This works fine, but doesn't include the 245 b or the 250 a Can anyone > help? > -- > Elaine Bradtke > Data Wrangler > VWML > English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp > House, 2 Regent's Park Road, London NW1 7AY > Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and > Song Society in London, England. If you wish to phone me personally, send an > e-mail first. I work off site) > -------------------------------------------------------------------------- > Registered Company No. 297142 > Charity Registered in England and Wales No. 305999 > --------------------------------------------------------------------------- > "Writing about music is like dancing about architecture" > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) > > > ------------------------------ > > Message: 7 > Date: Wed, 24 Oct 2012 23:51:10 +0200 > From: mh_zalabany(a)hotmail.com <mh_zalabany(a)hotmail.com> > To: eb(a)efdss.org,"koha" <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Help needed with report - how to extract subtitle > and edition? > Message-ID: <BLU0-SMTP34294835DD8881E4738D9DE97780(a)phx.gbl> > Content-Type: text/plain; charset="utf-8" > > I think in this case you need to make the report using the xml field in > biblio items table because the rest of sub fields you will find there > > Sent from my HTC > > ----- Reply message ----- > From: "Elaine Bradtke" <eb(a)efdss.org> > To: "koha" <koha(a)lists.katipo.co.nz> > Subject: [Koha] Help needed with report - how to extract subtitle and > edition? > Date: Wed, Oct 24, 2012 11:23 pm > > > I'm trying to catch duplicate items in data before I upload it (ISBN won't > help in this case). In order to do that I've written a report to list the > books currently in Koha, and will compare them with my external files. > However, if I can't include the subtitle (MARC 245 b) I will get too many > false positives (we have lots of things with the same title, but different > subtitles) > It would also help if I could also have the 250 a (edition) > > > This is what I have: > SELECT > > biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit > ems.place,biblioitems.publishercode,biblioitems.isbn > FROM items > LEFT JOIN biblioitems on > (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) > WHERE items.itype='BK' AND items.holdingbranch='VWML' > ORDER BY biblio.author asc > > > This works fine, but doesn't include the 245 b or the 250 a Can anyone > help? > -- > Elaine Bradtke > Data Wrangler > VWML > English Folk Dance and Song Society | http://www.efdss.org > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY > Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and > Song Society in London, England. If you wish to phone me personally, send > an e-mail first. I work off site) > -------------------------------------------------------------------------- > Registered Company No. 297142 > Charity Registered in England and Wales No. 305999 > --------------------------------------------------------------------------- > "Writing about music is like dancing about architecture" > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 84, Issue 45 > ************************************ > > > > ------------------------------ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 84, Issue 46 > ************************************ > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 84, Issue 48 ************************************

1 0

Re: [Koha] Improving the advanced search form
by Mason James 25 Oct '12

25 Oct '12

On 2012-10-25, at 5:27 PM, Sunil Kumar wrote: > Dear All, > > I agree with the same, I always had problem in advance search especially for > the barcode based search. > > Even if I select the barcode as search option and enter the specific barcode > number, Koha opac always show all the titles wherever that specific number > is entered. But other that the barcode number. hmm, i just tested this on Koha 3.8.5 it works fine for me... ps: edit your email, before replying to digest messages > > Is there any solution for the same? > > Thanks and Regards > > R Sunil Kumar > Library Technologist > > > > > -----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: 25 October 2012 09:53 > To: koha(a)lists.katipo.co.nz > Subject: Koha Digest, Vol 84, Issue 46 > > 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. Improving the advanced search form (Srikanth Dhondi) > 2. Re: Improving the advanced search form (Chris Cormack) > 3. Re: Improving the advanced search form (Gay Richards) > 4. Re: Data Migration (Dennis Njuguna) (Sunil Kumar) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 25 Oct 2012 14:55:31 +1300 > From: Srikanth Dhondi <srikanth(a)catalyst.net.nz> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Improving the advanced search form > Message-ID: <50889C13.9080505(a)catalyst.net.nz> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hi there, > > I am currently working on improving accessibility of koha opac site with our > accessibility expert. > One of the things we noticed is that the advanced search option is not only > confusing for blind users but also even for normal users. > > I have noticed the following issues with it: > > 1) By default the Fewer Options option is selected, which is not obvious to > the normal users until they click on More Options. > > 2) The layout could be a lot better, in particular the Fewer Options search > form is quite abstract in what it does. > > For example, the default boolean operator is AND which is not obvious to > even normal user. > > In my opinion, layout similar to the one http://kea.massey.ac.nz/search/X, > is better. > > Looking forward to your comments/feedback. > > Srikanth > > > ------------------------------ > > Message: 2 > Date: Thu, 25 Oct 2012 15:03:21 +1300 > From: Chris Cormack <chris(a)bigballofwax.co.nz> > To: Srikanth Dhondi <srikanth(a)catalyst.net.nz> > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Improving the advanced search form > Message-ID: > <CA+95qVR9P0U4Wynn2p0PWP3Wb37J+7SSiMu1xjvZs1kbq=9=nw(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > On 25 October 2012 14:55, Srikanth Dhondi <srikanth(a)catalyst.net.nz> wrote: >> Hi there, >> >> I am currently working on improving accessibility of koha opac site >> with our accessibility expert. >> One of the things we noticed is that the advanced search option is not >> only confusing for blind users but also even for normal users. >> >> I have noticed the following issues with it: >> >> 1) By default the Fewer Options option is selected, which is not >> obvious to the normal users until they click on More Options. >> >> 2) The layout could be a lot better, in particular the Fewer Options >> search form is quite abstract in what it does. >> >> For example, the default boolean operator is AND which is not obvious >> to even normal user. >> >> In my opinion, layout similar to the one >> http://kea.massey.ac.nz/search/X, is better. >> > I'm going to disagree and say that site is horrid :) > > Maybe others will have different opinions though. > > Chris > > > ------------------------------ > > Message: 3 > Date: Thu, 25 Oct 2012 02:45:24 +0000 > From: Gay Richards <g.richards(a)auckland.ac.nz> > To: 'Chris Cormack' <chris(a)bigballofwax.co.nz>, Srikanth Dhondi > <srikanth(a)catalyst.net.nz> > Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Improving the advanced search form > Message-ID: > > <AB44DEB8CF4F784F90EBCDBBD9B817376D7E2714(a)uxcn10-5.UoA.auckland.ac.nz> > Content-Type: text/plain; charset="us-ascii" > > Agree advanced search could and should be improved, but don't like example > suggested. > > I generallly like the "look: of the Koha advanced search page. The problem > (apart from any accessibility issues) is that some functions don't work as > one might expect - as outlined below. Also: > > We would like to turn off or limit languages to onees that are actually > available in our catalog. > > The Search for additional content types is really misleading as it relies on > codes from marc field 008 which may or may not have been used. > I'm sure I have other issues with this screen and I would be keen to discuss > any improvements further. We support anything that makes it more accessible > too. Gay > > -----Original Message----- > From: koha-bounces(a)lists.katipo.co.nz > [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Chris Cormack > Sent: Thursday, 25 October 2012 3:03 p.m. > To: Srikanth Dhondi > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Improving the advanced search form > > On 25 October 2012 14:55, Srikanth Dhondi <srikanth(a)catalyst.net.nz> wrote: >> Hi there, >> >> I am currently working on improving accessibility of koha opac site >> with our accessibility expert. >> One of the things we noticed is that the advanced search option is not >> only confusing for blind users but also even for normal users. >> >> I have noticed the following issues with it: >> >> 1) By default the Fewer Options option is selected, which is not >> obvious to the normal users until they click on More Options. >> >> 2) The layout could be a lot better, in particular the Fewer Options >> search form is quite abstract in what it does. >> >> For example, the default boolean operator is AND which is not obvious >> to even normal user. >> >> In my opinion, layout similar to the one >> http://kea.massey.ac.nz/search/X, is better. >> > I'm going to disagree and say that site is horrid :) > > Maybe others will have different opinions though. > > Chris > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > Message: 4 > Date: Thu, 25 Oct 2012 09:52:23 +0530 > From: "Sunil Kumar" <sunil.kumar(a)ecoleglobal.com> > To: <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Data Migration (Dennis Njuguna) > Message-ID: <000301cdb268$57b958c0$072c0a40$@kumar@ecoleglobal.com> > Content-Type: text/plain; charset="us-ascii" > > Dear Dennis, > > I believe you are missing MARC tag 952 series, 952 is the local tags which > contain all the information about the holding. For example. > > 952$8$9$a$b$c$g$h$p$y > $8 is for collection code > $9 is for biblio number > $a is for permanent location > $b is for current location > $c is for shelf location > $g is for purchase price (you can include the vendor name, location and > invoice details also here) $h is for volume details of the resources mainly > it is used for the journal/magazine/periodicals $p is for the barcode $y is > for the item type > > Once you have all the required information in 952 series you can convert the > file into marc format and upload the same to koha, as the standard process. > > Thanks and Regards > > R Sunil Kumar > Library Technologist > > > > -----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: 25 October 2012 03:21 > To: koha(a)lists.katipo.co.nz > Subject: Koha Digest, Vol 84, Issue 45 > > 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: Data Migration (Dennis Njuguna) > 2. Re: Data Migration (Mohamed zalabany) > 3. Problems upgrading to 3.8 (Ramon Andi?ach) > 4. Re: Problems upgrading to 3.8 (Hugo Agud) > 5. Email. (Estel Porras) > 6. Help needed with report - how to extract subtitle and > edition? (Elaine Bradtke) > 7. Re: Help needed with report - how to extract subtitle and > edition? (mh_zalabany(a)hotmail.com) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 24 Oct 2012 12:17:39 +0300 > From: Dennis Njuguna <cknjuguna(a)gmail.com> > To: Mohamed zalabany <mh_zalabany(a)hotmail.com> > Cc: koha list <koha(a)lists.katipo.co.nz>, "manny_tamayao(a)sil.org" > <manny_tamayao(a)sil.org> > Subject: Re: [Koha] Data Migration > Message-ID: > <CAH0M1x-AbcrEvvzfvOL9oJ4nE7NMD0o4-UytqTUa0LfGxyOyAA(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > it is marc compliant, but when I take it to marcedit i view the file but I > cannot see/view the barcode, if I import the marc into koha I can only > import the biblios records, no holdings. > > > > On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany > <mh_zalabany(a)hotmail.com>wrote: > >> 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 Zalabaitny* >> ** >> *Integrated library systems consultant* >> >> Zalabany Knowledge Systems Team? >> For Libraries and Information systems Development and support >> mh_zalabany(a)hotmail.com >> Mobile: 0111291444 >> >> ** >> >> >> ------------------------------ >> Date: Tue, 23 Oct 2012 17:08:09 +0300 >> Subject: Re: [Koha] Data Migration >> From: cknjuguna(a)gmail.com >> To: mh_zalabany(a)hotmail.com >> CC: manny_tamayao(a)sil.org; koha(a)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_zalabany(a)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_zalabany(a)hotmail.com >> Mobile: 202-0111291444 >> >> >> >>> From: manny_tamayao(a)sil.org >>> To: koha(a)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(a)lists.katipo.co.nz >>> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> _______________________________________________ >> Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> >> >> -- >> >> Dennis K. Njuguna >> >> > > > -- > > Dennis K. Njuguna > > > ------------------------------ > > Message: 2 > Date: Wed, 24 Oct 2012 09:38:15 +0000 > From: Mohamed zalabany <mh_zalabany(a)hotmail.com> > To: <cknjuguna(a)gmail.com> > Cc: koha list <koha(a)lists.katipo.co.nz>, "manny_tamayao(a)sil.org" > <manny_tamayao(a)sil.org> > Subject: Re: [Koha] Data Migration > Message-ID: <BLU165-W49D11BF288626BB715E85597780(a)phx.gbl> > Content-Type: text/plain; charset="iso-8859-1" > > > > I think there is option to export item data with MARC record > > > Mohamed El ZalabanyIntegrated library systems consultant > > Zalabany Knowledge Systems Team? > For Libraries and Information systems Development and support > mh_zalabany(a)hotmail.com > Mobile: 0111291444 > > > > Date: Wed, 24 Oct 2012 12:17:39 +0300 > Subject: Re: [Koha] Data Migration > From: cknjuguna(a)gmail.com > To: mh_zalabany(a)hotmail.com > CC: manny_tamayao(a)sil.org; koha(a)lists.katipo.co.nz > > > it is marc compliant, but when I take it to marcedit i view the file but I > cannot see/view the barcode, if I import the marc into koha I can only > import the biblios records, no holdings. > > > > > On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany <mh_zalabany(a)hotmail.com> > wrote: > > > > > > 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 Zalabaitny > Integrated library systems consultant > > Zalabany Knowledge Systems Team? > For Libraries and Information systems Development and support > > mh_zalabany(a)hotmail.com > Mobile: 0111291444 > > > > > Date: Tue, 23 Oct 2012 17:08:09 +0300 > Subject: Re: [Koha] Data Migration > From: cknjuguna(a)gmail.com > To: mh_zalabany(a)hotmail.com > > CC: manny_tamayao(a)sil.org; koha(a)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_zalabany(a)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_zalabany(a)hotmail.com > > Mobile: 202-0111291444 > > > > > > > >> From: manny_tamayao(a)sil.org > >> To: koha(a)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(a)lists.katipo.co.nz > >> http://lists.katipo.co.nz/mailman/listinfo/koha > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > -- > > Dennis K. Njuguna > > > > > -- > > Dennis K. Njuguna > > > > ------------------------------ > > Message: 3 > Date: Wed, 24 Oct 2012 23:46:00 +0800 > From: Ramon Andi?ach <custard(a)westnet.com.au> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Problems upgrading to 3.8 > Message-ID: <96D8A573-0DC3-478B-BA5C-CBD5FD9974A5(a)westnet.com.au> > Content-Type: text/plain; charset=us-ascii > > Hi, > > This is going sound pathetic, and stupid, but I'm in need of some guidance. > It has been quite some time since I've tried to use koha. > > I've been upgrading my koha from 3.00 towards 3.8 via the tarball method. > > I was attempting to be good, and going in smallish steps so 3.00 to 3.02 to > 3.04 to 3.06 and then to 3.8. > > In between each upgrade I was trying a few searches to make sure that the > books end of the db was intact and then backing up the DB. > > After the 3.06 step it seemed to be working. > > But, after the 3.8 step suddenly most of the books seem to have vanished. > > I'd put it down to noticing in the upgrade notes some extra steps that I > didn't see in the 3.6 or 3.4 notes (the ones about removing the duplicated > item details). So I dropped the DB and reloaded the backup from the 3.6 step > and tried without these steps. > > I've also now tried the original backup too, without success. > > I'm not sure at this point if it's the items that have vanished or the > records too. Yes, I have run rebuild_zebra -b -r as the koha user (several > times no luck). > > So I suppose I'm looking for guidance on > a) working out what is going on. > b) how to get normality back again. > > -ramon. > > ------------------------------ > > Message: 4 > Date: Wed, 24 Oct 2012 18:01:53 +0200 > From: Hugo Agud <hagud(a)orex.es> > To: Ramon Andi?ach <custard(a)westnet.com.au> > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Problems upgrading to 3.8 > Message-ID: > <CADT_QRTsaDrrye_Ux-To_JkjQZk=eT3QN_b1UEoEPSg1N_k64Q(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi Ramon > > Do not worry it happens to a lot of people ... take a look on this > > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8665 > > Kindest Regards > > 2012/10/24 Ramon Andi?ach <custard(a)westnet.com.au> > >> Hi, >> >> This is going sound pathetic, and stupid, but I'm in need of some >> guidance. It has been quite some time since I've tried to use koha. >> >> I've been upgrading my koha from 3.00 towards 3.8 via the tarball method. >> >> I was attempting to be good, and going in smallish steps so 3.00 to >> 3.02 to 3.04 to 3.06 and then to 3.8. >> >> In between each upgrade I was trying a few searches to make sure that >> the books end of the db was intact and then backing up the DB. >> >> After the 3.06 step it seemed to be working. >> >> But, after the 3.8 step suddenly most of the books seem to have vanished. >> >> I'd put it down to noticing in the upgrade notes some extra steps that >> I didn't see in the 3.6 or 3.4 notes (the ones about removing the >> duplicated item details). So I dropped the DB and reloaded the backup >> from the 3.6 step and tried without these steps. >> >> I've also now tried the original backup too, without success. >> >> I'm not sure at this point if it's the items that have vanished or the >> records too. Yes, I have run rebuild_zebra -b -r as the koha user >> (several times no luck). >> >> So I suppose I'm looking for guidance on >> a) working out what is going on. >> b) how to get normality back again. >> >> -ramon. >> _______________________________________________ >> Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> > > > > -- > > *Hugo Agud - Orex Digital * > > *www.orex.es* > > * > * > > Director > > Avenida Sarri? 29 ? 08029 Barcelona <http://twitter.com/OrexDigital> > :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539 > 33 30 > hagud(a)orex.es ? http://www.orex.es/ > > > > No imprima este mensaje a no ser que sea necesario. Una tonelada de papel > implica la tala de 15 ?rboles y el consumo de 250.000 litros de agua. > > > > Aviso de confidencialidad > Este mensaje contiene informaci?n que puede ser CONFIDENCIAL y/o de USO > RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni est? > autorizado a recibirlo por el remitente), no est? autorizado a copiar, > reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje > por error, por favor, notif?quenoslo inmediatamente y b?rrelo de su sistema. > > > ------------------------------ > > Message: 5 > Date: Wed, 24 Oct 2012 10:11:18 -0700 (PDT) > From: Estel Porras <orlib(a)yahoo.com> > To: Koha community <koha(a)lists.katipo.co.nz> > Subject: [Koha] Email. > Message-ID: > <1351098678.37956.YahooMailNeo(a)web125305.mail.ne1.yahoo.com> > Content-Type: text/plain; charset=iso-8859-1 > > Just wanted to thank all the very helpful folks here. You guys rock! > > ? > ?Have a great day, ~Estel~ > Orland Free Library > 333 Mill St. > Orland CA. 95963 > [530]865-1640 > > ------------------------------ > > Message: 6 > Date: Wed, 24 Oct 2012 22:23:41 +0100 > From: Elaine Bradtke <eb(a)efdss.org> > To: koha <koha(a)lists.katipo.co.nz> > Subject: [Koha] Help needed with report - how to extract subtitle and > edition? > Message-ID: > <CAPdfUux1_GHutDqzKJrr-F+3DPU0fwCH8LYrfKiGmwtbEM5DHw(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > I'm trying to catch duplicate items in data before I upload it (ISBN won't > help in this case). In order to do that I've written a report to list the > books currently in Koha, and will compare them with my external files. > However, if I can't include the subtitle (MARC 245 b) I will get too many > false positives (we have lots of things with the same title, but different > subtitles) > It would also help if I could also have the 250 a (edition) > > > This is what I have: > SELECT > > biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit > ems.place,biblioitems.publishercode,biblioitems.isbn > FROM items > LEFT JOIN biblioitems on > (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) > WHERE items.itype='BK' AND items.holdingbranch='VWML' > ORDER BY biblio.author asc > > > This works fine, but doesn't include the 245 b or the 250 a Can anyone > help? > -- > Elaine Bradtke > Data Wrangler > VWML > English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp > House, 2 Regent's Park Road, London NW1 7AY > Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and > Song Society in London, England. If you wish to phone me personally, send an > e-mail first. I work off site) > -------------------------------------------------------------------------- > Registered Company No. 297142 > Charity Registered in England and Wales No. 305999 > --------------------------------------------------------------------------- > "Writing about music is like dancing about architecture" > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) > > > ------------------------------ > > Message: 7 > Date: Wed, 24 Oct 2012 23:51:10 +0200 > From: mh_zalabany(a)hotmail.com <mh_zalabany(a)hotmail.com> > To: eb(a)efdss.org,"koha" <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Help needed with report - how to extract subtitle > and edition? > Message-ID: <BLU0-SMTP34294835DD8881E4738D9DE97780(a)phx.gbl> > Content-Type: text/plain; charset="utf-8" > > I think in this case you need to make the report using the xml field in > biblio items table because the rest of sub fields you will find there > > Sent from my HTC > > ----- Reply message ----- > From: "Elaine Bradtke" <eb(a)efdss.org> > To: "koha" <koha(a)lists.katipo.co.nz> > Subject: [Koha] Help needed with report - how to extract subtitle and > edition? > Date: Wed, Oct 24, 2012 11:23 pm > > > I'm trying to catch duplicate items in data before I upload it (ISBN won't > help in this case). In order to do that I've written a report to list the > books currently in Koha, and will compare them with my external files. > However, if I can't include the subtitle (MARC 245 b) I will get too many > false positives (we have lots of things with the same title, but different > subtitles) > It would also help if I could also have the 250 a (edition) > > > This is what I have: > SELECT > > biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit > ems.place,biblioitems.publishercode,biblioitems.isbn > FROM items > LEFT JOIN biblioitems on > (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) > WHERE items.itype='BK' AND items.holdingbranch='VWML' > ORDER BY biblio.author asc > > > This works fine, but doesn't include the 245 b or the 250 a Can anyone > help? > -- > Elaine Bradtke > Data Wrangler > VWML > English Folk Dance and Song Society | http://www.efdss.org > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY > Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and > Song Society in London, England. If you wish to phone me personally, send > an e-mail first. I work off site) > -------------------------------------------------------------------------- > Registered Company No. 297142 > Charity Registered in England and Wales No. 305999 > --------------------------------------------------------------------------- > "Writing about music is like dancing about architecture" > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 84, Issue 45 > ************************************ > > > > ------------------------------ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 84, Issue 46 > ************************************ > > _______________________________________________ > 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] Data Migration (Dennis Njuguna)
by Dennis Njuguna 25 Oct '12

25 Oct '12

Thank you Sunil for that info, I have found the current one is holding info at tag 852 I have edited it using MARCEdit 8.5 and when I import I see there are items imported though when I go to the book itself to view it tells me that "no physical items for this record" what could I be doing wrong? On Thu, Oct 25, 2012 at 7:22 AM, Sunil Kumar <sunil.kumar(a)ecoleglobal.com>wrote: > Dear Dennis, > > I believe you are missing MARC tag 952 series, 952 is the local tags which > contain all the information about the holding. For example. > > 952$8$9$a$b$c$g$h$p$y > $8 is for collection code > $9 is for biblio number > $a is for permanent location > $b is for current location > $c is for shelf location > $g is for purchase price (you can include the vendor name, location and > invoice details also here) > $h is for volume details of the resources mainly it is used for the > journal/magazine/periodicals > $p is for the barcode > $y is for the item type > > Once you have all the required information in 952 series you can convert > the > file into marc format and upload the same to koha, as the standard process. > > Thanks and Regards > > R Sunil Kumar > Library Technologist > > > > -----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: 25 October 2012 03:21 > To: koha(a)lists.katipo.co.nz > Subject: Koha Digest, Vol 84, Issue 45 > > 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: Data Migration (Dennis Njuguna) > 2. Re: Data Migration (Mohamed zalabany) > 3. Problems upgrading to 3.8 (Ramon Andi?ach) > 4. Re: Problems upgrading to 3.8 (Hugo Agud) > 5. Email. (Estel Porras) > 6. Help needed with report - how to extract subtitle and > edition? (Elaine Bradtke) > 7. Re: Help needed with report - how to extract subtitle and > edition? (mh_zalabany(a)hotmail.com) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 24 Oct 2012 12:17:39 +0300 > From: Dennis Njuguna <cknjuguna(a)gmail.com> > To: Mohamed zalabany <mh_zalabany(a)hotmail.com> > Cc: koha list <koha(a)lists.katipo.co.nz>, "manny_tamayao(a)sil.org" > <manny_tamayao(a)sil.org> > Subject: Re: [Koha] Data Migration > Message-ID: > < > CAH0M1x-AbcrEvvzfvOL9oJ4nE7NMD0o4-UytqTUa0LfGxyOyAA(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > it is marc compliant, but when I take it to marcedit i view the file but I > cannot see/view the barcode, if I import the marc into koha I can only > import the biblios records, no holdings. > > > > On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany > <mh_zalabany(a)hotmail.com>wrote: > > > 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 Zalabaitny* > > ** > > *Integrated library systems consultant* > > > > Zalabany Knowledge Systems Team? > > For Libraries and Information systems Development and support > > mh_zalabany(a)hotmail.com > > Mobile: 0111291444 > > > > ** > > > > > > ------------------------------ > > Date: Tue, 23 Oct 2012 17:08:09 +0300 > > Subject: Re: [Koha] Data Migration > > From: cknjuguna(a)gmail.com > > To: mh_zalabany(a)hotmail.com > > CC: manny_tamayao(a)sil.org; koha(a)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_zalabany(a)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_zalabany(a)hotmail.com > > Mobile: 202-0111291444 > > > > > > > > > From: manny_tamayao(a)sil.org > > > To: koha(a)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(a)lists.katipo.co.nz > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > _______________________________________________ > > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > > > -- > > > > Dennis K. Njuguna > > > > > > > -- > > Dennis K. Njuguna > > > ------------------------------ > > Message: 2 > Date: Wed, 24 Oct 2012 09:38:15 +0000 > From: Mohamed zalabany <mh_zalabany(a)hotmail.com> > To: <cknjuguna(a)gmail.com> > Cc: koha list <koha(a)lists.katipo.co.nz>, "manny_tamayao(a)sil.org" > <manny_tamayao(a)sil.org> > Subject: Re: [Koha] Data Migration > Message-ID: <BLU165-W49D11BF288626BB715E85597780(a)phx.gbl> > Content-Type: text/plain; charset="iso-8859-1" > > > > I think there is option to export item data with MARC record > > > Mohamed El ZalabanyIntegrated library systems consultant > > Zalabany Knowledge Systems Team? > For Libraries and Information systems Development and support > mh_zalabany(a)hotmail.com > Mobile: 0111291444 > > > > Date: Wed, 24 Oct 2012 12:17:39 +0300 > Subject: Re: [Koha] Data Migration > From: cknjuguna(a)gmail.com > To: mh_zalabany(a)hotmail.com > CC: manny_tamayao(a)sil.org; koha(a)lists.katipo.co.nz > > > it is marc compliant, but when I take it to marcedit i view the file but I > cannot see/view the barcode, if I import the marc into koha I can only > import the biblios records, no holdings. > > > > > On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany <mh_zalabany(a)hotmail.com > > > wrote: > > > > > > 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 Zalabaitny > Integrated library systems consultant > > Zalabany Knowledge Systems Team? > For Libraries and Information systems Development and support > > mh_zalabany(a)hotmail.com > Mobile: 0111291444 > > > > > Date: Tue, 23 Oct 2012 17:08:09 +0300 > Subject: Re: [Koha] Data Migration > From: cknjuguna(a)gmail.com > To: mh_zalabany(a)hotmail.com > > CC: manny_tamayao(a)sil.org; koha(a)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_zalabany(a)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_zalabany(a)hotmail.com > > Mobile: 202-0111291444 > > > > > > > > > From: manny_tamayao(a)sil.org > > > To: koha(a)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(a)lists.katipo.co.nz > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > -- > > Dennis K. Njuguna > > > > > -- > > Dennis K. Njuguna > > > > ------------------------------ > > Message: 3 > Date: Wed, 24 Oct 2012 23:46:00 +0800 > From: Ramon Andi?ach <custard(a)westnet.com.au> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Problems upgrading to 3.8 > Message-ID: <96D8A573-0DC3-478B-BA5C-CBD5FD9974A5(a)westnet.com.au> > Content-Type: text/plain; charset=us-ascii > > Hi, > > This is going sound pathetic, and stupid, but I'm in need of some guidance. > It has been quite some time since I've tried to use koha. > > I've been upgrading my koha from 3.00 towards 3.8 via the tarball method. > > I was attempting to be good, and going in smallish steps so 3.00 to 3.02 to > 3.04 to 3.06 and then to 3.8. > > In between each upgrade I was trying a few searches to make sure that the > books end of the db was intact and then backing up the DB. > > After the 3.06 step it seemed to be working. > > But, after the 3.8 step suddenly most of the books seem to have vanished. > > I'd put it down to noticing in the upgrade notes some extra steps that I > didn't see in the 3.6 or 3.4 notes (the ones about removing the duplicated > item details). So I dropped the DB and reloaded the backup from the 3.6 > step > and tried without these steps. > > I've also now tried the original backup too, without success. > > I'm not sure at this point if it's the items that have vanished or the > records too. Yes, I have run rebuild_zebra -b -r as the koha user (several > times no luck). > > So I suppose I'm looking for guidance on > a) working out what is going on. > b) how to get normality back again. > > -ramon. > > ------------------------------ > > Message: 4 > Date: Wed, 24 Oct 2012 18:01:53 +0200 > From: Hugo Agud <hagud(a)orex.es> > To: Ramon Andi?ach <custard(a)westnet.com.au> > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Problems upgrading to 3.8 > Message-ID: > <CADT_QRTsaDrrye_Ux-To_JkjQZk= > eT3QN_b1UEoEPSg1N_k64Q(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi Ramon > > Do not worry it happens to a lot of people ... take a look on this > > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8665 > > Kindest Regards > > 2012/10/24 Ramon Andi?ach <custard(a)westnet.com.au> > > > Hi, > > > > This is going sound pathetic, and stupid, but I'm in need of some > > guidance. It has been quite some time since I've tried to use koha. > > > > I've been upgrading my koha from 3.00 towards 3.8 via the tarball method. > > > > I was attempting to be good, and going in smallish steps so 3.00 to > > 3.02 to 3.04 to 3.06 and then to 3.8. > > > > In between each upgrade I was trying a few searches to make sure that > > the books end of the db was intact and then backing up the DB. > > > > After the 3.06 step it seemed to be working. > > > > But, after the 3.8 step suddenly most of the books seem to have vanished. > > > > I'd put it down to noticing in the upgrade notes some extra steps that > > I didn't see in the 3.6 or 3.4 notes (the ones about removing the > > duplicated item details). So I dropped the DB and reloaded the backup > > from the 3.6 step and tried without these steps. > > > > I've also now tried the original backup too, without success. > > > > I'm not sure at this point if it's the items that have vanished or the > > records too. Yes, I have run rebuild_zebra -b -r as the koha user > > (several times no luck). > > > > So I suppose I'm looking for guidance on > > a) working out what is going on. > > b) how to get normality back again. > > > > -ramon. > > _______________________________________________ > > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > -- > > *Hugo Agud - Orex Digital * > > *www.orex.es* > > * > * > > Director > > Avenida Sarri? 29 ? 08029 Barcelona <http://twitter.com/OrexDigital> > :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539 > 33 30 > hagud(a)orex.es ? http://www.orex.es/ > > > > No imprima este mensaje a no ser que sea necesario. Una tonelada de papel > implica la tala de 15 ?rboles y el consumo de 250.000 litros de agua. > > > > Aviso de confidencialidad > Este mensaje contiene informaci?n que puede ser CONFIDENCIAL y/o de USO > RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni > est? autorizado a recibirlo por el remitente), no est? autorizado a copiar, > reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje > por error, por favor, notif?quenoslo inmediatamente y b?rrelo de su > sistema. > > > ------------------------------ > > Message: 5 > Date: Wed, 24 Oct 2012 10:11:18 -0700 (PDT) > From: Estel Porras <orlib(a)yahoo.com> > To: Koha community <koha(a)lists.katipo.co.nz> > Subject: [Koha] Email. > Message-ID: > <1351098678.37956.YahooMailNeo(a)web125305.mail.ne1.yahoo.com> > Content-Type: text/plain; charset=iso-8859-1 > > Just wanted to thank all the very helpful folks here. You guys rock! > > ? > ?Have a great day, ~Estel~ > Orland Free Library > 333 Mill St. > Orland CA. 95963 > [530]865-1640 > > ------------------------------ > > Message: 6 > Date: Wed, 24 Oct 2012 22:23:41 +0100 > From: Elaine Bradtke <eb(a)efdss.org> > To: koha <koha(a)lists.katipo.co.nz> > Subject: [Koha] Help needed with report - how to extract subtitle and > edition? > Message-ID: > < > CAPdfUux1_GHutDqzKJrr-F+3DPU0fwCH8LYrfKiGmwtbEM5DHw(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > I'm trying to catch duplicate items in data before I upload it (ISBN won't > help in this case). In order to do that I've written a report to list the > books currently in Koha, and will compare them with my external files. > However, if I can't include the subtitle (MARC 245 b) I will get too many > false positives (we have lots of things with the same title, but different > subtitles) > It would also help if I could also have the 250 a (edition) > > > This is what I have: > SELECT > > > biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit > ems.place,biblioitems.publishercode,biblioitems.isbn > FROM items > LEFT JOIN biblioitems on > (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) > WHERE items.itype='BK' AND items.holdingbranch='VWML' > ORDER BY biblio.author asc > > > This works fine, but doesn't include the 245 b or the 250 a Can anyone > help? > -- > Elaine Bradtke > Data Wrangler > VWML > English Folk Dance and Song Society | http://www.efdss.org > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY > Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and > Song Society in London, England. If you wish to phone me personally, send > an e-mail first. I work off site) > -------------------------------------------------------------------------- > Registered Company No. 297142 > Charity Registered in England and Wales No. 305999 > --------------------------------------------------------------------------- > "Writing about music is like dancing about architecture" > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) > > > ------------------------------ > > Message: 7 > Date: Wed, 24 Oct 2012 23:51:10 +0200 > From: mh_zalabany(a)hotmail.com <mh_zalabany(a)hotmail.com> > To: eb(a)efdss.org,"koha" <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Help needed with report - how to extract subtitle > and edition? > Message-ID: <BLU0-SMTP34294835DD8881E4738D9DE97780(a)phx.gbl> > Content-Type: text/plain; charset="utf-8" > > I think in this case you need to make the report using the xml field in > biblio items table because the rest of sub fields you will find there > > Sent from my HTC > > ----- Reply message ----- > From: "Elaine Bradtke" <eb(a)efdss.org> > To: "koha" <koha(a)lists.katipo.co.nz> > Subject: [Koha] Help needed with report - how to extract subtitle and > edition? > Date: Wed, Oct 24, 2012 11:23 pm > > > I'm trying to catch duplicate items in data before I upload it (ISBN won't > help in this case). In order to do that I've written a report to list the > books currently in Koha, and will compare them with my external files. > However, if I can't include the subtitle (MARC 245 b) I will get too many > false positives (we have lots of things with the same title, but different > subtitles) > It would also help if I could also have the 250 a (edition) > > > This is what I have: > SELECT > > > biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit > ems.place,biblioitems.publishercode,biblioitems.isbn > FROM items > LEFT JOIN biblioitems on > (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) > WHERE items.itype='BK' AND items.holdingbranch='VWML' > ORDER BY biblio.author asc > > > This works fine, but doesn't include the 245 b or the 250 a Can anyone > help? > -- > Elaine Bradtke > Data Wrangler > VWML > English Folk Dance and Song Society | http://www.efdss.org > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY > Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and > Song Society in London, England. If you wish to phone me personally, send > an e-mail first. I work off site) > -------------------------------------------------------------------------- > Registered Company No. 297142 > Charity Registered in England and Wales No. 305999 > --------------------------------------------------------------------------- > "Writing about music is like dancing about architecture" > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 84, Issue 45 > ************************************ > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Dennis K. Njuguna

1 0

Re: [Koha] need help in zebra indexing for Arabic words
by mh_zalabany＠hotmail.com 25 Oct '12

25 Oct '12

Hi karam I think this issue is very important to all users who use Arabic language We need to know what the important modifications in Zebra index And koha files to index the arabic words without suffix and prifex or searsh with root word using zebra I will give you example We need to search for word (al-madrasah) this mean school We have tow parts (al) mean (the)and (madrasah ) and the last caracter (h) may have tow forms( ه ة ) we need when we search for madrasa get madrasah and al-madrasah with all its forms Sent from my HTC ----- Reply message ----- From: "Karam Qubsi" <karamqubsi(a)gmail.com> To: "Koha" <Koha(a)lists.katipo.co.nz>, <Koha-devel(a)lists.koha-community.org> Subject: [Koha] need help in zebra indexing for Arabic words Date: Thu, Oct 25, 2012 11:12 am Hi All I sent this email to the zebra mailing list I wish that koha will support suffix and prefix in the arabic search by default in the future I wish if you have any Idea about the solution for this Best regards Karam. ---------- Forwarded message ---------- From: Karam Qubsi <karamqubsi(a)gmail.com> Date: Thu, Oct 25, 2012 at 4:20 AM Subject: need help in transliterate rule To: zebralist(a)lists.indexdata.dk Hi all , I'm new to zebra , and using it in "koha" ILS in the Arabic language there is some letter come before the words or after them these letters we don't need to index in our index I will give you an example : in English we can say : the car... in Arabic the same is : السيارة if you note that the letter in Red is "the" and it's ignored in English search but in Arabic search we need the zebra to find every record that have " the word " or just "word" الكلمة or كلمة so how to define that to zebra thanks a lot _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Fwd: Koha Database Migration
by Chris Nighswonger 25 Oct '12

25 Oct '12

Yesan, Please send your support requests to the Koha User's list. You will have a much greater chance of getting a response that way. You should be able to do an "in place" upgrade. After taking a backup of your current database, just install the new version of Koha and browse to the staff interface to run the installer. There is also at least one script you will need to run from the command line to remove the items from the bibs. Probably the best way is to move to the packages. I believe there is a way when installing from the packages to import your existing database. Check out koha-create for more on that. Also, I think the packages will run all of the necessary back-end scripts. Someone else will correct me if I'm wrong. Read more here: http://wiki.koha-community.org/wiki/Debian Kind Regards, Chris ---------- Forwarded message ---------- From: Chief Librarian, SAIACS <library(a)saiacs.org> Date: Thu, Oct 25, 2012 at 1:58 AM Subject: Koha Database Migration To: paul.a(a)aandc.org Cc: cnighswonger(a)foundations.edu Dear friends, I would like to know if you have got a solution to migrate my KOHA database 3.6 to 3.8. I know marc records export and import. But I would like to know if we can migrate the database itself. 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 : www.saiacs.org Alternative Email: yesan.sellan(a)saiacs.org or yesans(a)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.

1 0

need help in zebra indexing for Arabic words
by Karam Qubsi 25 Oct '12

25 Oct '12

Hi All I sent this email to the zebra mailing list I wish that koha will support suffix and prefix in the arabic search by default in the future I wish if you have any Idea about the solution for this Best regards Karam. ---------- Forwarded message ---------- From: Karam Qubsi <karamqubsi(a)gmail.com> Date: Thu, Oct 25, 2012 at 4:20 AM Subject: need help in transliterate rule To: zebralist(a)lists.indexdata.dk Hi all , I'm new to zebra , and using it in "koha" ILS in the Arabic language there is some letter come before the words or after them these letters we don't need to index in our index I will give you an example : in English we can say : the car... in Arabic the same is : السيارة if you note that the letter in Red is "the" and it's ignored in English search but in Arabic search we need the zebra to find every record that have " the word " or just "word" الكلمة or كلمة so how to define that to zebra thanks a lot

1 0

Re: [Koha] Improving the advanced search form
by Sunil Kumar 25 Oct '12

25 Oct '12

Dear All, I agree with the same, I always had problem in advance search especially for the barcode based search. Even if I select the barcode as search option and enter the specific barcode number, Koha opac always show all the titles wherever that specific number is entered. But other that the barcode number. Is there any solution for the same? Thanks and Regards R Sunil Kumar Library Technologist -----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: 25 October 2012 09:53 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 84, Issue 46 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. Improving the advanced search form (Srikanth Dhondi) 2. Re: Improving the advanced search form (Chris Cormack) 3. Re: Improving the advanced search form (Gay Richards) 4. Re: Data Migration (Dennis Njuguna) (Sunil Kumar) ---------------------------------------------------------------------- Message: 1 Date: Thu, 25 Oct 2012 14:55:31 +1300 From: Srikanth Dhondi <srikanth(a)catalyst.net.nz> To: koha(a)lists.katipo.co.nz Subject: [Koha] Improving the advanced search form Message-ID: <50889C13.9080505(a)catalyst.net.nz> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hi there, I am currently working on improving accessibility of koha opac site with our accessibility expert. One of the things we noticed is that the advanced search option is not only confusing for blind users but also even for normal users. I have noticed the following issues with it: 1) By default the Fewer Options option is selected, which is not obvious to the normal users until they click on More Options. 2) The layout could be a lot better, in particular the Fewer Options search form is quite abstract in what it does. For example, the default boolean operator is AND which is not obvious to even normal user. In my opinion, layout similar to the one http://kea.massey.ac.nz/search/X, is better. Looking forward to your comments/feedback. Srikanth ------------------------------ Message: 2 Date: Thu, 25 Oct 2012 15:03:21 +1300 From: Chris Cormack <chris(a)bigballofwax.co.nz> To: Srikanth Dhondi <srikanth(a)catalyst.net.nz> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Improving the advanced search form Message-ID: <CA+95qVR9P0U4Wynn2p0PWP3Wb37J+7SSiMu1xjvZs1kbq=9=nw(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 On 25 October 2012 14:55, Srikanth Dhondi <srikanth(a)catalyst.net.nz> wrote: > Hi there, > > I am currently working on improving accessibility of koha opac site > with our accessibility expert. > One of the things we noticed is that the advanced search option is not > only confusing for blind users but also even for normal users. > > I have noticed the following issues with it: > > 1) By default the Fewer Options option is selected, which is not > obvious to the normal users until they click on More Options. > > 2) The layout could be a lot better, in particular the Fewer Options > search form is quite abstract in what it does. > > For example, the default boolean operator is AND which is not obvious > to even normal user. > > In my opinion, layout similar to the one > http://kea.massey.ac.nz/search/X, is better. > I'm going to disagree and say that site is horrid :) Maybe others will have different opinions though. Chris ------------------------------ Message: 3 Date: Thu, 25 Oct 2012 02:45:24 +0000 From: Gay Richards <g.richards(a)auckland.ac.nz> To: 'Chris Cormack' <chris(a)bigballofwax.co.nz>, Srikanth Dhondi <srikanth(a)catalyst.net.nz> Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Improving the advanced search form Message-ID: <AB44DEB8CF4F784F90EBCDBBD9B817376D7E2714(a)uxcn10-5.UoA.auckland.ac.nz> Content-Type: text/plain; charset="us-ascii" Agree advanced search could and should be improved, but don't like example suggested. I generallly like the "look: of the Koha advanced search page. The problem (apart from any accessibility issues) is that some functions don't work as one might expect - as outlined below. Also: We would like to turn off or limit languages to onees that are actually available in our catalog. The Search for additional content types is really misleading as it relies on codes from marc field 008 which may or may not have been used. I'm sure I have other issues with this screen and I would be keen to discuss any improvements further. We support anything that makes it more accessible too. Gay -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Chris Cormack Sent: Thursday, 25 October 2012 3:03 p.m. To: Srikanth Dhondi Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Improving the advanced search form On 25 October 2012 14:55, Srikanth Dhondi <srikanth(a)catalyst.net.nz> wrote: > Hi there, > > I am currently working on improving accessibility of koha opac site > with our accessibility expert. > One of the things we noticed is that the advanced search option is not > only confusing for blind users but also even for normal users. > > I have noticed the following issues with it: > > 1) By default the Fewer Options option is selected, which is not > obvious to the normal users until they click on More Options. > > 2) The layout could be a lot better, in particular the Fewer Options > search form is quite abstract in what it does. > > For example, the default boolean operator is AND which is not obvious > to even normal user. > > In my opinion, layout similar to the one > http://kea.massey.ac.nz/search/X, is better. > I'm going to disagree and say that site is horrid :) Maybe others will have different opinions though. Chris _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 4 Date: Thu, 25 Oct 2012 09:52:23 +0530 From: "Sunil Kumar" <sunil.kumar(a)ecoleglobal.com> To: <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Data Migration (Dennis Njuguna) Message-ID: <000301cdb268$57b958c0$072c0a40$@kumar@ecoleglobal.com> Content-Type: text/plain; charset="us-ascii" Dear Dennis, I believe you are missing MARC tag 952 series, 952 is the local tags which contain all the information about the holding. For example. 952$8$9$a$b$c$g$h$p$y $8 is for collection code $9 is for biblio number $a is for permanent location $b is for current location $c is for shelf location $g is for purchase price (you can include the vendor name, location and invoice details also here) $h is for volume details of the resources mainly it is used for the journal/magazine/periodicals $p is for the barcode $y is for the item type Once you have all the required information in 952 series you can convert the file into marc format and upload the same to koha, as the standard process. Thanks and Regards R Sunil Kumar Library Technologist -----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: 25 October 2012 03:21 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 84, Issue 45 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: Data Migration (Dennis Njuguna) 2. Re: Data Migration (Mohamed zalabany) 3. Problems upgrading to 3.8 (Ramon Andi?ach) 4. Re: Problems upgrading to 3.8 (Hugo Agud) 5. Email. (Estel Porras) 6. Help needed with report - how to extract subtitle and edition? (Elaine Bradtke) 7. Re: Help needed with report - how to extract subtitle and edition? (mh_zalabany(a)hotmail.com) ---------------------------------------------------------------------- Message: 1 Date: Wed, 24 Oct 2012 12:17:39 +0300 From: Dennis Njuguna <cknjuguna(a)gmail.com> To: Mohamed zalabany <mh_zalabany(a)hotmail.com> Cc: koha list <koha(a)lists.katipo.co.nz>, "manny_tamayao(a)sil.org" <manny_tamayao(a)sil.org> Subject: Re: [Koha] Data Migration Message-ID: <CAH0M1x-AbcrEvvzfvOL9oJ4nE7NMD0o4-UytqTUa0LfGxyOyAA(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 it is marc compliant, but when I take it to marcedit i view the file but I cannot see/view the barcode, if I import the marc into koha I can only import the biblios records, no holdings. On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany <mh_zalabany(a)hotmail.com>wrote: > 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 Zalabaitny* > ** > *Integrated library systems consultant* > > Zalabany Knowledge Systems Team? > For Libraries and Information systems Development and support > mh_zalabany(a)hotmail.com > Mobile: 0111291444 > > ** > > > ------------------------------ > Date: Tue, 23 Oct 2012 17:08:09 +0300 > Subject: Re: [Koha] Data Migration > From: cknjuguna(a)gmail.com > To: mh_zalabany(a)hotmail.com > CC: manny_tamayao(a)sil.org; koha(a)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_zalabany(a)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_zalabany(a)hotmail.com > Mobile: 202-0111291444 > > > > > From: manny_tamayao(a)sil.org > > To: koha(a)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(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > -- > > Dennis K. Njuguna > > -- Dennis K. Njuguna ------------------------------ Message: 2 Date: Wed, 24 Oct 2012 09:38:15 +0000 From: Mohamed zalabany <mh_zalabany(a)hotmail.com> To: <cknjuguna(a)gmail.com> Cc: koha list <koha(a)lists.katipo.co.nz>, "manny_tamayao(a)sil.org" <manny_tamayao(a)sil.org> Subject: Re: [Koha] Data Migration Message-ID: <BLU165-W49D11BF288626BB715E85597780(a)phx.gbl> Content-Type: text/plain; charset="iso-8859-1" I think there is option to export item data with MARC record Mohamed El ZalabanyIntegrated library systems consultant Zalabany Knowledge Systems Team? For Libraries and Information systems Development and support mh_zalabany(a)hotmail.com Mobile: 0111291444 Date: Wed, 24 Oct 2012 12:17:39 +0300 Subject: Re: [Koha] Data Migration From: cknjuguna(a)gmail.com To: mh_zalabany(a)hotmail.com CC: manny_tamayao(a)sil.org; koha(a)lists.katipo.co.nz it is marc compliant, but when I take it to marcedit i view the file but I cannot see/view the barcode, if I import the marc into koha I can only import the biblios records, no holdings. On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany <mh_zalabany(a)hotmail.com> wrote: 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 Zalabaitny Integrated library systems consultant Zalabany Knowledge Systems Team? For Libraries and Information systems Development and support mh_zalabany(a)hotmail.com Mobile: 0111291444 Date: Tue, 23 Oct 2012 17:08:09 +0300 Subject: Re: [Koha] Data Migration From: cknjuguna(a)gmail.com To: mh_zalabany(a)hotmail.com CC: manny_tamayao(a)sil.org; koha(a)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_zalabany(a)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_zalabany(a)hotmail.com Mobile: 202-0111291444 > From: manny_tamayao(a)sil.org > To: koha(a)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(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Dennis K. Njuguna -- Dennis K. Njuguna ------------------------------ Message: 3 Date: Wed, 24 Oct 2012 23:46:00 +0800 From: Ramon Andi?ach <custard(a)westnet.com.au> To: koha(a)lists.katipo.co.nz Subject: [Koha] Problems upgrading to 3.8 Message-ID: <96D8A573-0DC3-478B-BA5C-CBD5FD9974A5(a)westnet.com.au> Content-Type: text/plain; charset=us-ascii Hi, This is going sound pathetic, and stupid, but I'm in need of some guidance. It has been quite some time since I've tried to use koha. I've been upgrading my koha from 3.00 towards 3.8 via the tarball method. I was attempting to be good, and going in smallish steps so 3.00 to 3.02 to 3.04 to 3.06 and then to 3.8. In between each upgrade I was trying a few searches to make sure that the books end of the db was intact and then backing up the DB. After the 3.06 step it seemed to be working. But, after the 3.8 step suddenly most of the books seem to have vanished. I'd put it down to noticing in the upgrade notes some extra steps that I didn't see in the 3.6 or 3.4 notes (the ones about removing the duplicated item details). So I dropped the DB and reloaded the backup from the 3.6 step and tried without these steps. I've also now tried the original backup too, without success. I'm not sure at this point if it's the items that have vanished or the records too. Yes, I have run rebuild_zebra -b -r as the koha user (several times no luck). So I suppose I'm looking for guidance on a) working out what is going on. b) how to get normality back again. -ramon. ------------------------------ Message: 4 Date: Wed, 24 Oct 2012 18:01:53 +0200 From: Hugo Agud <hagud(a)orex.es> To: Ramon Andi?ach <custard(a)westnet.com.au> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Problems upgrading to 3.8 Message-ID: <CADT_QRTsaDrrye_Ux-To_JkjQZk=eT3QN_b1UEoEPSg1N_k64Q(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi Ramon Do not worry it happens to a lot of people ... take a look on this http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8665 Kindest Regards 2012/10/24 Ramon Andi?ach <custard(a)westnet.com.au> > Hi, > > This is going sound pathetic, and stupid, but I'm in need of some > guidance. It has been quite some time since I've tried to use koha. > > I've been upgrading my koha from 3.00 towards 3.8 via the tarball method. > > I was attempting to be good, and going in smallish steps so 3.00 to > 3.02 to 3.04 to 3.06 and then to 3.8. > > In between each upgrade I was trying a few searches to make sure that > the books end of the db was intact and then backing up the DB. > > After the 3.06 step it seemed to be working. > > But, after the 3.8 step suddenly most of the books seem to have vanished. > > I'd put it down to noticing in the upgrade notes some extra steps that > I didn't see in the 3.6 or 3.4 notes (the ones about removing the > duplicated item details). So I dropped the DB and reloaded the backup > from the 3.6 step and tried without these steps. > > I've also now tried the original backup too, without success. > > I'm not sure at this point if it's the items that have vanished or the > records too. Yes, I have run rebuild_zebra -b -r as the koha user > (several times no luck). > > So I suppose I'm looking for guidance on > a) working out what is going on. > b) how to get normality back again. > > -ramon. > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- *Hugo Agud - Orex Digital * *www.orex.es* * * Director Avenida Sarri? 29 ? 08029 Barcelona <http://twitter.com/OrexDigital> :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539 33 30 hagud(a)orex.es ? http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 ?rboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene informaci?n que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni est? autorizado a recibirlo por el remitente), no est? autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notif?quenoslo inmediatamente y b?rrelo de su sistema. ------------------------------ Message: 5 Date: Wed, 24 Oct 2012 10:11:18 -0700 (PDT) From: Estel Porras <orlib(a)yahoo.com> To: Koha community <koha(a)lists.katipo.co.nz> Subject: [Koha] Email. Message-ID: <1351098678.37956.YahooMailNeo(a)web125305.mail.ne1.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Just wanted to thank all the very helpful folks here. You guys rock! ? ?Have a great day, ~Estel~ Orland Free Library 333 Mill St. Orland CA. 95963 [530]865-1640 ------------------------------ Message: 6 Date: Wed, 24 Oct 2012 22:23:41 +0100 From: Elaine Bradtke <eb(a)efdss.org> To: koha <koha(a)lists.katipo.co.nz> Subject: [Koha] Help needed with report - how to extract subtitle and edition? Message-ID: <CAPdfUux1_GHutDqzKJrr-F+3DPU0fwCH8LYrfKiGmwtbEM5DHw(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 I'm trying to catch duplicate items in data before I upload it (ISBN won't help in this case). In order to do that I've written a report to list the books currently in Koha, and will compare them with my external files. However, if I can't include the subtitle (MARC 245 b) I will get too many false positives (we have lots of things with the same title, but different subtitles) It would also help if I could also have the 250 a (edition) This is what I have: SELECT biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit ems.place,biblioitems.publishercode,biblioitems.isbn FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype='BK' AND items.holdingbranch='VWML' ORDER BY biblio.author asc This works fine, but doesn't include the 245 b or the 250 a Can anyone help? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ------------------------------ Message: 7 Date: Wed, 24 Oct 2012 23:51:10 +0200 From: mh_zalabany(a)hotmail.com <mh_zalabany(a)hotmail.com> To: eb(a)efdss.org,"koha" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Help needed with report - how to extract subtitle and edition? Message-ID: <BLU0-SMTP34294835DD8881E4738D9DE97780(a)phx.gbl> Content-Type: text/plain; charset="utf-8" I think in this case you need to make the report using the xml field in biblio items table because the rest of sub fields you will find there Sent from my HTC ----- Reply message ----- From: "Elaine Bradtke" <eb(a)efdss.org> To: "koha" <koha(a)lists.katipo.co.nz> Subject: [Koha] Help needed with report - how to extract subtitle and edition? Date: Wed, Oct 24, 2012 11:23 pm I'm trying to catch duplicate items in data before I upload it (ISBN won't help in this case). In order to do that I've written a report to list the books currently in Koha, and will compare them with my external files. However, if I can't include the subtitle (MARC 245 b) I will get too many false positives (we have lots of things with the same title, but different subtitles) It would also help if I could also have the 250 a (edition) This is what I have: SELECT biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit ems.place,biblioitems.publishercode,biblioitems.isbn FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype='BK' AND items.holdingbranch='VWML' ORDER BY biblio.author asc This works fine, but doesn't include the 245 b or the 250 a Can anyone help? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 84, Issue 45 ************************************ ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 84, Issue 46 ************************************

1 0

Re: [Koha] Data Migration (Dennis Njuguna)
by Sunil Kumar 25 Oct '12

25 Oct '12

Dear Dennis, I believe you are missing MARC tag 952 series, 952 is the local tags which contain all the information about the holding. For example. 952$8$9$a$b$c$g$h$p$y $8 is for collection code $9 is for biblio number $a is for permanent location $b is for current location $c is for shelf location $g is for purchase price (you can include the vendor name, location and invoice details also here) $h is for volume details of the resources mainly it is used for the journal/magazine/periodicals $p is for the barcode $y is for the item type Once you have all the required information in 952 series you can convert the file into marc format and upload the same to koha, as the standard process. Thanks and Regards R Sunil Kumar Library Technologist -----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: 25 October 2012 03:21 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 84, Issue 45 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: Data Migration (Dennis Njuguna) 2. Re: Data Migration (Mohamed zalabany) 3. Problems upgrading to 3.8 (Ramon Andi?ach) 4. Re: Problems upgrading to 3.8 (Hugo Agud) 5. Email. (Estel Porras) 6. Help needed with report - how to extract subtitle and edition? (Elaine Bradtke) 7. Re: Help needed with report - how to extract subtitle and edition? (mh_zalabany(a)hotmail.com) ---------------------------------------------------------------------- Message: 1 Date: Wed, 24 Oct 2012 12:17:39 +0300 From: Dennis Njuguna <cknjuguna(a)gmail.com> To: Mohamed zalabany <mh_zalabany(a)hotmail.com> Cc: koha list <koha(a)lists.katipo.co.nz>, "manny_tamayao(a)sil.org" <manny_tamayao(a)sil.org> Subject: Re: [Koha] Data Migration Message-ID: <CAH0M1x-AbcrEvvzfvOL9oJ4nE7NMD0o4-UytqTUa0LfGxyOyAA(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 it is marc compliant, but when I take it to marcedit i view the file but I cannot see/view the barcode, if I import the marc into koha I can only import the biblios records, no holdings. On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany <mh_zalabany(a)hotmail.com>wrote: > 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 Zalabaitny* > ** > *Integrated library systems consultant* > > Zalabany Knowledge Systems Team? > For Libraries and Information systems Development and support > mh_zalabany(a)hotmail.com > Mobile: 0111291444 > > ** > > > ------------------------------ > Date: Tue, 23 Oct 2012 17:08:09 +0300 > Subject: Re: [Koha] Data Migration > From: cknjuguna(a)gmail.com > To: mh_zalabany(a)hotmail.com > CC: manny_tamayao(a)sil.org; koha(a)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_zalabany(a)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_zalabany(a)hotmail.com > Mobile: 202-0111291444 > > > > > From: manny_tamayao(a)sil.org > > To: koha(a)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(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > -- > > Dennis K. Njuguna > > -- Dennis K. Njuguna ------------------------------ Message: 2 Date: Wed, 24 Oct 2012 09:38:15 +0000 From: Mohamed zalabany <mh_zalabany(a)hotmail.com> To: <cknjuguna(a)gmail.com> Cc: koha list <koha(a)lists.katipo.co.nz>, "manny_tamayao(a)sil.org" <manny_tamayao(a)sil.org> Subject: Re: [Koha] Data Migration Message-ID: <BLU165-W49D11BF288626BB715E85597780(a)phx.gbl> Content-Type: text/plain; charset="iso-8859-1" I think there is option to export item data with MARC record Mohamed El ZalabanyIntegrated library systems consultant Zalabany Knowledge Systems Team? For Libraries and Information systems Development and support mh_zalabany(a)hotmail.com Mobile: 0111291444 Date: Wed, 24 Oct 2012 12:17:39 +0300 Subject: Re: [Koha] Data Migration From: cknjuguna(a)gmail.com To: mh_zalabany(a)hotmail.com CC: manny_tamayao(a)sil.org; koha(a)lists.katipo.co.nz it is marc compliant, but when I take it to marcedit i view the file but I cannot see/view the barcode, if I import the marc into koha I can only import the biblios records, no holdings. On Tue, Oct 23, 2012 at 7:02 PM, Mohamed zalabany <mh_zalabany(a)hotmail.com> wrote: 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 Zalabaitny Integrated library systems consultant Zalabany Knowledge Systems Team? For Libraries and Information systems Development and support mh_zalabany(a)hotmail.com Mobile: 0111291444 Date: Tue, 23 Oct 2012 17:08:09 +0300 Subject: Re: [Koha] Data Migration From: cknjuguna(a)gmail.com To: mh_zalabany(a)hotmail.com CC: manny_tamayao(a)sil.org; koha(a)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_zalabany(a)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_zalabany(a)hotmail.com Mobile: 202-0111291444 > From: manny_tamayao(a)sil.org > To: koha(a)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(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Dennis K. Njuguna -- Dennis K. Njuguna ------------------------------ Message: 3 Date: Wed, 24 Oct 2012 23:46:00 +0800 From: Ramon Andi?ach <custard(a)westnet.com.au> To: koha(a)lists.katipo.co.nz Subject: [Koha] Problems upgrading to 3.8 Message-ID: <96D8A573-0DC3-478B-BA5C-CBD5FD9974A5(a)westnet.com.au> Content-Type: text/plain; charset=us-ascii Hi, This is going sound pathetic, and stupid, but I'm in need of some guidance. It has been quite some time since I've tried to use koha. I've been upgrading my koha from 3.00 towards 3.8 via the tarball method. I was attempting to be good, and going in smallish steps so 3.00 to 3.02 to 3.04 to 3.06 and then to 3.8. In between each upgrade I was trying a few searches to make sure that the books end of the db was intact and then backing up the DB. After the 3.06 step it seemed to be working. But, after the 3.8 step suddenly most of the books seem to have vanished. I'd put it down to noticing in the upgrade notes some extra steps that I didn't see in the 3.6 or 3.4 notes (the ones about removing the duplicated item details). So I dropped the DB and reloaded the backup from the 3.6 step and tried without these steps. I've also now tried the original backup too, without success. I'm not sure at this point if it's the items that have vanished or the records too. Yes, I have run rebuild_zebra -b -r as the koha user (several times no luck). So I suppose I'm looking for guidance on a) working out what is going on. b) how to get normality back again. -ramon. ------------------------------ Message: 4 Date: Wed, 24 Oct 2012 18:01:53 +0200 From: Hugo Agud <hagud(a)orex.es> To: Ramon Andi?ach <custard(a)westnet.com.au> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Problems upgrading to 3.8 Message-ID: <CADT_QRTsaDrrye_Ux-To_JkjQZk=eT3QN_b1UEoEPSg1N_k64Q(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi Ramon Do not worry it happens to a lot of people ... take a look on this http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8665 Kindest Regards 2012/10/24 Ramon Andi?ach <custard(a)westnet.com.au> > Hi, > > This is going sound pathetic, and stupid, but I'm in need of some > guidance. It has been quite some time since I've tried to use koha. > > I've been upgrading my koha from 3.00 towards 3.8 via the tarball method. > > I was attempting to be good, and going in smallish steps so 3.00 to > 3.02 to 3.04 to 3.06 and then to 3.8. > > In between each upgrade I was trying a few searches to make sure that > the books end of the db was intact and then backing up the DB. > > After the 3.06 step it seemed to be working. > > But, after the 3.8 step suddenly most of the books seem to have vanished. > > I'd put it down to noticing in the upgrade notes some extra steps that > I didn't see in the 3.6 or 3.4 notes (the ones about removing the > duplicated item details). So I dropped the DB and reloaded the backup > from the 3.6 step and tried without these steps. > > I've also now tried the original backup too, without success. > > I'm not sure at this point if it's the items that have vanished or the > records too. Yes, I have run rebuild_zebra -b -r as the koha user > (several times no luck). > > So I suppose I'm looking for guidance on > a) working out what is going on. > b) how to get normality back again. > > -ramon. > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- *Hugo Agud - Orex Digital * *www.orex.es* * * Director Avenida Sarri? 29 ? 08029 Barcelona <http://twitter.com/OrexDigital> :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539 33 30 hagud(a)orex.es ? http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 ?rboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene informaci?n que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni est? autorizado a recibirlo por el remitente), no est? autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notif?quenoslo inmediatamente y b?rrelo de su sistema. ------------------------------ Message: 5 Date: Wed, 24 Oct 2012 10:11:18 -0700 (PDT) From: Estel Porras <orlib(a)yahoo.com> To: Koha community <koha(a)lists.katipo.co.nz> Subject: [Koha] Email. Message-ID: <1351098678.37956.YahooMailNeo(a)web125305.mail.ne1.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Just wanted to thank all the very helpful folks here. You guys rock! ? ?Have a great day, ~Estel~ Orland Free Library 333 Mill St. Orland CA. 95963 [530]865-1640 ------------------------------ Message: 6 Date: Wed, 24 Oct 2012 22:23:41 +0100 From: Elaine Bradtke <eb(a)efdss.org> To: koha <koha(a)lists.katipo.co.nz> Subject: [Koha] Help needed with report - how to extract subtitle and edition? Message-ID: <CAPdfUux1_GHutDqzKJrr-F+3DPU0fwCH8LYrfKiGmwtbEM5DHw(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 I'm trying to catch duplicate items in data before I upload it (ISBN won't help in this case). In order to do that I've written a report to list the books currently in Koha, and will compare them with my external files. However, if I can't include the subtitle (MARC 245 b) I will get too many false positives (we have lots of things with the same title, but different subtitles) It would also help if I could also have the 250 a (edition) This is what I have: SELECT biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit ems.place,biblioitems.publishercode,biblioitems.isbn FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype='BK' AND items.holdingbranch='VWML' ORDER BY biblio.author asc This works fine, but doesn't include the 245 b or the 250 a Can anyone help? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ------------------------------ Message: 7 Date: Wed, 24 Oct 2012 23:51:10 +0200 From: mh_zalabany(a)hotmail.com <mh_zalabany(a)hotmail.com> To: eb(a)efdss.org,"koha" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Help needed with report - how to extract subtitle and edition? Message-ID: <BLU0-SMTP34294835DD8881E4738D9DE97780(a)phx.gbl> Content-Type: text/plain; charset="utf-8" I think in this case you need to make the report using the xml field in biblio items table because the rest of sub fields you will find there Sent from my HTC ----- Reply message ----- From: "Elaine Bradtke" <eb(a)efdss.org> To: "koha" <koha(a)lists.katipo.co.nz> Subject: [Koha] Help needed with report - how to extract subtitle and edition? Date: Wed, Oct 24, 2012 11:23 pm I'm trying to catch duplicate items in data before I upload it (ISBN won't help in this case). In order to do that I've written a report to list the books currently in Koha, and will compare them with my external files. However, if I can't include the subtitle (MARC 245 b) I will get too many false positives (we have lots of things with the same title, but different subtitles) It would also help if I could also have the 250 a (edition) This is what I have: SELECT biblio.biblionumber,biblio.author,biblio.title,biblio.copyrightdate,biblioit ems.place,biblioitems.publishercode,biblioitems.isbn FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype='BK' AND items.holdingbranch='VWML' ORDER BY biblio.author asc This works fine, but doesn't include the 245 b or the 250 a Can anyone help? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 84, Issue 45 ************************************

1 0