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.ku...@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-boun...@lists.katipo.co.nz > [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of > koha-requ...@lists.katipo.co.nz > Sent: 25 October 2012 03:21 > To: koha@lists.katipo.co.nz > Subject: Koha Digest, Vol 84, Issue 45 > > Send Koha mailing list submissions to > koha@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-requ...@lists.katipo.co.nz > > You can reach the person managing the list at > koha-ow...@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_zalab...@hotmail.com) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 24 Oct 2012 12:17:39 +0300 > From: Dennis Njuguna <cknjug...@gmail.com> > To: Mohamed zalabany <mh_zalab...@hotmail.com> > Cc: koha list <koha@lists.katipo.co.nz>, "manny_tama...@sil.org" > <manny_tama...@sil.org> > 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 > <mh_zalab...@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_zalab...@hotmail.com > > Mobile: 0111291444 > > > > ** > > > > > > ------------------------------ > > Date: Tue, 23 Oct 2012 17:08:09 +0300 > > Subject: Re: [Koha] Data Migration > > From: cknjug...@gmail.com > > To: mh_zalab...@hotmail.com > > CC: manny_tama...@sil.org; koha@lists.katipo.co.nz > > > > > > Hello Mohamed what about data migration from mandarin M3 especially > > the holdings? > > > > On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany > > <mh_zalab...@hotmail.com > > > wrote: > > > > > > i have a big experience in data conversion but unfortunately i don't > > know MAELISA library systemso could you tell us is the data is MARC > > format i what format and send me a sample of data > > > > > > > > Mohamed El ZalabanyIntegrated library systems consultant > > > > Zalabany Knowledge Systems Team? > > For Libraries and Information systems Development and support > > mh_zalab...@hotmail.com > > Mobile: 202-0111291444 > > > > > > > > > From: manny_tama...@sil.org > > > To: koha@lists.katipo.co.nz > > > Date: Tue, 23 Oct 2012 10:21:40 +0800 > > > Subject: [Koha] Data Migration > > > > > > Good day to all, > > > > > > > > > > > > I'm Manny from Manila and in the process of data migration of the > > > library from "MAELISA" to KOHA. > > > > > > Is there anyone who had done this process or has a script that may > help? > > > > > > > > > > > > Salamat > > > > > > > > > > > > Manny Tamayao > > > > > > Librarian/Archivist > > > > > > SIL Philippines > > > > > > skype: mannytamayao > > > > > > mobile: 09152822329 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > _______________________________________________ > > Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > > > -- > > > > Dennis K. Njuguna > > > > > > > -- > > Dennis K. Njuguna > > > ------------------------------ > > Message: 2 > Date: Wed, 24 Oct 2012 09:38:15 +0000 > From: Mohamed zalabany <mh_zalab...@hotmail.com> > To: <cknjug...@gmail.com> > Cc: koha list <koha@lists.katipo.co.nz>, "manny_tama...@sil.org" > <manny_tama...@sil.org> > Subject: Re: [Koha] Data Migration > Message-ID: <blu165-w49d11bf288626bb715e85597...@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_zalab...@hotmail.com > Mobile: 0111291444 > > > > Date: Wed, 24 Oct 2012 12:17:39 +0300 > Subject: Re: [Koha] Data Migration > From: cknjug...@gmail.com > To: mh_zalab...@hotmail.com > CC: manny_tama...@sil.org; koha@lists.katipo.co.nz > > > 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_zalab...@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_zalab...@hotmail.com > Mobile: 0111291444 > > > > > Date: Tue, 23 Oct 2012 17:08:09 +0300 > Subject: Re: [Koha] Data Migration > From: cknjug...@gmail.com > To: mh_zalab...@hotmail.com > > CC: manny_tama...@sil.org; koha@lists.katipo.co.nz > > Hello Mohamed what about data migration from mandarin M3 especially the > holdings? > > > On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany <mh_zalab...@hotmail.com > > > wrote: > > > > i have a big experience in data conversion but unfortunately i don't know > MAELISA library systemso could you tell us is the data is MARC format i > what > format and send me a sample of data > > > > > > > > Mohamed El ZalabanyIntegrated library systems consultant > > > > Zalabany Knowledge Systems Team? > > For Libraries and Information systems Development and support > > mh_zalab...@hotmail.com > > Mobile: 202-0111291444 > > > > > > > > > From: manny_tama...@sil.org > > > To: koha@lists.katipo.co.nz > > > Date: Tue, 23 Oct 2012 10:21:40 +0800 > > > Subject: [Koha] Data Migration > > > > > > Good day to all, > > > > > > > > > > > > I'm Manny from Manila and in the process of data migration of the > > library > > > from "MAELISA" to KOHA. > > > > > > Is there anyone who had done this process or has a script that may help? > > > > > > > > > > > > Salamat > > > > > > > > > > > > Manny Tamayao > > > > > > Librarian/Archivist > > > > > > SIL Philippines > > > > > > skype: mannytamayao > > > > > > mobile: 09152822329 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > Koha mailing list http://koha-community.org > > > Koha@lists.katipo.co.nz > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > -- > > Dennis K. Njuguna > > > > > -- > > Dennis K. Njuguna > > > > ------------------------------ > > Message: 3 > Date: Wed, 24 Oct 2012 23:46:00 +0800 > From: Ramon Andi?ach <cust...@westnet.com.au> > To: koha@lists.katipo.co.nz > Subject: [Koha] Problems upgrading to 3.8 > Message-ID: <96d8a573-0dc3-478b-ba5c-cbd5fd997...@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 <ha...@orex.es> > To: Ramon Andi?ach <cust...@westnet.com.au> > Cc: koha@lists.katipo.co.nz > 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 <cust...@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@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 > ha...@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 <or...@yahoo.com> > To: Koha community <koha@lists.katipo.co.nz> > Subject: [Koha] Email. > Message-ID: > <1351098678.37956.yahoomail...@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 <e...@efdss.org> > To: koha <koha@lists.katipo.co.nz> > 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: mh_zalab...@hotmail.com <mh_zalab...@hotmail.com> > To: e...@efdss.org,"koha" <koha@lists.katipo.co.nz> > Subject: Re: [Koha] Help needed with report - how to extract subtitle > and edition? > Message-ID: <blu0-smtp34294835dd8881e4738d9de97...@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" <e...@efdss.org> > To: "koha" <koha@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@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > _______________________________________________ > Koha mailing list > Koha@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@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Dennis K. Njuguna _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha