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)
Jane,
I have a PHP command-line script that does Excel to MODS in an OAI wrapper, but
it's hard coded to the MODS elements we are using (i.e., I did it up for a
specific, never-ever-ever-to-change Excel template). I don't mind sharing it if
you think it would be useful.
Mark
Mark Jordan
Head
I don't know of anything pre-written, but there's a couple of Perl
modules for reading Excel files. I've know I've used the OLE
libraries (inherited code) but my memory is rusty. I thought there
was another one but couldn't find it. Of course, depending on the
format of the data within the
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