I think the example is missing Get Outlook for iOS<https://aka.ms/o0ukef> ________________________________ From: Koha <koha-bounces@lists.katipo.co.nz> on behalf of Katrin Fischer <katrin.fischer.83@web.de> Sent: Saturday, June 2, 2018 4:30:17 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Import the MARC21 with Item details Hi, you want one 952 for each item you want to import. Each 952 should have at least the following fields: $a and $b the branchcode configured in Koha $y the itemtype code configured in Koha $p barcode $o callnumber can be helpful too There should be no semicolons or whitespace like below: Hope that helps, Katrin On 02.06.2018 09:35, Laxmi Lal Menaria wrote:

Hello everyone,

I have marc21 file with more than 20K records, I would need to import in the Koha with the barcode, I have updated the Marc21 file with MarcExit tool and added items with 952, but still it doesn't reflect in the Koha catalog. When tried to use circulation it says invalid.

So please let me know how can I import marc21 file with barcode data.

For barcode I have tried these 2 things:

=952 \\$a2442 ;$b2442 ;$o2442 ;$p2442 ;$yBooks

=952 \\$p2442

Both are not working, please let me know how can I fix it.

_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Hi, I have tried the same but still barcode not listed, =952\\$aBR1$bBR1$oBR1-2442$p2442$yITEM001 Thanks, On Sat, Jun 2, 2018 at 8:50 PM, Michael Kuhn <mik@adminkuhn.ch> wrote:

Hi Laxmi Lal Menaria

You wrote:

...

I think the example is missing

Katrin wrote:

...

There should be no semicolons or whitespace like below: ... =952 \\$a2442 ;$b2442 ;$o2442 ;$p2442 ;$yBooks

So by omitting semicolons and whitespaces I guess Katrin is suggesting the following:

=952\\$a2442$b2442$o2442$p2442$yBooks

$a $b $o and $p all containing the same value "2442" seems wrong. Of course you should use the correct values according to your actual branchcode / itemtype code / callnumber / barcode - only your $yBooks seems correct (assuming "Books" is actually one of your configured itemtype codes).

...

$a and $b the branchcode configured in Koha $o callnumber $p barcode $y the itemtype code configured in Koha

In fact, myself I don't know about this syntax since I always create MARCXML records. In MARCXML MARC field 952 could look like this, for example:

<datafield tag="952" ind1=" " ind2=" "> <subfield code="a">KDZ</subfield> <subfield code="b">KDZ</subfield> <subfield code="o">KDZ-A-108-108</subfield> <subfield code="p">+XVK26608</subfield> <subfield code="y">BOOK</subfield> </datafield>

Hope this helps.

Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch

_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

-- Thanks, Laxmilal Menaria | +91 982 955 3793 | http://laxmilalmenaria.com/

I can see $a and $b values only, others are blank. On Mon, Jun 4, 2018 at 4:15 PM, Michael Kuhn <mik@adminkuhn.ch> wrote:

Hi

...

I have tried the same but still barcode not listed,

=952\\$aBR1$bBR1$oBR1-2442$p2442$yITEM001

Is only the barcode missing and the rest of the item data is imported - or is the item data not imported at all?

Be sure

1. you have defined a library with Code "BR1" in Koha menu "Koha administration > Libraries"

2. you have definded a media type with Code "ITEM001" Koha menu "Koha administration > Item types"

If this is both the case - what is your setting of Koha system preference "autoBarcode"?

Hope this helps.

Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch

-- Thanks, Laxmilal Menaria | +91 982 955 3793 | http://laxmilalmenaria.com/

Only one item type with code "ITEM001" and autoBarcode value is 'not generated automatically" Thanks, Laxmi Lal On Mon, Jun 4, 2018 at 8:45 PM, Michael Kuhn <mik@adminkuhn.ch> wrote:

Hi

...

I can see $a and $b values only, others are blank.

Have you definded a media type with Code "ITEM001" in Koha menu "Koha administration > Item types"?

What is your setting of Koha system preference "autoBarcode"?

Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch

-- Thanks, Laxmilal Menaria | +91 982 955 3793 | http://laxmilalmenaria.com/

Please find attached sample 10 records file Let me know if any issue with the file. On Wed, Jun 6, 2018 at 6:34 PM, Michael Kuhn <mik@adminkuhn.ch> wrote:

Hi

...

Only one item type with code "ITEM001"

and autoBarcode value is 'not generated automatically"

If I understand right everything seems correct now, but still you experience the problem. I have no further clues... (and I will be away until tomorrow evening).

Maybe it will help if you send the complete data record so people can see if there is something else that really causes the problem.

Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch

-- Thanks, Laxmilal Menaria | +91 982 955 3793 | http://laxmilalmenaria.com/

Hello, Hope this sample MARC record / example will help you. =LDR 02915nam 2200361Ia 4500 =008 180529s9999||||xx\||||||||||||||\||und|| =041 \\$aKannada =082 \\$a320.5 RAM =100 \\$aRamakrishna, H.T. =245 \\$aAdhunika Sarkaragalu$cHT Ramakrishna =260 \\$aTipatur$bLalitha Prkashana =300 \\$a278 =942 \\$cTB =952 \\$pG0001$d1994-01-23$o320.5$8POS$cGEN$ePrakasha Sahitya Bangalore$iDC Bill 2/93-94$xWrite off 2009-2010$g45$aGECH$bGECH$yTB$70 =952 \\$pG0002$d1994-01-23$o320.5$8POS$cGEN$ePrakasha Sahitya Bangalore$iDC Bill 2/93-94$xWrite off 2009-2010$g45$aGECH$bGECH$yTB$70 –---------- $p=barcode $y=Item Type Regards Satish MB Librarian Govt. Engineering College, Hassan. Karnataka.

I'm able to import but when I go to edit item details the barcode field is blank. Without barcode I am not able to do circulation system. Get Outlook for iOS<https://aka.ms/o0ukef> ________________________________ From: Indranil Das Gupta <indradg@gmail.com> Sent: Wednesday, June 6, 2018 11:23:58 PM To: koha@lists.katipo.co.nz Cc: Laxmi Lal Menaria Subject: Re: [Koha] Import the MARC21 with Item details Hi, One thing I can immediately see wrong with your records is that you have no 942 $c, which you really should. But that won't stop your records from being either staged or imported. By changing BR1 to CPL for 952 $a and $b and itype (942 $y) to BK, I could import all you records into 18.05 without any hiccup as you can see from the following screenshots: 1) https://ibin.co/w800/44NXuTfnw9yJ.png 2) https://ibin.co/w800/44NY6LG7Q8TQ.png So, if these records are not going into your system, you need to review your installation and config settings closely. hope this helps, Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 WWW : http://www.l2c2.co.in Blog : http://blog.l2c2.co.in IRC : indradg on irc://irc.freenode.net Twitter : indradg On Wed, Jun 6, 2018 at 10:59 PM, Laxmi Lal Menaria <menarialaxmilal@gmail.com> wrote:

Shared link:

https://www.amazon.com/clouddrive/share/jdltI5YoY66OTnJN8UGZ5YurvCcBSrETfX0j...

Get Outlook for iOS<https://aka.ms/o0ukef> ________________________________ From: Laxmi Lal Menaria <menarialaxmilal@gmail.com> Sent: Wednesday, June 6, 2018 8:23:42 PM To: Michael Kuhn Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Import the MARC21 with Item details

Please find attached sample 10 records file

Let me know if any issue with the file.

On Wed, Jun 6, 2018 at 6:34 PM, Michael Kuhn <mik@adminkuhn.ch<mailto:mik@adminkuhn.ch>> wrote: Hi

...

Only one item type with code "ITEM001"

and autoBarcode value is 'not generated automatically"

If I understand right everything seems correct now, but still you experience the problem. I have no further clues... (and I will be away until tomorrow evening).

Maybe it will help if you send the complete data record so people can see if there is something else that really causes the problem.

Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch<mailto:mik@adminkuhn.ch> · W www.adminkuhn.ch<http://www.adminkuhn.ch>

--

Thanks, Laxmilal Menaria | +91 982 955 3793 | http://laxmilalmenaria.com/

_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Hi, After adding the "shelving location" it works. Thank you for your support. I have tried with the default configuration of the KOHA with these installation steps. http://cloud-computing.solutions/how-to-install-koha-a-library-software-on-u... Thanks again. On Fri, Jun 8, 2018 at 5:40 AM, Michael Kuhn <mik@adminkuhn.ch> wrote:

Hi

...

Please find attached sample 10 records file

Let me know if any issue with the file. ... https://www.amazon.com/clouddrive/share/jdltI5YoY66OTnJN8UGZ 5YurvCcBSrETfX0juT0G2ub

No issue, the content of your file is syntactically correct und sufficiently complete (but you should however also use MARC 942 $c, as Indranil Das Gupta has pointed out).

I have downloaded your file "10records.mrc". I created a library with code BR1, I created a media type with code ITEM001, then uploaded and imported the records from your file into my Koha 18.05 demo installation, using the standard framework. All records were imported correctly, including the barcode.

Since it worked without problems in my demo installation I guess there has to be some configuration issue in your installation.

Did you control if there is any 952 $p in the framework that you're using when importuing your data?

...

I'm able to import but when I go to edit item details the barcode field is blank. Without barcode I am not able to do circulation system.

Or is there maybe a misunderstanding? If you're clicking on "Edit item" you will see

a) the existing items in a table at the very top - basically just one long line, with the barcode filled

b) the section "Add item" - well, to add a new item. This section has many empty fields, of course the "barcode" field is empty too, because in a new item you would first have to fill it.

Hope this helps.

Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch

-- Thanks, Laxmilal Menaria | +91 982 955 3793 | http://laxmilalmenaria.com/