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_librar...@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_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 > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha