[Koha] Problem in Data conversion excel to marc

[John Palmer]

Try this approach to create your Marc data from excel files.
http://manual.koha-community.org/3.2/en/marceditexcel.html

The one step that needs to be added is in the Marc Delimited Text
Translator. Before you press finish, right-click on all the 952 fields and
join them together. This gives a clean input of the 952 data and only adds
one item per excel row.




On Wed, Nov 27, 2013 at 10:57 PM, Vinod Kumar Mishra <
vinod_librarian at rediffmail.com> wrote:

> Dear,
>
> The option is given in maredit to change all at once, you have to use the
> tricks so kindly convert all the record in marc format and use the trick
> and options given to modify,delete,swap etc.
>
> On Thu, 28 Nov 2013 10:58:02 +0530  wrote
> >Dear sir,
> We have data of 25000 records. while converting the marc format from excel
> sheet can i tag the below mentioned items. in the excel sheet directly.
> * tag number for Koha item type
> * tag number for barcode
> * tag number for Shelving location
>
> i have tired to give this tags but i cannot able to do it. the record or
> on the hold. it is difficult change one by one record.
>
> Can i have the solution for this. It will be very help to me change in one
> time.
>
>
> Server information:
>             Koha version: 3.14.00.000
>             OS version ('uname -a'): Linux library 3.2.0-56-generic-pae
> #86-Ubuntu SMP Wed Oct 23 17:51:27 UTC 2013 i686 i686 i386 GNU/Linux
>
>             Perl interpreter: /usr/bin/perl
>             Perl version: 5.014002
>             Perl @INC:
>
>                     /usr/share/koha/lib
>
>
>                     /etc/perl
>
>
>                     /usr/local/lib/perl/5.14.2
>
>
>                     /usr/local/share/perl/5.14.2
>
>
>                     /usr/lib/perl5
>
>
>                     /usr/share/perl5
>
>
>                     /usr/lib/perl/5.14
>
>
>                     /usr/share/perl/5.14
>
>
>                     /usr/local/lib/site_perl
>
>
>                     .
>
>
>
>             MySQL version: mysql  Ver 14.14 Distrib 5.5.34, for
> debian-linux-gnu (i686) using readline 6.2
>
>             Apache version: Server version: Apache/2.2.22 (Ubuntu)
>
>             Zebra version: Zebra 2.0.44
> (C) 1994-2010, Index Data ApS
> Zebra is free software, covered by the GNU General Public License, and you
> are
> welcome to change it and/or distribute copies of it under certain
> conditions.
> SHA1 ID: 419ad759807269fdfa379799a051ed3a551c6541
> Using ICU
>
> With regards,
> Madhu KB
> LibraryBITS-Pilani, Hyderabad Campus.
>
>
>
> With regards,
> Vinod Kumar Mishra,
> Assistant Librarian,
> Biju Patnaik Central Library,
> NIT Rourkela,
> Mob:91+9439420860
>     91+6612462103 (O)
> email: vinod_librarian at rediffmail.com
>      : mishravk79 at gmail.com
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>