<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<html><body style='font-family: Verdana,Geneva,sans-serif'>
<p>Hola Brian,</p>
<p>You should be able to change it directly to "id" and run epadmin update_database_structure - it will be the no-op since "text" and "id" have the same db field definition. (in fact if you look at the source code, you'll see that "text" is a special case of "id").</p>
<p>Also.. in doubt, back up your DB before making the change.</p>
<p>Seb</p>
<p>On 09.12.2014 19:03, Brian D. Gregg wrote:</p>
<blockquote type="cite" style="padding-left:5px; border-left:#1010ff 2px solid; margin-left:5px"><!-- html ignored --><!-- head ignored --><!-- meta ignored --><!-- meta ignored --><!-- node type 8 --><!-- node type 8 -->
<div class="WordSection1">
<p class="MsoNormal">All,<!-- o ignored --></p>
<p class="MsoNormal"><!-- o ignored --> </p>
<p class="MsoNormal">We have an EPrint field that we intended to use to hold ORCIDs originally defined as ‘type’ => ‘text’ and we have done so and thus we have data in the fields already. <!-- o ignored --></p>
<p class="MsoNormal"><!-- o ignored --> </p>
<p class="MsoNormal">The problem is that an advanced search for an ORCID ID will return more than just the exact ORCID ID due to the fuzzy matching imposed on a ‘text’ field. I was advised to change this to ‘type’ => ‘id’ to force the advanced search to use exact matching.<!-- o ignored --></p>
<p class="MsoNormal"><!-- o ignored --> </p>
<p class="MsoNormal">My question is how can I change this field to ‘type’ => ’id’ including any database changes if they are needed (we are using MySQL)? Obviously we edit the eprint_fields.pl file and change the definition, but what if anything else needs to be done on the database backend to accommodate this change?<!-- o ignored --></p>
<p class="MsoNormal"><!-- o ignored --> </p>
<p class="MsoNormal">Any help would be appreciated.<!-- o ignored --></p>
<p class="MsoNormal"><!-- o ignored --> </p>
<p class="MsoNormal">Thanks in advance,<!-- o ignored --></p>
<p class="MsoNormal">Brian.<!-- o ignored --></p>
<p class="MsoNormal"><!-- o ignored --> </p>
<p class="MsoNormal"><strong><span style="font-size: 18.0pt; color: #323e4f;">Brian D. Gregg<!-- o ignored --></span></strong></p>
<p class="MsoNormal"><em><span style="font-size: 14.0pt; color: #323e4f;">Solutions Architect </span></em><span style="font-size: 14.0pt; color: #323e4f;">|<em> Manager Systems Development<!-- o ignored --></em></span></p>
<p class="MsoNormal"><span style="color: #323e4f;">University of Pittsburgh | University Library System<!-- o ignored --></span></p>
<p class="MsoNormal"><span style="color: #323e4f;">Address: <a href="https://maps.google.com/maps?q=7500+Thomas+Blvd,+Pittsburgh,+PA&hl=en&sll=41.117935,-77.604698&sspn=7.662465,13.73291&oq=7500+Tho&t=h&hnear=7500+Thomas+Blvd,+Pittsburgh,+Pennsylvania+15208&z=17"> 7500 Thomas Blvd. Room 129 Pittsburgh, PA 15208</a><!-- o ignored --></span></p>
<p class="MsoNormal"><span style="color: #17365d;">Tel: (412) 648-3264 | Email: <a href="mailto:bdgregg@pitt.edu"> bdgregg@pitt.edu</a> | Fax: (412) 648-3585<!-- o ignored --></span></p>
<p class="MsoNormal"><!-- o ignored --> </p>
</div>
<!-- html ignored --><br />
<pre>*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<p> </p>
<div> </div>
</body></html>