The metadata export didn't delimit properly.  May be due to some commas in
the text_value field not getting escaped or encapsulated properly.  The
data didn't line up quite right with the headers when viewed in Excel.  I
was reluctant to import it back in.

What I did instead was run this update against the metadatavalue table in
the database.
-------------------------------------------------
UPDATE metadatavalue
SET text_value = REPLACE(text_value, 'http://hdl.handle.net/', '
http://centralspace-test.ucmo.edu/handle/')
WHERE text_value LIKE 'http://hdl.handle.net/%'
-------------------------------------------------

Thanks again,
Shannon
--
Mr. Shannon Meisenheimer
Office of Technology
Blackboard and Academic Application Management
University of Central Missouri
Dockery 207A
meisenhei...@ucmo.edu
Work Phone:  (660) 543-8483


On Thu, Jul 2, 2015 at 9:23 AM, Tim Donohue <tdono...@duraspace.org> wrote:

>  Hi Shannon,
>
> (I'm copying back in dspace-tech. We prefer asking all questions on that
> tech support mailing list, as it allows others to help answer questions
> and/or learn from the answers themselves)
>
> Any existing records unfortunately will need manually updating, as the
> "dc.identifier.uri" field will contain a value starting with
> "http://hdl.handle.net/"; <http://hdl.handle.net/>.  If you have a lot of
> these existing records, your easiest route towards doing these updates is
> to use the Batch Metadata Editing capabilities in DSpace:
>
> https://wiki.duraspace.org/display/DSDOC5x/Batch+Metadata+Editing
>
> The Batch Metdata Editing tools let you export metadata records to a CSV
> file, which can be opened using Microsoft Excel (or similar spreadsheet
> tools).  You can then find the column in that spreadsheet for
> "dc.identifier.uri", and  *update* all values starting with
> "http://hdl.handle.net/"; <http://hdl.handle.net/> so that they now begin
> with "[dspace.url]/handle/" (where [dspace.url] is your DSpace's URL).
> Make sure to retain the number-based identifiers at the end of those values
> (obviously).
>
> Once you've updated the spreadsheet values, just upload the spreadsheet to
> update DSpace itself.  Much more information on the process is in the
> documentation that I linked above.
>
> Good luck,
>
> Tim
>
> On 7/2/2015 8:45 AM, Shannon Meisenheimer wrote:
>
> Thanks Tim.  I did find that and changed it in the live dspace.cfg file.
> ... And did realize I was misunderstanding the handle subfolder in the URL
> path.
>
>  Is there an easy way to propagate the "new" URI to existing records?  Or
> would the rebuild/redeploy take care of that?
>
>  For now I've just commented the URI out in:
>
> dspace\webapps\xmlui\themes\Mirage2\xsl\aspect\artifactbrowser\item-view.xsl
>   Thanks,
> Shannon
> --
>      Mr. Shannon Meisenheimer
> Office of Technology
> Blackboard and Academic Application Management
> University of Central Missouri
> Dockery 207A
> meisenhei...@ucmo.edu
> Work Phone:  (660) 543-8483
>
>
> On Thu, Jul 2, 2015 at 8:40 AM, Tim Donohue <tdono...@duraspace.org>
> wrote:
>
>>  Hi Shannon,
>>
>> While DSpace shows URLs that include the word "handle" by default, the
>> actual handle server is actually not configured by default.
>>
>> It sounds like you may just be wanting the URI that is displayed on Item
>> pages to no longer start with <http://hdl.handle.net/>
>> "http://hdl.handle.net/"; <http://hdl.handle.net/>.  If that's the case
>> you can easily tweak that in your "build.properties".
>>
>>
>> It's the "handle.canonical.prefix" setting in that file:
>> https://github.com/DSpace/DSpace/blob/master/build.properties#L148
>>
>> If you want it to simply be the URL of your Dspace, you can change this
>> setting to be:
>>
>> handle.canonical.prefix = ${dspace.url}/handle/
>>
>> After changing that setting, you will need to rebuild & redeploy DSpace
>> (which will cause the setting to be propagated to your "live" dspace.cfg
>> file):
>>
>> cd [dspace-src]    (i.e. source directory)
>> mvn clean package
>> cd dspace/target/dspace-installer
>> ant update
>>
>> Finally, restart Tomcat.
>>
>> - Tim
>>
>> On 7/1/2015 8:16 AM, Shannon Meisenheimer wrote:
>>
>>  Is it possible to disable handle all together?  Our Library is just
>> wanting to have the DSpace internal URL displaying without the handle in
>> the Article link and change the URI displayed to the internal DSpace link.
>>
>>  Thanks,
>> Shannon
>> --
>>    Mr. Shannon Meisenheimer
>> Office of Technology
>> Blackboard and Academic Application Management
>> University of Central Missouri
>> Dockery 207A
>> meisenhei...@ucmo.edu
>> Work Phone:  (660) 543-8483 <%28660%29%20543-8483>
>>
>>
>>
>>  
>> ------------------------------------------------------------------------------
>> Don't Limit Your Business. Reach for the Cloud.
>> GigeNET's Cloud Solutions provide you with the tools and support that
>> you need to offload your IT needs and focus on growing your business.
>> Configured For All Businesses. Start Your Cloud 
>> Today.https://www.gigenetcloud.com/
>>
>>
>>
>> _______________________________________________
>> DSpace-tech mailing 
>> listDSpace-tech@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/dspace-tech
>> List Etiquette: 
>> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>>
>>
>>
>
>
------------------------------------------------------------------------------
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Reply via email to