Re: [Koha] How to remove unwanted characters when importing MARC data? [SOLVED]

2017-06-21 Thread Michael Kuhn
Hi Yesterday I wrote: Our library receives MARC data from EKZ (a German cataloging data provider) which includes two unwanted characters: * a beginning "non-sorting character" * an ending "non-sorting character" These characters can't be seen in the OPAC and in the hitlist of the staff clie

Re: [Koha] Schema question

2017-06-21 Thread Ricardo Ruiz
Hi Tomas, This is not the case of a bug, I just wanted to be clear about the storage process for a migration process that I'm going to do. Thank you very much for your help. Regards 2017-06-21 16:40 GMT-05:00 Tomas Cohen Ara

Re: [Koha] Schema question

2017-06-21 Thread Tomas Cohen Arazi
The MARC::Record library which we use to parse that kind of data, preserves the subfield order. So it won't modify =650 $a History $z Colombia and storage will be different if it gets =650 $z Colombia $a History If such wasn't the case, you might have found a bug. Then you should provide with

Re: [Koha] Schema question

2017-06-21 Thread Ricardo Ruiz
Thanks Tomas, for your answer. And in this regard I ask you the following: if I import in koha a .mrc file in koha which contains a record with this information: = 650 \\ $ History $ z Colombia will MARCXML storage maintain this order? MARCXML storage will be different if the information is: = 65

Re: [Koha] Schema question

2017-06-21 Thread Tomas Cohen Arazi
That's stored on the MARCXML data itself. El mié., 21 jun. 2017 a las 17:48, Ricardo Ruiz () escribió: > Hi All, > > In the bib editor the user can reorder subfields (upSubfield), in which > table or place is this new ordering information stored? > > > Thanks, > Ricardo > > __

[Koha] Schema question

2017-06-21 Thread Ricardo Ruiz
Hi All, In the bib editor the user can reorder subfields (upSubfield), in which table or place is this new ordering information stored? Thanks, Ricardo

Re: [Koha] How to remove unwanted characters when importing MARC data?

2017-06-21 Thread Michael Kuhn
Hi Brooke Not yet. As I wrote it should be an easy way (which can be handled by an unsuspecting librarian several times a year). We hoped there is an easier way than install even more software and learn how to use it. After all it's just deleting two characters. But well, I know... "just" and "o

Re: [Koha] How to remove unwanted characters when importing MARC data?

2017-06-21 Thread BWS Johnson
Salvete! >> Not yet. As I wrote it should be an easy way (which can be handled by an unsuspecting librarian several times a year). We hoped there is an easier way than install even more software and learn how to use it. After all it's just deleting two characters. But well, I know... "just" an

Re: [Koha] How to remove unwanted characters when importing MARC data?

2017-06-21 Thread Michael Kuhn
Hi Marc Did you try marcedit? http://marcedit.reeset.net/ Not yet. As I wrote it should be an easy way (which can be handled by an unsuspecting librarian several times a year). We hoped there is an easier way than install even more software and learn how to use it. After all it's just delet

Re: [Koha] How to remove unwanted characters when importing MARC data?

2017-06-21 Thread Marc Véron
Hi Michael Did you try marcedit? http://marcedit.reeset.net/ Kind regards Marc Véron Am 21.06.2017 um 18:55 schrieb Michael Kuhn: Hi Our library receives MARC data from EKZ (a German cataloging data provider) which includes two unwanted characters: * a beginning "non-sorting character" *

Re: [Koha] How to remove unwanted characters when importing MARC data?

2017-06-21 Thread Michael Kuhn
Hi Pedro I don't think you'll find an easy way within Koha to do that, maybe bulk edit but I don't know, haven't used it. From our experience - we've had all sorts of unwanted data like the one you're experiencing and worst - MARCXML is the way to go. Assuming the MARC file is well-formed, c

Re: [Koha] How to remove unwanted characters when importing MARC data?

2017-06-21 Thread Michael Kuhn
Hi Jonathan Take a look at C4::Charset::nsb_clean I guess you can add more substitutions there. Trouble is I don't know anything about "C4::Charset::nsb_clean". I understand it is a Perl module, but I don't know how to use Perl (excepet of some small stuff like changing existing scripts). So

Re: [Koha] How to remove unwanted characters when importing MARC data?

2017-06-21 Thread Jonathan Druart
Take a look at C4::Charset::nsb_clean I guess you can add more substitutions there. On Wed, 21 Jun 2017 at 13:55 Michael Kuhn wrote: > Hi > > Our library receives MARC data from EKZ (a German cataloging data > provider) which includes two unwanted characters: > > * a beginning "non-sorting chara

Re: [Koha] How to remove unwanted characters when importing MARC data?

2017-06-21 Thread Pedro Amorim
Hello Michael, I don't think you'll find an easy way within Koha to do that, maybe bulk edit but I don't know, haven't used it. From our experience - we've had all sorts of unwanted data like the one you're experiencing and worst - MARCXML is the way to go. Assuming the MARC file is well-formed,

[Koha] How to remove unwanted characters when importing MARC data?

2017-06-21 Thread Michael Kuhn
Hi Our library receives MARC data from EKZ (a German cataloging data provider) which includes two unwanted characters: * a beginning "non-sorting character" * an ending "non-sorting character" These characters can't be seen in the OPAC and in the hitlist of the staff client, but they do appe

[Koha] MARC Load Error

2017-06-21 Thread Lamb Joseph
I was hoping to get some direction or more logging for an error please. While staging a MARC records from my old library system, I get "use of uninitialized value $tag in hash" from /usr/share/perl5/MARC/Record.pm line 202. I opened up record.pm at line 202 and the field is I.  245?.  I am not sur

Re: [Koha] How to get use of asort1 and asort2?

2017-06-21 Thread vinod mishra
Thanks Katrin, i understand which works fine. With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 Website: http://mishravk.com/ *"Spiritual relationship is far more precious than physical.

[Koha] How to get use of asort1 and asort2?

2017-06-21 Thread vinod mishra
Dear All, How to get use of asort1 and asort2? i entered value in authorized values field for that under asort1 and asort2 but it does not reflect in book data entry under statistics1 and statistics2, however, bsort1 and bsort2 values reflect as drop down under the patron data entry field. Koha ver