On 2012-10-26, at 1:07 AM, Sunil Kumar wrote: > 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
i didn't test on koha 3.6 will you please edit your email, before replying to digest messages? > > > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > [email protected] > Sent: 25 October 2012 17:31 > To: [email protected] > Subject: Koha Digest, Vol 84, Issue 48 > > Send Koha mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 > ([email protected]) > 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: [email protected] <[email protected]> > To: [email protected], "Koha" <[email protected]>, > [email protected] > Subject: Re: [Koha] need help in zebra indexing for Arabic words > Message-ID: <[email protected]> > 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" <[email protected]> > To: "Koha" <[email protected]>, <[email protected]> > 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 <[email protected]> > Date: Thu, Oct 25, 2012 at 4:20 AM > Subject: need help in transliterate rule > To: [email protected] > > > 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 [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > > ------------------------------ > > Message: 2 > Date: Thu, 25 Oct 2012 06:13:28 -0400 > From: Chris Nighswonger <[email protected]> > To: [email protected] > Subject: [Koha] Fwd: Koha Database Migration > Message-ID: > <CAP3yOomSLJTvDboaguJghre3L2rO=cf6cse7c7w4bvzfba8...@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 <[email protected]> > Date: Thu, Oct 25, 2012 at 1:58 AM > Subject: Koha Database Migration > To: [email protected] > Cc: [email protected] > > > 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: [email protected] or [email protected] > > ______________________________________ > > 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 <[email protected]> > To: "[email protected]" <[email protected]> > Cc: Koha <[email protected]>, > [email protected] > Subject: Re: [Koha] need help in zebra indexing for Arabic words > Message-ID: > <CAML=htz+eqbrfltrvksac9ojxw9g97d1j_a286epktoyflh...@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, [email protected] < > [email protected]> 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" <[email protected]> >> To: "Koha" <[email protected]>, >> <[email protected] >>> >> 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 <[email protected]> >> Date: Thu, Oct 25, 2012 at 4:20 AM >> Subject: need help in transliterate rule >> To: [email protected] >> >> >> 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 [email protected] >> 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: [email protected]* > *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 <[email protected]> > To: [email protected] > Cc: [email protected] > Subject: Re: [Koha] Improving the advanced search form > Message-ID: <[email protected]> > 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: [email protected] >> [mailto:[email protected]] On Behalf Of >> [email protected] >> Sent: 25 October 2012 09:53 >> To: [email protected] >> Subject: Koha Digest, Vol 84, Issue 46 >> >> Send Koha mailing list submissions to >> [email protected] >> >> 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 >> [email protected] >> >> You can reach the person managing the list at >> [email protected] >> >> 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 <[email protected]> >> To: [email protected] >> Subject: [Koha] Improving the advanced search form >> Message-ID: <[email protected]> >> 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 <[email protected]> >> To: Srikanth Dhondi <[email protected]> >> Cc: [email protected] >> Subject: Re: [Koha] Improving the advanced search form >> Message-ID: >> <CA+95qVR9P0U4Wynn2p0PWP3Wb37J+7SSiMu1xjvZs1kbq=9=n...@mail.gmail.com> >> Content-Type: text/plain; charset=UTF-8 >> >> On 25 October 2012 14:55, Srikanth Dhondi <[email protected]> > 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 <[email protected]> >> To: 'Chris Cormack' <[email protected]>, Srikanth Dhondi >> <[email protected]> >> Cc: "[email protected]" <[email protected]> >> Subject: Re: [Koha] Improving the advanced search form >> Message-ID: >> >> <ab44deb8cf4f784f90ebcdbbd9b817376d7e2...@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: [email protected] >> [mailto:[email protected]] On Behalf Of Chris Cormack >> Sent: Thursday, 25 October 2012 3:03 p.m. >> To: Srikanth Dhondi >> Cc: [email protected] >> Subject: Re: [Koha] Improving the advanced search form >> >> On 25 October 2012 14:55, Srikanth Dhondi <[email protected]> > 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 [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> ------------------------------ >> >> Message: 4 >> Date: Thu, 25 Oct 2012 09:52:23 +0530 >> From: "Sunil Kumar" <[email protected]> >> To: <[email protected]> >> Subject: Re: [Koha] Data Migration (Dennis Njuguna) >> Message-ID: <000301cdb268$57b958c0$072c0a40$@[email protected]> >> 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: [email protected] >> [mailto:[email protected]] On Behalf Of >> [email protected] >> Sent: 25 October 2012 03:21 >> To: [email protected] >> Subject: Koha Digest, Vol 84, Issue 45 >> >> Send Koha mailing list submissions to >> [email protected] >> >> 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 >> [email protected] >> >> You can reach the person managing the list at >> [email protected] >> >> 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? ([email protected]) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Wed, 24 Oct 2012 12:17:39 +0300 >> From: Dennis Njuguna <[email protected]> >> To: Mohamed zalabany <[email protected]> >> Cc: koha list <[email protected]>, "[email protected]" >> <[email protected]> >> Subject: Re: [Koha] Data Migration >> Message-ID: >> <cah0m1x-abcrevvzfvol9oj4ne7nmd0o4-uytqtua0lfgxyo...@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 >> <[email protected]>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 >>> [email protected] >>> Mobile: 0111291444 >>> >>> ** >>> >>> >>> ------------------------------ >>> Date: Tue, 23 Oct 2012 17:08:09 +0300 >>> Subject: Re: [Koha] Data Migration >>> From: [email protected] >>> To: [email protected] >>> CC: [email protected]; [email protected] >>> >>> >>> Hello Mohamed what about data migration from mandarin M3 especially >>> the holdings? >>> >>> On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany >>> <[email protected] >>>> 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 >>> [email protected] >>> Mobile: 202-0111291444 >>> >>> >>> >>>> From: [email protected] >>>> To: [email protected] >>>> 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 [email protected] >>>> http://lists.katipo.co.nz/mailman/listinfo/koha >>> >>> _______________________________________________ >>> Koha mailing list http://koha-community.org [email protected] >>> 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 <[email protected]> >> To: <[email protected]> >> Cc: koha list <[email protected]>, "[email protected]" >> <[email protected]> >> Subject: Re: [Koha] Data Migration >> Message-ID: <[email protected]> >> 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 >> [email protected] >> Mobile: 0111291444 >> >> >> >> Date: Wed, 24 Oct 2012 12:17:39 +0300 >> Subject: Re: [Koha] Data Migration >> From: [email protected] >> To: [email protected] >> CC: [email protected]; [email protected] >> >> >> 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 > <[email protected]> >> 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 >> >> [email protected] >> Mobile: 0111291444 >> >> >> >> >> Date: Tue, 23 Oct 2012 17:08:09 +0300 >> Subject: Re: [Koha] Data Migration >> From: [email protected] >> To: [email protected] >> >> CC: [email protected]; [email protected] >> >> Hello Mohamed what about data migration from mandarin M3 especially the >> holdings? >> >> >> On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany > <[email protected]> >> 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 >> >> [email protected] >> >> Mobile: 202-0111291444 >> >> >> >> >> >> >> >>> From: [email protected] >> >>> To: [email protected] >> >>> 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 >> >>> [email protected] >> >>> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> >> [email protected] >> >> 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 <[email protected]> >> To: [email protected] >> Subject: [Koha] Problems upgrading to 3.8 >> Message-ID: <[email protected]> >> 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 <[email protected]> >> To: Ramon Andi?ach <[email protected]> >> Cc: [email protected] >> Subject: Re: [Koha] Problems upgrading to 3.8 >> Message-ID: >> <CADT_QRTsaDrrye_Ux-To_JkjQZk=et3qn_b1ueoepsg1n_k...@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 <[email protected]> >> >>> 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 [email protected] >>> 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 >> [email protected] ? 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 <[email protected]> >> To: Koha community <[email protected]> >> Subject: [Koha] Email. >> Message-ID: >> <[email protected]> >> 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 <[email protected]> >> To: koha <[email protected]> >> Subject: [Koha] Help needed with report - how to extract subtitle and >> edition? >> Message-ID: >> <capdfuux1_ghutdqzkjrr-f+3dpu0fwch8lyrfkigmwtbem5...@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: [email protected] <[email protected]> >> To: [email protected],"koha" <[email protected]> >> Subject: Re: [Koha] Help needed with report - how to extract subtitle >> and edition? >> Message-ID: <[email protected]> >> 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" <[email protected]> >> To: "koha" <[email protected]> >> 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 >> [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> ------------------------------ >> >> _______________________________________________ >> Koha mailing list >> [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> End of Koha Digest, Vol 84, Issue 45 >> ************************************ >> >> >> >> ------------------------------ >> >> _______________________________________________ >> Koha mailing list >> [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> End of Koha Digest, Vol 84, Issue 46 >> ************************************ >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha > > > > ------------------------------ > > _______________________________________________ > Koha mailing list > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 84, Issue 48 > ************************************ > > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha sorry, i didn't test on koha 3.6 please edit your email, before replying to digest messages _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha

