Hello Tom,
Congratulations on developing an Excel based metadata generation program and
nice to hear that our work was useful. Further details are accessible at
http://wiki.dspace.org/index.php/Google_Summer_of_Code_2008_Batch_Import
If you wish please feel free to create a sub-section on the above Wiki so that
users can choose according to their preference.
Cheers!
Jayan
________________________________
From: [EMAIL PROTECTED] on behalf of Thomas A McGee
Sent: Mon 7/28/2008 9:32 PM
To: dspace-tech@lists.sourceforge.net; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [Dspace-tech] Excel Batch Import Tool
Speaking of making batch-importing more accessible, I've put together an Excel
spreadsheet that does a lot of the preparatory work. It was inspired by the
work the people at Nanyang Technological University had done, using a
spreadsheet that held the metadata and running it as a data source through a
Java application. My addition is to make it work completely within Excel.
A user will build their directory structure and populate it with the
bitstreams:
parent directory
>>subdirectory
>>>>bitstream1.jpg
>>>>bitstream2.jpg
>>subdirectory
>>>>bitstream3.pdf
And then fill out the columns and rows of the spreadsheet corresponding to each
subdirectory. Run the macro, and the dublin_core.xml and contents files are
generated and put into their corresponding subdirectories.
If you'd like to take a look at this work-in-progress drop me a line and I'll
send it to you. I've only tested in on Excel 2003 running on XP. There are
still a lot of refinements I want to do to make it easier, and also function
things like handling bundles.
You still have to use the command-line tool; this just prepares the necessary
directory.
_____________________
Tom McGee
Seton Hall University TLTC
973 761 9000 x5021
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
