[EP-tech] Re: Change EPrint field type.

[sf2]

Hola Brian, 

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"). 

Also.. in doubt, back up your DB before making the change. 

Seb 

On 09.12.2014 19:03, Brian D. Gregg wrote: 

> All, 
> 
> 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. 
> 
> 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. 
> 
> 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? 
> 
> Any help would be appreciated. 
> 
> Thanks in advance, 
> 
> Brian. 
> 
> BRIAN D. GREGG 
> 
> _Solutions Architect _|_ Manager Systems Development_ 
> 
> University of Pittsburgh | University Library System 
> 
> Address: 7500 Thomas Blvd. Room 129 Pittsburgh, PA 15208 [5] 
> 
> Tel: (412) 648-3264 | Email: bdgregg at pitt.edu | Fax: (412) 648-3585 
> 
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech [1]
> *** Archive: http://www.eprints.org/tech.php/ [2]
> *** EPrints community wiki: http://wiki.eprints.org/ [3]
> *** EPrints developers Forum: http://forum.eprints.org/ [4]

 

Links:
------
[1] http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
[2] http://www.eprints.org/tech.php/
[3] http://wiki.eprints.org/
[4] http://forum.eprints.org/
[5]
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20141209/1f307502/attachment.html