Walter,
If you can extract the data out in a cvs file, you could import it
into an excel
spreadsheet and clean the data up and get it ready to batch import
into DSpace.
Would you be adding bitstreams to this data at this time? If so,
there is an OhioLINK
tool that will let you use an excel spreadsheet and through proper
preparation
you can create the batch importing that DSpace explains in some detail
in the documentation.
(cf. 9.5 Item Importer and Exporter the most recent documentation).
Go to this link and look at the bulk-submission form and see it will
help you:
http://sites.google.com/a/ohiolink.edu/drmc/bulk-submission
If you wanted to migrate just the data over without the metadata, then
DSpace 1.6
will have a tool that can take an excel spreadsheet and upload it in
batch into
DSpace.
Hope this helps.
Jeffrey Trimble
System LIbrarian
William F. Maag Library
Youngstown State University
330.941.2483 (Office)
[email protected]
http://www.maag.ysu.edu
http://digital.maag.ysu.edu
"I must not fear. Fear is the mind-killer.
I will permit it to pass over me and through me..."
--Litany against fear....
On Aug 4, 2009, at 5:12 PM, Walker Sampson wrote:
Hey guys,
Thanks for the info, this has been extremely helpful! Here are a few
more details:
The MySQL database was used with a PHP front-end and was not part of a
DSpace installation. It contains simple textual metadata for each
record; these are not Dublin Core elements. The MySQL database doesn't
store any bitstreams. There are about 1500+ records in the MySQL
database.
Regarding writing a script to write the records in a Dublin Core XML
file, is there a scripting language you suggest? We're running a
CentOS 5 server here.
Thanks again!
On Tue, Aug 4, 2009 at 2:52 PM, Jeffrey Trimble<[email protected]>
wrote:
Walker,
Well, that depends. You could map out an extraction file to the
PostgreSQL,
but
I guess the bigger question is what purposes was the MySQL used
for? Was it
a prior
DSpace installation? (That would make the process somewhat easier).
Are these records in MySQL storing Dublin Core Metadata + the
bitstream?
In a future release there will be a batch editing program that
**might** (I
use caution here)
assist you with the data. Also, there is an excel macro tool that
OhioLINK
uses
to load records and their associated Metadata into DSpace.
I think you question needs a little more detail before a solid
answer could
be given to you.
Best wishes,
Jeffrey Trimble
System LIbrarian
William F. Maag Library
Youngstown State University
330.941.2483 (Office)
[email protected]
http://www.maag.ysu.edu
http://digital.maag.ysu.edu
"I must not fear. Fear is the mind-killer.
I will permit it to pass over me and through me..."
--Litany against fear....
On Aug 4, 2009, at 3:28 PM, Walker Sampso Apple-interchange-newline">
Hi all,
Apologies in advance if this has already been covered.
I have a lot of records stored in a MySQL database. I've just got an
instance of DSpace up, and I'd like to migrate the records from MySQL
to a collection in DSpace. Has anyone done something similar to this
or know what some first steps would be?
Thank you,
Walker
_______________________________________________
Dspace-general mailing list
[email protected]
http://mailman.mit.edu/mailman/listinfo/dspace-general
--
Walker Sampson
MS in Information Studies, Expected 2010
School of Information, UT Austin
http://www.ischool.utexas.edu/~walker
_______________________________________________
Dspace-general mailing list
[email protected]
http://mailman.mit.edu/mailman/listinfo/dspace-general
