<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Georgia;
        panose-1:2 4 5 2 5 4 5 2 3 3;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
        {font-family:Verdana;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";
        mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:#0563C1;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:#954F72;
        text-decoration:underline;}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";}
span.EmailStyle17
        {mso-style-type:personal;
        font-family:"Verdana","sans-serif";
        color:windowtext;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:Consolas;
        mso-fareast-language:EN-US;}
span.EmailStyle20
        {mso-style-type:personal-reply;
        font-family:"Georgia","serif";
        color:#0F243E;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-AU link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#0F243E'>I can&#8217;t speak to &#8220;best practice&#8221;, but we often have to do bulk imports/updates over dozens or hundreds of records.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#0F243E'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#0F243E'>Usually our data people give me a spreadsheet (they have templates for common sets of fields for common actions), which I convert to EPrintsXML using an arcane mix of scripts and manual tweaks, and then import using </span><span style='font-family:"Courier New";color:#0F243E'>bin/import</span><span style='font-family:"Georgia","serif";color:#0F243E'><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#0F243E'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#0F243E'>Lots of </span><span style='font-family:"Courier New";color:#0F243E'>--parse-only</span><span style='font-family:"Georgia","serif";color:#0F243E'> is used.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#0F243E'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#0F243E'>Cheers<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:6.0pt;font-family:"Courier New";color:#003366;mso-fareast-language:EN-AU'>-- <o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:gray;mso-fareast-language:EN-AU'><a href="http://staff.qut.edu.au/details?id=kerwinm"><span style='color:gray;text-decoration:none'>Matthew</span><span style='color:gray;font-weight:normal;text-decoration:none'>&nbsp;</span><span style='color:gray;text-decoration:none'>Kerwin</span></a></span></b><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A;mso-fareast-language:EN-AU'>&nbsp;</span></b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A;mso-fareast-language:EN-AU'>|&nbsp;ITS-EIS:AS:LS&nbsp;|&nbsp;</span><u><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7F7F7F;mso-fareast-language:EN-AU'><a href="https://map.what3words.com/cards.reader.steer"><span style='color:#7F7F7F'>KG-SYN</span></a></span></u><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A;mso-fareast-language:EN-AU'>&nbsp;|&nbsp;QUT</span><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:#7A7A7A;mso-fareast-language:EN-AU'><o:p></o:p></span></p></div><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#0F243E'><o:p>&nbsp;</o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-AU'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-AU'> eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk] <b>On Behalf Of </b>Matthew Brady<br><b>Sent:</b> Wednesday, 1 March 2017 11:01<br><b>To:</b> eprints-tech@ecs.soton.ac.uk<br><b>Subject:</b> [EP-tech] What's the ideal method for importing records<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Hi All,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Just wondering how everyone handles importing of records into ePrints.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>I have a situation where I have access to the metadata for over 1000 records to import, but the import process is still a little mysterious.. My last export/import was when we migrated from 2.x to 3.x.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>I would prefer to create an ePrints XML structure, with as much detail as possible, and let ePrints ingest the records&#8230;, rather than skip the flat file creation and just cram it into the database..<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>But if anyone has any other thoughts on &#8216;best practice&#8217;, I would love to hear it, so let me know.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Cheers<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Matt.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p>&nbsp;</o:p></span></p><pre><o:p>&nbsp;</o:p></pre><pre>_____________________________________________________________<o:p></o:p></pre><pre>This email (including any attached files) is confidential and is for the intended recipient(s) only. If you received this email by mistake, please, as a courtesy, tell the sender, then delete this email.<o:p></o:p></pre><pre><o:p>&nbsp;</o:p></pre><pre>The views and opinions are the originator's and do not necessarily reflect those of the University of Southern Queensland. Although all reasonable precautions were taken to ensure that this email contained no viruses at the time it was sent we accept no liability for any losses arising from its receipt.<o:p></o:p></pre><pre><o:p>&nbsp;</o:p></pre><pre>The University of Southern Queensland is a registered provider of education with the Australian Government.<o:p></o:p></pre><pre>(CRICOS Institution Code QLD 00244B / NSW 02225M, TEQSA PRV12081 )<o:p></o:p></pre></div></body></html>