Re: Excel or CSV to METS or MODS

Hi,

I recently did some coding for Excel -> MARC/MARCXML/MARCMaker/ISIS within a
CGI application. MARCXML to MODS crosswalk should be trivial (Vortex [1]
provides it), although I never tried my hand in it. I used the following
modules for my app:

Spreadsheet::ParseExcel::Simple (for read-only parsing of Excel,
platform-independent)
MARC::Record
MARC::File::USMARC (comes default with MARC::Record)
MARC::File::XML
MARC::File::MARCMaker
MARC::File::ISIS (a customized version of MARC::File::USMARC for ISIS
format, modified ISO2709, used mostly by CDS/ISIS)
and of course the CGI related modules.

I've used Win32::OLE in the past for reading/writing Excel. Though it is
much more powerful, it requires Excel installed on the host machine.

I would be glad to share the code, mostly object-oriented. Let me know if
you are interested.

[1] http://www.vtls.com/opensource/vortex

Regards,
Saiful

-- 
Saiful Amin
+91-9343826438

On Thu, Dec 18, 2008 at 8:33 PM, Jacobs, Jane W <
[email protected]> wrote:

> Hi Folks,
>
> My New Year's resolution includes trying to wrap my mind around METS
> and/or MODS.  We recently discussed converting Excel/CSV to MARC, which
> I've done.  I know there's a schema that will take you from MARC to MODS
> and/or MADS (http://www.loc.gov/standards/mods/v3/mods-3-3.xsd) although
> I'm fuzzy as to the specifics of implementation.  However, that would
> mean Excel -> CSV -> MARC -> MODS, YUCK!
>
> Has anyone done any Excel to METS or MODS?  If yes, would you be willing
> to share some code?
>
> Thanks.
> JJ
>