May I suggest to use update-handle-prefix?
On Fri, Aug 28, 2009 at 11:16 AM, Lewatle
Phaladilewatle.phal...@wits.ac.za wrote:
Hi
As my [dspace]/dspace/bin/update-handle-prefix gives error, I also come with
an idea of modifying the handle table and change 123456789/ handle prefix
I tried on one collection it worked, but I need an SQL statement that will
update only 123456789 and leave other value, If you can check the values in
handle table and specifically handle column start with prefix and followed
by id like
123456789/7135
SQL statement that can alter our prefix (123456789) only in that column and
leaves the id (/7135)
I was using the statement :
Table name is handle
Column name is also handle
dspace= UPDATE handle SET handle = '85642/7178' WHERE handle =
'123456789/7178';
that worked for updating single item,
we need to update them simultaneously.
Regards
Lewatle
-Original Message-
From: Kim Shepherd [mailto:k...@waikato.ac.nz]
Sent: Thu 8/27/2009 10:22 PM
To: Lewatle Phaladi; dspace-tech@lists.sourceforge.net
Subject: RE: [Dspace-tech] handle-server setup
Hi Lewatle,
In your [dspace]/bin directory, there is a script called
update-handle-prefix
If, for example, your new handle is 858585:
[dspace]/bin/update-handle-prefix 123456789 858585
This will update the old handles with a default handle prefix without
bothering your new, correct items/collections/communities.
Cheers,
Kim
From: Lewatle Phaladi [mailto:lewatle.phal...@wits.ac.za]
Sent: Friday, 28 August 2009 1:42 a.m.
To: dspace-tech@lists.sourceforge.net
Subject: [Dspace-tech] handle-server setup
Hi All
I was setting up handle server for my University, and everything went well
in such a way that changes apply only for new submissions, if we submit or
import a file the file will take a new prefix not default like 123456789,
What we really need is to change the default handle prefix e.g 123456789 to
all our previous stored digital files and even to the new imported or
submited file.
Regards
Lewatle
This communication is intended for the addressee only. It is confidential.
If you have received this communication in error, please notify us
immediately and destroy the original message. You may not copy or
disseminate this communication without the permission of the University.
Only authorized signatories are competent to enter into agreements on behalf
of the University and recipients are thus advised that the content of this
message may not be legally binding on the University and may contain the
personal views and opinions of the author, which are not necessarily the
views and opinions of The University of the Witwatersrand, Johannesburg. All
agreements between the University and outsiders are subject to South African
Law unless the University agrees in writing to the contrary.
This communication is intended for the addressee only. It is confidential.
If you have received this communication in error, please notify us
immediately and destroy the original message. You may not copy or
disseminate this communication without the permission of the University.
Only authorized signatories are competent to enter into agreements on behalf
of the University and recipients are thus advised that the content of this
message may not be legally binding on the University and may contain the
personal views and opinions of the author, which are not necessarily the
views and opinions of The University of the Witwatersrand, Johannesburg. All
agreements between the University and outsiders are subject to South African
Law unless the University agrees in writing to the contrary.
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech