Like Mike, I have some existing tools that do this in perl - though very
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
On 3/1/2011 3:59 PM, Edward M. Corrado wrote:
> Hi Mike,
> Yes, by Dublin Core, I mean OAI Dublin Core XML.
> On Tue, Mar 1, 2011 at 3:34 PM, Michael J. Giarlo
> <[log in to unmask]> wrote:
>> 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?
>> On Tue, Mar 1, 2011 at 14:53, Edward M. Corrado<[log in to unmask]> 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
Corey A Harper
Metadata Services Librarian
New York University Libraries
20 Cooper Square, 3rd Floor
New York, NY 10003-7112
[log in to unmask]