Sam, thanks for the PHP script. I'll see what I can do with it to let it work with MySQL instead.
This project is a bit down the line but it doesn't hurt to plan. I'll let you all know what the solution ends up being! -Walker On Tue, Aug 4, 2009 at 4:12 PM, Walker Sampson<[email protected]> 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 > -- 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
