<br><font size=2 face="sans-serif">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 </font><font size=2 color=#000080 face="Arial">Nanyang
Technological University</font><font size=2 face="sans-serif"> 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. </font>
<br>
<br><font size=2 face="sans-serif">A user will build their directory structure
and populate it with the bitstreams:</font>
<br>
<br><font size=2 face="sans-serif">parent directory</font>
<br><font size=2 face="sans-serif">>>subdirectory</font>
<br><font size=2 face="sans-serif">>>>>bitstream1.jpg</font>
<br><font size=2 face="sans-serif">>>>>bitstream2.jpg</font>
<br><font size=2 face="sans-serif">>>subdirectory</font>
<br><font size=2 face="sans-serif">>>>>bitstream3.pdf</font>
<br>
<br><font size=2 face="sans-serif">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. </font>
<br>
<br><font size=2 face="sans-serif">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.
</font>
<br>
<br><font size=2 face="sans-serif">You still have to use the command-line
tool; this just prepares the necessary directory. </font>
<br><font size=2 face="sans-serif"><br>
_____________________<br>
Tom McGee<br>
Seton Hall University TLTC<br>
973 761 9000 x5021</font>