Jane,
I've got perl code for converting text renderings of MARC records to
MARCXML and MODS. If you share your csv file, I can probably tell how
much trouble it would be to adapt my code to work with your data.
-Harrison
On Thu, Dec 18, 2008 at 7:03 AM, Jacobs, Jane W
wrote:
> Hi Folks,
>
>
>
>
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 par
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 excel
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
