Hi Edward,
Like Mike, I have some existing tools that do this in perl - though very
hack-ish.
Basically, I set the Windows default field separator to pipe (because I
hate comma separated data) and save the spreadsheet as .csv, though a
pipe delimited one.
My perl then reads that in, and maps columns to DC elements and
OAI-header elements and spits out an XML file per row of the spreadsheet.
I'd be happy to pop a version of one of these into git-hub if you're
interested.
-corey
On 3/1/2011 3:59 PM, Edward M. Corrado wrote:
Hi Mike,
Yes, by Dublin Core, I mean OAI Dublin Core XML.
Edward
On Tue, Mar 1, 2011 at 3:34 PM, Michael J. Giarlo
<leftw...@alumni.rutgers.edu> wrote:
Edward,
Because I already have some code lying around that does more or less
the same thing, I'd probably sling some Python using the xlrd library
(N.B. works on xls files but not xlsx files). �It'd look similar to
this method, perhaps a little simpler, though this method doesn't
write out a DC file:
� � https://github.com/MaxFisher/caps/blob/master/pilot/views.py#L87
By "Dublin Core," I assume you mean OAI Dublin Core XML?
-Mike
On Tue, Mar 1, 2011 at 14:53, Edward M. Corrado<ecorr...@ecorrado.us> wrote:
Hello all,
I have an excel file that I need to map to Dublin Core. I can think of
a number of ways to do this, but was wondering if anyone else who has
done it has a suggestion before I dust off my old sed/awk skills or
otherwise reinvent the wheel. I looked at Terry Reese's MarcEdit and I
probably can use that, but it looks like I'd have to intermediately
convert it to MARC. Either a windows-based program or *nix tool is
fine.
Edward
--
Corey A Harper
Metadata Services Librarian
New York University Libraries
20 Cooper Square, 3rd Floor
New York, NY 10003-7112
212.998.2479
corey.har...@nyu.edu
