[Koha] Improving the advanced search form (Mason James)

Mason James mtj at kohaaloha.com
Fri Oct 26 08:12:05 NZDT 2012


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: koha-bounces at lists.katipo.co.nz
> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
> koha-request at lists.katipo.co.nz
> Sent: 25 October 2012 17:31
> To: koha at lists.katipo.co.nz
> Subject: Koha Digest, Vol 84, Issue 48
> 
> Send Koha mailing list submissions to
> 	koha at 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 at lists.katipo.co.nz
> 
> You can reach the person managing the list at
> 	koha-owner at 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 at 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 at hotmail.com <mh_zalabany at hotmail.com>
> To: karamqubsi at gmail.com, "Koha" <Koha at lists.katipo.co.nz>,
> 	Koha-devel at lists.koha-community.org
> Subject: Re: [Koha] need help in zebra indexing for Arabic words
> Message-ID: <BLU0-SMTP3851383E7C326B28479E844977F0 at 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 at gmail.com>
> To: "Koha" <Koha at lists.katipo.co.nz>, <Koha-devel at 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 at gmail.com>
> Date: Thu, Oct 25, 2012 at 4:20 AM
> Subject: need help in transliterate rule
> To: zebralist at 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 at 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 at foundations.edu>
> To: koha at lists.katipo.co.nz
> Subject: [Koha] Fwd: Koha Database Migration
> Message-ID:
> 	<CAP3yOomSLJTvDboaguJghre3L2rO=CF6csE7C7w4bVzfba8eGQ at 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 at saiacs.org>
> Date: Thu, Oct 25, 2012 at 1:58 AM
> Subject: Koha Database Migration
> To: paul.a at aandc.org
> Cc: cnighswonger at 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 at saiacs.org or yesans at 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 at gmail.com>
> To: "mh_zalabany at hotmail.com" <mh_zalabany at hotmail.com>
> Cc: Koha <Koha at lists.katipo.co.nz>,
> 	Koha-devel at lists.koha-community.org
> Subject: Re: [Koha] need help in zebra indexing for Arabic words
> Message-ID:
> 	<CAML=htZ+EQBrfLtrvkSac9oJXw9G97d1j_a286EpkToyFLhKow at 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 at hotmail.com <
> mh_zalabany at 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 at gmail.com>
>> To: "Koha" <Koha at lists.katipo.co.nz>, 
>> <Koha-devel at 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 at gmail.com>
>> Date: Thu, Oct 25, 2012 at 4:20 AM
>> Subject: need help in transliterate rule
>> To: zebralist at 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 at 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 at 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 at kohaaloha.com>
> To: sunil.kumar at ecoleglobal.com
> Cc: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Improving the advanced search form
> Message-ID: <6A656B61-2350-4882-9E09-EEFFBEA910A5 at 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 at lists.katipo.co.nz
>> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
>> koha-request at lists.katipo.co.nz
>> Sent: 25 October 2012 09:53
>> To: koha at lists.katipo.co.nz
>> Subject: Koha Digest, Vol 84, Issue 46
>> 
>> Send Koha mailing list submissions to
>> 	koha at 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 at lists.katipo.co.nz
>> 
>> You can reach the person managing the list at
>> 	koha-owner at 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 at catalyst.net.nz>
>> To: koha at lists.katipo.co.nz
>> Subject: [Koha] Improving the advanced search form
>> Message-ID: <50889C13.9080505 at 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 at bigballofwax.co.nz>
>> To: Srikanth Dhondi <srikanth at catalyst.net.nz>
>> Cc: koha at lists.katipo.co.nz
>> Subject: Re: [Koha] Improving the advanced search form
>> Message-ID:
>> 	<CA+95qVR9P0U4Wynn2p0PWP3Wb37J+7SSiMu1xjvZs1kbq=9=nw at mail.gmail.com>
>> Content-Type: text/plain; charset=UTF-8
>> 
>> On 25 October 2012 14:55, Srikanth Dhondi <srikanth at 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 at auckland.ac.nz>
>> To: 'Chris Cormack' <chris at bigballofwax.co.nz>, Srikanth Dhondi
>> 	<srikanth at catalyst.net.nz>
>> Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
>> Subject: Re: [Koha] Improving the advanced search form
>> Message-ID:
>> 	
>> <AB44DEB8CF4F784F90EBCDBBD9B817376D7E2714 at 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 at lists.katipo.co.nz
>> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Chris Cormack
>> Sent: Thursday, 25 October 2012 3:03 p.m.
>> To: Srikanth Dhondi
>> Cc: koha at lists.katipo.co.nz
>> Subject: Re: [Koha] Improving the advanced search form
>> 
>> On 25 October 2012 14:55, Srikanth Dhondi <srikanth at 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 at 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 at ecoleglobal.com>
>> To: <koha at lists.katipo.co.nz>
>> Subject: Re: [Koha] Data Migration (Dennis Njuguna)
>> Message-ID: <000301cdb268$57b958c0$072c0a40$@kumar at 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 at lists.katipo.co.nz
>> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
>> koha-request at lists.katipo.co.nz
>> Sent: 25 October 2012 03:21
>> To: koha at lists.katipo.co.nz
>> Subject: Koha Digest, Vol 84, Issue 45
>> 
>> Send Koha mailing list submissions to
>> 	koha at 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 at lists.katipo.co.nz
>> 
>> You can reach the person managing the list at
>> 	koha-owner at 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 at hotmail.com)
>> 
>> 
>> ----------------------------------------------------------------------
>> 
>> Message: 1
>> Date: Wed, 24 Oct 2012 12:17:39 +0300
>> From: Dennis Njuguna <cknjuguna at gmail.com>
>> To: Mohamed zalabany <mh_zalabany at hotmail.com>
>> Cc: koha list <koha at lists.katipo.co.nz>,	"manny_tamayao at sil.org"
>> 	<manny_tamayao at sil.org>
>> Subject: Re: [Koha] Data Migration
>> Message-ID:
>> 	<CAH0M1x-AbcrEvvzfvOL9oJ4nE7NMD0o4-UytqTUa0LfGxyOyAA at 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 at 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 at hotmail.com
>>> Mobile: 0111291444
>>> 
>>> **
>>> 
>>> 
>>> ------------------------------
>>> Date: Tue, 23 Oct 2012 17:08:09 +0300
>>> Subject: Re: [Koha] Data Migration
>>> From: cknjuguna at gmail.com
>>> To: mh_zalabany at hotmail.com
>>> CC: manny_tamayao at sil.org; koha at 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 at 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 at hotmail.com
>>> Mobile: 202-0111291444
>>> 
>>> 
>>> 
>>>> From: manny_tamayao at sil.org
>>>> To: koha at 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 at lists.katipo.co.nz 
>>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>> 
>>> _______________________________________________
>>> Koha mailing list  http://koha-community.org Koha at 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 at hotmail.com>
>> To: <cknjuguna at gmail.com>
>> Cc: koha list <koha at lists.katipo.co.nz>,	"manny_tamayao at sil.org"
>> 	<manny_tamayao at sil.org>
>> Subject: Re: [Koha] Data Migration
>> Message-ID: <BLU165-W49D11BF288626BB715E85597780 at 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 at hotmail.com
>> Mobile: 0111291444
>> 
>> 
>> 
>> Date: Wed, 24 Oct 2012 12:17:39 +0300
>> Subject: Re: [Koha] Data Migration
>> From: cknjuguna at gmail.com
>> To: mh_zalabany at hotmail.com
>> CC: manny_tamayao at sil.org; koha at 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 at 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 at hotmail.com
>> Mobile: 0111291444
>> 
>> 
>> 
>> 
>> Date: Tue, 23 Oct 2012 17:08:09 +0300
>> Subject: Re: [Koha] Data Migration
>> From: cknjuguna at gmail.com
>> To: mh_zalabany at hotmail.com
>> 
>> CC: manny_tamayao at sil.org; koha at 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 at 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 at hotmail.com
>> 
>> Mobile: 202-0111291444
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>>> From: manny_tamayao at sil.org
>> 
>>> To: koha at 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 at lists.katipo.co.nz
>> 
>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>> 
>> 
>> 
>> _______________________________________________
>> 
>> Koha mailing list  http://koha-community.org
>> 
>> Koha at 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 at westnet.com.au>
>> To: koha at lists.katipo.co.nz
>> Subject: [Koha] Problems upgrading to 3.8
>> Message-ID: <96D8A573-0DC3-478B-BA5C-CBD5FD9974A5 at 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 at orex.es>
>> To: Ramon Andi?ach <custard at westnet.com.au>
>> Cc: koha at lists.katipo.co.nz
>> Subject: Re: [Koha] Problems upgrading to 3.8
>> Message-ID:
>> 	<CADT_QRTsaDrrye_Ux-To_JkjQZk=eT3QN_b1UEoEPSg1N_k64Q at 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 at 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 at 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 at 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 at yahoo.com>
>> To: Koha community <koha at lists.katipo.co.nz>
>> Subject: [Koha] Email.
>> Message-ID:
>> 	<1351098678.37956.YahooMailNeo at 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 at efdss.org>
>> To: koha <koha at lists.katipo.co.nz>
>> Subject: [Koha] Help needed with report - how to extract subtitle and
>> 	edition?
>> Message-ID:
>> 	<CAPdfUux1_GHutDqzKJrr-F+3DPU0fwCH8LYrfKiGmwtbEM5DHw at 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 at hotmail.com <mh_zalabany at hotmail.com>
>> To: eb at efdss.org,"koha" <koha at lists.katipo.co.nz>
>> Subject: Re: [Koha] Help needed with report - how to extract subtitle
>> 	and	edition?
>> Message-ID: <BLU0-SMTP34294835DD8881E4738D9DE97780 at 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 at efdss.org>
>> To: "koha" <koha at 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 at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>> 
>> 
>> ------------------------------
>> 
>> _______________________________________________
>> Koha mailing list
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>> 
>> 
>> End of Koha Digest, Vol 84, Issue 45
>> ************************************
>> 
>> 
>> 
>> ------------------------------
>> 
>> _______________________________________________
>> Koha mailing list
>> Koha at 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 at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> 
> ------------------------------
> 
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> End of Koha Digest, Vol 84, Issue 48
> ************************************
> 
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> 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


More information about the Koha mailing list