On Wed, Nov 12, 2008 at 11:03 PM, Yan Liao <[EMAIL PROTECTED]> wrote:

> Does any one know how to trans data from Excel to MARC? There is a rush
> local project and I don't have time to review my PERL class notes.
>

The best method would be to convert the Excel file into a delimited text
file (using 'Save As ..') and use MARC::Record to write the MARC data by
hand. There is a marvelous tutorial available for this module [1] with lot
of real examples. Once you get comfortable with this module you probably
won't look anywhere else for MARC related jobs in future.

Having said that, I've just started working on a personal project of
creating a web-based utility to enable conversion of Excel data into MARC21.
You can have look at the pre-alpha version in [2]. It is far from complete,
e.g., the download option in iso2709 or marcxml is yet to be written. Any
feedback would be welcome.

[1]
http://search.cpan.org/~mikery/MARC-Record-2.0.0/lib/MARC/Doc/Tutorial.pod
[2] http://122.166.0.252/cgi-bin/xl2marc.pl

-- 
Saiful Amin

Edutech India Pvt Ltd
Bangalore, India.
www.edutech.com

Reply via email to