[Koha] Importing data into Koha 3.14
Hello, I am trying to import data into Koha 3.14 from a .mrc file. I know that in order to insert an item it has to be under tag 952. But my file has a special structure where the items are separated from the bib record and linked to it through tag 004. Below is a sample record with its item. I appreciate any idea that you can give which helps me importing these records into Koha. =LDR 00713cas a2200265 4500 =001 115761 =005 20100208102331.0 =008 740909u1972ir\grh0\\\a0eng\u =010 \\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547S =035 \\$a(NIC)notisAAM7160 =035 \\$a(OCoLC)1001547 =035 \\$a115761 =040 \\$cPU$dNIC$dCStRLIN =050 0\$aCT1886$b.I7 =082 \\$a920/.055 =245 00$aIran who's who. =260 \\$aTehran,$bEcho of Iran. =300 \\$av.$c21 cm. =362 0\$a1st- ed.; 1972- =651 \0$aIran$xBiography =905 \\$a1992030912.0 =948 2\$a20100208$bm$dbatch$elts$xdel9XXtxt =950 \\$lREF$aDS271$b.I65$e\Last vol\in Ref\$i01/21/86 N =995 \\$aHivolm$d20100208 =LDR 00675cy a22001213 4500 =001 151381 =004 115761 =005 20060220173142.0 =008 9301235u8\\\2\\\uu\\ =014 1\$aAAM7160CU001 =014 0\$9000148016 =852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003 =866 \1$80$a1st-2nd,4th ed. (1972-1974,1993) As you can see, tag =004 115761 in the second record is the same as tag =001 115761 in the first record which is used to link those two records. How can I import such a file into Koha correctly? Many thanks, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Is there a self check-in system in Koha?
Hi, I just checked out the Self checkout module of Koha, I am currently using Koha 3.14. I wanted to ask if we have a functionality of Self check-in as well? Or someone is working on it for the upcoming versions? Thanks in advance! Regards *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Importing data into Koha 3.14
Hello, Thanks a lot for the prompt response. Can you please tell me how the below data should look like? Just to make sure I got you correctly. Many thanks, Regards. From: vinod_librar...@rediffmail.com [mailto:vinod_librar...@rediffmail.com] Sent: Friday, June 06, 2014 10:13 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Importing data into Koha 3.14 Hello, Simply use find and replace option in marcedit and replace =004 acc. number with =952 \\$pfile:///\\$p acc. number. On Fri, 06 Jun 2014 11:43:32 +0530 wrote Hello, I am trying to import data into Koha 3.14 from a .mrc file. I know that in order to insert an item it has to be under tag 952. But my file has a special structure where the items are separated from the bib record and linked to it through tag 004. Below is a sample record with its item. I appreciate any idea that you can give which helps me importing these records into Koha. =LDR 00713cas a2200265 4500 =001 115761 =005 20100208102331.0 =008 740909u1972ir\grh0\\\a0eng\u =010 \\$afile:///\\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547Sfile:///\\$a(CStRLIN)NYCX1001547S =035 \\$a(NIC)notisAAM7160file:///\\$a(NIC)notisAAM7160 =035 \\$a(OCoLC)1001547file:///\\$a(OCoLC)1001547 =035 \\$a115761file:///\\$a115761 =040 \\$cPU$dNIC$dCStRLINfile:///\\$cPU$dNIC$dCStRLIN =050 0\$aCT1886$b.I7 =082 \\$a920/.055file:///\\$a920\.055 =245 00$aIran who's who. =260 \\$aTehran,$bEchofile:///\\$aTehran,$bEcho of Iran. =300 \\$av.$c21file:///\\$av.$c21 cm. =362 0\$a1st- ed.; 1972- =651 \0$aIran$xBiography =905 \\$a1992030912.0file:///\\$a1992030912.0 =948 2\$a20100208$bm$dbatch$elts$xdel9XXtxt =950 \\$lREF$aDS271$b.I65$e\Lastfile:///\\$lREF$aDS271$b.I65$e\Last vol\in Ref\$i01/21/86 N =995 \\$aHivolm$d20100208file:///\\$aHivolm$d20100208 =LDR 00675cy a22001213 4500 =001 151381 =004 115761 =005 20060220173142.0 =008 9301235u8\\\2\\\uu\\ =014 1\$aAAM7160CU001 =014 0\$9000148016 =852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003 =866 \1$80$a1st-2nd,4th ed. (1972-1974,1993) As you can see, tag =004 115761 in the second record is the same as tag =001 115761 in the first record which is used to link those two records. How can I import such a file into Koha correctly? Many thanks, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.commailto:vinod_librar...@rediffmail.com : mishrav...@gmail.commailto:mishrav...@gmail.com [http://sigads.rediff.com/RealMedia/ads/adstream_nx.ads/www.rediffmail.com/signatureline.htm@Middle]http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle? Get your own FREE website, FREE domain FREE mobile app with Company email. Know More http://track.rediff.com/click?url=___http://businessemail.rediff.com/email-ids-for-companies-with-less-than-50-employees?sc_cid=sign-1-10-13___cmp=hostlnk=sign-1-10-13nsrv1=host ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Importing data into Koha 3.14
Hello, =004 115761 =952 \\$p115761 However, few more things need to be add in 952 field for each accession number like location, item type, call number etc all these are possible through marcedit and you have to explore the options given their. On Fri, 06 Jun 2014 12:46:16 +0530 wrote Hello,Thanks a lot for the prompt response. Can you please tell me how the below data should look like? Just to make sure I got you correctly.Many thanks,Regards.From: vinod_librar...@rediffmail.com [mailto:vinod_librar...@rediffmail.com] Sent: Friday, June 06, 2014 10:13 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Importing data into Koha 3.14Hello, Simply use find and replace option in marcedit and replace =004 acc. number with =952 \\$p acc. number. On Fri, 06 Jun 2014 11:43:32 +0530 wrote Hello, I am trying to import data into Koha 3.14 from a .mrc file. I know that in order to insert an item it has to be under tag 952. But my file has a special structure where the items are separated from the bib record and linked to it through tag 004. Below is a sample record with its item. I appreciate any idea that you can give which helps me importing these records into Koha. =LDR 00713cas a2200265 4500 =001 115761 =005 20100208102331.0 =008 740909u1972ir\grh0\\\a0eng\u =010 \\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547S =035 \\$a(NIC)notisAAM7160 =035 \\$a(OCoLC)1001547 =035 \\$a115761 =040 \\$cPU$dNIC$dCStRLIN =050 0\$aCT1886$b.I7 =082 vol\in Ref\$i01/21/86 N =995 \\$aHivolm$d20100208 =LDR 00675cy a22001213 4500 =001 151381 =004 115761 =005 20060220173142.0 =008 9301235u8\\\2\\\uu\\ =014 1\$aAAM7160CU001 =014 0\$9000148016 =852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003 =866 \1$80$a1st-2nd,4th ed. (1972-1974,1993) As you can see, tag =004 115761 in the second record is the same as tag =001 115761 in the first record which is used to link those two records. How can I import such a file into Koha correctly? Many thanks, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishravk79@gmail.comGet your own FREE website, FREE domain FREE mobile app with Company email. Know More With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishrav...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Importing data into Koha 3.14
Hello, I really appreciate your prompt response. I fixed the record as you suggested and added the $p number to the 952 field but still when importing, I get a record without items and the second record also imported separate from the first one. Here is the record imported. Please let me know what wrong I am doing and if there are special settings I should select while importing for Koha to map them correctly. =LDR 00762cas a2200277 4500 =001 115761 =005 20100208102331.0 =008 740909u1972ir\grh0\\\a0eng\u =010 \\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547S =035 \\$a(NIC)notisAAM7160 =035 \\$a(OCoLC)1001547 =035 \\$a115761 =040 \\$cPU$dNIC$dCStRLIN =050 0\$aCT1886$b.I7 =082 \\$a920/.055 =245 00$aIran who's who. =260 \\$aTehran,$bEcho of Iran. =300 \\$av.$c21 cm. =362 0\$a1st- ed.; 1972- =651 \0$aIran$xBiography =905 \\$a1992030912.0 =948 2\$a20100208$bm$dbatch$elts$xdel9XXtxt =950 \\$lREF$aDS271$b.I65$e\Last vol\in Ref\$i01/21/86 N =995 \\$aHivolm$d20100208 =LDR 00742cy a22001333 4500 =001 151381 =004 115761 =005 20060220173142.0 =008 9301235u8\\\2\\\uu\\ =014 1\$aAAM7160CU001 =014 0\$9000148016 =852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003 =866 \1$a1st-2nd,4th ed. (1972-1974,1993) =952 \\$yCR$colin$2z$z-$bolin,anx$oDS271 .I65$acornell$p115761 Many Thanks, Layale. From: vinod_librar...@rediffmail.com [mailto:vinod_librar...@rediffmail.com] Sent: Friday, June 06, 2014 10:20 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: RE: [Koha] Importing data into Koha 3.14 Hello, =004 115761 =952 \\$p115761file:///\\$p115761 However, few more things need to be add in 952 field for each accession number like location, item type, call number etc all these are possible through marcedit and you have to explore the options given their. On Fri, 06 Jun 2014 12:46:16 +0530 wrote Hello,Thanks a lot for the prompt response. Can you please tell me how the below data should look like? Just to make sure I got you correctly.Many thanks,Regards.From: vinod_librar...@rediffmail.commailto:vinod_librar...@rediffmail.com [mailto:vinod_librar...@rediffmail.com] Sent: Friday, June 06, 2014 10:13 AM To: Layale Bassil Cc: koha@lists.katipo.co.nzmailto:koha@lists.katipo.co.nz Subject: Re: [Koha] Importing data into Koha 3.14Hello, Simply use find and replace option in marcedit and replace =004 acc. number with =952 \\$pfile:///\\$p acc. number. On Fri, 06 Jun 2014 11:43:32 +0530 wrote Hello, I am trying to import data into Koha 3.14 from a .mrc file. I know that in order to insert an item it has to be under tag 952. But my file has a special structure where the items are separated from the bib record and linked to it through tag 004. Below is a sample record with its item. I appreciate any idea that you can give which helps me importing these records into Koha. =LDR 00713cas a2200265 4500 =001 115761 =005 20100208102331.0 =008 740909u1972ir\grh0\\\a0eng\u =010 \\$afile:///\\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547Sfile:///\\$a(CStRLIN)NYCX1001547S =035 \\$a(NIC)notisAAM7160file:///\\$a(NIC)notisAAM7160 =035 \\$a(OCoLC)1001547file:///\\$a(OCoLC)1001547 =035 \\$a115761file:///\\$a115761 =040 \\$cPU$dNIC$dCStRLINfile:///\\$cPU$dNIC$dCStRLIN =050 0\$aCT1886$b.I7 =082 vol\in Ref\$i01/21/86 N =995 \\$aHivolm$d20100208file:///\\$aHivolm$d20100208 =LDR 00675cy a22001213 4500 =001 151381 =004 115761 =005 20060220173142.0 =008 9301235u8\\\2\\\uu\\ =014 1\$aAAM7160CU001 =014 0\$9000148016 =852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003 =866 \1$80$a1st-2nd,4th ed. (1972-1974,1993) As you can see, tag =004 115761 in the second record is the same as tag =001 115761 in the first record which is used to link those two records. How can I import such a file into Koha correctly? Many thanks, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nzmailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860
[Koha] About example with the 952 field
Hi All, In Koha 3.14 Manual (en) there is the Tag 952 Subfield constraint table (see section '4.1.4. Edit Framework Subfield' of the chapter '2. Administration'). Why exactly 952 ? Is it accident ? Maybe, this field randomly has been selected as an example of the ordinary field ? Or, maybe, this is more essential, the 952 field is a special field in the Koha system ? For instance, not for cataloging but for a management ctalogues. Regards, Gennady ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Is there a self check-in system in Koha?
Hello, I will not clarify you please test yourself as it is clearly visible in screenshot given by you because by doing so you can learn more things. On Fri, 06 Jun 2014 12:54:08 +0530 wrote Dear Vinod, Thanks for the reply.I can see only the self checkout preference in Koha: Kindly provide the name of the preference. Thanks. Mayank On Fri, Jun 6, 2014 at 12:39 PM, Vinod Kumar Mishra wrote: Hello, I think Both options are given please check the system preferences. On Fri, 06 Jun 2014 12:37:33 +0530 wrote Hi, I just checked out the Self checkout module of Koha, I am currently using Koha 3.14. I wanted to ask if we have a functionality of Self check-in as well? Or someone is working on it for the upcoming versions? Thanks in advance! Regards *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishrav...@gmail.com Get your own FREE website, FREE domain FREE mobile app with Company email. Know More -- Mayank SrivastavaMob: +91 971 851 6955 New Delhi, India With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishrav...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Importing data into Koha 3.14
Hello, At least second record should show the item details as it contains 952 field but check the location, item type field, better is to enter one record in koha then export it in marc format and view structure of exported record so that you can convert your all records accordingly. On Fri, 06 Jun 2014 13:11:36 +0530 wrote Hello,I really appreciate your prompt response. I fixed the record as you suggested and added the $p number to the 952 field but still when importing, I get a record without items and the second record also imported separate from the first one. Here is the record imported. Please let me know what wrong I am doing and if there are special settings I should select while importing for Koha to map them correctly. =LDR 00762cas a2200277 4500=001 115761=005 20100208102331.0=008 740909u1972ir\grh0\\\a0eng\u=010 \\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547S=035 \\$a(NIC)notisAAM7160=035 \\$a(OCoLC)1001547=035 \\$a115761=040 \\$cPU$dNIC$dCStRLIN=050 0\$aCT1886$b.I7=082 \\$a920/.055=245 00$aIran who's who.=260 \\$aTehran,$bEcho of Iran.=300 \\$av.$c21 cm.=362 0\$a1st- ed.; 1972-=651 \0$aIran$xBiography=905 \\$a1992030912.0=948 2\$a20100208$bm$dbatch$elts$xdel9XXtxt=950 \\$lREF$aDS271$b.I65$e\Last vol\in Ref\$i01/21/86 N=995 \\$aHivolm$d20100208=LDR 00742cy a22001333 4500=001 151381=004 115761=005 20060220173142.0=008 9301235u8\\\2\\\uu\\=014 1\$aAAM7160CU001=014 0\$9000148016=852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003=866 \1$a1st-2nd,4th ed. (1972-1974,1993)=952 \\$yCR$colin$2z$z-$bolin,anx$oDS271 .I65$acornell$p115761Many Thanks,Layale.From: vinod_librar...@rediffmail.com [mailto:vinod_librar...@rediffmail.com] Sent: Friday, June 06, 2014 10:20 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: RE: [Koha] Importing data into Koha 3.14Hello, =004 115761 =952 \\$p115761 However, few more things need to be add in 952 field for each accession number like location, item type, call number etc all these are possible through marcedit and you have to explore the options given their. On Fri, 06 Jun 2014 12:46:16 +0530 wrote Hello,Thanks a lot for the prompt response. Can you please tell me how the below data should look like? Just to make sure I got you correctly.Many thanks,Regards.From: vinod_librar...@rediffmail.com [mailto:vinod_librar...@rediffmail.com] Sent: Friday, June 06, 2014 10:13 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Importing data into Koha 3.14Hello, Simply use find and replace option in marcedit and replace =004 acc. number with =952 \\$p acc. number. On Fri, 06 Jun 2014 11:43:32 +0530 wrote Hello, I am trying to import data into Koha 3.14 from a .mrc file. I know that in order to insert an item it has to be under tag 952. But my file has a special structure where the items are separated from the bib record and linked to it through tag 004. Below is a sample record with its item. I appreciate any idea that you can give which helps me importing these records into Koha. =LDR 00713cas a2200265 4500 =001 115761 =005 20100208102331.0 =008 740909u1972ir\grh0\\\a0eng\u =010 \\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547S =035 \\$a(NIC)notisAAM7160 =035 \\$a(OCoLC)1001547 =035 \\$a115761 =040 \\$cPU$dNIC$dCStRLIN =050 0\$aCT1886$b.I7 =082 vol\in Ref\$i01/21/86 N =995 \\$aHivolm$d20100208 =LDR 00675cy a22001213 4500 =001 151381 =004 115761 =005 20060220173142.0 =008 9301235u8\\\2\\\uu\\ =014 1\$aAAM7160CU001 =014 0\$9000148016 =852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003 =866 \1$80$a1st-2nd,4th ed. (1972-1974,1993) As you can see, tag =004 115761 in the second record is the same as tag =001 115761 in the first record which is used to link those two records. How can I import such a file into Koha correctly? Many thanks, Regards. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT
Re: [Koha] Importing data into Koha 3.14
Hi There is no problem you have separate records from bib items, Koha imports tool it is able to join both without any problem. 1st import biblio marc into koha as usuarl 2nd ajust items marc records according the 952 requirements of koha, the most important fields 952$abop, you should map 852 into 952 the besto possible way, i suggest to copy items.001 to some empty firlds of 952 in order to be able to track 3rd change 004 into 001 in items.marc record 4rd create a new matching rule in koha to match the index control-number 5 import marc.items records into koha, assign match record using 001 *note:make sure to not replace existing marc record in kohanota: maje sure to ignore new records (it shouldn't be new records)* *nota: configure add items.* If you do wll all these steps, the items will be attached to the right bibliographic record I hope it helps 2014-06-06 10:40 GMT+02:00 Vinod Kumar Mishra vinod_librar...@rediffmail.com: Hello, At least second record should show the item details as it contains 952 field but check the location, item type field, better is to enter one record in koha then export it in marc format and view structure of exported record so that you can convert your all records accordingly. On Fri, 06 Jun 2014 13:11:36 +0530 wrote Hello,I really appreciate your prompt response. I fixed the record as you suggested and added the $p number to the 952 field but still when importing, I get a record without items and the second record also imported separate from the first one. Here is the record imported. Please let me know what wrong I am doing and if there are special settings I should select while importing for Koha to map them correctly. =LDR 00762cas a2200277 4500=001 115761=005 20100208102331.0=008 740909u1972ir\grh0\\\a0eng\u=010 \\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547S=035 \\$a(NIC)notisAAM7160=035 \\$a(OCoLC)1001547=035 \\$a115761=040 \\$cPU$dNIC$dCStRLIN=050 0\$aCT1886$b.I7=082 \\$a920/.055=245 00$aIran who's who.=260 \\$aTehran,$bEcho of Iran.=300 \\$av.$c21 cm.=362 0\$a1st- ed.; 1972-=651 \0$aIran$xBiography=905 \\$a1992030912.0=948 2\$a20100208$bm$dbatch$elts$xdel9XXtxt=950 \\$lREF$aDS271$b.I65$e\Last vol\in Ref\$i01/21/86 N=995 \\$aHivolm$d20100208=LDR 00742cy a22001333 4500=001 151381=004 115761=005 20060220173142.0=008 9301235u8\\\2\\\uu\\=014 1\$aAAM7160CU001=014 0\$9000148016=852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003=866 \1$a1st-2nd,4th ed. (1972-1974,1993)=952 \\$yCR$colin$2z$z-$bolin,anx$oDS271 .I65$acornell$p115761Many Thanks,Layale.From: vinod_librar...@rediffmail.com [mailto: vinod_librar...@rediffmail.com] Sent: Friday, June 06, 2014 10:20 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: RE: [Koha] Importing data into Koha 3.14Hello, =004 115761 =952 \\$p115761 However, few more things need to be add in 952 field for each accession number like location, item type, call number etc all these are possible through marcedit and you have to explore the options given their. On Fri, 06 Jun 2014 12:46:16 +0530 wrote Hello,Thanks a lot for the prompt response. Can you please tell me how the below data should look like? Just to make sure I got you correctly.Many thanks,Regards.From: vinod_librar...@rediffmail.com [mailto: vinod_librar...@rediffmail.com] Sent: Friday, June 06, 2014 10:13 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Importing data into Koha 3.14Hello, Simply use find and replace option in marcedit and replace =004 acc. number with =952 \\$p acc. number. On Fri, 06 Jun 2014 11:43:32 +0530 wrote Hello, I am trying to import data into Koha 3.14 from a .mrc file. I know that in order to insert an item it has to be under tag 952. But my file has a special structure where the items are separated from the bib record and linked to it through tag 004. Below is a sample record with its item. I appreciate any idea that you can give which helps me importing these records into Koha. =LDR 00713cas a2200265 4500 =001 115761 =005 20100208102331.0 =008 740909u1972ir\grh0\\\a0eng\u =010 \\$a 72624790 =035 \\$a(CStRLIN)NYCX1001547S =035 \\$a(NIC)notisAAM7160 =035 \\$a(OCoLC)1001547 =035 \\$a115761 =040 \\$cPU$dNIC$dCStRLIN =050 0\$aCT1886$b.I7 =082 vol\in Ref\$i01/21/86 N =995 \\$aHivolm$d20100208 =LDR 00675cy a22001213 4500 =001 151381 =004 115761 =005 20060220173142.0 =008 9301235u8\\\2\\\uu\\ =014 1\$aAAM7160CU001 =014 0\$9000148016 =852
Re: [Koha] [koha] Collecting Dewey codes ?
Hi, Frederic: you may see Obtaining the Dewey Decimal Classification Number from other databases: a catalog clean-up project [1] where MARC21 or Unimarc sources (through Z39.50, SRU, web scraping...) where used to enrich our catalog. The batch and the online version of Dewey import processes are presented in [2]. HTH. Stefano [1] http://leo.cineca.it/index.php/jlis/article/view/8766 [2] http://www.slideshare.net/stefanobargioni/bargioni-dewey I want to collect dewey codes to complete my database. I was thinking about using z39.50 servers to get them but I have 2questions: - I want to use 2 different servers; one in marc21 and one in unimarc. As z39.50 only works for servers using the same format as me, Is there a way to collect the dewey code of the other server with an alternative? What about SRU ? - My second question is: When importing that dewey code, I dont want other data (like title author etc) to overwrite mines. How can I do that? Thx for responses, Frederic Edmont __ Il tuo 5x1000 al Patronato di San Girolamo della Carita' e' un gesto semplice ma di grande valore. Una tua firma aiutera' i sacerdoti ad essere piu' vicini alle esigenze di tutti noi. Aiutaci a formare sacerdoti e seminaristi provenienti dai 5 continenti indicando nella dichiarazione dei redditi il codice fiscale 97023980580. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Import in 3.14
Dear community, In Koha 3.14 I had to imported files with holdings two times, because at first it only replace items and second time it add new items. (Ifitem processing: replace items if matching bib was found(only for existing items). How can we solve it? Thanks ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Upgrade from source installation using repository
Dear all, How do I upgrade from source installation using Koha repository or is my option to upgrade using tar file only? My installation is Koha 3.12 which was installed using the tar file. Regards, Mesfin ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Request for Support to Integrate ElasticSearch into Koha
Dear Colleagues, I recently sent this message to ByWater Solutions partner institutions, but I would like to expand my call and solicit your support for integrating ElasticSearch http://www.elasticsearch.org/ into Koha. The goal is to add a new search engine next to the current Zebra search engine. This is a fundamental, strategic development that will ensure that Koha remains relevant in the coming years and that will benefit the entire Koha community. The current Zebra search engine works fine, but it is of a previous generation and has important limitations. In particular, it doesn't allow us to take full advantage of linked data. Koha currently links to Google Books and Scholar, Amazon, the Open Library, and WorlCat. This is wonderful, but automatic links to Google Books and Amazon are limited to recent publications with ISBN (in use only since the 1970s) and access to Google Scholar, the Open Library and WorldCat is limited to a title keyword search. With the proposed dependencies for implementing ElasticSearch http://www.elasticsearch.org/, we will expand these options and facilitate linking to most any repository by providing a MARC to RDF crosswalk and greater flexibility to ingest other metadata schemes. Providing libraries with the option to select ElasticSearch http://www.elasticsearch.org/ as their preferred search engine instead of Zebra (it is important to stress that this would be a choice), would open the door to linking to the full content of Google Books and the Hathi Trust, the Digital Public Library and other repositories, or to controlled vocabularies, such as the Library of Congress Authorities http://id.loc.gov/ or VIAF http://viaf.org/. Linking could be established on a number of criteria, including keywords, but also OCLC numbers and LCCN. In short, implementing Koha with ElasticSearch http://www.elasticsearch.org/ would open the world of linked data and permit Koha to function in a manner more similar to current discovery tools. Today, to benefit from the flexibility that discovery tools provide, you would have to implement one in addition to Koha. That means contracting with another company or developing your own. Few of us will be able to afford that. With ElasticSearch http://www.elasticsearch.org/, the Koha community would be able to gradually develop Koha to fulfill the same purpose, with the added benefit that the current development of ElasticSearch http://www.elasticsearch.org/ in Koha provides the option to browse the collection. In this manner, users would be able to perform powerful and fast keyword searches, as well as browse the collection by author, title, subject or call number, and link out to repositories for access to the full text or to controlled vocabularies. Currently we cannot browse the catalog in useful methods with Zebra. An additional benefit is that ElasticSearch http://www.elasticsearch.org/ will improve speed, as you can cluster the search engine and actually control and configure the configuration files to use more system resources. The initial data is cross-walked from MARC to JSON, which is a lightweight metadata schema and which will greatly improve speed. Finally, ElasticSearch http://www.elasticsearch.org/ is open source and, just like Koha, benefits from a dynamic community supporting its continued growth. To keep Koha relevant and to expand its functionality mattersto all of us and I would like to ask you to contribute to this development by contacting bren...@bywatersolutions.com or kath...@catalyst.net.nz -- please also feel free to contact me. Best regards from Rome, Sebastian Hierl *Koha Gruppo Italiano https://it-it.facebook.com/KohaGruppoItaliano* -- Sebastian Hierl, Ph.D. Drue Heinz Librarian, Arthur Janet C. Ross Library American Academy in Rome Via Angelo Masina 5 00153 Rome Italy T: +39 06 5846 417 F: +39 06 5810 788 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] About example with the 952 field
952 is a special field in Koha - it contains holdings data - otherwise known as the item information. http://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx) regards, Elaine On Fri, Jun 6, 2014 at 8:17 AM, zolot zo...@imath.kiev.ua wrote: Hi All, In Koha 3.14 Manual (en) there is the Tag 952 Subfield constraint table (see section '4.1.4. Edit Framework Subfield' of the chapter '2. Administration'). Why exactly 952 ? Is it accident ? Maybe, this field randomly has been selected as an example of the ordinary field ? Or, maybe, this is more essential, the 952 field is a special field in the Koha system ? For instance, not for cataloging but for a management ctalogues. Regards, Gennady ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- 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
Re: [Koha] Looking for more Serials Documentation help
We are just getting around to putting our serials in Koha and yes, I am baffled. I was hoping to use the system to help us better track the serials as they come in so we could claim missing issues in a timely fashion. But the couple attempts I made to set up a fairly simple subscription pattern didn't work as expected. So I'm adding my voice to the appeal - if anyone really understands this, expanding the manual to include more examples and more thorough explanations would really, really help. On Thu, Jun 5, 2014 at 4:44 PM, Hernandez, Heather heather_hernan...@nps.gov wrote: Hi! I have to admit that we find the serials module to be rather baffling. Although we are using it to check in new issues so that our patrons can get an email notification when new issues arrive, I couldn't really tell you why it's doing what it's doing, and I have to say that I'm far from understanding it. And I'm no serials system newbie--I've been using such systems since the days of Innovacq way before ILS's were twinkles in the eyes of developers--but getting our subscriptions to behave in a 'good enough' manner on Koha seems to have been rather hit and miss, and I haven't taken the time to fine tune them. I also haven't taken the time to figure out claiming, since I wasn't sure it would be a better solution than just walking around our Reading Room every now and then to eyeball what hasn't come in and just shooting an email off to the publisher to get our missing issue(s). Granted, we don't have a lot of current subscriptions! We also gave up on using Koha for acquisitions except for storing subscription vendors, since it doesn't meet our needs--federal purchasing is a bit byzantine, and we have no money to contribute towards developments. I'll keep my eyes open when receiving issues for subscriptions that could benefit from some work, and will try to compare things with the manual--if I can contribute anything, I'd be happy to do it--but I may just be contributing more questions! Cheerio, heather ~~ Heather Hernandez Technical Services Librarian San Francisco Maritime National Historical Park Research Center heather_hernan...@nps.gov 415-561-7032 (voice) 415-556-3540 (fax) http://www.nps.gov/safr/historyculture/museum-collections.htm The sailor does not pray for wind, he learns to sail.--Gustaf Lindborg ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- 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] Overdrive Integration
Hi! We're just about to go live with Koha. We've got our Overdrive integration set up, but in the Overdrive search results page all of the titles come up with links that start with http// rather than http://. In the list archive I see a discussion from March 2014 of a bug arising from a change in Overdrive's APIs. Was that the same issue I'm seeing? Anything I can do about it from my end? Thanks, Andrew Fuerste-Henry Adult Services Librarian Carnegie-Stout Public Library 360 West 11th Street Dubuque, IA 52001 (563) 589-4225 This message has been scanned for malware by Websense. www.websense.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Report help needed - filter by itemtype
I can't seem to get the report to filter on item type. Probably another typo somewhere. it works if I take out this line: biblioitems.itemtype=‘BK’ But I want to filter by books (and eventually other item types). SELECT ExtractValue(b.marcxml, '//datafield[@tag=100]/subfield[@code=a]'), ExtractValue(b.marcxml, '//datafield[@tag=245]/subfield[@code=a]'), ExtractValue(b.marcxml, '//datafield[@tag=245]/subfield[@code=b]'), ExtractValue(b.marcxml, '//datafield[@tag=245]/subfield[@code=c]'), ExtractValue(b.marcxml, '//datafield[@tag=260]/subfield[@code=a]'), ExtractValue(b.marcxml, '//datafield[@tag=773]/subfield[@code=t]'), ExtractValue(b.marcxml, '//datafield[@tag=773]/subfield[@code=g]'), ExtractValue(b.marcxml, '//datafield[@tag=260]/subfield[@code=b]'), ExtractValue(b.marcxml, '//datafield[@tag=260]/subfield[@code=c]'), ExtractValue(b.marcxml, '//datafield[@tag=300]/subfield[@code=a]'), ExtractValue(b.marcxml, '//datafield[@tag=020]/subfield[@code=a]'), ExtractValue(b.marcxml, '//datafield[@tag=022]/subfield[@code=a]'), monthname(datecreated) AS month, year(datecreated) AS year, biblionumber AS biblionumber LEFT JOIN biblioitems b USING (biblionumber) FROM biblio WHERE biblioitems.itemtype=‘BK’ AND datecreated BETWEEN Between (-mm-dd) AND and (-mm-dd) -- 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
Re: [Koha] Overdrive Integration
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11978 That's the patch that you need. On Fri, Jun 6, 2014 at 9:43 AM, Andrew Fuerste-Henry afuerste-he...@dubuque.lib.ia.us wrote: Hi! We're just about to go live with Koha. We've got our Overdrive integration set up, but in the Overdrive search results page all of the titles come up with links that start with http// rather than http://. In the list archive I see a discussion from March 2014 of a bug arising from a change in Overdrive's APIs. Was that the same issue I'm seeing? Anything I can do about it from my end? Thanks, Andrew Fuerste-Henry Adult Services Librarian Carnegie-Stout Public Library 360 West 11th Street Dubuque, IA 52001 (563) 589-4225 This message has been scanned for malware by Websense. www.websense.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- --- Brendan A. Gallagher ByWater Solutions CEO Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Headquarters: Santa Barbara, CA - Office: Redding, CT Phone # (888) 900-8944 http://bywatersolutions.com i...@bywatersolutions.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha