<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Walter,<div><br></div><div>If you can extract the data out in a cvs file, you could import it into an excel</div><div>spreadsheet and clean the data up and get it ready to batch import into DSpace.</div><div>Would you be adding bitstreams to this data at this time? If so, there is an OhioLINK</div><div>tool that will let you use an excel spreadsheet and through proper preparation</div><div>you can create the batch importing that DSpace explains in some detail in the documentation.</div><div>(cf. 9.5 Item Importer and Exporter the most recent documentation).</div><div><br></div><div>Go to this link and look at the bulk-submission form and see it will help you:</div><div><br></div><div><span class="Apple-style-span" style="font-family: monospace; "><a href="http://sites.google.com/a/ohiolink.edu/drmc/bulk-submission">http://sites.google.com/a/ohiolink.edu/drmc/bulk
-submiss
<br></div><div>If you wanted to migrate just the data over without the metadata, then DSpace 1.6</div><div>will have a tool that can take an excel spreadsheet and upload it in batch into</div><div>DSpace.</div><div><br></div><div>Hope this helps.</div><div><br></div><div><div apple-content-edited="true"> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="
border-c
rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><span class="Apple-style-span" style="font-size: 12px; "><div>Jeffrey Trimble</div><div>System LIbrarian</div><div>William F. Maag Library</div><div>Youngstown State University</div><div>330.941.2483 (Office)</div><div><a href="mailto:jtrimble@cc.ysu.edu">jtrimble@cc.ysu.edu</a></div><div><a href="http://www.maag.ysu.edu">http://www.maag.ysu.edu</a></div><div><a href="http://digital.maag.ysu.edu">http://digital.maag.ysu.
edu</a><
r. Fear is the mind-killer.</div><div>I will permit it to pass over me and through me..."</div><div>--Litany against fear....</div></span></div></div></span></div></span> </div><br><div><div>On Aug 4, 2009, at 5:12 PM, Walker Sampson wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Hey guys,<br><br>Thanks for the info, this has been extremely helpful! Here are a few<br>more details:<br><br>The MySQL database was used with a PHP front-end and was not part of a<br>DSpace installation. It contains simple textual metadata for each<br>record; these are not Dublin Core elements. The MySQL database doesn't<br>store any bitstreams. There are about 1500+ records in the MySQL<br>database.<br><br>Regarding writing a script to write the records in a Dublin Core XML<br>file, is there a scripting language you suggest? We're running a<br>CentOS 5 server here.<br><br>Thanks again!<br><br>On Tue, Aug 4, 2009 at 2:52 PM, Jeffrey Trimble<<a href="mailto:ja
trimble@
u</a>> wrote:<br><blockquote type="cite">Walker,<br></blockquote><blockquote type="cite">Well, that depends. You could map out an extraction file to the PostgreSQL,<br></blockquote><blockquote type="cite">but<br></blockquote><blockquote type="cite">I guess the bigger question is what purposes was the MySQL used for? Was it<br></blockquote><blockquote type="cite">a prior<br></blockquote><blockquote type="cite">DSpace installation? (That would make the process somewhat easier).<br></blockquote><blockquote type="cite">Are these records in MySQL storing Dublin Core Metadata + the bitstream?<br></blockquote><blockquote type="cite">In a future release there will be a batch editing program that **might** (I<br></blockquote><blockquote type="cite">use caution here)<br></blockquote><blockquote type="cite">assist you with the data. Also, there is an excel macro tool that OhioLINK<br></blockquote><blockquote type="cite">uses<br></blockquote><blockquote type="c
ite">to
sociated Metadata into DSpace.<br></blockquote><blockquote type="cite">I think you question needs a little more detail before a solid answer could<br></blockquote><blockquote type="cite">be given to you.<br></blockquote><blockquote type="cite">Best wishes,<br></blockquote><blockquote type="cite">Jeffrey Trimble<br></blockquote><blockquote type="cite">System LIbrarian<br></blockquote><blockquote type="cite">William F. Maag Library<br></blockquote><blockquote type="cite">Youngstown State University<br></blockquote><blockquote type="cite">330.941.2483 (Office)<br></blockquote><blockquote type="cite"><a href="mailto:jtrimble@cc.ysu.edu">jtrimble@cc.ysu.edu</a><br></blockquote><blockquote type="cite"><a href="http://www.maag.ysu.edu">http://www.maag.ysu.edu</a><br></blockquote><blockquote type="cite"><a href="http://digital.maag.ysu.edu">http://digital.maag.ysu.edu</a><br></blockquote><blockquote type="cite">"I must not fear. Fear is the mind-killer.<br></blockquote><b
lockquot
it it to pass over me and through me..."<br></blockquote><blockquote type="cite">--Litany against fear....<br></blockquote><blockquote type="cite">On Aug 4, 2009, at 3:28 PM, Walker Sampso Apple-interchange-newline"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Hi all,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Apologies in advance if this has already been covered.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I have a lot of records stored in a MySQL database. I've just got an<br></blockquote><blockquote type="cite">instance of DSpace up, and I'd like to migrate the records from MySQL<br></blockquote><blockquote type="cite">to a collection in DSpace. Has anyone done something similar to this<br></blockquote><blockquote type="cite">or know what some first steps would be?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Thank you,<br><
/blockqu
e">Walker<br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">Dspace-general mailing list<br></blockquote><blockquote type="cite"><a href="mailto:Dspace-general@mit.edu">Dspace-general@mit.edu</a><br></blockquote><blockquote type="cite"><a href="http://mailman.mit.edu/mailman/listinfo/dspace-general">http://mailman.mit.edu/mailman/listinfo/dspace-general</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><br><br><br>-- <br>Walker Sampson<br>MS in Information Studies, Expected 2010<br>School of Information, UT Austin<br><a href="http://www.ischool.utexas.edu/~walker">http://www.ischool.utexas.edu/~walker</a><br></div></blockquote></div><br></div></body></html>